You are viewing limited content. For full access, please sign in.

Question

Question

Has anyone tried to integrate a Munis database into Laserfiche Forms?

asked on June 5, 2023

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.

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:

https://doc.laserfiche.com/laserfiche.documentation/11/administration/en-us/Default.htm#../Subsystems/Forms/Content/Settings/ODBC-Data-Sources.htm

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.