mp3 rename apo excel

[johnnieB]

kalispera paidia. prospathw na vrw mia lysi alla oso ki an psaxnw den ginetai tipota.exw mia lista apo to excel me 2500 mp3 peripou pou exoun sinthetes kallitexnes etos klp klp. prospathw na vrw kapoio software pou tha vlepei ton titlo kai tha vazei ta pedia apo tis sthles tou excelofullou se tags. yparxei kati tetoio? egw vasika thelw na mou vazei kallitexnh-onoma tragoudiou-syntheti kai etos ston titlo.diladi 4 apo tis stiles tou excel sto name tou mp3. gnwrizei kapoios kati tetoio?einai ellinika an auto paizei kapoio rolo... eyxaristw gia ton xrono sas.

[johnnieB]

kapoios na voithisei re paidia?

[worldcitizen]

Ίσως αν γινόσουν πιο περιγραφικός... Τα mp3 πως είναι ονομασμένα τώρα, και πως θα τα βρίσκει το πρόγραμμα?

 

 

Εdit: Δεν ξέρω αν σου κάνει αυτό..

[alkisg]

MP3BookHelper

[johnnieB]

loipon na to exigisw ligo kalytera... exw 2500 rempetika tragoudia se mp3. ola ayta einai kataxwrimena se ena excelofyllo me analytika stoixeia opws onoma tragoudiou-synthetis-ermineutis-etos kykloforias-prwtos stixos.diladi kapoios vlepei to mp3 ton titlo tou kai mporei na paei sthn lista kai na dei poios to egrapse kai pote.mexri edw kala. thelw kapoio programma pou na metonomasei automata ola ta mp3 pairnontas apo thn lista tou excel to onoma, ton syntheti ton ermhneyth kai to etos px. tragoudi-tragoudisths-synthetis-etos.mp3 Elpizw na egina perissotero katanohtos.

[Eddy_Gordo]

Giati pedeuesai me auton ton tropo?

 

Dokimase to tag and rename kai tha eisai ok

[johnnieB]

wraio to tag&rename. omws den vrika to pws kanei thn diadikasia pou psaxnw. vrika pws kanei get tags from file name alla auto pou psaxnw den to vrika puthena.mipws xereis?

[worldcitizen]

Δοκίμασε να δώσεις το excel σε dat και προσπάθησε...

[johnnieB]

to ekana dat. pou yparxei to import tags from dat i kati tetoio?

[oldnew]

loipon na to exigisw ligo kalytera... exw 2500 rempetika tragoudia se mp3. ola ayta einai kataxwrimena se ena excelofyllo me analytika stoixeia opws onoma tragoudiou-synthetis-ermineutis-etos kykloforias-prwtos stixos.diladi kapoios vlepei to mp3 ton titlo tou kai mporei na paei sthn lista kai na dei poios to egrapse kai pote.mexri edw kala. thelw kapoio programma pou na metonomasei automata ola ta mp3 pairnontas apo thn lista tou excel to onoma, ton syntheti ton ermhneyth kai to etos px. tragoudi-tragoudisths-synthetis-etos.mp3 Elpizw na egina perissotero katanohtos.

Den ksero pos ta exeis valei akrivos sto excel, as poyme pos ta exeis:

A B C

onoma arxeioy onoma tragoydioy Tragoydisths

mp31.mp3 mynumber1 Paparizoy

 

An Pas p.x sth sthlh D kai valeis thn entolh "=CONCATENATE(B2;"-";C2;".mp3") "

tote sth sthlh D tha exeis sto parapano paradeigma: mynumber1-Paparizoy.mp3

Travontas thn entolh kato, tha ginei to idio gia ta ypolipa 2500 tragoydia.

Fisika kata ton idio tropo mporeis na to kaneis opos thes dil na exei syntheth etos kykl kai oti alo se endiaferei.

Mporeis na ftiakseis ena arxeio .bat poy na exei mesa thn entolh rename toy dos oste trexontas to mia fora na soy kanei th doylia. Ego gia paradeigma , se ena fakelo me 1000liades arxeia poy hthela na metakiniso kapies 100dades se alo fakelo ekana sto excel to parakato

move aircombj.zip nonwork

move av2mj1bb.zip nonwork

move av2mj2rg.zip nonwork

..

Esi prepei na kaneis kati antistoixo me thn entolh dos poy einai gia metonomasia, nomizo ren , h rename? as grapsei kapios pos syntasetai akrivos, opote sto excel me th vohthia ths entolhs CONCATENATE na to kaneis gia 1 arxeio, kai meta apla travontas thn entolh kato na ginei aftomata ia ta ypoloipa.

Meta me mia antigrafh ths parapano lista kai epikolish ths se ena aplo notpad, sozontas to me katalhksh .bat, eisai etoimos. Apla tha to trekeis 1 fora. Krata backap mhpos kati den paei kala. Elpizo na vohthisa, kai opoioi einai pio dinatoi se dos as grapsoyn pos syntasetai h entolh rename sto dos.