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

  • 2
    Have you looked at csv to xml converters? Search for "csv to xml" – Sanjay Jain Dec 14 '15 at 0:18
  • Thanks Sanjay that's sort of a last resort if I can't build it in to civi. – suzi Dec 14 '15 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. – Eli Lisseck Dec 14 '15 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 '15 at 19:23
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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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