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

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

Save As PDF Script Step in FMPro Advanced 11.0v3

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

Contents

  Save As PDF Script Step in FMPro Advanced 11.0v3 JayBee <Jennifer_Beecroft@hotmail.com> - 2014-01-29 07:36 -0800
    Re: Save As PDF Script Step in FMPro Advanced 11.0v3 Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2014-01-29 08:48 -0800
      Re: Save As PDF Script Step in FMPro Advanced 11.0v3 JayBee <Jennifer_Beecroft@hotmail.com> - 2014-01-30 00:34 -0800
        Re: Save As PDF Script Step in FMPro Advanced 11.0v3 clkaufmann@gmx.ch (Christoph Kaufmann) - 2014-01-30 10:11 +0100
        Re: Save As PDF Script Step in FMPro Advanced 11.0v3 Erik Appeldoorn <ursus.kirk@gmail.com> - 2014-01-30 10:45 +0100
    Re: Save As PDF Script Step in FMPro Advanced 11.0v3 JayBee <Jennifer_Beecroft@hotmail.com> - 2014-01-30 02:19 -0800
      Re: Save As PDF Script Step in FMPro Advanced 11.0v3 Erik Appeldoorn <ursus.kirk@gmail.com> - 2014-01-30 11:58 +0100
        Re: Save As PDF Script Step in FMPro Advanced 11.0v3 JayBee <Jennifer_Beecroft@hotmail.com> - 2014-01-30 08:47 -0800
          Re: Save As PDF Script Step in FMPro Advanced 11.0v3 Erik Appeldoorn <ursus.kirk@gmail.com> - 2014-01-31 11:09 +0100
            Re: Save As PDF Script Step in FMPro Advanced 11.0v3 Erik Appeldoorn <ursus.kirk@gmail.com> - 2014-01-31 11:18 +0100
              Re: Save As PDF Script Step in FMPro Advanced 11.0v3 JayBee <Jennifer_Beecroft@hotmail.com> - 2014-02-11 04:55 -0800
                Re: Save As PDF Script Step in FMPro Advanced 11.0v3 Erik Appeldoorn <ursus.kirk@gmail.com> - 2014-02-11 15:21 +0100
      Re: Save As PDF Script Step in FMPro Advanced 11.0v3 clkaufmann@gmx.ch (Christoph Kaufmann) - 2014-01-30 12:10 +0100

#1683 — Save As PDF Script Step in FMPro Advanced 11.0v3

Hello
Trying to save a recrod as a pdf to one of the shared folders on our server machine.  Filename is a variable.

System is windows:

I have defined my variable with name: $filename in a preceding scriptstep as follows:
"freetext"&TableName::Field Name&"freetext"&Get ( CurrentTimeStamp )

Path I have used is: filewin://SERVERNAME/FolderName/$filename

Error message we get is:
"filename" could not be created on this idsk.  Use a different name, make more room on the disk, unlock it or use a different disk."

The network administrator informs me that this volume is fully accessible and read writable so shouldn't be an issue there.

We can't work out how to make it work / why we are getting this error message..

Any Help?

Thanks

[toc] | [next] | [standalone]

#1684

On 1/29/2014 7:36 AM, JayBee wrote:
> Hello
> Trying to save a recrod as a pdf to one of the shared folders on our server machine.  Filename is a variable.
>
> System is windows:
>
> I have defined my variable with name: $filename in a preceding scriptstep as follows:
> "freetext"&TableName::Field Name&"freetext"&Get ( CurrentTimeStamp )
>
> Path I have used is: filewin://SERVERNAME/FolderName/$filename
>
> Error message we get is:
> "filename" could not be created on this idsk.  Use a different name, make more room on the disk, unlock it or use a different disk."
>
> The network administrator informs me that this volume is fully accessible and read writable so shouldn't be an issue there.

If you are using a variable for the filename or path, the Save/Export 
dialog can only include the protocol (i.e. file: or filewin:) and the 
variable name. (The protocol can be either entered directly in this 
dialog or can instead be part of your variable's value.)

If you are trying to use "filewin://SERVERNAME/FolderName/$filename" in 
the save/export window, then it will literally try to save a file named 
"$filename", which is probably an illegal name with the dollar sign.

You should instead set a variable named $filepath and set it to the full 
path and file name:

"filewin://SERVERNAME/FolderName/" & $filename

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

#1686

Thanks Howard

I've done that, so I've now defined two variables in preceding script steps as follows:

$filename = TableName::FieldName & Get ( CurrentTimeStamp )
$filepath = "filewin://servername/foldername/" & $filename

In the output file path dialog box of the save records as pdf I have simply typed:
$filepath

Unfortunately, I still get the same error message: "filename" could not be created on this disk.  Use a different name, make more room on the disk, unlock it or use a different disk."

I hope we can be helped further!

:-)

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

#1687

JayBee <Jennifer_Beecroft@hotmail.com> wrote:

> Unfortunately, I still get the same error message: "filename" could not
> be created on this disk.  Use a different name, make more room on the
> disk, unlock it or use a different disk."

Export a a record in the filemaker format to the destination folder.
First thing you find out here is whether or not you have write
permissions there.

Second, open the export file and use the get ( filepath ) function to
see how the path needs to be phrased.
-- 
Christoph Kaufmann
http://clk.ch

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

#1688

JayBee schreef op 30-1-2014 9:34:
> Thanks Howard
>
> I've done that, so I've now defined two variables in preceding script steps as follows:
>
> $filename = TableName::FieldName & Get ( CurrentTimeStamp )
> $filepath = "filewin://servername/foldername/" & $filename
>
> In the output file path dialog box of the save records as pdf I have simply typed:
> $filepath
>
> Unfortunately, I still get the same error message: "filename" could not be created on this disk.  Use a different name, make more room on the disk, unlock it or use a different disk."
>
> I hope we can be helped further!
>
> :-)
>

The timestamp can create all kind of problems because it contains spaces 
and colons (:).

Because of the spaces you might need the filepath contained by parenthis 
("\"filewin://.../.../" & $filename & "\"")

And because : are part of prohibited signs, they need to be avoided (or 
replaced)

-- 
met vriendelijke groeten,
Erik Appeldoorn

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

#1690

Awesome.  Great Plan Christoph.  That worked a treat!  I can manage to save a file there as a pdf.  Now I just need to to work out how to still get the time stamp in the filename, by removing or replacing the colons..... Is this possible Erik?

Thanks All

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

#1691

JayBee schreef op 30-1-2014 11:19:
> Awesome.  Great Plan Christoph.  That worked a treat!  I can manage to save a file there as a pdf.  Now I just need to to work out how to still get the time stamp in the filename, by removing or replacing the colons..... Is this possible Erik?
>
> Thanks All
>

Ofcourse, timestamp is simply text and any text can be manipulated as 
you like. you can just remove the : or substitute them with -.

To remove them

$MyTimestamp =
substitute (
timestamp ( get (currentdate) ; get (currenttime) ) ;
":" ; "" )

untested, but should work

-- 
met vriendelijke groeten,
Erik Appeldoorn

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

#1695

ok, so I have set a variable with the following name: $mytimestamp specified as follows:

Substitute (Timestamp ( Get (CurrentDate) ; Get (CurrentTime) ) ;":" ; "-" )

However if I then use that variable within my $filename variable as follows:

"EstimateSent_" & Works::Job No.&$mytimestamp&"_.pdf"

It goes back to the same error message about using a different filename or using a different disk etc.

?!

Have I done something wrong?!

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

#1696

JayBee schreef op 30-1-2014 17:47:
> ok, so I have set a variable with the following name: $mytimestamp specified as follows:
>
> Substitute (Timestamp ( Get (CurrentDate) ; Get (CurrentTime) ) ;":" ; "-" )
>
> However if I then use that variable within my $filename variable as follows:
>
> "EstimateSent_" & Works::Job No.&$mytimestamp&"_.pdf"
>
> It goes back to the same error message about using a different filename or using a different disk etc.
>
> ?!
>
> Have I done something wrong?!
>

what is the exact contents of Works::Job No.
To be usefull as (part of) a filename this should also not contain any 
strange characters (?!~*&:@) but only stripped alpha numeric (ab...yz, 
AB ... YZ, 12...90

First try to export to the local disk. Does that work?
This a very tricky thing to debug without being on site.
Any number of glitches within the network might cause the problem. I 
have found filemaker to be very unforgiving. If all fails you could 
export to a local disk. Then use folder actions (a freeware software for 
windows) to copy the file across the network. [http://www.folderactions.com]

-- 
met vriendelijke groeten,
Erik Appeldoorn

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

#1697

Erik Appeldoorn schreef op 31-1-2014 11:09:

> [http://www.folderactions.com]
>
Sorry this is not free. Watch 4 Folder is.

-- 
met vriendelijke groeten,
Erik Appeldoorn

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

#1714

On Friday, January 31, 2014 10:18:31 AM UTC, Erik Appeldoorn wrote:
> Erik Appeldoorn schreef op 31-1-2014 11:09:
> 
> 
> 
> > [http://www.folderactions.com]
> 
> >
> 
> Sorry this is not free. Watch 4 Folder is.
> 
> 
> 
> -- 
> 
> met vriendelijke groeten,
> 
> Erik Appeldoorn

Thanks.  I figured this out.  I had to, of course, replace the forward slashes as well as the colons.  If anyhting more important as forward slashes very important in filepaths.. I couldn't really keep it as part of the filename.  I replaced them all with hyphens or underscores.  Just didn't have time to post back until now.

Thanks.

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

#1715

JayBee schreef op 11-2-2014 13:55:

>> Erik Appeldoorn
>
> Thanks.  I figured this out.  I had to, of course, replace the forward slashes as well as the colons.  If anyhting more important as forward slashes very important in filepaths.. I couldn't really keep it as part of the filename.  I replaced them all with hyphens or underscores.  Just didn't have time to post back until now.
>
> Thanks.
>

Well glad you figured it out.

-- 
met vriendelijke groeten,
Erik Appeldoorn

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

#1692

JayBee <Jennifer_Beecroft@hotmail.com> wrote:

> Now I just need to to work out how to still get the time stamp in the
> filename, by removing or replacing the colons

I don't bother with the timestamp function since I reformat the
information anyway. Here's my expression for the filepath:

Let ( [

verzeichnis = GLOBAL::PfadEntwicklersicherung_g ; // Text field with the
destination folder's path datei = Get ( FileName ) & "_" ; jahr = Year (
Get ( CurrentDate ) ) ; monat = Right ( "00" & Month ( Get ( CurrentDate
) ) ; 2 ) ; tag = Right ( "00" & Day ( Get ( CurrentDate ) ) ; 2 ) ;
datum = jahr & monat & tag ; Stunde = Right ( "00" & Hour ( Get (
CurrentTime ) ) ; 2 ) ; Minute = Right ( "00" & Minute ( Get (
CurrentTime ) ) ; 2 ) ] ; verzeichnis & datei & datum & "_" & Stunde &
Minute & "h" & GLOBAL::Dateierweiterung_g )

The global text field GLOBAL::Dateierweiterung_g simply contains ".fp7"
or ".fmp12"

The resulting file name looks like this:

FileName_20140130_1125h.fp7

-- 
Christoph Kaufmann
http://clk.ch

[toc] | [prev] | [standalone]

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

csiph-web