0 Replies Latest reply on Aug 27, 2014 2:48 PM by fdenman

    HELP!  Cannot Export Records from Web

    fdenman

      Title

      HELP!  Cannot Export Records from Web

      Post

           Hello,

           I'm very  new to Filemaker and can't seem to figure out the solution to my problem.  I have a web page that calls a script
           "tlcompleters".  the script basically goes to the last record in the dates table, and sets a global variable equal to the "completeddate" field.  I perform a find, searching for records equal to the global variable.  I then export and email those records in csv format.  The script works if i run it from the client, but it will not work if i run it from a web page.  I've read a few post and understand that the "Export Records" function is not compatible with web publishing.  I was hoping that someone has a work around for this OR perhaps could a web publishing script call a client script to export the records?   Below is my script, any help is truely appreciated!!!!!


           /* web page call to script
               $scriptName = 'tlcompleters';
               $script_object = $fm->newPerformScriptCommand($layoutName, $scriptName);
               $script_result = $script_object->execute();

            

           /* client script
           Go to Layout ["dates" (dates)]
           Go to Record/Request/Page [Last]
           Set Variable [$$completeddate; Value:dates::completeddate]
           Go to Layout ["students" (regstu)]
           Enter Find Mode []
           Set Field [regstu::completeddate; $$completeddate]
           Set Error Capture [On]
           Perform Find []
           Set Variable [$docpathtlcompleters; Value:Get ( DocumentsPath ) & "tlcompleters.csv"]
           Export Records [No dialog; "$docpathtlcompleters"; Macintosh]
           Send Mail [Send vial E-mail Client; No dialog; To: jane.doe@xxx.edu; Subject: "TL Completers Export"; Message "see attachment"; "$docpathtlcompleters" (NOT COMPATIBLE)]