DataBridge – Import/Export Data

Menu path: Data Management > DataBridge

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

This makes it possible to import data to TimeSheet Reporter and export data from TimeSheet Reporter, which you can then use in your other applications, for example your CRM system, accounting system or Microsoft Excel.

TSR DataBridge can be run via the web interface, or via command line operations, for example via scripting.

Overview:

Export Data
Import Data
Command Line Interface

Export Data

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

Step 2: Click on “Create new” to create new export profile, or select an existing one.

Step 3: Fill out the form and select which kind of data that you'd like to export (for example time entries).

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

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

Step 6: Export, Preview or Save.

If you want to preview the exported result, input the necessary information and then click “Preview”. Otherwise, click “Export”. You can also save the profile for later use, by clicking “Save.”
By clicking “Export” it will create a CSV file for you, with the relevant data, which you can download.

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

Back to overview

Import Data

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

Step 2: Click on “Create new” to create new import profile, or select an existing one.

Step 3: Fill out the fields in the form.

“Source Application ID” is used to identify the source you import from, for example “SAP”.

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

Step 6: Import or Save.

Save the profile for later use, by clicking “Save.”
By clicking “Import” it will import the data to TSR.

Note: The date format when importing, will use the user’s settings.

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:

-i|-e “ProfileName” [-f <file_path>] [-a] [-from <start_date> -to <end_date>]

Options:
-e Export data to TSR database to CSV file by an available profile
-i Import data from CSV file to TSR database by using an available profile
-a Update all TSR records when importing data
-f <file_path> Full path of file
-from <start_date> -to <end_date> Start date and end date, when exporting time entries. Format must be yyyy.mm.dd.

To get the TSR DataBridge Runtime, please contact Support.