Page History
...
Name | Description |
---|---|
Truncate i2b2 Project? | If you check this, the project will be truncated before the data is uploaded. |
Truncate Previous Queries? | This will truncate the previous queries tables. |
Database Indexing | Ignore: Don't touch the indexes; |
Set patient_count after import | This will fill the c_totalnum column. |
CSV Folder | Here you can select the folder that contains all CSV files you want to upload. |
Use PID Generator | This will use the PID Generator, which has to be configured seperately (see Options). |
IDAT Options | Select whether your identifying data is in the same or in an extra file. |
ID-File | Select the identifying data file here. |
Date Pattern | Here you can select the date pattern that your data uses (e.g. dd-MM-yyyy). |
Quote Character | Here you can set the quote character, that you use in your CSV files. |
Save Settings? | This will save the settings for the next import. Note: The truncate checks are never saved. |
TODO PAGE 3
If you Set your variables and continue to page 3.
On the left hand side you can see all csv files in the selected directory. A green check mark lets you know, that a config file has been found. If there is currently no config file present, a red X is shown. On the right hand side the configuration for the selected csv file is shown. The table consists of five columns:
Item: The column name in the csv file.
Name: The name, the item should have in i2b2. You can e.g. rename cryptic column names.
Tooltip: The tooltip the item should have in i2b2. You can set a tooltip for better understanding, or the unit of an item for example.
Datatype: The datatype the item has. You can select either Integer, Float, Date, or String.
Metadata: This tells the Import Browser, where to look for specific items, such as the id of the patient, the import date, start date and so on. Y
Note |
---|
The metadata item PatientID/ObjectID has to be present in each configuration file. Without it, the Import Browser won't let you continue and displays an error. |
ou can also ignore items. These will not end up in the i2b2 database.
Note |
---|
The ObjectID is the same as the PatientID, but the file is imported using modifiers instead. This way more than one row per patient is allowed. |
Name of the Button | Description |
---|---|
Headline | If your CSV file does not start directly at the beginning, you can set the starting row here. |
Clear Table | This will delete your configuration for the selected file. |
Guess Schema | You can let the Import Browser try to guess the schema of the file. You can set in the Options how many rows the Import Browser should look through. |
Guess All Schemata | This will guess the schema for all files in the directory. |
If you hit finish the upload starts. You can observe the progress in the progress bar of the Import Browser.