| Info |
|---|
| This function is intended to be used with timerecording V2 If you are using the newer V3 version, please use get_timerecording.php |
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 | | date_query | which date column is base for date query | string | 'insert' (default) : date of proceed 'gps' : date of timerecording message | no |
ReturnA 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 |
|---|
Columns| 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 | - delimiter: "%|%"
- structure: cost center + space + area name
- example: "101 construction site A%|%201 construction site B%|%456 customer smith"
| | 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 | - example: "51.4"
- only for "mode=CSV" and "version=2"
| | LON | Longitude | - example: "13.1"
- only for "mode=CSV" and "version=2"
|
example| Code Block |
|---|
"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| Code Block |
|---|
| title | get bookings with geo coordinates |
|---|
| httphttps://map.yellowfox.de/rti/get_timerecording.asp?company=COMPANY_RTIKEY&import=COMPANY_IMPORTKEY&begin=20151102000000&end=20151108235959&mode=CSV&version=2 |
| Code Block |
|---|
| title | get bookings for Reiner SCT import |
|---|
| httphttps://map.yellowfox.de/rti/get_timerecording.asp?company=COMPANY_RTIKEY&import=COMPANY_IMPORTKEY&begin=20151026000000&end=20151101235959&mode=RSCT |
|