Using TSDE Export

Exporting data is the process of sending data from one application to another application while importing data is the process of loading a file, text, data, etc. prepared with one application into another application.

If data has been created with another application, the data has to be exported first into Extensible Markup Language (XML) files. Once the XML files have been created, the TSDE import service can be used to import data into the Trapeze Data Exchange Format (TSDF).
  1. To open the Data Exchange screen, click Task > Data Exchange.
  2. On the vertical screen toolbar on the left side of the Data Exchange tab, click the Export button:Export button
  3. Select the TSDE Export check box on the Export interface(s) pane.
    TSDE Export check box
    Additional fields appear on the right pane. The Export Files frame shows the list of files that can be exported.
    Note: If you do not see the files, this may mean that TSDE has not been activated. For assistance, please contact your Trapeze representative.
  4. In the Signup Period drop-down list (below the Export Files frame), select the sign-up period whose data you want to export.
    The Service Groups, Divisions, and Lines frames are automatically filled in with the data associated with the sign-up period.
    Data Exchange Interface
  5. In the Export interface(s) pane, click the ellipsis button in the Export Folder field.

    The Browse for Folder dialog box is displayed. Select the folder where you want to store the data to be exported, and then click OK.

  6. In the Log File field, click the ellipsis button.

    The Browse for Files or Folders dialog box is displayed. Select the log file you want to overwrite or enter a file name for the new log file, and then click OK.

  7. In the Format drop-down list, select the appropriate format: Delimited, Fixed Width, or XML.

    If you selected Delimited, the Delimiter and Text Qualifier fields are activated.

    Perform one of the following steps:

    • In the Field Delimiter list, select the symbol to distinguish the fields. for example, select comma (,) if the data is delimited by commas.
    • In the Text Qualifier drop-down list, select the appropriate mark. The double quotation marks () is recommended.
  8. Review the lists in Service Groups, Divisions, and Lines/Line Groups frames and clear the check boxes of the items that you do not want to include in the export.
  9. Click the Execute Interface button:Execute interface button

    A Summary message box is displayed.

  10. Verify the information displayed and if necessary, change the selections that you made in the previous steps.
  11. Click OK.
The system produces the data in the selected folder, A message appears informing you that the process has been completed. When exporting to XML format, note that the apostrophes are shown as &apos instead of & #39.