Require Guidance Syncing Multi-Platform Shared PDBs

Discuss the HanDBase for Windows Desktop program, conduits, and add-ons.

Require Guidance Syncing Multi-Platform Shared PDBs

Postby Shepherd Jim » Wed Apr 18, 2012 9:44 am

My mobile devices are a Motorola Droid Razr Maxx (Verizon -- Android Gingerbread Ver. 2.3.6) and an iPad 2.

I currently have nine databases that I want to be available and synced between the two devices.

After much confusion, trial and error I have re-located the .pdb files into a separate folder on my hard drive. A painful lesson learned was that moving a database.pdb from one device's folder into the "shared folder" and setting up the "shared sync" in HanDBase Desktop is only half the process. You also must take a look in other device's \HanDBase\ folder and delete any .pdb file in there with that same name.

So, things are pretty straight forward as I move back and forth between the phone and the iPad, accessing the databases and being careful to syn each device with my PC regularly.

My question/problem has to do with what to do after I have accessed and or altered a database on the PC in HDB Desktop. As I go to close the database, a "Question" window pops open asking "This Database (BirthRecs2012) has either been modified, recalculated, resorted or navigated. Would you like to save these changes? offering Buttons: Yes No Cancel"

If I click the "Yes" button I'm asked to which "User" I want to "install" the altered pdb:

    Select User(s) to Install File to....
      Jim Child (Palm OS)
      Hatchtown iPad (iPhone//iPad/iPod Touch)
      RazrEC (Android)
      ECDroid2 (Android)
      CustomUser1 ()

My understanding is that the database is shared between the users "Hatchtown iPad (iPhone//iPad/iPod Touch)" and "RazrEC (Android)" -- so how do I correctly respond at this point? BTW: The "CustomUser1" user is a complete mystery to me -- where did it come from??

Jim
i wish i knew then what i know now
Shepherd Jim
 
Posts: 116
Joined: Mon May 25, 2009 3:28 pm
Location: Bristol, Maine USA

Re: Require Guidance Syncing Multi-Platform Shared PDBs

Postby dhaupert » Wed Apr 18, 2012 11:31 am

Hi Jim,

Thanks for your question. The desktop program will prompt you to install a file to a smartphone or handheld if it's saved outside one of the actual device folders. If you select Yes, it will queue it for installation. An installation differs from a sync- it actually overwrites the device's version with the version you queue to install and does it BEFORE the actual syncing happens, so it's not something you should select in your case!

Regarding the Custom User1, to the right of the user's drop down list (in the Open PDB screen) is a way to manage custom users. Here is where you must have set this up in the past. A custom user is setup for exact situations like this- where you have a folder or location for files that are being synced or used by a device, and you can set up a 'virtual user' that uses this folder, so that you aren't always prompted to install a file saved in that folder.
dhaupert
 
Posts: 3461
Joined: Tue May 26, 2009 11:51 am

Re: Require Guidance Syncing Multi-Platform Shared PDBs

Postby Shepherd Jim » Wed Apr 18, 2012 2:37 pm

Hey Dave:

dhaupert wrote:...<snip>...An installation differs from a sync- it actually overwrites the device's version with the version you queue to install and does it BEFORE the actual syncing happens, so it's not something you should select in your case! ...<snip>...


I think I've had a pretty good understanding of how the "Install to .." works and, over the years, have opted to use it when I intentionally wanted to be sure that the then current desktop pdb version (usually that I had just finished adding to or correcting) would be written out to the device.

Am I right? When you say "so it's not something you should select in your case!" it is because the "install to" does not work with "shared databases" because it will re-create a "copy" of the database in the device's folder? I'd then have the .pdb I wanted in the "SharedPDB" folder PLUS a new copy in, for instance, C:\Users\ShepJim\Documents\HanDBase\RazrEC

dhaupert wrote:...<snip>...Regarding the Custom User1, to the right of the user's drop down list (in the Open PDB screen) is a way to manage custom users. Here is where you must have set this up in the past. A custom user is setup for exact situations like this- where you have a folder or location for files that are being synced or used by a device, and you can set up a 'virtual user' that uses this folder, so that you aren't always prompted to install a file saved in that folder.


If I click on menu item "Configure/Sync" and then "Other/Custom Users" in the dropdown, I get a box entitled "Manage Custom Users". If I click the "Select Custom User" dropdown I see that "CustomUser1 ()" I'd mentioned. I see "CustomUser1" as the "User Name" but the "Path to PDB Files" and "User Type" boxes are both empty.

I'm not very clear about how you're saying Custom Users are used. Could I set the "Path to PDB Files" to point to the "SharedPDB" folder thus then being able to "install to" my shared situation?

Could you describe a scenario in which one would create a "custom user"?

----- update question added in AM edit ----
We had two lambs last night and I added them to the "BirthRecs" pdb on my Droid phone. I USB-synced the phone to my laptop this AM and afterwards accessed the "BirthRecs" pdb in the "SharedPDB" folder using HDB Desktop. I adjusted the widths of few columns, etc, and then clicked to close the database and was asked if I wanted to "...save these changes.." If I click "Yes" I'm then asked to "Select User(s) to Install File to..."

What should be my response? If I choose not to install will any data changes still be synced (thinking here of the fact that an install will overwrite where a sync will preserve the newest change(s). If I choose to install to BOTH my phone and the iPad (the two devices accessing the \SharedPDB\ I believe that NEW copies of the "BirthRecs" pdb will be written into the individual phone and iPad device folders and I will then have THREE, soon-to-be conflicting versions of the database. Is this where I could have a "Custom User" using the \SharedPDB\ folder and I could install the updated pdb to the Custom User ...thus continuing to have just the one shared version of the database?

----------------------------------

Sorry for being so dense! Jim
i wish i knew then what i know now
Shepherd Jim
 
Posts: 116
Joined: Mon May 25, 2009 3:28 pm
Location: Bristol, Maine USA

Re: Require Guidance Syncing Multi-Platform Shared PDBs

Postby hopper.kiel » Tue May 01, 2012 11:58 am

Jim,
looking for a similar problem I've found your 2 threads here in the HanDBase-forum.
Here's how I've managed the problem for the combination of iOS/PalmOS, which I like to be in synchronization. (I guess it will work with Android/iOS as well...):
For the files I wished to be in sync i've left the files in the standard PalmOS folder (e.g. user/my documents/palm desktop/hotsync-user/handbase)
instead of moving/creating them in a special "synced-files-folder". (Could be done as well in the opposite direction ...)
After this I moved to the iOS sync setting (menu: configure/sync:iphone/ipod users) opend the "Edit Sync Settings" dialogue via button and added the database from my PalmOS-Handbase-folder via "Create new shared database".
Now I'm able to both Hotsync changes to my PalmOS-device (when I've changed the database on the desktop, there's no request about installing the database to any other user/device) and my iOS-device (via menu: configure/sync:iphone/ipod users; Button "Synchronize").
Changes concerning single records are synchronized now but only concerning added/deleted records. Be careful about making just changes to a record on both databases: the one with the most recent changes will override the one with the older timestamp on the other device (in case you and your wife use the same database and make simultaneously changes on a certain record).
Hope this will help you solve the problem "keeping the herd together..." Let me know, if it works for Android/iOS as well.
With kind regards,
Robert
hopper.kiel
 
Posts: 21
Joined: Tue May 01, 2012 11:24 am
Location: Kiel, Baltic Sea, Germany

Re: Require Guidance Syncing Multi-Platform Shared PDBs

Postby Shepherd Jim » Sun May 13, 2012 9:54 am

dhaupert wrote:Hi Jim, ...<snip>...
Regarding the Custom User1, to the right of the user's drop down list (in the Open PDB screen) is a way to manage custom users. Here is where you must have set this up in the past. A custom user is setup for exact situations like this- where you have a folder or location for files that are being synced or used by a device, and you can set up a 'virtual user' that uses this folder, so that you aren't always prompted to install a file saved in that folder.


Dave, you've known me long enough to understand just how old and slow to grok I really am.

Over the years I have grown accustomed to frequently using the "Install to ..." function to be absolutely sure that any and all changes that I had just made to a database structure and/or its records in the HDB Desktop would be saved out to the "mobile device" -- using the power of the "file overwrite".

Are you saying that I may/can/should put together a "Custom User" that will relate to the shared pdb's -- those being the pdb's that I'm syncing between the desktop, the iPad and my Droid RAZR MAXX phone?

Please be very "step-by-step" in your response.

Thank you! Jim
i wish i knew then what i know now
Shepherd Jim
 
Posts: 116
Joined: Mon May 25, 2009 3:28 pm
Location: Bristol, Maine USA

Re: Require Guidance Syncing Multi-Platform Shared PDBs

Postby Brian_Houghton » Mon May 14, 2012 11:13 pm

Hi Jim,

Thanks for posting. Here's my advice re shared files:

Using the shared database option in HanDBase Plus or higher, you can configure syncing of more than one handheld to the same copy of a database on a laptop or desktop.

To do this, you will want to first move the database(s) in question to a unique folder. This will be the new location for the file(s). Next, open the sync settings dialog in HanDBase Desktop and add a shared entry using the controls at the bottom. Be sure to point to the database in it's new location.

Do the same for the second device, making sure the path points to the same database in it's unique location.

Give it a try and let me know if you run into any problems.
Kind Regards,
Brian Houghton, DDH Software
Brian_Houghton
 
Posts: 1314
Joined: Wed May 20, 2009 8:30 am

Re: Require Guidance Syncing Multi-Platform Shared PDBs

Postby hopper.kiel » Sun May 20, 2012 3:57 am

Hi Jim, 
having read your last post in the forum, here some additional explanations about your synching problem (which is quite similar to the problem I had to figure out recently).

There are two ways to solve your problem:
1. separate "sync-folder" as Brian mentioned
2. share a database of an exsisting mobile_device_A/desktop-sync to another mobile_device_B with full control of mobile_device_A over the database but sync between both mobile devices and the "desktop-user" of mobile_device_A.

case 1: separate "sync-folder"
you create a folder e.g. ".../handbase/syncedfiles" and move your databases to that folder.
As Brian mentioned be sure that there are no copies of that database on any of your mobile_devices and their correspondant  desktop-sync folders (e.g. /handbase/mobile_device_A and /handbase/mobile_device_B etc.).
Then go to the Configure-menue of HanDBase-desktop => "Manage iPhone/iPod touch Users" to make the shared databases available on your iPad (similar steps for your Android-smartphone or maybe PalmOS-device, too). You'll  see your iPad account in the next window showing the connected devices: highlight your iPads-entry,
then got to the "Edit Sync-Settings"-box at the bottom. 
In the next window popping up you will have to choose your databases to be in sync: they are listed in the left lower section of that window and databases can be added with the button "Create New Shared Database" where you can choose your exsisting databases from that ".../handbase/syncedfiles"-folder to be synced to your iPad.
It's important to know that at first you can view/edit synced databases on the iPad only and sync changes to that specific ".../handbase/syncedfiles" folder, but you have no access to the databases via HanDBase-desktop/iPad-User-account, since the iPad-user has a different folder for HanDBase files.
So you will have to create a custom-user to get access to your  ".../handbase/syncedfiles" folder via HanDBase-desktop in order to access/open/manage all your database stored in this specific folder. (as far as I've found out, HanDBase uses predefined folder-settings/locations for the standard PalmOS/iOS sync and folder-location cannot be modified. So you have to create a "custom user" to set the sync-folder location!)
E.g.: 
Menue: Configure/other&custom users
=> window "Manage Custom User"
- [Create new user] for new user
- [Browse]"path to PDB-files" to set path to the given  ".../handbase/syncedfiles" folder 
- [User type] "desktop only".

In case you should create any new database on the desktop via the new Custom-User and save it to the ".../handbase/syncedfiles" folder for syncing beetween different mobile devices, you'll get that missleading message-box, asking you to install the new database to any of the exsisting HanDBase users. Here you must not install the database to any of your mobile devices, since then a copy of the database will be sent to the mobile device and will be now in sync with the device's standard Handbase-desktop user account/folder but not to your common sync-folder. 
Instead you'll have to quit that message box and you will have to create a sync-connection for each single database and  mobile-device manually, as I've mentioned above. (all databases of the ".../handbase/syncedfiles"-folder will be visible in your custom-user's account, as long, as  you've attached the ".../handbase/syncedfiles" to the custom-user's account to be able to view/edit the database with handbase desktop).
In this szenario only the Custom User has full controll over the database-file. In case you might delete the database on any of your mobile devices it won't be deleted in the ".../handbase/syncedfiles" folder but only the Custom user may delete the file. 
But you have to set the sync-connection for each single database and mobile device manually.

case 2: share databases of an exsisting user (= exsisting mobile device-desktop-sync) to another mobile device
you may have your main mobile_device_A (e.g. the iPad) holding all your databases you own.
then the iPad is in full control over the databases and the databases are in sync with the iPads HanDBase-desktop-account and -folder (there is to be a standard folder for that device, which cannot be modified, e.g.".../handbase/iPad") .
As I understand deleting a file on HanDBase desktop will restore the database from the mobile-device (e.g.iPad) back to the desktop during next sync, since the mobile device is to be in full control of the database. Vice versa deleting a database on the main mobile device will delete the Sync to HanDBase desktop but ought to give you means to restore the database on you desktop by any desktop-backups. 
Now you have *one* main-user with a working sync (e.g.HanDBase desktop/iPad) which is in hold and full controll of all your databases and you automatically have access to all of your databases via iPad and HanDBase desktop using the user "iPad".
You can now pick and share any of your databases to any other of you mobile devices via the Configure-menue of HanDBase desktop, as I've described above. So the "other" mobile devices are in sync to the selected files, which are located at/under control of the iPads-User account but have also their own HanDBase user-accounts with their respective standard user-folder-location. You might give a separate category within HanDBase to mark those shared files (e.g category "shared2xy"). Each of the additional mobile-devices is able to sync changes with main (iPad-) database now, but are not eligible to delete the database, which strongly is in control of the main-user account (iPad).
I think, the way of "case_2" is easier to use because setting up a hassle-free sync e.g. between iPad and HanDBase desktop is a no-brainer and a adding any other devices to that "working" sync is simple as well. In my case I have also choosen the iPad as my main-device/"headquarter" now to hold all my databases, since editing data is as convenient as on the desktop, and select those databases to be in sync with other devices. Sync between iPhone and iPad can be made by email&attachment, when I'm on the go which serves as a fair substitute for any missing cloud-sync solution. I guess the Android-version might be capable of synching/merging any received database-attachment coming from your iPad too!?
I recommend to make test-runs with a few dummi-databases to check both methods and the sync via email-attachment before you fiddle around with your important data.
Hope this will help you to solve all questions ...
with kind regards,
Robert
hopper.kiel
 
Posts: 21
Joined: Tue May 01, 2012 11:24 am
Location: Kiel, Baltic Sea, Germany

Re: Require Guidance Syncing Multi-Platform Shared PDBs

Postby Shanti » Thu May 24, 2012 4:18 pm

Brian_Houghton wrote:Hi Jim,

Thanks for posting. Here's my advice re shared files:

Using the shared database option in HanDBase Plus or higher, you can configure syncing of more than one handheld to the same copy of a database on a laptop or desktop.

To do this, you will want to first move the database(s) in question to a unique folder. This will be the new location for the file(s). Next, open the sync settings dialog in HanDBase Desktop and add a shared entry using the controls at the bottom. Be sure to point to the database in it's new location.

Do the same for the second device, making sure the path points to the same database in it's unique location.

Give it a try and let me know if you run into any problems.

The post of a month. Even I understood the algorithm. Thanks a lot
Shanti
 
Posts: 1
Joined: Thu May 24, 2012 2:27 pm


Return to HanDBase for Windows

Who is online

Users browsing this forum: Google [Bot] and 1 guest