Opened 11 years ago

Closed 9 years ago

#157 closed Issue (Fixed)

Export page to MS-Excel CSS Issue

Reported by: Garth Braithwaite Owned by: Testing
Priority: -Low Milestone: 2.2 - Testing
Component: View-App Version: 2.2
Severity: Minor Effort Keywords: query output
Cc:

Description (last modified by Garth Braithwaite)

When exporting a page to MS-Excel the backend control sets the mime type and sets the XSLT to produce a printer friendly version of the page.

The problem with the current implementation is that Excel complains about not being able to find the CSS files. The reason for this is that main stylesheet imports other stylesheets with a relative path. There are currently 2 easy fixes to get around this.

1) Simply edit the main css/stylesheet.css's imports to be a fully qualified URL. So edit css/stylesheet.css and change the imports to http://some ip address/css/xyz.css.

2) Edit the xslt/html/SiteSpecific.xslt's "Page.standardCSS" template and change the the single "css/stylesheet.css" reference and replace this single reference with a series of references that replicate the imports included within the main single stylesheet.css file.

3) There are other solutions but they require development time. One is to actually return an Excel XML file etc.

Duplicate ticket #21.

Attachments (1)

temp.PNG (11.8 KB) - added by Lois Haggard 9 years ago.
Error message about file extension

Download all attachments as: .zip

Change History (10)

comment:1 Changed 11 years ago by Garth Braithwaite

Type: UnknownIssue

comment:2 Changed 10 years ago by Garth Braithwaite

Description: modified (diff)
Resolution: Duplicate Ticket
Status: newclosed

comment:3 Changed 10 years ago by Garth Braithwaite

Resolution: Duplicate Ticket
Severity: UnknownMinor Effort
Status: closedreopened

comment:4 Changed 10 years ago by Eleanor Howell

Keywords: query output added

comment:5 Changed 10 years ago by Garth Braithwaite

Milestone: Unassigned2.1 - Testing
Priority: Unknown-Low
Version: Unknown2.1

To resolve use the xslt/html/Excel_CSS_Issue_Template_Example-Page.standardCSS.xslt as an example. Brief instructions are in the file.

comment:6 Changed 10 years ago by Garth Braithwaite

Milestone: 2.1 - TestingUnassigned
Version: 2.1Parking Lot

comment:7 Changed 9 years ago by Garth Braithwaite

Description: modified (diff)
Milestone: Unassigned2.2 - Testing
Owner: set to Testing
Status: reopenednew
Version: Parking Lot2.2

The real fix is to implement ooxml. But for now implemented a simple, stripped down HTML query result page XSLT that is hooked up to the Excel query result request. This XSLT removes all script, css, header, navigation, and site footer HTML code. It also removes the graphic request as this was not working.

Note that this solution does not offer any formatting - it's a basic and defaults to whatever Excel wants to use for the imported HTML.

Adopters Should: Update the main ss.xslt print footer param “SiteSpecific?.printPageFooter” as needed. Also, update the new query/module/result/simple/ss.xslt as needed.

Test: run a query and see if any errors occur or really messed up formatting when the import to excel request is made.

SVN: 4854

Changed 9 years ago by Lois Haggard

Attachment: temp.PNG added

Error message about file extension

comment:8 Changed 9 years ago by Lois Haggard

Tested the Simple stripped down html query result page. Still get a warning message about file extension or file corruption -- see attached -- Other than that the simple xslt is working

comment:9 Changed 9 years ago by Lois Haggard

Resolution: Fixed
Status: newclosed
Note: See TracTickets for help on using tickets.