Export records with variable path set not working

January 28, 201411 yr

I have the attached script which allows the user to find a group of records, grabs the user's Desktop path -- Get(DesktopPath) and sets a field to be used as a variable --- Get(DesktopPath) & "exportPoints.tab", uses that field to set the variable $filepath which is used in the export.

On my machine and on a few other machines (all using Windows 7) this works fine and dandy.

On the person's machine that is supposed to use this, I am told that the error message - can't create file - either locked, or no room on disk or whatever occurs and no file is created. I have found that this message comes up very often when the $filepath is set incorrectly - but that does not appear to be the case - the file path that is being set is: /C:/Users/My/Desktop/exportPoints.tab Â -- could this be an issue? on my machine (and others..), the path looks like /C:/Users/[nameofpersontypically]/Desktop Â - I have never seen 'My' as a username. Also, he told me that if I were to hard code the path to a folder on his machine it would look like: C:/Users/My/Documents Â --- this looks odd to me also - but, maybe that's not the issue.

I know he can manually export the records - and I will need to go to that if I can't get this to work - but, the next step is to import to an online database, and I'd like the online database to know where to look for the file - if it is manually exported locally, I can't be sure that it will be in same place everytime.

I have created this solution in FMP11, the user is using FMP10 - I am unsure of his operating system - it could be XP.

Does anyone have any idea why this one person is having difficulty with this script? Or - what questions I should be asking to find out why they are having difficulty?Â

thanks so much!

Martie

January 29, 201411 yr

Author

In case anyone else runs into this issue, I have managed to solve it. Adding filewin: to the start of the variable for the path made it work on all machines and both FMP10 and FMP11. I am unsure whether this requirement was due to something about the user's machine or due to his using FMP10 - the script works fine for the other machines (all on 11) with or without 'filewin:'.

I think it's odd, but I'm glad it's solved. Of course, I now need to add a filter for the system platform so that if someone on a mac uses this it will work properly also.

Martie