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

eZ debug

Timing:	Jan 31 2025 00:36:29
Script start
Timing:	Jan 31 2025 00:36:29
Module start 'layout'
Timing:	Jan 31 2025 00:36:29
Module start 'content'
Timing:	Jan 31 2025 00:36:29
Module end 'content'
Timing:	Jan 31 2025 00:36:29
Script end

Main resources:

Total runtime	0.0229 sec
Peak memory usage	6,144.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0050	588.2813	151.2266
Module start 'layout'	0.0051	0.0041	739.5078	220.7188
Module start 'content'	0.0091	0.0122	960.2266	997.7578
Module end 'content'	0.0213	0.0015	1,957.9844	29.9922
Script end	0.0228		1,987.9766

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0025	10.7764	14	0.0002
Check MTime	0.0010	4.5449	14	0.0001
Mysql Total
Database connection	0.0006	2.5758	1	0.0006
Mysqli_queries	0.0023	10.1395	3	0.0008
Looping result	0.0000	0.0709	1	0.0000
Template Total	0.0010	4.6	1	0.0010
Template load	0.0008	3.6067	1	0.0008
Template processing	0.0002	0.9309	1	0.0002
Override
Cache load	0.0005	2.2380	1	0.0005
General
dbfile	0.0009	3.8736	8	0.0001
String conversion	0.0000	0.0407	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs