• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Action that can read and put metadata from CSV file?

Explorer ,
Feb 15, 2017 Feb 15, 2017

Copy link to clipboard

Copied

HI,

I just need to create an action that do:

1) read 1st column of CSV file

2) find the file named the same as the test in the 1st field of CSV

3) insert all column data into the appropriate meta field

then save the psd file

4) export same psd file as a JPG and PNG while maintaining the meta info

Is this something that Photoshop can do that?

Thanks in advance!

TOPICS
Actions and scripting

Views

10.8K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe
Community Expert ,
Feb 19, 2017 Feb 19, 2017

Copy link to clipboard

Copied

Did you rename exiftool(-k).exe to exiftool.exe  I have never used the tool I just not downloaded the zip file extracted the file amd rebamed it int my E||exiftool foder I just created. How did you install it into your windows folder show that exiftool.exe is in there and that C:\windows is in your path.

Microsoft Windows [Version 10.0.15031]

(c) 2017 Microsoft Corporation. All rights reserved.

C:\Users\John J McAssey\AppData\Local\Temp>Echo %Path%

C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live

;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Common Files\Roxio Shared\DLLShared\;C:\Program Files (x86)\Common Files\Roxio Shared\OEM\DL

LShared\;C:\Program Files (x86)\Common Files\Roxio Shared\OEM\12.0\DLLShared\;C:\Program Files (x86)\Roxio\OEM\AudioCore\;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\Common Files\Adobe\AGL;C:\Pr

ogram Files (x86)\Skype\Phone\;%localappdata%\Microsoft\WindowsApps;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\WINDOWS\system32;C:

\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Common Files\Roxio Shared\DLLShared\;C:\Program Files (x86)\Common Files\Roxio Shared\OEM\DLLShared\;C:\Program Fil

es (x86)\Common Files\Roxio Shared\OEM\12.0\DLLShared\;C:\Program Files (x86)\Roxio\OEM\AudioCore\;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files\Java\jre1.8.0_25\bin\;C:\Program Files (x86)\QuickTime\QT

System\;C:\Program Files (x86)\Keditw\;C:\KeditW;C:\KedPro;C:\KeditW\Macros;C:\KeditW\Samples;c:\dosutil;C:\Users\John J McAssey\AppData\Local\Microsoft\WindowsApps;

C:\Users\John J McAssey\AppData\Local\Temp>exiftool

'exiftool' is not recognized as an internal or external command,

operable program or batch file.

C:\Users\John J McAssey\AppData\Local\Temp>e:

E:\>cd exiftool

E:\Exiftool>exiftool

NAME

    exiftool - Read and write meta information in files

RUNNING IN WINDOWS

    Drag and drop files or folders onto the exiftool executable to display

    meta information, or rename to "exiftool.exe" and run from the command

    line to access all exiftool features.

    This stand-alone Windows version allows simple command-line options to

    be added to the name of the executable (in brackets and separated by

    spaces at the end of the name), providing a mechanism to use options

    when launched via the mouse. For example, changing the executable name

    to "exiftool(-a -u -g1 -w txt).exe" gives a drag-and-drop utility which

    generates sidecar ".txt" files with detailed meta information. As

    shipped, the -k option is added to cause exiftool to pause before

    terminating (keeping the command window open). Options may also be added

    to the "Target" property of a Windows shortcut to the executable.

SYNOPSIS

  Reading

    exiftool [*OPTIONS*] [-*TAG*...] [--*TAG*...] *FILE*...

  Writing

    exiftool [*OPTIONS*] -*TAG*[+-<]=[*VALUE*]... *FILE*...

  Copying

    exiftool [*OPTIONS*] -tagsFromFile *SRCFILE* [-*SRCTAG*[>*DSTTAG*]...]

    *FILE*...

  Other

    exiftool [ -ver | -list[w|f|r|wf|g[*NUM*]|d|x] ]

    For specific examples, see the EXAMPLES sections below.

    This documentation is displayed if exiftool is run without an input

    *FILE* when one is expected.

