Mifos Data Migration Tool
  1. Mifos Data Migration Tool
  2. MIFOSDATAMIGRATION-70

Error uploading file - Cannot get a text value from a numeric cell

    Details

      Description

      Trying to upload "SAN FERNANDO_MARITESPAMPLONA_TUE_CTR1.xlsx" and getting this error. I looked at the file but cannot determine where its happening. Can you have a look and identify the issue, then chat with me so we can decide to do a validation or not.

      ---------
      HTTP Status 500 -

      type Exception report

      message

      description The server encountered an internal error () that prevented it from fulfilling this request.

      exception

      java.lang.IllegalStateException: Cannot get a text value from a numeric cell
      org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:781)
      org.apache.poi.xssf.usermodel.XSSFCell.getRichStringCellValue(XSSFCell.java:278)
      org.apache.poi.xssf.usermodel.XSSFCell.getStringCellValue(XSSFCell.java:230)
      dao.CreateClients.createClientFamily(CreateClients.java:521)
      dao.ReadFromExcelSheet.createClientFamily(ReadFromExcelSheet.java:250)
      RunMigration.doPost(RunMigration.java:138)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      ProcessFiles.doPost(ProcessFiles.java:180)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

      note The full stack trace of the root cause is available in the Apache Tomcat/6.0.20 logs.
      Apache Tomcat/6.0.20

        Activity

        Hide
        Seetha Rajagopalan added a comment -

        Error due to wrong format of date field. A validation has been incorporated in order to report such errors.

        Show
        Seetha Rajagopalan added a comment - Error due to wrong format of date field. A validation has been incorporated in order to report such errors.

          People

          • Assignee:
            Seetha Rajagopalan
            Reporter:
            Ryan Whitney
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: