'Copy' data from custom field to label

Stephen
Posts: 633
Joined: 01 Oct 14 10:15

'Copy' data from custom field to label

Post by Stephen » 20 Jan 19 23:38

I have been using custom fields to record some confidential data, but not want to transfer this data to labels.

Does anybody know how it could be done please?
Never say never change, but using Mac since 2005. Photo Supreme 3.3.0.2605. I endorse the interoperability of files between applications and systems.

User avatar
G8DHE
Posts: 80
Joined: 21 Aug 17 13:58

Re: 'Copy' data from custom field to label

Post by G8DHE » 20 Jan 19 23:47

Do you mean Private Labels which are only held in the Catalogue itself not in the Metadata ? If so then choose this option below when you make the label;
Image
Geoff Mather (G8DHE)

Stephen
Posts: 633
Joined: 01 Oct 14 10:15

Re: 'Copy' data from custom field to label

Post by Stephen » 21 Jan 19 0:02

Yes, I want to copy data from existing (private, catalog only) custom fields and create new private labels from them or map to existing private labels. Your screen shot looks like a useful feature when making labels, but I cannot find that feature for custom fields in the Info panel.
Never say never change, but using Mac since 2005. Photo Supreme 3.3.0.2605. I endorse the interoperability of files between applications and systems.

sanphotgn
Posts: 457
Joined: 26 Aug 07 18:06

Re: 'Copy' data from custom field to label

Post by sanphotgn » 21 Jan 19 2:30

Custom fields (which is custom XMP), via the Info panel, is written to the file if the setting is set to write XMP to the file. There isn't a setting to make them private.

You can copy your existing custom fields to labels. It is a several step process. Not sure the script works in version 3, however. So, right click on a file (for testing), Metadata - Export Metadata to CSV File. Choose only one of your custom fields. It did not work here when I chose more than one custom field. Export.

Go here:

https://repository.idimager.com/openres ... D96EA3BFD6

Download script.

Menu ... Tools - Scripter.

Open downloaded script. Run.

Select CSV file. Link your custom field to dc:subject. Start Import.

The label will be created under the Miscellaneous label.

If it works ... and you process the remaining photos with that custom field, you can select all the labels at once, set them to be Private, and move them where they need to be moved.
Photo Supreme 3.3.0.2602 (64 bits) (Windows)

sanphotgn
Posts: 457
Joined: 26 Aug 07 18:06

Re: 'Copy' data from custom field to label

Post by sanphotgn » 21 Jan 19 5:06

Stephen - I just tried the script in a version 3 database and it didn't work here.
Photo Supreme 3.3.0.2602 (64 bits) (Windows)

sanphotgn
Posts: 457
Joined: 26 Aug 07 18:06

Re: 'Copy' data from custom field to label

Post by sanphotgn » 21 Jan 19 5:30

OK, I got it to work in version 3.

Original lines:

Code: Select all

result.Width  := 700 * result.DPIFactor;
result.Height := 400 * result.DPIFactor; 
I am assuming the lines are present for high resolution monitors. I don't have a high resolution monitor.

I changed them to:

Code: Select all

result.Width  := 700;
result.Height := 400;
Photo Supreme 3.3.0.2602 (64 bits) (Windows)

Stephen
Posts: 633
Joined: 01 Oct 14 10:15

Re: 'Copy' data from custom field to label

Post by Stephen » 21 Jan 19 17:50

sanphotgn wrote:
21 Jan 19 5:06
Stephen - I just tried the script in a version 3 database and it didn't work here.
But your signature states that you are using version 3! ???
Never say never change, but using Mac since 2005. Photo Supreme 3.3.0.2605. I endorse the interoperability of files between applications and systems.

sanphotgn
Posts: 457
Joined: 26 Aug 07 18:06

Re: 'Copy' data from custom field to label

Post by sanphotgn » 21 Jan 19 19:00

I have version 3 and version 4 installed in parallel. I see your other post. I am on Windows. Is the process the same on a Mac? I don't know.

I ran both side by side for a while, mirroring my workflow in both (yes, double the work) to ensure I understood what I had to do and everything worked. I started using version 4 exclusively only a couple of months ago.

I don't have one monolith catalog. I have many. Thus, I use the command line parameters.
Photo Supreme 3.3.0.2602 (64 bits) (Windows)

Stephen
Posts: 633
Joined: 01 Oct 14 10:15

Re: 'Copy' data from custom field to label

Post by Stephen » 21 Jan 19 19:37

