Developers Getting Started With i2b2
Space shortcuts
Space Tools
Developers Getting Started With i2b2 getstarted

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

QT_BREAKDOWN_PATH defines e-mail content (for request and export) and SQL code (for export) in the following XML format:

NameValue
  • <request name>_REQUEST defines the request email generation parameters. 
  • Request email can be configured in PM_USER_DATA parameters to define the email address of the User.
  • Data Manager gets the request email (configured in the HIVE_CELL_PARAMS)

<?xml version="1.0"?>
<ValueExporter>
  <Version>[...version number...]</Version>
  <CreationDateTime>08/09/2024 12:00:00</CreationDateTime>
 

<RequestLetter>

<RequesterEmailMessage>[...details sent to User on data request...]  </

RequestLetter>

RequesterEmailMessage> <DataManagerEmailMessage>[...details sent to data Manager on user data request...]</DataManagerEmailMessage>
</ValueExporter>

  • <request name>_CSV defines the data export email parameters and the SQL to for the export file generation.   
  • The data export email has detailed info on the file location and access info.
  • The exported file is generated in a secure location on the local drive along with the data export email file in a zipped folder
  • Email content and export SQL are configurable in the XML entries for the request/export in the Value parameters.
  •  Multiple SQL statements can be configured in the Value <file></file> tags as one SQL statement per file tag
<?xml version="1.0"?>
<ValueExporter>
  <Version>[...version number...]</Version>
  <CreationDateTime><date value></CreationDateTime>
 
<RequesterEmailLetter>details
<DataManagerEmailMessage>details sent to data Manager on data request</
RequesterEmailLetter>
DataManagerEmailMessage>
    <LetterFilename><name of the file></LetterFilename>
  <Letter> <letter content></Letter>
 
<Table>
<File>
<Filename>filename</Filename>
<Query>[... SQL query to generate the data export content...]</Query>
      <SeparatorCharacter>[...file format seperator...]</SeparatorCharacter>
  </
Table>
File>
</ValueExporter>


Info

The data manager receives both the requester email and the data export email confirmation which can be forwarded to the User that initiated the request.

...

Developers Getting Started With i2b2 getstarted