Filemaker automated filename when exporting

Hi,

I have database which tracks merchandise delivered and received, one of our suppliers(supplier X) wants me to exports records into .csv and save the the file name as the time stamp field.

Examples

For Order Acknowledgment the suppler wants the file name to be like: Order_Ack_YYYYMMDD_HHMMSS; Order_Ack_20100512_032501.csv

Is there anyway to do a script where it automatically saves it like the above format, instead of me manually typing the actual file name.


Any help would be greatly appreciated

Many Thanks,

jedi
J3D1-KN1G1-1tAsked:
Who is Participating?
 
Lieven EmbrechtsSenior IT ConsultantCommented:
From filemaker 8 and later, you can use $variables in file paths.
Variables let you specify file or folder paths dynamically.
more info here: http://www.filemaker.com.au/help/html/create_db.8.32.html

i assume you already registered the acknowledgment date-time in a field.
so in your script:
- first set a $variable with a calculation to you file format
- export to that variable
0
 
lesouefCommented:
don't to format it fmwise, ie:
file://folder/filename
or winfile:/C:/folder/file
or macfile:volume/folder/file (from memory, not 100% dure)
0
 
lesouefCommented:
missing word up there
read don't forget to format...
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
J3D1-KN1G1-1tAuthor Commented:
Thanks for all the replies

Will this create multiple exports ? or will it keep exporting to the same file?
I need to have multiple exports for every record for each time stamp created

Cheers
0
 
lesouefCommented:
up to you, it exports the current foundset, so do what you need. you obviouly need to select the right records before exporting
0
 
J3D1-KN1G1-1tAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.