Forums / General / STEP by step guide to import a database into ez publish ?

STEP by step guide to import a database into ez publish ?

Next topic

Author	Message
francis Nart	Tuesday 16 March 2004 3:42:30 am Hi, Has anybody already imported an existing database in ezpublish? We've just done that and we had real problems. Firs tof all, the database structure available in the docs is not up to date. Plus, we had to find what data was inserted in what table. But the main problem seems to be the indexation. Apparently, the dat we inserted is not searched by the internal search engine because we did not use the ez publish interface of course but a script we wrote for the occasion. Does anaybody have successfully imported a complete (and wuite complex) database ? Thansk for your help ! Francis.
Tore Skobba	Tuesday 16 March 2004 4:28:08 am Hi I have tried myself by using automatically post to my EZ site. That is an script which fetches data from the source database and makes post requsts to the EZ site to import into. However, I did not get EZ to accept the data fully (objects were created without any data at all). I did this because I belive that it would be the best way as it would most likely if succsesfull mean that EZ got the data the way it wanted it. Cheers Tore
francis Nart	Tuesday 16 March 2004 5:03:45 am all right. But do you know where we could find an up to date database structure + a guide to the different tables and their function. Francis.
K259	Wednesday 17 March 2004 3:56:24 am I've asked the eZ crew about this in another topic :) Hope they have this information available. Would be a great help! http://www.ez.no/content/view/full/47035
maurizio boscaini	Saturday 22 May 2004 6:35:14 am can you send me your procedure? I want to try to do the same thing thanks mauri m.boscaini@tin.it
Tore Skobba	Monday 24 May 2004 6:01:51 am Hi I have sent you my procedure. If anyone else want it then send me an email (tore@grunderskolen.no). But it is NOT working and there is no docs. But it could make a nice start for anyone trying to do the same. Cheers Tore

eZ debug

Timing:

Jan 31 2025 03:44:55

Script start

Timing:

Jan 31 2025 03:44:55

Module start 'content'

Timing:

Jan 31 2025 03:44:55

Module end 'content'

Timing:

Jan 31 2025 03:44:55

Script end

Main resources:

Total runtime

0.2967 sec

Peak memory usage

8,192.0000 KB

Database Queries

141

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0087	588.0703	370.2813
Module start 'content'	0.0087	0.0128	958.3516	1,005.4688
Module end 'content'	0.0214	0.2752	1,963.8203	3,894.5859
Script end	0.2967		5,858.4063

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0087

588.0703

370.2813

Module start 'content'

0.0087

0.0128

958.3516

1,005.4688

Module end 'content'

0.0214

0.2752

1,963.8203

3,894.5859

Script end

0.2967

5,858.4063

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0049	1.6436	20	0.0002
Check MTime	0.0014	0.4692	20	0.0001
Mysql Total
Database connection	0.0006	0.2086	1	0.0006
Mysqli_queries	0.2044	68.8837	141	0.0014
Looping result	0.0014	0.4579	139	0.0000
Template Total	0.2748	92.6	1	0.2748
Template load	0.0009	0.3097	1	0.0009
Template processing	0.2739	92.3046	1	0.2739
Override
Cache load	0.0006	0.2190	1	0.0006
Sytem overhead
Fetch class attribute can translate value	0.0018	0.6181	1	0.0018
XML
Image XML parsing	0.0003	0.0880	1	0.0003
General
dbfile	0.0060	2.0249	20	0.0003
String conversion	0.0000	0.0016	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0049

1.6436

0.0002

Check MTime

0.0014

0.4692

0.0001

Mysql Total

Database connection

0.0006

0.2086

0.0006

Mysqli_queries

0.2044

68.8837

141

0.0014

Looping result

0.0014

0.4579

139

0.0000

Template Total

0.2748

92.6

0.2748

Template load

0.0009

0.3097

0.0009

Template processing

0.2739

92.3046

0.2739

Override

Cache load

0.0006

0.2190

0.0006

Sytem overhead

Fetch class attribute can translate value

0.0018

0.6181

0.0018

XML

Image XML parsing

0.0003

0.0880

0.0003

General

dbfile

0.0060

2.0249

0.0003

String conversion

0.0000

0.0016

0.0000

Note: percentages do not add up to 100% because some accumulators overlap

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

Cache	Type	Packlevel	SourceFiles
	CSS	0	extension/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
	JS	0	extension/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

Cache

Type

Packlevel

SourceFiles

CSS

extension/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

extension/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:

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

Usage

Requested template

Template

Template loaded

Edit

Override

pagelayout.tpl

<No override>

extension/sevenx/design/simple/templates/pagelayout.tpl

Number of times templates used: 1
Number of unique templates used: 1

Time used to render debug report: 0.0001 secs