cat_gon Respected Contributor.
Respected Contributor.
587 views

Scan QR Code error when exporting to Excel

Hi All,

We have a export to excel functionality in most of our customised report. The Export to Excel is also a customised JSP with this piece of code:

<%@ page language="java" contentType="text/html;charset=UTF-8" import="java.util.*"%>
<%@ page import="java.net.*"%>
<%@ page import="java.io.*"%>

<%response.setHeader("expires","-1");%>
<%response.setContentType("application/vnd.ms-excel");%>

<%

                String strReportNumber = request.getParameter("num");
                /*String strName = "//nvautst001/app_gifsit_ppmc_test$/ITG/reports/rep_"+strReportNumber+".html";*/
    String strName = "//nav02001atds01-204s01.aut01.cbaitest01.com/q_001_001$/ITG/reports/rep_"+strReportNumber+".html";

                String thisLine;
                FileInputStream fin =  new FileInputStream(strName);
                BufferedReader myInput = new BufferedReader
                                                                  (new InputStreamReader(fin));
                while ((thisLine = myInput.readLine()) != null) { 
                                                                 out.println(thisLine);
                                                                 }

                                                                 fin.close();

/*           finally
                 {
                  if(myInput != null)
                                   myInput.close();
                 }*/


%>

 However, after we upgrade to 9.41, everytime we export to excel, we are getting this weird result (screenshot attached). We were wondering if there is some Mobile App config that is not working well with the export to excel that could have caused this issue. We do not have mobile app enabled in our environment so we are not sure where is this coming from.

Thank you.

 

Cath

0 Likes
3 Replies
Micro Focus Expert
Micro Focus Expert

Re: Scan QR Code error when exporting to Excel

Hello Cath,

Unfortunately since this is a custom report, we don't have official documentation about this matter.

We can help with problems that are defects in the PPM product, but, unfortunately, we cannot help with implementation (customization) questions or best practices as we do not have the relevant experience or the necessary resources. These type of questions need to be handled by our Professional Services Organization (PSO). 

Also, I attached the Mobile Website Client User's Guide that you can check.

Thanks,
Bryan.

0 Likes
Micro Focus Expert
Micro Focus Expert

Re: Scan QR Code error when exporting to Excel

Hello Cath,

Hope you are doing great!

Please let me know if you have additional comments about this thread.

I will be aware for your feedback.

Thanks and Regards,
Bryan

0 Likes
Micro Focus Expert
Micro Focus Expert

Re: Scan QR Code error when exporting to Excel

Hi Cath,

This is not related to whether Mobile Web Client/QR Code is enabled or not. The problem here is that you're trying to retrieve a resource from PPM (here, a generated report) without being authenticated. As a result, you're prompted with the PPM login screen, which gets exported instead of the JSP contents.

Your JSP likely won't be even called, as your users are hitting the login page instead. 

Check in the PPM Administration console (or in your Server.conf); there is a parameter "AUTHENTICATE_REPORTS" which is now "true" by default for Security purposes. If you want your users to be able to access your reports without being authenticated, set this to "false". You may need to stop PPM, and run kUpdateHtml.sh for changes to take effect. 

Hopefully that should take care of your problem.

Cheers,

Etienne.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.