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
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
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!
0 Comments
Add your comment