Does somebody can help me? I'm getting a MIME message when I run a procedure using 3 holds, trying to get a compound file in excel 2007, the procedure works just fine using PDF, here's the error and the code I wrote, thank you guys.
MIME-Version: 1.0 X-Document-Type: Workbook Content-Type: multipart/related; boundary="====Boundary====" --====Boundary==== Content-Location: file:///C:/HOLD.XHT Content-Transfer-Encoding: 8bit Content-Type: text/html; charset="windows-1252" Sheet1 --====Boundary==== Content-Location: file:///C:/IBIT0001.xht Content-Transfer-Encoding: 8bit Content-Type: text/html; charset="windows-1252" False DEALER_COST 37,853 DEALER_COST 41,235 COUNTRY DEALER_COST ENGLAND 37,853 FRANCE 4,631 ITALY 41,235 JAPAN 5,512 W GERMANY 54,563 --====Boundary====--
TABLE FILE CAR SUM DEALER_COST WHERE COUNTRY EQ 'ENGLAND' ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK END -RUN
TABLE FILE CAR SUM DEALER_COST WHERE COUNTRY EQ 'ITALY' ON TABLE PCHOLD FORMAT EXL2K NOBREAK END -RUN
TABLE FILE CAR SUM DEALER_COST BY COUNTRY ON TABLE PCHOLD FORMAT EXL2K CLOSE END -RUNThis message has been edited. Last edited by: Kerry,
WebFOCUS 769, Windows XP Excel, PDF, HTML
May 18, 2010, 06:14 PM
Waz
I think that you should submit a case with Techsupport.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
May 18, 2010, 06:51 PM
AlexG
Thank you Waz, but if I have no login privilege to submit the case at IBI Techsupport, how can I find a solution?
WebFOCUS 769, Windows XP Excel, PDF, HTML
May 18, 2010, 07:02 PM
Waz
You can register you self, all you need is the siite code, and the name of the company as it appears on the mainenance contract.
I believe if you are not using the document composer, trying using the
SET COMPOUND = OPEN Fexes (Keep the nobreak where applicable) SET COMPOUND = CLOSE Last fex
Kathy Phillips Web FOCUS 8.2.05.14, 8.1.05, 8.08, 8.0.7, 8.0.5,8.0.2m, 7.6.10,7.7.03 Windows
May 24, 2010, 03:20 PM
AlexG
Thank you Kathy, but unfortunally still doesn't work, it can't open the excel spred sheet.
WebFOCUS 769, Windows XP Excel, PDF, HTML
May 25, 2010, 10:06 AM
Kathy P
At the beginning of one of the middle reports in the compound EXL2K focexec, try SET COMPOUND syntax followed by a -RUN.
SET COMPOUND = NOBREAK -RUN
Kathy Phillips Web FOCUS 8.2.05.14, 8.1.05, 8.08, 8.0.7, 8.0.5,8.0.2m, 7.6.10,7.7.03 Windows
May 26, 2010, 10:20 AM
AlexG
Hi there Kathy, still having same problem, here's the code using your suggestions:
SET COMPOUND = OPEN -RUN
TABLE FILE CAR SUM DEALER_COST BY COUNTRY WHERE COUNTRY EQ 'ENGLAND' ON TABLE PCHOLD FORMAT EXL2K END -RUN
SET COMPOUND = NOBREAK -RUN
TABLE FILE CAR SUM DEALER_COST BY COUNTRY WHERE COUNTRY EQ 'ITALY' ON TABLE PCHOLD FORMAT EXL2K END -RUN
SET COMPOUND = CLOSE -RUN
TABLE FILE CAR SUM DEALER_COST BY COUNTRY ON TABLE PCHOLD FORMAT EXL2K END -RUN
-EXIT
and here's the result:
MIME-Version: 1.0 X-Document-Type: Workbook Content-Type: multipart/related; boundary="====Boundary====" --====Boundary==== Content-Location: file:///C:/HOLD.XHT Content-Transfer-Encoding: 8bit Content-Type: text/html; charset="windows-1252" Sheet1 Sheet2 --====Boundary==== Content-Location: file:///C:/IBIT0001.xht Content-Transfer-Encoding: 8bit Content-Type: text/html; charset="windows-1252" False COUNTRY DEALER_COST ENGLAND 37,853 --====Boundary==== Content-Location: file:///C:/IBIT0002.xht Content-Transfer-Encoding: 8bit Content-Type: text/html; charset="windows-1252" False COUNTRY DEALER_COST ITALY 41,235 COUNTRY DEALER_COST ENGLAND 37,853 FRANCE 4,631 ITALY 41,235 JAPAN 5,512 W GERMANY 54,563 --====Boundary====--
am I using correctly the COMPOUND syntaxis?
WebFOCUS 769, Windows XP Excel, PDF, HTML
May 26, 2010, 10:37 AM
Francis Mariani
Alex, the code works correctly for Excel 2003.
The problem *may* be with the mime redirection settings. Verify the following:
WebFOCUS Admin Console > Configuration > Redirection Settings. On my server, xls is set to Redirect "yes".
"The mime.wfs file contains information about format types available with WebFOCUS. Setting the redirect column to yes enables redirection, which allows you to save the report output in a temporary directory. Then, an http call is made from the browser to retrieve the temporary stored output for display in the browser. If redirection is turned off (set to no), the report output displays in the browser immediately after the request is executed. The len setting stores report content in the temporary directory when it exceeds the buffer size and then sends the output to the browser without an additional http call." - I feel this documentation isn't very clear, but may help fix the problem.
Then again it may be an Excel 2007 issue. Does Excel 2007 open a non-compound report without any problem?
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
May 26, 2010, 04:45 PM
AlexG
Thanks for your time Francis, I can't find the conf path that you wrote, I mean WebFOCUS Admin Console > Configuration > Redirection Settings. On my server, xls is set to Redirect "yes".
But I have checked the MIME file at C:\ibi\srv76\home\etc and at C:\ibi\srv76\wfs\etc they both have the settings as shown:
extension content_type format redirect translate content_disposition
.xls application/vnd.ms-excel binary yes no no
So I guess this is right isn't.
I've also tried the xls output with a non compound pchold, it works just fine.
Any way thank you so much, I'm thinking in a MS Excel 97 issue.
WebFOCUS 769, Windows XP Excel, PDF, HTML
May 27, 2010, 09:33 AM
Kathy P
Hi Alex, I played with it quite a bit and could not reproduce your error. Did some research and that was the only thing I could find related to your problem and releases. I think it is an 2007 issue also. You forgot to "close" your compound report on the syntax above. I do not have office 2007. Sorry.
Kathy Phillips Web FOCUS 8.2.05.14, 8.1.05, 8.08, 8.0.7, 8.0.5,8.0.2m, 7.6.10,7.7.03 Windows
May 28, 2010, 05:15 AM
Tony A
Alex,
A pure shot in the dark here but check the default program for opening files of type ".xlt" is MS Excel and not something else.
I can't see it being anything else but you never know.
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
May 31, 2010, 01:11 PM
AlexG
Thanks Tony, it is MS Excel the defualt program for opening '.xlt' files, so I'm still looking for an aswer to this problem, greetings.
WebFOCUS 769, Windows XP Excel, PDF, HTML
July 23, 2010, 12:05 PM
AlexG
Thank you all for your kindness, I discover that the error comes using the WF admin web console, if I run this procedure using the ibi_apps URL i.e. "http://localhost:8080/ibi_apps/WFServlet?IBIF_ex=f_ide_cte" then I get the open/save excel dialog manager.
Best regards to all.
Note: Even thoug I don't know why I can't run it from the web console.