Exporting and Importing in any of the OSICS or Body Diagram Fields.

All of the OSICS and Body Diagram fields can now be exported and imported directly out and back into the system without manipulation. Previously, many of the fields needed to be altered before they could be imported back in.

This means users can do a straight export and import without having to use additional fields built that had to be built in to extract the data correctly for importing into the system. Note, as is the status quo, if the Form is set up with related entries, this should NOT be exported and imported.

This form contains examples of the different body diagram areas and OSICS codes

This form contains examples of the different body diagram areas and OSICS codes

Previously many of the injury or body diagram fields need to be pulled into calculations which added in a splits or a "|" before they could be imported in. Now, a straight export and import can be done without any manipulation

The excel file contains the fields in the correct format required for importing- no manipulation is required

The example here show that data is being imported back into the system

The example here show that data is being imported back into the system

Map the data accordingly

All of the data will import correctly. NOTE, there will now be extra rows in the Import Results output (as shown here). These are NOT errors. They are show the rows of data that were imported into the system as a single record, instead of multiple records (e.g one body diagram with three injuries, which are imported back in as one record, NOT 3).

The example here shows the newly imported data (it is a duplicate for demonstration purposes). Thus, each body areas has a count of 2, or 4 etc.

Looking at one athlete's data you can see the original and the import are the same

There are differences in the way that the data will be exported. Notably, each selected Area (for the Body Diagram) or OSICS code appears on a separate row in the table for that entry. Previously, if there were three selected injuries on one OSICS diagram, only the primary injury would be exported AND it would be copied to three rows!

There are differences in the way that the data will be exported. Notably, each selected Area (for the Body Diagram) or OSICS code appears on a separate row in the table for that entry. Previously, if there were three selected injuries on one OSICS diagram, only the primary injury would be exported AND it would be copied to three rows!

Note, the Body Diagram Summary and the Simple Body diagram concatenate selected areas into one row for the athlete history and exports.

0 Comments

Add your comment

E-Mail me when someone replies to this comment