How to make multiple network changes at the same time to the baseline network ?

You can make bulk network changes through Excel downloads and uploads. 

You can add, close and edit locations all within the same Excel file.

General steps to follow

1. Go to the Data Management module
2. Make sure you indicate the right country for which you want to make changes to
3. Go to Location Management under Competitive landscape
4. Click on the Download template button
5. Indicate the scope of the file you want to download, full own brand or selected own brand. 
   The template file contains the full list of locations in scope with all editable location characteristics (called attributes within article). The headers of the location attributes are a combination of the attribute name and a unique textual key. These should not be changed, nor deleted! In case you removed a column and want to re-add it, you can find the correct headers back on the second sheet of the template file.
6. Perform the steps that are shown under the heading applicable for your use-case (below)
7. Upload the excel. 
   Uploading the Excel template will make the changes to your baseline network permanent!

Use case specific steps

TIP:  To make your file more clear and the upload faster, you can delete the rows of all existing locations for which you don't want to make changes. Deleting a row doesn't mean deleting the location.

1. Adding locations

You can add a new location by adding a new row for each new location. Make sure the following is completed correctly:

1. The ID field should be left blank
2. Shop code, name, and address-city must be unique.
3. State (Open vs Closed) is a general as well as a segment-specific characteristic. Put this to 'Open' in the 'General attributes' section. For the 'Charge & go', 'Visit & charge' and 'Stay & charge' columns, take the folowing rules into account:
   • if you have > 0 fast or ultrafast charging points -> fill out  'Open' in the cell 'State' for segment Charge & go else fill out 'Closed'
   • if you have > 0 fast or ultrafast charging points -> fill out  'Open' in the cell 'State' for segment Visit & charge else fill out 'Closed'
   • if you have > 0 slow charging points -> fill out  'Open' in the cell 'State' for segment Stay & charge else fill out 'Closed'
4. Either address fields or coordinates must be provided
5. When you leave a cell for a characteristic in the Excel file blank, the default value will be assigned/calculated.
    

Remark! Shop code, brand and name are mandatory fields. 

2. Closing locations

You can close locations as a whole or only a segment of a location. 

• Close a location: Close the location by updating the state in the general location information section from 'Open' to 'Removed'. By closing the location in the general section, the location will be considered as closed for all segments and will be entirely removed from the baseline network.
• Close the location for a segment: Close a segment of a location by changing the state in that segment section from 'Open'  to 'Removed'. The location itself will still be considered as open and will not be entirely removed from the baseline network.

Remark! It is not allowed to close all segments of a location while the general state is still open

3. Updating location characteristics

Update the values of the attributes you want to change in the right column(s). 

• Do not update the id field - those are unique!
• Some attributes only allow certain values. If you started from the downloaded template, these values can be found in the second tab.

4. Moving the markers of locations

Change the coordinates of the location and clear the address fields, these don't have to be filled.

A NOTE ON ADDRESS FIELDS AND COORDINATES

In the bulk upload, it is possible to provide the address, the coordinates or both when adding a new or moving an existing location. Partially filling the address fields is never allowed. For new and existing locations the options work differently: 

For new locations in the bulk upload:

• If you complete only the coordinates: the address fields will be reverse geocoded. 
• If you complete only the address fields: the coordinates will be geocoded.
• If you complete both the coordinates and address fields: no (reverse) geocoding. The coordinates and address will be stored in the database as provided in the Excel file.
• If you don't complete the coordinates AND the address fields: not allowed for new locations!

For existing locations in the bulk upload:

• If you complete only coordinates: the address field will be reverse geocoded in case the coordinates are updated, otherwise they will remain unchanged.
• If you complete only address fields: the coordinates will be geocoded in case the address fields are updated, otherwise they will remain unchanged.
• If you complete both the coordinates and the address fields: no (reverse) geocoding. The coordinates and address fields be updated in the database as provided in the Excel file, if there is no update they will remain unchanged.
• If you don't complete the coordinates AND the address fields: The coordinates and address fields will remain unchanged.