Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] EXL07 Template WF8 errors

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] EXL07 Template WF8 errors
 Login/Join
 
Guru
posted
Hi FOCUSed developers,
I've done the searches, read the docs and tested many possibilities with no success.
I used Excel templates extensively about 10 years ago but things have changed.

I'm looking for an example of a excel template which is pre-designed (I can create one on the fly with BYTOC and then load the sheets but I need a pre-designed output). I need Sheet 1 with multiple reports and Sheet 2 through Sheet n that Sheet 1 links to.
In other words, there are links (references) in the cells of Sheet 1 that link to cells in either Sheet 2 or Sheet n.

Output is EXL07 using WF 8.009

I'm getting the following error from a template I created in Excel07 using several extensions in my tests: xlsx, xltm, xlsm, and mht.
(FOC3289) TEMPLATE FILE: Error opening file
(FOC3317) Error processing template file.

PS.I checked WF Admin console to verify that these extensions do exist.

Thanks for any guidance or guesses.

This message has been edited. Last edited by: <Kathryn Henning>,



Greg



current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
 
Posts: 274 | Location: Boston/New England | Registered: February 12, 2006Report This Post
Expert
posted Hide Post
Hi Greg,

At which point do you get the error, at the first template, the second ....?

I posted the following code last August, it might trigger some thoughts?
-* File exl07_template.fex
SET EMPTYREPORT = ON

TABLE FILE CAR
  SUM RCOST
      DCOST
   BY COUNTRY
   BY CAR
   BY MODEL
WHERE COUNTRY EQ 'ENGLAND'
ON TABLE HOLD AS CAR1 FORMAT EXL07 TEMPLATE 'exl07_template.xltm' SHEETNUMBER 1
END
-RUN

TABLE FILE CAR
  SUM RCOST
      DCOST
   BY COUNTRY
   BY CAR
   BY MODEL
WHERE COUNTRY EQ 'ITALY'
ON TABLE HOLD AS CAR2 FORMAT EXL07 TEMPLATE 'car1.xlsm' SHEETNUMBER 2
END
-RUN

TABLE FILE CAR
  SUM RCOST
      DCOST
   BY COUNTRY
   BY CAR
   BY MODEL
WHERE COUNTRY EQ 'W GERMANY'
ON TABLE PCHOLD FORMAT EXL07 TEMPLATE 'car2.xlsm' SHEETNUMBER 3
END
-RUN

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Guru
posted Hide Post
Hi Tony,

Ran your code and I got the error at the first point itself.

0 NUMBER OF RECORDS IN TABLE= 4 LINES= 4
(FOC3289) TEMPLATE FILE: Error opening file
(FOC3289) TEMPLATE FILE: Error opening file
(FOC3317) Failed to unzip EXL07 template file

Recently, i had to use macro in one of my requirement but with no luck. But, i too remember sometime back, was succeed on this.I don't know where I'm going wrong now.
Merging cells using CSS - Excel


-Rifaz

WebFOCUS 7.7.x and 8.x
 
Posts: 406 | Location: India | Registered: June 13, 2013Report This Post
Guru
posted Hide Post
I saw your code, Tony, and ran it.
It runs fine with a simple CAR file report.

My report has 4 sections on sheet 1 that is populated from sheet 2 through sheet 5 with links in the cells.
As soon as I try to populate this I get the template error.
I appreciate you code and it did verify that the basics work.

Thanks and keep the ideas coming.

PS: I've opened a case on this and will report back when this is solved.



Greg



current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
 
Posts: 274 | Location: Boston/New England | Registered: February 12, 2006Report This Post
Platinum Member
posted Hide Post
In webFocus 8 I would consider going with FORMAT XLSX instead of FORMAT EXL07.


WebFOCUS 7.7.05 (Someday 8)
Windows 7, All Outputs
In Focus since 1983.
 
Posts: 103 | Registered: April 27, 2011Report This Post
Guru
posted Hide Post
Kevin W,
From the documentation, they should be the same:
"FORMAT EXL07 and FORMAT XLSX are synonyms and can be used interchangeably. The FILE
SAVED message will always display "XLSX FILE SAVED", regardless of the syntax specified."

Thanks.



Greg



current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
 
Posts: 274 | Location: Boston/New England | Registered: February 12, 2006Report This Post
Platinum Member
posted Hide Post
It was explained to me that EXL07 didn't do the full XML that comes with XLSX. But perhaps that is comparing our 7.7.05 system to our 8.1.03. Maybe they made them synonomous in 8.1.0.3. Still I see a lot of caveats in the 8.1.0.3 doc that XLSX still doesn't have quite all the features that were in EXL07. So I wonder. Here is the most recent XLSX document that I have: http://documentation.informati...f_wf_8009/TM4690.pdf


WebFOCUS 7.7.05 (Someday 8)
Windows 7, All Outputs
In Focus since 1983.
 
Posts: 103 | Registered: April 27, 2011Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] EXL07 Template WF8 errors

Copyright © 1996-2020 Information Builders