Uploaded image for project: 'Document Management System'
  1. Document Management System
  2. DMS-1970

DMS : Add validations to DMS System Fields

    Details

      Description

      Objective: As a HR Manager, I want to be able to control and validate the data format on forms so that users have specific formats to use so that I can standardize the data collected for use in an API.

      Pre-requisite: I have a DMS activated. I am a CBAT customer.

      Entry: I create a form

      Exit: I can control the data format entered

      Acceptance criteria:

      • can control data entry types:
        • Date
        • soc sec #
        • phone number
        • text
      • receive feedback when the data format is invalid
      • hr manager can configure at set up
      • user sees the required format (dd/mm/yyyy), XXX-XX-XXXX; X-XXX-XXX-XXXX

      Add validations to DMS system fields.

      For an example SSN must be numeric and fixed length.

      Currently DMS not having any validations for system fields. But some API implemented some validations details are updated into DMS-1962.

      CC – Samir

        Attachments

          Issue Links

            Activity

            rohan.khandave Rohan J Khandave (Inactive) created issue -
            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Field Original Value New Value
            Epic Link DMS-2 [ 69268 ]
            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Description Add validations to DMS system fields.

            For an example SSN must be numeric and fixed length.
            Add validations to DMS system fields.

            For an example SSN must be numeric and fixed length.

            Currently DMS not having any validations for system fields. But some API implemented some validations details are updated into DMS-1962.
            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Description Add validations to DMS system fields.

            For an example SSN must be numeric and fixed length.

            Currently DMS not having any validations for system fields. But some API implemented some validations details are updated into DMS-1962.
            Add validations to DMS system fields.

            For an example SSN must be numeric and fixed length.

            Currently DMS not having any validations for system fields. But some API implemented some validations details are updated into DMS-1962.

            CC -- [~samir]
            samir Samir made changes -
            Assignee Samir [ samir ] Mohd Belal [ mohd.belal ]
            samir Samir made changes -
            Sprint Winter-2020 Sprint 3 [ 185 ]
            mohd.belal Mohd Belal (Inactive) made changes -
            Remaining Estimate 24h [ 86400 ]
            Original Estimate 24h [ 86400 ]
            mohd.belal Mohd Belal (Inactive) made changes -
            Status To Do [ 10000 ] In Progress [ 3 ]
            mohd.belal Mohd Belal (Inactive) logged work - 13/Nov/19 02:40 AM
            • Time Spent:
              8h
               
              <No comment>
            mohd.belal Mohd Belal (Inactive) made changes -
            Remaining Estimate 24h [ 86400 ] 16h [ 57600 ]
            Time Spent 8h [ 28800 ]
            Worklog Id 211847 [ 211847 ]
            samir Samir made changes -
            Description Add validations to DMS system fields.

            For an example SSN must be numeric and fixed length.

            Currently DMS not having any validations for system fields. But some API implemented some validations details are updated into DMS-1962.

            CC -- [~samir]
            Objective: As a HR Manager, I want to be able to control and validate the data format on forms so that users have specific formats to use so that I can standardize the data collected for use in an API.

            Pre-requisite: I have a DMS activated. I am a CBAT customer.

            Entry: I create a form

            Exit: I can control the data format entered

            Acceptance criteria:
             * can control data entry types:

             ** Date

             ** soc sec #

             ** phone number

             ** text

             * receive feedback when the data format is invalid

             * hr manager can configure at set up

             * user sees the required format (dd/mm/yyyy), XXX-XX-XXXX; X-XXX-XXX-XXXX

            Add validations to DMS system fields.

            For an example SSN must be numeric and fixed length.

            Currently DMS not having any validations for system fields. But some API implemented some validations details are updated into DMS-1962.

            CC – [~samir]
            mohd.belal Mohd Belal (Inactive) logged work - 13/Nov/19 09:55 PM
            • Time Spent:
              2h
               
              <No comment>
            Hide
            mohd.belal Mohd Belal (Inactive) added a comment -

            Hi All,

            I have done the analysis on implementing the validation for system fields in DMS for PDF.

            We will be adding the validation on the basis of system fields name, but in our current scenario we don't have any fixed standard defined for creating the system fields.

             

            For example: We need to validate the date fields in the format of MM/DD/YYYY.

            So we planned to check for fields with name "date" and add validation to all the fields which include date as a part of its name.

            But for some dates we are using names as dob, doj  instead of dateofjoin or dateofbirth.

            This will cause a fail in checking the dates field and our validation won't work in that fields.

             

            Awaiting for further discussion in this implementation.

             

            cc - Samir

            Thanks

             

            Show
            mohd.belal Mohd Belal (Inactive) added a comment - Hi All, I have done the analysis on implementing the validation for system fields in DMS for PDF. We will be adding the validation on the basis of system fields name, but in our current scenario we don't have any fixed standard defined for creating the system fields.   For example: We need to validate the date fields in the format of MM/DD/YYYY . So we planned to check for fields with name " date " and add validation to all the fields which include date as a part of its name. But for some dates we are using names as dob, doj   instead of dateofjoin or dateofbirth . This will cause a fail in checking the dates field and our validation won't work in that fields.   Awaiting for further discussion in this implementation.   cc - Samir Thanks  
            mohd.belal Mohd Belal (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ] 14h [ 50400 ]
            Time Spent 8h [ 28800 ] 10h [ 36000 ]
            Worklog Id 212029 [ 212029 ]
            mohd.belal Mohd Belal (Inactive) logged work - 18/Nov/19 02:02 AM
            • Time Spent:
              8h
               
              <No comment>
            Hide
            mohd.belal Mohd Belal (Inactive) added a comment - - edited

            Hi All,

            The current case analysis is added in the document attached.

             

            Another work around that can be done in this case is:

             

            The system fields are accurate which can be used to identify the field and apply validation.

            We can check the mapping of the form fields with the system fields from the mapping details and add validation accordingly.

             

            Analysis of this case:

            We are using following API to fetch the PDF details in Document Preview page.

             

            https://dmsapistage.workterra.net/api/FormsLibrary/GetFormDetails/mohd.belal@careerbuilder.com/1443

            Currently, this is not providing any data related to the Mapped fields which we have for this template. If we get the Mapped data in response we can use that to check the mapping and apply validation.

            Same applied to Document Review Page where the API used is:

            https://dmsapistage.workterra.net/api/Person/GetDetailsForEditPDF/61/1456/1/3509/3494/0

            So, both these API need to be updated to return Mapped Field data for the template in its response.
             

            FYI, the API which we are using in create template is returning the Mapped fields data:

            https://dmsapistage.workterra.net/api/DocumentTemplate/GetFormData/1443

             

            cc - Samir

            Show
            mohd.belal Mohd Belal (Inactive) added a comment - - edited Hi All, The current case analysis is added in the document attached.   Another work around that can be done in this case is:   The system fields are accurate which can be used to identify the field and apply validation. We can check the mapping of the form fields with the system fields from the mapping details and add validation accordingly.   Analysis of this case: We are using following API to fetch the PDF details in Document Preview page.   https://dmsapistage.workterra.net/api/FormsLibrary/GetFormDetails/mohd.belal@careerbuilder.com/1443 Currently, this is not providing any data related to the Mapped fields which we have for this template. If we get the Mapped data in response we can use that to check the mapping and apply validation. Same applied to Document Review Page where the API used is: https://dmsapistage.workterra.net/api/Person/GetDetailsForEditPDF/61/1456/1/3509/3494/0 So, both these API need to be updated to return Mapped Field data for the template in its response.   FYI,  the API which we are using in create template is returning the Mapped fields data: https://dmsapistage.workterra.net/api/DocumentTemplate/GetFormData/1443   cc - Samir
            mohd.belal Mohd Belal (Inactive) made changes -
            Remaining Estimate 14h [ 50400 ] 6h [ 21600 ]
            Time Spent 10h [ 36000 ] 18h [ 64800 ]
            Worklog Id 212560 [ 212560 ]
            mohd.belal Mohd Belal (Inactive) made changes -
            Attachment DMS_System_Fields_Validation.docx [ 126759 ]
            mohd.belal Mohd Belal (Inactive) made changes -
            Status In Progress [ 3 ] To Do [ 10000 ]
            shashikant.mishra ShashiKant Mishra (Inactive) made changes -
            Sprint Winter-2020 Sprint 3 [ 185 ] Winter-2020 Sprint 3, Winter-2020 Sprint 4 [ 185, 187 ]
            shashikant.mishra ShashiKant Mishra (Inactive) made changes -
            Sprint Winter-2020 Sprint 3, Winter-2020 Sprint 4 [ 185, 187 ] Winter-2020 Sprint 3, Winter-2020 Sprint 4, Winter-2020 Sprint 5 [ 185, 187, 189 ]
            shashikant.mishra ShashiKant Mishra (Inactive) made changes -
            Sprint Winter-2020 Sprint 3, Winter-2020 Sprint 4, Winter-2020 Sprint 5 [ 185, 187, 189 ] Winter-2020 Sprint 3, Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6 [ 185, 187, 189, 190 ]
            shashikant.mishra ShashiKant Mishra (Inactive) made changes -
            Sprint Winter-2020 Sprint 3, Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6 [ 185, 187, 189, 190 ] Winter-2020 Sprint 3, Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7 [ 185, 187, 189, 190, 193 ]
            narendra.kumar Narendra Kumar made changes -
            Fix Version/s Winter 2020 CBAT Integration [ 11316 ]
            Fix Version/s Winter 2020 Enhancements [ 11314 ]
            Hide
            mohd.belal Mohd Belal (Inactive) added a comment -

            Hi Shamooka Mohapatra,

            Any update on this regarding the fields list and validation rules.

             

            cc - Samir

            Thanks

            Show
            mohd.belal Mohd Belal (Inactive) added a comment - Hi Shamooka Mohapatra , Any update on this regarding the fields list and validation rules.   cc - Samir Thanks
            narendra.kumar Narendra Kumar made changes -
            Sprint Winter-2020 Sprint 3, Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7 [ 185, 187, 189, 190, 193 ] Winter-2020 Sprint 3, Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8 [ 185, 187, 189, 190, 193, 197 ]
            mohd.belal Mohd Belal (Inactive) made changes -
            Assignee Mohd Belal [ mohd.belal ] Shamooka Mohapatra [ shamooka.mohapatra ]
            narendra.kumar Narendra Kumar made changes -
            Sprint Winter-2020 Sprint 3, Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8 [ 185, 187, 189, 190, 193, 197 ] Winter-2020 Sprint 3, Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Winter-2020 Sprint 9 [ 185, 187, 189, 190, 193, 197, 198 ]
            Hide
            Shamooka.Mohapatra Shamooka Mohapatra (Inactive) added a comment -

            Mohd Belal Card is created on our side. We will pick this card later

            Show
            Shamooka.Mohapatra Shamooka Mohapatra (Inactive) added a comment - Mohd Belal Card is created on our side. We will pick this card later
            narendra.kumar Narendra Kumar made changes -
            Sprint Winter-2020 Sprint 3, Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 2 [ 185, 187, 189, 190, 193, 197, 198 ] Winter-2020 Sprint 3, Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 2, Spring-2020 - Sprint 3 [ 185, 187, 189, 190, 193, 197, 198, 199 ]
            Hide
            Shamooka.Mohapatra Shamooka Mohapatra (Inactive) added a comment -
            Show
            Shamooka.Mohapatra Shamooka Mohapatra (Inactive) added a comment - The corresponding card from CBAt - https://careerbuilder.atlassian.net/browse/AT-3962 cc: Samir Amrendra Kumar
            narendra.kumar Narendra Kumar made changes -
            Sprint Winter-2020 Sprint 3, Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 2, Spring-2020 - Sprint 3 [ 185, 187, 189, 190, 193, 197, 198, 199 ] Winter-2020 Sprint 3, Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 2, Spring-2020 - Sprint 3, Spring-2020 - Sprint 4 [ 185, 187, 189, 190, 193, 197, 198, 199, 200 ]
            narendra.kumar Narendra Kumar made changes -
            Sprint Winter-2020 Sprint 3, Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 2, Spring-2020 - Sprint 3, Spring-2020 - Sprint 4 [ 185, 187, 189, 190, 193, 197, 198, 199, 200 ] Winter-2020 Sprint 3, Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 2, Spring-2020 - Sprint 3, Spring-2020 - Sprint 4, Spring-2020 - Sprint 5 [ 185, 187, 189, 190, 193, 197, 198, 199, 200, 202 ]
            narendra.kumar Narendra Kumar made changes -
            Sprint Winter-2020 Sprint 3, Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 2, Spring-2020 - Sprint 3, Spring-2020 - Sprint 4, Spring-2020 - Sprint 5 [ 185, 187, 189, 190, 193, 197, 198, 199, 200, 202 ] Winter-2020 Sprint 3, Winter-2020 Sprint 4, Winter-2020 Sprint 5, Winter-2020 Sprint 6, Winter-2020 Sprint 7, Winter-2020 Sprint 8, Spring-2020 - Sprint 2, Spring-2020 - Sprint 3, Spring-2020 - Sprint 4, Spring-2020 - Sprint 5, Spring-2020 - Sprint 6 [ 185, 187, 189, 190, 193, 197, 198, 199, 200, 202, 203 ]
            narendra.kumar Narendra Kumar made changes -
            Labels DMS-CBAT
            narendra.kumar Narendra Kumar made changes -
            Fix Version/s DMS Monthly Release - May 2020 [ 11705 ]
            Fix Version/s Winter 2020 CBAT Integration [ 11316 ]
            narendra.kumar Narendra Kumar made changes -
            Link This issue relates to DMS-2122 [ DMS-2122 ]
            Hide
            narendra.kumar Narendra Kumar added a comment -

            Hi Shamooka Mohapatra

            This we have covered in DMS-2122. So closing this ticket.

            cc: Samir, Amrendra Kumar

            Show
            narendra.kumar Narendra Kumar added a comment - Hi Shamooka Mohapatra This we have covered in  DMS-2122 . So closing this ticket. cc: Samir , Amrendra Kumar
            narendra.kumar Narendra Kumar made changes -
            Resolution Done [ 10000 ]
            Status To Do [ 10000 ] Done [ 10001 ]
            Transition Time In Source Status Execution Times
            Mohd Belal (Inactive) made transition -
            To Do In Progress
            27d 16h 19m 1
            Mohd Belal (Inactive) made transition -
            In Progress To Do
            7d 7h 14m 1
            Narendra Kumar made transition -
            To Do Done
            193d 16h 12m 1

              People

              Assignee:
              Shamooka.Mohapatra Shamooka Mohapatra (Inactive)
              Reporter:
              rohan.khandave Rohan J Khandave (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 60h
                  60h
                  Remaining:
                  Time Spent - 22h Remaining Estimate - 38h
                  38h
                  Logged:
                  Time Spent - 22h Remaining Estimate - 38h
                  22h