Is anyone smart enough to know how to avoid duplicate sub-keywords?

Report · Aug 08, 2023

Is anyone smart enough to know how to avoid duplicate sub-keywords? I am not. I had made phylogenetic keywords originally, in the form, Diptera (FLIES). I found out, importing to my website, that the proper separation is with commas, and () causes problems. So I decided to rename to Diptera, FLIES,

This is an Order of Insects, and there are Families, Subfamilies and Tribes below this. And there are parents, Arthropods and Insects above. I was first just trying to work on one family of Bee Flies, Bombyllidae, whose format I thus changed. But then I found when I checked one of the subkeywords, the same one in the older one would also check. Likewise with uncheck. I spent hours, trying to view all the subkeywords and starting over, unchecking all the levels but they still came duplicated. that when I then went to the parent keyword Diptera and did the same thing, but it made no difference except creating another duplicate of Bee flies in the new format. Then I selected all the images in the family folder and selected every level and uncheck all the way up to Arthropods. I deleted all levels of duplicate keywords. I I closed and reopened the Bridge and tried again, all to no avail. I had also tried deleting both instances of a subkeyword in the old and new keywords and then putting back in the new and checking. The old came back with all the levels.. I changed the preference to not apply parents, but the subkeyword still duplicates. keyword dupes.jpg

Report · Sep 27, 2023

So, investigating further, I find that it was just unlucky that I was on flies or hymenoptera, big folders that have essentially all wrong formats, and I don't see the original exports, only ones named corrected and with the wrong format. There were almost 20 subfolders that I processed and several have the correct date format, So it may be only half where some difference in procedure caused the change.... 9 folders mostly good and 7 mostly not, with about 3800 files needed to change.

Report · Sep 27, 2023

Maybe the date was reformatted when you pasted it into the other sheet. That sheet might have been formatted for dates.

I have found that Excel doesn't change the exported date format 2023-06-04T16:02:43-05:00, probably because it doesn't recognize the "T" or the "-05:00" as a date. Sometimes file metadata dates do not have all of that, it's not all required.

To be sure you don't loose the XMP date format, select the Date Created column and set column data format to Text

Report · Sep 27, 2023

For the 3800 files that need to have the date changed, can you check to see if the camera exif Date Time or Date Time Original are the correct date?

Report · Sep 27, 2023

But when I would paste the data from a sheet with columns row at the top to one using the imported fields as the top, the receiving sheet was always one that I'd used the exporter before. I'm just uncertain why some had the column row and others didn't. Must have had a slightly different process. In the future I want to have the procedure so that there is a step to omit columns, and never import the dates again.

As far as I can tell with those format altered dates, they all seem correct. Most were from a recent trip and the dates are from that period.

Report · Sep 27, 2023

If it would help, I can modify my script so it only exports-imports the columns you need. This would the spreadsheet smaller and easier to work with.

File Name

File Folder

Keywords

?

Report · Sep 29, 2023

For years, I have used another custom exporter that I use to eventually get the data in a form that my MS Access database will recognize, after tweaking in MSWorks SS. It includes some camera data such as GPS but not some other fields that I wish it did. I don't use it to import back into Bridge and I'm sure the dates would alter.

Your script is great and I just wish I could get the right procedure to open into Excel where I get to choose the fields. For the keyword purpose only, I think the file name, path, keywords, and description would be most useful and minimal.

It would be great if there was a script or macro to manually cut and past the date/times. Based on the time to do several, it looks like over 10 hours to do all.

Report · Sep 29, 2023

It would be great if there was a script or macro to manually cut and past the date/times. Based on the time to do several, it looks like over 10 hours to do all.

By robirdman1

Perhaps you could provide clear, concise info and upload two or three sample files with explanations about which metadata date fields are wrong and how they should be corrected...

Report · Sep 30, 2023

