export button

[carol333]

I have made a button to export records and some specified fields to an excel file on my desktop - the button and associated script works fine for me ( with administrator privileges) but it doesn't work for other users - they get the error message 'file is locked or in use' - can anyone tell me if I have made an error in the way the script works or is it a feature of Filemaker that you cannot make a button to export records?

My script is very simple ->

Export Records [Restore, "issue selection report.csv"]

Other users can use File > Export records OK, but aren't successful using my button.

Grateful for any help

Carol

[Genx]

... Most likely the file path is invalid? I.e. your desktop path is likely to be:

C:Documents and SettingsCarrol WilliamsDesktopyourfilehere.csv

Where as another users might be:

C:Documents and SettingsAlex BabkovDesktopyourfilehere.csv

[carol333]

hi

many thanks for this - it sounds like you're right - if I edit the script so it uses a dialog before exporting could this be the way for individual users to nominate where to place their file?

Carol

[Genx]

Likely yes...

[Inky Phil]

Carol

I thought I would just mention that there is a function Get(DesktopPath) which returns the path to the desktop folder for the current user.

You might be able to use this to keep things fully automated if you so wish

Phil

[Genx]

In FileMaker 6? I'm pretty sure you can't use variable file names before 8...

[carol333]

hi

thanks for this suggestion - we will be moving to FM 8 in the next six months so this may be something I can learn to do then

best regards

Carol

[Inky Phil]

Oops sorry! My mistake - but you really are being picky now!

Phil

[Genx]

Well no,

I do that all the time It's just wrong to give people false hope hehehe.