[ 
http://mifosforge.jira.com/browse/MIFOS-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Artur Siekielski resolved MIFOS-3186.
-------------------------------------

    Resolution: Fixed

I implemented handling of XLSX format (one of Office Open XML formats from the 
wiki page). But handling of XLS format from newer Excel (which is also XML but 
begins with "<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet") is 
not possible - it's a propietary Microsoft format and it cannot be read from 
Java.

> MPESA plugin takes in Excel 97 spreadsheet, but it appears the safaricom 
> spreadsheet is actually in XML format
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: MIFOS-3186
>                 URL: http://mifosforge.jira.com/browse/MIFOS-3186
>             Project: mifos
>          Issue Type: Improvement
>    Affects Versions: Release 1.5.1
>            Reporter: Kay Chau
>            Assignee: Artur Siekielski
>             Fix For: Release E - Iteration 8, Release E
>
>
> In KEEF UAT testing, it appears that the safaricom spreadsheet actually comes 
> in an XML format w/ an .xls extension, instead of a "pure" Excel 97 
> spreadsheet.
> Example spreadsheet is here - 
> http://dl.dropbox.com/u/5083125/Test%20data%202_June%20Scrubbed.xls
> Details on Microsoft Excel here - 
> http://en.wikipedia.org/wiki/Microsoft_Excel#File_formats
> Determine if we need to / can fix the plugin to take in the XML format too

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Mifos-issues mailing list
Mifos-issues@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-issues

Reply via email to