dbTalk Databases Forums  

Filename saved with actual sytem date or time stamp

comp.databases.filemaker comp.databases.filemaker


Discuss Filename saved with actual sytem date or time stamp in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
walhol
 
Posts: n/a

Default Filename saved with actual sytem date or time stamp - 11-30-2005 , 07:42 AM






Hello,
I want from a running script my exported records write to disk. The filename
should be by each run have the name of the system date e.g.
filemac:/mac/Users/walli/actualdate.fp7 were actualdate:=DDMMYY
I couldn't find any syntax in the script maker. Does anybody have an idea?

regards
Walter



Reply With Quote
  #2  
Old   
Helpful Harry
 
Posts: n/a

Default Re: Filename saved with actual sytem date or time stamp - 11-30-2005 , 01:47 PM






In article <dmka7r$2mp$1 (AT) news (DOT) mch.sbs.de>, "walhol" <hollerwal (AT) aol (DOT) de>
wrote:

Quote:
Hello,
I want from a running script my exported records write to disk. The filename
should be by each run have the name of the system date e.g.
filemac:/mac/Users/walli/actualdate.fp7 were actualdate:=DDMMYY
I couldn't find any syntax in the script maker. Does anybody have an idea?
I'm not 100% sure about FileMaker 7, but older versions of FileMaker
cannot have a variable export filename. The Export script command can
use either static text or let the user chooce a filename.

To do what you want you would need an extra file routines plug-in or
use AppleScript or it's Windows equivalent.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)


Reply With Quote
  #3  
Old   
Matt Wills
 
Posts: n/a

Default Re: Filename saved with actual sytem date or time stamp - 11-30-2005 , 04:39 PM



Helpful Harry wrote:

Quote:
In article <dmka7r$2mp$1 (AT) news (DOT) mch.sbs.de>, "walhol" <hollerwal (AT) aol (DOT) de
wrote:

Hello,
I want from a running script my exported records write to disk. The
filename should be by each run have the name of the system date e.g.
filemac:/mac/Users/walli/actualdate.fp7 were actualdate:=DDMMYY
I couldn't find any syntax in the script maker. Does anybody have
an idea?

I'm not 100% sure about FileMaker 7, but older versions of FileMaker
cannot have a variable export filename. The Export script command can
use either static text or let the user chooce a filename.

To do what you want you would need an extra file routines plug-in or
use AppleScript or it's Windows equivalent.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships
;o)
You still can't in 7.

Before oAzium FileTools (plugin), I exported to a generically-named
file (export.txt), then used a calc field to dynamically generate an
AppleScript which, when run, changed the name of export.txt to whatever.

It worked like a charm, but due to the generosity of my employer at the
time, I now have a dev license to FileTools, which does a lot more than
I could do with AS (read: had time to learn).

Something similar could be done in Winduhs.

Matt

Matt

--



Reply With Quote
  #4  
Old   
Howard Schlossberg
 
Posts: n/a

Default Re: Filename saved with actual sytem date or time stamp - 11-30-2005 , 05:04 PM



walhol wrote:
Quote:
Hello,
I want from a running script my exported records write to disk. The filename
should be by each run have the name of the system date e.g.
filemac:/mac/Users/walli/actualdate.fp7 were actualdate:=DDMMYY
I couldn't find any syntax in the script maker. Does anybody have an idea?
You don't specify whether you are using FM7 or FM8. There is no way to
do it in FM7 without either a plug-in, a DOS 'rename' command or an
Applescript.

In FM8, you can set a variable with the full path and file name, and
then use that variable name within the scripted export dialog.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance


Reply With Quote
  #5  
Old   
Helpful Harry
 
Posts: n/a

Default Re: Filename saved with actual sytem date or time stamp - 11-30-2005 , 05:54 PM



In article <11osbv5i2510587 (AT) corp (DOT) supernews.com>, Howard Schlossberg
<howard (AT) antispahm (DOT) fmprosolutions.com> wrote:

Quote:
walhol wrote:
Hello,
I want from a running script my exported records write to disk. The filename
should be by each run have the name of the system date e.g.
filemac:/mac/Users/walli/actualdate.fp7 were actualdate:=DDMMYY
I couldn't find any syntax in the script maker. Does anybody have an idea?

You don't specify whether you are using FM7 or FM8. There is no way to
do it in FM7 without either a plug-in, a DOS 'rename' command or an
Applescript.

In FM8, you can set a variable with the full path and file name, and
then use that variable name within the scripted export dialog.
I guessed that "...actualdate.fp7" implies FileMaker 7, but that could
easily be wrong. )

Which leads to another point, the exported file should not be called
".fp7", but will be ".txt" if a standard tab-seperated text file and
there are other filename extensions for the other filetypes FileMaker
can export.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)


Reply With Quote
  #6  
Old   
Helpful Harry
 
Posts: n/a

Default Re: Filename saved with actual sytem date or time stamp - 11-30-2005 , 05:57 PM



