DWH & INTERFACES
The DWH interfaces, with a pivot format, the data of the theoritical repository to diffuse towards the applications. Interfaces are designed and developed according to the needs, uses and application environment of our clients. Our objectives are: automation, modeling and productivity (saving time in calculations, manipulations and processing). Camtek solutions are data boosters.
Tools interfaces
Upstream interfaces
automated interfaces and to DWH from HASTUS, OKAPI, HEURES... consistency and quality tests
SCHEDULING
OPERATOR
Downstream interfaces
Automated exports (stop tables, lines and sub-lines, routes, calendar...) to ticketing systems (ACS, ERG...), consistency & quality tests
TICKETING
Downstream interfaces
Automated exports (geographical repository, route tables, calendar, agent services...) to AVL (VIX, NAVINEO...), consistency & quality tests
OPERATING
AVL
Plugin [NTX]
Generator of files theoretical offer to the Public Transport Authority
NETEX
Plugin [XGT]
Generator of offer files in GTFS format
GTFS
Formatting interfaces
Plugin [DXH]
Automated editing (HTML, EXCEL, mobile), according to calibrated templates, with settings and layout module
TIME SHEET
Plugin [DSP]
Presentation of the deviation sheets (dates and time slot), statistical follow-up
DETOUT
VIATION
Plugin [FDS]
Automated editing (HTML, WORD), mobile, according to calibrated templates, with settings and layout module
DUTY
ROSTER
Plugin [CMP]
Positioning of stops, updating of stop characteristics and equipment
MAPPING
OF STOPS
Plugin [FSL]
Automated output of statistical data (with graphical representation) by commercial line
MARKETING
FILE
Analysis interfaces
Plugin [AT1]
Structural analysis of the gain or loss components of public transit run-time
RUN-TIME
ANALYSIS
Plugin [DLA]
Queries on predefined filters, presentation by object (stop, line, route...), integration with calculation reports (cross references...)
STANDARD QUERIES
Plugin [DTS]
Extraction of work units, multi-carrier calendar management, multi-vehicles types
OUTPUT
UNIT
Business interfaces
Plugin [DXG]
Daily monitoring of the transit offer (reporting, invoicing, declarations, operating reports, downgraded offers)
EVENT
BOOK
Plugin [SYGECO]
Organization of traveller control actions, recording of control acts, follow-up, management chart, performance and analysis
CONTROL
FUNCTION
Plugin [DQS]
Insertion of ticketing validation data, quality of service status of 'Lines - Directions' information
QUALITY
OF SERVICE
Plugin [DXG]
Entry of events (internal or external) reducing the transit offer or modifying the number of kilometers done
DISTURBANCES
Plugin [CIRCE]
Transformation of the geographic coordinates and projections (two-dimension, Lambert-93,...)
GEOGRAPHIC
COORDONATES
Plugin [ATL]
Follow the processing of a report issued by a driver or a dispatcher, then processed by the workshop
WORKSHOP
Plugin [NVR]
Carpooling plan, editing of instructions, statistical dashboard