Is there a better way of using the export records script step...???

[angelleye]

Some of our users are on a Mac and some are on Windows. I've got a script setup that includes an Export Records step.

On Windows machines this isn't a problem because I can save it to filewin:/C:/filename.tab

No matter what computer you're on (windows) this will work because the drive letter is C:. I know it's possible somebody could have changed their drive letters, but that's not likely.

My problem is on the Mac side. The format for export records is filemac:/VolumeName/filename.tab

The problem here is that many Mac users change the name of their drive to something else and there's no way of knowing what it would be for any given user.

Is there a way I can set this up so that no matter what computer a person is on it will work? Currently I have an If/Then that checks the OS type and if it's Windows it just uses filewin:/c:/filename.tab and if it's Mac it uses filemac:/Macintosh HD/filename.tab. But if a Mac user has changed their drive name it won't work for them.

Any ideas? Thanks!

[angelleye]

I found a Get(SystemDrive) function that will return the Mac volume name so that's cool, however, it doesn't look like I can use variables or dynamic field values within the Export File script step's setup dialog..??

[angelleye]

Ah, I think I figured out a way using script variables.

[angelleye]

Yup, works great! Now it works no matter what platform they're on and no matter what the drive letter/volume name is. woohoo!