topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Tuesday March 19, 2024, 12:20 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: File labeling tool  (Read 3948 times)

KoenFugro

  • Participant
  • Joined in 2008
  • *
  • Posts: 26
    • View Profile
    • Donate to Member
File labeling tool
« on: January 13, 2009, 09:46 AM »
Hi people,

I have a bunch of files, with a solid prefix and a random numer. These files are listed in an excel sheet.
The sheet has a few row's. Next to the row witch contains the original file name, is a second row, containing extra information about the file and that information must become part of the filename.

Is there a way to read out the second row of the excel sheet and apply the data in that cell to the file - names i have?
This is about 10000+ files, so i would be glad if this is something I don't have to do by hand :'( :(

So what must happen is that some program makes a file list, then compares the file list with the file names in ms excel in row 1, then paste the information in the second row to the file name.

For more information ask me!
Thanks in advance!

Koen

kwacky1

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 182
  • i am Cody's cousin
    • View Profile
    • CrazyLittleWebsite
    • Donate to Member
Re: File labeling tool
« Reply #1 on: January 13, 2009, 10:32 PM »
Do I understand correctly that column 1 contains the current filename and column 2 contains the desired file name?

Can you export the file to csv?
ie. oldfilename,newfilename

Does your spreadsheet contain full path names or would the program need to search for the files?

I have attached a basic script that assumes the following
  • the files to be renamed have the full path specified or are in the current directory
  • the list of files is in csv format with only 2 columns
« Last Edit: January 13, 2009, 10:43 PM by kwacky1 »