How to upload a database to the structure of my site

Next topic

Author	Message
Jorge estévez	Wednesday 21 November 2007 12:18:21 pm Hello, I have this huge database that I manage to save it as an excel table, each column is an attribute of the class product, no images, only text attributes and checkmarks. How can I upload the table, and manage each column to be added to each attribute for the language XXX? I will need to do the same later for another language! Thanks, jorge Diseño Web Cuba Web Design Cuba www.elfosdesign.com
Lazaro Ferreira	Thursday 22 November 2007 3:44:12 am Hi Jorge, If you format your Excel file to be accepted by ezcsvimport.php ( Ezpublish CSV import script ), you can import your database from command line Regarding the language you can tell the the script in which siteaccess you want to create the objects For instance php bin/php/ezcsvimport.php --siteaccess eng --class=your_class your_parent_node your_csv_file Hint: Run a ezcsvexport.php for the class that you want to import, just to see how it formats the CSV file, then format your Excel file accordingly, and run the ezcsvimport.php script Regards! Lazaro http://www.mzbusiness.com

Author

Message

Wednesday 21 November 2007 12:18:21 pm

Hello,

I have this huge database that I manage to save it as an excel table, each column is an attribute of the class product, no images, only text attributes and checkmarks.

How can I upload the table, and manage each column to be added to each attribute for the language XXX?

I will need to do the same later for another language!

Thanks, jorge

Diseño Web Cuba
Web Design Cuba
www.elfosdesign.com

Lazaro Ferreira

Thursday 22 November 2007 3:44:12 am

Hi Jorge,

If you format your Excel file to be accepted by

ezcsvimport.php

( Ezpublish CSV import script ), you can import your database from command line

Regarding the language you can tell the the script in which siteaccess you want to create the objects

For instance

php bin/php/ezcsvimport.php --siteaccess eng --class=your_class your_parent_node your_csv_file

Hint: Run a ezcsvexport.php for the class that you want to import, just to see how it formats the CSV file, then format your Excel file accordingly, and run the ezcsvimport.php script

Regards!

Lazaro
http://www.mzbusiness.com