Export MySQL tables into EZ publish classes.

Previous topic

Developer

Next topic

Author	Message
Simon Caisse	Monday 28 November 2005 5:25:25 pm Is it possible to export MySQL tables into EZ publish classes? I have MySQL tables with data that was not created by EZ that I would like to be displayed into EZ publish. I know how to create new classes in EZ but is there a way to populate these 'classes' with the data I already have on MySQL tables?
Łukasz Serwatka	Thursday 01 December 2005 12:29:45 am Hi Simon, It is possible to fetch from database and display result in templates. You have to write new fetch function, it is not so difficult and well documented example you can find here: http://ez.no/products/ez_publish_cms/documentation/development/extensions/module/module_tutorial_part_1 However if you want to present data using objects, read this topic, and it will give you some light how create objects pragmatically: http://ez.no/community/forum/install_configuration/how_to_create_ezcontentobject_programmatically You can also learn more from eZ publish book: http://ez.no/products/books/ez_publish_book Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Simon Caisse	Thursday 01 December 2005 5:45:45 pm That's exactly what I was looking for. Thank you very much for your help. Much appreciated

Author

Message

Simon Caisse

Monday 28 November 2005 5:25:25 pm

Is it possible to export MySQL tables into EZ publish classes?

I have MySQL tables with data that was not created by EZ that I would like to be displayed into EZ publish.

I know how to create new classes in EZ but is there a way to populate these 'classes' with the data I already have on MySQL tables?

Łukasz Serwatka

Thursday 01 December 2005 12:29:45 am

Hi Simon,

It is possible to fetch from database and display result in templates. You have to write new fetch function, it is not so difficult and well documented example you can find here:

http://ez.no/products/ez_publish_cms/documentation/development/extensions/module/module_tutorial_part_1

However if you want to present data using objects, read this topic, and it will give you some light how create objects pragmatically:

http://ez.no/community/forum/install_configuration/how_to_create_ezcontentobject_programmatically

You can also learn more from eZ publish book:
http://ez.no/products/books/ez_publish_book

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Simon Caisse

Thursday 01 December 2005 5:45:45 pm

That's exactly what I was looking for. Thank you very much for your help. Much appreciated