VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product creation => Topic started by: dsrpmedia on November 15, 2011, 23:59:15 PM

Title: csv import
Post by: dsrpmedia 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?
Title: Re: csv import
Post by: craig_wild 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

QuoteSupport 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
Title: Re: csv import
Post by: dsrpmedia 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
Title: Re: csv import
Post by: PRO 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.

Title: Re: csv import
Post by: dsrpmedia 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?
Title: Re: csv import
Post by: PRO on November 16, 2011, 17:41:32 PM
Quote from: BanquetTables.pro on November 16, 2011, 12:28:10 PM
open office format

^^ spreadsheet is what I did
Title: Re: csv import
Post by: dsrpmedia 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?
Title: Re: csv import
Post by: PRO 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.

Title: Re: csv import
Post by: dsrpmedia on November 16, 2011, 19:02:29 PM
awesome, I will give it a try
Title: Re: csv import
Post by: RFreund on November 16, 2011, 20:58:53 PM
How did you export the product? CSVI?

Thanks.
Title: Re: csv import
Post by: PRO on November 16, 2011, 21:10:17 PM
attached

[attachment cleanup by admin]
Title: Re: csv import
Post by: dominiosclave on December 31, 2011, 19:36:11 PM
any other method or tool for more good import/export data?
Title: Re: csv import
Post by: jenkinhill on December 31, 2011, 21:29:59 PM
There will be soon. CSVI 4  http://www.csvimproved.com/