Welcome to the developer documentation for our CSV File Download feature.
If you monitor thousands of carriers, then you know how time-consuming the process of manually updating records in your software can be. Consider the consequences if you overlook updating certain carriers.
Integration with Carrier411 using our CSV File Download feature can automate the update process, save you valuable time, improve efficiency, and help protect your business from using the wrong carriers.
As an alternative to our more robust Web Services Interface, we can provide access to a comma-separated values (CSV) file that gets created on demand.
Compared to accessing data with our Web Services Interface, our CSV File Download feature provides an easier (but more limited) way to access critical information about all the companies monitored by your Carrier411 account.
Carrier411 CSV file data provides the current authority status, insurance, safety ratings and SafeStat scores for you to integrate with your transportation software system. Again, it does this for all the companies being monitored by your Carrier411 account.
In simple terms, your server communicates with our server. By scheduling one daily request to our CSV File Download feature, your software system can keep its database up-to-date automatically within a matter of seconds.
Want to Start Using Our CSV File Download Feature?
If you have questions or would like to start downloading CSV files for your account, please call us today at (888) 411-9661. Access to our CSV File Download feature is disabled by default. It is only available to Carrier411 customers with an active account, and it is not available for trial accounts. This optional add-on feature can be enabled for an additional $49.00 per month. Carrier411 reserves the right to allow access to the CSV File Download feature.
How to Initiate CSV File Download
First, you must have an active Carrier411 account, and the CSV File Download feature must be enabled for your account. When your server invokes the following URL string, a CSV file will be created at that moment. It will begin downloading automatically.
CSV file creation may take between 5 seconds and 30 seconds, depending on the number of companies monitored by your Carrier411 account.
| URL String to Create CSV File |
| http://www.carrier411.com/createcsvfile.cfm?username=xxx&password=yyy |
| Substitute xxx with your Carrier411 username and yyy with your password. |
| Unless &header=0 (optional parameter) is specified in the above URL string, a file header row will be included in the CSV file by default. |
| Schedule |
Schedule your server to invoke the above URL string one time only in the morning, between 7:45 AM and 9:00 AM EST. Schedule this event every Monday through Friday morning. Do not download in the evening or night, because data is updated in the early morning. |
| Purpose |
Creates comma-separated values (CSV) file upon request.
Includes data (detailed below) for all the companies monitored by your Carrier411 account. |
| Errors |
Any errors will produce a FaultCode when the URL string is invoked.
FaultCode 1: Username and password not provided.
FaultCode 2: Username not provided.
FaultCode 3: Password not provided.
FaultCode 4: Invalid username or password.
FaultCode 5: Account inactive.
FaultCode 6: Account suspended.
FaultCode 7: Trial accounts cannot download CSV files.
FaultCode 8: CSV file download not activated for account.
|
| Parameters |
username -- Carrier411 username (Required).
password -- Carrier411 password (Required).
header -- 1 or 0 (Optional). Include &header=0 for no header row.
|
CSV File Fields and Possible Values
 View Example CSV File with Header Row
