Importing Data Directly Into Database

[kory27]

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.

[franzpeter]

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).

[kory27]

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

[rightminddesigns]

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