Re: Extract of database

lzanettin · ‎Jun 19, 2014

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

MikeLockwood · ‎Jun 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

lzanettin · ‎Jun 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!

MikeLockwood · ‎Jun 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.

lzanettin · ‎Jun 23, 2014

It would be fine if I coulf find this Report Manager!

Please find attached the view that I have when I am on utilities link.

I have a Report section (not in utilities) but not sure that is what I need. (attached too)

thanks,

Laurent

MikeLockwood · ‎Jun 23, 2014

Hmmm... I'm amazed - Reports are evidently not included in Intralink 10 (as compared to PDMLink or ProjectLink). Sorry - you're out of luck running Windchill reports. Didn't know this.

I can help you obtain directly from the database if you like.

lzanettin · ‎Jun 24, 2014

I had yesterday the confirmation by our support that Report Manager is only available on PDMlink.

What do you mean by "obtain directly from the database" ?

MikeLockwood · ‎Jun 24, 2014

Lots to this

Do you have access to the database that Windchill stores it's data in (either Oracle or SQL Server)? If not, ignore. Have to use Search in small chunks.

lzanettin · ‎Jun 25, 2014

Not me, but I can have access with our IT admin.

ptc-5476001 · ‎Jul 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

lzanettin · ‎Jul 25, 2014

You prefer in french?

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

How I can execute a JSP page??

thanks

laurent

ptc-5476001 · ‎Jul 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>

<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>

<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.

TomU · ‎Jul 25, 2014

Here's a copy of the presentation. Looks like it may have been updated slightly compared with the one on Google (from NASA).