Desktop version of Codebook will not sync

Codebook Issues
21

Hi @sgrune

When you get the chance, would you go into TestFlight and update to version 3.3.5 (535)? Thanks!

23

Hey all, I am having a similar problem when I upgraded to 3.2.4. One of my Macs consistently hangs at 96% with dropbox. I have changed records on both sides. An Integrity check found orphans and unlabeled fields but re-running after still hangs.

24

When I try to Restore from Dropbox, nothing happens but Codebook hangs. My other desktops are working fine.

25

@myronm

Do you have pending changes on the Desktop that isn’t syncing?

If you don’t have any pending changes, could you try resetting Codebook by following the instructions in this post under for OS X: Resetting Codebook then re-try restoring from Dropbox?

Thanks!

26

Updated. Tried a sync and it crashed at 80%. The is no error message. Codebook just shuts down completely.

27

I do have pending changes on the desktop.
Just FYI, I’m out of state with no access to my computer until Monday

28

@sgrune

Thanks for the response and sorry if there was a misunderstanding. My previous question about changes on the Desktop side was directed at myronm (I did see from your previous respond to @developernotes that you have changes pending on both sides).

While we’re unable to reproduce this issue using any of our databases, I have seen the crash reports come in from the most recent beta versions. Unfortunately they don’t lead us to a definitive conclusion on what the cause could be without further investigating the state of your database.

I understand most of this isn’t possible at the moment because you’re traveling, but here are some options for when you return:

If you’d like to get back up and running right away:

  1. Login to Codebook for Windows. Select File → “Export All” and name the file: windows-export.csv
  2. Login to Codebook for iOS. Perform an Overwrite operation to get your data from there onto Dropbox.
  3. Login to Codebook for Windows, perform a restore operation to get the data you just overwrote from your iPhone onto your Windows Computer (this will replace the local data on your Windows machine, but we just exported it to CSV).
  4. Select File → “Export All” and name the file ios-export.csv
  5. Reset your database on Windows by following these instructions: Resetting Codebook under “For Windows”.
  6. Re-open Codebook for Windows, at this point you should be prompted to setup a new database.
  7. Go to File → Import and select the windows-export.csv file from earlier. At this point you should have all records that were on your Windows machine.
  8. Now we’d like to get the records from your iOS database onto your Windows machine as well, there are a couple of options here:

  • Import the ios-export.csv the same way as we did in step 7 (This will cause your records to duplicate and you’ll need to go through and delete the ones that are invalid).

  • Visually compare the CSV records from ios-export.csv to what’s currently in your Codebook database to determine what the differences are and add those.

  • Use a diff tool, like Meld, kdiff or WinMerge to compare the two csv’s (windows-export.csv and ios-export.csv) which will highlight the differences. At which point you can delete all rows that aren’t different in ios-export.csv (Except the header row - Entry…Category…Password) and do File → Import of this adjusted csv.

  1. At this point once you’ve verified all your data is correct on Windows, perform on overwrite operation from your Windows computer to Dropbox. Then perform a restore operation from your iPhone to Dropbox.

Alternatively if you’d like to continue troubleshooting this issue, I have a few additional questions:

  1. If you perform an overwrite operation from your iPhone to Dropbox, then change a record on your iPhone and perform a regular sync operation, does it work properly? Does the same thing work separately for Codebook for Windows (perform an overwrite to Dropbox, change a record, perform a sync from Windows to Dropbox)?
  2. Would you be willing to use a script from us to redact all the sensitive data from your database and send us the result?
  3. Are you in a location that usually uses 24 hour time?
  4. What languages do you have your devices set to?

If you’d prefer to respond in a private setting, feel free to pm me or write us at support@zetetic.net

Thank you for your patience as we help work through this issue.

Cheers,
Micah

29

Micah,

I have the latest version of TestFlight installed. I also followed your instructions below.

When I performed an overwrite from my computer to Dropbox, and a restore from my iPhone to Dropbox, both worked correctly. I them make changes to both the desktop and my iPhone, and performed syncs to Dropbox, and those both worked correctly.

I looks like all is good.

Thanks much,

Steve

30

Steve,

Excellent! Glad we could help.

Cheers,
Micah

31

OUCH! Deleting the local DB, restoring, and re-entering new records worked. Painful!