286729 - Revision history

DuttonT: /* TMS TRP Message to SMARTPHONE */

2011-06-28T14:34:45Z

TMS TRP Message to SMARTPHONE

← Older revision		Revision as of 16:34, 28 June 2011
Line 484:		Line 484:
	The system parameter SMA_OWNING_DEPOT will determine if the owning depot or database is sent in the filename to SMARTPHONE. The file will be sent with the naming convention :		The system parameter SMA_OWNING_DEPOT will determine if the owning depot or database is sent in the filename to SMARTPHONE. The file will be sent with the naming convention :

	~~'''~~== SMARTPHONE Messages into MTS ==~~'''~~		=== SMARTPHONE Messages into MTS ===

	A new job will run every minute to check if XML documents have been placed in the SMA inbound directory as stated in section 2.3 Data.		A new job will run every minute to check if XML documents have been placed in the SMA inbound directory as stated in section 2.3 Data.
Line 558:		Line 558:

	SCH_ORD_ITEMS_REASONS		SCH_ORD_ITEMS_REASONS


	=== Sample XML Inbound file ===		=== Sample XML Inbound file ===

DuttonT: /* SMARTPHONE Messages into MTS */

2011-06-28T14:33:55Z

SMARTPHONE Messages into MTS

← Older revision		Revision as of 16:33, 28 June 2011
Line 484:		Line 484:
	The system parameter SMA_OWNING_DEPOT will determine if the owning depot or database is sent in the filename to SMARTPHONE. The file will be sent with the naming convention :		The system parameter SMA_OWNING_DEPOT will determine if the owning depot or database is sent in the filename to SMARTPHONE. The file will be sent with the naming convention :

	== SMARTPHONE Messages into MTS ==		'''== SMARTPHONE Messages into MTS =='''

	A new job will run every minute to check if XML documents have been placed in the SMA inbound directory as stated in section 2.3 Data.		A new job will run every minute to check if XML documents have been placed in the SMA inbound directory as stated in section 2.3 Data.
Line 657:		Line 657:

	\|}		\|}


	=AUTHORISED BY=		=AUTHORISED BY=

DuttonT: /* Solution */

2011-06-28T14:32:14Z

Solution

← Older revision		Revision as of 16:32, 28 June 2011
Line 82:		Line 82:
	* '''''Trip/Order Level''' :-''		* '''''Trip/Order Level''' :-''
	** ''On inserting or deleting orders on trips at status EN-ROUTE or ACCEPTED (and SMA_SEND_ACCEPTED system registry is Y) if the trip header has a Carrier ID or driver that is Smartphone enabled then send TRP.''		** ''On inserting or deleting orders on trips at status EN-ROUTE or ACCEPTED (and SMA_SEND_ACCEPTED system registry is Y) if the trip header has a Carrier ID or driver that is Smartphone enabled then send TRP.''


	* '''''Order Line Level''' :-''		* '''''Order Line Level''' :-''
Line 118:		Line 119:

	\|}		\|}


	/webint/COLV/interface/SMA/OUT		/webint/COLV/interface/SMA/OUT
Line 218:		Line 220:

	\|}		\|}

DuttonT: /* Solution */

2011-06-28T14:30:59Z

Solution

← Older revision		Revision as of 16:30, 28 June 2011
Line 65:		Line 65:

	\|}		\|}


	The actual message will be added to a queue table to be generated where the following triggers are activated:		The actual message will be added to a queue table to be generated where the following triggers are activated:


	* '''''Trip Level''' :- ''		* '''''Trip Level''' :- ''

DuttonT: /* Enabling Message */

2011-06-28T14:22:09Z

Enabling Message

← Older revision		Revision as of 16:22, 28 June 2011
Line 466:		Line 466:


	<center>[[Image:~~286729_4~~.png]]</center>		<center>[[Image:286729_8.png]]</center>

DuttonT: /* Enabling Message */

2011-06-28T14:20:29Z

Enabling Message

← Older revision		Revision as of 16:20, 28 June 2011
Line 466:		Line 466:


	<center>[[Image:]]</center>		<center>[[Image:286729_4.png]]</center>


Line 472:		Line 472:

	The code behind the menu item will be amended to process SMARTPHONE messages. The new code will be added above the existing MICROLISE checks,to ensure that SMARTPHONE is processed first. The SMARTPHONE message will follow the same rules as the MICROLISE, only allowing a new TRP record for the trip to be created if there are no TRP records for the trip waiting in the control table to be processed.		The code behind the menu item will be amended to process SMARTPHONE messages. The new code will be added above the existing MICROLISE checks,to ensure that SMARTPHONE is processed first. The SMARTPHONE message will follow the same rules as the MICROLISE, only allowing a new TRP record for the trip to be created if there are no TRP records for the trip waiting in the control table to be processed.


	=== TMS TRP Message to SMARTPHONE ===		=== TMS TRP Message to SMARTPHONE ===

DuttonT: /* Outbound File */

2011-06-28T14:19:32Z

Outbound File

DuttonT: /* Outbound File */

2011-06-28T14:13:57Z

Outbound File

← Older revision		Revision as of 16:13, 28 June 2011
Line 412:		Line 412:
	\| style="border-top:none;border-bottom:none;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\|		\| style="border-top:none;border-bottom:none;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\|
	\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS = ACCEPTED and SMA_SEND_ACCEPTED =Y		\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS = ACCEPTED and SMA_SEND_ACCEPTED =Y




	\|-		\|-
	\| style="border-top:none;border-bottom:~~0.018cm solid #000000~~;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\|		\| style="border-top:none;border-bottom:none;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\|
	\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS = EN-ROUTE and the driver or carrier is changed		\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS = EN-ROUTE and the driver or carrier is changed

