Difference between revisions of "Telemarque Migration Assistant"
m |
|||
| Line 1: | Line 1: | ||
| + | __NOTOC__ | ||
| + | __NOEDITSECTIONS__ | ||
| + | |||
===Overview=== | ===Overview=== | ||
Revision as of 18:56, 5 March 2018
__NOEDITSECTIONS__
Overview
The Telemarque Migration Assistant obtains statistics about Telemarque, and/or exports all Telemarque data to the file system. This can then be imported into AquilaCRS.
Pre-requisites
In addition to the presence of a Telemarque database, the migration assistant requires the INTERSOLV Interbase ODBC driver to be installed on the same machine. This is likely to be already installed on any machine with Telemarque installed and on the Telemarque Server.
Assistant Mode
The TM Migration Asst provides two main functions:
- Statistics: runs a few queries on the TM database to establish record counts & uploads results to EHS. This is to assist with the development of the Aquila to Telemarque Import Assistant.
- Migration: exports Telemarque data to a folder on the server, ready for later importing.
The TM Migration Asst can be run with either statistics, migration or both.
Export Types
It provides 3 types of export:
- Full: Exports all patient records from the TM database, skipping any patient record that already exists. Must be run at least once.
- Update since last Full: Exports all patient records that have been changed in TM, since the last FULL export was run. Useful to ensure the exported data is kept up to date with changes in the Telemarque database until the Import is ready to be run.
- Export Year: Exports all patient records that were created in the selected year. WILL overwrite existing data. Useful for either testing export, or for exporting TM data piece-by-piece, such as overnight.
E.g. you could export a few select years as a test; then run a Full export which will fill in the gaps. And at some point later on, run an "Update since last full" export and all exported data will be updated with any changes. The update can be run as many times as necessary to bring the exported data up to date prior to import.
