• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to import PDF with CSV index
#11
(05-24-2018, 02:33 AM)art Wrote: hi there could somebody look at this csv and tell me what I need to do to edit the separator, I can only open this in read-only, this is all new to me so any help would be appreciated

Here's your file back with:
- semicolon separators - I did this in LibreOffice
- added a first row defining the fields as title, pages, collection

I don't have the Real Book 2 that you're trying to import so you may have to edit this further to get it to work right, but this file at least has semicolon separators.  Hope you don't mind the suggestion ... I'd think you'd do well to get LibreOffice on your computer (free) so you can edit + re-save it with semicolon separator at your convenience. I don't know of any other way to do it except manually change a couple hundred characters in a text editor.

Hope it helps.


Attached Files
.csv   Real Book 2.csv (Size: 12.62 KB / Downloads: 9)
Reply
#12
youre a star chriss, i dragged the file into Libreoffice, and i had semicolon ticked, but it didnt seem to change anything, can you explain the procedure, as i have other books i need to alter, many thanks
Reply
#13
You might want to take a look here:
https://zubersoft.com/mobilesheets/forum...p?tid=3276
https://zubersoft.com/mobilesheets/forum...p?tid=3450
or just search the forum for CSV files.
A number of CSVs already exist.
It would be great (and save a lot of time and effort) if more forum members would share their work.
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 1803
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#14
I think you may need to save from LibreOffice under a new CSV filename, to get the delimiter character to change from comma to semicolon - it's hard to know for sure 'from a distance'. I can "look" at a CSV file with a text editor to check what the delimiter is. I use Leafpad but I'm on Ubuntu Linux - on Windows, maybe you can look with Notepad?? Probably better not to save the file from Notepad - I believe Notepad does something to the end-of-line characters, but I'm not an expert on that - maybe someone else can say for sure.

Then you'll probably need to delete the original (comma-delimited) CSV file, and rename the new CSV file (with semicolons), so it's the filename that you need to get MobileSheets to recognize it as paired with the PDF.

Hope that helps -
C
Reply
#15
thanks for editing my real book file, the problem is now that when i import the csv file and the pdf, the select songs to import file that pops up,  it has all the songs listed, when i select all, it just imports all the songs into the song list, and not in the collection folder, it doesnt seem to be linking to the real book pdf,  tried it several times and it keeps duplicating the files in the song list, so i now have about four of each song,
Reply
#16
(05-24-2018, 11:12 PM)art Wrote: thanks for editing my real book file, the problem is now that when i import the csv file and the pdf, the select songs to import file that pops up,  it has all the songs listed, when i select all, it just imports all the songs into the song list, and not in the collection folder, it doesnt seem to be linking to the real book pdf,  tried it several times and it keeps duplicating the files in the song list, so i now have about four of each song,

Glad you got LibreOffice + the basic import worked, sorry about the problem with the collection. 
I looked at the file spec again, which is here - 
https://zubersoft.com/mobilesheets/forum...4#pid13484

It seems likely to me that the problem is in the first line in the file I gave you. 
I gave you:
title;pages;collection

I think it needs to be:
title;pages;collections

Note the "s" at the end of "collections" - I think MobileSheets didn't recognize the "collections" field because it was missing the "s".  I'm sorry for that mistake.

What to do now / next ...
If you have some way to identify and select all the "extra" songs, you could delete 3 of the 4. 
Then select the remaining ones, and in the top right corner, tap the "..." and you'll get a menu, one option being "add to collection" - this will add all the selected songs to the collection all in one step. 

Or if you have a backup of your database before these imports, you could restore that backup to get your library back to a "clean" state. Then I've attached the CSV file again here, with the missing "s". Do the import again with this file.

Lastly, I'm not sure exactly what you meant by << it doesnt seem to be linking to the real book pdf >> .  
If there's another part I'm missing, maybe you can try to explain it a different way + I'll see if I can help.

Hope it helps.
C


Attached Files
.csv   Real Book 2.csv (Size: 12.63 KB / Downloads: 3)
Reply
#17
(05-25-2018, 12:53 AM)chrisss Wrote:
(05-24-2018, 11:12 PM)art Wrote: thanks for editing my real book file, the problem is now that when i import the csv file and the pdf, the select songs to import file that pops up,  it has all the songs listed, when i select all, it just imports all the songs into the song list, and not in the collection folder, it doesnt seem to be linking to the real book pdf,  tried it several times and it keeps duplicating the files in the song list, so i now have about four of each song,

Glad you got LibreOffice + the basic import worked, sorry about the problem with the collection. 
I looked at the file spec again, which is here - 
https://zubersoft.com/mobilesheets/forum...4#pid13484

It seems likely to me that the problem is in the first line in the file I gave you. 
I gave you:
title;pages;collection

I think it needs to be:
title;pages;collections

Note the "s" at the end of "collections" - I think MobileSheets didn't recognize the "collections" field because it was missing the "s".  I'm sorry for that mistake.

What to do now / next ...
If you have some way to identify and select all the "extra" songs, you could delete 3 of the 4. 
Then select the remaining ones, and in the top right corner, tap the "..." and you'll get a menu, one option being "add to collection" - this will add all the selected songs to the collection all in one step. 

Or if you have a backup of your database before these imports, you could restore that backup to get your library back to a "clean" state. Then I've attached the CSV file again here, with the missing "s". Do the import again with this file.

Lastly, I'm not sure exactly what you meant by << it doesnt seem to be linking to the real book pdf >> .  
If there's another part I'm missing, maybe you can try to explain it a different way + I'll see if I can help.

Hope it helps.
C

thanks once again it worked,  so do i use the  same format with the other real books? titles, pages, collections
Reply
#18
thanks once again it worked so do I use the same format with the other real books titles, pages, collections?
Reply
#19
(05-26-2018, 01:02 AM)art Wrote: thanks once again it worked ...
Good glad it worked.

<<  do I use the same format with the other real books: titles, pages, collections?  >> 
That's the idea - - BUT as we've both discovered, you must be EXACT with the field names. 

So use:
title; pages; collections
Not "titles"  <---that extra "s" would probably make it fail.

good luck - C
Reply
#20
@Mike

Any chance that MSP could prompt the user when the first line contains unrecognized keywords ? (before it starts updating the database!)

Geoff
Samsung Galaxy Tab A6
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.