dt_rdl.php (Command: list)
Last modified by YellowFox_RD on 2024/12/19 10:11
Table of Contents
DEPRECATED
Please use get_file_list.php (https://doc.yellowfox.net/display/RTI/get_file_list.php).
Returns a list of files, which were downloaded from digital tachograph.
Description
dt_rdl.php?company=COMPANY_RTIKEY&vehicle=VEHICLE_RTIKEY&command=list&show=new&start=YYYYMMDDHHMMSS&end=YYYYMMDDHHMMSS
Parameter
| Parameter | Description | Type | Note | Mandatory |
|---|---|---|---|---|
| company | RTI company key | string | yes | |
| vehicle | RTI vehcile key | string | vehicle or group parameter | (yes) |
| group | RTI group key | string | vehicle or group parameter | (yes) |
| import | RTI import key | string | or import parameter for all vehicles | (yes) |
| command | command: list | string | yes | |
| show | 'all': shows all files 'new': shows files which are not downloaded up to now | string | yes | |
| start | begin of requested timerange | datestring | Format: YYYYMMDDHHMMSS | no |
| end | end of requested timerange | datestring | Format: YYYYMMDDHHMMSS | no |
| format | return format | string | csv | no |
| date_type | 'process' Uses the date time where the file was firstprocessed by YellowFox, and not the file creation date. This setting affects the meaning of the parameters 'start' and 'end' and the return value DATETIME inside the CSV | no |
Return
Return a string. In case of error it returns "ERROR:Description".
CSV Format
Meta informations
| Separator | Semicolon ( ; ) |
|---|---|
| Delimiter | Double quote ( " ) |
| Line break | 0x0D 0x0A (CarriageReturn LineFeed) |
| Header | Line 1 |
Header
Header informations
"DID";"DATETIME";"NEW";"FILENAME","VEHICLE","TYPE";"DRIVERID";"DRIVERNAME";
Columns
| Column | Description | |
|---|---|---|
| DID | ID of downloaded file (important for download of RTI file) | |
| DATETIME | date when file was created, or if date_type=process the processing date | Format: YYYYMMDDHHMMSS |
| NEW | 1 - get new files, 0 - already downloaeded | |
| FILENAME | file name | |
| VEHICLE | license plate of vehicle where file was downloaded | |
| TYPE | driver or vehicle | |
| DRIVERID | card number of driver (first 13 token will be used) | |
| DRIVERNAME | name of driver |
Example
"DID";"DATETIME";"NEW";"FILENAME";"VEHICLE";"TYPE";"DRIVERID";"DRIVERNAME"
"123456";"20120725001100";"1";"C_20120725_0011_Slot_1_1000000000000.DDD";"DD-YF 2012";"DRIVER";"1000000000000";"Testfahrer"
"789012";"20120725144700";"0";"M_20120725_1447__DD-YF_2012___WDB324865L2222229.DDD";"DD-YF 2012";"VEHICLE";"";""
"123456";"20120725001100";"1";"C_20120725_0011_Slot_1_1000000000000.DDD";"DD-YF 2012";"DRIVER";"1000000000000";"Testfahrer"
"789012";"20120725144700";"0";"M_20120725_1447__DD-YF_2012___WDB324865L2222229.DDD";"DD-YF 2012";"VEHICLE";"";""
Example Calls
Request to get list of files
https://map.yellowfox.de/rti/dt_rdl.php?company=COMPANY_RTIKEY&vehicle=VEHICLE_RTIKEY&command=list&show=new&start=20151020120000&end=20151025120000