Extension to export to native Excel (xlsx)

[mathieu]

There's always things to add, code to cleanup, but unless you find any critical issues, I think it's pretty safe for production.

I'll try to get someone to review the code, so that we can enable it for automatic distribution (so that people can install directly from CiviCRM).

[SemperFi]

It's in production and I've applied the patch to our 4.4.6 version to fix export field size issue.
So far this is working well. I'll keep you posted if we found anything that could help moving forward with this great extension.


Thanks for your help Mathieu

[SemperFi]

Up! We're using the extension with success with Civi 4.5.1 / it really makes a difference. Thanks again.

[mathieu]

Hi everyone,

I was wondering if you could test a change I would like to make in civiexportexcel for 'reports' (does not apply to Search Export):

In the file civiexportexcel.php:

Code: [Select]

--- a/civiexportexcel.php
+++ b/civiexportexcel.php
@@ -118,7 +118,7 @@ function civiexportexcel_civicrm_buildForm($formName, &$form) {
       $form->buildRows($sql, $rows);
 
       // format result set.
-      $form->formatDisplay($rows);
+      // $form->formatDisplay($rows);

I noticed that some custom reports do not apply the "alterDisplay()" correctly when $form->formatDisplay() is called.

The only "bug" I found to removing that line of code, is that it adds a column for the "internal contact id" (on some reports).

Any thoughts?

Mathieu

EDIT: tangential: but I also pushed to git/master a fix for column types in Search Export. It was causing PHP notices.