You can define one or more entries in a spreadsheet and import them.
The steps are:
- Prepare your spreadsheet (below).
- Navigate to the entry you want to import under
- From the entry popup menu select "Import"
- Under "Type:" select "CSV Import". You can either provide an XLSX spreadsheet or a CSV file.
- Press Submit
The upload can either be an XLSX or a CSV. Here is an
example
collections.xlsx spreadsheeet.
- Any line in the spreadsheet that starts with "#" is ignored.
- The header must have a "type" and a "name" column.
- The header may have a "description" column.
Here is an example:
#this is a comment | | |
type | name | description |
type_archive_collection | collection 1 | Some description |
type_archive_series | series 1 | Some other description |
| series 2 | Some more description |
type_archive_file | file 1 | Some file description |
| file 2 | |
You can view and search for entry types at the
/repository/entry/types.html page. Clicking on the type ID
will copy the ID to the clipboard where you can paste it into your spreadsheet.
The type does not have to be repeated. If there is no value specified then the previous
type is used.
There may be an "id" and a "parent" column. This defines the entry hierarchy.
So here we have a collection with id "c1". The parent of the series entries "s1" and "s2"
is the collection. The parent of the "file 1" entry is the series "s1".
The parent of the "file 2" entry is the series "s2".
type | name | id | parent |
type_archive_collection | collection 1 | c1 | |
type_archive_series | series 1 | s1 | c1 |
| series 2 | s2 | c1 |
type_archive_file | file 1 | | s1 |
| file 2 | | s2 |
One or more metadata types can be added. Create a column of the form:
metadata:
metadata type ID
The available metadata can be viewed at
/repository/metadata/types.html.
Clicking on the type ID
Here we are defining an archive_subject and an archive_note.
The values can be ";" delimited, so, e.g., we are adding two subjects - "subject 1" and "subject 2".
If the metadata has multiple fields then seperated the field values with a ":".
For example, the archive_note metadata takes two values - the note type and the note. So here we
are adding one archive_note with type="Scope" and note="Some scope".
type | name | metadata:archive_subject | metadata:archive_note |
type_archive_collection | collection 1 | subject1;subject 2 | Scope:Some scope |
Entries may have fixed properties. For example, the Archive Collection entry type has a Collection number, a Form number, a Shelf location and a Size.
These properties can be set by having a column of the form:
entry_type.column
The
entry_type. prefix is optional. If an entry created does not have that property then it is ignored.
For example:
type | name | type_archive_collection.shelf_location |
type_archive_collection | collection 1 | Some shelf collection |
The column names can be viewed from the
/repository/entry/types.html page.
Click on an entry label to see the entry type details, e.g.
/repository/entry/types.html?type=type_archive_collection.