Hello, I am in the process of creating an audit report and would like to have a drop-down list of all of the vendors that we have so that their info can be autofilled on different variables, and want to make sure that the list is up to date. I think that if I create my own database and table of vendors that it might become outdated as new vendors get added, so that's why I would want some kind of API call or something so a user can access the Munis database.
Question
Question
Has anyone tried to integrate a Munis database into Laserfiche Forms?
asked on June 5, 2023
0
0
Replies
replied on June 5, 2023
I am using MUNIS data but I am setting the process up by exporting a saved TRS report, as a csv, into a local FTP site where I can have SQL Server consume the file.
Then I have Forms populating fields via my db table lookups.
This is not live data, but I am working on less than 24 hours old (the ETL process happens overnight after close)
0
0
replied on June 5, 2023
Hi Ellie, we don't have Munis database for testing but if Munis database supports ODBC, you may give it a try to setup ODBC drivers and connections and use ODBC datasource in Forms:
0
0
You are not allowed to follow up in this post.