Rate Deck Importation & Format Information – Commio Knowledge Base

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.
carrier_id (int) 3 carrier (varchar) 50 prefix (varchar) 10 inter (decimal) 6, 6 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)	prefix (varchar) 10 inter (decimal) 6, 6 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)	carrier_id (int) 3 destination (varchar) 55 prefix (varchar) 15 rate (decimal) 6, 6 initial (int) 1 additional (int) 1 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)

Comments