*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.
Adding accession numbers
Adding accession numbers
[
{
"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.
Catalog Number Formatting
Catalog Number Formatting
{
"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)
Filling in some blanks
Filling in some blanks
{
"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'. It also DELETES the now-defunct 'old' columns.
Old Storage Location Into Notes
[
{
"op": "core/text-transform",
"description": "Text transform on cells in column OldCage using expression grel:\"Old Loc: \" + value",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "OldCage",
"expression": "grel:\"Old Loc: \" + value",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/mass-edit",
"description": "Mass edit cells in column OldCabinet",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "OldCabinet",
"expression": "value",
"edits": [
{
"fromBlank": true,
"fromError": false,
"from": [],
"to": " "
}
]
},
{
"op": "core/mass-edit",
"description": "Mass edit cells in column OldDrawer",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "OldDrawer",
"expression": "value",
"edits": [
{
"fromBlank": true,
"fromError": false,
"from": [],
"to": " "
}
]
},
{
"op": "core/mass-edit",
"description": "Mass edit cells in column OldCage",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "OldCage",
"expression": "value",
"edits": [
{
"fromBlank": true,
"fromError": false,
"from": [],
"to": " "
}
]
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column OldCage using expression grel:cells[\"OldCage\"].value + \", \" + cells[\"OldCabinet\"].value + \"/\" + cells[\"OldDrawer\"].value",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "OldCage",
"expression": "grel:cells[\"OldCage\"].value + \", \" + cells[\"OldCabinet\"].value + \"/\" + cells[\"OldDrawer\"].value",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column Comments using expression grel:cells[\"OldCage\"].value + \"; \" + cells[\"Comments\"].value",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "Comments",
"expression": "grel:cells[\"OldCage\"].value + \"; \" + cells[\"Comments\"].value",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/column-removal",
"description": "Remove column OldCage",
"columnName": "OldCage"
},
{
"op": "core/column-removal",
"description": "Remove column OldCabinet",
"columnName": "OldCabinet"
},
{
"op": "core/column-removal",
"description": "Remove column OldDrawer",
"columnName": "OldDrawer"
}
]
To combine the Fossil Inventory 'other number' with the Catalog Inventory 'Other Number' //difficult to do, can't just combine columns, as the data is often repeated. Also how to delinate between numbers, but only when there are 2 numbers? All attempts up to now have resulted in 'UTMP 4564-345,' and I can't find a way to get rid of that (tried: EndsWith( variables), also tried various ways to facet and split data.