Forums / Developer / How to upload a database to the structure of my site

How to upload a database to the structure of my site

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