Official website: English | Dansk | Deutsch

DataBridge – Import/Export Data

Menu path: Data Management > DataBridge > DataBridge Setup

TSR DataBridge allows user to import/export data from/to other systems via csv files.

 

Overview:

 

 

 

Export Data

This video shows how to export data from TSR with DataBridge.

For more details, also on how to import, please see below.

Step 1: Select “Export” in the “Action Type” drop down list.

image008

Step 2: Click on “Create new” to create new export profile.
Step 3: Fill out the form.

image010

Step 4: Click on “Show select fields” to select the fields that you want to export, and optionally limit the length of each field.

image012

Step 5: Click on “Show search criteria” further down the page, to choose search criteria for the export.

image014

Step 6: If you want to preview the exported result, input the necessary information and then click “Preview”. Otherwise, click “Export”.

 

Back to overview

 

 

Import Data

Step 1: Select “Import” in the “Action Type” drop down list.

image002

Step 2: Click “Create new” to create a new import profile.
Step 3: Fill out the fields in the form.
“Source Application ID” is used to identify the source you import from, for example “SAP”.

image004

Step 4: Click on “Display columns mapping” to map fields from your file with the TSR database.

image006

Step 5: Click the “Import” button to start importing data.

 

Back to overview

 

 

Search Import/Export Profiles

Step 1: Select Action Type.
Step 2: Enter keyword to search for.
Step 3: Click on the “Search” button, and then “Select” to use the corresponding profile.

 

Back to overview

 

 

Command Line Interface

The import/export feature can be performed by a command line tool called TSRDBRUN.exe in the “TSR Command Line” folder.

The syntax is:

TSRDBRUN.exe -i|-e “ProfileName” [–f <file_path>] [-a]

-i: import data using a profile
-e: export data using a profile
“ProfileName”: Name of the profile created in TSR
-f: indicate file path (optional). By default, the tool use current folder to search for the profile
<file_path>: Full path of the profile name
-a: update all records in TSR when importing data (optional). By default, the tool will ask when updating an existing record in TSR.

 

To get the TSR DataBridge Runtime, please contact Support.

 

Back to overview

 

 

Leave a Reply

More about TSR

Microsoft Windows Certified

Microsoft Windows 7 and 8 Certified