เสร็จสมบูรณ์

Automated Tool To Rename files using MySQL database

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]

ทักษะ: MySQL, Python

ดูเพิ่มเติม : copy database mysql query, mysql duplicate database with different name, clone mysql database to another server, mysql workbench duplicate schema, mysql workbench duplicate database, mysql copy database to new database, mysql clone database same server, copy database mysql command line, tool apple script rename files depending on entries, rename files using powershell, gui matlab using mysql database, monthly reports using mysql database, java rmi using mysql database, create reports php using mysql database mysql php, using mysql database asterisk ivr, using mysql database generate pages wordpress, jsms using mysql database, java swing login using mysql database, quickbooks using mysql database, using mysql database netbeans j2me

เกี่ยวกับนายจ้าง:
( 169 บทวิจารณ์ ) Bridgwater, United Kingdom

หมายเลขโปรเจค: #16313899

มอบให้กับ:

HardlineSoftware

Hi, I understand what you need and I could perform your task. the only thing I want to clarify: "b) Copy new files to c:\Users\Quiz\Sync\01 Nick Burrett\Music\Sunfly B5014" is the path always the same or shou เพิ่มเติม

$30 USD ใน 1 วัน
(15 บทวิจารณ์)
4.5

freelancer 6 คน กำลังเสนอราคาเฉลี่ยที่ $27 สำหรับงานนี้

mariushudea

I don't have a lot of experience with Python, but I'm very familiar with PHP. My proposal is for writing a PHP script that will do exactly what you describe, with easy to edit options (where the tracks are located, เพิ่มเติม

$25 USD ใน 1 วัน
(139 บทวิจารณ์)
5.3
vw8092236vw

I am expert of mysql Database I have 5 years of experience in Database Management. Feel free to contact me .

$10 USD ใน 1 วัน
(27 บทวิจารณ์)
4.6
KhanMahmud3

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.

$25 USD ใน 1 วัน
(5 บทวิจารณ์)
4.1
$55 USD ใน 1 วัน
(1 บทวิจารณ์)
2.7
rarruda1988

Good afternoon! Currently working with Business Intelligence, where my job is to turn data into relevant information and present it in reports and dashboards. I work daily with multiple data sources at the same tim เพิ่มเติม

$15 USD ใน 2 วัน
(0 บทวิจารณ์)
0.0