| 1. |
DOCKET |
CHAR 8 |
| This is the motor carrier (MC) number for the company. It may also be an FF or MX number for freight forwarders or Mexican carriers. |
| 2. |
USDOT |
NUMERIC 9 |
| This is the USDOT number for the carrier. Values may include 0 or NULL. |
| 3. |
LEGALNAME |
VARCHAR 120 |
| This is the legal name of the company. |
| 4. |
DBANAME |
VARCHAR 60 |
| This is the doing-business-as (dba) name for the company. |
| 5. |
ADDRESS |
VARCHAR 50 |
| This is the business address for the company. |
| 6. |
CITY |
VARCHAR 30 |
| This value is the city for the business address specified in ADDRESS. |
| 7. |
STATE |
CHAR 2 |
| This value is the 2-character state for the business address specified in ADDRESS. |
| 8. |
ZIP |
VARCHAR 10 |
| This value is the zip code for the business address specified in ADDRESS. Most zip codes are 5 digits. Some are zip plus 4. Others are international postal codes. |
| 9. |
PHONE |
VARCHAR 14 |
| This value is the 10-digit business phone number if provided. The value may be NULL. |
| 10. |
FAX |
VARCHAR 14 |
| This value is the 10-digit business fax number if provided. The value may be NULL. |
| 11. |
EMAIL |
VARCHAR 80 |
| Possible Values: NULL or text. This is the company's email address. |
| 12. |
TRUCKS |
VARCHAR 6 |
| Possible Values: NULL or numeric value. This value indicates the total number of "Power Units" operated by the carrier. |
| 13. |
COMMON |
CHAR 1 |
| This value describes the company's common carrier authority status. There are three possible values: "A" for active common authority, "I" for inactive common authority or "N" for no common authority. |
| 14. |
CONTRACT |
CHAR 1 |
| This value describes the company's contract carrier authority status. There are three possible values: "A" for active contract authority, "I" for inactive contract authority or "N" for no contract authority. |
| 15. |
BROKER |
CHAR 1 |
| This value describes the company's broker authority status. There are three possible values: "A" for active broker authority, "I" for inactive broker authority or "N" for no broker authority. |
| 16. |
PENDCOMMON |
CHAR 1 |
| Possible Values: Y or N. This value describes whether the company has applied for common carrier authority and is in the process of receiving it. There are two possible values: "Y" for yes or "N" for no. |
| 17. |
PENDCONTRACT |
CHAR 1 |
| Possible Values: Y or N. This value describes whether the company has applied for contract carrier authority and is in the process of receiving it. There are two possible values: "Y" for yes or "N" for no. |
| 18. |
PENDBROKER |
CHAR 1 |
| Possible Values: Y or N. This value describes whether the company has applied for broker authority and is in the process of receiving it. There are two possible values: "Y" for yes or "N" for no. |
| 19. |
REVCOMMON |
CHAR 1 |
| Possible Values: Y or N. This value describes whether the company is pending revocation of its common carrier authority. It may soon lose authority. There are two possible values: "Y" for yes or "N" for no. Yes does not mean they have lost their common carrier authority. Yes usually indicates the company is within 30 days of its insurance premium being due, and it remains unpaid. However, there are other reasons this warning flag may get raised. |
| 20. |
REVCONTRACT |
CHAR 1 |
| Possible Values: Y or N. This value describes whether the company is pending revocation of its contract carrier authority. It may soon lose authority. There are two possible values: "Y" for yes or "N" for no. Yes usually indicates the company is within 30 days of its insurance premium being due, and it remains unpaid. However, there are other reasons this warning flag may get raised. |
| 21. |
REVBROKER |
CHAR 1 |
| Possible Values: Y or N. This value describes whether the company is pending revocation of its broker authority. It may soon lose authority. There are two possible values: "Y" for yes or "N" for no. Yes usually indicates the company is within 30 days of the premium being due for its broker bond, and it remains unpaid. However, there are other reasons this warning flag may get raised. |
| 22. |
BIPDREQ |
VARCHAR 10 |
| BIPD is bodily injury property damage, more commonly known as liability insurance. If BIPD is required by the FMCSA, the minimum dollar amount of required coverage will be specified. If required, the minimum amount is usually 750000 ($750,000.00), but it could be higher. It could also be 0 (zero), if BIPD is not required. FMCSA requires companies with contract authority to have BIPD insurance. |
| 23. |
BIPDFILED |
VARCHAR 10 |
| This value indicates the dollar amount of liability insurance on file for the company, as reported to the FMCSA by insurance underwriters. Even though BIPD insurance may not be required, some companies will maintain a BIPD insurance policy. |
| 24. |
CARGOREQ |
CHAR 1 |
| This value indicates whether the FMCSA requires the company to have cargo insurance. There are two possible values: "Y" for yes or "N" for no. FMCSA requires companies with common authority to have cargo insurance. |
| 25. |
CARGOFILED |
CHAR 1 |
| This value indicates whether cargo insurance is on file for the company, as reported to the FMCSA by insurance underwriters. There are two possible values: "Y" for yes or "N" for no. Even though cargo insurance may not be required, some companies will maintain a cargo insurance policy. |
| 26. |
BONDREQ |
CHAR 1 |
| Possible Values: Y or N. This value indicates whether the FMCSA requires the company to have a bond. There are two possible values: "Y" for yes or "N" for no. FMCSA requires companies with broker authority to maintain a bond. |
| 27. |
BONDFILED |
CHAR 1 |
| Possible Values: Y or N. This value indicates whether a broker bond is on file for the company, as reported to the FMCSA by insurance underwriters. There are two possible values: "Y" for yes or "N" for no. |
| 28. |
RATING |
CHAR 1 |
| Possible Values: NULL or single letter. This is the carrier safety rating. There are three possible safety ratings: U = Unsatisfactory, C = Conditional, S = Satisfactory. The safety rating was issues on the date specified in RATEDATE. |
| 29. |
RATEDATE |
DATETIME |
| Possible Values: NULL or date. If the carrier has a carrier safety rating value specifies in RATING, this is the date the safety rating was issued formatted as mm/dd/yyyy. If the carrier has no safety rating, the value will be NULL. |
| 30. |
DRSEA |
REAL 4 |
| Possible Values: NULL or number. This value is the numeric Driver Safety Evaluation Area (DRSEA) SafeStat score. This value may be NULL. Numeric values range from 0 to 100, and any score 75 or above is considered deficient and should be highlighted. Scores may have two decimal places, such as 63.85. |
| 31. |
VHSEA |
REAL 4 |
| Possible Values: NULL or number. This value is the numeric Vehicle Safety Evaluation Area (VHSEA) SafeStat score. This value may be NULL. Numeric values range from 0 to 100, and any score 75 or above is considered deficient and should be highlighted. Scores may have two decimal places, such as 63.85. |
| 32. |
SMSEA |
REAL 4 |
| Possible Values: NULL or number. This value is the numeric Safety Management Evaluation Area (SMSEA) SafeStat score. This value may be NULL. Numeric values range from 0 to 100, and any score 75 or above is considered deficient and should be highlighted. Scores may have two decimal places, such as 63.85. |
| 33. |
UPDATED |
DATETIME |
| This the mm/dd/yyyy date that insurance and authority information about the company was last updated in our database. |
| 34. |
CREATED |
DATETIME |
| This the mm/dd/yyyy date that CSV file was created. |
|
|
| Special Offer - Free Trial Account |
Test drive Carrier411 absolutely free for 30 days with no obligation. Get started today with our membership test drive.
|
 |
