Hi Tom and everybody,
We have been working on a GPL'ed web-based data management tool (OIO, http://sourceforge.net/projects/open-outcomes/) that focuses on metadata interchange. Basically, it is a frontend/middleware system that provides plug-and-play "forms" through automated generation of database tables etc in the backend. There are, of course, also online data analytic tools etc.
It would be very useful if these same "plug-and-play" forms can be rendered on the Palm Pilot and data be interchanged between the Palm and the web-based system (we use PostgreSQL now).
I have been trying to determine the best way to do this and discovered the Pilot-DB project. My guess is that you have already done much of the work that will support this.
Right now, OIO forms can be imported and export as XML. Do you already have a way to transport a Pilot-DB database between the Palm Pilot and a PC? If so, how is your database described? I think if I can build a program that converts from OIO forms (in XML or comma-delimited etc) to your database format on the PC, then the database can be transferred to the Palm Pilot for data collection. Does that sound reasonable?
The step after that would be to convert data collected using Pilot-DB to XML (which should be trivial) for import into OIO.
If this works, Pilot-DB would gain a web-based database/form designer (provided by OIO) and OIO would gain the ability to collected data from Palm devices.
Your comment and any assistance will be very much appreciated,
Andrew
---
Andrew P. Ho, M.D.
OIO: Open Infrastructure for Outcomes
www.TxOutcome.Org,
Assistant Clinical Professor
Department of Psychiatry, Harbor-UCLA Medical Center
University of California, Los Angeles
Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com
|
