This is an option in the Administration > Data Import > “Generic Case Note Import”.
This import process performs the following tasks based on the data provided:
- Create Notes record if it doesn’t already exist.
The import process then searches for an existing Episode (Case) record with an identifier that matches the “episode_key” value. If a match is not found, it then tries to match the “referral_key” value against the “ReferralId” field in the database. If found the existing record is loaded and updated to match the values provided. Otherwise, a new record is created and populated with the values provided.
Where lookup tables are used, the value being imported will be checked against both the ‘Code’ and the ‘Description’ in the lookup. This makes it easier to import without converting values.
Also, ensure the leading ‘0’ are on any dates in the ‘dd-MMM-yyyy’ format (example 09-Jan-2023)
The import process requires a set of values provided as an Excel spreadsheet or CSV file:
- ClientKey (external system generated identifier, will be stored as client custom identifier named “ClientKey”, required)
- CaseKey (Fixus Referral id eg ‘123456’, optional – if not provided then a unique random number is generated)
- May also be Fixus Case GUID, optional)
- ProgramCode (required – must match a configured generic program)
- NoteCreatedDate (Format: “dd-MMM-yyyy”, optional – if not provide then the current date & time will be recorded)
- NoteDate (Format: “dd-MMM-yyyy”, without time value optional)
- NoteAuthor (any text, not limited to current users or team members, optional)
- Subject – text of note subject (required)
- Note – text of note (required)
- Tags – comma-delimited list of any tags to be added to note (optional)
- DirectTime – integer of any time (in minutes) related to this note (optional)
- IndirectTime – integer of any time (in minutes) related to this note (optional)
- TravelTime – integer of any time (in minutes) related to this note (optional)
- Category – (must match values in “Generic_{Program Code}_Category” lookup table, optional)
- DeliveryMode – (must match values in “DeliveryMode” lookup table, optional)
Either an Episode Key or a Referral Id can exist. If both exist, the Episode Key will be used for the lookup. A list of errors will be shown prior to import.
The first row within the datafile must contain the column header values (see attached template, or use the above list of fields)
Check the attachments to this article for a sample import file. The template may also be downloaded from the Fixus Administration > Data Imports page after selecting the Import ‘Target’ type
Validation
During Import, the data will be validated to check required/optional values, formatting (eg Dates) and any expected values. Errors will be listed showing the details of the error and the row within the source file that caused the error.
*Note: Only those records that display an error have been excluded. ALL OTHER ROWS HAVE BEEN SUCCESSFULLY IMPORTED. This is important, under certain configurations simply fixing the invalid row(s) then re-importing may re-import the successful records and cause multiple records.
To avoid the creation of multiple records when re-importing data, make sure to provide either an Episode Key or Referral Key values. These will then be used to lookup the existing record and update with the values provided. A note is created for each episode record each time the import is run.