#1 : 04/02-19 18:36
i have a list of image files i1.jpg, i2.jpg, i22.jpg (about 2000)
I have a table of short descriptions that i would like to merge into those file names
these are in a file, say a 2000 row csv file has a column with the i1, i2, i22 for a cross reference to the image files...so a typical row would be
door knob i2
so i'd like to rename the file i1.jpg to i1-lamp.jpg
i2.jpg to i2-door knob.jpg
? thorny issue and appreciate any help in advance...
04/02-19 18:36 - edited 04/02-19 18:37
#2 : 04/02-19 21:16
Reply to #1:
Should be straightforward using "Import"=>"Files from CSV..." to load the source filenames into the list and the corresponding new filenames into the List method.
You will need to edit your csv file so that source filenames - including extensions - are in column 1 and new filenames in column 2.
i2.jpg, i2-door knob
If you have Excel then open your csv file and...
Select cells C1 & D1 and copy down to the end of the worksheet
Select columns C & D
Copy and Paste Special to the same columns as Values
Delete columns A & B
Save as csv
Filename: Browse for csv file
Base folder for original files: Just as it says
Column separator: Comma
List method should now be set up ready to run the batch
Select Apply to: Name
04/02-19 21:16 - edited 04/02-19 21:22