FS 311049 Palletforce Pallet Generation

From Calidus HUB





Aptean Logo.png







Partnerlink

Palletforce Pallet Generation

CALIDUS ePOD

30th August 2013 - 0.1
Reference: FS 311049











































Functional Overview

Client Requirement

Andrew Allison having a problem with Barcode data not validating against the Container_ID code. Kyle Smith @ Palletforce identifies how he expects it to be set up and the barcode generated. As follows:

Format AAABBBCDDDEEEEEEEEEEFF where:

  • AAA is always 506 - 506
  • BBB is the three digit delivery depot number padded with zeros
  • C is a single character to reflect the service
  • DDD is always the requesting depot; please contact Palletforce if you are unsure of your requesting depot number.
  • EEEEEEEEEE is the last ten digits of the Tracking Number from field 4
  • FF is a two digit number identifying an individual pallet in a consignment, 01 for the first pallet, 02 for the second pallet and so on.

Solution Overview

The Partnerlink Import functionality will change to generate the Pallet ID (Container ID) in CALIDUS ePOD from the data passed in from the various TMS providers.

The resulting Container ID length will be 22 characters, which will be too big for the field within the application, so this will be modified in all parts of the system to allow a larger Container ID

Scope

  • These changes will be made in the latest version of the CALIDUS ePOD product only.
  • The changes will not affect CALIDUS Portal - no changes are required here.
  • This change requires that the incoming data from the various TMS providers in the Palletforce Tracking ID and Depot Code is correct. For Palletforce Depot Code specifically, for Collection jobs this should be Collecting Depot, for Delivery jobs this should be Delivering Depot.
  • All partners that operate Palletforce jobs will be affected by this change, and so this change must be agreed by all partners before work can proceed.


Set-up

Pre-requisites

Menu Structure

Data

Functional Description

Database and DAL

The database table EPOD_CONTAINER should be modified as follows:

  • Change EPL_CONTAINER_ID to nvarchar(30).

The database should have procedures that use an EPL_CONTAINER parameter changed to reflect the new length. This includes but may not be limited to:

  • EPOD_CONTAINER_CANCEL
  • EPOD_CONTAINER_DELETE
  • EPOD_CONTAINER_GET_MAXID
  • EPOD_CONTAINER_INSERT
  • EPOD_CONTAINER_SELECT
  • EPOD_CONTAINER_UPDATE
  • EPOD_PRODUCT_CANCEL
  • EPOD_PRODUCT_DELETE
  • EPOD_PRODUCT_GET_MAXSEQ
  • EPOD_PRODUCT_INSERT
  • EPOD_PRODUCT_SELECT
  • EPOD_PRODUCT_UPDATE

Note Note: The EPOD_CONTAINER_GET_MAXID should continue to generate container IDs at the length that it currently does, but the field parameter should change to 30.

The EPOD_CONTAINER DAL object should have each parameter function (identified as functions that begin "GetParameters") checked for the new length of the EPL_CONTAINER_ID parameter.


The database table EPOD_PRODUCT should be modified as follows:

  • Change EPL_CONTAINER_ID to nvarchar(30).

The EPOD_PRODUCT DAL object should have each parameter function (identified as functions that begin "GetParameters") checked for the new length of the EPL_CONTAINER_ID parameter.

Server

The length of the EPL_CONTAINER_ID field needs to be modified throughout all the .NET projects, to ensure that the length is changed to 30.

  • Length parameters must removed or modified, for example:
    • EPOD_UTILS.cs(41): public static int EPL_CONTAINER_ID = 20;
    • Utilites.cs(625): public static int EPL_CONTAINER_ID = 15;

All XSDs used in export and import should be modified to identify the restriction to 30 characters on the EPL_CONTAINER_ID field. These include but are not limited to:

  • EPOD_EXPORT_JOB.XSD
  • EPOD_EXPORT_JOB_RESPONSE.XSD
  • EPOD_EXPORT_LOAD.XSD
  • EPOD_EXPORT_LOAD_RESPONSE.XSD
  • XMLUpload.XSD