In article <xSpjf.335$GA2.25@trndny02>, "Matt Wills" <Im (AT) Witz (DOT) End>
wrote:

Quote:
Helpful Harry wrote:

In article <dmka7r$2mp$1 (AT) news (DOT) mch.sbs.de>, "walhol" <hollerwal (AT) aol (DOT) de
wrote:

Hello,
I want from a running script my exported records write to disk. The
filename should be by each run have the name of the system date e.g.
filemac:/mac/Users/walli/actualdate.fp7 were actualdate:=DDMMYY
I couldn't find any syntax in the script maker. Does anybody have
an idea?

I'm not 100% sure about FileMaker 7, but older versions of FileMaker
cannot have a variable export filename. The Export script command can
use either static text or let the user chooce a filename.

To do what you want you would need an extra file routines plug-in or
use AppleScript or it's Windows equivalent.

You still can't in 7.

Before oAzium FileTools (plugin), I exported to a generically-named
file (export.txt), then used a calc field to dynamically generate an
AppleScript which, when run, changed the name of export.txt to whatever.

It worked like a charm, but due to the generosity of my employer at the
time, I now have a dev license to FileTools, which does a lot more than
I could do with AS (read: had time to learn).

Something similar could be done in Winduhs.
For FileMaker 5 there's a free plug-in called "File Toolbox" at
http://www.geocities.com/SiliconVall...7/plPLUGs.html for
both Windows and Mac OS 9.

I haven't tried it, but it probably works in FileMaker 6 as well, but
the changes to FileMaker 7 may mean that it doesn't work there - could
be worth trying since it is free though.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)


Reply With Quote
  #7  
Old   
walhol
 
Posts: n/a

Default Re: Filename saved with actual sytem date or time stamp - 12-01-2005 , 06:05 AM



I am using FM7. FoxPro can this since 10 years. None the less, why should I
store the exported records to a text file?
When I upgrade my application, I must backup the existing records and import
to the new application.
regards
Walter

"Helpful Harry" <helpful_harry (AT) nom (DOT) de.plume.com> wrote

Quote:
In article <11osbv5i2510587 (AT) corp (DOT) supernews.com>, Howard Schlossberg
howard (AT) antispahm (DOT) fmprosolutions.com> wrote:

walhol wrote:
Hello,
I want from a running script my exported records write to disk. The
filename
should be by each run have the name of the system date e.g.
filemac:/mac/Users/walli/actualdate.fp7 were actualdate:=DDMMYY
I couldn't find any syntax in the script maker. Does anybody have an
idea?

You don't specify whether you are using FM7 or FM8. There is no way to
do it in FM7 without either a plug-in, a DOS 'rename' command or an
Applescript.

In FM8, you can set a variable with the full path and file name, and
then use that variable name within the scripted export dialog.

I guessed that "...actualdate.fp7" implies FileMaker 7, but that could
easily be wrong. )

Which leads to another point, the exported file should not be called
".fp7", but will be ".txt" if a standard tab-seperated text file and
there are other filename extensions for the other filetypes FileMaker
can export.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)



Reply With Quote
  #8  
Old   
Matt Wills
 
Posts: n/a

Default Re: Filename saved with actual sytem date or time stamp - 12-01-2005 , 09:02 AM



walhol wrote:

Quote:
I am using FM7. FoxPro can this since 10 years. None the less, why
should I store the exported records to a text file?
Export the file to whatever supported format you want to use.

The point is that if you want automated export to a dynamically-named
file, you have to use 1) a plug-in or 2) a calc field that will create
a Your-OS-Script to change the name of the file once it has been
exported.

Quote:
When I upgrade my application, I must backup the existing records and
import to the new application.
Are you saying that you export your FileMaker data to back it up, then
re-import it?

Why not just keep a backup copy of the FM file and import from there as
needed?

Matt

Quote:
regards
Walter

"Helpful Harry" <helpful_harry (AT) nom (DOT) de.plume.com> wrote in message
news:011220051254591403%helpful_harry (AT) nom (DOT) de.plume.com...
In article <11osbv5i2510587 (AT) corp (DOT) supernews.com>, Howard Schlossberg
howard (AT) antispahm (DOT) fmprosolutions.com> wrote:

walhol wrote:
Hello,
I want from a running script my exported records write to disk.
The
filename
should be by each run have the name of the system date e.g.
filemac:/mac/Users/walli/actualdate.fp7 were actualdate:=DDMMYY
I couldn't find any syntax in the script maker. Does anybody
have an
idea?

You don't specify whether you are using FM7 or FM8. There is no
way to do it in FM7 without either a plug-in, a DOS 'rename'
command or an Applescript.

In FM8, you can set a variable with the full path and file name,
and then use that variable name within the scripted export dialog.

I guessed that "...actualdate.fp7" implies FileMaker 7, but that
could easily be wrong. )

Which leads to another point, the exported file should not be called
".fp7", but will be ".txt" if a standard tab-seperated text file and
there are other filename extensions for the other filetypes
FileMaker can export.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork
hardships ;o)


--



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.