On my computer I have approx 15,000 songs that are named is a less than helpful way, for example:
[login to view URL]
I want to rename these files using the information stored in a MySQL database.
a) Check to see if any new files have been added since the script was last run. (This script will be run every week and I don’t want to start renaming files that have already been renamed.
b) Copy new files to c:\Users\Quiz\Sync\01 Nick Burrett\Music\Sunfly B5014
c) Lookup the first file (for example: [login to view URL]) in MySQL “files” table and retrieve “trackid”
d) Lookup “trackid” in MySQL “tracks” table and store the “title” into memory.
e) Lookup “trackid” in MySQL “artists” table and store the “name” into memory.
f) Rename the file from [login to view URL] to name - [login to view URL]
The resulting track should be something like Adele - [login to view URL] instead of [login to view URL]
freelancer 6 คน กำลังเสนอราคาเฉลี่ยที่ $27 สำหรับงานนี้
I’m dedicated professional Web, Desktop and Apps Programmer & Developer and freelancer only. I have been working with challenge and hope to improve future plan with good network every client. I am ready to work.