![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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? |
#3
| |||
| |||
|
|
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) |
#4
| |||
| |||
|
|
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? |
#5
| |||
| |||
|
|
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. |
)
#6
| |||
| |||
|
|
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. |
#7
| |||
| |||
|
|
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) |
#8
| |||
| |||
|
|
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 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) |
![]() |
| Thread Tools | |
| Display Modes | |
| |