The id field for the Agency, Host LMS, Location and Reference Value Mapping

The id field for the agency, host_lms, location and reference_value_mapping tables is a uuid which is generated in a special way so the same id can be easily regenerated given the values in the record, so it is important that you do not use a a general uuid generator to create the uuid for the id field.

The script idFunctions.sh will allow you to work out what the id should be for one of the records.

Download the script and make the functions and environment variables part of your shell as follows

Note: This is assuming bash is installed.

Example uses:

1. Display the id for the agency who has the code 6altn

which will give the uuid

2. Display the id of the Host LMS record that has the code ALTOONA

which will give the uuid

3. Display the id of the location record for the agency 6altn and code apl

which will give the uuid

4. Display the id of the reference mapping record that has the from context CALVARY_UNIVERSITY, from category ItemType, from value "Video Projector", to context DCB and to category ItemType

which will give the uuid