AnsweredAssumed Answered

PDF Export with file name according to serial number

Question asked by PatrickHolzer on Feb 8, 2011
Latest reply on Feb 9, 2011 by Sorbsbuster

Like • Show 0 Likes0
Comment • 6

Title

Post

Hi,

I have orders in my database that are continously and automatically numbered for unique identification (this field is called order ID).

I'd like to be able to create a script that allows me to:

go to a specific export layout so that the PDF looks accordingly
export the layout as PDF file
save the exported PDF where its file name is the order ID, for example: "12500.pdf" where 12500 would be the order ID
return to the layout where I initiated the script (called "Browse Orders")

I haven't figured out how to get the saving of the file done according to its order ID.

Thank you!

No one else has this question

Outcomes

philmodjunk Feb 8, 2011 10:46 AM

Adapting from a script where I save a PDF...

Set Variable [$Path ; Value: "file:" & Get ( DesktopPath ) & yourTable::OrderID & ".PDF" ]
Save Records as PDF [Restore; No dialog ; $Path ; ... //specify options appropriate to your needs]

This saves the PDF to your desktop. If you want it saved to a different location, you'll need to specify the path to that location in place of Get ( DesktopPath ).

Actions

PatrickHolzer Feb 9, 2011 2:25 AM

Unfortunately, I didn't quite make it work. Below a screen shot showing my script. Any advice? Thanks!

Actions

philmodjunk Feb 9, 2011 8:31 AM

That looks exactly correct. The syntax perfectly matches the script where I have this working.

What happens if you enable the automatic open option so that the saved PDF automatically opens?

Actions

Sorbsbuster Feb 9, 2011 9:05 AM

Phil - does it not need to be filemac: in front of that? When I show a custom dialogue with just Get (DesktopPath ) I get /C:/Documents and setting etc. The relative path syntax quoted doesn't include the leading /. The other syntaxeses-es do have the leading slash, but they are filewin: or filemac:

But you've got a script with it working, and nothing beats that!

Actions

philmodjunk Feb 9, 2011 9:11 AM

It's something I and another forum poster discovered a while back when we were discussing this very same issue. By using File: instead of FileMac or FileWin, you get a path that is cross platform compatible and is much simpler than adding a complex expression to check platforms before setting a platform specific path.

Actions

Sorbsbuster Feb 9, 2011 9:44 AM

Huh! That'll teach me to read the destructions...

Actions

6 Replies

philmodjunk Feb 8, 2011 10:46 AM
Mark Correct
Correct Answer
Adapting from a script where I save a PDF...

Set Variable [$Path ; Value: "file:" & Get ( DesktopPath ) & yourTable::OrderID & ".PDF" ]
Save Records as PDF [Restore; No dialog ; $Path ; ... //specify options appropriate to your needs]

This saves the PDF to your desktop. If you want it saved to a different location, you'll need to specify the path to that location in place of Get ( DesktopPath ).
Like • Show 0 Likes0
Actions
PatrickHolzer Feb 9, 2011 2:25 AM
Mark Correct
Correct Answer
Unfortunately, I didn't quite make it work. Below a screen shot showing my script. Any advice? Thanks!
Like • Show 0 Likes0
Actions
philmodjunk Feb 9, 2011 8:31 AM
Mark Correct
Correct Answer
That looks exactly correct. The syntax perfectly matches the script where I have this working.

What happens if you enable the automatic open option so that the saved PDF automatically opens?
Like • Show 0 Likes0
Actions
Sorbsbuster Feb 9, 2011 9:05 AM
Mark Correct
Correct Answer
Phil - does it not need to be filemac: in front of that? When I show a custom dialogue with just Get (DesktopPath ) I get /C:/Documents and setting etc. The relative path syntax quoted doesn't include the leading /. The other syntaxeses-es do have the leading slash, but they are filewin: or filemac:

But you've got a script with it working, and nothing beats that!
Like • Show 0 Likes0
Actions
philmodjunk Feb 9, 2011 9:11 AM
Mark Correct
Correct Answer
It's something I and another forum poster discovered a while back when we were discussing this very same issue. By using File: instead of FileMac or FileWin, you get a path that is cross platform compatible and is much simpler than adding a complex expression to check platforms before setting a platform specific path.
Like • Show 0 Likes0
Actions
Sorbsbuster Feb 9, 2011 9:44 AM
Mark Correct
Correct Answer
Huh! That'll teach me to read the destructions...
Like • Show 0 Likes0
Actions

PDF Export with file name according to serial number

Title

Post

Outcomes

Related Content

Recommended Content