Import
You can import a csv file of requests, and it will update the existing requests in the system.
BEWARE this means you can edit and potentially damage many records. PLEASE export records from the system before you import so we can recover any damage caused.
Every row in the csv must contain values for the fields you want to change in each request - so each
row needs at least an _id, to identify which request the changes are for. Blank cells will have no effect.
If you want to remove a particular value from a request and replace it with nothing, enter the value DELETE
in the relevant cell.
The accepted fields match what you can export for requests from /export, and they are:
Note, although _id is required and created_date is accepted, you cannot alter the values of those fields - if they
are changed in the import csv, they will be ignored.
If you want to create new records, you must create them in the system FIRST and then submit a sheet here to edit them.
You can create requests in bulk by using the /admin page bulk job upload feature - upload a csv
full of the identifiers you want to check for, and then once the job is done and all have been checked, you can use
the "create requests for unavailable" option there (coming soon). Once you have created the requests, go to the export
page again, and do an export restricted to today, then you can filter the list you receive down to just the new ones
you just created. From that csv you can then generate your import csv to import here.
