Hello,

I would like to present a Kexi form to a user by launching it from the command line i.e. I want to call it from a batch or PS script (Windows). Can someone comment on how that can be done?

Secondly once they input data into the form, I would like to have them click an 'export/submit' button which will output those data elements into a CSV.

I'm very new to Kexi and it's a non-starter for me if it can't do these two things.

Thanks!

Hi!
1. KEXI has a number of command-line options and commands. Command-line reference for is documented here http://www.kexi-project.org/wiki/wikivi ... tions.html. And if you type --help option you would see them too.
While I have not tested or used KEXI with PowerShell scripts and don't know if you'd see text output on screen. Unix versions of KEXI output all kind of output. In canse if this is lacking on Windows, the functionality should still work on Windows. Some warning, error and question messages, if they happen, are displayed in the graphical interface. For this reason KEXI has no "complete headless" mode currently for automation, although that was planned. Under the mask KEXI uses a KDb database framework that can be used to create programs for such operations though, compatible with KEXI file formats and KEXI server databases.

2. "Export to File" (CSV) can be assigned to a button this way: https://docs.kde.org/trunk5/en/kexi/kexi/kexi.pdf - see "3.5.8.1 Assigning actions to form buttons". Pick a table/query/form/report and pick "Export to File As Data Table".

Screen shots: http://www.kexi-project.org/pics/1.1.2/ ... ction.html

Best regards.