Wiki source code of dt_rdl.php (Command: list)
Last modified by YellowFox_RD on 2025/01/23 08:59
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | (% class="box" %) | ||
| 2 | ((( | ||
| 3 | Table of Contents | ||
| 4 | ))) | ||
| 5 | |||
| 6 | {{toc/}} | ||
| 7 | |||
| 8 | (% class="mark red" %)DEPRECATED(%%) | ||
| 9 | Please use [[get_file_list.php>>doc:YellowFox Remote Tracking Interface.Funktionen.Abfrageseiten.get_file_list\.php.WebHome]]. | ||
| 10 | Returns a list of files, which were downloaded from digital tachograph. | ||
| 11 | |||
| 12 | = Description = | ||
| 13 | |||
| 14 | **dt_rdl.php?company**=//COMPANY_RTIKEY//**&vehicle**=//VEHICLE_RTIKEY//**&command**=list**&show**=new**&start**=//YYYYMMDDHHMMSS//**&end**=//YYYYMMDDHHMMSS// | ||
| 15 | |||
| 16 | = Parameter = | ||
| 17 | |||
| 18 | |=Parameter|=Description|=Type|=Note|=Mandatory | ||
| 19 | |company|RTI company key|string| |yes | ||
| 20 | |vehicle|RTI vehcile key|string|vehicle or group parameter|(yes) | ||
| 21 | |group|RTI group key|string|vehicle or group parameter|(yes) | ||
| 22 | |import|RTI import key|string|or import parameter for all vehicles|(yes) | ||
| 23 | |command|command: list|string| |yes | ||
| 24 | |show|'all': shows all files | ||
| 25 | 'new': shows files which are not downloaded up to now|string| |yes | ||
| 26 | |start|begin of requested timerange|datestring|Format: YYYYMMDDHHMMSS|no | ||
| 27 | |end|end of requested timerange|datestring|Format: YYYYMMDDHHMMSS|no | ||
| 28 | |format|return format|string|csv|no | ||
| 29 | |date_type|'process' Uses the date time where the file was firstprocessed by YellowFox, | ||
| 30 | and not the file creation date. This setting affects the meaning of the parameters | ||
| 31 | 'start' and 'end' and the return value DATETIME inside the CSV| | |no | ||
| 32 | |||
| 33 | = Return = | ||
| 34 | |||
| 35 | Return a **string**. In case of error it returns "(% class="error" %)**ERROR:Description**(%%)". | ||
| 36 | |||
| 37 | == CSV Format == | ||
| 38 | |||
| 39 | === Meta informations === | ||
| 40 | |||
| 41 | |=Separator|Semicolon ( ; ) | ||
| 42 | |=Delimiter|Double quote ( " ) | ||
| 43 | |=Line break|0x0D 0x0A (CarriageReturn LineFeed) | ||
| 44 | |=Header|Line 1 | ||
| 45 | |||
| 46 | === Header === | ||
| 47 | |||
| 48 | **Header informations** | ||
| 49 | {{code language="java"}}"DID";"DATETIME";"NEW";"FILENAME","VEHICLE","TYPE";"DRIVERID";"DRIVERNAME";{{/code}} | ||
| 50 | |||
| 51 | === Columns === | ||
| 52 | |||
| 53 | |=Column|=Description|= | ||
| 54 | |DID|ID of downloaded file (important for download of RTI file)| | ||
| 55 | |DATETIME|date when file was created, or if date_type=process the processing date|Format: YYYYMMDDHHMMSS | ||
| 56 | |NEW|1 - get new files, 0 - already downloaeded| | ||
| 57 | |FILENAME|file name| | ||
| 58 | |VEHICLE|license plate of vehicle where file was downloaded| | ||
| 59 | |TYPE|driver or vehicle| | ||
| 60 | |DRIVERID|card number of driver (first 13 token will be used)| | ||
| 61 | |DRIVERNAME|name of driver| | ||
| 62 | |||
| 63 | === Example === | ||
| 64 | |||
| 65 | {{code language="java"}} | ||
| 66 | "DID";"DATETIME";"NEW";"FILENAME";"VEHICLE";"TYPE";"DRIVERID";"DRIVERNAME" | ||
| 67 | "123456";"20120725001100";"1";"C_20120725_0011_Slot_1_1000000000000.DDD";"DD-YF 2012";"DRIVER";"1000000000000";"Testfahrer" | ||
| 68 | "789012";"20120725144700";"0";"M_20120725_1447__DD-YF_2012___WDB324865L2222229.DDD";"DD-YF 2012";"VEHICLE";"";"" | ||
| 69 | {{/code}} | ||
| 70 | |||
| 71 | = Example Calls = | ||
| 72 | |||
| 73 | **Request to get list of files** | ||
| 74 | {{code language="java"}}https://map.yellowfox.de/rti/dt_rdl.php?company=COMPANY_RTIKEY&vehicle=VEHICLE_RTIKEY&command=list&show=new&start=20151020120000&end=20151025120000{{/code}} | ||
| 75 |