Task #464
Updated by Aaron Marcuse-Kubitza over 12 years ago
For steps h2. Steps to reverse, see [[XPath Reversing]] reverse h3. -@DwC2-VegBIEN.specimens.csv@- # -@bin/in_place mappings/DwC2-VegBIEN.specimens.csv env left_in_root= left_out_root= right_in_root= right_out_root= left_connect= right_connect='/location/locationevent' bin/ch_root_via@- # -In the map spreadsheet, remove the following (order matters):- <pre> /specimenreplicate/*_id/locationevent /locationevent/*_id/location </pre> # -Test and commit- h3. @VegX-VegBIEN.stems.csv@ input # -@bin/in_place mappings/VegX-VegBIEN.stems.csv env left_in_root= left_out_root= right_in_root='/stemobservation' right_out_root='/stemobservation' left_connect='/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->' right_connect='/stemobservation' bin/ch_root_via@- ** The new root (inlined with the paths) will be: @/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]@ # -Do the same for all the VegX via maps:- ## -@VegX.plots.csv@:- <pre> for map in inputs/*/maps/VegX.plots.csv; do bin/in_place "$map" env left_in_root= left_out_root= right_in_root='/*s/plotObservation' right_out_root= left_connect= right_connect='/*s/plot->/*s/plotObservation[*UniqueIdentifierID]' bin/ch_root_via done </pre> ## -@VegX.organisms.csv@:- <pre> for map in inputs/*/maps/VegX.organisms.csv; do bin/in_place "$map" env left_in_root= left_out_root= right_in_root='/*s/individualOrganismObservation' right_out_root= left_connect= right_connect='/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]' bin/ch_root_via done </pre> ## -@VegX.stems.csv@:- <pre> for map in inputs/*/maps/VegX.stems.csv; do bin/in_place "$map" env left_in_root= left_out_root= right_in_root='/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]' right_out_root= left_connect= right_connect='/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]' bin/ch_root_via done </pre> # -In the map spreadsheet _and all VegX via maps_ (@VegX.{plots,organisms,stems}.csv@), remove the following (order matters):- <pre> ->/*s/individualOrganismObservation[relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID]/relatedIndividual/relatedItem[itemRelationship=stemParent]/relatedItemID->/*s/individualOrganismObservation ->/*s/individualOrganismObservation[*ID]/*ID->/*s/plotObservation ->/*s/plotObservation[*UniqueIdentifierID]/*UniqueIdentifierID->/*s/plot </pre> # -Update @mappings/Makefile@ VegX section- # Update @inputs/CTFS/maps/VegX.organisms.csv@ input ** Need to prepend organisms->plots root to go from plots into organisms and back out ** Update left side using similar procedure to @VegX-VegBIEN.stems.csv@ input above? # -Test and commit- h3. @VegX-VegBIEN.stems.csv@ output # @bin/in_place mappings/VegX-VegBIEN.stems.csv env left_in_root= left_out_root= right_in_root= right_out_root= left_connect= right_connect='/location/locationevent' bin/ch_root_via@ # In the map spreadsheet, remove the following (order matters): <pre> /specimenreplicate/*_id/locationevent /locationevent/*_id/location ... </pre> # Update @mappings/Makefile@ VegX section # Test and commit