Unlimited Monitoring for $99 Month |
|
Research and Qualify Any Carrier |
|
Configurable Qualification Settings |
|
Track Insurance and Authority |
|
Safety Ratings and SafeStat Scores |
|
Alerts by Email, Fax and Online |
|
|
 |
|
| Safety Ratings and SafeStat Scores |
|
Are you relying on any of the 16,196 trucking companies with conditional or unsatisfactory carrier safety ratings?
|
Brokerage Agent Recruiting
Brokers can take advantage of our new broker agent recruiting solution to find the most qualified freight broker agents in the United States and Canada.
Flat Rate Pricing - $99.00 Per Month
Other carrier monitoring services have ridiculous tiered pricing models based on the number of carriers you monitor. We make it practical and affordable to monitor all your carriers for a flat rate of only $99.00 per month - without any hidden charges or additional fees.
Our service price comparison shows how we outperform CarrierWatch™ by TransCore™ in price, features and bottom-line results.
Monitor Your Carriers - Free Import
We even make it easy for you to get started with Carrier411 by importing the MC numbers for all your carriers at no additional cost. Importing your carrier list is the quickest way to register your carriers for monitoring. Learn how to export your carrier list.
Added Bonus - Free Safety Analysis
Provide an Excel spreadsheet with the MC numbers of your carriers to import, and receive your complimentary safety analysis reports identifying all of your high-risk carriers.
TransCore and CarrierWatch are registered trademarks of TC IP, Ltd.
|
