I’ve been using the Sort-It Collectors app on my phone since at least 2011 if not earlier on my Touch. I’ve scanned in hundreds of books over the years and it’s really helpful when I’m out and see a book I can’t remember if I have. Even when I read a book and immediately donate it, I scan it in so I don’t forget.
Today I went to scan in a just-finished book and my entire database is gone
Worse, when I add a book, that is also gone after exiting the program. So I can’t even restore
Two things: the last time I exported a CSV of the database was three years ago. My phone is backed up nightly. Any idea where I can find the backup of this program? I’d like to see if I can import the data and re-export it so I have a current list. I can’t even tell you how many books I’ve read and redonated in the past three years.
Then I need a replacement. I remember trying Delicious Library and I loved it but I don’t think it had an iOS version? I absolutely need to carry it with me.
A must-have requirement is that I don’t have to create an account for data that resides on my phone! It’s why I never migrated to the new company when Sort-It went out.
As I wrote, whenever I update the database, I print a report to a PDF and I sync it to my phone via the Books app. I can search for text within the PDF. I fully expect that this can be done with any database software.
For something beyond that, I’m not sure. FileMaker has the “FileMaker Go” product, which can be used (in conjunction with FileMaker Pro) to make database-accessing mobile apps. But I think your database needs to be hosted on an Internet-facing server, running FileMaker Server. So this is clearly going to be prohibitively expensive for a personal project.
FileMaker Go without a server works reasonably well with iCloud. You download the database to your device to be used offline. Changes that are made in Go remain there until uploaded to the cloud. So, syncing is completely manual and requires some care and discipline but it works. And it’s free if you already have FileMaker.
I don’t have a link to an article but it is pretty straightforward. I created a FileMaker folder in my iCloud Drive to hold various databases. Then you start FileMaker Go, go to the launch center and select “On My iDevice” under locations. There should be a little download icon in the upper right hand corner. Touch that icon and it will open a file browser that you can use to navigate to the databases. (You may need to add iCloud Drive to the locations in the Files app). The database will download to your device. Tapping the database file icon will open it in Go.
You can add/edit/delete records, run scripts, but not modify the database structure (that has to be done in the desktop version). You can save the changed database back to iCloud. This is where the manual syncing comes in because of the potential to overwrite the original. I usually want to update the desktop file but that may not always be the case.
It’s been awhile since I set it up so I may have forgotten some detail. Hopefully I have given you enough to get it working.
There’s a simple app, CSV Touch, that can read CSV files. I used to use it years ago for book lists, especially for missing volumes from series to watch for in bookstores. I haven’t used it lately though it still works as of ios 16.n (I don’t have 17 yet). It has fast search and sort, and you can choose which fields show in the table. You can’t edit the data though–you have to make any changes in your database or spreadsheet then re-export/import. $2, no subscription, data not collected.
Tap Forms database is another possibility though I haven’t gotten properly into it yet. But I’ll most likely be switching to it from Filemaker on newer systems than sierra because I can’t justify the FM upgrade costs. Not cheap, but not that expensive considering it’s general purpose, featureful and the user forum looks pretty useful. The ios version can apparently scan barcodes into a field then do a web search to fill in other fields, though I haven’t tried it and I don’t know how much work you have to put into it while setting up the database. $50 for mac, $17 for ios, no subscription, no data collected.
I use LibraryThing myself to track my books as well, but it does require creating an online account and stores the data online, not on device. I’ve also had a lot of issues with entering dates into my book details - start and finish and purchase dates - since they switched from being an obviously scraped web app to adding some native code. This app on iOS at least needs more work - though the iPadOS version works fine, and it works fine in a Safari tab.
I realized I didn’t put the best title on my thread last week, so I am responding to myself with a better title.
I do have Delicious Library 2 from a long time ago but even that database seems to be corrupted and it won’t take new scans. I believe it’s no longer supported and IIRC the iOS app at the time was just a scanner.
I found Bookpedia in another thread and it also seems great, but also unsupported. The Mac app is downloadable but the iOS app (which is what I really want) is gone.
I am currently testing BookBuddy on the iOS side and hoping I can import a backup of Sort-it into it.
I don’t want a subscription nor do I want to have to create an account. I primarily use this on my phone.
I would also love to know if I can retrieve a backup of my Sort-it database from the cloud and my phone backup. I hadn’t done a manual backup of the phone in quite some time but it backs up to the cloud every night.
There is software that will extract things from manual backups. But perhaps the thing to do is write a very nice email to the author of Sort-it asking how you can do this? From personal experience I know that the sadness of having to give up on a project is often relieved by enthusiastic users who are not accusative and demanding but just asking for a knowledgeable helping hand.
That said, I am pessimistic about virtually all of these utilities; not just books. Most of them are dreadful, a few are great—so useful!—but the long-term economics of writing good utilities is grim and that’s why so many fall by the wayside in time.
Your best protection is to make sure, whatever you use, that you can export to an utterly plain-vanilla format like CSV so that when things fall apart you can find another app that will import them. Additional effort, I know, but it’s really the only way.