Schedule to File Location

system · July 16, 2010, 7:20pm

Hi All,

I would like to schedule a Deski report to a file location.
What steps that I should follow in the Destination job server to have the report scheduled in the File location.

Also, how the path should be in the Direcroty on the Infoview when scheduling?
Thanks…

JohnJustus (BOB member since 2007-06-25)

system · July 19, 2010, 4:57am

Hi John,

I’ve just set this up and got it working.

You’ll need to setup each Job server that you are using based it application, eg Webi, Deski, Crystal.

The file path that you put in there really is irrelevant as its what you put in the actual scheduled object that will be used.
If the folder where the file is being sent is on the same server, then you can simply specify its drive letter.
If however its a network drive, you will have to put the full DNS name in the path of the file name. You’ll also need to make sure that the user you are using to run your BO application has access to that file path.
If it doesn’t, then you’ll need to change all the servers in the CMC to use a valid network account and then restart the CMS.

plessiusa (BOB member since 2004-03-22)

system · July 22, 2010, 9:36am

The Job server has to have the File location enabled .
GO to CMC-> Job server- > Destination -> Choose File System -> and ADD.

The rest where to send each file depends on what you give while scheduling.

arunmozhi (BOB member since 2007-12-26)

system · July 22, 2010, 6:51pm

Thanks everyone for the replies.
If I go to the Destination job server, there are 4 options : Business Objects Inbox, File System, FTP Server, Email.

I selected File System ->ADD. Should I need to specify any parameters for Directory, File Name:?

In the Destination, currently nothing has been configured for Business Objects Inbox, then how come I am able to schedule reports to Inbox?

My doubt is, Is configuration required on the Destination Job server?

Thanks…

JohnJustus (BOB member since 2007-06-25)

system · July 22, 2010, 8:46pm

Hi John,

No you don’t have to put anything in the destinations for the file system. These are the defaults that would be used if you don’t remove the tick in the Use Defaults check box in the scheduling screen.

plessiusa (BOB member since 2004-03-22)

system · July 23, 2010, 1:16pm

Thanks for the information,
Say we have a shared network drive as follows,

‘just’ on ‘ad\root\a\am\users’(P: )

The above is my shared driver where I can keep my documents.
How do I specify that on the Directory parameter? Also, what is the user name and password parameter?
Thanks…

JohnJustus (BOB member since 2007-06-25)

system · July 23, 2010, 8:48pm

Hi John,

You need to use the full DNS name of the server, so instead of say P:… Which is what you have it resolved as, you would say \servername\directory structure

With regards to the userid and password you use, if you have your BO server logging onto the network using a network administrator account rather than local admin account, you won’t/shouldn’t need any special logon details so these can be left blank.

plessiusa (BOB member since 2004-03-22)

system · July 26, 2010, 4:18pm

I setup Unmanaged Disk in CMC, and I scheduled a Deski report in Infoview by giving the necessary arguments, but it gives the error as below,

destination file error. CrystalEnterprise.DiskUnmanaged: Access is denied.

I can manually write files to the given destination.

Thanks…

JohnJustus (BOB member since 2007-06-25)

system · July 26, 2010, 8:37pm

I understand that you can write that the file location, but you have to make sure that the logon being used by Business Objects can.

Typically BO uses local host to logon, this does not give it access to Network drives, so to get around this, you need to edit each of the destination servers and the CMC to use a valid network user id. Your choice is to either use the network administrator account (if your allowed) or to get your network guys to create a BO network logon and then use that.

Once you’ve added, restart the SIA and it should then be allowed access to your network drives.

plessiusa (BOB member since 2004-03-22)

system · July 26, 2010, 9:00pm

Thanks for the valuable information.
In other words, if we give the BO Logon ID the access to the network drive then it should be all set correct?
Thanks…

JohnJustus (BOB member since 2007-06-25)

system · July 26, 2010, 10:55pm

Thats pretty much, create a genuine network logon for BO, change the individual BO servers to use that logon and yes it should work.

plessiusa (BOB member since 2004-03-22)

system · July 29, 2010, 3:29pm

Is it possible to customize the Placeholder when scheduling from Infoview?
If I select DateTime, the Starttime will embed with the reportname, for instance the parameter will look like this,

Weekly_Report%SI_STARTTIME%

The result is Weekly_Report 2010-07-29-10-58-23

Is it possible to remove the time (10-58-23) and removing the dash between Date and time ,kind of customization.

Thanks…

JohnJustus (BOB member since 2007-06-25)

system · July 29, 2010, 8:16pm

That I am afraid John I don’t know.

plessiusa (BOB member since 2004-03-22)

system · October 14, 2010, 11:03pm

I am having trouble when the folder name contains spaces or characters like ‘-’. Can the reports be published only to locations that do not contain spaces or special characters? Or is there a way to code the path (similar to URLEncode) to publish to any folder?

Thanks in advance.

Sujata (BOB member since 2006-09-12)

system · October 14, 2010, 11:35pm

Not sure sorry, when I did this, I created a custom folder in the structure that I wanted and this worked really well. So I’m guessing that if you are having issues with special characters, then I would have to assume that you may not be able to do this.

Though I have been proven wrong in the past.

plessiusa (BOB member since 2004-03-22)