Follow

Rate Deck Importation & Format Information

FULL RATE DECK PRIME RATE DECK INTL RATE DECK
To import the rate deck in to a database you will need to run something similar to the following: To import the rate deck in to a database you will need to run something similar to the following: To import the rate deck in to a database you will need to run something similar to the following:
Create a table called rates.
Create the following fields within the rates table.
Create a table called rates.
Create the following fields within the rates table.
Create a table called rates.
Create the following fields within the rates table.
  1. carrier_id (int) 3 
  2. carrier (varchar) 50 
  3. prefix (varchar) 10 
  4. inter (decimal) 6, 6 
  5. intra (decimal) 6, 6
LOAD DATA LOCAL INFILE '/PATH-TO-CSV/import.csv' 
INTO TABLE rates 
FIELDS TERMINATED BY ',' 
OPTIONALLY ENCLOSED BY '"' 
ESCAPED BY '\\' 
LINES TERMINATED BY '\n' 
(carrier_id,carrier,prefix, inter, intra)
  1. prefix (varchar) 10 
  2. inter (decimal) 6, 6
  3. intra (decimal) 6, 6
LOAD DATA LOCAL INFILE '/PATH-TO-CSV/import.csv' 
INTO TABLE rates 
FIELDS TERMINATED BY ',' 
OPTIONALLY ENCLOSED BY '"' 
ESCAPED BY '\\' 
LINES TERMINATED BY '\n' 
(prefix,inter, intra)
  1. carrier_id (int) 3 
  2. destination (varchar) 55 
  3. prefix (varchar) 15 
  4. rate (decimal) 6, 6 
  5. initial (int) 1
  6. additional (int) 1
  7. effective (varchar) 16
LOAD DATA LOCAL INFILE '/PATH-TO-CSV/import.csv' 
INTO TABLE rates 
FIELDS TERMINATED BY ',' 
OPTIONALLY ENCLOSED BY '"' 
ESCAPED BY '\\' 
LINES TERMINATED BY '\n' 
(carrier_id,destination,prefix, rate, initial, additional, effective)
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk