We have extensive experience of importing information into OpenFIT, from heavy duty ETL type processes to the self-service outlined below. OpenFIT administrators can import Case, Client, Appointment, and Survey data into OpenFIT using a flat file format. Below example shows a data dictionary for importing Case, Client, Appointment, and ORS/SRS survey data.
| Column Name | Description |
|---|---|
| Service_Location | [Required] Name of the provider location |
| Provider_FirstName | [Required] First Name of the user (clinician) in your system |
| Provider_LastName | [Required] Last Name of the user (clinician) in your system |
| Provider_Email | [Required] Email address (unique and will be the username to login to OpenFIT) per clinician. If the user does not exist in OpenFIT, the process will create one with a default role (Clinician) and password. |
| Case_ID | [Required] An ID used to group sessions for a client(s) |
| Case_Date | [Required, Format (yyyy-MM-dd)] Start Date of this case |
| Session_ID | [Required] Sequential integer ID within the case (1,2,3, etc...) where 1 is the first session (sorted by date ascending) and so on. |
| Session_Date | [Required, Format (yyyy-MM-dd)] The session date (values sorted and linked to Session_ID as described above) |
| Client_Gender | [Required] One of (Male, Female, Transfeminine, Transmasculine, GenderExpansiveNonBinary, TwoSpirit, Questioning, DeclinedToState, AdditionalCategory) |
| ORS_Skip | [Required] One of (Y, N) where Y skips the scores |
| Total_ORS | [Optional, Decimal] Total ORS Score (if individual scores not provided, total will be divided by 4) |
| Notes | [Optional] Text will be saved once the system creates a Case (Episode) |
If you have custom fields set up in OpenFIT, contact us at support@acehealth.co, and we will provide you with the column names to import custom field data.
Template import file
You can download the template definition file from here. Please note you must have an OpenFIT administrator account to download the file.