*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": { "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'.