VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: kory27 on April 15, 2012, 02:07:25 AM

Title: Importing Data Directly Into Database
Post by: kory27 on April 15, 2012, 02:07:25 AM
Hello,

I have a question.

I have a large amount of categories and products in flat csv files.

I would like to import them directly into the database tables.

Are there known issues with this?  Do I need to import them in certain order?

I am concerned that there are backend operations VM does when creating, for instance, a category in the admin area.

Any insight is appreciated.

Thanks.
Title: Re: Importing Data Directly Into Database
Post by: franzpeter on April 16, 2012, 10:43:31 AM
It should work. You have to pay attention on the slugs. There should not be any double entries. Else it will not work (slugs need to be there by default for categories, manufacturers, products a.s.o. in the language files).
Title: Re: Importing Data Directly Into Database
Post by: kory27 on April 19, 2012, 00:09:01 AM
Hello,

I did it with 0 errors on both the jml_virtuemart_categories and jml_virtuemart_categories_en_gb tables, but they aren't showing in the VM Admin, but show in the db.

They show a "1" for published, and appear to look just like the sample date, which I left in for reference.

Any ideas?

Thanks in advance. 

Kory
Title: Re: Importing Data Directly Into Database
Post by: rightminddesigns on April 23, 2012, 01:20:24 AM
Quote from: kory27 on April 15, 2012, 02:07:25 AM
Hello,

I have a question.

I have a large amount of categories and products in flat csv files.

I would like to import them directly into the database tables.

Are there known issues with this?  Do I need to import them in certain order?

I am concerned that there are backend operations VM does when creating, for instance, a category in the admin area.

Any insight is appreciated.

Thanks.

Try this extension: http://extensions.joomla.org/extensions/migration-a-conversion/data-import-a-export/19745