Solved

Satellite forms sync

Posted on 2000-02-28
5
332 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

A short article about problems I had with the new location API and permissions in Marshmallow
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.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

688 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