Topic: Export to Excel / CSV
Would be handy in the future be able to export reports to excel / CSV electronic forms instead of just PDF. Eg. Balance Sheets, GL, etc.
Re: Export to Excel / CSV
I second that notion. Big time.
I think it might already be in progress?
https://frontaccounting.com/wbt/pages/products/the-future.php
Re: Export to Excel / CSV
Not to be done before final 2.1 release. Probably this will be addressed in 2.2 release, or even some next 2.1.x issues.
Janusz
Re: Export to Excel / CSV
Best to adopt the pear component http://pear.php.net/manual/en/package.fileformats.spreadsheet-excel-writer.php
It does wonders
Re: Export to Excel / CSV
I haven't know this one, interesting thing. I was also thinking about integration of some lighter solution available on SF.net.
Janusz
Re: Export to Excel / CSV
Personly, I don't like the PEAR approach. I have been looking at a SF project called Excel Writer (XML) for PHP.
This is was they claim:
Set of classes for PHP that allow Excel XML files to be generated dynamically. Nearly a full implementation of the MS XML architecture. Requires PHP 5+ Does not require any XML libraries
It is very small and elegant. It is written in PHP 5.0 but as it is very small it is easy to fix so it runs in both 4 and 5.
It creates XML files, which of course is a good thing, especially for the XBRML standard. A standard for Accounting applications. This implementation is also for the future.
And it is easy to later create a class like pdf_report.inc, where similar routines are created. Then we only have to switch to the right include pdf_report or excel_report.
This is what I think we should do.
I will do some further research on this one. Please have a look and comment on this.
/Joe
Re: Export to Excel / CSV
Ya this looks to be pretty good Joe! I agree that for moving to the XBRML standard this is probably a good choice.