I started looking for a replacement for my uGrokit app with a search for ‘simple database apps for the iphone’. The first hit that came back was iDatabase on the app store, and when I looked at that, the app store also suggested Collections Database, easyAsPieDB Database, Formbook, HanDBase Database Manager, and Memento Database. After doing a bit of netsurfing to find out as much as I could about them, I decided that Memento Database would be worth a try, so I downloaded it and imported the first 5 records, then the next 5 and then the next 20. At that point I decided this was probably going to work for me, and loaded up the other 120 or so records. This wasn’t a particularly scientific process, but I suspect its fairly typical of the way apps are selected from the huge number that are available. I had no desire to do detailed analyses for days and days: I just wanted something that works.
The key characteristics that made me decide to go with Memento Database (MD) were the ability to:
- create and edit fields at will, and to easily reorder them using finger movements;
- import data in csv format;
- search across all fields very easily and quickly;
- take photos from within the app;
- export records in CSV format;
- just have a local copy at no cost.
Interestingly, the one thing I’ve found really difficult about MD is trying to ascertain if I can really use it for free, or if at some moment my iPhone/mobile account is going to get charged. The problem is that the current ‘Free’ plan I’m on is limited to 100Mb storage, but it’s not clear if that 100Mb is for cloud storage or not. For now, I’m assuming it must be for cloud storage because the iPhone says that this app is taking up 4.67 Gb of which 4.63 Gb is being taken up by Documents and Data. I don’t understand this sizing as it works out at over 29Mb for each of the 155 records – very strange. Anyway, I shall continue to use the app locally and will keep my fingers crossed that it doesn’t lock me out at some point in the future. If that should happen, I’d have to decide whether to tie myself to the £35 a year charge, or whether to look for a replacement.
The process of getting the data from my uGrokit app into the MD app was particularly tortuous, and demonstrated how important it is to retain collection data in a transferable format. The uGrokit app would, on request, send a list of all the data in the body of an email as in the example shown below:
- Description: Numark TTUSB Turntable with USB interface
- Type: Item
- Item Serial No: 285
- Container Serial No: Not a container
- Position Serial No: Not a position
- Item category: Hi-fi & video equipment
- Item Owner: Paul
- Item or Container Condition: Good
- Container this Item or Container is contained in: No container
- Position this Item or Container is placed in: P4
- Date this record was created: 12/10/2016
- Container security status: Closed
- Date removed from loft: (no Date removed from loft)
- EPC: (none)
- image key: 2016_10_12_07_00_14_07668572.png
I had to put this material into a spreadsheet and save it in csv format in order to import it to the MD app. I made several different attempts to do so including using Excel’s ‘Get data’ function which I couldn’t understand; and copying and pasting chunks and deleting unwanted material. I ended up just copying and pasting the description and then manually filling in the necessary fields (the ones underlined in the example above). I did this on my laptop in tranches with a small number of records in a spreadsheet to start with and then, as I grew in confidence with the app and the process, I increased the number of records until all 155 had been dealt with. As I did each spreadsheet, I emailed it to myself, picked it up on my iPhone, saved the file to the iPhone’s file system, and imported it from there into the MD app. As I did each import, I discovered foibles of the import process which I was able to address in subsequent csv spreadsheets. For example, apostrophes in the description text (such as “from Paul’s study”) resulted in the text following it being placed into a new record; so, once I figured that out, I eliminated apostrophes from subsequent spreadsheets.
As I compiled the spreadsheets, I was also able to eliminate items that had been removed from the loft: when I designed the uGrokit database I had included a ‘Date removed from loft’ field rather than opting to simply delete the item concerned, because I wanted to have certainty about what had been there and when it was removed. However, with this new app my priority was to keep the number of records down in case I should surpass a charging threshold, so I elected to eliminate items that were no longer in the loft. For the same reason, I did not include the records (including photos) for each of the 32 Positions in the loft (which had been included in the uGrokit database).
Once all the records in the last uGrokit email had been included, I then had to manually create entries in a final csv spreadsheet for the 24 new items that had been added after the last uGrokit email had been sent in January 2023.
Finally, all the spreadsheets were finished and the information imported into the MD app. However, the records from Ugrokit had come with only image file names and not the images themselves, so I then had to go into the loft and take a photo of each of the 155 items. Despite being a laborious exercise, it actually doubled as a useful stock check as well as enabling me to rectify errors in the Position information.
The loft database is now complete and fully operational as a Local ‘Library’ in the MD app. So far, I haven’t been charged anything or been asked to upgrade. The app seems to do everything I need it to – though, of course, time will tell. It has just three flaws that I can see at the moment:
- As already mentioned, the records in the app are taking up a huge amount of storage (some 29Mb each) which I don’t think can be attributed to the photos. I don’t understand this and fear it might have unpredictable implications.
- When entering the Loft ‘Library’ the records are displayed underneath a search bar and a field title bar. However, when you scroll down the records, they scroll up over the field title bar and the search bar and off the top of the screen. It’s not a critical problem – but its not what I would expect.
- Scrolling through the records quickly can be a little hesitant as though the processor is having to work excessively. This is even more pronounced when the photo field of the records is displayed (there is only room for the first 6 fields to be displayed when the iphone is held landscape, so the photos only get displayed if you scroll to the right and then scroll up and down). In fact, not all the photos appear as the records are scrolled through – some of them just have time circles until they appear. Perhaps this issue is simply because I’ve got a relatively old iPhone. However, it doesn’t really concern me because I would rarely scroll through all the records. My useage is almost entirely based around searching for a particular item.
These issues – particularly the first one – are a little disconcerting; but having gone to all the effort to populate my loft database in the MD app, I’m not inclined to do further investigations right now and to potentially have to go through it all again with another app. Instead, I’ll wait and see how things go – and in the meantime export a copy of the MD Loft database, as well as saving a copy of every photo to my iPhone photo library: I’ve learnt my lesson about retaining data in a transferable format. I have retained my old uGrokit loft database on my iPhone: there seems no particular reason to delete it until I have to. However, all additions and changes will be made in the MD app going forward. I’ll report back on how things work out with the new app in a year so.