Restoring Checkout 3.6 database / backup after reformat

Graham

22 May, 2016 03:31 AM

Hi Checkout users and Support team,

We were recently forced to re-format our POS computer (thanks OSX updates!) running Checkout 3.6 on OSX Mavericks , but managed to get a disk image before we formatted.

So we have all 'current' checkout files on the drive image, as well as an older checkout backup file circa Oct 2015. (I'm assuming this was made with 3.6, but not sure).

The POS computer is now running Mountain Lion happily (for the time being). The problem is we can't seem to restore any information!

I've tried combinations of copying the 'current' files across into the user library, and restoring the older backup file under both 3.6 and 4.x;

3.6 doesn't recognise the 'current' files at all. When attempting to restore the 'older' backup, it goes through the restore process but gets stuck when the wait dialog ("this may take up to half a minute") appears. The wait dialog has window focus, so the only way to abandon is to force-quit Checkout.

4.x recognises 'checkout 3 stores' (the 'current' files) on first start, and asks to update them. It does... something.. but no stores appear in the manager. 4.x is able to restore the the 'older' backup file and the store shows in manager. However we are unable to log into the store (the new 'reset' password and old 'store' password are the same).

Just looking for some insight before I go to the trouble of learning postgresql to retrieve our data, because from what I've managed to read (not much technical documentation out there for checkout) I've got all the right files but nothing works and the failures are far from verbose.

I'm unable to attach a copy of the 'current' user library files from our disk image, or the 'older' checkout backup as both are over the 10MB limit, but if it helps I have copies of both to hand.

Cheers, Graham

  1. 1 Posted by tom on 27 May, 2016 09:06 PM

    Hi,
    Since you go no asnwer as another user you could use Navicat for Progress to connect to the database and then do an export. But not sure if you use variations since they cannot be imported properly. You'll have to manually do all variations again.
    If you use excell to clear out the variations then watch out for the barcode field properties they can also easily go wrong.
    succes T

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac