You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

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

parameterdescriptiontypenotemandatory
companyRTI company keystring yes
importRTI import keystring yes
beginoutput start timestringthe output timerange is limited to 31 daysyes
endoutput end timestringthe output timerange is limited to 31 daysyes
modeoutput formatstring

valid output formats

  • CSV
  • RSCT 
yes
versionalternative CSV outputintegera value of "2" add geocoordinates for outputno

Return

A string will be returned. In case of error "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

SeparatorSemicolon ( ; )
DelimiterDouble quote ( " )
Line break0x0D 0x0A (CarriageReturn LineFeed)
HeaderZeile 1
EncodingUTF-8

Columns

ColumnDescription 
DATETIMEDateformat DD.MM.YYYY HH:MM:SS
ACTION

Short booging type definition

  • K, G, X, Y, B, E
ACTIONTEXT

Description text for booking as defined

POSITIONAufgelö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"
DRIVERKEYpersonal key of person who did the booking 
DRIVERNAMEname 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

"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
  • No labels