I've created a .MHT file in desktop and copied to my application folder. when i call this template in webfocus7.7.02 version i get error message as " (FOC3290) TEMPLATE FILE must be in "Single File Web Page" format (FOC009) INCOMPLETE REQUEST STATEMENT"
Here is the steps i followed to create .mht file step1 - Opened excel 2003, created a required cell formatting in sheet1 and saved file as EXCEL_MHT.mht format step2 - copied the EXCEL_MHT.mht from desktop to webfocus other folder in my application. step3 - I wrote a simple procedure as below APP PATH XYZ TABLE FILE CAR PRINT COUNTRY CAR BY MODEL ON TABLE HOLD AS TEMPMHT FORMAT EXL2K TEMPLATE 'EXCEL_MHT' SHEETNUMBER 1 END Step 4 - when i run this report, i get error message as said above.
I even tried to change the format from EXL2K to other excel formats but no luck.
Please help me in resolving this issue.
ThanksThis message has been edited. Last edited by: Kerry,
WF 7702m / Windows
April 19, 2012, 10:21 AM
Mary Watermann
Kittuputtu,
In your .mht file do you have the followign:
1. More than 1 tab? 2. A value in one of the cells?
That may be what it doesn't recognize.
I have worked a lot with .mht files with EXL2K.
WF 7.6.10, Windows, PDF, Excel
April 22, 2012, 05:57 PM
Waz
Did you save the excel document as excel format with a mht extension or save it in single file web page format ?
And as Mary suggests, there must be a sheet available for the data to be places into. You have said that you formatted sheet 1 cells, and told FOCUS to overwrite sheet 1.
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!
April 23, 2012, 03:04 AM
Kittuputtu
quote:
u formatted sheet 1 cells, and told FOCUS to overwrite sheet 1.
Thanks for the reply... Yes i have more than 1 tab (sheet1, sheet2, sheet3) and also in sheet1 I have named col1 to col5. I have saved the excel file with .mht format and placed in other folder in webfocus.
WF 7702m / Windows
April 23, 2012, 03:08 AM
Kittuputtu
when i open other folder in Webfocus, i can see the file name as excel_mht.mht with internet explorer image and type as "MHTML Document". Is there in any problem with the way it saved in webfocus? I worked in earlier version 769 and when i placed the .mht file, the icon was same as when i save in my desktop but in 7702 version it is bit different.
WF 7702m / Windows
April 23, 2012, 05:20 AM
Tony A
quote:
I have saved the excel file with .mht format and placed in other folder in webfocus
The "other" folder in WebFOCUS Developer Studio is not a "real" folder.
Try using windows explorer to copy your MHT file into the correct location (providing you have access of course).
Also, as per Waz, please confirm that you saved as a single page web archive and didn't just type the mht file extension.
Finally, what version of MS Excel are you using to create the file?
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
April 23, 2012, 05:32 AM
Kittuputtu
Hi Tony,
I copied .mht file from Windows explorer aswell but still no luck. Yes i have saved file as "single page web archive" format from excel 2003 version
WF 7702m / Windows
April 23, 2012, 10:47 AM
Tony A
Silly question, but where is the mht file located?
Also, could you post the results of APP SHOWPATH and ? PATH or they are sensitive then PM me with them.
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
April 24, 2012, 02:01 AM
Kittuputtu
i took working .mht file(migrated from 7.6x), copied content(code) into my 'EXCEL_MHT.mht' file and it worked :-)...but it is not working when i create new mht file. I'm trying to analyse what content is missing when i create a fresh .mht compared to working .mht file. I will keep posted on the findings.
WF 7702m / Windows
April 25, 2012, 12:58 PM
jgelona
I think the issue is how you created the .mht file.
The requirement is that at least 1 cell in SHEET2 has data, not SHEET1. All of the other sheets in the .mht file can be blank. I always put a blank in cell A1 of SHEET2 and never have an issue.
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.