11-06-2022, 03:38 AM
Hello Jonny,
The CSV functionality is currently only meant to be used to break up a single PDF into many individual songs. I do plan on adding support for CSV files where users can specify the PDF to use for each song in the list (like in your example). When I add support for that, I can eliminate the need to specify the page order, as the absence of that field will just indicate that every page should be imported.
In the meantime, I can only see a couple of ways for you to utilize your csv file:
1) Split it up into one csv file per PDF, and the csv files have to be named the same thing as the PDF and you have to specify the page order to use for each file, (so you'd need to open each file to see how many pages it is). I imagine this will be pretty tedious to do.
2) If you are comfortable with scripting and SQLite databases, you could manually populate the database using the data in your CSV file. This is a little involved due to the large number of database tables that have to be updated.
I know you are not the only user to want support for importing csv files to populate the library, but I just haven't had the time yet to implement the necessary changes.
Mike
The CSV functionality is currently only meant to be used to break up a single PDF into many individual songs. I do plan on adding support for CSV files where users can specify the PDF to use for each song in the list (like in your example). When I add support for that, I can eliminate the need to specify the page order, as the absence of that field will just indicate that every page should be imported.
In the meantime, I can only see a couple of ways for you to utilize your csv file:
1) Split it up into one csv file per PDF, and the csv files have to be named the same thing as the PDF and you have to specify the page order to use for each file, (so you'd need to open each file to see how many pages it is). I imagine this will be pretty tedious to do.
2) If you are comfortable with scripting and SQLite databases, you could manually populate the database using the data in your CSV file. This is a little involved due to the large number of database tables that have to be updated.
I know you are not the only user to want support for importing csv files to populate the library, but I just haven't had the time yet to implement the necessary changes.
Mike