Uploading ratings to files - almost there (2):)

Hi all! Following a previous post, in which @ohrenkino was instrumental(!), I now know how to upload ratings to files, but have hit a stumbling block.

I'm uploading using Convert Text to Tag and

%_path%=%popularimeter%

I tested this on 1,000 mp3s - 892 were fine, the remaining 108 are target files whose filename/path contains a comma. These errors occur using both .csv and .txt file types. Anyone know any way round this which doesn't involve renaming around 2,000 files? I guess the answer is some way of telling MP3Tag to treat commas as text rather than delimeters (note that in the string I'm using here, commas are irrelevant as delimeters anyway - there's nothing to delimit - as I'm using a single command for a single column/field (POPM).

Thanks!

Rob

does it work, if you enclose the data that should be treated as 1 piece in "?

Hi @ohrenkino ! You mean the entry in the csv/text file should be/end with:

"Smiths\Louder Than Bombs\10 - Smiths - William, It Was Really Nothing.mp3"=196

with the same string command in MP3Tag? Doesn't seem to work for csv - will try with txt

TBH, I just tried it with a filename with comma - and it works for MP3tag.
For a better help, if would be nice to see

  • the original dataline from the text file
  • the real filename

Thanks for your comments @ohrenkino
Here's one which didn't work on upload:

Original dataline used
Z:\My Music\AAFamiliar\Albums\0FromShelf\Costello, Elvis\Sulky Girl [Single]\Elvis Costello - Sulky Girl (Single Version).mp3=128

Real filename
Z:\My Music\AAFamiliar\Albums\0FromShelf\Costello, Elvis\Sulky Girl [Single]\Elvis Costello - Sulky Girl (Single Version).mp3

I don't know how you entered the filenames in the text-file generating program.
It would be, though, that the filename has a character that looks like e.g. a hyphen but isn't one.
Is such a file the only one from that folder or does the whole folder lead to problems?
Here is an internet page that checks the characters in a string for you:

Thanks again @ohrenkino - I'll have a look at this - I think you're saying that the comma many not be the problem character?

I do not think that the comma is a problem - as I tested it with a filename containing a comma and got the update.
Still, I exported the filenames with the help of an MP3tag export script - so the filenames were taken as they are.
If you have a different way to get the original text file, like e.g. typing in the names manually and not importing them from a machine-generated list, then it could be that the string in the text file only looks like the filename.
To narrow down the problem: does the problem occur for all files from a folder or only for some?
What happens, if you copy the real filename and paste it as is to the text file and try the import? Does that work?

Yes, looks like something in the extraction - I've taken a couple of files and treated them more manually and seems to work, WITH brackets and without ""s. Thanks again! I'll have a play and see how I can simplify the extraction...

Just to finish off on this, what seems to have been happening is that on conversion to csv via MS Excel (Save as), it was being TOO clever and adding “”s where it detected commas in the file, and MP3Tag wasn’t liking the resulting:

“Z:\My Music\AAFamiliar\Albums\0FromShelf\Costello, Elvis\Sulky Girl [Single]\Elvis Costello - Sulky Girl (Single Version).mp3=128”

Thanks again for your help @ohrenkino and hope others find this useful!

I doubt that - it would be the file system that does not find the files with such names. And without a hit MP3tag cannot modify it.

Got you - yes, that's most likely.