Working on a very small workbench upload, but wanted to use an existing plan. I have recieved an error that I have not encountered before, and am having trouble deciphering. Wondering if this could be related to anything new in 7.10, as this mapping worked previously.
Removing Canada fixes the issue. BC in province does not produce an error during validation
Mapping
{
"baseTableName": "collectionobject",
"uploadable": {
"uploadTable": {
"wbcols": {
"altcatalognumber": "SEM #",
"text2": "Previous Determinations",
"text3": "Additional Label information",
"text5": "Databaser",
"catalogeddateverbatim": "Year Databased",
"remarks": "Databaser's Notes",
"catalogeddate": "Date Added",
"text4": "Form",
"catalognumber": "catalogNumber"
},
"static": {},
"toOne": {
"collectingevent": {
"uploadTable": {
"wbcols": {
"enddate": "Collection Date 2",
"text1": "Collector",
"remarks": "Habitat",
"text2": "Plant Host",
"text3": "Animal Host",
"text4": "Misc. Collection Data",
"text5": "Trap",
"startdateverbatim": "Verbatim Date 1",
"enddateverbatim": "Verbatim Date 2",
"startdate": "startDate"
},
"static": {},
"toOne": {
"locality": {
"uploadTable": {
"wbcols": {
"localityname": "Collection Location",
"latitude1": "Latitude",
"longitude1": "Longitude",
"text1": "Elevation",
"remarks": "Notes on Location"
},
"static": {},
"toOne": {
"geography": {
"treeRecord": {
"ranks": {
"Country": {
"treeNodeCols": {
"name": "Country"
}
},
"State": {
"treeNodeCols": {
"name": "Province"
}
},
"County": {
"treeNodeCols": {
"name": "Region"
}
}
}
}
}
},
"toMany": {
"localitydetails": [
{
"wbcols": {
"utmzone": "UTM Zone",
"utmeasting": "Easting",
"utmnorthing": "Northing",
"text1": "Worldmap Format"
},
"static": {},
"toOne": {}
}
],
"geocoorddetails": [
{
"wbcols": {
"georefremarks": "Notes on Georeferencing"
},
"static": {},
"toOne": {}
}
]
}
}
}
},
"toMany": {}
}
},
"collectionobjectattribute": {
"uploadTable": {
"wbcols": {
"text31": "Lifestage",
"text1": "sex"
},
"static": {},
"toOne": {},
"toMany": {}
}
}
},
"toMany": {
"determinations": [
{
"wbcols": {
"text1": "Determiner",
"text2": "Determiner Date"
},
"static": {},
"toOne": {
"taxon": {
"treeRecord": {
"ranks": {
"Phylum": {
"treeNodeCols": {
"name": "Phylum"
},
"treeId": 7
},
"Class": {
"treeNodeCols": {
"name": "Class"
},
"treeId": 7
},
"Order": {
"treeNodeCols": {
"name": "Order"
},
"treeId": 7
},
"Suborder": {
"treeNodeCols": {
"name": "Suborder"
},
"treeId": 7
},
"Infraorder": {
"treeNodeCols": {
"name": "Infraorder"
},
"treeId": 7
},
"Superfamily": {
"treeNodeCols": {
"name": "Superfamily"
},
"treeId": 7
},
"Family": {
"treeNodeCols": {
"name": "Family"
},
"treeId": 7
},
"Subfamily": {
"treeNodeCols": {
"name": "Subfamily"
},
"treeId": 7
},
"Tribe": {
"treeNodeCols": {
"name": "Tribe"
},
"treeId": 7
},
"Subtribe": {
"treeNodeCols": {
"name": "Subtribe"
},
"treeId": 7
},
"Genus": {
"treeNodeCols": {
"name": "Genus"
},
"treeId": 7
},
"Subgenus": {
"treeNodeCols": {
"name": "Subgenus"
},
"treeId": 7
},
"Species": {
"treeNodeCols": {
"name": "Species",
"author": "Species Author"
},
"treeId": 7
},
"Subspecies": {
"treeNodeCols": {
"name": "Subspecies"
},
"treeId": 7
}
}
}
}
}
}
],
"collectionobjectproperties": [
{
"wbcols": {
"text32": "Museum",
"text33": "Publication Date",
"text31": "Loan Data",
"text10": "Photographed",
"text11": "Photo added",
"text34": "Database Label"
},
"static": {},
"toOne": {}
}
],
"preparations": [
{
"wbcols": {},
"static": {},
"toOne": {
"preptype": {
"mustMatchTable": {
"wbcols": {
"name": "Storage"
},
"static": {},
"toOne": {},
"toMany": {}
}
}
}
}
],
"dnasequences": [
{
"wbcols": {
"boldbarcodeid": "BOLD Specimen #",
"boldsampleid": "BOLD ID"
},
"static": {},
"toOne": {}
}
]
}
}
}
}