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

How to upload a database to the structure of my site

« 
Previous topic
|
Developer
|
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

eZ debug

Timing: Jan 30 2025 21:29:16
Script start
Timing: Jan 30 2025 21:29:16
Module start 'content'
Timing: Jan 30 2025 21:29:16
Module end 'content'
Timing: Jan 30 2025 21:29:16
Script end

Main resources:

Total runtime0.3886 sec
Peak memory usage8,192.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0129 588.0781370.2734
Module start 'content' 0.01290.0196 958.35161,001.5000
Module end 'content' 0.03240.3561 1,959.85163,889.7891
Script end 0.3885  5,849.6406 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00511.3135200.0003
Check MTime0.00150.3812200.0001
Mysql Total
Database connection0.00070.183010.0007
Mysqli_queries0.277071.27751410.0020
Looping result0.00180.45451390.0000
Template Total0.355591.510.3555
Template load0.00080.213310.0008
Template processing0.354791.265510.3547
Override
Cache load0.00050.141510.0005
Sytem overhead
Fetch class attribute can translate value0.00210.539110.0021
XML
Image XML parsing0.00030.067910.0003
General
dbfile0.00992.5527200.0005
String conversion0.00000.003430.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs