Compatibility

This function is intended to be used with timerecording V3

If you are using the older V2 version, please use get_timerecording.asp

Returns all received timerecording bookings for the requested time range. This range may refer to the processing time in our computing center or to the booked date and time.

In case you are using bookings based on digitacho files, there is a delay of multiple hours between the booked time and when this booking is available via rti. The digitacho files with all bookings per (work) day are typically submitted at the next work day. Then this digitacho bookings will be translated into time bookings and are available after this is done. So working with digitacho bookings requires to use the insert date to get catch all bookings without a gap.

Description

get_timerecording.php?output=bookingslist&company=COMPANY_RTIKEY&import=COMPANY_IMPORTKEY&begin=YYYYMMDDHHMMSS&end=YYYYMMDDHHMMSS&format=CSV&version=1&date_query=insert

Parameter

Parameter	Description	Type	Hint	Mandatory
company	RTI company key	string		yes
import	RTI import key	string		yes
begin	start time for output	string	the difference between start and end must not ecxeed 31 days	yes
end	end time for output	string	the difference between start and end must not ecxeed 31 days	yes
format	output format	string	valid output formats csv json xml	yes
version	version number for request	integer	currently there is only the version 1 on change of any output parameter this version number will change, too	no
date_query	set the date reference for request	string	'insert' (default) = get bookings by processing time 'gps' = get booking by booked date and time	no

Return values

This funtion returns a string. On error the return will be "Error:Description".

CSV Format

Returning a row per booking with all the data as defined below

Meta informations

Separator	Semicolon ( ; )
Delimiter	Double quote ( " )
Line break	0x0D 0x0A (CarriageReturn LineFeed)
Header	Row 1
Encoding	Windows-1252

Columns

Column	Description
PERSON_ID	self defined person number in portal listed as "Ma-Nr"
PERSON_KEY	Booking key, used by person
PERSON_NAME	name of person
PERSON_CARD_NUMBER	self defineable additional booking number in portal listed as "Card Nr"
DATETIME	Date	format DD.MM.YYYY HH:MM:SS
ACTIVITY_ID	Short booging type definition
ACTIVITY_NAME	Description text for booking as defined
TERMINAL	portal Name of object, where the booking was done
LAT	Latitude
LON	Longitude
ADDRESS	Aufgelöster Positionstext
AREA	areas, as defined for this Position	delimiter: "%\|%"
DRIVERKEY	personal key of person who did the booking
COST_CENTER_ID	technical ident of cost center
COST_CENTER_NAME	name of used cost center

example

"PERSON_ID";"PERSON_KEY";"PERSON_NAME";"PERSON_CARD_NR";"DATETIME";"ACTIVITY_ID";"ACTIVITY_NAME";"TERMINAL";"LAT";"LON;""ADDRESS";"AREA";"COST_CENTER_ID";"COST_CENTER_NAME"
"A23";"DF000000000123";"John Smith";"";"01.10.2019 08:00:00";"1023";"work";"DD-YF 123";"51.4";"13.1";"Musterstraße 17, 01234 Musterstadt";"Hauptzentrale";"K-47";"common work"
"A23";"DF000000000123";"John smith";"";"01.10.2019 12:00:00";"1024";"break";"DD-YF 123";"52.0";"11.3";"Testweg 23, 91234 Testhausen";"Müller GmbH";"";""

JSON Format

Returns a JSON formatted string with detailed data per booking

Example output

JSON output

[
    {
        "person": {
            "id": "A23",
            "key": "DF00000001234",
            "name": "John Smith",
            "card_nr": null
        },
        "datetime": "2019-04-01 05:26:00",
        "activity": {
            "id": "1003",
            "name": "work time"
        },
        "terminal": "DD-YF 456",
        "position": {
            "lat": 51.4,
            "lon": 13.1,
            "address": "Am Wüsteberg 3, 01723 Kesselsdorf"
        },
        "area": null,
        "costcenter": {
            "id": null,
            "name": null
        }
    },
    {
        "person": {
            "id": "A23",
            "key": "DF00000001234",
            "name": "John Smith",
            "card_nr": null
        },
        "datetime": "2019-04-01 12:35:00",
        "activity": {
            "id": "1001",
            "name": "break time"
        },
        "terminal": "central",
        "position": {
            "lat": 52.0,
            "lon": 11.9,
            "address": "Am Wüsteberg 3, 01723 Kesselsdorf"
        },
        "area": null,
        "costcenter": {
            "id": "K-47",
            "name": "common"
        }
    }

XML Format

XML output

<?xml version="1.0"?>
<bookings>
    <booking>
        <person>
            <id/>
            <key>DF00000001234</key>
            <name>John Smith</name>
            <card_nr/>
        </person>
        <datetime>2019-04-01 05:26:00</datetime>
        <activity>
            <id>1003</id>
            <name>work time</name>
        </activity>
        <terminal>DD-YF 456</terminal>
        <position>
            <lat>51.0</lat>
            <lon>13.1</lon>
            <address>Am Wüsteberg 3, 01723 Kesselsdorf</address>
        </position>
        <area/>
        <costcenter>
            <id/>
            <name/>
        </costcenter>
    </booking>
    <booking>
        <person>
            <id/>
            <key>DF00000001234</key>
            <name>John Smith</name>
            <card_nr/>
        </person>
        <datetime>2019-04-01 12:35:00</datetime>
        <activity>
            <id>1001</id>
            <name>break</name>
        </activity>
        <terminal>central</terminal>
        <position>
            <lat>52.3</lat>
            <lon>11.09</lon>
            <address>Am Wüsteberg 3, 01723 Kesselsdorf</address>
        </position>
        <area/>
        <costcenter>
            <id>K-47</id>
            <name>allgemeines</name
        </costcenter>
    </booking>
</bookings>

Example request

http://map.yellowfox.de/rti/get_timerecording.php?output=bookingslist&company=COMPANY_RTIKEY&import=COMPANY_IMPORTKEY&begin=20151102000000&end=20151108235959&format=JSON

Page tree

get_timerecording.php