That was buried above in this long thread. Exported dates were changed to a format that Bridge doesn't recognize, so when a RAW file is opened in Photoshop, a warning is given that data can't be read. the resulting tiff is stripped of all metadata. The incorrect date format is in the IPTC core, while the correct fomat remains under the thumbnails and in the camera data (exif). I can copy and paste that from the exif into the IPTC core Date created box and the problem for that file is solved, but there are about 3800 files that were changed, and attempts to re-export and change the format in Excel were unsuccessful because the seconds are actually gone.

Report · Sep 30, 2023

@robirdman1 – This is something that ExifTool is good for, copying the metadata from one field to another. This can be performed in bulk.

Is the error in the raw file, or the .xmp sidecar file or in the entry for the camera raw database?

Can you provide a sample file for testing? You can contact me offlist via PM if you prefer.

Report · Sep 30, 2023

I found that the exporter only affects RAW files when their XMPs are not hidden and selected during export. Otherwise the RAW files are unaffected. The RAW files are huge, like maybe 20mg, But some of the exported files for keyword correction were performed on files that had already made into tiffs and jpegs, so I can attach one,

Report · Sep 30, 2023

Hmmm, RAW file changes work for me even if the XMP files are hidded (the new metadata from the spreadsheet is saved to the XMP on import). I'm not sure what's causing the problem on your system.

I customized the script for you with just these fields:

File Name

File Folder

Description

Keywords

These can be changed in the script, if needed. Look for the variable "earlyBirderFieldsArr"

Remove the old export-import script before installing this one.

When you restart Bridge, look for "Early Birder Export-Import" under the "Metadata Deluxe" menu.

https://www.dropbox.com/scl/fi/v0c5p2ksjdlw28mpxnkgw/export_import_earlyBirder.jsx?rlkey=cz65kammg7n...

When you first open it, select "Early Birder" from the metadata fields list.

Report · Sep 30, 2023

Looking at the sample JPG, I see that photoshop:DateCreated is in the wrong format. This probably happened becasue Excel changed the format and then it was imported.

<photoshop:DateCreated>8/29/2023 21:31</photoshop:DateCreated>
<xmp:CreateDate>2023-08-29T21:31:50</xmp:CreateDate>
<exif:DateTimeOriginal>2023-08-29T21:31:50.73</exif:DateTimeOriginal>

I think copying exif:DateTimeOriginal to photoshop:DateCreated will solve the problem.

@Stephen Marsh what would be the best way to do this in ExifTool?

Report · Sep 30, 2023

I found that the reason I was not seeing the opportunity to omit fields was due to the way I was opening. I would create a new blank worksheet and then open the text file. I would get to choose the 65001 and tab, and that is all. But if instead just open the txt file, then, though I don't see the 65001 in the choice menu, it allows me to skip fields so I can just have the few I want to open. Also this way it doesn't have a unchangeable green header at the top because it also asks if there are field names. They come at the top but are not green and are recognized on import.

So I would hate to delete that original exporter/imported where in some circumstances I might want to have more categories.

Is the new one completely replace all that or is the Earlybirder a specific set within that, where I can reinclude fields. I wasn't sure, thanks.

Report · Sep 30, 2023

Early Birder is just a very stripped down version of IPTC Core.

The new script also contains the same set of IPTC Core fields as the old script. Just select "IPTC Core" in the Metadata Fields drop down to use all the fields you were originally using. Be sure to choose the right field set to match the spreadsheet you are importing.

Report · Sep 30, 2023

@gregreser

That could do it, I have no example file to check, usually there are many date fields in metadata.

I'll need to create a test file to ensure that it's working as intended.

EDIT:

Work on a copy of the original as this command is intended to overwrite the original without automatically creating a backup file. This is untested, but for a single file:

MAC:

exiftool -P -overwrite_original_in_place '-ExifIFD:DateTimeOriginal>XMP-photoshop:DateCreated' 'mac-os-platform/specific/path/to/the file.tif'

WIN:

exiftool -P -overwrite_original_in_place "-ExifIFD:DateTimeOriginal>XMP-photoshop:DateCreated" "win-os-platform\specific\path\to\the file.tif"

Report · Sep 30, 2023

Definitely. I've been compiling a list of exif and XMP date fields and where they are displayed in Bridge, Windows Explorer and Mac OS. It's an ongoing project...

