|
Siebel eService Administration Guide for Siebel Open UI > Administering Siebel eService > Process of Setting Up Branch Locations >
Importing Geocode Data
The geocode data includes location references. You can import Geocode data in one of the following ways:
- Using the Import command in Siebel Call Center.
- Using Siebel Enterprise Integration Manager. For information about importing data with Siebel Enterprise Integration Manager, see Siebel Enterprise Integration Manager Administration Guide.
The imported geocode data is stored in the (S_ZIPCODE) database table. Table 4 shows the columns in this database table that must have data.
Table 4. Data Model for S_ZIPCODE Table
|
|
ZIP Code |
Postal code in alphanumeric text. |
City |
Name of city. |
State |
Name of state or province. This field can be blank for certain countries. |
Country |
Name of the country. |
Latitude |
Latitude number (0 to plus or minus 90). A plus sign (+) denotes the Northern Hemisphere, and a minus sign (-) denotes the Southern Hemisphere. |
Longitude |
Longitude number (0 to plus or minus 180). A plus sign (+) denotes the Eastern Hemisphere, and a minus sign (-) denotes the Western Hemisphere). |
You can import a maximum of 2,000 geocode data records for each Import command on Siebel Call Center. You must store the geocode data in a file that contains the column heading information in Table 4. NOTE: Oracle provides no guarantees or warranties about the accuracy of the geocode data for branch locations. For the latest geocode data, contact a geocode data vendor.
This task is a step in Process of Setting Up Branch Locations. To import geocode data with the Import command
- Navigate to the Administration - Data screen, then the ZIP Code Administration view.
- In the ZIP Geocodes list, click the menu button, and then select Import.
The Import dialog box appears.
- In the Import dialog box, complete the following steps:
- Click Choose File to select a file in the Input File field.
This file is the geocode data file.
- For the Input Format field, select Comma Separated Text File or Tab Delimited Text File for the geocode data file.
- For the Input Source field, select Auto Mapping.
- For the Conflict Resolution field, select Overwrite Existing Record.
- Click Next.
- Make sure the values for the import fields match the values for the Siebel fields, and click Next.
A view log appears when the import process is complete.
|
