When working on Web Direct version have Performed script to Save to Excel - this is not happening even though the same script works when Performed on Server. Am I missing an element of the setup?
"Save Records As Excel"
(NOT COMPATIBLE ON: Server or Web Direct)
(PARTIAL on Server & Web Direct - so see the notes)
Can you post the script(s) that you use to PSoS?
Thank you for your response
This is the script that I am running – sorry had to type longhand – cannot find an easy way to take screen shot from server.
Save Records as Excel
Show All Records
This may explain why I am having problem when in Webdirect but not via the Server as developer
Thank you for the update. Yes, an incompatibility will halt the progress.
(at least until you get a work-around)
If you can performed on server,
Perform Script on Server [ exporting ]Export Field Contents [ ] // webd user download excel file from container
Perform Script on Server [ exporting ]
Export Field Contents [ ] // webd user download excel file from container
and "exporting" script is
Go to layout [ ]//choose records and sort for exportingSet Variable [ $path ; Get(TemporaryPath) & Get(UUID) & ".xlsx" ]Export Records [ $path ]Insert From URL [ "file://" & $path ; don't encode URL ]
Go to layout [ ]
//choose records and sort for exporting
Set Variable [ $path ; Get(TemporaryPath) & Get(UUID) & ".xlsx" ]
Export Records [ $path ]
Insert From URL [ "file://" & $path ; don't encode URL ]
The record inserting file on server and exporting field contents on client should be same, so you'd need some more steps (and table/container field)
Thank you for the script that may help to resolve the issue - currently I am using one script named Export File to Excel - am I correct in assuming that I will need to rewrite this as follows
Go to Layout ["Availability" (Argos Tag Logger)]
Perform Script on server ["Export File to Excel"] should this be at the end of the process
Export Field Contents ["filewin:/U:/Users Shared Files/Lesley/Filemaker Pro/Import from Filemaker/Export"] file destination?
Perform Script ["Chosen Tags"] creates found set for export
Set Variable [$Path;Value:Get (Temporary Path)$ Get (UUID) & ".xlsx"]
Export Records [Filename;$Path;Character Set;Windows(ANSI)";Field Order:Argos Tag Logger::Tag ID
Argos Tag Logger::Hexadecimal
Argos Tag Logger::Frequency
Argos Tag Logger::Selected
Argos Tag Logger::Available]
Insert into URL ["File://"&$Path]
[Do not automatically encode URL;Select;No dialog]
Perform Script ["Chosen Tags"] returns to found set
Perform Script ["Remove Selection"] removes check from checkbox
My confusion comes when I get to your last sentence
"The record inserting file on server and exporting field contents on client should be the same" - so do I actually need two scripts to perform the task?
"You need more steps and table/container field" - I do not follow exactly what is meant here!
Thanks once again for your help
Retrieving data ...