Using TSDE Import

Importing data refers to processes such as loading a file, text, or data prepared with one application into another application while exporting data is the process of sending data from one application to another application.

The TSDE Import functionality includes:
  • Accepting having the stops before nodes or nodes before stops in the pattern point files
  • Using a single RunId in the MasterRun table for all TSDE Records with the same Service/Division/Run Number
  • Preventing the insertion of the same relief opportunity more than once into the Trip Times table after a run with different exceptions has been cut at the same point
  • After importing line stops and copying stops from another sign-up period, it matches the patterns of the source sign-up period. If line points are not imported, it merges the matching stops in a manner similar to how stop patterns are merged.
  1. To open the Data Exchange screen, click Task > Data Exchange.
    By default, the TSDE Import screen is displayed.
  2. In the Import interface(s) pane in the Data Exchange screen,

    • Custom Convert - Allows you to convert data, which is in a third party format, to Trapeze format in order that you can import the data.

    • TSDE Import - Allows you to import basic scheduling data such as stops, lines, trips, and blocks.

    • TSDE Import Run and Roster - Allows you to import scheduling data and runs and roster data.
      Data Exchange Tab
  3. In the Import interface(s) pane, select the TSDE Import checkbox.
    Additional fields are shown on the right pane and below the Import interface(s) pane.
    Import Interfaces Pane
  4. Click the ellipsis button beside the Import Folder field.

    The Browse for Folder dialog appears.

  5. Select the folder containing the files created in the export process, and then click OK.
    The Subset to Import frame in the right pane is filled in with the lines, services, and other optional data contained in the selected files.
  6. Click the ellipsis button beside the Log File field.

    The Browse for Files or Folders dialog appears. Create a log file for the import process. The path to the file is displayed.

  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.

    • 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 list, select the appropriate mark. The double quotation marks () is recommended.

  8. (In a multi-agency environment) In the Agency list, select the agency from which you want to import data.
  9. In the Import into dropdown list, select the sign-up period to which you want to import.

    • To import into a new sign-up period, choose <New Signup>.

    • To import into an existing sign-up period, choose the sign-up period from the dropdown list. Click the Detail ellipsis button.
    The SignUp Details dialog displays information on the selected sign-up period.
    Signup Details dialog box
  10. Change the From Date and Time Date if you only want data from a specific time period. Type a comment in the Comments field as necessary. Click OK.
  11. Optional: To copy stops data from another sign-up period:
    1. On the right pane, select Copy stops from other Signup Period. If selected, the system copies stops data from another sign-up period. For example, choose this option if you require the stops data since you only have exported nodes data.
    2. In the Signup dropdown list, select the sign-up period from which you want to copy.
    3. In the Match Pattern By dropdown list, choose how you want to identify the patterns from which the stops will be copied:
      • Nodes - Copy from patterns with the same nodes as the pattern to which it is copied.
      • Pattern Name - Copy from patterns with the same pattern name.
    4. In the Match Nodes by First _ Characters field , type the number of characters by which nodes are identified. For example, if the following node names exist: ABCN, ABCS, ABCE, and ABCW and the field is set to 3, data of all the nodes that start with ABC are copied. The system ignores the characters after the set number.
  12. Optional: To copy data other than stops from another sign-up period:
    1. On the right pane, select Copy data from other signup period - If selected, you can choose the data that you want to import in the Copy data from other signup dialog.
    2. In the Signup dropdown list, select the sign-up period from which you want to copy.
    3. In the Copy Options dropdown list, select the data elements that you want to copy and then, click OK.
  13. Optional: To modify the subset of data to be imported, select or clear the appropriate line/directions, services, or other options in the Subset to Import pane.
  14. In the Match Stop by dropdown list, select how you want the stops matched: Id or Abbr. If the data being copied has an ID or Abbr that matches the data it is being copied into, it overwrites the data.
  15. Optional: Select Create Unique StopAbbrs to change names of duplicate Stop Abbrs of the data being copied. For example, Stop EXPO for Line 1 and Stop EXPO for Line 10 are changed to Stop EXPO1 and Stop EXPO2, respectively.

    A suffix is added to the abbreviations to make the stop abbreviation unique.

  16. Click the Mapping Stop Attributes button.
    The Mapping Stop Attributes dialog is displayed. The Attribute Name column shows the stop attributes from the source data. The FieldName column contains Trapeze field names as in the Stops table. The FieldLabel column contains the name of the field as it appears in the Trapeze application.
  17. Click a field in the FieldName column and select the appropriate matching attribute from the list.
    If supplementary information has been updated in the Trapeze application, that is, user fields renamed, the field label is shown and can be selected from the Field Label list. If the field name is selected from the FieldName list, the FieldLabel and FieldType fields are automatically filled in.
  18. After completing the list of attributes, click OK.
  19. To save all of the import settings for future imports, click the Save button and save the ini file.
  20. Optional: To load a set of saved import settings, click Open and select an ini file.
  21. To run the TSDE Import, click Execute Interfaces: Execute Interfaces button
The data of the new sign-up period is loaded into the destination database.