|
Author
|
Message
|
|
Emmanuelle Vietti
|
Friday 20 May 2011 1:56:42 am
hi everyonecan someone help me to understand the structure of the ez publish database please ?I must import some data from another database : rubrics, articles and external files (pdf media files...) and Im not sure to understand how to.For each element, I may have to create a record in the table ezcontentobject, define the class of the object in the ezcontentclass table and the node of the object in the eznode_assignment table ? Im not sure to understand : each object refers to one or several nodes, does this mean the position in the arborescence ?thank You.
|
|
Ivo Lukac
|
Friday 20 May 2011 2:26:51 am
Hi, It is not a good idea to insert data directly in the eZ database. Use tools like this http://projects.ez.no/sqliimport to import data, they are taking care of all the complicated things required to make ez objects and nodes...
http://www.linkedin.com/in/ivolukac
http://www.netgen.hr/eng/blog
http://twitter.com/ilukac
|
|
Jérôme Vieilledent
|
Friday 20 May 2011 2:48:56 am
Hi Emmanuelle and Bienvenue ! Ivo is right, it's never a good idea to directly manipulate eZ Publish database. To keep consistent, you must use eZ Publish API which is (for the moment) quite tough and complex. SQLIImport is a good choice to do stuffs like you want as it has been designed for it. Moreover, it has a simplified API that allows you to easily manipulate content objects in PHP. Check out the extension documentation A bientôt !
|
|
Christian Pfeffer Gjengedal
|
Friday 20 May 2011 3:06:42 am
Regardless of the reason and approach, the DB schema is documented: http://doc.ez.no/eZ-Publish/Technical-manual/4.x/Reference/Database-schema
|
|
Emmanuelle Vietti
|
Friday 20 May 2011 3:35:24 am
thanks a lot ;) but now, Im trying to use the function createAndPublishObject from the api ezcontentfunctions.php bonne journée !
|
|
Marko Žmak
|
Friday 20 May 2011 6:44:35 am
Take a look at this tutorial:
- http://share.ez.no/learn/ez-publish/creating-ez-publish-objects-in-php
It explains how to create objects in eZP, and also has an example of using createAndPublishObject() function.
--
Nothing is impossible. Not if you can imagine it!
Hubert Farnsworth
|
|
Veronique Jamilloux
|
Sunday 22 May 2011 9:39:00 am
Hi, Is it with the sqliimport extension that I can delete the attribute content for all the objects of one class? How can remove an attribute from a class when I've lot of objects from this class? This attribute is an enum and I don't use it in template. I add a selection attribute, better for the fetch function. Thank you Véronique
URGI - INRA
Webmaster
Route de Saint Cyr
78000 Versailles
|
|
Jérôme Vieilledent
|
Monday 23 May 2011 1:21:37 am
Hi Véronique You can actually do that in the administration interface, but if you have a lot of objects from this class, you'd better use eZScriptMonitor extension, which defers to CRON such action (supported in eZ Publish since version 4.3, before you'll need to patch the kernel with provided patch in the extension).
|
|
Emmanuelle Vietti
|
Monday 23 May 2011 4:02:45 am
"
Take a look at this tutorial:
- http://share.ez.no/learn/ez-publish/creating-ez-publish-objects-in-php
It explains how to create objects in eZP, and also has an example of using createAndPublishObject() function.
"
this tutorial is really helpfull, thank you Marko (edit ok)
|
|
Veronique Jamilloux
|
Monday 23 May 2011 5:17:48 am
Hi, Thank you Jérôme for your suggestion about eZScriptMonitor extension. And the tutorial http://share.ez.no/learn/ez-publish/creating-ez-publish-objects-in-php is very interesting too, thank you Marko
URGI - INRA
Webmaster
Route de Saint Cyr
78000 Versailles
|
|
Emmanuelle Vietti
|
Tuesday 24 May 2011 2:50:16 am
hello, sorry to bother one more time but is there a way to delete my pending list please ?
|
|
Jérôme Vieilledent
|
Tuesday 24 May 2011 5:32:20 am
Do you mean the SQLIImport pending imports list ? If so, they are stored in ezpending_actions table, so feel free to delete them here ;)
|
|
Emmanuelle Vietti
|
Tuesday 24 May 2011 6:25:39 am
Jerome : Ive just sent you an email written in French ^^
|