Two types of Library Items are available for importing - documents and geospatial items.
Please read the general Importing Data into Crisisworks instructions before proceeding with Importing Library Items.
Importing Library Items
From the "What do you want to import?" drop down list on the Import Form, select the Library Items option and click on the Next button.
You will then be presented with what type of Library Items you would like to import. If you are importing simple Library Documents, choose the "Library Item (Document schema Import)" option.
If you would like to import Geospatial data, you can choose the "Library Item > Geospatial > All Categories" option and specify the category in your spreadsheet, or alternatively you can choose one of the specific categories defined in the list.
Library Items (Document schema) Import
To import basic Library Items, choose the Library Item (Document schema Import) option.
The CSV file format for this import type is below:
Library Item (Geospatial Import)
The Library Item Geospatial Import option allows you to add a Library item for a specific category (ie Vulnerable Facility) with geospatial data included. It is also possible to attach an asset, icon and assignment to this record.
If you would like to import records into multiple categories, choose the "Library Item > Geospatial > All Categories" option and set the Category field in your spreadsheet.
Alternatively, if you are importing items for only one category, you should choose the category from the list. For example, if you are only importing Vulnerable Facilities, choose the "Library Item > Geospatial > Vulnerable Facility" option. This will automatically set the category to Vulnerable Facility on import. When choosing a specific category, you also have the option of deleting all existing data for this category and inserting all items as new. See below for more information on the Delete/Insert option.
Choosing a Category
You will need to choose an appropriate category for your Geospatial item. If you do not choose a category, it will default to a category called "General".
...
There are two available options to use when setting geo data for your library item. You can set separate Latitude and Longitude fields (called lat and lng) or you can set a field called geometry. The geometry field will import geometry data as well-known text.
The CSV file format for this import type is below:
Below is a sample CSV file for a Geospatial Library Item that you can base your import on. The Property field can either be the asset's address or it can use the code (this is your code not the Crisisworks ID).
View file name Library Geospatial Feature CSV with geometry field.csv height 250
Importing Data
You will need to upload a file in CSV format with a list of library items to import based on the appropriate CSV fields shown in the images above.
...
Delete & Insert - you can choose the Delete & Insert option for Library Geospatial imports if you choose a specific category from the Import Option drop down list. If you choose the Delete & Insert option, it will delete all library items for this category only and insert the items from your spreadsheet as new items into this category. For example if you choose the "Library Item > Geospatial > Vulnerable Facility" import option, and choose Delete & Insert, it will delete all existing library items from the event chosen that have the category Vulnerable Facility. It will then import your items as new items into this category.
Additional Settings
It is best to choose the Rollback on Error and Validate Field Names options for your import. The Validate Field Names option will inspect your spreadsheet and alert you if you have any additional fields in your spreadsheet that are not in the fields listed above. It will also ensure you have all required fields in your spreadsheet.
...