• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to import PDF with CSV index
#21
Geoff,

Do you just want a warning popup that asks if you want to continue if unrecognized columns are found? There is no way for the processing to continue if title or pages aren't found though, as those are not optional.

Thanks,
Mike
Reply
#22
@Mike

I suppose it really all depends on whether there is a legitimate reason for someone to have unrecognized column headers in the file; If there is no reason then, to my mind, the user should be warned as they probably need to edit the file (easier for them to cancel the load instead of trying to unpick it).

What do you do currently if you detect unrecognized keywords? (I suspect you ignore them - I would if I was programming it!)

Perhaps it would be easiest if you accepted multiple spellings for the field headers e.g. match the first 4 letters (say, assuming unique in 4) rather than the whole header. This would cater for simple misspellings like whether or not there should be a trailing 's'. Obviously, this wouldn't cater for errors in the first 4 chars so a prompt might still be necessary.

I think the main problem is that the load is going to add a lot of entries to the database so one would rather it not happen if it isn't going to have the desired effect. Additionally, this is likely to be something that users do only occasionally (unlike loading individual songs) so they are more likely to make mistakes, especially on their first attempts.

Another possibility, and perhaps it is there already, would be a method to remove a physical file and all the database entries that relate to it; this would make it relatively easy to unpick a faulty load of a CSV file (as opposed to trying to remove all the individual data records which then results in the physical file being deleted)

Not a show stopper for me, just trying to help you improve an already great program

Cheers
Geoff
Samsung Galaxy Tab A6
Reply
#23
"if you accepted multiple spellings for the field headers e.g. match the first 4 letters"
Please NO, it's common that users have to be precise with the keywords for database imports. It would just cause different confusion.
uppercase / lowercase doesn't matter (already)

"unrecognized keywords? (I suspect you ignore them - I would if I was programming it!)"
title and pages are mandatory, all other fields are optional, columns with unknown keywords in the header are ignored.
That definitely makes sense. I prefer e.g. the CSV files to be sorted alfabetically by title for import. But it makes sense to have an additional "number" column that is ignored by MSP to sort it back to the original sequence of pages in the fakebook for proof-reading. Sorting by "pages" doesn't help in that case as it is text and is sorted 1, 10, 11, 2, ...
A warning (and allowing the user to cancel the import) might be helpful. But the option to continue import ignoring unrecognized columns is essential.
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
#24
(05-26-2018, 08:25 AM)itsme Wrote: "if you accepted multiple spellings for the field headers e.g. match the first 4 letters"
Please NO, it's common that users have to be precise with the keywords for database imports. It would just cause different confusion.
uppercase / lowercase doesn't matter (already)

"unrecognized keywords? (I suspect you ignore them - I would if I was programming it!)"
title and pages are mandatory, all other fields are optional, columns with unknown keywords in the header are ignored.
That definitely makes sense. I prefer e.g. the CSV files to be sorted alfabetically by title for import. But it makes sense to have an additional "number" column that is ignored by MSP to sort it back to the original sequence of pages in the fakebook for proof-reading. Sorting by "pages" doesn't help in that case as it is text and is sorted 1, 10, 11, 2, ...
A warning (and allowing the user to cancel the import) might be helpful. But the option to continue import ignoring unrecognized columns is essential.

hi everyone chris kindly helped me with a csv file with real book, which worked ok, the problem now is my whole library is missing, all the folders are in the database but no pdf's, the real books which have been edited are all ok, i have searched all folders cant find them, any ideas, thanks
Reply
#25
Long press one of the song entries until it is selected
"Edit Song" - top of screen
Files
This will show you the name of the pdf book; all song entries for this real book will point to the same pdf file
I would expect the pdf to be in the MS data area (it gets copied there during the import - assuming you are not self managing file locations)

Geoff
Samsung Galaxy Tab A6
Reply
#26
hi geoff the folders are in the data file, but no pdf's
Reply
#27
Not sure what your terminology is; by "folders" do you mean something in MSP or something in the device filing system?

1) Do your pages display when selected in MSP; if yes you have a file somewhere, if not you have somehow just created database entries without referencing a file.

2) Depending how you have configured MSP, it may be storing files directly in it's storage area or it may be storing then in folders contained in the storage area i.e. have you drilled down through the folders shown in the storage location?

3) You might have to use a 3rd party tool to identify where your files are e.g. ES file explorer.
Alternatively, use Windows to look directly in the folders (if using a tablet, connect using wifi and examine the file system using File Explorer)

4) The "Settings |Other Settings| Diagnostics"  options allow you to check for missing files; if it says there aren't any then you deffo have a file, you just don't know where it is!

Hope that helps

Geoff
Samsung Galaxy Tab A6
Reply
#28
(05-29-2018, 01:57 AM)Geoff Bacon Wrote: Not sure what your terminology is; by "folders" do you mean something in MSP or something in the device filing system?

1) Do your pages display when selected in MSP; if yes you have a file somewhere, if not you have somehow just created database entries without referencing a file.

2) Depending how you have configured MSP, it may be storing files directly in it's storage area or it may be storing then in folders contained in the storage area i.e. have you drilled down through the folders shown in the storage location?

3) You might have to use a 3rd party tool to identify where your files are e.g. ES file explorer.
Alternatively, use Windows to look directly in the folders (if using a tablet, connect using wifi and examine the file system using File Explorer)

4) The "Settings |Other Settings| Diagnostics"  options allow you to check for missing files; if it says there aren't any then you deffo have a file, you just don't know where it is!

Hope that helps

Geoff

thanks for the reply geoff, i had a back up so i just did that, but i wanted to know what went wrong, i did a search through the all the stored files, couldnt find them anywhere
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


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