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 email@example.com for further assistance. Reference the community FAQ to learn more about the community.
I'm quite nervous about posting a question, as I know some people respond quite harshly! But I'm quite desperate for help - I have raised a case, but have been told that it is an issue on the macro side.
I'm no expert and that's why I'm asking for help ... please be kind :-)
I have used the code almost exactly (I called my .mht EXCEL_MHT.mht instead of EXCEL_TEMPLATE; and in the macro I put the name of our server). I created a EXCEL_MHT.fex and EXCEL_MHT.mht which are both stored in the apps\bi folder. This folder is mapped in the application path.
When I run the .fex, the data is correctly displayed in the spreadsheet in a WFServlet. But when I click on the button to update the CAR table in webfocus, then I get a message saying that EXCEL_MHT.mht cannot be found.
So if I understand correctly: The .fex can find the .mht and uses it to display the data in the WFServlet. However, when clicking the button on the WFServlet, it cannot find the .mht. Could somebody please help me in getting the data to be written back to the table? We don't have MAINTAIN.
The strange part: Yesterday on my work PC, if I had the .mht open and then ran the process, it worked, and I managed to successfuly update the CAR table. However, today I am working remotely on the laptop and it won't work even if I have the .mht open!
The .fex is as follows:
TABLE FILE CAR PRINT COUNTRY CAR MODEL BODYTYPE RETAIL_COST DEALER_COST COMPUTE MARGIN/D5.2 = (RETAIL_COST - DEALER_COST) / DEALER_COST;
ON TABLE PCHOLD FORMAT EXL2K FORMULA TEMPLATE 'EXCEL_MHT' SHEETNUMBER 2
-IF &COUNTRY.EXISTS NE 1 THEN GOTO NODATA;
MODIFY FILE CAR FREEFORM COUNTRY CAR MODEL BODYTYPE DEALER_COST RETAIL_COST MATCH COUNTRY CAR MODEL BODYTYPE ON NOMATCH REJECT ON MATCH UPDATE DEALER_COST RETAIL_COST DATA
[quote=janine]The strange part: Yesterday on my work PC, if I had the .mht open and then ran the process, it worked, and I managed to successfuly update the CAR table. However, today I am working remotely on the laptop and it won't work even if I have the .mht open! [/quote]
I think you were not able to make it work remotely because the xmlhttp object is not allowed to make cross domain calls. When you were working remotely and if the excel spreadsheet was on the remote machine you more than likely were trying to do something the xmlhttp object is not allowed to do for security reasons. Now if you had the spread sheet on a local machine (inside the network) and you 'remoted' to that machine and ran it from that machine it should work fine (like it already has). Just a guess but I would sure take a look at that.
Hi, sorry for refreshing this post!! I get the same error message as janine "EXCEL_MHT.mht cannot be found" and i used a button from vba toolbar. I use excel 2007 for building the mht. Could this be the reason?? i followed strictly Mr. Delgado,s example!!
WF Production Version: 7.7.02M WF Test Version: 7.7.02M Developer Studio: 7.7.02 HTML, EXL2K, FLEX, PDF,PPT
You need to use excel 2003 to update/create mht files as they are not a fully supported feature in Office 2007
Here is the statement from microsoft
Single File Web Page (*.mht; *.mhtml) Excel 2007 no longer stores Excel-specific feature information in this file format. You can open a file in this format, preserving any Excel-specific features that were created in an earlier version of Excel. However, you can save such a file (or any other workbook) in this file format for publishing purposes only.
Webfocus 8.0.7 on Windows
Posts: 176 | Location: Ohio | Registered: October 26, 2006