Importing data as object from another database

Next topic

Author	Message
Shurbann Martes	Wednesday 19 November 2003 6:32:17 am Hello there, I'm looking for an answer (way to start) to this problem: I have a database with information that comes from another application I made. This application stores these information in another DB (so not the same DB as eZ is using). Now I want to store some of these data into eZ as object. I looked around and found this in the forum: http://www.ez.no/developer/ez_publish_3/forum/developer/creating_a_simple_content_object_via_php That's exactly what I'm looking for, need a little bit of tweaking, but ok. Still I dont know how and where to put this little script (if I may call it so) . Should I put it like in the cronjobs directory where it will be running using cron or somewhere else?. I would appreciate it if someone can shed some light on this. TIA, Shurbann
Claus Jensen	Wednesday 19 November 2003 7:08:52 am Hi Shurbann, I've done some importing of objects this way, as you may have seen on the thread you refer to. You should put this script in the root folder ezpublish, and there it may fetch ini-files from your installation. Ofcourse it may also be run from a cron-script is that is what you prefer, but for me it was a "one-time-job". Also, this was a flat-file import, exported into commaseparated or semicolon from the other database. Anyway, it is timing out after about 249-250 objects, why I dont know, but now you are aware. The solution for us was to "chop" our flat-file into several flatfiles containing only a "safe" number of records ..say 230-240 or so. Hope you get some idea from this. Good luck! regards, claÜs
Shurbann Martes	Thursday 20 November 2003 4:23:55 am Thank you Claus, I think you gave me enough ideas/tips to start this project. Once in the while there would be a new entry in this DB. So it's not a "one-time-job". There are not alot of entries, so I wont be having the problem of timing-out I hope. Next challenge is how to keep track of what have already been imported. (But I wont bother you guys with that :) ) Shurbann

Author

Message

Wednesday 19 November 2003 6:32:17 am

Hello there,

I'm looking for an answer (way to start) to this problem:
I have a database with information that comes from another application I made. This application stores these information in another DB (so not the same DB as eZ is using).

Now I want to store some of these data into eZ as object. I looked around and found this in the forum:

http://www.ez.no/developer/ez_publish_3/forum/developer/creating_a_simple_content_object_via_php

That's exactly what I'm looking for, need a little bit of tweaking, but ok. Still I dont know how and where to put this little script (if I may call it so) .

Should I put it like in the cronjobs directory where it will be running using cron or somewhere else?. I would appreciate it if someone can shed some light on this.

TIA,
Shurbann

Claus Jensen

Wednesday 19 November 2003 7:08:52 am

Hi Shurbann,
I've done some importing of objects this way, as you may have seen on the thread you refer to. You should put this script in the root folder ezpublish, and there it may fetch ini-files from your installation. Ofcourse it may also be run from a cron-script is that is what you prefer, but for me it was a "one-time-job". Also, this was a flat-file import, exported into commaseparated or semicolon from the other database. Anyway, it is timing out after about 249-250 objects, why I dont know, but now you are aware. The solution for us was to "chop" our flat-file into several flatfiles containing only a "safe" number of records ..say 230-240 or so.

Hope you get some idea from this. Good luck!

regards,
claÜs

Shurbann Martes

Thursday 20 November 2003 4:23:55 am

Thank you Claus, I think you gave me enough ideas/tips to start this project.

Once in the while there would be a new entry in this DB. So it's not a "one-time-job". There are not alot of entries, so I wont be having the problem of timing-out I hope.

Next challenge is how to keep track of what have already been imported. (But I wont bother you guys with that :) )

Shurbann

eZ debug

Timing:	Jan 19 2025 03:18:08
Script start
Timing:	Jan 19 2025 03:18:08
Module start 'layout'
Timing:	Jan 19 2025 03:18:08
Module start 'content'
Timing:	Jan 19 2025 03:18:10
Module end 'content'
Timing:	Jan 19 2025 03:18:10
Script end

Main resources:

Total runtime	1.6306 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0075	589.2891	152.6406
Module start 'layout'	0.0075	0.0044	741.9297	39.4766
Module start 'content'	0.0120	1.6173	781.4063	473.2109
Module end 'content'	1.6293	0.0013	1,254.6172	12.4375
Script end	1.6306		1,267.0547

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.2112	16	0.0002
Check MTime	0.0013	0.0817	16	0.0001
Mysql Total
Database connection	0.0009	0.0579	1	0.0009
Mysqli_queries	1.5848	97.1883	57	0.0278
Looping result	0.0006	0.0355	55	0.0000
Template Total	1.5909	97.6	2	0.7955
Template load	0.0018	0.1111	2	0.0009
Template processing	1.5891	97.4530	2	0.7946
Template load and register function	0.0002	0.0106	1	0.0002
states
state_id_array	0.0009	0.0579	1	0.0009
state_identifier_array	0.0018	0.1081	2	0.0009
Override
Cache load	0.0015	0.0907	24	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0009	0.0562	2	0.0005
Fetch class attribute name	0.0012	0.0748	3	0.0004
XML
Image XML parsing	0.0002	0.0153	2	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0004	3	0.0000
General
dbfile	0.0007	0.0402	10	0.0001
String conversion	0.0000	0.0009	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
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
7	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
5	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 17 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs