Importing Location Information

This section describes how to import location information in CSV format. A set of sample CSV files is presented. Tables must be loaded in the order presented in this section. Otherwise, foreign key violations occur.

1. Import the LOCATION Table.

   The following example illustrates how you specify LOCATION data in CSV format.

   LOCATION
   LOCATION_GID,LOCATION_XID,LOCATION_NAME,CITY,PROVINCE,PROVINCE_CODE,POSTAL_CODE,COUNTRY_CODE3_GID,TIME_ZONE_GID,LAT,LON,IS_TEMPORARY,IS_MAKE_APPT_BEFORE_PLAN,RATE_CLASSIFICATION_GID,DOMAIN_NAME,IS_SHIPPER_KNOWN,IS_ADDRESS_VALID,IS_MIXED_FREIGHT_THU_ALLOWED,SLOT_TIME_INTERVAL,SLOT_TIME_INTERVAL_UOM_CODE,SLOT_TIME_INTERVAL_BASE,IS_LTL_SPLITABLE
   EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDDHH24MISS'
   MYDOMAIN.YELLOW,YELLOW,YELLOW LOCATION,PITTSBURGH,,PA,99999,USA,America/New_York,,,N,N,,MYDOMAIN,N,U,N,,,,Y
   MYDOMAIN.MYLOCATION,MYLOCATION,MYLOCATION,PHILADELPHIA,,PA,19001,USA,America/New_York,40.12726,-75.12881,N,N,COMMERCIAL,MYDOMAIN,N,U,N,0,S,0,Y
   MYDOMAIN.MYCORPORATION,MYCORPORATION,MYCORPORATION,PHILADELPHIA,,PA,19001,USA,America/New_York,40.12726,-75.12881,N,N,COMMERCIAL,MYDOMAIN,N,U,N,0,S,0,Y
   

2. Import the LOCATION_ADDRESS table.

   The following example illustrates how you specify LOCATION_ADDRESS data in CSV format.

   LOCATION_ADDRESS
   LOCATION_GID,LINE_SEQUENCE,ADDRESS_LINE,DOMAIN_NAME
   EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDDHH24MISS'
   MYDOMAIN.YELLOW,1,432 YELLOW AVE,MYDOMAIN
   MYDOMAIN.MYCORPORATION,1,11 EMPEROR AVE,MYDOMAIN
   MYDOMAIN.MYLOCATION,1,123 MAPLE STREET,MYDOMAIN
   MYDOMAIN.MYLOCATION,2,BUILDING H,MYDOMAIN
   MYDOMAIN.MYLOCATION,3,ROOM 100,MYDOMAIN
   

3. Import the CORPORATION Table.

   The following example illustrates how you specify CORPORATION data in CSV format.

   Note: Each CORPORATION_GID must correspond to a LOCATION_GID specified in the location table (See example).

   CORPORATION
   CORPORATION_GID,CORPORATION_XID,CORPORATION_NAME,DOMAIN_NAME,IS_DOMAIN_MASTER,IS_SHIPPING_AGENTS_ACTIVE,IS_ALLOW_HOUSE_COLLECT
   EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDDHH24MISS'
   MYDOMAIN.MYCORPORATION,MYCORPORATION,MYCORP,MYDOMAIN,N,N,N
   MYDOMAIN.YELLOW INC,YELLOW INC,YELLOW INCORPORATED,MYDOMAIN,N,N,N
   

4. Import the LOCATION_CORPORATION Table.

   The following example illustrates how you specify LOCATION_CORPORATION data in CSV format. This links a location to a corporation.

   LOCATION_CORPORATION
   LOCATION_GID,CORPORATION_GID,DOMAIN_NAME
   EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDDHH24MISS'
   MYDOMAIN.MYLOCATION,MYDOMAIN.MYCORPORATION,MYDOMAIN
   MYDOMAIN.MYCORPORATION,MYDOMAIN.MYCORPORATION,MYDOMAIN
   MYDOMAIN.YELLOW,MYDOMAIN.YELLOW INC,MYDOMAIN
   

5. Import the SERVPROV Table.

   The following example illustrates how you specify SERVPROV data in CSV format. Each SERVPROV_GID must correspond to a LOCATION_GID specified in the location table (See example).

   SERVPROV
   SERVPROV_GID,SERVPROV_XID,AUTO_PAYMENT_FLAG,DOMAIN_NAME,IS_DISPATCH_BY_REGION,ALLOW_TENDER,IS_ACCEPT_SPOT_BIDS,IS_ACCEPT_BROADCAST_TENDERS,IS_LOCALIZE_BROADCAST_CONTACT,DO_CONDITIONAL_ACCEPTS,IS_INTERNAL_NVOCC,IS_ACCEPT_BY_SSU_ALLOWED,IS_COPY_INV_DELTA_BACK_TO_SHIP,INVOICING_PROCESS
   EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDDHH24MISS'
   MYDOMAIN.YELLOW,YELLOW,N,MYDOMAIN,N,Y,N,N,N,N,N,N,N,S
   

6. Import the LOCATION_ROLE_PROFILE Table.

   The following example illustrates how you specify LOCATION_ROLE_PROFILE data in CSV format. Each location should have at least one row in this table.

   LOCATION_ROLE_PROFILE
   LOCATION_GID,LOCATION_ROLE_GID,CALENDAR_GID,FIXED_HANDLING_TIME,FIXED_HANDLING_TIME_UOM_CODE,FIXED_HANDLING_TIME_BASE,CREATE_XDOCK_HANDLING_SHIPMENT,CREATE_POOL_HANDLING_SHIPMENT,DOMAIN_NAME
   EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDDHH24MISS'
   MYDOMAIN.YELLOW,CARRIER,,0,S,0,N,N,MYDOMAIN
   MYDOMAIN.MYLOCATION,SHIPFROM/SHIPTO,,0,S,0,N,N,MYDOMAIN
   MYDOMAIN.MYCORPORATION,BILL TO,,0,S,0,N,N,MYDOMAIN
   MYDOMAIN.MYCORPORATION,REMIT TO,,0,S,0,N,N,MYDOMAIN
   

7. Import the LOCATION_REMARK Table.

   The following example illustrates how you specify LOCATION_REMARK data in CSV format.

   LOCATION_REMARK
   LOCATION_GID,REMARK_SEQUENCE,REMARK_QUAL_GID,REMARK_TEXT,DOMAIN_NAME
   EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDDHH24MISS'
   MYDOMAIN.MYLOCATION,1,REM,DRIVER CANNOT HAVE A BEARD,MYDOMAIN
   MYDOMAIN.MYLOCATION,2,REM,DRIVER MUST HAVE SAFETY GLASSES,MYDOMAIN