Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Rename files from database

by yaakovraskin Jun 12, 2013 10:51PM PDT

Hi
I have an HD full of files, from a (now obselete and not functional) reference program.
It contains thousands of books, all in PDF.
The program had the filenames as numbers, instead of book titles, making it easy for the program to use, but impossible for humans.
I have a database (HTML and CSV) of all the books, and the correspondiong numbers. Is there an automatic way of renaming files from the database? Similar to how MediaMonkey sorts music from their matedata, but this is with PDF on a separate database?
Also, any way to search the text of multiple PDFs quickly, particularly in other languages (hebrew)?

Thanks for your help

Discussion is locked

3 Posts

- Collapse + Expand Details

- Collapse -

No.

by r. proffitt Forum moderator Jun 13, 2013 3:16AM PDT

But if you did write an app that took your HTML or CSV as input then it could be done. All the file renamers I know of won't use your current HTML or CSV so the answer is no. But you have the basic info, now you need an app. If you can't find an app, you write one.
Bob

- Collapse -

Coding

by yaakovraskin Jun 13, 2013 9:11PM PDT

I was asking if anyone knows of such an app. I've never done coding, and I'm not in a big rush to start.

- Collapse -

No need to code.

by Kees_B Forum moderator Jun 13, 2013 9:44PM PDT

Just use MS Excel to generate from the csv file a colomn contain the command prompt rename commands. That are just formulas, no VBA code.
Then copy/paste that column to Notepad, save it as a batch file and execute that.

Couldn't be simpler.

Kees

Back to Office & Productivity Software forum