Page History
...
3 new default rows are logged in RPDO_TABLE_REQUEST when user submits 1.8.1 data request. This will enable the 1.8.1 requests to be displayed on data request Manager panel along with 1.8.2 requests
RPDO_TABLE_REQUEST
Data file creation
1.8.2 Data file creation
...
| Info |
|---|
Wildfly must be restarted for changes to the HIVE_CELL_PARAMs to take effect. |
| Cell ID | Parameter Name | Example Value | Notes | ||||
| CRC | edu.harvard.i2b2.crc.exportcsv.datamanageremail | userid@partners.org | Email address used for sending request/export e-mails | CRC | edu.harvard.i2b2.crc.smtp.host | smtp.partners.org | SMTP host |
| CRC | edu.harvard.i2b2.crc.smtp.port | 25 | SMTP port | ||||
| CRC | edu.harvard.i2b2.crc.smtp.ssl.enabled | FALSE | TRUE will enable SSL | ||||
| CRC | edu.harvard.i2b2.crc.smtp.auth | FALSE | TRUE will enable SMTP authentication | ||||
| CRC | edu.harvard.i2b2.crc.smtp.username | none | SMTP username (required for SMTP authentication) | ||||
| CRC | edu.harvard.i2b2.crc.smtp.password | none | SMTP password (required for SMTP authentication) | ||||
| CRC | edu.harvard.i2b2.crc.smtp.enabled | FALSE | TRUE will enable | e-mails||||
| CRC | edu.harvard.i2b2.crc.smtp.from.fullname | Data Manager | Name that e-mails will be sent from. | ||||
| CRC | edu.harvard.i2b2.crc.smtp.from.email | datamanager@site.org | E-mail address thate-mails | will be sent from.CC | edu.harvard.i2b2.crc.smtp.subject | i2b2 Data Request | Subject line for e-mails.|
| CRC | edu.harvard.i2b2.crc.exportcsv.defaultescapecharacter | " | Escape character for export files | ||||
| CRC | edu.harvard.i2b2.crc.exportcsv.maxfetchrows | -1 | Maximum number of rows to export, or -1 for no limit | ||||
| CRC | edu.harvard.i2b2.crc.exportcsv.defaultlineend | \n | Line ending for export files | ||||
| CRC | edu.harvard.i2b2.crc.exportcsv.defaultseperator | \t | Field separator for export files | ||||
| CRC | edu.harvard.i2b2.crc.exportcsv.resultfetchsize | 50000 | Number of records retrieved during each database fetch. | ||||
| CRC | edu.harvard.i2b2.crc.exportcsv.filename | {{{PROJECT_ID}}}/{{{DATE_yyyyMMdd}}}_{{{FULL_NAME}}}.tsv | Parameterized template for export file names. If the extension is .zip, the file is zipped. | ||||
| CRC | edu.harvard.i2b2.crc.exportcsv.defaultquotechar | " | Quote character for export files | ||||
| CRC | edu.harvard.i2b2.crc.exportcsv.workfolder | /tmp/i2b2 | Folder on the i2b2 server for data exports | ||||
| CRC | edu.harvard.i2b2.crc.exportcsv.zipencryptmethod | none | Encryption method for the exported ZIP file. One of STANDARD, NONE, or AES. |
Software Changes:
- Data: New entries in RPDO_TABLE_REQUEST, HIVE_CELL_PARAMS, QT_QUERY_RESULT_TYPE, and QT_BREAKDOWN_PATH define the exporter configuration.
- Java code: New breakdown classes and updates to existing java classes to support the data exporter functionality.
...
