Difference between revisions of "Telemarque Migration Assistant"
From EHS Help
m |
|||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | __NOTOC__ | ||
| + | __NOEDITSECTION__ | ||
| + | |||
===Overview=== | ===Overview=== | ||
| Line 13: | Line 16: | ||
* '''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. | * '''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. | * '''Migration''': exports Telemarque data to a folder on the server, ready for later importing. | ||
| + | * '''Statistics and Migration''': allows both statistics extract and data export. | ||
| − | |||
===Export Types=== | ===Export Types=== | ||
| Line 20: | Line 23: | ||
It provides 3 types of export: | It provides 3 types of export: | ||
| − | * '''Full''': Exports all patient records from the TM database, | + | * '''Full Export''': Exports all patient records from the TM database, will '''NOT overwrite or update''' any patient data that already exists in the target folder. This must be run at least once to ensure a complete export. |
| − | * '''Update | + | * '''Update from Audit Trail''': Exports all patient records that have been changed in Telemarque since the FIRST export was run. Essentialto 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 | + | * '''Export Year''': Exports all patient records that were created in the selected year. This WILL overwrite existing data. Useful for testing or for exporting TM data piecemeal over a period of days. Ideally do a Full export to ensure no missed years. |
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. | 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. | ||
| Line 35: | Line 38: | ||
* [[TM Migration Assistant Settings|Settings]] | * [[TM Migration Assistant Settings|Settings]] | ||
| + | * [[TM Migration Assistant File Viewer|File Viewer]] | ||
Latest revision as of 15:44, 2 July 2018
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.
- Statistics and Migration: allows both statistics extract and data export.
Export Types
It provides 3 types of export:
- Full Export: Exports all patient records from the TM database, will NOT overwrite or update any patient data that already exists in the target folder. This must be run at least once to ensure a complete export.
- Update from Audit Trail: Exports all patient records that have been changed in Telemarque since the FIRST export was run. Essentialto 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. This WILL overwrite existing data. Useful for testing or for exporting TM data piecemeal over a period of days. Ideally do a Full export to ensure no missed years.
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.
