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

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

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/