The Append and Replace wizard can be used to add rows to your existing platform dataset or completely replace the entire dataset. This can be done by users who have proper account and dataset permissions - site admin, publisher OR editor, designer AND dataset owner.
Here's how to access and use it --
Accessing the Append and Replace Wizard
- Go to the dataset that you'd like to update. Make sure that you are logged in and are on the data table view of the dataset (there should be a /data at the end of the URL). You can get to this page from Primer by selecting Explore Data > View Data.
- Click Edit which will open up the Edit panel
- Click Edit Dataset button to get to the working copy
- Clicking on the Edit panel again will reveal a new panel section 'Append and Replace' containing a 'Launch the Append and Replace wizard' button within it.
The append function simply adds the source data to the end of your existing dataset. This will happen regardless of whether you have a row identifier set for your dataset. If you wish to perform an Upsert instead, you must use DataSync.
After reaching the wizard, if you wish to append to your dataset:
- Click the "Append" button
- Choose a file to upload
- You will be shown a scan of the data file you are appending. Here, you can review and configure which columns your data is being imported into
- Click 'Next' to finish appending the datafile contents onto the end of the platform dataset
If you wish to replace your dataset:
- Click the "Replace" button
- Follow the rest of the instructions in the "Append" section above