Add IPTC to database
|
jrmint
Joined: 2005-08-20
Posts: 94 |
Posted: Tue, 2005-08-23 15:28
|
|
Okay heres the deal. i would like to add a few items to the g2_Item table in mysql. ie IPTC Byline, City and Object Name. I know how to add these to the table. Can I get a list of what files I need to tweak so that the program will add the meta data to these fields? It would save me alot of time and trouble shooting if I knew exactly what files I need to edit. It looks like most of the files are in the Modules/exif dir and the search dir. I don't mind posting the fixed files after I know they work. Thanks |
|
Posts: 32509
adding additional stuff to the g2_item table isn't the way to go in g2.
either use the g2 itemattributes table or a new table just for iptc / exif data.
i guess we don't store iptc / exif data in the db just because ... the module was written faster without adding such tables. of course it would make sense to store all the exif/iptc data in the database.
Posts: 94
The reason I was thinking of useing the g2_Item table was that it looks like that is where the search is being done. It has
g_description g_keywords g_ownerId g_summary g_title
In the table with all of the text.
I can add a new table no problem. but what are the exact files I need to edit to get the program to put the data to that table? And be able to search that table also?
Posts: 94
Any hints
I don't mind doing the leg work to get this to work.
Posts: 8601
look at how comments and customfields store data and are searched.
Posts: 94
I took a look at these functions and they are in the database as g_id and g_itemid.
I can't seem to be able to find out what the IPTC items id number is. I am using dbadmin as an interface to the mysql.
under the g2_exifprogertiesmap the fields are listed as
property
viewmode and
swquence.
Still at a loss on how I will have to add these items to the database with out having to go threw every file.
Is the creater of the exif module still around?
Posts: 94
Does the version released today put IPTC information into the database. Or is it the same a previous versions?
Posts: 94
Does the version released today put IPTC information into the database. Or is it the same a previous versions?
Posts: 32509
no, not yet. not planned for the next version, still a lot of other things to do... hope you find someone else who is interested and capable of implementing it.
Posts: 15
This sounds similar to a request I posted a few minutes ago. Too bad I didn't see this first. I too am interested in either storing the EXIF data in the database or mapping that data to custom fields. I'll take a look around to see how it might be done but I'm certainly eager to hear any and all input as to where to look for starters.