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!
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 --
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
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...
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.
Copy link to clipboard
Copied
no exiftool is directly in main folder of c:/windows -> exiftool also i have see user directory is also show exiftool please see image.
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>
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.
Copy link to clipboard
Copied
here is snap shot for result. i have find any .bat file when extract exiftool?
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.
Copy link to clipboard
Copied
I think i have put exiftool in folder now i have directly put to c:/windows
this is after put directly without folder?
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.
Copy link to clipboard
Copied
Now what happens when you run the command? This is like pulling teeth.....
Copy link to clipboard
Copied
same result..
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.
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
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?
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.
Copy link to clipboard
Copied
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.
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:
Copy link to clipboard
Copied
Yes i have use the similar file because i have other file which contain metadata
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.
Copy link to clipboard
Copied
To finish off this topic… I have uploaded an example edited CSV file.
The key points being:
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"
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?
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.