Re: Having Trouble with Setting Variable and/or Get(DesktopPath) Script Step

On Jun 9, 3:19 pm, Grip <g...@xxxxxxxxxxxxx> wrote:
On Jun 9, 2:53 pm, jahn <jahnbigbo...@xxxxxxxxx> wrote:



Hello -

I'm working in FM9 Advanced on a Mac developing a file to be shared
via FM Server to a mixed-platform environment. I have several scripts
that save PDF, text and Excel files to the desktop that work just fine
on OSX, but when someone with a Windows computer runs them, the
database won't write the files to their disk -- perhaps because of
trouble with the desktop path variable. The relevant portion of one
of the troubled scripts is as follows...

Set Variable [$path; Value: Get(DesktopPath)]
Commit Records [Skip data entry validation; No dialog]
Save Records as Excel [Restore; No dialog; “Transportation.xls”;
Records being browsed]

...where the output file path is: $path/Transportation.xls

I thought this would cover all bases, but it appears not to be working
on any of several Windows machines even when the database is located
on the client computer and not being shared. This further raises the
question whether I'll need a different syntax once the database is
being served on FM Server. Has anyone experienced this issue and have
wisdom to share on the topic? Any help would be greatly appreciated.

Best,
-J.

You can't mix a variable with a text constant in the Save
As...dialog.

Try
Set Variable[$path; Get(DesktopPath) & "/Transportation.xls"]
then use $path by itself.

Note to self: Test before posting. It appears you can use the syntax
you're trying. I would still wrap it all in a single variable
though. Seems cleaner to me that way.
.

Relevant Pages

  • [NEWS] Granite Software ZMerge Administration Database Insecure Default ACLs
    ... the ZMerge administration database grants ... Note that while anonymous web users can read and modify all scripts, ... The ZMerge administration database contains the data import/export scripts ... server, allowing scripts to read and write arbitrary files on the server. ...
    (Securiteam)
  • Re: Having Trouble with Setting Variable and/or Get(DesktopPath) Script Step
    ... via FM Server to a mixed-platform environment. ... of the troubled scripts is as follows... ... Commit Records ... on any of several Windows machines even when the database is located ...
    (comp.databases.filemaker)
  • Having Trouble with Setting Variable and/or Get(DesktopPath) Script Step
    ... via FM Server to a mixed-platform environment. ... of the troubled scripts is as follows... ... Commit Records ... on any of several Windows machines even when the database is located ...
    (comp.databases.filemaker)
  • Re: Excel to FP Tables
    ... an Access Database, then use the save as an mdb, then use the Database Results ... frontpage web You can then set up a search, pagination of the screens (to display ... Access database & ASP reqiures ASP supported server, FP extensions, and Access ... I use scripts from www.ezscripting.co.uk - very good for ...
    (microsoft.public.frontpage.client)
  • Re: Advice on relational architecture/design before building
    ... forms can be connected to this database and hosted in the same server ... I cannot connect the forms for data collection to this, ... need to import the excel files. ...
    (microsoft.public.access.tablesdbdesign)
Loading