DESCRIPTION

    A command-line interface to Image::ExifTool, used for reading and

    writing meta information in a variety of file types. *FILE* is one or

    more source file names, directory names, or "-" for the standard input.

    Metadata is read from source files and printed in readable form to the

    console (or written to output text files with -w).

    To write or delete metadata, tag values are assigned using the

    -*TAG*=[*VALUE*] syntax, or the -geotag option. To copy or move

    metadata, the -tagsFromFile feature is used. By default the original

    files are preserved with "_original" appended to their names -- be sure

    to verify that the new files are OK before erasing the originals. Once

    in write mode, exiftool will ignore any read-specific options.

    Note: If *FILE* is a directory name then only supported file types in

    the directory are processed (in write mode only writable types are

    processed). However, files may be specified by name, or the -ext option

    may be used to force processing of files with any extension. Hidden

    files in the directory are also processed. Adding the -r option causes

    subdirectories to be processed recursively, but those with names

    beginning with "." are skipped unless -r. is used.

    Below is a list of file types and meta information formats currently

    supported by ExifTool (r = read, w = write, c = create):

      File Types

      ------------+-------------+-------------+-------------+------------

      3FR   r     | DV    r     | K25   r     | OFR   r     | RSRC  r

      3G2   r/w   | DVB   r/w   | KDC   r     | OGG   r     | RTF   r

      3GP   r/w   | DYLIB r     | KEY   r     | OGV   r     | RW2   r/w

      A     r     | EIP   r     | LA    r     | OPUS  r     | RWL   r/w

      AA    r     | EPS   r/w   | LFP   r     | ORF   r/w   | RWZ   r

      AAX   r/w   | EPUB  r     | LNK   r     | OTF   r     | RM    r

      ACR   r     | ERF   r/w   | M2TS  r     | PAC   r     | SEQ   r

      AFM   r     | EXE   r     | M4A/V r/w   | PAGES r     | SO    r

      AI    r/w   | EXIF  r/w/c | MAX   r     | PBM   r/w   | SR2   r/w

      AIFF  r     | EXR   r     | MEF   r/w   | PCD   r     | SRF   r

      APE   r     | EXV   r/w/c | MIE   r/w/c | PDB   r     | SRW   r/w

      ARW   r/w   | F4A/V r/w   | MIFF  r     | PDF   r/w   | SVG   r

      ASF   r     | FFF   r/w   | MKA   r     | PEF   r/w   | SWF   r

      AVI   r     | FLA   r     | MKS   r     | PFA   r     | THM   r/w

      AZW   r     | FLAC  r     | MKV   r     | PFB   r     | TIFF  r/w

      BMP   r     | FLIF  r/w   | MNG   r/w   | PFM   r     | TORRENT r

      BPG   r     | FLV   r     | MOBI  r     | PGF   r     | TTC   r

      BTF   r     | FPF   r     | MODD  r     | PGM   r/w   | TTF   r

-- More  --

JJMack

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 19, 2017 Feb 19, 2017

Copy link to clipboard

Copied

Yes i have renamed exiftool(-k).exe to exiftool.exe and copy in folder and place this folder in c:/windows folder

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 19, 2017 Feb 19, 2017

Copy link to clipboard

Copied

I just checked all documentation regarding exiftool installation for windows and tired stand alone file as well but this tool not working on my pc...

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 19, 2017 Feb 19, 2017

Copy link to clipboard

Copied

If it is in some Folder c:\Windows\Somefolder\exiftool.exe Make sure you added C:\Windows\Simefolder;  to your user id system Payh environment variable.

JJMack

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 19, 2017 Feb 19, 2017

Copy link to clipboard

Copied

no exiftool is directly in main folder of c:/windows -Capture.PNG> exiftool also i have see user directory is also show exiftool please see image.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 19, 2017 Feb 19, 2017

Copy link to clipboard

Copied

If exitfool.exe is in your c:\Windows directory and that directory is in your environment %Path% variable and you type exiftool on a command line you should not get the message that it is not a command or bat file.

Just type exiftool if you get that message something you wrote is not right

Microsoft Windows [Version 10.0.15031]

(c) 2017 Microsoft Corporation. All rights reserved.

C:\Users\John J McAssey\AppData\Local\Temp>dir c:\Windows\Exif*

Volume in drive C is OSDisk

Volume Serial Number is 1A06-AFC3

Directory of c:\Windows

File Not Found

