Create PFT Data File for Import

This document explains how to import your pulmonary function testing data into WebChart .
What you will need:

  • Spreadsheet software (Microsoft Excel or Google Sheets)
  • PFT Data CSV File Example

WebChart

  • end user with administrative rights

Create PFT Data CSV File

  1. The following table provides optional or required Field Names and Descriptions, as indicated by the Requirement column. Items marked as Best Practice or Optional are not required and may be left blank, or omitted entirely. Employee ID must be the first column in the CSV file. The order of the remaining fields does not matter.
Field NameDescriptionRequirementData File Column Header
Employee IDEmployee Identifier. This field will be used for looking up the chart in WebChart , to insert or update.Requireddocuments.pat_id
External IDThis is a unique identifier typically populated by third-party interfaces from which the document originated.Requireddocuments.ext_doc_id
Test DatetimeWhen (datetime) the PFT was performed. Must be formatted as YYYY-MM-DD HH:MM:SSRequiredpft.test_datetime
PFT Maneuver DatetimeDatetime of PFT maneuver. Must be formatted as YYYY-MM-DD HH:MM:SSRequiredpft_maneuver.meneuver_datetime
FVCRecords the forced vital capacity (FVC) , the total volume expelled from lungs. Enter volume in milliliters (mL).Requiredpft_maneuver.fvc
FVC PredictedRecords the predicted value for FVC. Enter volume in milliliters (mL).Optionalpft_maneuver.fvc_predicted
FEV1Records the forced expiratory volume (FEV). Enter volume in milliliters (mL).Optionalpft_maneuver.fev1
FEV1 PredictedRecords the predicted value for the FEV for the first second of the test. Enter volume in milliliters (mL).Optionalpft_maneuver.fev1_predicted
FEF25%-75%Records the forced expiratory flow (FEF) from 25% to 75% of test, or the middle 50% of test. Enter volume in milliliters (mL).Optionalpft_maneuver.fef25_75
FEF25%-75% PredictedRecords the predicted value for FEF from 25% to 75% of test. Enter volume in milliliters (mL).Optionalpft_maneuver.fef25_75_predicted
FEV1/FVCRecords the lower limit of normal for the first second of FEV over the FVC.Optionalpft_maneuver.fev1_fvc
FEV1/FVC PredictedRecords the predicted value for the first second of FEV over the FVC.Optionalpft_maneuver.fev1_fvc_predicted
PEFRecords the lower limit of normal for PEF. Enter volume in milliliters (mL).Optionalpft_maneuver.pef
PEF PredictedRecords the predicted value for PEF. Enter volume in milliliters (mL).Optionalpft_maneuver.pef_predicted
SpirometerModel of spirometer.Optionalpft.spirometer
InterpretationInterpretation of a test (by device).Optionalpft_maneuver.interpretation
CommentFree text comment for PFT. This field may be repeated in the CSV file. Comments would be handled in-order and separated by a newline.Optionalpft.comment
Tip
For a more comprehensive list of supported fields, please refer to the PFT Data CSV API Specification
  1. Using the table, above, determine the data to be imported. Starting with the Employee ID field, enter all required and desired data, verifying required data is present. Note that each row represents a pulmonary function test record. Below is a screenshot of the PFT Data CSV File Example for guidance.

  1. Save the file as CSV format.

Upload PFT Data CSV File

  1. Login as a user with administrator rights.
  2. Navigate to the Control Panel from the side menu.

  1. Select the Data Import tab.

  1. Select PFT Data CSV API from the drop-down menu and click Go.

  1. Select the PFT Data CSV File and click Upload.

Tip
For extra information on what happens during the import, click the Verbose* checkbox.*

Resources

Troubleshooting

Ensure that all of the fields marked as Required have valid content. The file uploaded must be saved as a CSV formatted file. In case of any errors, contact Technical Support.


WebChart Documentation

Page Created:
Last Updated:
Last Build: Fri, 03 Feb 2023 13:52:14 EST
WikiGDrive Version: 6c6f21d9d0a63cb86fd32dec4cec30d4b470cbf5