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

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 Exponential 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 Exponential, then import/insert the "insert into..." into Exponential database where parent is category_id = x.

Hope someone can help.

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..

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?