1 2 Previous Next 50 Replies Latest reply on Feb 24, 2017 3:05 PM by Stephen_A_Marsh

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?

• ###### 1. Re: Action that can read and put metadata from CSV file?

An Action can not do what you want to do. You would need to program a Photoshop Script not record and edit a Photoshop Action.

• ###### 2. Re: Action that can read and put metadata from CSV file?

Yeh Mack, I were also thought that this can be done via js coding.... any clue please? I am comfortable with js in Photoshop?

• ###### 3. Re: Action that can read and put metadata from CSV file?

Adobe's scripting supports most of JavaScript Applescript and VSB and Adobe DOM covers some of Photoshop features. Where it does not you can use Action Manger Code Recorded by the Sciptlistener Plugin.  So you would use JavaScript normal file system support to read/write your CVS file and Adobe DOM code to read/write  a Document xmpMetadata.

• ###### 4. Re: Action that can read and put metadata from CSV file?

Here you go (I can’t help with all of your request):

(Last paragraph has info on injecting metadata from .CSV)

Once you have used a Bridge script or ExifTool to import the .CSV metadata into the batch of PSD files, then use Image Processor Pro to create the JPEG and PNG versions. PNG may or may not support the metadata though…what is the exact metadata field that you wish to import?

• ###### 5. Re: Action that can read and put metadata from CSV file?

As an alternative approach, you might consider using Exiftool, an extremely powerful command-line application.

This is actually what the article referenced in the previous message refers to…

• ###### 6. Re: Action that can read and put metadata from CSV file?

Detailed instructions here:

Re: Need a script to update keywords for 20000 images in Bridge

P.S. It is hard to make specific suggestions without understanding:

2) Seeing a copy of the . CSV data

• ###### 7. Re: Action that can read and put metadata from CSV file?

Hi Stephen_A_Marsh, thanks for  your interest on this action. here I attaching csv, psd file link for review actually All PSD files generated based on data set to be batch processed and saved as PSD by the name of the field "v_Filename_Extension" and PSD files generated in action contain all the metadata in the correct places as per the csv also All individual keyword PSD files to be batch processed and saved as PNG with metadata

• ###### 8. Re: Action that can read and put metadata from CSV file?

mirza5313 areyou also mirzaa26404547 ?

If so what you posted here look like Data Driven Graphics not anything related the a document xmp metadata.

Your CSV first row has 23 variable names however, all of the following rows do not have 23 fields. The last filed seems to be a file path in the rows and would not always match up with the header variable name in column 23. Your PSD template look like it may have more than 22 text replacement layers I did not check all layers the see which are defined as variable for there are things used in the document nor include in what you uploaded to dropbox...

• ###### 9. Re: Action that can read and put metadata from CSV file?

Your CSV mostly looks OK, however I think that I can spot a few potential formatting issues and some column headers that I am not sure of in their destination mapping.

Are you Mac or Windows based? My guess is Win…

First you will need to install the venerable ExifTool software.

Next, run the following command line code on a sample file that has metadata in your required fields to find out what the ExifTool metadata fields are titled:

exiftool -a -G1 -s "path\to\file\here.psd"

Such as:

Or perhaps this will serve you better:

Which should output a text file of all of the metadata in your PSD sample. Then you will need to replace the column headers in your current file with the column headers generated by the ExifTool CSV output.

Come back once you have changed over the column headers and we can then go through the other issues that I spotted in your file.

• ###### 10. Re: Action that can read and put metadata from CSV file?

Here are a variety of scripts the DIY custom meta data is the script that has the ability to do all that I am asking, it just does not work in latest version of Adobe CS bridge..

The VRA script also has the same ability, but cant choose which fields to populate so 2nds choice, but they both supposed to read a tab or csv file and find the image and inject meta data...

Please review AND tell me any possibility that how can these script works?

• ###### 11. Re: Action that can read and put metadata from CSV file?

Paul put his script on GitHub - Paul-Riggott/PS-Scripts: Photoshop Scripts make sure you have his latest DIY custom metadata script.  Not though he stated nor of the scripts were tested with CC...

• ###### 12. Re: Action that can read and put metadata from CSV file?

The DIY Metadata script works fine in the latest version of Bridge. Have you checked the errlog ? Error Log.txt is created in the folder that the script was run.

Another thing is that the first field in the csv file must be the file name (no path), you must also select the folder/top level folder where the files reside.

• ###### 13. Re: Action that can read and put metadata from CSV file?

This is why many use ExifTool, it is highly configurable and is not dependent on having a specific version of Bridge or requiring an end user to understand scripting if a certain field is not available. Whether one uses a Bridge script or ExifTool – some planning, testing and work is required by the end user in order to reap the benefits of the chosen tool.

• ###### 14. Re: Action that can read and put metadata from CSV file?

