Formatted catalog number in DwCA export

Hi @ZsPapp,

Hi from Kansas! :smile: :waving_hand: :sheaf_of_rice:

I believe the issue here is that you are trying to apply a table format to a field (collectionobject.catalogNumber) rather than mapping to the (formatted) table field itself (collectionobject.).

I defined a table format as described by @bhumikagupta, and once I did so, I was able to map the http://rs.tdwg.org/dwc/terms/catalogNumber term to the 1.collectionobject. string ID (corresponding to the ‘(formatted)’ Collection Object record itself).

See my DwC mapping line below:

<field term="http://rs.tdwg.org/dwc/terms/catalogNumber" stringId="1.collectionobject." oper="8" value="" isNot="false" isRelFld="false"/>

Output:

occurrenceID catalogNumber originalCatalogNumber eventDate
db191bf1-1ed3-11e3-bfac-90b11c41863e NHMD000037319 37319 10/17/2005
db191eef-1ed3-11e3-bfac-90b11c41863e NHMD000039946 39946 06/26/2007
db19207b-1ed3-11e3-bfac-90b11c41863e NHMD000040682 40682 07/26/2010
db1921e0-1ed3-11e3-bfac-90b11c41863e NHMD000028892 28892 07/18/2001

:tada: The prefix appears before the catalog number itself!