IDRT Import and Mapping Tool (IDRT IMT)
When you first start the IMT, you will see a window similar to the screen dump below. Most windows within the IMT don't contain entries. IMT is an Eclipse-based application, so we will stick to their terminology, calling these windows "views".
The different views of the software are explained in detail in a separate wiki page.
First, you will have to define at least one staging server. A staging server is a connection to a database that hosts one or more i2b2 projects. As the name suggests, it will be the destination for data imports and other modifications.
When you add a staging server, you have to provide a number of parameters. Server configurations can be modified later and even exported/imported for backup.
If you click on a staging server, the IMT will show all i2b2 projects that the database account can read. i2b2 projects correspond to at least one database or schema and start with a leading string "I2B2".
Exits the program.
A Staging Server is an i2b2-Database-Server that is used to upload data to.
A Datasource Server is any Database-Server that is used to extract data from.
Add Staging I2B2Server...
Creates a new Staging Server.
Edit Staging I2B2Server...
Edits the selected Staging Server.
Delete Staging I2B2Server
Deletes the selected Staging Server.
New Datasource Server...
Creates a new Datasource Server.
Edit Datasource Server...
Edits the selected Datasource Server.
Delete Datasource Server
Deletes the selected Datasource Server.
Import Staging I2B2Server...
Let's you import a previously exported Staging Server.
Export Staging I2B2Server...
Let's you export the selected Staging Server.
It's a good idea to backup staging servers regularly. Additionally, export/import is useful for copying the configuration to another instance of the IMT.
Target Folder Name:
The root i2b2 folder name where your data get imported to.
The URL where your TMF PID generator is running (rarely used).
Export Log Location
The location where the log is stored after exporting it, e.g. /home/idrt/IDRTworkspace/logs/export.log
Activates extended logging
Syso Log Location
The location where the sys log is stored.
Filters i2b2 projects to exclude e.g. i2b2pm, i2b2hive, etc
Hide Temporary/Secondary Tables
Only for Oracle: hides temporary/secondary tables.
Show Total Number of Patients
Shows the c_totalnum in the Mapping Editor
The number of rows the CSV importer should check to guess the datatypes of the columns.
In some cases, specifying a Syso Log Location results in an empty and non-responding import browser view after restart. Closing the import browser view and reopening the view in the view menu solves the problem.
Here you find all IDRT Views. If you have closed a View, you can restore it here.
You can choose between two Perspectives.
Shows all available Views (default).
Shows only important Views.
Links to this wiki.
Report A Bug
Links to the IDRT GitHub.
Shows the About text.
Install New Software...
Opens a window where you can install new RCP plugins.
Updates the software.
The menu Options >> Add Regular Expression is not explained yet.
What is meant by "root i2b2 folder" (for the Menu Options section, Target Folder Name)? Is it the name of the schema where data is stored (e.g.
i2b2demodatain the Harvard demo image)? The root node of all the concept paths? A literal folder on the user's local file system that IMT uses?
Also, what are RCP plugins?
Datasource has a MSSQL DB Type. Staging Server does not. How can MSSQL be added to Staging I2B2 server?