We were using Collector on Android to collect data for a layer, and we found out that the pictures that were attached contained no EXIF tags at all, including the orientation tag - meaning some photos show upside down, left side up etc. Now we have to rotate every photo manually to make them appear right side up.
In order to do that I thought the following steps will be sufficient:
- Extract blob data from the attachments table into .jpg files.
- Edit the .jpg files and rotate them.
- Extract the data from the .jpg files and update the blob field in the attachments table according to the attachment name field.
I managed to figure out steps 1 and 2, but I wonder how to get step 3 to work?
How do I update specific attachment blob fields, from .jpg files content, according to the attachment name?
Is it possible to do with a cursor?