Wiki source code of dt_rdl.php (Command: list)

Last modified by YellowFox_RD on 2025/01/23 08:59
Show last authors
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