Author Topic: csv import  (Read 4278 times)

dsrpmedia

  • Jr. Member
  • **
  • Posts: 332
csv import
« on: November 15, 2011, 23:59:15 pm »
Hi

I have a new site with several thousand products. I was assuming that I could use csvi to do my import, but apparently (according to their website) they have no plans of publishing a vm2 compatible version.

Is there any way to do a csv import into vm2, or is this version basically dead?

craig_wild

  • Beginner
  • *
  • Posts: 2
Re: csv import
« Reply #1 on: November 16, 2011, 05:31:49 am »
The article below seems to suggest it will be supported. It is certainly very useful in 1.1.x

Quote
Support for VirtueMart 2 will be added to CSVI once the VirtueMart team has released a stable version to the general public. With the new CSVI 4 release it will be possible to support both VirtueMart 1.1.x and VirtueMart 2, this should be good news for everybody :)
http://www.csvimproved.com/index.php?option=com_content&view=article&id=759:looking-forward&catid=1:news

dsrpmedia

  • Jr. Member
  • **
  • Posts: 332
Re: csv import
« Reply #2 on: November 16, 2011, 05:46:30 am »
unfortunately right above that it says "Support for Joomla 1.6/1.7 will not be added to CSVI 4.0. The plan is to adapt CSVI for Joomla 1.8 when this is released."

so I guess as far as joomla 1.7 goes having csv import capability will be a no-go

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10318
  • VirtueMart Version: 3+
Re: csv import
« Reply #3 on: November 16, 2011, 12:28:10 pm »
I used phpmyadmin to import some product attributes in open office format  the other day with 2.0. It was pretty easy.

J3.9+ VM 3.4.2
Slowest Page Speed Score (88) (Category)
Fastest Page Speed Score (94-96) (productdetails)

I do NOT do development work for hire.

dsrpmedia

  • Jr. Member
  • **
  • Posts: 332
Re: csv import
« Reply #4 on: November 16, 2011, 17:39:01 pm »
that makes sense, if you are good at writing sql queries - but an sql query to import 1k products with descriptions, images etc would be pretty complicated to write would it not?

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10318
  • VirtueMart Version: 3+
Re: csv import
« Reply #5 on: November 16, 2011, 17:41:32 pm »
open office format

^^ spreadsheet is what I did
J3.9+ VM 3.4.2
Slowest Page Speed Score (88) (Category)
Fastest Page Speed Score (94-96) (productdetails)

I do NOT do development work for hire.

dsrpmedia

  • Jr. Member
  • **
  • Posts: 332
Re: csv import
« Reply #6 on: November 16, 2011, 17:48:11 pm »
that is what I use to create the csv files that I import through csvi in joomla 1.5 / vm 1.1 - do you mean I can use phpmyadmin to import a csv file without having to write a query for it?

do the column headings stay the same as they would for a csvi import?

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10318
  • VirtueMart Version: 3+
Re: csv import
« Reply #7 on: November 16, 2011, 18:02:09 pm »
create a product.

THEN, export the product table. Open office spreadsheet format. (column header included)

THEN, paste the new products into the columns of the files you exported.

 
J3.9+ VM 3.4.2
Slowest Page Speed Score (88) (Category)
Fastest Page Speed Score (94-96) (productdetails)

I do NOT do development work for hire.

dsrpmedia

  • Jr. Member
  • **
  • Posts: 332
Re: csv import
« Reply #8 on: November 16, 2011, 19:02:29 pm »
awesome, I will give it a try

RFreund

  • Beginner
  • *
  • Posts: 44
Re: csv import
« Reply #9 on: November 16, 2011, 20:58:53 pm »
How did you export the product? CSVI?

Thanks.

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10318
  • VirtueMart Version: 3+
Re: csv import
« Reply #10 on: November 16, 2011, 21:10:17 pm »
attached

[attachment cleanup by admin]
J3.9+ VM 3.4.2
Slowest Page Speed Score (88) (Category)
Fastest Page Speed Score (94-96) (productdetails)

I do NOT do development work for hire.

dominiosclave

  • Beginner
  • *
  • Posts: 12
Re: csv import
« Reply #11 on: December 31, 2011, 19:36:11 pm »
any other method or tool for more good import/export data?

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27277
  • Always on vacation
    • Jenkin Hill Internet
Re: csv import
« Reply #12 on: December 31, 2011, 21:29:59 pm »
There will be soon. CSVI 4  http://www.csvimproved.com/
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM 3.4.3.10026 on Joomla 3.9.4 PHP 7.0.33
Testing VM 3.4.3.10026 on Joomla 3.9.4