Skip to content

Is there a way to automate the CSV export that Output Channels provides (via right-click > Output > Output to CSV on a screen like Coordinators) so it saves to a location automatically on a schedule, rather than being manually triggered each time — ideally something a script could pick up afterward?

Answer

Output Channels itself doesn't have a built-in scheduling/automation mechanism for this. The practical approach used successfully by others is bypassing Output Channels entirely and querying the same underlying view or table directly from an external script — for example, a Python script using cx_Oracle to connect to the database and run the equivalent SELECT query, combined with a library like pandas to shape and write the results to CSV, wrapped in a batch file and triggered on a schedule via Windows Task Scheduler. This achieves the same recurring-export outcome as automating Output Channels, just built as an external script against the database rather than through the application's own Output Channel feature.

← Browse Integrations and APIs questions