Satellite forms sync
I've developed a simple application for the palm pilot which collects various bits of information.
What I want to do now is distribute this application to about 20 people who have palm pilots and send them off collecting data from various clients.
Up to this point everything is fine, until, that is, I want to combine all the information collected into one database (whether it be Access / comma separated or whatever).
Has anybody done this before, 'cos as far as I can see, the hotsync function syncs each palm to it's own profile, therefore, having 20 different copies of the data.
I know that I can export the data and combine it myself, but we want to make this process as seamless as possible, so that the users at the end of the day just have to plonk their palm into the cradle and press a button, whether it be on the cradle or on the PC desktop.
What I want to do now is distribute this application to about 20 people who have palm pilots and send them off collecting data from various clients.
Up to this point everything is fine, until, that is, I want to combine all the information collected into one database (whether it be Access / comma separated or whatever).
Has anybody done this before, 'cos as far as I can see, the hotsync function syncs each palm to it's own profile, therefore, having 20 different copies of the data.
I know that I can export the data and combine it myself, but we want to make this process as seamless as possible, so that the users at the end of the day just have to plonk their palm into the cradle and press a button, whether it be on the cradle or on the PC desktop.
I think you need to write a conduit. I don't know if Satellite Forms can do that but conduits are usually programmed in C++ or Java. Palm recently released a new kit for conduit development. You can find it here: http://www.palm.com/devzone/conduits.html
You can create a conduit that you install in the Hotsync managers of all the users. The conduit is called during the hotsync process and it can then insert the data into the common database.
You can create a conduit that you install in the Hotsync managers of all the users. The conduit is called during the hotsync process and it can then insert the data into the common database.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can write a application with SF ActiveX whoe event HotSyncStatus would be fired by the HotSync Manager jusring syncing. In that event, you can upload the palm DB to desktop DBF database, then do whatever you wanted to the DBF DB, or copy them to your final DB, say an Access DB.
ASKER
Coorrr I can't even remember writing this question :-)
in the 3 years since I initially asked this question I've never had to do it again.
Thanks for your tip anyway.
in the 3 years since I initially asked this question I've never had to do it again.
Thanks for your tip anyway.
ASKER