Understanding how ez Publish does galleries

Next topic

Author	Message
Werner Strydom	Saturday 09 April 2005 9:50:06 am I've created a ez Publish website [http://www.bloudraak.com/] with a gallery [http://www.bloudraak.com/index.php/photography]. I am also using an application called IMatch [http://www.photools.com/] to manage my photos, of which some, may go into my gallery. So I'm trying to understand how the gallery module works, so I can integrate the two applications and get the desired effect. If you don't mind, please point me to information which can help. I know C#, C++, Java and Visual Basic. I'm looking at writing an IMatch script that 1) Transform the image for the web by scaling it, adding a border, copyright notice and creating a thumbnail. 2) Create a gallery if it doesn't exist 3) Update images if it was added before, or add it My goal is to manipulate the database directly using MySQL/ODBC. What tables do I need to reference; what do I need to be carefull of? 1) Find if a gallery with an id exists? 2) Add a gallery and determine its id 3) Find an image in a gallery 4) Update the image in the gallery 5) Add an image to the gallery; settings its thumbnail and large image 6) Remove the image from the gallery 7) Where do I FTP the thumbnail and large image? If I can use SOAP or XMLRPC, instead of ODBC, then so much better. I have approx 1200 photos, which have full IPTC information, a description and name. So the batch upload doesn't work for me as that information will not be displayed on the website. May I suggest that "ez Publish" documents all the webservices it offers, just like Microsoft SharePoint does it. It will ease integration from other platforms.
Ekkehard Dörre	Saturday 09 April 2005 3:28:55 pm <i>1) Transform the image for the web by scaling it, adding a border, copyright notice and creating a thumbnail. </i> possible with ez you can look in image.ini IPTC: Exif export is possible in ez You can use all pear packages via http://ez.no/community/contribs/3rd_party/extension_ezpowerlib_pubsvn http://pear.php.net/package/Image_IPTC/ or more directly via image.ini and http://imagemagick.org/script/formats.php#embedded Upload via webdav with automatic exif extraction. http://ez.no/ez_publish/documentation/configuration/configuration/webdav_setup SOAP is possible, too, search: http://ez.no/content/search?SearchText=SOAP ez can handle 6000 images without problems, 100.000 should be possible, too. Greetings, ekke http://www.coolscreen.de - Over 40 years of certified eZ Publish know-how: http://www.cjw-network.com CJW Newsletter: http://projects.ez.no/cjw_newsletter - http://cjw-network.com/en/ez-publ...w-newsletter-multi-channel-marketing

Author

Message

Saturday 09 April 2005 9:50:06 am

I've created a ez Publish website [http://www.bloudraak.com/] with a gallery [http://www.bloudraak.com/index.php/photography]. I am also using an application called IMatch [http://www.photools.com/] to manage my photos, of which some, may go into my gallery. So I'm trying to understand how the gallery module works, so I can integrate the two applications and get the desired effect. If you don't mind, please point me to information which can help. I know C#, C++, Java and Visual Basic.

I'm looking at writing an IMatch script that
1) Transform the image for the web by scaling it, adding a border, copyright notice and creating a thumbnail.
2) Create a gallery if it doesn't exist
3) Update images if it was added before, or add it

My goal is to manipulate the database directly using MySQL/ODBC. What tables do I need to reference; what do I need to be carefull of?

1) Find if a gallery with an id exists?
2) Add a gallery and determine its id
3) Find an image in a gallery
4) Update the image in the gallery
5) Add an image to the gallery; settings its thumbnail and large image
6) Remove the image from the gallery
7) Where do I FTP the thumbnail and large image?

If I can use SOAP or XMLRPC, instead of ODBC, then so much better. I have approx 1200 photos, which have full IPTC information, a description and name. So the batch upload doesn't work for me as that information will not be displayed on the website.

May I suggest that "ez Publish" documents all the webservices it offers, just like Microsoft SharePoint does it. It will ease integration from other platforms.

Ekkehard Dörre

Saturday 09 April 2005 3:28:55 pm

<i>1) Transform the image for the web by scaling it, adding a border, copyright notice and creating a thumbnail. </i>
possible with ez
you can look in image.ini

IPTC: Exif export is possible in ez
You can use all pear packages via
http://ez.no/community/contribs/3rd_party/extension_ezpowerlib_pubsvn
http://pear.php.net/package/Image_IPTC/

or more directly via image.ini and
http://imagemagick.org/script/formats.php#embedded

Upload via webdav with automatic exif extraction.
http://ez.no/ez_publish/documentation/configuration/configuration/webdav_setup

SOAP is possible, too, search:
http://ez.no/content/search?SearchText=SOAP

ez can handle 6000 images without problems, 100.000 should be possible, too.
Greetings, ekke

http://www.coolscreen.de - Over 40 years of certified eZ Publish know-how: http://www.cjw-network.com
CJW Newsletter: http://projects.ez.no/cjw_newsletter - http://cjw-network.com/en/ez-publ...w-newsletter-multi-channel-marketing

eZ debug

Timing:	Jan 18 2025 18:40:38
Script start
Timing:	Jan 18 2025 18:40:38
Module start 'layout'
Timing:	Jan 18 2025 18:40:38
Module start 'content'
Timing:	Jan 18 2025 18:40:39
Module end 'content'
Timing:	Jan 18 2025 18:40:39
Script end

Main resources:

Total runtime	1.2607 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0092	589.1797	152.6406
Module start 'layout'	0.0092	0.0034	741.8203	39.4766
Module start 'content'	0.0127	1.2466	781.2969	536.0234
Module end 'content'	1.2592	0.0014	1,317.3203	12.1250
Script end	1.2607		1,329.4453

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.2690	16	0.0002
Check MTime	0.0013	0.1059	16	0.0001
Mysql Total
Database connection	0.0016	0.1256	1	0.0016
Mysqli_queries	1.2053	95.6038	54	0.0223
Looping result	0.0006	0.0438	52	0.0000
Template Total	1.2244	97.1	2	0.6122
Template load	0.0019	0.1504	2	0.0009
Template processing	1.2225	96.9730	2	0.6113
Template load and register function	0.0002	0.0166	1	0.0002
states
state_id_array	0.0009	0.0681	1	0.0009
state_identifier_array	0.0013	0.1071	2	0.0007
Override
Cache load	0.0016	0.1257	35	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0539	2	0.0003
Fetch class attribute name	0.0023	0.1816	3	0.0008
XML
Image XML parsing	0.0005	0.0424	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0009	3	0.0000
General
dbfile	0.0008	0.0670	16	0.0001
String conversion	0.0000	0.0008	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
9	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
8	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 22 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs