Hi Simone,

eZ Publish is a CMS with features such as translation features, advanced WYSIWYG editor, etc. That
 a tool to build complex relational databases, if you use CMS features / content classes / object relation attribute, etc. for such a purpose, then you will face performance issues when your database will get bigger and if you have a lot of visitor. As far as I'm concerned I've seen this mistake too many time while auditing critical projects...

Be careful, I'm not saying that you should not use eZ Publish for this kind of content (Person, Department, etc...) but you should consider developing custom content attributes (datatypes) to manage content relations (1-n / n-m / with meta informations such as your TBL_PERS_POS table) etc...

These datatypes will have to be based on what we call an eZPersistentObject (basically, this is a DAO) which will help you abstracting your data from simple MySQL tables (or anything else) and give you the opportunity to use it within your eZ Publish developments (extensions and custom modules/workflow, content classes via a datatype, etc...)

I have to go, try to find some tutorials on eZPersistentObject developments & Datatypes. If you do not find anything, I'll get back to you.

Cheers.

Hi Arnaud, your answer is exactly what I was afraid of!

I'm not such a good ez-programmer so I'm bit scared of making my own datatypes (although they were the first solution in my mind)!

I'm going to look for some good hint on line, I hope to find my solution.

Thank you very much

Hi Arnaud, your answer is exactly what I was afraid of!

I'm not such a good ez-programmer so I'm bit scared of making my own datatypes (although they were the first solution in my mind)!

I'm going to look for some good hint on line, I hope to find my solution.

 

Thank you very much

Don't be afraid. That is not really a difficult task and I'm pretty sure that you'll get some help from the community. Basically, you will just have to implement some required methods in your PHP classes. I can still remember the day I've discovered Persistent Object in eZ Publish : Waouh !
Believe me it's worth it !

Good start for eZ Persistent Object : http://share.ez.no/learn/ez-publish/a-quick-and-friendly-introduction-to-ezpersistentobject

Good start for Datatypes : http://share.ez.no/learn/ez-publish/creating-datatypes-in-ez-publish-4

You can also read the excellent article from Jérome, written for PHP Solutions Mag. last year : http://www.lolart.net/blog/ez-publish/dossier-ez-publish-dans-le-dernier-php-solutions

Last but not least, if you are willing to use eZ Find for your search feature, developing your own datatype will help you in indexing data the way you want...

 

Good start for eZ Persistent Object : http://share.ez.no/learn/ez-publish/a-quick-and-friendly-introduction-to-ezpersistentobject

Good start for Datatypes : http://share.ez.no/learn/ez-publish/creating-datatypes-in-ez-publish-4

You can also read the excellent article from Jérome, written for PHP Solutions Mag. last year : http://www.lolart.net/blog/ez-publish/dossier-ez-publish-dans-le-dernier-php-solutions

Last but not least, if you are willing to use eZ Find for your search feature, developing your own datatype will help you in indexing data the way you want...

Hi Arnaud... I guess that nobody loves me!!

I took a look to the links you suggested me and that's what I discovered:

• eZ Persistent objects: quite easy and good tutorial! But it's not enough for me to go on with my work (it helps!)
• Datatypes: good tutorial, but completely useles without the source code... People are looking for that since 2008, so I have no hope to find it
• The article of Jérome is no more available on that site

Any other suggestion will be really appreciated!

Hi Simone, 

regarding datatypes, I'm pretty sure that there's something somewhere... please get in touch with Jérome so that he might send you the tutorial.

You can also have a look at the RAD in the Setup tab of your admin interface. It will give you the PHP class prototype with the mandatory methods. Furthermore, you should have a look at the built-in datatype such eZText (kernel/classes/datatypes/eztext/eztexttype.php) or eZDate (kernel/classes/datatypes/ezdate/ezdatetype.php). These ones are pretty simple to understand.

Cheers

regarding datatypes, I'm pretty sure that there's something somewhere... please get in touch with Jérome so that he might send you the tutorial.

Hi Simone, 

Arnaud is right. You can get in touch with Jérôme directly here : http://share.ez.no/authorcontact/form/11256

Cheers !

Hello Folks,

I just wanted to share that just a few hours ago we (BC) sent contact requests / emails which give all required detail regarding this issue to Jérôme and another contact at ymc.ch in the interest of trying to help resolve this problem with the missing article source code.

Worth mentioning we have received up to 3 recent reports that we remember of this problem in the recent past. Also we also long ago tried contacting the author using the authorcontent solution but never received any response. 

We hope this helps ... 

We will post updates here in this thread again if we receive any positive responses to our request attempts.

Cheers,

Heath

Hi there !

I have received your requests .

I'm currently in the process of translating my article from french to english so that it can be published here. It is quite extensive so it can take a while, sorry.

Anyway, if you can read french, I can post it somewhere

Hello Jérôme,

If you can just go ahead and "post it somewhere" if you would please

as French is not normally a language bariaer in an era where Google Translate does the heavy lifting for us English reader's brains

No worries, just a suggestion. I'll trust that this article makes it to publication on share.ez.no and puts an 'End-Game' ending to the problems encountered within this thread (and many many others btw).

I hope this helps ...

Cheers,

Heath

And here it is : http://bit.ly/ezdatatype

And here it is : http://bit.ly/ezdatatype

Well done, nice temporary solution !