Details

    • Type: Sub-task
    • Status: Done
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None
    • Company:
      All Clients/Multiple Clients

      Description

      CBES HTML forms implementation:
      1. Add TemplatefileType column in database
      2. Add metadata with localization in datbase
      3. Expose metadata from API to angular
      4. fetchTemplatefiletype value on Edit
      5. Save Templatefiletype value in database.
      6. Fetch key values on Preview forms
      7. API changes on send forms

        Attachments

          Activity

          swapnil.pandhare Swapnil Pandhare (Inactive) created issue -
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Field Original Value New Value
          Assignee Samir [ samir ] Swapnil Pandhare [ swapnil.pandhare ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Status To Do [ 10000 ] In Progress [ 3 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 26/Feb/19 02:23 AM
          • Time Spent:
            2h
             

            Analysis
            Discussion

          swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 27/Feb/19 08:53 AM
          • Time Spent:
            2h
             

            Analysis
            Discussion with Belal and Samir

          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Summary Analysis of parsing HTML forms CBES HTML forms implementation
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Description Analysis CBES HTML forms implementation:
          1. Add TemplatefileType column in database
          2. Add metadata with localization in datbase
          3. Expose metadata from API to angular
          4. fetchTemplatefiletype value on Edit
          5. Save Templatefiletype value in database.
          6. Fetch key values on Preview forms
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Status In Progress [ 3 ] In Progress [ 3 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 2h [ 7200 ]
          Worklog Id 163771 [ 163771 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Description CBES HTML forms implementation:
          1. Add TemplatefileType column in database
          2. Add metadata with localization in datbase
          3. Expose metadata from API to angular
          4. fetchTemplatefiletype value on Edit
          5. Save Templatefiletype value in database.
          6. Fetch key values on Preview forms
          CBES HTML forms implementation:
          1. Add TemplatefileType column in database
          2. Add metadata with localization in datbase
          3. Expose metadata from API to angular
          4. fetchTemplatefiletype value on Edit
          5. Save Templatefiletype value in database.
          6. Fetch key values on Preview forms
          7. API changes on send forms
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Time Spent 2h [ 7200 ] 4h [ 14400 ]
          Worklog Id 163961 [ 163961 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 01/Mar/19 04:20 AM - edited
          • Time Spent:
            4h
             

            Coding
            Discussion

          Hide
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

          Hi Mohd Belal,

          Please find below changed API responses for HTML implementation :
          1. Preview API resonse :
          {"DocType":1,"fileName":"155124268543312_1551335964546.html","formDetails":

          {"first_name":"John","last_name":"Doetest"}

          ,"fileExtension":".html"}

          2. Get meta data collection API :
          URL : /api/documenttemplate/GetMetaDataCollection
          Response added in API : "templateFileTypes":

          { "48": "PDF", "49": "HTML" }

          3. Get template details API
          URL : /api/documenttemplate/GetFormData/

          {id}

          New response :
          {"Id":191,"TemplateName":"CBES HTML","Description":"CBES HTML","TemplateFileName":"155124268543312_1551335964546.html","Accessibility":0,"DocumentType":14,"DocumentPath":"OBFileServer\\OnBoard\\PDFServiceAssets\\TemplatesPdf\\1\\Document
          ","SourceProductId":17,"TemplateTypeId":27,"TemplateVersion":null,"TemplateDocumentSource":"21","TemplateStatusId":23,"TemplateStatus":null,"TemplateStartDate":null,"TemplateEndDate":null,"strPDFFiels":null,"strFieldMapping":null,"DateCreated":"2019-02-28T12:11:22","UploadDate":"2019-02-28T12:11:22","UploadedBy":"0","CompletedWithin":null,"PDFFormFields":

          {"3":"pagename","4":"submit","5":"reset","6":"subject","7":"subject","8":"maths","9":"physics","10":"fileupload","11":"ok","12":"imagebutton","13":"description","14":"dropdown"}

          ,"MappingFields":

          {"1~first_name$^$11":"first_name-Person.Given Name","2~last_name$^$14":"last_name-Person.Family Name"}

          ,"OriginalFormFields":

          {"1":"first_name","2":"last_name","3":"pagename","4":"submit","5":"reset","6":"subject","7":"subject","8":"maths","9":"physics","10":"fileupload","11":"ok","12":"imagebutton","13":"description","14":"dropdown"}

          ,"isDocInUse":false,"ESignedDocument":false,"IsArchived":0,"TemplateFileTypeId":49}

          Also, you need to send "TemplateFileTypeId" field while saving documentTemplate.

          Please let me know if you need more details .

          Thanks,
          Swapnil P.

          Show
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - Hi Mohd Belal , Please find below changed API responses for HTML implementation : 1. Preview API resonse : {"DocType":1,"fileName":"155124268543312_1551335964546.html","formDetails": {"first_name":"John","last_name":"Doetest"} ,"fileExtension":".html"} 2. Get meta data collection API : URL : /api/documenttemplate/GetMetaDataCollection Response added in API : "templateFileTypes": { "48": "PDF", "49": "HTML" } 3. Get template details API URL : /api/documenttemplate/GetFormData/ {id} New response : {"Id":191,"TemplateName":"CBES HTML","Description":"CBES HTML","TemplateFileName":"155124268543312_1551335964546.html","Accessibility":0,"DocumentType":14,"DocumentPath":"OBFileServer\\OnBoard\\PDFServiceAssets\\TemplatesPdf\\1\\Document ","SourceProductId":17,"TemplateTypeId":27,"TemplateVersion":null,"TemplateDocumentSource":"21","TemplateStatusId":23,"TemplateStatus":null,"TemplateStartDate":null,"TemplateEndDate":null,"strPDFFiels":null,"strFieldMapping":null,"DateCreated":"2019-02-28T12:11:22","UploadDate":"2019-02-28T12:11:22","UploadedBy":"0","CompletedWithin":null,"PDFFormFields": {"3":"pagename","4":"submit","5":"reset","6":"subject","7":"subject","8":"maths","9":"physics","10":"fileupload","11":"ok","12":"imagebutton","13":"description","14":"dropdown"} ,"MappingFields": {"1~first_name$^$11":"first_name-Person.Given Name","2~last_name$^$14":"last_name-Person.Family Name"} ,"OriginalFormFields": {"1":"first_name","2":"last_name","3":"pagename","4":"submit","5":"reset","6":"subject","7":"subject","8":"maths","9":"physics","10":"fileupload","11":"ok","12":"imagebutton","13":"description","14":"dropdown"} ,"isDocInUse":false,"ESignedDocument":false,"IsArchived":0,"TemplateFileTypeId":49} Also, you need to send "TemplateFileTypeId" field while saving documentTemplate. Please let me know if you need more details . Thanks, Swapnil P.
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Done [ 10001 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Status Done [ 10001 ] Code Review [ 11801 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 04/Mar/19 04:19 AM - edited
          • Time Spent:
            3h
             

            Code checkin
            Discussion with Samir
            Updating JIRA

          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Original Estimate 10h [ 36000 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Time Spent 4h [ 14400 ] 6h [ 21600 ]
          Worklog Id 164464 [ 164464 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Time Spent 6h [ 21600 ] 9h [ 32400 ]
          Worklog Id 164465 [ 164465 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Summary CBES HTML forms implementation CBES HTML forms preview tasks
          Hide
          mohd.belal Mohd Belal (Inactive) added a comment -

          Hi Swapnil Pandhare,

          Let me proceed with the API implementation as  provided above and if needed anything I will ping you back.

          cc - Samir

          Thanks

          Show
          mohd.belal Mohd Belal (Inactive) added a comment - Hi Swapnil Pandhare , Let me proceed with the API implementation as  provided above and if needed anything I will ping you back. cc - Samir Thanks
          Hide
          mohd.belal Mohd Belal (Inactive) added a comment - - edited

          Hi Swapnil Pandhare,

          The remaining API which needs to be updated are:

          1. create / update document API
          2.  Send Forms new column File type listing ( FormsLibrary-> active)
          3. Person->SavePDFData to save the mapped fields before sending mail to user.

          cc - Samir

           

          Thanks

          Show
          mohd.belal Mohd Belal (Inactive) added a comment - - edited Hi Swapnil Pandhare , The remaining API which needs to be updated are: create / update document API  Send Forms new column File type listing ( FormsLibrary-> active) Person->SavePDFData to save the mapped fields before sending mail to user. cc - Samir   Thanks
          swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 04/Mar/19 11:29 PM
          • Time Spent:
            1h
             

            Discussion with samir, belal
            Updating files on dev server

          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Time Spent 9h [ 32400 ] 10h [ 36000 ]
          Worklog Id 164653 [ 164653 ]
          Hide
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

          Hi Mohd Belal,

          Below is update as per our call :
          1. create / update document API - Done. Give response as mentioned above.
          2. Send Forms new column File type listing ( FormsLibrary-> active) - Pending
          3. Person->SavePDFData to save the mapped fields before sending mail to user. - There might be no changes needed.

          Thanks,
          Swapnil P.

          Show
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - Hi Mohd Belal , Below is update as per our call : 1. create / update document API - Done. Give response as mentioned above. 2. Send Forms new column File type listing ( FormsLibrary-> active) - Pending 3. Person->SavePDFData to save the mapped fields before sending mail to user. - There might be no changes needed. Thanks, Swapnil P.
          swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 05/Mar/19 08:34 AM
          • Time Spent:
            2h
             

            Discussion
            Changes for fetching file type in send forms

          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Time Spent 10h [ 36000 ] 12h [ 43200 ]
          Worklog Id 164844 [ 164844 ]
          Hide
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

          Hi Mohd Belal,

          Below is today's update : :
          1. create / update document API - Done. Give response as mentioned above.
          2. Send Forms new column File type listing ( FormsLibrary-> active) - Done
          You will get TemplateFileTypeId as extra field in the collection for each documenttemplate record.
          3. Person->SavePDFData to save the mapped fields before sending mail to user. - There might be no changes needed.

          Thanks,
          Swapnil P.

          Show
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - Hi Mohd Belal, Below is today's update : : 1. create / update document API - Done. Give response as mentioned above. 2. Send Forms new column File type listing ( FormsLibrary-> active) - Done You will get TemplateFileTypeId as extra field in the collection for each documenttemplate record. 3. Person->SavePDFData to save the mapped fields before sending mail to user. - There might be no changes needed. Thanks, Swapnil P.
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Status Code Review [ 11801 ] In QA Testing [ 11901 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Assignee Swapnil Pandhare [ swapnil.pandhare ] Priya Dhamande [ priya.dhamande ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Time Spent 12h [ 43200 ] 13h [ 46800 ]
          Worklog Id 164464 [ 164464 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Time Spent 13h [ 46800 ] 14h [ 50400 ]
          Worklog Id 164465 [ 164465 ]
          Hide
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

          Hi Mohd Belal,

          We have to verify this through API or UI ?
          Can you please confirm

          Thanks
          Jayshree

          Priya Dhamande

          Show
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Mohd Belal , We have to verify this through API or UI ? Can you please confirm Thanks Jayshree Priya Dhamande
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In QA Testing [ 11901 ] In Progress [ 3 ]
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Assignee Priya Dhamande [ priya.dhamande ] Mohd Belal [ mohd.belal ]
          mohd.belal Mohd Belal (Inactive) made changes -
          Status In Progress [ 3 ] To Do [ 10000 ]
          Hide
          mohd.belal Mohd Belal (Inactive) added a comment -

          Hi Jayshree Nagpure,

          Both have to tested and verified.

          cc -Samir, Swapnil Pandhare

          Thanks

          Show
          mohd.belal Mohd Belal (Inactive) added a comment - Hi Jayshree Nagpure , Both have to tested and verified. cc - Samir , Swapnil Pandhare Thanks
          mohd.belal Mohd Belal (Inactive) made changes -
          Status To Do [ 10000 ] In QA Testing [ 11901 ]
          mohd.belal Mohd Belal (Inactive) made changes -
          Assignee Mohd Belal [ mohd.belal ] Jayshree Nagpure [ jayshree.nagpure ]
          Hide
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

          Verified HTML Preview through UI - Working fine
          For API, currently there is no such API preview request implemented.
          Created jira for the same DMS-1127.

          Closing this ticket

          Priya Dhamande Swapnil Pandhare Mohd Belal Ganesh Sadawarte

          Show
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified HTML Preview through UI - Working fine For API, currently there is no such API preview request implemented. Created jira for the same DMS-1127 . Closing this ticket Priya Dhamande Swapnil Pandhare Mohd Belal Ganesh Sadawarte
          jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 09/Apr/19 11:38 PM
          • Time Spent:
            0.5h
             

            testing

          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In QA Testing [ 11901 ] Done [ 10001 ]
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Time Spent 14h [ 50400 ] 14.5h [ 52200 ]
          Worklog Id 171981 [ 171981 ]
          Transition Time In Source Status Execution Times
          Swapnil Pandhare (Inactive) made transition -
          To Do In Progress
          23h 57m 1
          Swapnil Pandhare (Inactive) made transition -
          In Progress In Progress
          1d 23h 49m 1
          Swapnil Pandhare (Inactive) made transition -
          In Progress Done
          4d 1h 24m 1
          Swapnil Pandhare (Inactive) made transition -
          Done Code Review
          31s 1
          Swapnil Pandhare (Inactive) made transition -
          Code Review In QA Testing
          6d 23h 56m 1
          Jayshree Nagpure (Inactive) made transition -
          In QA Testing In Progress
          25d 6h 27m 1
          Mohd Belal (Inactive) made transition -
          In Progress To Do
          19h 1
          Mohd Belal (Inactive) made transition -
          To Do In QA Testing
          10m 22s 1
          Jayshree Nagpure (Inactive) made transition -
          In QA Testing Done
          3d 22h 45m 1

            People

            Assignee:
            jayshree.nagpure Jayshree Nagpure (Inactive)
            Reporter:
            swapnil.pandhare Swapnil Pandhare (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 10h Original Estimate - 10h
                10h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 14.5h
                14.5h