I've been trying several different methods for generating a CSV file for our Accounts Payable process but have hit a wall with all of them. Lookup tables may work, but their usability is limited as I need to be able to write data to it, export that data after some time, and clear the old data while retaining previous versions of the table.

I figured the best way to do this was to use a CSV data source; however, I needed to install the Access 2010 runtime just to get it to work. Even when I did, the only options provided to me was to Select data from the file. When I tried to Insert or Update data, the CSV I had "verified" was greyed out. Is that a limitation of using a CSV as a data source?

The next thing I tried was to build a python script that would create a CSV file and input data by sending it through parameters. Now I'm stuck with that as I get the following error:

" Process python.exe: the system cannot find the file specified. Make sure python.exe has been setup. --> The system cannot find the file specified"

When I run python.exe in the command line, it works just fine. I have verified the filepath, and verified that the script works (right now it's a very basic script that just creates a CSV and puts one row in without any input parameters). Why is this error happening?

Is there some better way of generating a CSV file in Laserfiche Cloud that I'm missing?

Thanks in advance.