Once mapped, every WorkBench data set has an “upload plan” that contains the mapping made between the columns in the data set and fields in Specify. This plan is stored in JSON.
The “upload plan” can be shared and reused by multiple users importing documents with the same (or similar) column headings.
If an upload plan refers to columns that do not exist in the WorkBench dataset it is applied to, the plan will just remove the mapping for those columns.
-
Navigate to the WorkBench data set you are having trouble with
-
Next, click on Tools in the top right which should drop down more buttons
-
Then, click on Upload Plan
-
With this dialog you can:
-
Export which will download a .json file of this data
-
or you can make any changes to this file and click Save
-
Importing an existing upload plan the Data Map into WorkBench
After the .json
file has been exported , you will need to manually load it into your Data Mapper.
-
Find the
.json
file on your computer and open it with a plain text editor like notepad, TextEdit etc. -
Select and copy the text inside.
-
Return to the Upload Plan dialog and paste the text inside the mapper.
-
Click save. The Data Mapper should now be populated with the imported mapping.