11-05-2022, 08:39 PM
Hi community,
i'm new on MSPro and I'm searching for a solution to import my huge collection of songs to MSPro (several 1000).
I found the description of csv in the docu, but I was not able to find an answer, so here's my issue:
Until now, I have organized my colletion in Excel, each Line is a song with some categories in the collums, like in MSPro, like this:
SongName;FileName;Genre;Composer;OtherInformation
Song A;0569.pdf;Tango;Villoldo;Argentina
Song B;A5397.pdf;waltz;Strauss;Austria
....
The filenames are unique, the songnames are not
How could I automatically import this, including the colums as metadata for the fields?
Because my source is Excel, I can easily create a csv, but does this work with several files?
Or do I have to create for each pdf a seperate csv with one line? This won't be a problem also, but it's work to do.
And if so: I don't know the number of pages of these files, what do I write in the entry for the pages?
Thanks for help,
Jonny
i'm new on MSPro and I'm searching for a solution to import my huge collection of songs to MSPro (several 1000).
I found the description of csv in the docu, but I was not able to find an answer, so here's my issue:
Until now, I have organized my colletion in Excel, each Line is a song with some categories in the collums, like in MSPro, like this:
SongName;FileName;Genre;Composer;OtherInformation
Song A;0569.pdf;Tango;Villoldo;Argentina
Song B;A5397.pdf;waltz;Strauss;Austria
....
The filenames are unique, the songnames are not
How could I automatically import this, including the colums as metadata for the fields?
Because my source is Excel, I can easily create a csv, but does this work with several files?
Or do I have to create for each pdf a seperate csv with one line? This won't be a problem also, but it's work to do.
And if so: I don't know the number of pages of these files, what do I write in the entry for the pages?
Thanks for help,
Jonny