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.
LVL 10
smeggheadAsked:
Who is Participating?
 
semoryConnect With a Mentor Commented:
I'm working on doing the same thing.  I have been testing a product from Extended Systems com called Extend Connect Server. You can find them here :http://www.extendedsystems

This product will allow you to setup a syncronization server that will allow you to syncronize the palms.  It has the conduits already built in and allows you to customize the process using VB script.  It is a liitle pricey though, buit it allows you to syncronize to MS Exchange, Lotus Notes, any ODBC compliant database, and Satellite Forms.  It alos allows you to install apllications and backup the Palm devices.  It also works with Win CE.  

We have discussed setting up mulitple databases(1 for each Palm)in MS Access and using the MS Access repliucation feature which takes care of a lot of this, but our hope is that the Extended Systems software will do all of this for us.

One thing to note if you use Access is that Satellite Forms only works with Office 97 and below.  Access 2000 does not use the DBASE V format that Access 97 and Satellite Forms uses.  
0
 
smeggheadAuthor Commented:
Sorry, forgot to say, I'm using Satellite forms. Maybe I should be using something else... ???
0
 
e7taCommented:
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.
0
 
joywalkerCommented:
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.
0
 
smeggheadAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.