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 04:28:14
Script start
Timing:	Jan 31 2025 04:28:14
Module start 'layout'
Timing:	Jan 31 2025 04:28:14
Module start 'content'
Timing:	Jan 31 2025 04:28:16
Module end 'content'
Timing:	Jan 31 2025 04:28:16
Script end

Main resources:

Total runtime	1.1572 sec
Peak memory usage	4,096.0000 KB
Database Queries	70

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0055	588.3516	151.2266
Module start 'layout'	0.0055	0.0025	739.5781	36.6797
Module start 'content'	0.0080	1.1482	776.2578	992.5156
Module end 'content'	1.1563	0.0009	1,768.7734	11.7969
Script end	1.1572		1,780.5703

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	0.2806	16	0.0002
Check MTime	0.0013	0.1125	16	0.0001
Mysql Total
Database connection	0.0008	0.0714	1	0.0008
Mysqli_queries	1.0970	94.7977	70	0.0157
Looping result	0.0007	0.0645	68	0.0000
Template Total	1.1230	97.0	2	0.5615
Template load	0.0020	0.1716	2	0.0010
Template processing	1.1210	96.8739	2	0.5605
Template load and register function	0.0016	0.1400	1	0.0016
states
state_id_array	0.0018	0.1534	1	0.0018
state_identifier_array	0.0013	0.1155	2	0.0007
Override
Cache load	0.0017	0.1459	36	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0620	4	0.0002
Fetch class attribute name	0.0028	0.2379	6	0.0005
XML
Image XML parsing	0.0005	0.0403	4	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0015	6	0.0000
General
dbfile	0.0007	0.0636	10	0.0001
String conversion	0.0000	0.0006	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
6	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
8	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 20 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs