Difference between revisions of "Telemarque Migration Assistant"

Revision as of 17:30, 5 March 2018

Overview

The Telemarque Migration Assistant exports all Telemarque data to the file system. This can then be imported into AquilaCRS.

The migration assistant requires the INTERSOLV Interbase ODBC driver to be installed on the same machine.

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.
• Export TM Data: exports Telemarque data to a folder on the server, ready for later importing.

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.

Example

For instance 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.

Instructions

• Installation
• Getting Telemarque Statistics
• Exprting TM Data

Reference

• Settings