Any tips for naming an exported file ?

[FM User New]

Hi Folks,

I'm setting up a lot of .mer export files which will then be sent to PDA's !

The problem is that I need to name each file uniquely - e.g. I had hoped to call the file - Jobfile HR 152793.mer with the "HR 152793" bit changing everytime as that is the unique job number in the file I'm exporting from.

Basically I want to name the file as the job number I'm exporting - as I'll be exporting a single job (record)at a time - How can I do this?: Do I need a plugin ?

I've no idea !

Any help would be great !

Thanks Folks

Dermot

[Fitch]

It's easy to do with a plugin such as Troi File. I recommend it.

[QuinTech]

Hi, Dermot. I'm a big fan of the Troi File plugin, but i learned from Wim Decorte how to do this without a plugin.

What you could do is to export the .mer file to the same spot every time, let's say C:jobsJobnew.mer. Also, have a calc text field, equal to:

"cmd /c move C:jobsJobnew.mer C:jobs" & uniqueJobNumber & ".mer"

Be sure that if the path is not 8.3-style (i.e., has spaces or more than eight characters in it) you will need to use quotes:

"cmd /c move ""C:longer folder nameJobnew.mer"" C:jobs" & uniqueJobNumber & ".mer"

HTH,

Jerry

[QuinTech]

Oh yeah, i should have added that Troi File does a lot more besides this. I couldn't do my job without it.

[FM User New]

HI Folks,

Thanks for all your help !

Tried out your suggestion QuinTech - Works a treat !!

Didn't know you could do that sort of thing from within Filemaker.

Cheers again !

Dermot