On-Line Transactions (LARS) Printer Friendly Format Newsletter Sign-up Translate This Page Text Size Small Medium Large


 
Apply for a License
Pay Renewal Fee
Pay Summons
Pay Other Fees
Update License Information
Additional Information




Lost Property Search
 

Register to Vote
FHV Trip Record Submission

CSV Specifications

CSV Instruction Guide (in Arabic|Bengali|Simplified Chinese|Russian|Urdu) Detailed explanation of general file requirements for submitting CSV files to the TLC.

Bases submitting CSV files must follow the exact specifications described in the CSV Instruction Guide above and should use the specifications provided below.

As outlined in the CSV instruction guide, bases must identify the driver and the vehicle that serviced each trip by including the driver and vehicle TLC license numbers in the main trip record file.

Please note that bases are no longer allowed to include the base’s internal IDs for drivers and vehicles.

Files are comma-delimited and use double quotations as escape characters. For more information about the required format for trip records submitted as CSV, please use the references below. Bases submitting CSV file(s) must submit via SFTP (see Upload Process Options, below).

CSV Trip Record File
Trip Record CSV Spec – Main trip record specification. Files are comma-delimited and use double quotations as escape characters. 
File naming convention: baselicense_yyyymmdd-yyyymmdd.csv 
Example: Trip Record CSV Example



<< Previous   Main Page   Next >>