X

An Oracle blog about BI Publisher

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.

Join the discussion

Comments ( 8 )
  • Graham Hewett Friday, December 4, 2009
    Do these also work in the bursting control file for EBS?
  • Ygor Tuesday, December 22, 2009
    How do i configure the attachment name on the standalone version when using burting?
    Thanks and congratulations on the great blog!
  • Ganesh Sudhakar Thursday, January 7, 2010
    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?
  • Tax Attorney Atlanta Monday, February 8, 2010
    Ah, thanks! This settled up some confusion I'd heard.
  • Sudhakar Monday, August 9, 2010
    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
  • sri Friday, September 3, 2010
    I tried sending email attachement with data appened but haven't got any result, It just gets me back what ever name i give.
  • Dinesh Monday, March 13, 2017

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


  • guest Wednesday, March 15, 2017

    Hi Tim,

    Can I use a repository variable which stores a date value and use the same in the name of the burs-ted file ?

    Regards,

    Athul Jayachandran


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.