Skip to content

Latest commit

 

History

History
220 lines (195 loc) · 7.81 KB

create-audiometric-data-file-for-import.md

File metadata and controls

220 lines (195 loc) · 7.81 KB
id title date version lastAuthor mimeType links source wikigdrive
1pqlmPPQPZeiKt_N7XDccPfdFT5zLskxOKriIx-Nc8W4
Create Audiometric Data File for Import
2020-03-17T02:43:45.578Z
43
text/x-markdown
0008bcbb1563384efe0a28ada6f97e9432e65f10

This document explains how to import your historical audiometric testing data into {{% system-name %}} .

What you will need:

  • Spreadsheet software (Microsoft Excel or Google Sheets)
  • Audiometric Data CSV File Example
  • {{% system-name %}} end user with administrative rights

Create Audiometric 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 Name Description Requirement Data File Column Header
Employee ID This identifier will be used for looking up the chart in {{% system-name %}} , to insert or update, and must match an Employee ID from the Employee Demographic Import specification. Required documents.pat_id
External ID This is used for {{% system-name %}} systems. Typically this is the auto incrementing column from the legacy DB or populated by third-party interfaces. Required documents.ext_doc_id
Test Datetime When the test was conducted (datetime), in YYYY-MM-DD HH:MM:SS format. Required audio.test_datetime
Left 500 Hz Result for the left ear 500 Hz test in dB. Best Practice audio.left05
Left 1 kHz Result for the left ear 1 kHz test in dB. Best Practice audio.left1
Left 2 kHz Result for the left ear 2 kHz test in dB. Best Practice audio.left2
Left 3 kHz Result for the left ear 3 kHz test in dB. Best Practice audio.left3
Left 4 kHz Result for the left ear 4 kHz test in dB. Best Practice audio.left4
Left 6 kHz Result for the left ear 6 kHz test in dB. Best Practice audio.left6
Left 8 kHz Result for the left ear 8 kHz test in dB. Best Practice audio.left8
Right 500 Hz Result for the right ear 500 Hz test in dB. Best Practice audio.right05
Right 1 kHz Result for the right ear 1 kHz test in dB. Best Practice audio.right1
Right 2 kHz Result for the right ear 2 kHz test in dB. Best Practice audio.right2
Right 3 kHz Result for the right ear 3 kHz test in dB. Best Practice audio.right3
Right 4 kHz Result for the right ear 4 kHz test in dB. Best Practice audio.right4
Right 6 kHz Result for the right ear 6 kHz test in dB. Best Practice audio.right6
Right 8 kHz Result for the right ear 8 kHz test in dB. Best Practice audio.right8
Left STS Standard threshold shift from last baseline test for the left ear. Options include: Yes or No. Best Practice audio.left_sts
Right STS Standard threshold shift from last baseline test for the right ear. Options include: Yes or No. Best Practice audio.right_sts
Left Baseline Flags the test as a baseline for the left ear. Options include: Yes or No. Best Practice audio.left_baseline
Right Baseline Flags the test as a baseline for the right ear. Options include: Yes or No. Best Practice audio.right_baseline
Calibration Date Records the last date (datetime) the audiometer was calibrated, YYYY-MM-DD HH:MM:SS format. Best Practice audio.calibration_date
Comment Free text comment regarding the test. Multiple comments may be specified. They will be separated by newlines in the comments section of the audiogram. Optional audio.comment

{{% tip %}} For a more comprehensive list of supported fields, please refer to the Audiometric Data CSV API Specification. {{% /tip %}}

  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 an audiometric testing record. Below is a screenshot of the Audiometric Data CSV File Example for guidance.

  1. Save the file as CSV format.

Upload Audiometric 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 Audiometric Data CSV API from the drop-down menu and click Go.

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

{{% tip %}} For extra information on what happens during the import, click the Verbose* checkbox.* {{% /tip %}}

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.