We want a program that could be written in D5, D6 or D7 -- as long as it's Delphi source code that compiles on Delphi 5.
Your program will do the following (with .mdb file(s) as the database):
1. Import and Export database records into or from a single XML file.
2. The tables are Patients and CMS485. There will be a few dozen tables
eventually added, so the code should support adding other tables.
3. If records change or are added we want the records exported into a single XML file that will be imported. The Import and Export should be in the same program.
4. The program should be written such that future encryption to the XML can be added easily.
5. You should verify/ figure out what new fields need to be added in the Patient and CMS485 tables to notify the StandAlone program that a field has been added or changed. During export the new fields should be updated.
- Probably a version number, date, export flag and status field would do
this. The status field will either say UPDATE or ADD.
- If the status is UPDATE, then the program justs updates the existing
records. Do a locate on the Patient ID for Patients and update the fields.
For the CMS485 record then the Patient ID and the KEY should be used. If the Status is ADD, then the entire record needs to be updated.
- I use auto increment keys for the Patients Table and an Auto Increment
for the CMS485 Table with the Patient ID in it for syncing,
- When a record is added or changed I WILL update the fields in the
records. I'll will update the date, version number and Export Flag in the
core module and send the programmer a New Version.
6. Remote and Corporate computers will Export the added or changed records. Then the files will be emailed either from the remote to Corporate or Corporate to remote to update the DB.
7. Once accepted, you'll be provided with a link and a copy of the commercial healthcare management software that this will be written for. This program will run/tell your program that an XML file needs to be exported.
## Deliverables
(This is continued from the description):
XML Files:
a. All fields in the Patient and CMS485 table need to be exported or
imported if the record changes or is addded.
b. The 2 tables need to have new fields that should let the system know if
they are in sync. For example if a remote computer exports the record is
should have a date, version number, export flag and Status in the record.
Also, on import your program will check the current record and if the version and date are the same -- no import has to be done.