Page 1 of 1

Compare image files to Excel file

PostPosted: Thu Oct 25, 2018 4:58 am
by Anita
I have an excel file containing sku numbers, eg 9999. I have a folder with pack shots, file names are "9999 model color.jpg" or "model color 9999.jpg" (and many many variations). Only common thing they have is that they all contain one or more sku numbers. The pack shots are devided into subfolders of their models.

I want to tag the pack shots (eg "2019 Brand") if the file name contains a sku number from Excel file.

Is there a way to to this?

Re: Compare image files to Excel file

PostPosted: Thu Oct 25, 2018 11:00 am
by Mr_Noodle
You'll need a script to read the Excel file as there's no built-in support to do that. I'm not sure of any commandline programs that can read Excel so you may need to search around a bit.

Re: Compare image files to Excel file

PostPosted: Fri Oct 26, 2018 4:32 am
by Anita
I will keep digging :)