Announcement

#1 2009-09-22 14:48:24

CMJN
Member
2009-09-22
1

Writing metadata in database when using pLoader

Hello all, I'm new to Piwigo (2.0.3) and therefore I may ask silly questions :-)

I have created a gallery and uploaded 100+ pictures with pLoader, everything went fine.
I have then edited my config_local.inc.php to choose what exif and iptc data I wanted to display below my pictures, everything went fine.
I also wanted to save some of these metadata in the images table, by setting use_exif=true and use_iptc=true and by selecting them with use_exif/iptc_mapping, and by creating corresponding columns in the images table.

The problem is :
- If I make a ftp upload into a real category and then a synchro, these metadata are correctly stored in the database, in appropriate fields.
- But if I use pLoader, which loads pictures in its own upload directory instead of the galleries arborescence, the pictures won't be taken into account for synchro and therefore their metadata are not stored in the database, which prevents any search based on the IPTC fields.

I would like to continue using pLoader which in my opinion is the easiest way to upload high resolution pictures and generate automatic low resolutions pictures for display ... but I need my metadata in the DB.

Do you see any solution ?
Thx.

Offline

 

#2 2009-09-26 23:09:41

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13548

Re: Writing metadata in database when using pLoader

Hi CMJN and sorry for the late reply :-/

* [Bugtracker] ticket 922
* [Bugtracker] ticket 944

I advise you to add a note in [Bugtracker] ticket 922 to declare you're waiting for a fix (I'm sure ron will fix the problem if he knows many people are interested).

CMJN wrote:

I also wanted to save some of these metadata in the images table, by setting use_exif=true and use_iptc=true and by selecting them with use_exif/iptc_mapping, and by creating corresponding columns in the images table.

I didn't even remember that Piwigo could fill columns that were not in the default data model, without modifying the PHP code. Nice to read this :-) (even if configuring the metadata mapping is still far too complex for any "basic" user).

Offline

 

#3 2010-01-13 13:28:55

Polly
Guest

Re: Writing metadata in database when using pLoader

Hello,

with this diff submitted piwigo will read the IPTC Keywords from the high-Res Images (uploaded with pLoader) and write it to the DB.

http://www.sam-net.de/fileadmin/ploader_metatags.diff

Tested versions: 2.0.6, 2.0.7

Greetings

 

#4 2010-01-15 10:19:50

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13548

Re: Writing metadata in database when using pLoader

Polly wrote:

with this diff submitted piwigo will read the IPTC Keywords from the high-Res Images (uploaded with pLoader) and write it to the DB.

http://www.sam-net.de/fileadmin/ploader_metatags.diff

I'm currently integrating your patch Polly.

I have a question : which version of pLoader did you use? (and which Operating System)

With pLoader 2.0.7b/Ubuntu9.04, the IPTC are not revmoved from the "web resized" picture.

(anyway, I integrate your patch, it is really useful, but in the pLoader specific case, I really wonder where the problem stands)

Offline

 

#5 2010-01-15 10:37:16

Polly
Translation Team
2010-01-15
60

Re: Writing metadata in database when using pLoader

Hi,

i used pLoader 2.0.5 with WinXP SP2.
Piwigo version i tested this patch was 2.0.6 + 2.0.7

btw:
why not include pLoader as a Plugin for BlueMarina or Lightroom?

Greetings
Polly

Last edited by Polly (2010-01-15 11:17:12)

Offline

 

#6 2010-01-15 12:35:56

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13548

Re: Writing metadata in database when using pLoader

Polly wrote:

i used pLoader 2.0.5 with WinXP SP2.
Piwigo version i tested this patch was 2.0.6 + 2.0.7

When I look at your picture on http://aus.sam-net.de/picture.php?/321/category/15 I see that IPTC are not removed from the "web resized" picture. In your picture, I see 2#025 = oller,toller,voller (anyway, this is a nice feature to search metadata in high definition)

[Bugtracker] ticket 620 => [Subversion] r4682
[Bugtracker] ticket 1381 => [Subversion] r4684

Thank you very much Polly for your patch :-)

Polly wrote:

btw:
why not include pLoader as a Plugin for BlueMarina or Lightroom?

Please open a new topic, this is a very important discussion :-)

Offline

 

#7 2010-02-16 17:05:27

Polly
Translation Team
2010-01-15
60

Re: Writing metadata in database when using pLoader

Hello,

just to let you guys know.....
currently we're working on getting ALL meta/IPTC-data from the highRes images.
At the moment only the keywords from the highRes images were added.

Greetings
Polly

Offline

 

#8 2010-02-19 09:33:07

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13548

Re: Writing metadata in database when using pLoader

Polly wrote:

currently we're working on getting ALL meta/IPTC-data from the highRes images.

Did you give a try to grum's plugin Advanced Metadata ?

Offline

 

#9 2010-02-22 15:33:22

Polly
Translation Team
2010-01-15
60

Re: Writing metadata in database when using pLoader

Hello,

i fixed the problem.
already uploaded wont be processed by the metadata script again.

Is this right?

Greetings
Polly

Last edited by Polly (2010-02-22 15:33:45)

Offline

 

#10 2010-02-22 15:46:41

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13548

Re: Writing metadata in database when using pLoader

Polly wrote:

i fixed the problem.

Which problem?

Polly wrote:

already uploaded wont be processed by the metadata script again.

Is this right?

What is the "metadata script"? Tell me exactly what action you perform to synchronize metadata.

Offline

 

#11 2010-02-22 15:55:11

Polly
Translation Team
2010-01-15
60

Re: Writing metadata in database when using pLoader

Hello,
I had a problem to display IPTC_AUTHOR in the "Author" field.
And displaying the Description.

After deleting all the DB-entries and uploading the pictures once more, the "author" and the "description" was displayed from pictures IPTC data.

sorry for being imprecise.

greetings
Polly

Offline

 

#12 2010-02-22 22:28:29

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13548

Re: Writing metadata in database when using pLoader

If you upload the very same photo (with new resize settings for example), then the metadata won't be automatically synchronized.

I know you have read the code (since you sent a nice patch) and the update_metadata function is called only at the end of ws_images_add, not at the end of ws_images_addFile (which is the function called when you reupload a photo).

Offline

 

#13 2010-02-23 09:18:59

Polly
Translation Team
2010-01-15
60

Re: Writing metadata in database when using pLoader

Hello plg,

thank you! I'm not that familiar with php. So i was not able to understand 100% of the php-code.
Now all the features work like a charm!

i will ask our customer if i'm allowed to publish a link of the gallery. somebody was asking for because of production use of this gallery.
The new pLoader 2.0.7c is great!

Have a nice day.

Polly

Last edited by Polly (2010-02-23 09:41:35)

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2022 · Contact