Importing in exported injury or illness records

Many of the injury and illness field types can be exported out of the system and imported back in, including:

  • Body Area Summary
  • OSICS Injury Diagram
  • OSICS Diagram with Medical

Please note that during an export and a re-import, ONLY the primary injury or illness is mapped across, and you will need to manually update the secondary or tertiary injuries or illnesses for any records that have them

However, two of the illness and medical field types need to be reconfigure BEFORE they can be imported in, these are:

  • OSICS Medical Diagram (to import correctly, you will need to optimise your Event Form to pull out the type of Medical code and this needs to be added to the codes)
  • OSICS Illness Diagram (to import correctly, Medical Illness needs to be added to the codes)

The steps below outline how to reconfigure the data for import.

Most of the injury and illness codes can be exported and imported into the system with any reconfiguration. However, some of the records do need to be adapted for importing

When injury or illness data is exported out of the system and imported back in, the import results may look as though the codes have imported correctly. However, when the Form is opened the specific field may be empty. This means the import format was incorrect, and the data needs to be deleted and re-imported.

An example of using the medical illness codes without reformatting them; it will result in no illness appearing in the record

An example of using the medical illness codes without reformatting them; it will result in no illness appearing in the record

The data looks to import correctly, but when an imported record is opened, the illness code is missing. This is because it needed to be reformatted

To ensure the Illness Codes import correctly, you need to add in Medical Illness to the exported codes.

To ensure the Illness Codes import correctly, you need to add in Medical Illness to the exported codes.

The exported codes for the Medical Illness file need to have the words "Medical Illness" added to the start of the code. This example here shows that the exported code of MVXX Environmental Illness, has been changed to Medical Illness MVXX Environmental Illness.

To do this a separate column was set up, and the original code was set to concatenate with "Medical Illness " (note the space at the end of Illness).

Now when the import is done, select the new import column to map to the Illness Codes

Now when the import is done, select the new import column to map to the Illness Codes

The data will import and appear in the athlete history/reports

When the form is opened, the Illness Code should display as expected. If it doesn't then you may have mapped the wrong column, or you may not have set up the concatenate correctly.

When the form is opened, the Illness Code should display as expected. If it doesn't then you may have mapped the wrong column, or you may not have set up the concatenate correctly.

To import in data for the Medical Code field, this needs changes to the  event form. Unfortunately, for this work around, you will need to add in new fields into the form.

To be able to import in data for the Medical codes you will need to add in calculations into your medical form which split out the type of field it is, and then this field will need to be concatenated with the code before re-import.

Take the first split to be able to identify the codes for the next option calculation (in the step below this one)

Take the first split to be able to identify the codes for the next option calculation (in the step below this one)

These are the options to be used in the interim hidden calculation, which splits out the type of data that is being exported:

  • Abnormalities
  • Paediatric
  • Disabled
  • Post
  • Medical
  • Consultations

Then add in the first split of the Medical Field name

Next, build in an Option Calculation to output the Type of Medical Code that will be used when you re-import the data back in

Next, build in an Option Calculation to output the Type of Medical Code that will be used when you re-import the data back in

The Options that you need to use are:

  • Abnormalities
  • Paediatric Diagnoses
  • Disabled Athlete Injuries/ Illnesses
  • Post Surgical Patient
  • Medical Illness
  • Consultations Where There is No Presenting Illness Needing Treatment

The Option Calculation is:

If (contains(Medical Type hidden, "Abnormalities"), "Abnormalities",

If (contains(Medical Type hidden ,"Paediatric"), "Paediatric Diagnoses",

If (contains(Medical Type hidden, "Disabled"), "Disabled Athlete Injuries/ Illnesses",

If (contains(Medical Type hidden, "Post"), "Post Surgical Patient",

If (contains(Medical Type hidden, "Medical"), "Medical Illness",

If (contains(Medical Type hidden, "Consultations"),

"Consultations Where There is No Presenting Illness Needing Treatment",

" "))))))

 

N.B. to get these to recalculate, you will need to run resave on this data. Check for the optimal times to do this.

This means, that when you export out your data, you can then concatenate the Medical Type with the Medical Code -ready for re-import

The Medical Code (e.g., YWXX Post Wrist/ Hand Surgery) is concatenated with the Medical Type (e.g. Post Surgical Patient) to become Post Surgical Patient YWXX Post Wrist/ Hand Surgery

Note, for the concatenate, The Medical Type is added before the code, and a space is used between the two fields =CONCATENATE(N2," ",L2)

When you import the data back into the system, use the reformatted column

When you import the data back into the system, use the reformatted column

The data will import and appear in the athlete history/reports

The data will import and appear in the athlete history/reports

When the form is opened, the Medical codes should all displaying correctly; an example of every Medical Type

When the form is opened, the Medical codes should all displaying correctly; an example of every Medical Type

If you have any questions or concerns, please check BEFORE you try and import or delete any data!

0 Comments

Add your comment

E-Mail me when someone replies to this comment