C:\Users\John J McAssey\AppData\Local\Temp>dir e:\exiftool\*

Volume in drive E is Seagate 4TB

Volume Serial Number is 18CB-CBF7

Directory of e:\exiftool

02/19/2017  09:46 AM    <DIR>          .

02/19/2017  09:46 AM    <DIR>          ..

02/19/2017  09:39 AM         6,093,423 exiftool-10.43.zip

02/16/2017  10:30 AM         8,217,468 exiftool.exe

               2 File(s)     14,310,891 bytes

               2 Dir(s)  3,443,599,273,984 bytes free

C:\Users\John J McAssey\AppData\Local\Temp>

JJMack

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 19, 2017 Feb 19, 2017

Copy link to clipboard

Copied

Please on a command line type Dir C:\windows\Exif*

post the output...  That message states that Windows does not find any EXIFTOOL.EXE or EXIFTOOL.BAT file in your execution path.

JJMack

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 19, 2017 Feb 19, 2017

Copy link to clipboard

Copied

Capture.PNG

here is snap shot for result. i have find any .bat file when extract exiftool?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 19, 2017 Feb 19, 2017

Copy link to clipboard

Copied

Right EXIFTOOL.EXE is not installed in C:\Windows it May be installed be C:\Windows\Exiftool\ 

The file exiftool.exe is not in C;\Windows\....

Add the fildet C:\Windows\Exiftool to your path.

JJMack

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 19, 2017 Feb 19, 2017

Copy link to clipboard

Copied

I think i have put exiftool in folder now i have directly put to c:/windows

Capture1.PNG

this is after put directly without folder?

result.PNG

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 19, 2017 Feb 19, 2017

Copy link to clipboard

Copied

Looking at the result of the command that JJ asked you to run, it would appear that you have named the file as exiftool.exe.exe which probably happend as you have your Windows settings set to hide the filename extension (you could change the setting to make invisible extensions visible, however this could lead to issues of accidentally breaking files/apps by inadvertently changing their extension).

So please just try renaming the file to only exiftool knowing that the .exe executable extension is hidden.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 19, 2017 Feb 19, 2017

Copy link to clipboard

Copied

Now what happens when  you run the command?   This is like pulling teeth.....

JJMack

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 19, 2017 Feb 19, 2017

Copy link to clipboard

Copied

same result..Capture.PNG

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 19, 2017 Feb 19, 2017

Copy link to clipboard

Copied

Please try to understand the message states that windows can not find the file exiftool.exe  You now show is in C:\windows  you never showed that windows is in your path by default it should be.

Try this.   At the command prompt    C:\Users\Mirza  Abdul Rahman>         type     CD C:\Windows

The command prompt should change from C:\Users\Mirza  Abdul Rahman>   to C:\Windows>

Now type exiftool

If you get the message download exiftool again and replace the exiftoot.exe you have ins Windows.

JJMack

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 19, 2017 Feb 19, 2017

Copy link to clipboard

Copied

This screenshot shows that there is no program called exiftoolexiftool installed.

Rename the executable as in my previous post to remove the double .exe extension (one visible, one hidden), then back in the cmd prompt type a single exiftool

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 20, 2017 Feb 20, 2017

Copy link to clipboard

Copied

Yes you are right Stephen_A_Marsh i have hided file intention, so i just removed double .exe and enter commands as stated and hit enter, now where i can get those file?Capture.PNG

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 20, 2017 Feb 20, 2017

Copy link to clipboard

Copied

The first file path in the command with the .psd is the input, while the second file path with the .csv is the output.

It would appear that you are writing to the desktop of the current logged in user with the same filename as the PSD, just with a .csv extension, which would create a plain text file. This may or may not have a plain text file icon, depending on whether the .csv extension is associated to a program, such as MS Excel or LibreOffice Calc etc. If you can’t find the .csv file on the desktop, try searching for *.csv on your computer. The plain text file can be opened into a spreadsheet program for convenient viewing.

If there is no file with the specified filename ending in .csv, then something has gone wrong.

You can try adding a “verbose command for more detailed command prompt display, which will provide more information regarding the processing:

exiftool -v1 -a -G1 -s -csv "C:\…

After all of this, I really hope that you have a comma separated value text file successfully output and containing the input file’s metadata!

