02-13-2018, 04:54 AM | #316 |
Zealot
Posts: 145
Karma: 12
Join Date: Jun 2017
Location: Australia
Device: Mac Pro 2013 & Mini 2018, iPad Mini 4, iPhone 11, iBooks, K4Mac/PC
|
Hi theducks,
Thanks for your suggestion. Luckily my list isn't too large so I should be able to spot the problem. I have series with name and numbers like - The Second Chronicles of Thomas Covenant [2] - would this cause the error? Do I need series and series index separately? Otherwise I only have Title, Series, Authors and Tags and I can't see any numbers in any of the other columns. The rest of those columns would be words right unless it counts . or : as a number? Inukami |
02-13-2018, 05:07 AM | #317 | |
null operator (he/him)
Posts: 20,459
Karma: 26645808
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Quote:
I thought the plugin had a setting for csv line endings, or it worked them out for itself, but its so long since I used the PI (during initial library load) that I've removed it. BR |
|
02-13-2018, 05:30 AM | #318 | |
Grand Sorcerer
Posts: 24,908
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
|
|
02-13-2018, 05:59 AM | #319 |
Zealot
Posts: 145
Karma: 12
Join Date: Jun 2017
Location: Australia
Device: Mac Pro 2013 & Mini 2018, iPad Mini 4, iPhone 11, iBooks, K4Mac/PC
|
Thanks. I have attached the file to this post.
Inukami Last edited by Inukami; 02-13-2018 at 06:07 AM. |
02-13-2018, 06:06 AM | #320 |
Zealot
Posts: 145
Karma: 12
Join Date: Jun 2017
Location: Australia
Device: Mac Pro 2013 & Mini 2018, iPad Mini 4, iPhone 11, iBooks, K4Mac/PC
|
Let's try that again...had to change to txt file as wouldn't accept the csv.
|
02-13-2018, 12:30 PM | #321 | |
Well trained by Cats
Posts: 29,689
Karma: 54369090
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
Also AFAIK Series Index should be a separate column (you might be able to use your spreadsheet functions to split these apart, also eliminating the []) NO ISBN When I added my paperback collection, way back when. I used Add from ISBN. (I happened to use a barcode Wedge scanner, to input those to AFI in groups of 20, so I could deal with errors) |
|
02-13-2018, 05:33 PM | #322 |
null operator (he/him)
Posts: 20,459
Karma: 26645808
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
@theducks - IMO those Macintosh line endings (CR) are line endings, not separators. What would create such things in 2018, apart from Visicalc on one of these
@Inukami - I changed the Mac Line ends to Unix Line ends, give the attachment a try. BR |
02-13-2018, 05:53 PM | #323 | |
Well trained by Cats
Posts: 29,689
Karma: 54369090
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
I have use Multiplan, Lotus123, Supercalc AND I avoided those original MAC's (they were for managers. Us working troops got XT clones |
|
02-13-2018, 11:08 PM | #324 |
Grand Sorcerer
Posts: 24,908
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Beta - Fix line end problem
Attached is a beta that should fix the problem that @Inukami has reported. The problem is the mode the file was opened in. As noted, it has Mac style line ends which wasn't being handled by the way the plugin was opening the file. In the attached beta, I have changed this to "universal mode".
I haven't done much testing. I works with the posted file and is still working with several other test files I have. |
02-13-2018, 11:21 PM | #325 | |||
Grand Sorcerer
Posts: 24,908
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
Quote:
Quote:
Last edited by davidfor; 02-13-2018 at 11:24 PM. |
|||
02-14-2018, 04:23 AM | #326 | |
Well trained by Cats
Posts: 29,689
Karma: 54369090
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
I don't think NP++ replaced a TAB with these. we are talking 4 or 5 in a row |
|
02-14-2018, 04:40 AM | #327 |
null operator (he/him)
Posts: 20,459
Karma: 26645808
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
@theducks - my screenshot is Notepad++, the pink arrows are tabs. I have View->Show symbols->Show all characters and Show indent guide checked, and Encoding set to UTF-8.
BR |
02-14-2018, 08:47 AM | #328 | ||
Zealot
Posts: 145
Karma: 12
Join Date: Jun 2017
Location: Australia
Device: Mac Pro 2013 & Mini 2018, iPad Mini 4, iPhone 11, iBooks, K4Mac/PC
|
Quote:
The way I made the file was I originally had the list in Excel for Mac. I then changed/saved the file into a CSV. Nothing too weird I hope... Quote:
I do also have a huge manga library which I think I'm just going to use an app on my phone (Bar-Code Reader seems to be okay) to scan and paste the ISBN into Add Books from ISBN as they are all in Japanese but haven't got to that project yet...Too bad Calibre doesn't allow you to enable the computer camera to scan in books (read the posts as to why Kovid doesn't want to do this). Inukami |
||
02-14-2018, 08:51 AM | #329 |
Grand Sorcerer
Posts: 6,211
Karma: 11766195
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
|
The poor plugin is doing what you're telling to it. The configuration says:
It should say:
|
02-14-2018, 09:00 AM | #330 | |
Zealot
Posts: 145
Karma: 12
Join Date: Jun 2017
Location: Australia
Device: Mac Pro 2013 & Mini 2018, iPad Mini 4, iPhone 11, iBooks, K4Mac/PC
|
Quote:
Inukami |
|
Tags |
column types |
Thread Tools | Search this Thread |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
[GUI Plugin] Reading List | kiwidude | Plugins | 1309 | 03-16-2024 11:52 PM |
[GUI Plugin] Manage Sony x50 Reader Book List | kpw | Plugins | 170 | 10-02-2014 08:23 PM |
Import List plugin idea thread | kiwidude | Development | 45 | 08-13-2012 06:05 AM |
[GUI Plugin] WebOS Kindle-Import | CranstD | Plugins | 0 | 01-24-2012 03:36 PM |
[GUI Plugin] Plugin Updater **Deprecated** | kiwidude | Plugins | 159 | 06-19-2011 12:27 PM |