264582
264582 - NW-7R9TLB Manual Microlise Trigger
Copyright OBS Logistics © 2009
The information contained herein is the property of OBS Logistics and is supplied without liability for errors or omissions. No part may be reproduced or used except as authorised by contract or other written permission. The copyright and foregoing restriction on reproduction and use extend to all media in which the information may be embodied
Functional Overview
Client Requirement
Messages from MTS to Microlise and other enabling systems can currently be managed automatically based on a flag set against the Tractor or Trailer. In some instances a driver may carry a portable MDT only and in these instances a separate method of triggering the message to the Microlise TMC will be required.
From Trip Manipulation or Trip Planning add a right click option to the Trip called "Send Enabling Message". Once selected this will trigger the Trip message to be sent to Microlise or another enabling system. A flag should also be added to the Trip Detail tab denoting that this message has been sent. I would suggest this should be called "Enabling Message Sent" and it should be added above the Manually Modified Flag. The existing FTL and GRP boxes can be moved so that they are adjacent rather than stacked.
This right click option should only become available once the Trip is in a status of ACCEPTED, once the check box is populated all other standard triggers around Trip updates should become enabled and be triggered automatically. If the Trip status is regressed to before ACCEPTED the check box should be unchecked and only checked again once the status is set back to ACCEPTED and the right click option selected.
Solution
The two trip screens TRIPSUM and TRIP_PLAN will have an additional option on the right click menu from the trip tree. The option will be labelled ‘Send Enabling Message’. Using the existing functionality, a number of trips from the trip tree can be highlighted, and then from the right click menu all the highlighted trips can be sent.
The new functionality will be based on the f_trip_tree.send_message code, the output being changed to create a new record on the INT_XML_CONTROL table (Interface errors transaction) for each highlighted trip. This record is the instruction for an XML trip message to be created for the trip on the next file creation cycle (set to 1 min intervals). Once a file is created, the processed record is stamped with the XML filename. If an unprocessed trip record exists waiting for the next file creation, the right click option for the same trip will not take any action.
The file creation cycle is a database job that runs permanently and every minute will produce a file in the required XML format for each requested trip. The XML files are FTP transferred to ESI, transformed to the Enabling Tool format and pushed to the Enabling Application.
Both Trip screens will be changed to show the date/time for the last sent message to Microlise with a label of ‘Last Sent Enabling’ on the Trip Details tab. The last sent date/time will not show on screen if the Trip Status is PLANNED or TENDERED. This covers the requirement to initialise the date/time if the trip status is regressed from ACCEPTED.
The TRIP_PLAN form has a space between the Delivery Type and Vehicle where the new field will be positioned.
The TRIPSUM change will include repositioning the FTL, GRP etc. flags to fit the new field above the Total Miles
Scope
This change will be applied to system version 10.6.
Data
Newly created table INT_XML_CONTROL will be used by triggers to inform the database job that an outbound XML is required.
This table will have a trigger to populate some fields including the unique identier populated by the new sequence seq_int_xml.
Functional Description
Trip Summary
Form changes as follows :-
A new option will be made available on the right click menu on the Trip below the existing ‘Send Message’ option.
It will be called ‘Send Enabling Message’ and when selected it will populate the standard INT_XML_CONTROL table with the appropriate data.
This in turn will result an already existing database job producing a file in the standard XML format and sending it to Microlise.
A second change to the form will be to shift the Vehicle field up a line and then add a new line where the Vehicle field was called ‘Enabling Sent’.
This will display the latest created date from the INT_XML_CONTROL record to inform the user that a message has already been sent to Microlise and when it was sent.
Trip Manipulation
Form changes as follows :-
A new option will be made available on the right click menu on the Trip below the existing ‘Send Message’ option.
It will be called ‘Send Enabling Message’ and when selected it will populate the standard INT_XML_CONTROL table with the appropriate data.
This in turn will result an already existing database job producing a file in the standard XML format and sending it to Microlise.
A second change to the form will be to shift the FTL and GRP flags to the same line, move the other flags up a line and add a new field to where ‘Elapsed Time’ is currently displayed called ‘Enabling Sent’.
This will display the latest created date from the INT_XML_CONTROL record to inform the user that a message has already been sent to Microlise and when it was sent.
References
Not Available
Document History
| Initial version | ||||
| Reviewed and Issued |
Authorised By
| Matt Crisford | Development Manager | |
| Suk Sandhu | TMSCC MTS Product Manager |
