EST 337120 Sterling Portal Interface - Revision history

Anw: Minor format changes

2016-09-13T15:05:36Z

Minor format changes

← Older revision		Revision as of 17:05, 13 September 2016
Line 7:		Line 7:
	\|The_version_of_the_document=1.0		\|The_version_of_the_document=1.0
	\|Your_Name=A N Walker		\|Your_Name=A N Walker
	\|Supimix_PO_Reference=		\|Supimix_PO_Reference=
	\|Supimix_Priority=3		\|Supimix_Priority=3
	\|Date_(DD/MM/YY)=13/09/16		\|Date_(DD/MM/YY)=13/09/16

Anw: Slight change to estimate

2016-09-13T10:26:19Z

Slight change to estimate

← Older revision		Revision as of 12:26, 13 September 2016
Line 56:		Line 56:
	\|Functional_Specification_Days=2.5		\|Functional_Specification_Days=2.5
	\|Technical_Specification_Days=0.0		\|Technical_Specification_Days=0.0
	\|Development_Days=10.5		\|Development_Days=10.25
	\|Testing_and_Release_Days=2.5		\|Testing_and_Release_Days=2.5
	\|Implementation_Days=0.25		\|Implementation_Days=0.25

Anw: v1.0 - Issue after review by Phil Harding

2016-09-13T10:23:36Z

v1.0 - Issue after review by Phil Harding

← Older revision		Revision as of 12:23, 13 September 2016
Line 5:		Line 5:
	\|Supimix_Client_Reference=PL-STERLING PORTAL		\|Supimix_Client_Reference=PL-STERLING PORTAL
	\|Supimix_Number=337120		\|Supimix_Number=337120
	\|The_version_of_the_document=0.1		\|The_version_of_the_document=1.0
	\|Your_Name=A N Walker		\|Your_Name=A N Walker
	\|Supimix_PO_Reference=		\|Supimix_PO_Reference=
Line 23:		Line 23:


	A new export configuration will be added to each site, to control the sending of the Job Completion export file to Sterling's Portal. The rule allowing only one configuration per type to be added to a configuration will be relaxed, so that this export configuration may be added.		A new export configuration will be added to each site, to control the sending of the Job Completion export file to Sterling's Portal. The rule allowing only one configuration per type to be added to a configuration will be relaxed, so that this export configuration may be added. The configuration will set the destination FTP directory and file naming specification and connectivity parameters to be the same for each of the sites.


	The database will be modified to create an Export Control record for each job that requires it, at the point that a job is set to Completed or Cancelled status. This will be triggered by the database at the point of completion and will be largely sourced from the existing package that decides which configuration requires an export. These changes will reduce development costs and increase the speed of the export process. The process will be modified slightly to obey the configuration against the site, rather than requiring the configuration to be the same name as the site code - this is required to allow the control records to be written.		The database will be modified to create an Export Control record for each job that requires it, at the point that a job is set to Completed or Cancelled status. This will be triggered by the database at the point of completion and will be largely sourced from the existing package that decides which configuration requires an export. These changes will reduce development costs and increase the speed of the export process. The process will be modified slightly to obey the configuration against the site, rather than requiring the configuration to be the same name as the site code - this is required to allow the control records to be written.
Line 32:		Line 33:
	The Export process for jobs will be changed to retrieve the control records rather than attempt to find each job that requires updating. The job associated to the control record will be retrieved at the same time. This will ensure a far more efficient export process.		The Export process for jobs will be changed to retrieve the control records rather than attempt to find each job that requires updating. The job associated to the control record will be retrieved at the same time. This will ensure a far more efficient export process.

	The process will 'batch' similar export files together, and produce the XML once only, replicating this to several files. The process will produce the files in a temporary area, and will send all FTP files for the same destination at the same time. Only then will a file be marked as successfully sent.		The process will 'batch' similar export files together, and produce the XML once only, replicating this to several files. The process will produce the files in a temporary area, and will send all FTP files for the same destination at the same time. Only then will a file be marked as successfully sent.
			The files will be named based on the Export configuration, expected to be:
			: EPOD_STIRLING_<SITE>_<DATE>_<TIME>_<SEQ>.XML

			For example:
			:EPOD_STIRLING_L01_20160805_093427_80.XML
			:EPOD_STIRLING_L01_20160805_093427_81.XML
			:EPOD_STIRLING_L03_20160805_093427_80.XML
			Note that the sequence may only be unique for the site file being sent, rather than for all messages sent in that batch.


	Any issues with creating or sending the export file will result in the Error or Reprocess status being set against the control record, as normal.		Any issues with creating or sending the export file will result in the Error or Reprocess status being set against the control record, as normal.
Line 43:		Line 53:

	\|Requirements_Days=0.0		\|Requirements_Days=0.0
	\|Estimation_Days=0.5		\|Estimation_Days=0.75
	\|Functional_Specification_Days=2.5		\|Functional_Specification_Days=2.5
	\|Technical_Specification_Days=2.5		\|Technical_Specification_Days=0.0
	\|Development_Days=10.5		\|Development_Days=10.5
	\|Testing_and_Release_Days=2.5		\|Testing_and_Release_Days=2.5

Anw: v0.1 - Initial Draft

2016-09-13T09:04:00Z

v0.1 - Initial Draft

← Older revision		Revision as of 11:04, 13 September 2016
Line 12:		Line 12:
	\|Clients_Customer=ALL		\|Clients_Customer=ALL
	\|System_Version_being_changed=3.3.X		\|System_Version_being_changed=3.3.X
	\|Client_Request=		\|Client_Request=From Stirling - [mailto:phil.hall@stirlingsolutions.co.uk Phil Hall] on Tuesday, 26 July, 2016 4:28 PM, cc John Davidson.
	\|OBS_Solution=
	\|Requirements_Days=
	\|Estimation_Days=		: We have now got the import working for AKW, we would also like to get it working for all delivery partners in Partnerlink, with this in mind would it be possible for you to give us a single login with all of the signatures for Partnerlink partners? This way we could import them all and they would just match to the relevant job.
	\|Functional_Specification_Days=		: Also configure the firewall to give Stirling access from the Partnerlink server IP address 81.138.72.158
	\|Technical_Specification_Days=		\|OBS_Solution={{Note}} The export of data from C-ePOD has been extended for multiple additional systems (i.e. the pallet network tracking exports) far beyond it's initial design. As such, the export process has at times reached its maximum capacity in the current form. As part of this change, the export process must have many efficiency changes put into it to handle:
	\|Development_Days=		* batching of FTP file sends, to reduce the overhead of connecting to FTP sites multiple times.
	\|Testing_and_Release_Days=		* reducing the number of times that the process builds export files, if the file is to be replicated to multiple destinations.
	\|Implementation_Days=		* distribute the decision as to whether files will be sent to the point of completing the jobs, rather than at the point of export.
	\|Project_Management_Days\|X=

			A new export configuration will be added to each site, to control the sending of the Job Completion export file to Sterling's Portal. The rule allowing only one configuration per type to be added to a configuration will be relaxed, so that this export configuration may be added.

			The database will be modified to create an Export Control record for each job that requires it, at the point that a job is set to Completed or Cancelled status. This will be triggered by the database at the point of completion and will be largely sourced from the existing package that decides which configuration requires an export. These changes will reduce development costs and increase the speed of the export process. The process will be modified slightly to obey the configuration against the site, rather than requiring the configuration to be the same name as the site code - this is required to allow the control records to be written.

			As the control records are being written based off the configuration against the site and job group, the new configuration added will result in a new control file being created for the new export to Stirling's Portal system.


			The Export process for jobs will be changed to retrieve the control records rather than attempt to find each job that requires updating. The job associated to the control record will be retrieved at the same time. This will ensure a far more efficient export process.

			The process will 'batch' similar export files together, and produce the XML once only, replicating this to several files. The process will produce the files in a temporary area, and will send all FTP files for the same destination at the same time. Only then will a file be marked as successfully sent.

			Any issues with creating or sending the export file will result in the Error or Reprocess status being set against the control record, as normal.


			The changes above will result in a faster processing export process, as well as improving the capability and efficiency of the re-sending process should an individual record fail to process.


			Access will be provided to Stirling to the Partnerlink server for the purposes of this change.

			\|Requirements_Days=0.0
			\|Estimation_Days=0.5
			\|Functional_Specification_Days=2.5
			\|Technical_Specification_Days=2.5
			\|Development_Days=10.5
			\|Testing_and_Release_Days=2.5
			\|Implementation_Days=0.25
			\|Project_Management_Days=0.75
	\|Year=2016		\|Year=2016
	\|Free_Of_Charge\|N=N		\|Free_Of_Charge=N
	\|Supimix_Client_Code\|TEMPLATE=PART}}		\|Supimix_Client_Code\|TEMPLATE=PART}}

Anw: EST_337120_Sterling_Portal_Interface

2016-09-13T08:54:02Z

EST_337120_Sterling_Portal_Interface

New page

{{Template:Estimate
|Supimix_Client_Code=PART
|Supimix_Project_Code=DEV
|Supimix_Site_Code=PART
|Supimix_Client_Reference=PL-STERLING PORTAL
|Supimix_Number=337120
|The_version_of_the_document=0.1
|Your_Name=A N Walker
|Supimix_PO_Reference=
|Supimix_Priority=3
|Date_(DD/MM/YY)=13/09/16
|Clients_Customer=ALL
|System_Version_being_changed=3.3.X
|Client_Request=
|OBS_Solution=
|Requirements_Days=
|Estimation_Days=
|Functional_Specification_Days=
|Technical_Specification_Days=
|Development_Days=
|Testing_and_Release_Days=
|Implementation_Days=
|Project_Management_Days|X=
|Year=2016
|Free_Of_Charge|N=N
|Supimix_Client_Code|TEMPLATE=PART}}