| Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-200823 - Sample Entry Import|http://helpdesk.irely.com/iRelyi21live/i21/#/HD/Ticket/?ticket=HDTN-200823]
* Add Import option in the Sample Entry Search Screen
* Clicking on Import will open a popup screen similar to below given screenshot
!pastedImage_d79484_0.png!
* User can select the CSV file using the browser button (refer attachment for sample CSV file format)
* User can click 'Import' button on this screen
* System will open up a Import Error screen as given below
!pastedImage_d79484_1.png!
* If CSV data is valid, then update sample entry tables and show 'Import Successful' message
* User will specify only the contract number, following logic has to be applied to identify the contract sequence.
** Go based on the sequence in ascending order starting from 1, 2, 3 etc.
** We will have a mapping table 'tblQMSampleImportSampleType' to exclude some more sample type(s). If there are sample type(s) which is specified in this mapping table and the sequence having approved sample in one of those sample type(s) then choose next sequence number.
** If there is no next sequence then show this in the error screen before importing. Proceed the same check for all the records.
* Once we fetch the contract sequence, we need to validate whether the import item and contract sequence item are same. If not, show it in the error list
* In excel,
** Sample Code = 'Item Short Name'
** Vendor Name = 'Contract Party'
** EOC Ref = 'Contract No'
** Quantity = 'Contract Sequence Quantity'
* All the following fields *should have value* and the specified validations are required:
** Sample Date - Value should be in 'date' format
** Sample No:
*** We will always Auto generate
*** Sample No which they will give will be unique values all over the samples available in i21 system. We will add this no in a new column as a feed reference no in our system.
** Sample Code - Should match with Item Short Name
** Sample Type - Should match with Quality Sample Type
** Vendor Name - Should match with Contract Party
** EOC Ref - Should match with Contract No
** Quantity - Value should be numeric. If Quantity > Contract Sequence Quantity, throw error. Save the quantity value in Sample Representing Qty & UOM should be Contract Seq item UOM
** Sample status - Should match with Quality Sample Status
** Property Name - Value should be there and should match with Property Name
** Result - Value can be empty / Passed / Failed / Marginal
** Property Value:
*** If Property data type is Boolean,
**** Property Value can be true / false
*** If Property data type is Integer,
**** Property Value can be integer (no decimal, string, negative values)
*** If Property data type is Float,
**** Property Value can be integer / decimal (no string, negative values)
*** If Property data type is Date Time,
**** Property Value can be date (date will be the same format specified in company preference)
* Based on the Item Short Name & Sample Type, retrieve the template. If template is not available, show it in the error list
* If property name is not available in the template, show it in the error list
* All errors for a record should show in a single column with comma seperator.
* Once we do validation for all the records, show the error records in error screen
* If there is no errors, then add the sample records
* Add Sample Reference No field in Sample Entry Screen
* Display the sample Reference No column in Sample Search Screen and all Quality Views (4 Views)
|