The PDA Web service (calidus_epod.asmx) must be checked that responses to the following requests give the full container ID (up to 30 characters):

  • JOB_REQUEST
  • AUTO_UPDATE_REQUEST
  • JOB_LOCK_REQUEST

Additionally, the processing of a JOB_UPDATE message must be checked that it will write the full 30-character Container ID.

Admin

The Containers and Products screen (product_containers.aspx) will be modified to ensure that entry of new containers or editing existing containers allow for entry of up to 30 characters.

Import

The Partnerlink Import functionality will change to generate the Pallet ID (Container ID) in CALIDUS ePOD from the data passed in from the various TMS providers.

The pallet ID generation routine in place for non-Palletforce jobs (i.e. EPL_JOB_GROUP = "PALLET") will not change.

The pallet ID generation routine in place for Palletforce jobs will be changed as follows: Format AAABBBCDDDEEEEEEEEEEFF where:

  • AAA - "506"
  • BBB - EPL_PF_DEPOT
  • C - EPL_SERVICE_LEVEL - never more than one character
  • DDDEEEEEEEEEE - EPL_PF_TRACKING_NO
  • FF - as now, a two digit number incrementing per pallet.

Android Client

The database tables EPOD_CONTAINER and EPOD_PRODUCT will be modified when created in Database.js as follows:

  • EPL_CONTAINER_ID nchar(30)

Note Note: As this change requires the database to be modified, this must be reflected as the latest database version that changed to database, to force the re-creation when this version of the application is installed by the users. As such, change the lngLastVersionDB variable to reflect the latest version.

The restriction when scanning or keying container IDs (to only check 15 characters) should be removed, as this will no longer be required.

Note Note: Scanning or entering containers, and the sending back of container IDs should be checked in the programs, to ensure that they have no restriction against them, specifically in files:

  • ColDel.js
  • Barcode.js
  • WebServices.js


Appendix A: Quote & Document References

Cost Details
Activity No. of Days Rate per Day (£) Cost (£ Exc. VAT)
Requirements 0.00 0 £0.00
Change Request Evaluation 0.00 0 £0.00
Functional Specification 0.50 0 £0.00
Technical Specification 0.00 0 £0.00
Development 2.00 0 £0.00
Testing and Release 0.50 0 £0.00
Implementation 0.00 0 £0.00
Project Management First argument to "number_format" must be a number. 0 £First argument to "number_format" must be a number.
 
TOTAL First argument to "number_format" must be a number.   £First argument to "number_format" must be a number.
Estimate excludes training, release to live and go live support.

A.1 References

Ref NoDocument Title & IDVersionDate
1UG 291094 EPOD Admin User Guide2.04/4/2012
2UG 291097 EPOD Client User Guide3.023/4/2013


A.2 Glossary

Term Definition
EPOD Electronic Proof of Delivery. The OBS EPOD system is CALIDUS ePOD.
CALIDUS eSERV The OBS mobile system to complete Service functionality in the field. This is part of the CALIDUS ePOD system.
PDA The mobile device on which the C-ePOD system will run in the field. This can be a Phone, EDA or industrial PDA, running Android.
DAL Data Access Layer. A mechanism for accessing data by the system that is removed from the application, allowing for simplified access and providing protection to the data, as only approved DAL methods can be used to modify it.
GPS Global Positioning System. A mechanism of retrieving accurate positioning information in the form of Latitude and Longitude (Lat-Long) co-ordinates from a device.
GPRS, 3G, HSDPA, Data Service All terms referring to mobile device network connectivity, and the speed at which the device connects to the internet.


A.3 Authorised By


Phil Harding
OBS Project Manager		_____________________________

Andrew Allison
Client Representative		_____________________________
Retrieved from ‘https://calidusassist.adcservices.apteancloud.com/calidus-assist/OBS/index.php?title=FS_311049_Palletforce_Pallet_Generation&oldid=1179’