NOTE: It still appears that you may be using curly/typographer double quotes when you need to use straight double quotes or inch marks, however this could just be the font used by the command prompt (my screenshots of Win 7 use “Raster Font”). It also looks like you need a word space on the right hand side of the > greater than symbol.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 20, 2017 Feb 20, 2017

Copy link to clipboard

Copied

Yes i got output file please see....

 

MASTER_PSD_META_IMPORT_v8_meta_import.csv

 

 

now what is next?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 20, 2017 Feb 20, 2017

Copy link to clipboard

Copied

Hooray! That is fantastic news…

So, from my previous post #16:

Once ExifTool has created a .csv file from a file with sample metadata, you can open it into a spreadsheet and look at the column headings. Copy/paste these ExifTool column headings into your existing .csv file replacing the appropriate headers.

Example:

Your original spreadsheet column V header was titled DC_Keywords and it would be renamed as XMP-dc:Subject

As I mentioned, after the headings are transplanted, you will have some other work to do as your example .csv is not yet correct for importing as there are issues with the data.

Please post a file download link when you have copied over the ExifTool column headings into your sample spreadsheet, then we can talk about the other issues in your spreadsheet and how to fix them.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 20, 2017 Feb 20, 2017

Copy link to clipboard

Copied

Was your test file that you ran through ExifTool the same file that you previously uploaded a few days ago?

Your results are different to my results for the test file that you uploaded titled:

master_1920x1082_withVariables_v8.psd

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 20, 2017 Feb 20, 2017

Copy link to clipboard

Copied

Yes i have use the similar file because i have other file which contain metadata

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 20, 2017 Feb 20, 2017

Copy link to clipboard

Copied

Please use the file with metadata that I linked to above in post # 44

This way you have a known metadata value that you can then match up with the ExifTool .csv header. Saves a lot of guesswork.

For example, your original spreadsheet column V header was titled DC_Keywords and it would be renamed as XMP-dc:Subject

So then just copy the ExifTool generated headings over into your original spreadsheet, replacing the original headings, then post a link for me to download and inspect.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 24, 2017 Feb 24, 2017

Copy link to clipboard

Copied

To finish off this topic… I have uploaded an example edited CSV file.

The key points being:

  • As my previous post #46 stated, swap out the incorrect column headers for those generated by the ExifTool CSV output, for example column W should use XMP-dc:Subject (I have not updated any other columns in this partial example).

  • If there are multiple keywords separated with commas in column W and you wish for them to import as separate keywords (rather than as one long string as a single keyword) – then wrap them in straight double quote marks, such as “keyword1,keyword 2, etc"

  • Column Y has to contain a valid MS windows (or Mac OS) path to the file, such as C:\ … (with the correct ExifTool column header)

Then use the following ExifTool command to import the metadata against the images:

exiftool -sep ", " -r -csv="C:\Username\Desktop\input-comma-separated-value-text-file.csv" "C:\Username\Desktop\my-folder-stuffed-full-of-files"

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 24, 2017 Feb 24, 2017

Copy link to clipboard

Copied

Thank you so much Stephen_A_Marsh for your interest and help in this regards, I'm sorry i had busy in some argent work, so can you please tell me after this exiftool command how this action will work?

I need to make an action script to automate all this process? 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 24, 2017 Feb 24, 2017

Copy link to clipboard

Copied

By an Action Script do you  you want  to use a mixture of actions and scripts to do you Photoshop automation.   There is Adobe product that was at one tine Macromedia Flash that Adobe purchased and renamed Adobe Flash Professional and has now renaled  Adobe Animate CC has an Action Script feature.   Photoshop has two automation features Photoshop Actions and Photoshop Scripts.  Actions are created by recording and editing  Photoshop steps. Actions can not really use logic except for a small list of document and layer condition.  Scripts are programs written in a scripting language JavaScript or AppleScript or VBS.  Script can can use actions and Actions can use script. So a Photoshop Automation may be a combination of Actions and Scripts.    You may want to use a Script like the Image Processor Pro to batch process your Image files and in its processing include your  combination of Action and Scripts to handle your metadata modification then have Image processor Pro  save your output image files.  It is your process how do you want it to work you need to implement it.

JJMack

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines