Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #1677 > unrolled thread

Need Help - Current Date in the File Name when export

Back to article view | Back to comp.databases.filemaker

Contents

  Need Help - Current Date in the File Name when export Tom E <tevanoff65@gmail.com> - 2014-01-28 09:32 -0800
    Re: Need Help - Current Date in the File Name when export clkaufmann@gmx.ch (Christoph Kaufmann) - 2014-01-28 20:12 +0100
    Re: Need Help - Current Date in the File Name when export Tom E <tevanoff65@gmail.com> - 2014-01-28 13:47 -0800
      Re: Need Help - Current Date in the File Name when export Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2014-01-28 14:50 -0800
        Re: Need Help - Current Date in the File Name when export Helpful Harry <HelpfulHarry@BusyWorking.com> - 2014-01-29 13:08 +1300
          Re: Need Help - Current Date in the File Name when export Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2014-01-28 20:18 -0800
    Re: Need Help - Current Date in the File Name when export Tom E <tevanoff65@gmail.com> - 2014-01-29 10:25 -0800
      Re: Need Help - Current Date in the File Name when export JayBee <Jennifer_Beecroft@hotmail.com> - 2014-01-30 02:02 -0800
    Re: Need Help - Current Date in the File Name when export Tom E <tevanoff65@gmail.com> - 2014-03-05 18:44 -0800
      Re: Need Help - Current Date in the File Name when export Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2014-03-05 20:47 -0800
    Re: Need Help - Current Date in the File Name when export Tom E <tevanoff65@gmail.com> - 2014-03-06 10:30 -0800
      Re: Need Help - Current Date in the File Name when export Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2014-03-06 10:49 -0800
    Re: Need Help - Current Date in the File Name when export Tom E <tevanoff65@gmail.com> - 2014-03-06 10:44 -0800
    Re: Need Help - Current Date in the File Name when export Tom E <tevanoff65@gmail.com> - 2014-03-06 10:47 -0800
    Re: Need Help - Current Date in the File Name when export Tom E <tevanoff65@gmail.com> - 2014-03-06 11:17 -0800
      Re: Need Help - Current Date in the File Name when export Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2014-03-06 12:49 -0800
    Re: Need Help - Current Date in the File Name when export Tom E <tevanoff65@gmail.com> - 2014-03-06 11:28 -0800
    Re: Need Help - Current Date in the File Name when export jesusruiz@macfix.mobi - 2016-05-23 21:30 -0700

#1677 — Need Help - Current Date in the File Name when export

Version FM12 

Still having issues creating a script that puts the current date in a file name. The current script I have saves the export to a PDF.  When you specify the output file name in Specify Output File I don't see any other options?

Any help would be greatly appreciated!  

[toc] | [next] | [standalone]

#1678

Tom E <tevanoff65@gmail.com> wrote:

> Version FM12
> 
> Still having issues creating a script that puts the current date in a
> file name. The current script I have saves the export to a PDF. When you
> specify the output file name in Specify Output File I don't see any
> other options?

set a variable $path (or whatever) for the full file path and put it in
the Specify Output file dialogue.

-- 
Christoph Kaufmann
http://clk.ch

[toc] | [prev] | [next] | [standalone]

#1679

I see the output to put the file name in the Specify Output box - but not sure how to script the current date to each file that I export?

On Tuesday, January 28, 2014 12:32:40 PM UTC-5, Tom E wrote:
> Version FM12 
> 
> 
> 
> Still having issues creating a script that puts the current date in a file name. The current script I have saves the export to a PDF.  When you specify the output file name in Specify Output File I don't see any other options?
> 
> 
> 
> Any help would be greatly appreciated!

[toc] | [prev] | [next] | [standalone]

#1680

On 1/28/2014 1:47 PM, Tom E wrote:
> I see the output to put the file name in the Specify Output box - but not sure how to script the current date to each file that I export?
>
> On Tuesday, January 28, 2014 12:32:40 PM UTC-5, Tom E wrote:
>> Version FM12
>>
>>
>>
>> Still having issues creating a script that puts the current date in a file name. The current script I have saves the export to a PDF.  When you specify the output file name in Specify Output File I don't see any other options?


Set Variable [ $filePath ;
    get(desktopPath) & "MyFile_" &
    Let( dt = get(currentdate);
       year(x) &
       right("00" & month(x); 2) &
       right("00" & day(x); 2)
    ) & ".ext"
]

Save as PDF [ $filePath ]

[toc] | [prev] | [next] | [standalone]

#1681

In article <lc9c8a$ean$3@news.motzarella.org>, Howard Schlossberg
<howard@nospam.fmprosolutions.com> wrote:

> On 1/28/2014 1:47 PM, Tom E wrote:
> > I see the output to put the file name in the Specify Output box - but not
> > sure how to script the current date to each file that I export?
> >
> > On Tuesday, January 28, 2014 12:32:40 PM UTC-5, Tom E wrote:
> >> Version FM12
> >>
> >>
> >>
> >> Still having issues creating a script that puts the current date in a file
> >> name. The current script I have saves the export to a PDF.  When you
> >> specify the output file name in Specify Output File I don't see any other
> >> options?
> 
> 
> Set Variable [ $filePath ;
>     get(desktopPath) & "MyFile_" &
>     Let( dt = get(currentdate);
>        year(x) &
>        right("00" & month(x); 2) &
>        right("00" & day(x); 2)
>     ) & ".ext"
> ]
> 
> Save as PDF [ $filePath ]

I haven't used the Let function, so I'm not sure, but is there a typo
there? Should the "x" in the three date functions be "dt"?

Helpful Harry   :o)

[toc] | [prev] | [next] | [standalone]

#1682

On 1/28/2014 4:08 PM, Helpful Harry wrote:
> In article <lc9c8a$ean$3@news.motzarella.org>, Howard Schlossberg
> <howard@nospam.fmprosolutions.com> wrote:
>
>> On 1/28/2014 1:47 PM, Tom E wrote:
>>> I see the output to put the file name in the Specify Output box - but not
>>> sure how to script the current date to each file that I export?
>>>
>>> On Tuesday, January 28, 2014 12:32:40 PM UTC-5, Tom E wrote:
>>>> Version FM12
>>>>
>>>>
>>>>
>>>> Still having issues creating a script that puts the current date in a file
>>>> name. The current script I have saves the export to a PDF.  When you
>>>> specify the output file name in Specify Output File I don't see any other
>>>> options?
>>
>>
>> Set Variable [ $filePath ;
>>      get(desktopPath) & "MyFile_" &
>>      Let( dt = get(currentdate);
>>         year(x) &
>>         right("00" & month(x); 2) &
>>         right("00" & day(x); 2)
>>      ) & ".ext"
>> ]
>>
>> Save as PDF [ $filePath ]
>
> I haven't used the Let function, so I'm not sure, but is there a typo
> there? Should the "x" in the three date functions be "dt"?
>
> Helpful Harry   :o)
>

Oops, yes.  Thanks for catching that, Harry.  I usually use the 'x' when 
there is only one variable in my Let() calcs, but I started out writing 
it today with 'dt' for clarification.  Turned out to be less clarifying 
then intended.  I also should have included FileMaker's file "protocol" 
(filewin or filemac) for purposes of the export path.  It should be:

Set Variable [ $filePath ;
     "filewin:" & get(desktopPath) & "MyFile_" &
     Let( dt = get(currentdate);
        year(dt) &
        right("00" & month(dt); 2) &
        right("00" & day(dt); 2)
     ) & ".ext"
]



And the result of that, if run right now on my Windows machine, would be:
	filewin:/C:/Users/Howard/Desktop/MyFile_20140128.ext

[toc] | [prev] | [next] | [standalone]

#1685

Howard, Harry

Thanks for your help! Sorry for all the questions I'm new to this...do I put this script in the Specify Output File box of the script Save Records as PDF? Do you know of any example files I can look at?

Thanks!
Tom 

On Tuesday, January 28, 2014 12:32:40 PM UTC-5, Tom E wrote:
> Version FM12 
> 
> 
> 
> Still having issues creating a script that puts the current date in a file name. The current script I have saves the export to a PDF.  When you specify the output file name in Specify Output File I don't see any other options?
> 
> 
> 
> Any help would be greatly appreciated!

[toc] | [prev] | [next] | [standalone]

#1689

.do I put this script in the Specify Output File box of the script Save Records as PDF? Do you know of any example files I can look at?

Hi Tom

Use the script step 'set variable'.  Give it whichever name you want but make sure that it is preceded by a '$' sign to make sure it can be referenced from within the script! e.g. $filepath.

Put the calc from Howard/Harry in the specify value part of your variable dialog box, clicking specify will bring up a dialog box for you to enter the calculaiton.

Then in your save records as pdf dialog for output file you should just need to type: $filepath or whatever you called your variable... Just don't forget to precede it with a '$' character.

HTH

[toc] | [prev] | [next] | [standalone]

#1741

On Tuesday, January 28, 2014 12:32:40 PM UTC-5, Tom E wrote:
> Version FM12 
> 
> 
> 
> Still having issues creating a script that puts the current date in a file name. The current script I have saves the export to a PDF.  When you specify the output file name in Specify Output File I don't see any other options?
> 
> 
> 
> Any help would be greatly appreciated!

I have tried & tried - I must be missing something? 

Set Variable:

Name: $TechHolds

Value: 

"filewin:" & Get(DesktopPath) & "$TechHolds_" & 
     Let( dt = Get(CurrentDate); 
        Year(dt) & 
        Right("00" & Month(dt); 2) & 
        Right("00" & Day(dt); 2) 
     ) & ".ext"


Save Records as PDF:
Output File: file:TelePresence/Holds/$TechHolds_.pdf

[toc] | [prev] | [next] | [standalone]

#1742

On 3/5/2014 6:44 PM, Tom E wrote:
> Set Variable:
>
> Name: $TechHolds
>
> Value:
>
> "filewin:" & Get(DesktopPath) & "$TechHolds_" &
>       Let( dt = Get(CurrentDate);
>          Year(dt) &
>          Right("00" & Month(dt); 2) &
>          Right("00" & Day(dt); 2)
>       ) & ".ext"
>
>
> Save Records as PDF:
> Output File: file:TelePresence/Holds/$TechHolds_.pdf

Two things:
1) Since you are setting $TechHolds to include the full path, you don't 
want to set the output to be a partial path plus the full path.
2) In your Save Records as PDF step, you should just enter the variable 
name as your path.  Nothing more, nothing less, since the variable 
already has the full path.

[toc] | [prev] | [next] | [standalone]

#1743

Thanks Howard for your patience! I now see a file with current date at the end. It pushes the file to the desktop since I just use the Variable in the  
Save Records as PDF. If I want to push it to a folder do I need to change something in the script below?  

"filewin:" & Get(DesktopPath) & "TechHolds_" & 
     Let( dt = Get(CurrentDate); 
        Year(dt) & 
        Right("00" & Month(dt); 2) & 
        Right("00" & Day(dt); 2) 
     ) & ".ext"




On Tuesday, January 28, 2014 12:32:40 PM UTC-5, Tom E wrote:
> Version FM12 
> 
> 
> 
> Still having issues creating a script that puts the current date in a file name. The current script I have saves the export to a PDF.  When you specify the output file name in Specify Output File I don't see any other options?
> 
> 
> 
> Any help would be greatly appreciated!

[toc] | [prev] | [next] | [standalone]

#1746

You need to change the variable, as that is where your path is.

Something like this perhaps:

"filewin:" & Get(DesktopPath) & "TelePresence/Holds/TechHolds_" &
      Let( dt = Get(CurrentDate);
         Year(dt) &
         Right("00" & Month(dt); 2) &
         Right("00" & Day(dt); 2)
      ) & ".pdf"

That will save a file today called "TechHolds_20140306.pdf" to
your desktop/TelePresence/Holds/ folder.


On 3/6/2014 10:30 AM, Tom E wrote:
> Thanks Howard for your patience! I now see a file with current date at the end. It pushes the file to the desktop since I just use the Variable in the
> Save Records as PDF. If I want to push it to a folder do I need to change something in the script below?
>
> "filewin:" & Get(DesktopPath) & "TechHolds_" &
>       Let( dt = Get(CurrentDate);
>          Year(dt) &
>          Right("00" & Month(dt); 2) &
>          Right("00" & Day(dt); 2)
>       ) & ".ext"
>
>
>
>
> On Tuesday, January 28, 2014 12:32:40 PM UTC-5, Tom E wrote:
>> Version FM12
>>
>>
>>
>> Still having issues creating a script that puts the current date in a file name. The current script I have saves the export to a PDF.  When you specify the output file name in Specify Output File I don't see any other options?
>>
>>
>>
>> Any help would be greatly appreciated!
>

[toc] | [prev] | [next] | [standalone]

#1744

> Still having issues creating a script that puts the current date in a file name. The current script I have saves the export to a PDF.  When you specify the output file name in Specify Output File I don't see any other options?
> 
> 
> 
> Any help would be greatly appreciated!

[toc] | [prev] | [next] | [standalone]

#1745

Thanks Howard for your patience! I now see a file with current date at the end. It pushes the file to the desktop since I just use the Variable in the   
Save Records as PDF. If I want to push it to a folder do I need to change something in the script below?   

"filewin:" & Get(DesktopPath) & "TechHolds_" & 

     Let( dt = Get(CurrentDate); 
        Year(dt) & 
        Right("00" & Month(dt); 2) & 
        Right("00" & Day(dt); 2) 
     ) & ".ext" 





> Still having issues creating a script that puts the current date in a file name. The current script I have saves the export to a PDF.  When you specify the output file name in Specify Output File I don't see any other options?
> 
> 
> 
> Any help would be greatly appreciated!

[toc] | [prev] | [next] | [standalone]

#1747

One other thing I have noticed when it pushes the file name it puts .ext (hidden)  at the end of the filename? 

[toc] | [prev] | [next] | [standalone]

#1749

That's because you had .ext in your variable path/file name.  In my last 
post, I changed it to .pdf

On 3/6/2014 11:17 AM, Tom E wrote:
> One other thing I have noticed when it pushes the file name it puts .ext (hidden)  at the end of the filename?
>

[toc] | [prev] | [next] | [standalone]

#1748

Got it! Thank you!

[toc] | [prev] | [next] | [standalone]

#2648

El martes, 28 de enero de 2014, 11:32:40 (UTC-6), Tom E escribió:
> Version FM12 
> 
> Still having issues creating a script that puts the current date in a file name. The current script I have saves the export to a PDF.  When you specify the output file name in Specify Output File I don't see any other options?
> 
> Any help would be greatly appreciated!

Funciono para mi, (works for me) saludos

Set Variable [ $Date ; Value: Substitute ( Get ( CurrentDate ) ; "/" ; "_" ) ]

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.filemaker

csiph-web