FS 343964 SCR-339876-02 Additional Landscape Data Import
Marshalls Stone
Addition Landscape Data Import
CALIDUS ePOD
28th June 2017 - 1.0
Reference: FS 343964 SCR-339876-02
Contents
Functional Overview
Client Requirement
Additional information is required to be sent to C-ePOD on the delivery job for Landscape jobs:
- Haulier.
- Transport Group.
- Case Quantity for the product (i.e. quantity of units to a case).
- Product References (e.g. "CEFL5656000 LSMUF560 EN1339:2003 EN1338-2003")
This will require modification of the data stored on the Jobs in C-ePOD. Note that these are required for the POD format report.
Solution Overview
New fields will be added to the C-ePOD application to store:
- Job:
- Haulier
- Transport Group
- Product:
- Case Quantity (stored in the existing Case Quantity field)
- Product References (stored in the Long Description).
This information will be stored in the CALIDUS ePOD database and will be visible within the C-ePOD Admin system against the job and the products.
The information will be used in the Marshalls Landscape (generic) POD/POC report.
Scope
Changes will be made to latest version of CALIDUS ePOD only, and will require an update to all application components and full system and user acceptance testing.
Note: Additional information is required to be sent to C-ePOD on the delivery job (in the job detail) for all Marshalls jobs:
- Date/Time loaded.
- Loading point (plant).
- The loader (name).
- Sales Contact Telephone.
This is specified as part of the Marshalls Premier Data Import, in change FS 343365 SCR-339867-01 Additional Premier Data Import, referenced in the appendices of this document.
Set-up
Pre-requisites
Menu Structure
Data
Functional Description
Database and Data Access Layer
The following fields will be added to the Job table EPOD_JOB:
- EPL_HAULIER - nvarchar(50)
- EPL_TRANSPORT_GROUP - nvarchar(50)
These fields will be added to all stored procedures in the database that require them.
These fields do not require exporting to the mobile device.
These fields are required to be set on jobs imported through the standard XML import (flat file or webservice). The Import XSD will be modified to show these fields. None are required to be provided in the incoming file (the tags can be omitted or present with no value).
These fields are not required to be contained within the Export.
These fields are not required to be used when filtering data for selection.
No fields are required to be added to the Product table EPOD_PRODUCT, as the following fields already exist to store this data:
- EPL_PRODUCT_QTY_CASE
- EPL_DESCRIPTION_LONG
These fields will be added to all stored procedures in the database that require them.
These fields are required to be sent to the mobile device.
The Case Quantity is required to be set on products imported through the standard XML import (flat file or webservice). The Import XSD will be modified to add this field. This is not required to be provided (i.e. the tag can be omitted) but if the tag is present, it must contain an integer value.
Note: When this code is included in a build for release to a customer, the standard Import documentation must be created for this version including these new tags.
Admin
Job Screen
The Job screen (job_details.aspx) will be changed to show these new data elements.
Job Screen
The pop-up Edit screen (accessed by clicking Select against an existing job or clicking New to add a new job) will be changed to add these fields. The results table will not be modified. All fields will be added to the Details tab.
- Add Haulier and Transport Group, from fields EPL_HAULIER and EPL_TRANSPORT_GROUP, above the Sales Contact field and below any new fields added for the Premier Mortars data, labelled as "Haulier/Group". These are free text fields and require no additional validation. These fields are not required and do not need to be entered by the user.
All new fields added will align with the existing fields on the pop-up.
Appendix A: TEST PLAN
| Test Script / Scenario Reference | Addition Landscape Data Import | Call Number(s): 343964 SCR-339876-02 |
| Test Script / Scenario Description | Testing the new data requirements for Marshalls Landscape are met. | PASS / ISSUES / FAIL |
| Menu Access | Administration/Auto-Import | |
| Pre-requisites | A system configured as Marshalls. | Tested By: |
| Test Objective | To test: Auto-Import may import the new data through the XML format; webservice import may import the new data and; Admin displays and can maintain the new fields. | Date: |
| Step | Action | Result | Remarks | P/F |
| 1 | Import | |||
| Create a test XML file that contains all the new fields, compliant with the new XSD. Also create a file without all these field fields, for limit testing. | ||||
| 1.01 | Configure a file Auto-Import for Loads. Drop the file without the new fields into the specified directory and check the import log and jobs. | Loads, Jobs and Products created with no issues, but without the new data. | ||
| 1.02 | Drop the file with the new fields into the specified directory and check the import log and jobs. | Loads, Jobs and Products created with no issues, with the new data populated as expected. | ||
| 1.03 | Paste the contents of the file without the new fields into the webservice through a browser and check the import log and jobs. | Loads, Jobs and Products created with no issues, but without the new data. | ||
| 1.04 | Paste the contents of the file with the new fields into the webservice through a browser and check the import log and jobs. | Loads, Jobs and Products created with no issues, with the new data populated as expected. |
| Step | Action | Result | Remarks | P/F |
| 2 | Admin System | |||
| Ensure there are some jobs and products with the new data already added, as well as some jobs and products without the new data. | ||||
| 2.01 | In the jobs screen, add a new job, enter the new fields and save. Check the job. | The new fields are entered as expected, with validation as described. The data is saved, and redisplayed when the details are shown again. | ||
| 2.02 | In the jobs screen, find a job without any of the new data. Add the data, save and modify again. | The new fields are entered as expected, with validation as described. The data is saved, and redisplayed when the details are shown again. |
Appendix B: Quote & Document References
| Cost Details | ||||
| Activity | Estimate No. of Days |
No. of Days | Rate per Day (£) | Cost (£ Exc. VAT) |
| Requirements | 0.00 | 0.00 | 750 | £0.00 |
| Change Request Evaluation | 0.00 | 0.00 | 750 | £0.00 |
| Functional Specification | 0.75 | 0.50 | 750 | £375.00 |
| Technical Specification | 0.00 | 0.00 | 750 | £0.00 |
| Development | 4.25 | 2.50 | 750 | £1,875.00 |
| Testing and Release | 0.50 | 0.50 | 750 | £375.00 |
| Implementation | 0.25 | 0.25 | 750 | £187.50 |
| Project Management | 0.25 | 0.25 | 750 | £187.50 |
| TOTAL | 6.00 | 4.00 | £3,000.00 | |
| Estimate excludes training, release to live and go live support. |
B.1 References
| Ref No | Document Title & ID | Version | Date |
| 1 | REQ 339867 Marshalls Premier Mortars Solution Design | 1.3 | 25/05/2017 |
| 2 | FS 343365 SCR-339867-01 Additional Premier Data Import | 1.0 | 14/06/2017 |
B.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. |
B.3 Authorised By
Matt Turner | OBSL Account Manager | _____________________________ |
Simon Martin | Customer Representative | _____________________________ |
Debbie Linley | Customer Representative | _____________________________ |