Line 431:		Line 429:
	\| style="border-top:0.018cm solid #000000;border-bottom:none;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| '''STOP'''		\| style="border-top:0.018cm solid #000000;border-bottom:none;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| '''STOP'''
	\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS =EN ROUTE and data for the first stop (where stop no =1 ) is changed		\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS =EN ROUTE and data for the first stop (where stop no =1 ) is changed




Line 499:		Line 495:

	The system parameter SMA_OWNING_DEPOT will determine if the owning depot or database is sent in the filename to SMARTPHONE. The file will be sent with the naming convention :		The system parameter SMA_OWNING_DEPOT will determine if the owning depot or database is sent in the filename to SMARTPHONE. The file will be sent with the naming convention :




	== SMARTPHONE Messages into MTS ==		== SMARTPHONE Messages into MTS ==

DuttonT: /* Resources Table and Screen Changes */

2011-06-28T14:10:58Z

Resources Table and Screen Changes

← Older revision		Revision as of 16:10, 28 June 2011
Line 299:		Line 299:


	<center>[[Image:]]</center>		<center>[[Image:286729_4.png]]</center>


Line 305:		Line 305:


	<center>[[Image:]]</center>		<center>[[Image:286729_5.png]]</center>


Line 313:		Line 313:


	<center>[[Image:]]</center>		<center>[[Image:286729_6.png]]</center>


Line 319:		Line 319:


	<center>[[Image:]]</center>		<center>[[Image:286729_7.png]]</center>


Line 329:		Line 329:

	When determining if a record should be created in the control table, the code currently assess if a trip has MICROLISE enabled resources. The code will be amended to assess if the trip has SMARTPHONE resources assigned, if there are no SMARTPHONE resources, the code will then check for MICROLISE. A control record will only be created for MICROLISE in the event that a SMARTPHONE record is not required.		When determining if a record should be created in the control table, the code currently assess if a trip has MICROLISE enabled resources. The code will be amended to assess if the trip has SMARTPHONE resources assigned, if there are no SMARTPHONE resources, the code will then check for MICROLISE. A control record will only be created for MICROLISE in the event that a SMARTPHONE record is not required.


	== Outbound File ==		== Outbound File ==

DuttonT: /* Data */

2011-06-28T14:10:00Z

Data

@@ Line 284: / Line 284: @@
 Insert into ADM_SYSTEM_PARAM (param_name, value, data_type, max_length, displayed, user_modifiable, description, config_by, config_by_value)
-Description:
+[[Image:286729_1.png]]
-SMA_OWNING_DEPOTY
+[[Image:286729_2.png]]
 = Functional Description =

← Older revision		Revision as of 16:19, 28 June 2011
Line 405:		Line 405:
	\| style="border-top:0.018cm solid #000000;border-bottom:none;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| '''TRIP'''		\| style="border-top:0.018cm solid #000000;border-bottom:none;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| '''TRIP'''
	\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS = EN-ROUTE OR DELETED		\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS = EN-ROUTE OR DELETED




	\|-		\|-
	\| style="border-top:none;border-bottom:none;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\|		\| style="border-top:none;border-bottom:none;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\|
	\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS = ACCEPTED and SMA_SEND_ACCEPTED =Y		\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS = ACCEPTED and SMA_SEND_ACCEPTED =Y


	\|-		\|-
Line 429:		Line 425:
	\| style="border-top:0.018cm solid #000000;border-bottom:none;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| '''STOP'''		\| style="border-top:0.018cm solid #000000;border-bottom:none;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| '''STOP'''
	\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS =EN ROUTE and data for the first stop (where stop no =1 ) is changed		\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS =EN ROUTE and data for the first stop (where stop no =1 ) is changed


	\|-		\|-
	\| style="border-top:none;border-bottom:none;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\|		\| style="border-top:none;border-bottom:none;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\|
	\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS =ACCEPTED and SMA_SEND_ACCEPTED = Y and the data for the first stop (where stop no =1) is changed		\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS =ACCEPTED and SMA_SEND_ACCEPTED = Y and the data for the first stop (where stop no =1) is changed




	\|-		\|-
	\| style="border-top:none;border-bottom:none;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\|		\| style="border-top:none;border-bottom:none;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\|
	\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS =EN-ROUTE and the arrive or depart times are changed		\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS =EN-ROUTE and the arrive or depart times are changed




	\|-		\|-
	\| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\|		\| style="border-top:none;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\|
	\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS =ACCEPTED and SMA_SEND_ACCEPTED=Y and the arrive or depart times are changed		\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS =ACCEPTED and SMA_SEND_ACCEPTED=Y and the arrive or depart times are changed



	\|-		\|-
Line 462:		Line 449:
	\| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| '''ORDER LINE'''		\| style="border-top:0.018cm solid #000000;border-bottom:0.018cm solid #000000;border-left:0.018cm solid #000000;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| '''ORDER LINE'''
	\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS = ACCEPTED and ACTUAL_DESPATCHED_QUANTITY on the order line has changed		\| style="border:0.018cm solid #000000;padding-top:0cm;padding-bottom:0cm;padding-left:0.191cm;padding-right:0.191cm;"\| STATUS = ACCEPTED and ACTUAL_DESPATCHED_QUANTITY on the order line has changed



	\|-		\|-
Line 474:		Line 459:

	\|}		\|}


	=== Enabling Message ===		=== Enabling Message ===