How to Schedule Reports or Data Exports from FIMS
  • 18 Jan 2023
  • Contributors
  • Dark
    Light
  • PDF

How to Schedule Reports or Data Exports from FIMS

  • Dark
    Light
  • PDF

Article summary

Does FIMS have the function to schedule reports or data exports and if so, how can I do it?

Answer:
In FIMS that function does not exist, however, you can do this task outside of FIMS to export data out of the database itself using one of these two methods below.

These methods are for on-premise customers.
 
  1. ODBC refresh:
For this method, you would be using Excel to pull in data via an ODBC connection from the FIMS Progress database. 
https://techcommunity.microsoft.com/t5/excel/can-i-automate-an-odbc-connection-refresh-and-then-save-workbook/m-p/116571

First, set up the ODBC connection on the FIMS database server. For that, please create a support case.


Then, set up the ODBC connection on the workstation:

How do I setup an ODBC Connection on my FIMS workstation?

Lastly, connect that ODBC data source to Excel then use the steps in the first article to create the Excel ODBC refresh. This is just an example of one article on how to connect an ODBC source to Excel. There are many more available upon a search being done:
https://blog.devart.com/how-to-import-data-to-excel-via-odbc.html
 
  1. Progress Pro2SQL
For this process, you would need to reach out to Progess to purchase this feature.
https://www.progress.com/docs/default-source/default-document-library/pro2-whitepaper.pdf?sfvrsn=0

NOTE: Please note that while we provide links to third-party websites in an effort to help you resolve your issue, we are not responsible for the information on third-party websites and cannot assist in implementing the solution on these websites.

Was this article helpful?