Telematics data collection and import process overview
You can import telematics data that is collected on an external device and then exported to an XML file. The telematics data cycle includes collecting, storing, importing, and processing the data.
Sample scenario
A typical life cycle for telematics data has several steps.
- Vehicle data is recorded in an on-board data-collection device. The data-collection device might be a polling device, such as a tire-pressure monitoring system. Or it might gather data based on error reporting, such as for low fluid levels.
- Data is periodically extracted from the collection devices and stored in a database or a file.
- The data is reviewed or used to generate reports.
- The data is exported into an XML file.
- The telematics data in the XML file is imported into the telematics transactions table (PLUSTTELETRANS) in the Maximo® database.
- The data in the telematics transactions table is processed. The processing generates actions in response to the telematics data. Examples of the actions are work order creation and meter reading updates.
- Successfully processed codes are deleted or moved to a storage location. Codes that generate errors can be edited then submitted for processing again.
The first four steps happen independently of IBM® Maximo for Transportation. You use Maximo for Transportation to import and process the telematics data. The data must be in an XML file, in a specific format.
Maximo for Transportation applications and telematics data
| Application | Function |
|---|---|
| Organizations (Tr) | Used to configure your system so that you can
import and process telematics data. Use the Telematics Import Setup window in the Organizations (Tr) application to create one or more data import templates. You typically create one template for each data source. You create templates to map the data elements from an XML file to fields in the telematics transactions table, so that the data can be imported. For each template, you specify an XML file and an XSD file. The XML file contains the data that is to be imported. The XSD file validates the integrity of the XML file. Ensure that the XML files and XSD files match the required format. |
| Telematics Codes (Tr) | For a telematics code to be recognized during data processing, a record for the code must exist in the Maximo database. Use the Telematics Codes (Tr) application to create a record for each telematics code that you want to process. When you create a telematics code record, you specify at least one action that is to be generated when the telematics code is processed. |
| Telematics Data Import (Tr) | Used to import the telematics data and to process it after it is imported. Processing the data includes generating an action, such as updating a meter reading. Also used to handle errors that are generated. |
After you set up and establish your processes for importing and processing your telematics data, you can create cron tasks to import and process the data. After you begin to use cron tasks to import and process telematics data, you typically use the Telematics Data Import (Tr) application only to process errors.