How to Export ACH Information from FIMS Database
  • 31 May 2023
  • Contributors
  • Dark
    Light
  • PDF

How to Export ACH Information from FIMS Database

  • Dark
    Light
  • PDF

Article summary

I need to export out ACH information from FIMS and I see that you cannot do that from a data grid or anywhere from FIMS, how can I export this data aside from the check export when printing a check?

Answer:
If you are sending data to a third party for check printing, we do not recommend exporting all ACH data out. We recommend using the check export. The check export will decrypt ACH fields if the user has permission to decrypt them. The check export has all of the correct corresponding data like grantee, payee, etc.

The article below outlines encryption permissions:

Configuring Encryption

See section 18 of this document for the check export process:
Check Export

To export all ACH data from the FIMS database, you will need to do the following.
NOTE: These steps below are only for on-premises customers these steps cannot be done if you are using FIMS on Azure Cloud:

1. Log into FIMS with an account that has permissions to encrypt and decrypt fields. In order to export ACH data out of the database, it has to be un-encrypted. You can later encrypt it again after exporting. The database table to decrypt will be the ACH_Distribution table:
Configuring Encryption

2. You will then use the steps in this article below to export that data. You will need to log into FIMS with an account that has access to the menu item referenced in the article:
How can I Output Table Data from Progress into a CSV File?
 

3. You will of course need to edit the query referenced in the article above to be specific to the database table for ACH data which is ACH_Distribution. See the article above for details on this process:
 

OUTPUT TO ach_distribution.csv. FOR EACH ach_distribution NO-LOCK : EXPORT DELIMITER "," ach_distribution. END. OUTPUT CLOSE.

 

4. To see ACH data in the database tables, you can do the following, again, the table will be ach_distribution. You cannot export out from this view, you can just view the data. you have to use the steps in the article referenced in step #2  to export:

How can I see all the tables and fields in FIMS?


Was this article helpful?