TM Migration Export

From EHS Help
Revision as of 15:01, 5 June 2018 by Admin (Talk | contribs)

Jump to: navigation, search

Considerations

  • An export can be run at any time prior to importing to AquilaCRS, even if Telemarque is actively being used.
  • Data can be exported year by year in order to export the data piecemeal & thus minimise server impact.
  • When all the TM data has been exported, it can be kept up to date with any new edits in Telemarque by using an "Audit Update Export".
  • We recommend running the export during quiet periods in order to prevent slowing down systems like Telemarque & IBID.

Export Instructions

  • [Optional] run yearly exports to gradually export all the data. (will overwrite any existing data)
  • Run at least one FULL export (will not overwrite any existing data files)
  • [Optional] if there has been more activity in Telemarque since the Full export, run an Audit Upgrade export once TM has been closed down to ensure the latest data is available. will overwrite any existing data files.


Running a Yearly Export

  1. Remote desktop into UHSM-IBID2 - *please use the same user each time to login to the computer*
  2. Open the TM Migration Assistant
  3. Click the Next button to get to the settings page
  4. Under the Application Settings header, change the Assistant Mode to Migration
  5. Under the Export Settings header, make sure the Export Directory is set to your desired location.
    1. See the screen shot below for an example
    2. Once the Export Directory has been set and data exported, do not alter this value
  6. Click Test Conn to ensure the Telemarque database is available
  7. Click Next to proceed to the Export page.
  8. Select the Export Year export type
  9. Select the year from the next drop down box.
    1. It's recommended to migrate the oldest years first (as recent years will still be being worked on in TM)
  10. Press the EXPORT DATA button
  11. The log will output the current settings and any important messages.
  12. The progress bar underneath the log indicates progress, as well as the fields above the log showing the count information.


Running a Full Export

All steps the same as running a yearly export (above), except:

8) On the Export Telemarque Data page, select Full Export

Running an Audit Update Export

All steps the same as running a yearly or full export (above), except:

8) On the Export Telemarque Data page, select Update since last Full


Tm2 settings.png

Example Settings Page


Wzd4.jpg

Example Export Page


Return to Telemarque Migration Assistant