Merin Joseph Posted August 24, 2021 Share Posted August 24, 2021 Under the export feature in Active report menu, Is there is a way to get the correct csv option with the working excel, HTML and pdf at the same time ON TABLE PCHOLD FORMAT AHTML ON TABLE SET WEBVIEWER ON ON TABLE SET CACHELINES ON using the above code csv is exporting in a different format WFServlet.ibfs. When i commented out ON TABLE SET WEBVIEWER ON , the csv is working but the pdf option is not working. Product version: 8206 merin.joseph@kashtechllc.com : Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted August 24, 2021 Share Posted August 24, 2021 Merin I did reproduce what you are experiencing with 8.2.06.27. The on demand paging interface only works when HTML is the output so this is an anonymity. I tried the same thing with 8.2.07.27 and it behaves exactly the same. I think you should report this to techsupport and get their take on what is going on. Link to comment Share on other sites More sharing options...
Brian Suter Posted August 24, 2021 Share Posted August 24, 2021 With webviewer on - the data for the report is kept in foccache And what happens when an export is done is that a fresh adhoc request is run that does a PCHOLD FORMAT PDF or format CSV (maybe its another name I didnt trace it). The request URL will be something like WFServlet.ibfs.. and the result will be PDF with the correct mime type headers, etc. The browser recognizes the PDF mime type and it works - regardless of what is in the URL. But (and this may be browser specific) it is not auto recognizing the csv format and it is looking at the invoking URL to make a guess and it does not know what to do with the .ibfs extension. What happens if you just have a simple hold format CSV fex on the server that you run with WFServlet,ibfsIBIF_ex=fexname I am guessing the same thing. The last check is to run the fex with simply WFServletIBIF_EX=fexname . You dont need the .ibfs extension. If that makes everything fine, I believe there is a setting that defaults to WFServlet.ibfs which can be changed to simply WFServlet no dot and extension. Remember to check ALL browsers! You may want to see what happens if you register the ibfs extension on your browser. Now without webviewer on - the export is done completely differently. All of the data is IN your browser and the AHTML JS code running in your browser knows hows how to write a CSV file. There is no interaction with the sever and there is no URL. But that JS code does NOT know how to do all the other formats the server supports - like PDF or PPT or That is why there is no PDF option there. Link to comment Share on other sites More sharing options...
Merin Joseph Posted August 24, 2021 Author Share Posted August 24, 2021 Ok. Will open a case . Thank you. Link to comment Share on other sites More sharing options...
Merin Joseph Posted August 27, 2021 Author Share Posted August 27, 2021 We opened a case for this issue, got a suggestion to add the following line of code to the procedure: SET ARVERSION = 2 This is for adding the newest version of active report formatting. It seems to be working in our end. But when client tried that in MAC, the csv is working but xls is not formed correctly. it opens like that in Numbers on the Mac and wont open at all in Google Sheets( Find the image below). Did you guys know the reason for that image (15).jpg28801618 548 KB Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted August 30, 2021 Share Posted August 30, 2021 Please continue to work through techsupport on this latest development and report back Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now