Use the Update and Insert Option to Keep Your Reports Data Intact


The Append and Insert option is the suggested method for uploading locations on an ongoing basis in most cases.  This method is unique because it allows you to not overwrite locations when there are changes to existing locations. When the Append and Insert Option is used, Bullseye loops through all locations, and applies changes to existing ones without overwriting, and also adds new locations you might have included.  By not overwriting locations  you are able to retain their valuable report data (note the Update-Works Like Clear and Append option would replace locations, and report data is lost).


It is important to note that, in order for this option to work, you first need to have an Internal Bullseye ID for your locations.  This ID will not be obtained until after you do your first upload.  Thus, the upload process might be explained like this:


1. First Upload-It doesn't matter if you use Append, Update (works like clear and append) or Update and Insert.  Simply upload your locations, and Bullseye will add the Location IDs.

2. Subsequent Uploads-Download the locations under Manage Locations/Export.  You will see the Location IDs in the LocationID column.  Add your edits to the existing locations if needed, and add new locations (without Location IDs as needed and they will be appended to the list).


Note: If you re-upload location and don't include their Location IDs, those locations will be duplicated.