Skip to main content
dkhosla1-Visitor
1-Visitor
Feb 7, 2013 7:13 AM UTC
Solved

Export reports Microsoft Excel

HI,

I have few report in MKS 2007. Whne i run those reports in IE 7 or 8.0 and try to export it by right clicking on the report, followiing error is returned:

The user name and password associated with the current HTTP request do not match those associated with the current session. Click the following link to go to the main view

Could you please help.

    jgorslineAnswer
    1-Visitor
    Mar 21, 2013 12:59 PM UTC

    Sorry, Deepika. That's an older document with a link to the old MKS site.

    You can find the new downoads page at:

    http://www.ptc.com/appserver/auth/it/esd/product.jsp?prodFamily=MIG

    You'll want to look under "features" for your Integrity version. I see the file name is "Integrity-2009sp6-Microsoft-Excel-2003&2007-Integration".

    View in thread

    16 replies

    jgorsline1-Visitor
    1-Visitor
    Feb 11, 2013 8:41 PM UTC

    Deepika,

    This is a known issue with Integrity 2007. It seems to only occur with certain versions of IE. We recommend trying this in another browser (such as Firefox) where this should not occur.

    Translate
    dkhosla1-VisitorAuthor
    1-Visitor
    Feb 22, 2013 7:15 AM UTC

    HI, But for chrome or firefox, i do not get an option to export to excel on the context menu (right clicking the report).

    How can this be achieved?

    Translate
    jgorsline1-Visitor
    1-Visitor
    Feb 25, 2013 2:48 PM UTC

    I must apologize Deepika, I had assumed something incorrectly. Are you running the reports in the client and having them open in your browser, or do you use our browser-based client?

    Translate
    dkhosla1-VisitorAuthor
    1-Visitor
    Feb 27, 2013 7:30 AM UTC

    Hi,

    I cannot see this option in either MKS 2007 or MKS 2009MKS2007.pngMKS2009.png

    Translate
    jgorsline1-Visitor
    1-Visitor
    Feb 27, 2013 2:13 PM UTC

    I'm afraid that functionality wasn't introduced until 2009 SP6, so if your version is older than that it won't appear. In that case you have these options:

    1) You can output data to an Excel file via the CLI (im issues --query="[name of query]" >Excel.xls)

    2) You can install and configure the Excel integration which allows you to select and get information from a query from within Excel itself. This method also supports synchronizing data with Integrity so you can choose when to update the current spreadsheet if items in Integrity get changed and you can also update items in Integrity from Excel as well.

    Translate
    dkhosla1-VisitorAuthor
    1-Visitor
    Feb 28, 2013 6:47 AM UTC

    Hi,

    Could you please tell me more in detail about the 2nd option.

    Translate
    jgorsline1-Visitor
    1-Visitor
    Feb 28, 2013 2:54 PM UTC

    Deepika,

    The details of the integration with Excel can be found starting on page 171 of the following document:

    http://www.ptc.com/WCMS/files/143530/en/IntegrationsUserGuide.pdf

    For just the export to Excel option, it is far easier to upgrade your Integrity to 2009 SP7 or later. There have been quite a few additional optimizations for this in 10.2 and 10.3.

    Translate
    dkhosla1-VisitorAuthor
    1-Visitor
    Mar 21, 2013 11:04 AM UTC

    Hi,

     

    I tried accessing the link provided on page 171 of the userguide you mentioned.

     

    It says '

    The integration ZIP file is available as a download from the MKS Customer Community

    (http://www.mks.com/support).'

     

    but when i click on the link, it just takes me to PTC Ingerity support site and there is nothing i can download.

     

    Please tell me more about it.

    Translate
    Terms & ConditionsAccessibility statement