Returns all timerecording bookings within desired timerange.
Description
get_timerecording.asp?company=COMPANY_RTIKEY&import=COMPANY_IMPORTKEY&begin=YYYYMMDDHHMMSS&end=YYYYMMDDHHMMSS&mode=CSV&version=2
Parameter
parameter | description | type | note | mandatory |
---|---|---|---|---|
company | RTI company key | string | yes | |
import | RTI import key | string | yes | |
begin | output start time | string | the output timerange is limited to 31 days | yes |
end | output end time | string | the output timerange is limited to 31 days | yes |
mode | output format | string | valid output formats
| yes |
version | alternative CSV output | integer | a value of "2" add geocoordinates for output | no |
Return
On error return "ERROR:Beschreibung".
Reiner SCT Format
The returning data matching the specification of Reiner SCT import definition.
CSV Format
On success, the data will be delivered in csv (comma seperated values) format. The first line always is defined as head with column names. The following rows containing the booking data.
Meta informations
Separator | Semicolon ( ; ) |
---|---|
Delimiter | Double quote ( " ) |
Line break | 0x0D 0x0A (CarriageReturn LineFeed) |
Header | Zeile 1 |
Encoding | UTF-8 |
Columns
Column | Description |
---|---|
DATETIME | Date with format DD.MM.YYYY HH:MM:SS |
ACTION | Short booging type definition
|
ACTIONTEXT | Description text for booking as defined
|
POSITION | Aufgelöster Positionstext |
AREA | Cost centers/areas, as defined for this Position
|
DRIVERKEY | personal key of person who did the booking |
DRIVERNAME | name of person who did the booking |
CAR | portal Name of object, where the booking was done |
LAT | Latitude
|
LON | Longitude
|
Output example
"DATETIME";"ACTION";"ACTIONTEXT";"POSITION";"AREA";"DRIVERKEY";"DRIVERNAME";"CAR";"LAT";"LON"; "01.10.2015 08:00:00";"K";"work start";"Examplestreet 17, 01234 Examplecity";"head office";"12345";"Sam Smith";"MU-YF 1";"51.4";"13.1"; "01.10.2015 08:00:00";"X";"pause start";"Testroad 23, 91234 Testvillage";"John Doe GmbH";"12345";"Sam Smith";"MU-YF 1";"52";"11.3";
Examples
get bookings with geo coordinates
http://map.yellowfox.de/rti/get_timerecording.asp?company=COMPANY_RTIKEY&import=COMPANY_IMPORTKEY&begin=20151102000000&end=20151108235959&mode=CSV&version=2
get bookings for Reiner SCT import
http://map.yellowfox.de/rti/get_timerecording.asp?company=COMPANY_RTIKEY&import=COMPANY_IMPORTKEY&begin=20151026000000&end=20151101235959&mode=RSCT