Forums / Developer / How to upload a database to the structure of my site
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