I need to export records into a csv file WITH HEADERS. Here is what I did: I first exported into a .mer file; then I changed the file name into a .csv file using Send Event script. This script resolves the command as follows:
cmd /c rename file:/C:/Program Files/FileMaker/FileMaker Server/Data/Documents/BarrieExporter/20170314_Connect5.mer 20170314_Connect5.csv
This works fine in Filemaker Pro. However, I need to schedule this export in Filemaker Server. Then I realized this was not supported.
Any suggestion to export into a csv file with headers, or change file format in Filemaker Server scheduled script?
Thanks in advance!