Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-8848

City National Bank import failure

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: High
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Support Task Type:
      Data Load
    • Reported by:
      Support
    • Module:
      BenAdmin - Import
    • Severity:
      Simple

      Description

      when i try to load a file into the "EE Load" template on stage. the file is failing. i will email you the file to try to load. please provide reasoning for failure. thanks
      cc Abhay Patil

        Attachments

          Issue Links

            Activity

            nwalker Nathaniel Cornejo-Walker (Inactive) created issue -
            nwalker Nathaniel Cornejo-Walker (Inactive) made changes -
            Field Original Value New Value
            Priority Medium [ 3 ] High [ 2 ]
            Hide
            mandark Mandar Kulkarni (Inactive) added a comment -

            Hi Suraj Sokasane,
            Could you please look in to this?

            --------------------------------------------
            CC: Vijay Siddha

            Show
            mandark Mandar Kulkarni (Inactive) added a comment - Hi Suraj Sokasane , Could you please look in to this? -------------------------------------------- CC: Vijay Siddha
            mandark Mandar Kulkarni (Inactive) made changes -
            Assignee Mandar Kulkarni [ mandark ] Suraj Sokasane [ suraj.sokasane ]
            Hide
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            Hi Nathaniel Cornejo-Walker,

            The "Multiple Rows?" flag should be set to Yes on template settings.Yes is used for normal templates where as No is used for column-wise paycheck imports only. I've changed the flag and file will be imported properly.

            We will change the help text under that field so that it will be more understandable.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Nathaniel Cornejo-Walker , The "Multiple Rows?" flag should be set to Yes on template settings.Yes is used for normal templates where as No is used for column-wise paycheck imports only. I've changed the flag and file will be imported properly. We will change the help text under that field so that it will be more understandable.
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Nathaniel Cornejo-Walker [ nwalker ]
            Resolution Done [ 10000 ]
            Status Open [ 1 ] Resolved [ 5 ]
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 14/Mar/17 12:53 PM
            • Time Spent:
              2h
               

              Analysis, new JIRA creation, mail to client.

            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 30908 [ 30908 ]
            Hide
            abhay.patil Abhay Patil (Inactive) added a comment -

            Nathaniel Cornejo-Walker - what was the error message?
            Thanks. Suraj Sokasane. While help text is a good thing, is it also possible for the system to emit an error message that could help the user to understand what went wrong?
            CC Mandar Kulkarni

            Show
            abhay.patil Abhay Patil (Inactive) added a comment - Nathaniel Cornejo-Walker - what was the error message? Thanks. Suraj Sokasane . While help text is a good thing, is it also possible for the system to emit an error message that could help the user to understand what went wrong? CC Mandar Kulkarni
            Hide
            nwalker Nathaniel Cornejo-Walker (Inactive) added a comment -

            Abhay Patil unfortunately, we do not get an reasoning for an import failure.

            Show
            nwalker Nathaniel Cornejo-Walker (Inactive) added a comment - Abhay Patil unfortunately, we do not get an reasoning for an import failure.
            Hide
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            Hi Abhay Patil and Nathaniel Cornejo-Walker,

            We will analyze if an proper Error message can be displayed and update you accordingly.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Abhay Patil and Nathaniel Cornejo-Walker , We will analyze if an proper Error message can be displayed and update you accordingly.
            nwalker Nathaniel Cornejo-Walker (Inactive) made changes -
            Attachment screenshot-1.png [ 42083 ]
            Hide
            nwalker Nathaniel Cornejo-Walker (Inactive) added a comment -

            Suraj Sokasane on the file that the client the date format is MMDDYYYY and that format isnt available in WT.

            is there a workaround for this issue?
            CC Mandar Kulkarni Abhay Patil

            Show
            nwalker Nathaniel Cornejo-Walker (Inactive) added a comment - Suraj Sokasane on the file that the client the date format is MMDDYYYY and that format isnt available in WT. is there a workaround for this issue? CC Mandar Kulkarni Abhay Patil
            Hide
            nwalker Nathaniel Cornejo-Walker (Inactive) added a comment -

            Date format

            Show
            nwalker Nathaniel Cornejo-Walker (Inactive) added a comment - Date format
            nwalker Nathaniel Cornejo-Walker (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Resolved [ 5 ] Reopened [ 4 ]
            nwalker Nathaniel Cornejo-Walker (Inactive) made changes -
            QA Nathaniel Cornejo-Walker [ nwalker ]
            Original Estimate 0h [ 0 ]
            nwalker Nathaniel Cornejo-Walker (Inactive) made changes -
            Assignee Nathaniel Cornejo-Walker [ nwalker ] Suraj Sokasane [ suraj.sokasane ]
            Hide
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            Hi Nathaniel Cornejo-Walker,

            We currently do not support the MMDDYYYY format for Import. This will need enhancement.
            You can create a JIRA for the same of type Enhancement and get it approved from Dave. Please suggest other dateformats which are coming in file right now and not yet implemented in WT.
            I do not see any workaround for this right now except manually changing the dateformat in excel.
            Please let us know if you have any queries.

            CC- Vijay Siddha, Satya, Jaideep Vinchurkar

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Nathaniel Cornejo-Walker , We currently do not support the MMDDYYYY format for Import. This will need enhancement. You can create a JIRA for the same of type Enhancement and get it approved from Dave. Please suggest other dateformats which are coming in file right now and not yet implemented in WT. I do not see any workaround for this right now except manually changing the dateformat in excel. Please let us know if you have any queries. CC- Vijay Siddha , Satya , Jaideep Vinchurkar
            Hide
            nwalker Nathaniel Cornejo-Walker (Inactive) added a comment -

            thank you for the feedback Suraj Sokasane
            Abhay Patil please advise if this is something that we can request. thanks

            Show
            nwalker Nathaniel Cornejo-Walker (Inactive) added a comment - thank you for the feedback Suraj Sokasane Abhay Patil please advise if this is something that we can request. thanks
            rakeshr Rakesh Roy (Inactive) made changes -
            Link This issue relates to WT-8876 [ WT-8876 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Import(10111)
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Status Reopened [ 4 ] In Progress [ 3 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Nathaniel Cornejo-Walker [ nwalker ]
            abhay.patil Abhay Patil (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            Hide
            abhay.patil Abhay Patil (Inactive) added a comment -

            Have created enhancement request for the same WT-8876.

            Show
            abhay.patil Abhay Patil (Inactive) added a comment - Have created enhancement request for the same WT-8876 .
            abhay.patil Abhay Patil (Inactive) made changes -
            Resolution Duplicate [ 3 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            abhay.patil Abhay Patil (Inactive) made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            nwalker Nathaniel Cornejo-Walker (Inactive) made changes -
            Link This issue is cloned by WT-9419 [ WT-9419 ]
            Transition Time In Source Status Execution Times
            Suraj Sokasane (Inactive) made transition -
            Open Resolved
            11h 29m 1
            Nathaniel Cornejo-Walker (Inactive) made transition -
            Resolved Reopen
            3h 53m 1
            Suraj Sokasane (Inactive) made transition -
            Reopen In Progress
            1d 14h 47m 1
            Suraj Sokasane (Inactive) made transition -
            In Progress Waiting for Customer Input
            13s 1
            Abhay Patil (Inactive) made transition -
            Waiting for Customer Input In Progress
            8h 46m 1
            Abhay Patil (Inactive) made transition -
            In Progress Resolved
            1m 24s 1
            Abhay Patil (Inactive) made transition -
            Resolved Closed
            11m 29s 1

              People

              Assignee:
              nwalker Nathaniel Cornejo-Walker (Inactive)
              Reporter:
              nwalker Nathaniel Cornejo-Walker (Inactive)
              QA:
              Nathaniel Cornejo-Walker (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 2h
                  2h