Export Reports using AwareIM data & Displaying same (#3)

tford · Post by **tford** » Thu Jun 25, 2009 8:00 pm

This builds on BSV built in two posts below:

http://www.awareim.com/forum/viewtopic.php?t=3479
http://www.awareim.com/forum/viewtopic.php?t=3481

This BSV demonstrates:
A) naming report files with AwareIM BO attributes in context
B) giving user the ability to save or email report with name from #1
C) eliminating extra messages / mouse clicks in report display

Steps:
1) Add a Report: OneCityReport . Determined at run time. Include City.Name and City.Country on the Detail Line.

2) Add process: ExportAndViewOneCityReport

PICK FROM 'City List' ORDER BY City.Name

EXPORT DOCUMENT OneCityReport TO FILE SystemSettings.ExportPath_Temp+'Report_300__City_'+City.Name+'.pdf'

DISPLAY URL SystemSettings.DisplayURLPrefix_Temp+'Report_300__City_'+City.Name+'.pdf' IN NEW WINDOW

3) Add "One City Report" to the Menu. This will run process from #2 above.

Now run a test:

After clicking the menu option from #3 above, you will get a Pick list.

When you choose a city & click OK, the PDF report will open in a new screen. It can be saved or emailed with a name that includes the City the user selected.

Obviously you can use different syntax of DISPLAY URL depending on your needs.

Sergej · Post by **Sergej** » Sun Jan 08, 2012 6:25 pm

Hi!
Is it possible to display url containing path where document was exported IN FOLDER ?

tford · Post by **tford** » Sun Jan 08, 2012 6:33 pm

Is it possible to display url containing path where document was exported IN FOLDER ?

It should be possible.

You would have to modify the syntax here to use the folder name in the URL being build for display:

DISPLAY URL SystemSettings.DisplayURLPrefix_Temp+'Report_300__City_'+City.Name+'.pdf' IN NEW WINDOW

Sergej · Post by **Sergej** » Sat Jan 14, 2012 2:35 pm

I meant

Code: Select all

The FOLDER keyword specified after the TO keyword identifies the directory in the file system where the file will be written. Note that if the file with this name already exists in the specified folder, it will not be overwritten. Instead another file with the variation of the original name (for example, originalName0) will be created.

So how is it possible to get path of that created file?

tford · Post by **tford** » Sat Jan 14, 2012 3:34 pm

EXPORT DOCUMENT OneCityReport TO FILE SystemSettings.ExportPath_Temp+'Report_300__City_'+City.Name+'.pdf'

DISPLAY URL SystemSettings.DisplayURLPrefix_Temp+'Report_300__City_'+City.Name+'.pdf' IN NEW WINDOW

Notice in my rules that I use EXPORT .. TO FILE syntax

but I allow the configurator or user to determine the folder / path that is used for file storage in SystemSettings.DisplayURLPrefix_Temp

Sergej · Post by **Sergej** » Sun Jan 15, 2012 10:05 am

I am trying to construct process of Order BO that:

1) Exports Document based on Order BO to folder A
2) Gets the Path to exported document
3) Stores Path to Order BO attribute DocPath

All Documents are exporting to the same folder A. I think the solution is to use Order.ID as a filename so documents in folder will not be overwritten.

tford · Post by **tford** » Sun Jan 15, 2012 12:08 pm

Using Order.ID seems to makes sense in your situation.

Do you have additional questions?

Sergej · Post by **Sergej** » Sun Jan 15, 2012 4:24 pm

No, thanks! I think it should work.