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.
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.
I am trying to create an email delivery service, where for each submission the data is sent in an excel spreadsheet to a specified email address.
I am reading an article which states you can do this by ticking the "Deliver Excel Receipt checkbox", however I cant seem to find the checkbox.
Delivery Configuration (Manager v4.3)
Could you please advise?
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!
Hi Brad White, Thanks for the detailed instructions on this. I've created the form and groovy script service, but I'm getting the following "No Dynamic Data service" error relating to the "GenerateDynamicDataReport":
Do you see an issue with how I've created this service delivery?
I believe the problem is how you created the service. You need to create a Dynamic Data Service called "GenericDynamicDataReport". It looks like you created a Delivery Service with a parameter called "GenericDynamicDataReport".