Please read the general Importing Data into Crisisworks instructions before proceeding with importing Recovery Cases.
Importing Recovery Cases
From the "What do you want to import?" drop down list on the Import Form, select the Cases option and click on the Next button.
You will then be presented with a list of import options associated with Cases. Choose the Recovery Case Import option.
You will need to upload a file in CSV format with a list of Recovery Cases to import.
To import changes to existing cases, it may be easier to export them to a report first by selecting the appropriate cases in the Recovery Case datagrid and clicking Export to Report. Once the report has been run, you can then click the "To CSV" button. This will generate a CSV file that is compatible with the import system. Make any necessary changes to the records in the CSV file, save it and choose this file to import.
Alternatively, you can download the sample Recovery Case Import CSV file below and base your import on this file.
Applicant Data
You can add related applicant data to your case by adding the applicant fields to your input spreadsheet. If you want to update an existing applicant that is associated with a case, you must supply the "Applicant Contact ID" field in your spreadsheet. This ID needs to match the Crisisworks ID of the applicant and is exported via the Export to Report feature.
Alternatively, if you don't specify an Applicant Contact ID in your input file, a new applicant will be created for the case.
Please note: imports cannot be undone once they are imported. However, you can specify an optional tag to add to each record so you can identify all imported records.
CSV File Format
The following CSV fields & rules are needed for the import to work.
Download the Recovery Case sample CSV import file
| Field | Description |
|---|---|
| Case ID | Relates to the ID field for a Recovery Case record. If specified, it will attempt to find a match and if one is found it will update the case. To add new cases, either do not have this field in your spreadsheet or set it to blank. |
| Asset | Sets the Asset to a property by matching on either code or address. You can enter either the code or the asset address into this field. |
| Applicant Contact ID | The Crisisworks ID of an existing applicant. You only need to specify this to update an existing applicant. |
| Applicant Contact Type | Set to individual or organisation. |
| Applicant Family Name | Family name of the applicant |
| Applicant Given Names | Given names of the applicant |
| Applicant Age | Age of the applicant (numbers only) |
| Applicant Gender | Set to M, F or O |
| Applicant Organisation Name | The applicant's organisation if the applicant is an organisation |
| Applicant Position | The applicant's position in the organisation |
| Applicant Phone | The applicant's phone number |
| Applicant Mobile | The applicant's mobile phone number |
| Applicant Email | The applicant's email address |
| Applicant Language | The applicant's language if an interpreter is required |
| Applicant Preferred Method of Contact | Set to either Phone, Email, Post or None. |
| Applicant Postal Type | Set to either Case, Other or Temporary |
| Applicant Postal Street | The applicant's postal street (if the postal type is set to Other) |
| Applicant Postal Town | The applicant's postal suburb/town (if the postal type is set to Other) |
| Applicant Postal State | The applicant's postal state (if the postal type is set to Other) |
| Applicant Postal Postcode | The applicant's postal postcode (if the postal type is set to Other) |
| Applicant Postal Country | The applicant's postal country (if the postal type is set to Other) |
| Is Applicant Attending Relief Centre? | Is the contact currently attending a relief centre. This must be set to Yes or No. |
| Relief Centre | This is based on the relief centres entered into your Crisisworks via the Mecc Lookup. Enter the label of the lookup. Note, for this field to be set, the attending Relief Centre field needs to be set to Yes. |
| Does Applicant Have a Temporary Address? | Set to Yes or No |
| Temporary Address Street | The applicant's temporary street. Note for this field to be set, the hasTemporaryAddress field needs to be set to Yes. |
| Temporary Address Town | The applicant's temporary town. Note for this field to be set, the hasTemporaryAddress field needs to be set to Yes. |
| Temporary Address State | The applicant's temporary state. Note for this field to be set, the hasTemporaryAddress field needs to be set to Yes. |
| Temporary Address Postcode | The applicant's temporary postcode. Note for this field to be set, the hasTemporaryAddress field needs to be set to Yes. |
| Temporary Address Country | The applicant's temporary country. Note for this field to be set, the hasTemporaryAddress field needs to be set to Yes. |
| Temporary Address Notes | Any notes regarding the applicant's temporary address. Note for this field to be set, the hasTemporaryAddress field needs to be set to Yes. |
| Case Sharing Level | Whether the applicant consents to sharing their personal information. Set to either Full, None or NotYetAsked. Will default to None. |
| Fixed Home Address | Set the option indicating the applicant has an affected property in the municipality. Set to either Yes or No. |
| Case Property Details | Enter any property details if required. This is a free text description field. |
| Case Property Use | This is based on the Property Type entered into your Crisisworks via the Mecc Lookup. Enter the label of the lookup. |
| Applicant Relationship to Property | This is based on the Case Relationship to Property entered into your Crisisworks via the Mecc Lookup. Enter the label of the lookup. |
| Property Insured | Is the property insured? Enter Yes, No or Unknown. |
| Case Insurance | If Property Insured is set to Yes, these are the insurance details |
| Cost Estimate | The total estimated cost of all services to be provided. |
| Case Property Damage | Set to Yes if there is property damage. This field must be set to Yes to add a Private Asset. |
| Damage Summary | Optional text description of the damage |
| Special Case Notes | Enter any special case notes. This is a free text description field. |
| Case Officer | Enter the case officer's name. Note - the user needs to be on duty in the event. |
| Field Officer | Enter the field officer's name. Note - the user needs to be on duty in the event. |
| Tags | A single tag for the item |
| External ID | An optional external Id used to identify the record in a separate system. This external Id can be used for matching records for importing into Crisisworks if necessary. |
| Case Status | Status will default to OPEN. Enter either Open, Review or Inspection Required |
| Case Priority | Priority defaults to Normal. Enter either Low, Normal, High or Urgent |