Returns all timerecording bookings within desired timerange.
get_timerecording.asp?company=COMPANY_RTIKEY&import=COMPANY_IMPORTKEY&begin=YYYYMMDDHHMMSS&end=YYYYMMDDHHMMSS&mode=CSV&version=2
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 |
A string will be returned. In case of error "ERROR:Description".
The returning data matching the specification of Reiner SCT import definition.
The returning data matching the specification of BOTIME. A TXT file will be returned. The requested date is based on timerecording date and not the date of message processing.
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.
Separator | Semicolon ( ; ) |
---|---|
Delimiter | Double quote ( " ) |
Line break | 0x0D 0x0A (CarriageReturn LineFeed) |
Header | Row 1 |
Encoding | Windows-1252 |
Column | Description | |
---|---|---|
DATETIME | Date | 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 |
|
"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"; |
http://map.yellowfox.de/rti/get_timerecording.asp?company=COMPANY_RTIKEY&import=COMPANY_IMPORTKEY&begin=20151102000000&end=20151108235959&mode=CSV&version=2 |
http://map.yellowfox.de/rti/get_timerecording.asp?company=COMPANY_RTIKEY&import=COMPANY_IMPORTKEY&begin=20151026000000&end=20151101235959&mode=RSCT |