OK, sanphotgn, thanks for the clarity.
Never say never change, but using Mac since 2005. Photo Supreme 3.3.0.2605. I endorse the interoperability of files between applications and systems.

Stephen
Posts: 633
Joined: 01 Oct 14 10:15

Re: 'Copy' data from custom field to label

Post by Stephen » 21 Jan 19 22:32

sanphotgn wrote:
21 Jan 19 2:30
Custom fields (which is custom XMP), via the Info panel, is written to the file if the setting is set to write XMP to the file. There isn't a setting to make them private.
I was unaware about that of custom fields and initially created them believing them to be private.

"if the setting is set to write XMP to the file"

Which setting are you referring to?
Never say never change, but using Mac since 2005. Photo Supreme 3.3.0.2605. I endorse the interoperability of files between applications and systems.

sanphotgn
Posts: 457
Joined: 26 Aug 07 18:06

Re: 'Copy' data from custom field to label

Post by sanphotgn » 21 Jan 19 23:36

Preferences - Synchronize Settings - Automatically write out Catalog changes to the image file.

If one performs this operation manually (right click - Metadata - Save Metadata to File), the custom fields will also be written to the file. Basically, they are no different than Headline, Description, ....
Photo Supreme 3.3.0.2602 (64 bits) (Windows)

Stephen
Posts: 633
Joined: 01 Oct 14 10:15

Re: 'Copy' data from custom field to label

Post by Stephen » 22 Jan 19 1:14

Is the user chosen name of the custom field written to the file or only the variable data entered?

Is the ics:portfolios data also written to the files?

Thanks
Never say never change, but using Mac since 2005. Photo Supreme 3.3.0.2605. I endorse the interoperability of files between applications and systems.

sanphotgn
Posts: 457
Joined: 26 Aug 07 18:06

Re: 'Copy' data from custom field to label

Post by sanphotgn » 22 Jan 19 1:46

Stephen wrote:
22 Jan 19 1:14
Is the user chosen name of the custom field written to the file or only the variable data entered?

Is the ics:portfolios data also written to the files?

Thanks
Chosen name: yes. Data: yes. Portfolios data: yes (I think, I don't use this feature, just tried it and I see it in the file's metadata).

Screenshot of ExifToolGui for a JPG file.

TestingOne is the name of my custom XMP field.

I used the default portfolio entries.

I used this file to test the copying of the custom field to the label and you can see it worked in version 3. Note I did not enable the Private feature for the label, thus it was written to the file.

xmp_custom_and_portfolios.png
xmp_custom_and_portfolios.png (19.45 KiB) Viewed 243 times
Photo Supreme 3.3.0.2602 (64 bits) (Windows)

Stephen
Posts: 633
Joined: 01 Oct 14 10:15

Re: 'Copy' data from custom field to label

Post by Stephen » 24 Jan 19 1:33

Many thanks for all of the screenshots, which are helpful.

Had I realised the interdependency of ICS and custom fields previously, then I would have never created them and used private labels instead.

Before testing as per your suggestion, I'm wondering how I will be able find all files with a custom field populated? I have 10 custom fields. I could select a year and then filter by one custom field, however some years have >25,000 images, so I would have to split the year. Presumably I would have to repeat that process for all years in question and for all 10 custom fields individually?
Never say never change, but using Mac since 2005. Photo Supreme 3.3.0.2605. I endorse the interoperability of files between applications and systems.

sanphotgn
Posts: 457
Joined: 26 Aug 07 18:06

Re: 'Copy' data from custom field to label

Post by sanphotgn » 24 Jan 19 4:05

Stephen wrote:
24 Jan 19 1:33
Before testing as per your suggestion, I'm wondering how I will be able find all files with a custom field populated?
Go to Catalog - By Image Details. Expand Your Custom Fields. Expand each field to review the data.

catalog_by_image_details.PNG
catalog_by_image_details.PNG (13.64 KiB) Viewed 165 times

Stephen wrote:
24 Jan 19 1:33
Presumably I would have to repeat that process for all years in question and for all 10 custom fields individually?
I don't see a way to do all custom fields at once. Maybe there is. I am not sure I would do that if that was possible. I like the idea of concentrating on one custom field at a time. I don't think I would look at years and the custom fields associated with those years. Are you concerned about transferring the data on 25,000 at once? (I would be. Thus, test on a few, get the feel for it, back up and then try the process on a custom field with less than 25,000.)
Photo Supreme 3.3.0.2602 (64 bits) (Windows)

Post Reply