Exporting all part numbers to CSV file

[DanPonjican]

I have about 99k documents in a Library folder (no WTParts or anything else in PDMLink yet... just documents in the Library). I need a list of all the part numbers exported out to a CSV or text file. I need to do some data comparison with our ERP system (need to find missing parts). What is the easiest way to export this information? I already tried running a search for all items and using the export to CSV icon on the results report but it crashes the method server. Can I connect directly to the oracle table using something like Toad and run an external query?

[dnovikov-2]

sqlplus .... select number from WTPartMaster where context like ...; select number from WTDocumetMaster where context like ...;

[DavidMertz]

Use the Report Manager. If you only care about numbers, use the WTPartMaster as the table to search. Then select all the fields you need. If you require additional attributes (IBAs), us WTPart. Link it to the context (ie: library) you want to use if you need it narrowed down by library. Library name can also be used as an input parameter so you can go library by library. Once you run the query, you can always save the URL generated to return to that same query at any time. Or import the results as a web query into an excel to see the results in a spreadsheet.