cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

or how to export it to excel? Display a very large list in Windchill

HerbertMiller
1-Newbie
1-Newbie
‎Sep 16, 2009 04:12 PM
‎Sep 16, 2009 04:12 PM

or how to export it to excel? Display a very large list in Windchill

The list can be exported to an excel file from the file pulldown menu of the
search results.



Herb Miller

TWeatherford, Inc.

3148 Beach Blvd

Cicero, IN 46034

www.tweatherford.com
clicking here

"If you continue to ignore PLM, you will learn about it from your biggest
competitor"
Labels:
0 Kudos
Notify Moderator
5 REPLIES 5
MikeLockwood
22-Sapphire I
22-Sapphire I
(To:HerbertMiller)
‎Sep 16, 2009 04:16 PM
‎Sep 16, 2009 04:16 PM

But anything over about 5000 objects in search results results in the process of exporting to Excel freezing in our experience.
0 Kudos
Notify Moderator
HerbertMiller
1-Newbie
1-Newbie
(To:HerbertMiller)
‎Sep 16, 2009 04:26 PM
‎Sep 16, 2009 04:26 PM

I guess then you could query oracle to get a list of objects that are stored
in windchill

Log into oracle as DB owner

Spool cadname.log

SELECT "CADNAME", "NAME", FROM "EPMDOCUMENTMASTER";

Spool off



This should create a cadname.log from the location you logged into oracle.

You can then open it in excel.



Herb Miller

TWeatherford, Inc.

3148 Beach Blvd

Cicero, IN 46034

www.tweatherford.com
clicking here

"If you continue to ignore PLM, you will learn about it from your biggest
competitor"
0 Kudos
Notify Moderator
ptc-113113
1-Newbie
1-Newbie
(To:HerbertMiller)
‎Sep 16, 2009 05:19 PM
‎Sep 16, 2009 05:19 PM

That's right in 9.1 export to excel was added!
Thanks Herb,

0 Kudos
Notify Moderator
ptc-113113
1-Newbie
1-Newbie
(To:HerbertMiller)
‎Sep 16, 2009 05:38 PM
‎Sep 16, 2009 05:38 PM

heck with excel freezing, my Rehersal instance now says:
Service Temporarily Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
New best practice:
Teammates please kindly pre-calculate the effect of your search terms upon our new Windchill system as finding too many matches to the system has been known to cause the system to crash. Oh pretty please do not crash the system intentionally..

Enterprise, this is Kirk, please beam me up as there is no support for enterprise level tasks down here. Wait, disregard last transmission, send the old 3.4 shuttle, it can do the job for the enterprise....

From: Lockwood,Mike,IRVINE,R&D [
0 Kudos
Notify Moderator
HerbertMiller
1-Newbie
1-Newbie
(To:HerbertMiller)
‎Sep 16, 2009 06:05 PM
‎Sep 16, 2009 06:05 PM

Maybe doing a search per object type would help.



Herb Miller

TWeatherford, Inc.

3148 Beach Blvd

Cicero, IN 46034

www.tweatherford.com
clicking here

"If you continue to ignore PLM, you will learn about it from your biggest
competitor"
0 Kudos
Notify Moderator
Top Tags