01-18-2022, 03:08 AM
Didn't you already try to import it into MSP?
At first sight:
good work, pretty complete information entered
but:
it won't work
- column headers are missing
- MSP needs "Pages" in one column e.g. 21-22 (instead of first page, last page in two columns)
It was easy to fix it, see attachments.
In the XLSX you can see the formula that I used to calculate "Pages"
I created the CSV using tab as separator, so that no quotes are required for "composers".
Semicolons are also fine or, as in your original version, using comma as separator and including all strings that contain a comma in quotes.
I was not sure where you want the content of the 4th column (e.g. "Scenes from Childhood") to be stored, so I used "custom2". It's easy to change that as you like.
At first sight:
good work, pretty complete information entered
but:
it won't work
- column headers are missing
- MSP needs "Pages" in one column e.g. 21-22 (instead of first page, last page in two columns)
It was easy to fix it, see attachments.
In the XLSX you can see the formula that I used to calculate "Pages"
I created the CSV using tab as separator, so that no quotes are required for "composers".
Semicolons are also fine or, as in your original version, using comma as separator and including all strings that contain a comma in quotes.
I was not sure where you want the content of the 4th column (e.g. "Scenes from Childhood") to be stored, so I used "custom2". It's easy to change that as you like.
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de