Order Question Import Tool
This wiki page is to document how Order Questions (AOE) data needs to be constructed in order to import using WebChart’s Order Questions Import Tool.
- File format: Data file shall be formatted in Comma Separated Values (CSV).
- The first row of the file shall contain column header information.
- Each subsequent row shall represent an order question.
- The Order Type is specified on the upload file form. Each item in the list will be imported to the order item that matches with the specified type.
The order question column definition shall contain all columns listed below regardless if there is a value or not.
- R = Required
- O = Optional
|Order code||char 30||R||The order code on which this question is to be asked when it is ordered.|
|Question code||char 30||R||Code that uniquely identifies the question.|
|Question||char 200||R||The Question to be asked.|
|Input Type||'T', 'Y', or 'R'||R||How the question is to be answered. The valid input types are (T)ext, (Y)esNo, and (R)adio button.|
|Answer List||char 1024||O||List of possible answers. Items must be separated by '|' (the bar/pipe character).|
|Asking display order||int 3||O||The order in which the questions are displayed.|
Examples of CSV
Order Question Example
This example shows how to import multiple order questions (AOE) into 1 order item with code ‘LAB5725’.
Order code,Question code,Question,Input Type,Answer List,Asking display order LAB5725,XN1,Type of Urine Collection,R,24 Hour|Random Specimen,1 LAB5725,XN2,Patient Fasting?,Y,,2 LAB5725,XN3,Source,T,,3
Sample CSV files
Here is a sample CSV file to download and view in a text editor or a spreadsheet program.