Developers Getting Started With i2b2
Space shortcuts
Space Tools

Versions Compared

Old Version 78

changes.mady.by.user Reeta Metta

Saved on

compared with

New Version 79

changes.mady.by.user Reeta Metta

Saved on

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.

...