Dynamic Delivery File Naming

Three folks have asked me about this just today. They wanted to create file names for FTP, Email or WebDAV that have some dynamic component to them e.g. TIM1212009.pdf where the numeric values relate to the date.

Well I learned something today, its supported on the standalone server. Its not that Leslie had not documented it; its just, its tucked away in the API documentation.

You can use the date expressions for a couple of properties. Those expressions will be translated with the actual values just before the delivery. Available expression are following.


  • %y : 4 digit year (ex, 1972, 2005)
  • %m : 2 digit month (00 - 12)
  • %d : 2 digit date (00 - 31)
  • %H : 24h based 2 digit hour (00 - 24)
  • %M : 2 digit minute (00 - 59)
  • %S : 2 digit sec (00 - 59)
  • %l : 3 digit millisec (000 - 999)

For example, if you specify my_file_%y%m%d.txt for the filename, the actual filename will be 'my_file_20051108.txt'.

Update

During some testing we have found that the following statement is not quite true. If you use unsupported expressions such as %a%b%b.pdf you file will arrive on the destination server as defined ie %a%b%b.pdf.

All undefined expressions will be translated into 0 length string, for example, if you specify my_file_%a%b%c.txt, it will be my_file_.txt. You can escape the '%' letter by passing '%%'.

The properties that support the date expressions are as follows.

  • E Mail file attachment
  • FTP Filename
  • WebDAV filename

This can be set either in the standalone scheduling page or when using the delivery APIs.

Comments:

Do these also work in the bursting control file for EBS?

Posted by Graham Hewett on December 03, 2009 at 10:23 PM MST #

How do i configure the attachment name on the standalone version when using burting? Thanks and congratulations on the great blog!

Posted by Ygor on December 22, 2009 at 08:21 AM MST #

I follow your blog regularly. I have learnt a lot. Great work. We are on R12.1 EBS. Can I set the file read and write permission for the files using bursting control file? If not, how does the file generated by bursting gets its permission in unix? Is it based on umask of the unix user?

Posted by Ganesh Sudhakar on January 07, 2010 at 05:13 AM MST #

Ah, thanks! This settled up some confusion I'd heard.

Posted by Tax Attorney Atlanta on February 08, 2010 at 06:40 AM MST #

Hi, How can we have dynamic content file as an attachment.The content of the file will be available in BlobDomain and we have to convert it to a stream and then using delivery manager we need to send an email with attachment. Regards Sudhakar

Posted by Sudhakar on August 09, 2010 at 07:56 AM MDT #

I tried sending email attachement with data appened but haven't got any result, It just gets me back what ever name i give.

Posted by sri on September 03, 2010 at 02:48 AM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today