Help needed - I'm converting our company portals into ez p

Next topic

Author	Message
K259	Thursday 06 July 2006 10:50:47 am I've dumped all the categories and links to a textfile from our portals and need to dump this into the ez publish database (to the ez p website I've created). Is there any script available to achieve this? The syntax of my textfile dump is: insert into links (id, title, description, url, categoryid) values(x,'x','x','x',x) I want to create all the categories as folders manually in ez publish, then import/insert the "insert into..." into ez publish database where parent is category_id = x. Hope someone can help.
Björn Dieding@xrow.de	Thursday 06 July 2006 4:05:45 pm http://pubsvn.ez.no/community/trunk/extension/import/ http://pubsvn.ez.no/community/trunk/extension/import/example/ http://pubsvn.ez.no/community/trunk/extension/advancedforum/bin/phpbb2ez.php sorry no documention... but this is what we always use to import. It has been developpped over multple projects. If you need support plz write me. Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs Looking for hosting? http://hostingezpublish.com ----------------------------------------------------------------------------- GMT +01:00 Hannover, Germany Web: http://www.xrow.com/
K259	Friday 07 July 2006 12:31:30 am Tnx Björn, but shouldn't this be eccential in a CMS, at least an open source CMS, good documentation on how to import external data into ez p? Seems a litle bit annoying this..
Björn Dieding@xrow.de	Friday 07 July 2006 1:11:30 am yes definitly... I think eZ is aware of this. Though I think htere are no plans to intregrate this within the next time. Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs Looking for hosting? http://hostingezpublish.com ----------------------------------------------------------------------------- GMT +01:00 Hannover, Germany Web: http://www.xrow.com/
K259	Friday 07 July 2006 7:06:22 am I guess I just can change the sqldump and "insert into ezcontentobject" (to create an object), then get the ezcontentobject_id and insert it in ezcontentobject_attribute with this id as reference to ezcontentobject_id, and add the url and description as data_text?
Björn Dieding@xrow.de	Friday 07 July 2006 8:17:01 am Please discard this idea... What about nodes and eZXML and all this other stuff... you need to use the API Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs Looking for hosting? http://hostingezpublish.com ----------------------------------------------------------------------------- GMT +01:00 Hannover, Germany Web: http://www.xrow.com/

eZ debug

Timing:	Jan 20 2025 06:37:42
Script start
Timing:	Jan 20 2025 06:37:42
Module start 'layout'
Timing:	Jan 20 2025 06:37:42
Module start 'content'
Timing:	Jan 20 2025 06:37:43
Module end 'content'
Timing:	Jan 20 2025 06:37:43
Script end

Main resources:

Total runtime	0.6474 sec
Peak memory usage	4,096.0000 KB
Database Queries	66

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0049	589.4063	152.6563
Module start 'layout'	0.0049	0.0025	742.0625	39.4922
Module start 'content'	0.0074	0.6388	781.5547	564.2969
Module end 'content'	0.6462	0.0011	1,345.8516	16.1094
Script end	0.6473		1,361.9609

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	0.5014	16	0.0002
Check MTime	0.0014	0.2121	16	0.0001
Mysql Total
Database connection	0.0007	0.1064	1	0.0007
Mysqli_queries	0.5950	91.9078	66	0.0090
Looping result	0.0006	0.0860	64	0.0000
Template Total	0.6171	95.3	2	0.3085
Template load	0.0021	0.3289	2	0.0011
Template processing	0.6149	94.9920	2	0.3075
Template load and register function	0.0002	0.0256	1	0.0002
states
state_id_array	0.0009	0.1387	1	0.0009
state_identifier_array	0.0007	0.1114	2	0.0004
Override
Cache load	0.0018	0.2838	29	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0008	0.1278	2	0.0004
Fetch class attribute name	0.0014	0.2124	7	0.0002
XML
Image XML parsing	0.0005	0.0792	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0030	9	0.0000
General
dbfile	0.0014	0.2216	16	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
6	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
2	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
3	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.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: 6

Time used to render debug report: 0.0001 secs