- Print
- DarkLight
- PDF
How to Export ACH Information from FIMS Database
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?
The article below outlines encryption permissions: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?