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.

Column Definition

The order question column definition shall contain all columns listed below regardless if there is a value or not.

  • R = Required
  • O = Optional
NameTypeRequiredComments
Order codechar 30RThe order code on which this question is to be asked when it is ordered.
Question codechar 30RCode that uniquely identifies the question.
Questionchar 200RThe Question to be asked.
Input Type'T', 'Y', or 'R'RHow the question is to be answered. The valid input types are (T)ext, (Y)esNo, and (R)adio button.
Answer Listchar 1024OList of possible answers. Items must be separated by '|' (the bar/pipe character).
Asking display orderint 3OThe 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. File:Order questions.csv


WebChart Documentation

Page Created:
Last Updated:
Last Build: Mon, 14 Nov 2022 01:22:36 EST
WikiGDrive Version: 64fa77a2dd4586094b6074a78ed6769886b60894