How can I import events from my EMR?

See Events for more information on events.

The powerful feature described here allows you to import events from excel or your EMR into Audiqueen. This can be useful for further processing in Audiqueen Analytics. The events should come as a CSV file. If your EMR contains events, you can ask your system administrator to generate the corresponding CSV file.

Each line of this CSV file should be structured as follows:

ID; Event; EventDate [S]

• The default separator is ; (This can be changed, but each line must have two separators)
• ID = unique patient identifier of the hospital EMR
• Event= keyword belonging to this patient
• EventDate= date of the event
• [S] = side to which the keyword applies (optional)
• The default values are 0 for right, 1 for left, and 2 for bilateral, but these codes can be changed if need be.

You can either make an excel with a list of patient numbers and events or query your EMR for patients who underwent certain events, export the required information in MS Excel, save this as a CSV file and import the entire list in Audiqueen.

Example: The file Surgery.csv contains 3 surgical events 
for 3 different patients.

Now open the tool in Event Manager and import the CSV file.

An events CSV file is selected (1) and Audiqueen generates a preview of its content (2).

Through Event Type Mapping, Audiqueen then tries to convert the EMR events into Audiqueen events.

In the Event Type Mapping Window, Audiqueen shows a list of EMR events (1), consisting of known (previous) EMR events, and how they are converted to Audiqueen events (2).  The user can also see the current events to be imported (3), that have not yet been mapped to Audiqueen events. You can map these ‘orphan’ events by selecting an event from the list (4) and moving it to the conversion table with the arrow (5).

In this example, T-tube is mapped to Ventilation tubes and Otoplasty to Otoplasty. The EMR event Cochlear Implant is not mapped, which means that it will not be imported into Audiqueen.

After importation, the events appear in the Audiqueen records.

This feature is not available in the web viewer.