Page History
...
Export File generation parameters are configurable in the HIVE_CELL_PARAMS
HIVE_CELL_PARAMS entries
| CRC | edu.harvard.i2b2.crc.exportcsv.datamanageremail | userid@partners.org |
| CRC | edu.harvard.i2b2.crc.smtp.host | smtp.partners.org |
| CRC | edu.harvard.i2b2.crc.smtp.port | 25 |
| CRC | edu.harvard.i2b2.crc.smtp.ssl.enable | FALSE |
| CRC | edu.harvard.i2b2.crc.smtp.auth | FALSE |
| CRC | edu.harvard.i2b2.crc.smtp.username | none |
| CRC | edu.harvard.i2b2.crc.smtp.password | none |
| CRC | edu.harvard.i2b2.crc.exportcsv.defaultescapecharacter | " |
| CRC | edu.harvard.i2b2.crc.exportcsv.maxfetchrows | -1 |
| CRC | edu.harvard.i2b2.crc.exportcsv.defaultlineend | \n |
| CRC | edu.harvard.i2b2.crc.exportcsv.defaultseperator | \t |
| CRC | edu.harvard.i2b2.crc.exportcsv.resultfetchsize | 50000 |
| CRC | edu.harvard.i2b2.crc.exportcsv.filename | /tmp/{{{PROJECT_ID}}}/{{{DATE_yyyyMMdd}}}_{{{FULL_NAME}}}.tsv |
| CRC | edu.harvard.i2b2.crc.exportcsv.defaultquotechar | " |
| CRC | edu.harvard.i2b2.crc.exportcsv.workfolder | /tmp/i2b2 |
| CRC | edu.harvard.i2b2.crc.exportcsv.zipencryptmethod | none |
Java Changes
include a new breakdown class for the file export process.
Flow chart
...
Request/Export Process:
- End user logs into webclient and creates a patientset query
- Selects a Data Request option and
- Click run Query
- Email is sent to manager user to run the user request
- The manager logs into the webclient and finds the run query by matching the query master id
- Manager user then re-runs the previous query and clicks on export. The export option is displayed selected in the Data export breakdown.
- Data export runs in the background and file is generated in the folder specified in the HIVE_CELL_PARAM
- Manger user manually sends a confirmation email to the user on the file generation and retrieval info.
Display for End User
Display for Manager user
...
