5

I work for a small nonprofit. Our funding body previously required reports in csv format. they now want them in xml. Of course they are not providing any funds! Can this be done via a custom report or would it be an extension? Would Drupal views combined with the views Data export module work? any assistance or pointers greatly appreciated

5
  • 2
    Have you looked at csv to xml converters? Search for "csv to xml" Dec 14, 2015 at 0:18
  • Thanks Sanjay that's sort of a last resort if I can't build it in to civi.
    – suzi
    Dec 14, 2015 at 4:13
  • 1
    Not sure about in civiCRM, but if you can search up the tables you need through views (can be tricky to configure depending on what you need) the drupal views data export module can export xml format nicely. Drupal Services views can also set up a REST style resource that folks can grab in xml format (maybe you can automate report pulls this way) but I believe you need to be a bit careful about security in that case. Dec 14, 2015 at 18:11
  • 1
    You really want to be more specific about your requirements first. XML is not really a format, but an abstract class of formats, and the details can be very different from one kind of XML to another. If your funding body is just asking for 'xml', then they're probably confused. They probably want a specific kind of xml, e.g. as defined by a document type.
    – Alan Dixon
    Dec 15, 2015 at 19:23
  • Suzi I have the same problem. Did you end up with a solution? And was this for DEX reporting?
    – LesleyJill
    Jul 9, 2022 at 23:47

1 Answer 1

1

As you've noted, your best bet is to use Drupal to generate the XML (whatever shape that might take as Alan Dixon commented).

Views Data Export, Views Datasource or Services Views will work if you require the flexibility of Views filters, etc. It really depends on what data need to be in the reports. As Eli noted in the comments above, using Services by itself could work, but depending on how the data is coming in, a Views solution is probably your best.

Another module to consider (again, depending on the data you need) is CiviCRM Entity. It will open up a lot more CiviCRM data to Drupal Views.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.