Importing Location Data
Location data used for coverage analysis can come from 2 sources:
• You can use existing locations. If you checked Import Location Master on Create for the location coverage scenario, the location base setup data will be used for the analysis and there is no need to import location data.
• You can create a location import file and import this data before running the coverage analysis.
When creating a location import file, remember the following:
• Columns must have the following names and be listed in the following order:
|
Order
|
Column Name
|
Description
|
|---|---|---|
|
1
|
# locationName
|
The name of the stocking location.
|
|
2
|
locDescription
|
The city and state for the stocking location.
|
|
3
|
locTypeID
|
For future use.
|
|
4
|
regionID
|
For future use.
|
|
5
|
postalCode
|
The zip code for the stocking location.
|
|
6
|
milesPerHour
|
How fast you can travel from a stocking location to a customer site.
|
|
7
|
thirdParty
|
Outsource stocking locations.
|
|
8
|
StagingTime
|
Total preparation or load time in hours (for example, 0.5).
|
|
9
|
Active
|
Indicates if the location is active, where:
y = the location is active
n = the location is not active
|
|
10
|
IncludeNB
|
Indicates whether the location is to be used in location coverage scenarios, where:
y = use this location in your location coverage scenarios
n = do not use this location in your location coverage scenarios
|
• You can use a tab-separated or comma-separated format for the import file. However, if you are using commas within your data (for example, "Atlanta, GA"), you need to use a tab-separated format.
• Save the file as a text file before importing (for example, importfile.txt).
To import the file:
1. From the Analysis menu, select > . The Location Coverages page appears.
2. Click the View Details button 
for the scenario. The Location Coverages - Scenario page appears with the Install Base tab selected.
for the scenario. The Location Coverages - Scenario page appears with the Install Base tab selected.3. Click the Import button 
, The Edit Location Coverages - Scenario page appears.
, The Edit Location Coverages - Scenario page appears.4. For Install Site File Name, select the stocking location import file. Then set Install Site File Type to Tab Separated or Comma Separated, depending on the selected file. Click the Save button 
.
.5. You are returned to the Location Coverages - Scenario page with the Install Base tab selected. Click the Save button to save the list of install sites.
to save the list of install sites.6. Click the Return to Previous Page button 
to return to the Location Coverages page.
to return to the Location Coverages page.