CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Extensions (Moderators: mathieu, totten, kasiawaka) »
  • Extension to export to native Excel (xlsx)
Pages: 1 [2]

Author Topic: Extension to export to native Excel (xlsx)  (Read 4834 times)

mathieu

  • Administrator
  • Ask me questions
  • *****
  • Posts: 620
  • Karma: 36
    • Work
  • CiviCRM version: 4.7
  • CMS version: Drupal
  • MySQL version: MariaDB 10
  • PHP version: 7
Re: Extension to export to native Excel (xlsx)
August 28, 2014, 11:07:53 am
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).
CiviCamp Montréal, 29 septembre 2017 | Co-founder / consultant / turn-key CiviCRM hosting for Quebec/Canada @ SymbioTIC.coop

SemperFi

  • I post frequently
  • ***
  • Posts: 177
  • Karma: 3
  • CiviCRM version: 4.5.4
  • CMS version: Wordpress 4.0.1
  • MySQL version: MySQL 5.5.16
  • PHP version: PHP 5.3.17
Re: Extension to export to native Excel (xlsx)
September 01, 2014, 06:31:35 am
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

  • I post frequently
  • ***
  • Posts: 177
  • Karma: 3
  • CiviCRM version: 4.5.4
  • CMS version: Wordpress 4.0.1
  • MySQL version: MySQL 5.5.16
  • PHP version: PHP 5.3.17
Re: Extension to export to native Excel (xlsx)
October 14, 2014, 02:11:27 pm
Up! We're using the extension with success with Civi 4.5.1 / it really makes a difference. Thanks again.

mathieu

  • Administrator
  • Ask me questions
  • *****
  • Posts: 620
  • Karma: 36
    • Work
  • CiviCRM version: 4.7
  • CMS version: Drupal
  • MySQL version: MariaDB 10
  • PHP version: 7
Re: Extension to export to native Excel (xlsx)
December 03, 2014, 01:23:28 pm
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.
« Last Edit: December 03, 2014, 01:28:16 pm by mathieu »
CiviCamp Montréal, 29 septembre 2017 | Co-founder / consultant / turn-key CiviCRM hosting for Quebec/Canada @ SymbioTIC.coop
Pages: 1 [2]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Extensions (Moderators: mathieu, totten, kasiawaka) »
  • Extension to export to native Excel (xlsx)

This forum was archived on 2017-11-26.