@robirdman1 posted a JPG called "Scopula limboundata" example a few posts up.

Report · Sep 30, 2023

@gregreser

It appears to work as expected:

[System]        FileName          : ORIGINAL.jpg
[ExifIFD]       DateTimeOriginal  : 2023:08:29 21:31:50
[XMP-photoshop] DateCreated       : 8/29/2023 21:31

[System]        FileName          : EXIFTOOL.jpg
[ExifIFD]       DateTimeOriginal  : 2023:08:29 21:31:50
[XMP-photoshop] DateCreated       : 2023:08:29 21:31:50

Report · Sep 30, 2023

@Stephen Marsh Yes, this works in my tests also. Very nice.

@robirdman1 I ran this solution on your sample JPG and I think it worked. Can you confirm that the IPTC Core Date Created shown is what you expected? My test test file is attached so you can look at it in Bridge.

If this looks correct, we can explain how to run ExifTool on your files.

Report · Sep 30, 2023

The date appears correct. When I click on it, it changes appearance, which is normal, instead of disappearing as before. Was data in some fields purposely removed? Sublocation, city, state, country and some others are now blank.

Report · Sep 30, 2023

I see those fields in Bridge. I don't think any data was removed.

Report · Oct 01, 2023

I've been compiling a list of exif and XMP date fields and where they are displayed in Bridge, Windows Explorer and Mac OS. It's an ongoing project...

By gregreser

A labour of love, to be sure!

Some overlap here for Windows:

https://exiftool.org/forum/index.php?topic=6591.0

Report · Oct 01, 2023

Strange anomaly. I had downloaded on my laptop as I was reading my email. I opened in Bridge and it had the name and date and most of the other fields were empty. So I was then going to take a picture as you did. I made it to fill the middle panel. I accidentally pressed control ). And it turned sideways. I did Control ( to get it back. And all the data appeared. I went to my PC and downloaded and opened in Bridge there and all the data is there. I would definitely like to try to use the exif tool on some sample batches as it would be great to not have to change all manually.

Report · Oct 01, 2023

robirdman1 wrote:

Strange anomaly.

Sounds like a cache refresh issue. You can purge the cache for the selected thumbnail or folder.

I posted the command line code for both Mac and Win a few posts back on this topic.

I recently provided similar instructions for different CLI code on the following topic:

https://community.adobe.com/t5/bridge-discussions/bridge-is-not-writing-metadata-to-tiff-files/td-p/...

I have also posted previously a number of times, search the Bridge forum for the keyword ExifTool for more.

Some further info on using ExifTool here:

https://exiftool.org/forum/index.php?topic=4888.0

https://exiftool.org/dummies.html

https://exiftool.org/#running

Different code, but this animation shows how you can drag a folder from the Finder into the Terminal to complete the path to the file or folder of files to be processed (work on copies while learning/testing). The process is the same using the Windows File Explorer and CMD.exe in Windows.

Report · Oct 01, 2023

robirdman1 AUTHOR

Engaged , Oct 1, 2023

So I downloaded and put exiftool(-k) on my desktop. I copied a few bad date format files into a tester folder and dropped the folder onto the icon, allowed it to run and then I pasted

and pressed enter. I went back to the test folder and looked and now they have the correct date format. Everything else seems normal. Opened in Photoshop and saved one raw as tiff and normal.

Is that all I need to do, with larger selections? Amazing! Thanks!

Report · Oct 01, 2023

@robirdman1

You have partly understood, but you are running the exe in Windows, not using the full command line.

You only need the following code without the faux path to the file or folder:

exiftool -P -overwrite_original_in_place "-ExifIFD:DateTimeOriginal>XMP-photoshop:DateCreated"

Ensure that there is a space separator at the end of the code. Then complete the path to the file or folder. You can process an entire folder instead of files and also add -r to recurse into all subdirectories or add further flags/arguments to only process specific file types or to ignore certain folders under the main folder being recursively processed.

I'd suggest that you read the links that I provided a few more times and practice.