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.

(Optional) To suppress the warnings in the import log regarding attribute fields that cannot be found in the import database, select the FX > TSDEExport > Log attribute errors option in the Trace Options dialog in the Service Shell.
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 checkbox 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 dropdown 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. The following image shows some sample data that has been selected for export.
    Data Exchange Interface
    Note: TSDE Export only fills in the Stopnum on the Trip Times and Pattern Point files if the Line Point file option is selected. (If your transit site does not use Line Point files, do not select the Line Point file option.)
  5. In the Export interface(s) pane, click the ellipsis button in the Export Folder field.

    The Browse for Folder dialog 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 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 dropdown 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 dropdown 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 checkboxes 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.