1

I have a bunch of views/reports built for my client. The reviewers then click download csv for the excel file. They asked if the views could download themselves daily to a folder.

Is that possible? And could you share links or knowledge how to handle this. I have been trying to figure it out.

Note: Right now the user is downloading CSV's from Drupal 7, an install of Moodle 1.9 in a Drupal 6 Shell and Survey Monkey. After they download and combine using Excel, the user creates reports that way for the users we have come to our events. Being a Front-end developer, coding is not my strength.

1

Maybe you want to consider the Forena module (disclosure: I'm a co-maintainer of it) ... Here is a quote from that page:

... built of the idea of using SQL to get data out of a database and use XHTML and CSS to format it into web reports.

It is designed to leverage existing knowledge of HTML, CSS, SQL and JavaScript to help you create rich interactive web reports.

Here is another quote from Reasons for considering Forena, related to the "CSV" in the question here:

Reports created by Forena (combined with SVGGraph and mPDF) can be saved (exported) as PDF documents with embedded graphs. Other supported formats for saving a report are CSV, XLS, DOC, HTML, etc.

My answer to "How to retrieve data directly from a Drupal database" contains like a 1 minute summary to explain the typical (about 3) steps for creating:

  • a connection to an external database (typically by an admin).
  • a custom SQL query (typically by an admin).
  • a custom report (either by an admin, or by just any regular user who is either familiar with creating what is called 'FRX files', or otherwise using the WYSIWYG report editor).

These steps (without any PHP coding involved ...) are like the equivalent to writing the PHP coding as included in the question there.

For an online demo (prior to installing/testing Forena), refer to these links:

  • Wow, Thank you for the answer. Right now the user is downloading csv's from Drupal 7, an install of Moodle 1.9 in a Drupal 6 Shell and Survey Monkey. After they download and combine using Excel, she creates reports that way for the users we have come to our events. Being a Front-end developer, coding is not my strength. I will be spending some time today to read through this module. If you have more to share based on that please share away! I still have a lot to learn. Thanks! – timwhelan Apr 28 '15 at 12:09
1

You might want to take a look at Views Rules. It's just for Drupal 7, but it should allow you to integrate your view with rules.

Views Bulk Operations might be another option, it can also work with rules, but might be have a bit of a learning curve to get it set up.

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.