14 Replies Latest reply on Mar 15, 2017 1:16 PM by philmodjunk

    How to export a csv file with headers in scheduled script

    GaoshengHuang

      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!