I was wondering if there is a way to create an automated excel export of the extract data on a monthly basis which will be emailed to a specified address.
We have been meaning to write a groovy service to do this for ages, but haven't found the time to even start on it. If you do write one, can you please share the code? This would be hugely helpful for a few of our form owners.
The answer is yes and it's quite simple. I've posted a KB article that you could easily transform into a scheduled service that will deliver this data via email. https://support.avoka.com/kb/display/TKB/Creating+and+Presenting+Custom+Reports
The DAO you'd be looking for is: DaoFactory.getSubmissionExtractDataDao().getSubmissionExtractData(). There's a Fluent equivalent which is recommended but the problem with the Fluent version is it doesn't take a date range yet. Good luck!
Take a look at the BIRT reporting guide at BIRT Reporting Guide Manual
Bill, BIRT Reporting is legacy.
The recommended solution would be to use a scheduled service to execute a Groovy Script to access Data Extracts, and then create an Excel file which can be transferred externally.
I do not have the details on how to code this.
Hannah, please be careful. If you send PII data over email, this could be seen as a data security risk. Check with your architects and security department if there is another way to do this.
Some examples of a secure transfer include:
Each of these solutions require some sort of setup by your organisation, and are worth considering.