This article may quote data or refer to features or workflows no longer applicable to the current version of eSpatial, which is updated every 6-8 weeks. Please refer to our help section for more up to date information
It’s easy to add new data to a mapped spreadsheet in eSpatial.
Let’s say, for instance, you have mapped a customer list and you need to update the data with new customers.
In this scenario, you can either append the new data (if it’s contained in a unique spreadsheet document) or you can overwrite the existing dataset in eSpatial (where you have added new customers to the original spreadsheet you uploaded).
Let’s go through the stages of updating data in an existing eSpatial document.
MOST IMPORTANTLY: when you are uploading new data in an Excel csv file, make sure the column heading titles match the column heading titles in the original csv file you uploaded to eSpatial.
The first thing to do is to go to your eSpatial homepage and find the dataset to which you want to add new data, as indicated below:
Click on the file and you will get a thumbnail of the original mapped data:
Click on the thumbnail and the original data map you created (with your original csv spreadsheet) will open up:
Next, go to the top left hand corner of the map and click on the “Update” button, as indicated:
This will bring you into an “Add Files” page. Click the orange button, as highlighted, to prepare your new file for upload.
Once you’ve done that, the file will appear in the Files menu. As you can see above, the csv file we’re uploading is called newcustomers4.
At this point, you must select one of the two options available to you.
Choose “Append to dataset” to add data from a new spreadsheet to the existing dataset within eSpatial.
Choose “Overwrite dataset” if you wish to replace the existing eSpatial dataset with data from a new spreadsheet. This is a likely scenario when you have simply added new data to the spreadsheet you originally uploaded to eSpatial. When you overwrite, the original eSpatial name of the dataset will be retained.
When you’ve decided which option you prefer, click on either of the following buttons at the bottom of the page:
Choose “Next” button if you wish to review the location data used for geocoding the data:
Choosing “Complete Now” (or “Finish” if you’ve reviewed the geocoding defaults page above) brings up the familiar upload page, with its upload progress bar:
Once this is completed, you have now appended new data to an existing dataset or overwritten it. Click “Map my Data” and a revised map, containing the newly-added data, will be generated.
If you have any questions on how to add new data to a mapped spreadsheet, please use our support channels for further assistance.