BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Send pdf reportname changes extra id/instance number add?
1 members found this topic helpful
Goto page Previous  1, 2
 
Search this topic... | Search XI Scheduler... | Search Box
Register or Login to Post    Forum Index -> Enterprise Scheduling and Distribution -> XI Scheduler  Previous TopicPrint TopicNext Topic
Author Message
twatson
Forum Member
Forum Member



Joined: 07 Oct 2008

Posts: 19



PostPosted: Mon Mar 15, 2010 11:29 am 
Post subject: Re: Send pdf reportname changes extra id/instance number add

Not sure if this will help, and pretty sure this is not the best answer, but:
-we have a tab in the report that has the distribution list, and how it relates to the data on the other tabs.
-we purge all queries except the query that contains the distribution list.
Perhaps doing one of these will help?
Trish
Back to top
abductee
Principal Member
Principal Member



Joined: 05 Sep 2006

Posts: 103


flag
PostPosted: Fri Aug 13, 2010 8:45 am 
Post subject: Re: Send pdf reportname changes extra id/instance number add

Does anyone know if this has been fixed,

I have same issue, I can get the trick to work by using the username or email address as the file name via dynamic recipients,

but now I want to publish about 300 reports all as xls files without any dynamic recipients, so am stuck with the default placeholders i.e.

Title
ID
Owner
DateTime
Email Address
User Full Name
Document Name
File Extension


Regards

Andy
Back to top
cchaize
Senior Member
Senior Member



Joined: 02 Nov 2005

Posts: 85
Location: LYON


flag
PostPosted: Mon Nov 15, 2010 7:35 am 
Post subject: Re: Send pdf reportname changes extra id/instance number add

Hello dear community,
Does anybody found a solution to make work normally the %SI_DOCUMENT_NAME% in a publication, without the instance number?

ex :
ReportforAccountmanagers.pdf
and not
ReportforAccountmanagers x3A 14439.pdf

Does a XI 3.1 ServicePack solve this issue?

Thanks

_________________
Regards,

Christophe
Back to top
craiggsmith
Principal Member
Principal Member



Joined: 01 Jun 2009

Posts: 267



PostPosted: Mon Nov 15, 2010 2:46 pm 
Post subject: Re: Send pdf reportname changes extra id/instance number add

The %SI_NAME% parameter does not include anything but the name.
Back to top
bdouglas
Forum Addict
Forum Addict



Joined: 29 Aug 2002

Posts: 2841
Location: dayton, OH


flag
PostPosted: Mon Nov 15, 2010 2:56 pm 
Post subject: Re: Send pdf reportname changes extra id/instance number add

I thought some of this issue was in how inboxes work in XI compare to 6.5 and back - before the ID was part of the math, behind the scenes . in XI, you are working with the name and possibly someone else's inbox - you don't have the rights to overwrite their documents. If you don't make a unique name, you get failures in the send.

I usually use NAME-DATE and TIME.... anyone else try this?

Brent
Back to top
craiggsmith
Principal Member
Principal Member



Joined: 01 Jun 2009

Posts: 267



PostPosted: Mon Nov 15, 2010 2:59 pm 
Post subject: Re: Send pdf reportname changes extra id/instance number add

Yes, I've used the NAME and DATE/TIME when I need a unique name, but I wish you could format the DATE/TIME.

Sometimes though I really need to put the data date, not the report run date, in the name. I tried doing this with dynamic recipients but have not yet been able to get it to work.
Back to top
cchaize
Senior Member
Senior Member



Joined: 02 Nov 2005

Posts: 85
Location: LYON


flag
PostPosted: Mon Nov 15, 2010 4:06 pm 
Post subject: Re: Send pdf reportname changes extra id/instance number add

craiggsmith wrote:
The %SI_NAME% parameter does not include anything but the name.


In a simple schedule (not a publication) : Yes - It's the object name, so the document name.

But in a Publication:
%SI_NAME% is the Object name ,so the name of the publication
%SI_DOCUMENT_NAME% is the name of the document in the publication (with the ID at the end).


I'm in BO EDGE 3.1 SP1. I will try to install the SP3.

_________________
Regards,

Christophe
Back to top
craiggsmith
Principal Member
Principal Member



