Data Import

Author Message

Rob Clews

Tuesday 04 November 2003 6:38:03 am

Hi,

I wish to import data from a previous database we have, however the data structure is not that obvious to do this quickly. What would be the best way to do this or is there a document showing the id mappings?

Cheers
Rob Clews

Willie Seabrook

Tuesday 11 November 2003 9:09:31 pm

I have imported data into ez from a legacy mysql database. It is a difficult thing to do:

1. Because the data model is complex and unintuitive but mostly because of
2. There is pretty much no documentation on the datamodel and how to pull accross your old data.

I suggest you look at the upgrade code provided with the ez distribution (i think) for pulling users and articles across from ez 2.2 and then modify it to simply pull data from your old database. I would not recommend *at all* modifying the database directly.

I will also point out that you need to go and get a debugger if your going to work with the ezpublish in this depth. Spending $500 or even $2000 on Zend will save you money in terms of labour by being able to see much faster how everything is set up in EZ.

eZ debug

Timing: Jan 18 2025 19:23:32
Script start
Timing: Jan 18 2025 19:23:32
Module start 'content'
Timing: Jan 18 2025 19:23:33
Module end 'content'
Timing: Jan 18 2025 19:23:33
Script end

Main resources:

Total runtime1.5204 sec
Peak memory usage4,096.0000 KB
Database Queries191

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0058 588.8203180.8438
Module start 'content' 0.00581.3551 769.6641464.1094
Module end 'content' 1.36090.1595 1,233.7734333.4844
Script end 1.5204  1,567.2578 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00400.2652210.0002
Check MTime0.00160.1067210.0001
Mysql Total
Database connection0.00080.049810.0008
Mysqli_queries1.449995.36111910.0076
Looping result0.00190.12431890.0000
Template Total1.492698.220.7463
Template load0.00220.144820.0011
Template processing1.490498.023820.7452
Template load and register function0.00020.012210.0002
states
state_id_array0.00070.043010.0007
state_identifier_array0.00140.093920.0007
Override
Cache load0.00180.1162130.0001
Sytem overhead
Fetch class attribute can translate value0.00160.102730.0005
Fetch class attribute name0.00120.077820.0006
XML
Image XML parsing0.00050.035630.0002
class_abstraction
Instantiating content class attribute0.00000.000420.0000
General
dbfile0.00670.4439210.0003
String conversion0.00000.000430.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
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
2content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
4content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 10
 Number of unique templates used: 5

Time used to render debug report: 0.0002 secs