Skip to main content
L
lzanettin1-Visitor
1-Visitor
June 19, 2014
Question

Extract of database

  • June 19, 2014
  • 2 replies
  • 4902 views

Hello,

is there any possibility to extract all our datas on an excel file for example.

I'm using Intralink 10.1 with creo 2.0,

we only deal with EPDM document, and I need a solution to have a list of ALL our datas on intralink, with all revisions.

On Intralink 3.4, it was very simple, I only had to launch a research with historic and " * " in the field,

and I obtained all our datas.

Thanks,

Laurent

2 replies

M
MikeLockwood22-Sapphire I
22-Sapphire I
June 19, 2014

Search will allow exactly this if there is only a small amount of data.

- Search for CAD Document Type

- Include in the Search Results table any columns of interest

- Export to Excel

But - If you have any significant amount of data, a query buiider report will be much more efficient and effective. Site, Utilities, Report Manager. Type = EPMDocument.

- If you just want a list of all unique CAD Doc numbers, select EPMDocumentMaster and select the root

L
lzanettin1-VisitorAuthor
1-Visitor
June 20, 2014

Thanks,

but with search tool, I have error message : Search results has exceeded the limit set by the administator (and I don't know how to allow more search results)

And, I think that Report Manager is only on PDM link, not on Pro/Intralink.

😞

help!

M
MikeLockwood22-Sapphire I
22-Sapphire I
June 20, 2014

Yes - Search is limited for how many records can be returned. Can either break it up into several smaller search results and export to Excel, or use a Report.

Reports are core to Windchill - not related to either PDMLink or ProjectLink. Available from Site, Utilities, Report Manager.

P
ptc-54760011-Visitor
1-Visitor
July 25, 2014

hi

i think you can try to use a jsp page (I*E) to resolve this problem.

see the code

...

<ie:webject name="Query-Objects" type="OBJ">

<ie:param name="INSTANCE" data="YOUR_INSTANCE"/>

<ie:param name="TYPE" data="wt.epm.EPMDocument"/>

<ie:param name="WHERE" data="()"/>

<ie:param name="authorization" data="$(@SERVER[]AUTHORIZATIOIN[0])"/>

<ie:param name="GROUP_OUT" data="objects"/>

</ie:webject>

...

BUT if you have large data, you will find some troubles while executing this JSP page(

PS sorry for my english

Message was not edited by: Michael Sergeev

L
lzanettin1-VisitorAuthor
1-Visitor
July 25, 2014

You prefer in french?

Sorry but I don't understand what you said!?

How I can execute a JSP page??

thanks

laurent

    P
    ptc-54760011-Visitor
    1-Visitor
    July 25, 2014

    2read
    1. IEUsersGuide

    2. Creating Simple Admin Tools Using lnfo*Engine and Java by Dennis G. Kapatos, Cory Skradski, J.D. Felkins

    both of pdf can be finded by Google

    -----------------------

    I. Create your own jsp at this dir

    <Windchill>\codebase\infoengine\jsp\

    example.jsp

    <%@page language="java" session="false"

    errorPage="IEError.jsp"

    %>

    <%@ taglib uri="http://www.ptc.com/infoengine/taglib/core"

    prefix="ie"

    %>

    <%@page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"

    %>

    <html>

    <head>

    <link rel="stylesheet" type="text/css" href="stylesheet.css" TITLE="Style"></link>

    </head>

    <body>

    <!-- Begint to Get data -->

    <ie:webject name="Query-Objects" type="OBJ">

    <ie:param name="INSTANCE" data="***"/>

    <ie:param name="TYPE" data="wt.epm.EPMDocument"/>

    <ie:param name="WHERE" data="()"/>

    <ie:param name="authorization" data="$(@SERVER[]AUTHORIZATIOIN[0])"/>

    <ie:param name="GROUP_OUT" data="objects"/>

    </ie:webject>

    <!-- End to Get data -->

    <p>

    <ie:webject name="Display-Table" type="DSP"/>

    </p>

    </body>

    </html>

    you must change this fields:
    <ie:param name="INSTANCE" data="***"/>
    <ie:param name="WHERE" data="()"/>

    II. Execute Windchill JSP

    "The URL to execute a JSP page includes the host name and Windchill application URL with "infoengine/jsp/" and the path to the JSP page."

    In your case it will be look smth like that

    http://train.ptc.com/Windchill/infoengine/jsp/example.jsp

    When the file is executed, the Web Server passes the URL to the JSP processor.

    And you will see the page with needed data table.

    Done.

    --

    I'm from Russia, i'm prefer in russian.

    Terms & ConditionsAccessibility statement