Joined: 01 Jun 2009

Posts: 267



PostPosted: Mon Nov 15, 2010 4:14 pm 
Post subject: Re: Send pdf reportname changes extra id/instance number add

True. I have resorted to always running my reports via a publication. Regular scheduling doesn't have all the options I need.
Back to top
jkanaks
Senior Member
Senior Member



Joined: 08 Jun 2005

Posts: 47
Location: Athens


flag
PostPosted: Wed Dec 08, 2010 9:09 am 
Post subject: Re: Send pdf reportname changes extra id/instance number add

craiggsmith wrote:
Sure. This is probably more than you need but let me recap everything:

My need was to automatically create a monthly report for each country in our database; the output was to be a PDF on a file server, all in the same directory. So I created a publication using the monthly report itself as the basis and created a separate report to pull a list of all the countries. I selected this as the source of the Dynamic Recipients, and I mapped the Country field to the Full Name field (I could have used email as well since I'm not emailing it). In the Personalization screen I just set the Report Field equal to the Country field, and selected the Country field in the Dynamic Recipient dropdown. Then in the Destinations screen I set the file name equal to %SI_USERFULLNAME%.%EXT% plus a few other qualifiers.

I'm having one problem getting the reports to generate correctly though, but I have been told it is a known bug with publications that should be fixed by the end of the month. I'm also having some issues with the report that pulls the list of countries (recipients). It seems this gets corrupted by the publication and I have to reload it to the server. I have yet to look into this.

I hope this helps.


This walkaround will only work for one report per publication. I used a free utility found here http://www.bulkrenameutility.co.uk/Download.php
within a batch file like that
BRC32.exe /DIR:"C:\temp" /NOFOLDERS /PATTERN:"*.PDF" /RECURSIVE /REMOVELASTN:10 /EXECUTE

nethertheless this is a poor solution and i blame SAP for that

_________________
http://biassedintelligence.blogspot.com/
Back to top
madion
Forum Member
Forum Member



Joined: 29 Apr 2010

Posts: 6



PostPosted: Tue Nov 01, 2011 4:14 pm 
Post subject: Re: Send pdf reportname changes extra id/instance number add

Just to let you know that this is still an issue in XI 4.0 SP2 HF6.

I will probably resort to hardcoding the name but thanks everyone for suggestions so far.

I'm going to raise a ticket with SAP for that...
Back to top
SdenAdel
Forum Member
Forum Member



Joined: 13 Dec 2011

Posts: 7
Location: Haarlem


flag
PostPosted: Tue Feb 07, 2012 4:38 am 
Post subject: Re: Send pdf reportname changes extra id/instance number add

I'd the same problem a week ago. As said before, normally you could solve it with using the publication name, or with report bursting and use the email placeholder. But with more reports in one publication, it seems to be impossible.

I made a batch solution:

1. Get rid of the files that already are in the directory:

Code:
@echo off &setlocal enableDelayedExpansion
set LF=^


net use r: /delete
net use r: "[(unc)path to directory]"
r:
del *.* /q
c:
net use r: /delete


2. Run the publication

3. Right trim filename (always 12 characters)

Code:
@echo off &setlocal enableDelayedExpansion
set LF=^


net use r: /delete
net use r: "[(unc)path to directory]"
r:
for %%f in (r:\*.pdf) do (
set "$old.fileName=%%~nf"
set "$new.fileName=!$old.fileName:~0,-12!"
ren "!$old.fileName!.pdf" "!$new.fileName!.pdf")
c:
net use r: /delete


Be sure that there are two blank lines after "set LF=^".

_________________
BI 4 XI 3.x 2.x BO 6.5
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6701
Location: Connecticut, USA


flag
PostPosted: Mon Jun 08, 2020 2:35 pm 
Post subject: Re: Send pdf reportname changes extra id/instance number add

Does anyone know if this was ever resolved? Is it possible to use si_document_name without getting the "x3a" and ID in the name?
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Enterprise Scheduling and Distribution -> XI Scheduler  Previous TopicPrint TopicNext Topic
Page 2 of 2 All times are GMT - 5 Hours
Goto page Previous  1, 2
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0310 seconds using 17 queries. (SQL 0.0029 Parse 0.0009 Other 0.0271)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo