Author Topic: image rename from spreadsheet data?  (Read 3349 times)

Offline sgomes

  • Newcomer
  • *
  • Posts: 1
    • View Profile
image rename from spreadsheet data?
« on: April 23, 2008, 04:35:56 PM »
Apologies in advance if this has been asked before:

I have approximately 1800 images that I need to rename. And I have an Excel spreadsheet that contains both the current file name and what I would like to change the image file names to.

My question is whether it's possible to have PM reference the Excel file to change the file names automatically.

Thanks,
Steve

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 24731
    • View Profile
    • Camera Bits, Inc.
Re: image rename from spreadsheet data?
« Reply #1 on: April 23, 2008, 05:08:58 PM »
Steve,

Apologies in advance if this has been asked before:

I have approximately 1800 images that I need to rename. And I have an Excel spreadsheet that contains both the current file name and what I would like to change the image file names to.

My question is whether it's possible to have PM reference the Excel file to change the file names automatically.

No, there is currently no way to rename from an Excel file.

I would imagine that some freeware utilities may do such a thing.

Sorry,

-Kirk


Offline Hayo Baan

  • Uber Member
  • ******
  • Posts: 2552
  • Professional Photographer & Software Developer
    • View Profile
    • Hayo Baan - Photography
Re: image rename from spreadsheet data?
« Reply #2 on: May 01, 2008, 02:34:33 AM »
Steve, if you have the renames in an excel file, it is quite easy to use that to create a file with the necessary commands to perform the rename on the command line.  Under Windows, you'll need to create lines of the form:
ren "<old-name>" "<new-name>"
For a mac, you would use mv instead of ren.

Hope this helps.

PS. If you're quick (I'll be away shortly), upload the excel file here, and I'll perform the magic for you  :)
Hayo Baan - Photography
Web: www.hayobaan.nl

Offline devenh

  • Sr. Member
  • ****
  • Posts: 435
    • View Profile
Re: image rename from spreadsheet data?
« Reply #3 on: May 01, 2008, 07:10:03 AM »
Renamer 6.0 is a powerful and free Windows file renamer that you may want to take a look at:

http://www.albert.nu/programs/renamer/main.htm

Deven

Offline denisbalibouse

  • Member
  • **
  • Posts: 65
    • View Profile
    • Display of my work
Re: image rename from spreadsheet data?
« Reply #4 on: September 04, 2012, 11:18:08 AM »
I am on a Mac with version 5.
Is it possible now to extract data from an Excel or Word doc to rename a folder of pics ?

Regards

Denis

Offline Hayo Baan

  • Uber Member
  • ******
  • Posts: 2552
  • Professional Photographer & Software Developer
    • View Profile
    • Hayo Baan - Photography
Re: image rename from spreadsheet data?
« Reply #5 on: September 05, 2012, 01:59:59 AM »
Hi Denis,

No, this is not possible – directly. But it is easily done using a simple script (especially on a mac as the command line has all the necessary scripting capabilities built right in). Or simply transform each line in ren "A" "B" (windows) or mv "A" "B" (mac) and run this on the respective command-lines (A and B denote each source/destination filename and don't forget the quotes if there are spaces in your filenames).

You could also transform your excel/word file into a code replacement file and use PM's code replacement feature to rename the files in question (use \{filenamebase}\ as the rename string). This comes perhaps closest to what you want.

Hope this helps,
Hayo
Hayo Baan - Photography
Web: www.hayobaan.nl