ez publish database

ez publish database

Friday 20 May 2011 1:56:42 am - 12 replies

Author Message

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

You must be logged in to post messages in this topic!

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.