Fully agree with the last sentence.

Speaking for ExifTool is that it is blazingly fast, and therefore well suited for bigger number of files to be processed.

• ###### 15. Re: Action that can read and put metadata from CSV file?

I just tried to work with ExifTool but i am not familiar with this any idea how to use?

• ###### 16. Re: Action that can read and put metadata from CSV file?

I previously provided a link to the installation instructions. Is the software installed?

If you need help with the command line, then try here (there is also some Mac info there too, despite the title):

Getting started: Command-line ExifTool in Windows

Did you look at my post #9?

1) In the command prompt window, just type in:

exiftool -a -G1 -s -csv "

2) Then drag-n-drop your test file into the command prompt to populate the path to the file, you should then have a result like this:

exiftool -a -G1 -s -csv "C:\Username\Desktop\master_1920x1082_withVariables_v8.psd

3) Then add a straight double quote to complete the path (if there are no word spaces in the path, then the straight double quotes are not required):

exiftool -a -G1 -s -csv "C:\Username\Desktop\master_1920x1082_withVariables_v8.psd"

4) Next you will need to add a space and then the greater than character and a space to inform ExifTool that you wish to output the contents of the file to a file:

exiftool -a -G1 -s -csv "C:\Username\Desktop\master_1920x1082_withVariables_v8.psd" >

5) Finally, you will need to add the path and filename of the .csv file that you wish to output:

6) So the final complete command would be similar to this:

Windows:

Mac:

7) Then press enter!

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:

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.

• ###### 17. Re: Action that can read and put metadata from CSV file?

Thanks Stephen_A_Marshfor this detailed instructions, unfortunately I have done at step 7 and press enter nothing happen just exiftool disappeared? I have try till step seven and press enter but no output file?

• ###### 18. Re: Action that can read and put metadata from CSV file?

What happens if you just type exiftool at the command prompt and hit enter?

I am guessing that this is either a simple installation or command syntax issue.

Did you copy the exiftool(-k).exe program to C:\WINDOWS and rename it to exiftool.exe ?

Can you provide a screenshot of where you have installed ExifTool and a screenshot or copy of the command text being entered?

• ###### 19. Re: Action that can read and put metadata from CSV file?

Please see snap shot this time when i enter commands and hit enter another message appear also i just copied exiftool to windows directory and renamed...

• ###### 20. Re: Action that can read and put metadata from CSV file?

It appears that you have typed:

eixftool

When you should type:

exiftool

Also, only a single set of straight double quotes:

-csv "C:\

Not:

-csv ""C:\

And finally, ensure that there is a space either side of the > character.

Be careful with copy/paste from external sources into the command prompt, as straight quotes can become curly, ensure that the quotes are straight. If there are no word spaces in your filepath, then there is no need to enclose the filepath in open/close quote marks, it is just good form to do so otherwise when you do have word spaces you might forget.

Once you fix these basic syntax errors it all should work fine!

• ###### 21. Re: Action that can read and put metadata from CSV file?

Please see snap shot same message, I have uninstalled and than reinstalled exiftool but no change?

After Enter...

• ###### 22. Re: Action that can read and put metadata from CSV file?

The message means that exiftool is not installed into your systems environment execution path.  The system can not find the executable exiftool program.  Either add the folder to your system path variable or change directory  to the folder that exiftool is installed in before you enter the the command line command.

• ###### 23. Re: Action that can read and put metadata from CSV file?

I have checked exiftool is exist in c:/windows directory path but dont know why exiftool not workng

• ###### 24. Re: Action that can read and put metadata from CSV file?

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:\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

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.

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  --

• ###### 25. Re: Action that can read and put metadata from CSV file?

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

• ###### 26. Re: Action that can read and put metadata from CSV file?

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...

• ###### 27. Re: Action that can read and put metadata from CSV file?

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:\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

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>

• ###### 28. Re: Action that can read and put metadata from CSV file?

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.

• ###### 29. Re: Action that can read and put metadata from CSV file?

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

• ###### 30. Re: Action that can read and put metadata from CSV file?

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.

• ###### 31. Re: Action that can read and put metadata from CSV file?

This look like the Command hung did not complete

This stated the command is not installed

• ###### 32. Re: Action that can read and put metadata from CSV file?

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

• ###### 33. Re: Action that can read and put metadata from CSV file?

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\....

• ###### 34. Re: Action that can read and put metadata from CSV file?

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

this is after put directly without folder?

• ###### 35. Re: Action that can read and put metadata from CSV file?

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

• ###### 36. Re: Action that can read and put metadata from CSV file?

same result..

• ###### 37. Re: Action that can read and put metadata from CSV file?

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.

• ###### 38. Re: Action that can read and put metadata from CSV file?

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.

• ###### 39. Re: Action that can read and put metadata from CSV file?

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

1 2 Previous Next