Page 1 of 1

Newbie Questions

PostPosted: Sat Nov 01, 2014 6:13 am
by mgbgt2
I'm considering using Handbase but have a number of questions before I buy:

1) I'm somewaht confused about the various products. I want to create a master database on a Windows PC V8.1 64 bit and then sync to an iPOD Touch running IOS 5.1.1. I can't update the IOS beyond V5 as its an older version of the Touch. The master database will change several times a week so I need to be able to easily sync without manual copy (Conduit??) I don't need to create fancy forms so a "spreadsheet" like simple list is sufficient. What products do I need? Assuming IOS V5 is still supported, is there a risk that future updates of Handbase will require later versions of IOS? I don't want to have to buy a newer version of my Apple device just to be able to run Handbase!

2) What happens to the Handbase opened decrypted database if my PC crashes before a normal DB close/encrypt? Is the database left open (decrypted) when the PC is re-started?

3) Is Handbase still getting regular updates and support from DHH? I can't find many details of version updates/releases and the latest "NEWS" item on the home page is dated 2012. Does not inspire much confidence for ongoing support

4) I need to import .CSV data to the Handbase database, can I map my .csv fields to spcific Handbase fields in order to change the displayed order?

Re: Newbie Questions

PostPosted: Sun Nov 02, 2014 8:30 am
by Brian_Houghton

Thanks for your interest in HanDBase.

HanDBase works back to iOS 6. It may work on iOS 5 but backwards functionality past the most recent version of the OS cannot always be guaranteed. This is largely due to Apple updating their API calls. HanDBase has to update to newer API calls for newer versions of the OS and this in turn eventually causes something to break regarding backwards compatibility.

If an encrypted database is in use when a computer crashes, the data will stay encrypted. There is, however, a possibility of corruption when this occurs. This is no fault of HanDBase, though.. any file that is open when a computer crashes can become corrupted.

HanDBase is definitely still getting updated. Take a look at the App Store description and you will see that the most recent version was introduced a few days ago. The site does not always get updated to reflect this, though, as we are always pretty busy with development aspects.

Re: Newbie Questions

PostPosted: Sun Nov 02, 2014 2:49 pm
by Alanwestwood
Hi mgbt2, a couple of things. First off, as a user for a year or two now I can say that updates seem to be regular and certainly are quick when there's a real need, such as for iOS8. And in particular the most recent updates have addressed some crucial (for me at least) issues - one of which is CSV import and export, which now both work brilliantly using Open-In.

On field mapping, I have found a way to do this and it works fine, but I'm not sure it's explained well in any of the help items I've read. What happens is that when importing (or exporting) a CSV file HanDBase uses the currently open list view to define the field order which is used. So you just have to match the incoming file with that field order - in fact I just have a list view called 'import' with the correct field order, and use that list view solely for import mapping. If necessary I use a calculated field to manipulate the incoming data. All I can say is that it's both easy and works just fine, and that virtually all my data is imported to HanDBase via CSV files.

Hope that might be of help.

Cheers, Alan.

Re: Newbie Questions

PostPosted: Sun Nov 02, 2014 5:40 pm
by glenwf
If that is true, that is a great hint - (Making a view that matches the actual field order).

I've had some problems in the past and that may have been my problem.

I didn't know that the displayed view had any relevance to the process.

Re: Newbie Questions

PostPosted: Sun Nov 02, 2014 7:04 pm
by Alanwestwood
I've tested this a lot, with several different databases, and all I can say is that it has worked for me in every instance.

One thing I have found is that I have occasionally forgotten to set the list view before doing the CSV import, then the wrong data goes into some fields (this can easily happen if the default view is not the import one) - actually you can cause HanDBase to crash that way if some field types are mis-matched. So what I do now for my main database (a fitness training log) is to create a copy of it and delete all the list views (and records) except the import one. Then I rename the copy database to 'Import' too. Then I import to that database always, and then simply move or copy all the imported records to my main database (the views in use are irrelevant when copying or moving within HanDBase itself). It's a safer method, and let's me see the records that have been imported before I transfer them to my master version.

Hope I've explained that OK - it works a charm for me anyway.

Cheers, Alan.

Re: Newbie Questions

PostPosted: Sun Nov 02, 2014 7:17 pm
by glenwf
Thanks again. I really like the way you made a copy prepared to get the import, then transfer it to the master when verified. Common sense, but often forgotten step in the chase for the result.

Re: Newbie Questions

PostPosted: Mon Nov 03, 2014 8:32 pm
by ArGiEs
mgbgt2, I would strongly recommend updating your hardware, depending how important your database is. All computing platforms, desktop or mobile, move forward steadily - and the longer one tries to use an older version, the more the risk of trouble increases. Apple's firmware moves forward fairly quickly; and since their devices are all part of the platform, eventually any developer-supported app , not just HanDBase, will become buggy, if not useless in time in an old firmware version on an old device. It's just how it is! There are millions of Windows computers out there still running XP - and they're sitting ducks for malware now. Besides, you'll enjoy the greatly improved speed and features of newer products!

Sent from my iPhone using Tapatalk

Re: Newbie Questions

PostPosted: Tue Nov 11, 2014 6:30 am
by mgbgt2
Thanks for all your replies to my original questions. Looks like the iOS version and .csv import is sorted but I am still not sure about which products I actually need to buy to get this working on an IPod Touch synching to a Windows 8 PC? Is Conduit a seperate product?

Re: Newbie Questions

PostPosted: Tue Nov 11, 2014 7:57 pm
by curtterp
Here is the website that has what you need

There are three options. By scrolling down, you can see what you can do with all three options.

Just pick the option that works for you