Solved

Satellite forms sync

Posted on 2000-02-28
5
320 Views
Last Modified: 2013-12-27
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.
0
Comment
Question by:smegghead
5 Comments
 
LVL 10

Author Comment

by:smegghead
ID: 2564863
Sorry, forgot to say, I'm using Satellite forms. Maybe I should be using something else... ???
0
 
LVL 4

Expert Comment

by:e7ta
ID: 2566472
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
 

Accepted Solution

by:
semory earned 50 total points
ID: 2570095
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
 

Expert Comment

by:joywalker
ID: 8083919
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
 
LVL 10

Author Comment

by:smegghead
ID: 8085230
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

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preface: This article is part of a series focused on cross platform mobile app development (specifically Android and iOS) using the Alloy framework and Titanium Studio made by Appcelerator (https://www.appcelerator.com/). This article presumes a wor…
You should read OS supplied guidelines before developing. I can't stress that enough. The guidelines will help you understand the reasons mobile app developers do what they do.  Apple is very particular when they review appstore submissions.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question