WORKTERRAProject Type: software

WORKTERRA

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

City of Irvine

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Module:
      BenAdmin
    • Reported by:
      Support
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      I am trying to load the file below into import rates and it is giving me an error code of invalid format - please advise or upload - THANK YOU

        Attachments

        1. IRVINE_s.xls
          441 kB
        2. IRVINE_sx.xlsx
          193 kB
        3. IRVINE.xlt
          447 kB

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-4586 WT -> Production Build Issue -> Getting Server error on Import Rate

          • High - Serious problem that could block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

            CC : Satya Samir Vijay Siddha

            Hi peggy fiedler

            Can you please check with attached files if its working?

            Thanks,
            Swapnil P.

            Show
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - CC : Satya Samir Vijay Siddha Hi peggy fiedler Can you please check with attached files if its working? Thanks, Swapnil P.
            Hide
            Permalink
            pfiedler peggy fiedler (Inactive) added a comment -

            the _s.xls - gave a error server encountered an internal error
            the _s.xlsx gave an error maximum capacity

            I need these loaded so I can move on with OE - thank you

            Show
            pfiedler peggy fiedler (Inactive) added a comment - the _s.xls - gave a error server encountered an internal error the _s.xlsx gave an error maximum capacity I need these loaded so I can move on with OE - thank you
            Hide
            Permalink
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

            CC : Vijay Siddha

            Hi Satya,

            This is similar as WT-4845. Due to service, file is getting removed from C :\temp directory and throwing server error on importing file.

            Thanks,
            Swapnil P.

            Show
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - CC : Vijay Siddha Hi Satya , This is similar as WT-4845 . Due to service, file is getting removed from C :\temp directory and throwing server error on importing file. Thanks, Swapnil P.
            Hide
            Permalink
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

            Hi Satya,

            Can you please assign this to someone. I guess this doesnt come under import team.

            Thanks,
            Swapnil P.

            Show
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - Hi Satya , Can you please assign this to someone. I guess this doesnt come under import team. Thanks, Swapnil P.
            Hide
            Permalink
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

            CC : Amruta Lohiya Satya

            Hi Harshawardhan Phalake

            First error was invalid format. So, i converted file to .xls and .xlsx. For both of these files, there is server error. The file is getting deleted from C:\temp path. I guess it is security issue. Please check this further.

            Thanks,
            Swapnil P

            Show
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - CC : Amruta Lohiya Satya Hi Harshawardhan Phalake First error was invalid format. So, i converted file to .xls and .xlsx. For both of these files, there is server error. The file is getting deleted from C:\temp path. I guess it is security issue. Please check this further. Thanks, Swapnil P
            Hide
            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) added a comment -

            Hi peggy fiedler,
            We are working on issue we will update you once done.

            Thanks,
            Harshawardhan

            Show
            harshawardhan Harshawardhan Phalake (Inactive) added a comment - Hi peggy fiedler , We are working on issue we will update you once done. Thanks, Harshawardhan
            Hide
            Permalink
            pfiedler peggy fiedler (Inactive) added a comment -

            What is the time frame to be able to import the rates? Thank you

            Show
            pfiedler peggy fiedler (Inactive) added a comment - What is the time frame to be able to import the rates? Thank you
            Hide
            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) added a comment -

            Hi peggy fiedler,
            This issue is covered under JIRA WT-4586. Currently this is on LB tomorrow it will be deployed on stage.
            We also go through the file that you send we found that the Rate and SubRate having "&" in their Names,
            once the issue get fixed and if you want to import the rates to system you need to change the names of rate which contains "&" because excel can not able to import the rates with "&" in it.
            This is the behavior of rate import functionality.
            As this is technical difficulty and "&" is used internally during import processing so once patch get deployed you can use AND instead of "&" before importing rates and we will restrict "&" trough UI once we done with these.

            Thanks,
            Harshawardhan.

            CC: Satya, Saurabh Sablaka,Swapnil Pandhare

            Show
            harshawardhan Harshawardhan Phalake (Inactive) added a comment - Hi peggy fiedler , This issue is covered under JIRA WT-4586 . Currently this is on LB tomorrow it will be deployed on stage. We also go through the file that you send we found that the Rate and SubRate having "&" in their Names, once the issue get fixed and if you want to import the rates to system you need to change the names of rate which contains "&" because excel can not able to import the rates with "&" in it. This is the behavior of rate import functionality. As this is technical difficulty and "&" is used internally during import processing so once patch get deployed you can use AND instead of "&" before importing rates and we will restrict "&" trough UI once we done with these. Thanks, Harshawardhan. CC: Satya , Saurabh Sablaka , Swapnil Pandhare
            Hide
            Permalink
            satyap Satya added a comment -

            Hi Peggy,

            This bug has been deployed on Stage & you can find the testing status under JIRA ID: WT-4586.

            Please let us know in case more details required on this.

            Thanks & Regards,
            Satya Prakash

            Cc: Priya Dhamande Rakesh Roy Amruta Lohiya Vijay Siddha

            Show
            satyap Satya added a comment - Hi Peggy, This bug has been deployed on Stage & you can find the testing status under JIRA ID: WT-4586 . Please let us know in case more details required on this. Thanks & Regards, Satya Prakash Cc: Priya Dhamande Rakesh Roy Amruta Lohiya Vijay Siddha

              People

              Assignee:
              pfiedler peggy fiedler (Inactive)
              Reporter:
              pfiedler peggy fiedler (Inactive)
              Account Executive:
              peggy fiedler (Inactive)
              Developer:
              Harshawardhan Phalake (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: