*Others should feel free to add recipes and instructions!*
Google wiki: Refine recipe wiki
Some 'recipies' for specific operations with TAGSRV data.
To add Accession numbers to the bulk of the existing entries for NPL, BEG and WSA
//check to make sure these are in fact correct- doing the accession numbers by memory.
[
{
"op": "core/mass-edit",
"description": "Mass edit cells in column AccessionNumber",
"engineConfig": {
"facets": [
{
"expression": "value",
"invert": false,
"selectError": false,
"omitError": false,
"name": "Collection",
"selectBlank": false,
"columnName": "Collection",
"omitBlank": false,
"type": "list",
"selection": [
{
"v": {
"v": "NPL",
"l": "NPL"
}
}
]
}
],
"mode": "row-based"
},
"columnName": "AccessionNumber",
"expression": "value",
"edits": [
{
"fromBlank": true,
"fromError": false,
"from": [],
"to": "2000-001"
}
]
},
{
"op": "core/mass-edit",
"description": "Mass edit cells in column AccessionNumber",
"engineConfig": {
"facets": [
{
"expression": "value",
"invert": false,
"selectError": false,
"omitError": false,
"name": "Collection",
"selectBlank": false,
"columnName": "Collection",
"omitBlank": false,
"type": "list",
"selection": [
{
"v": {
"v": "WSA",
"l": "WSA"
}
}
]
}
],
"mode": "row-based"
},
"columnName": "AccessionNumber",
"expression": "value",
"edits": [
{
"fromBlank": true,
"fromError": false,
"from": [],
"to": "1980-001"
}
]
},
{
"op": "core/mass-edit",
"description": "Mass edit cells in column AccessionNumber",
"engineConfig": {
"facets": [
{
"expression": "value",
"invert": false,
"selectError": false,
"omitError": false,
"name": "Collection",
"selectBlank": false,
"columnName": "Collection",
"omitBlank": false,
"type": "list",
"selection": [
{
"v": {
"v": "BEG",
"l": "BEG"
}
}
]
}
],
"mode": "row-based"
},
"columnName": "AccessionNumber",
"expression": "value",
"edits": [
{
"fromBlank": true,
"fromError": false,
"from": [],
"to": "1970-001"
}
]
}
]
To normalize our catalog numbers, run this. //will need to update 'suffix' to reflect letters as well as numbers, with different format requirements.
[
{
"op": "core/text-transform",
"description": "Text transform on cells in column Collection using expression grel:value + \"000\"[0,3-value.length()]",
"engineConfig":
,
"columnName": "Collection",
"expression": "grel:value + \"000\"[0,3-value.length()]",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column Specimen. using expression grel:\"00000000\"[0,8-value.length()] + value",
"engineConfig":
,
"columnName": "Specimen.",
"expression": "grel:\"00000000\"[0,8-value.length()] + value",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/mass-edit",
"description": "Mass edit cells in column Suffix",
"engineConfig":
,
"columnName": "Suffix",
"expression": "value",
"edits": [
]
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column Suffix using expression grel:\"000\"[0,3-value.length()] + value",
"engineConfig":
,
"columnName": "Suffix",
"expression": "grel:\"000\"[0,3-value.length()] + value",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
}
]
[
{
"op": "core/text-transform",
"description": "Text transform on cells in column Collection using expression grel:value + \"000\"[0,3-value.length()]",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "Collection",
"expression": "grel:value + \"000\"[0,3-value.length()]",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column Specimen. using expression grel:\"00000000\"[0,8-value.length()] + value",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "Specimen.",
"expression": "grel:\"00000000\"[0,8-value.length()] + value",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/mass-edit",
"description": "Mass edit cells in column Suffix",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "Suffix",
"expression": "value",
"edits": [
{
"fromBlank": false,
"fromError": false,
"from": [
"."
],
"to": "000"
}
]
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column Suffix using expression grel:\"000\"[0,3-value.length()] + value",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "Suffix",
"expression": "grel:\"000\"[0,3-value.length()] + value",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
}
]
Filling in CatalogedDate (sets to 01/01/1000), CatalogerLastName (sets to unknown) and Collection Type (sets to Invertebrate)
[
{
"op": "core/mass-edit",
"description": "Mass edit cells in column CatalogerLastName",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "CatalogerLastName",
"expression": "value",
"edits": [
{
"fromBlank": true,
"fromError": false,
"from": [],
"to": "Unknown"
}
]
},
{
"op": "core/mass-edit",
"description": "Mass edit cells in column CatalogedDate",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "CatalogedDate",
"expression": "value",
"edits": [
{
"fromBlank": true,
"fromError": false,
"from": [],
"to": "01/01/1000"
}
]
},
{
"op": "core/mass-edit",
"description": "Mass edit cells in column CollectionType",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "CollectionType",
"expression": "value",
"edits": [
{
"fromBlank": true,
"fromError": false,
"from": [],
"to": "Invertebrate"
}
]
}
]
This next bit will allow you to combine all of the old locations into a single string formatted in the 'cage cabinet/drawer' style. The last step takes the newly formatted old locations, and adds them to 'notes'.
