Search for objects in Windchill by content from a list or Excell

[JC_12507758]

We manage data by listing the data checked in to Windchill in Excel. When searching for file names organized in Excel in Windchill, it is very difficult to copy and search each file one by one. ex) A1 cs01 > copy > search .. A10000 ecw01 copy > search .. Is there a way in Windchill to search through file name lists organized in Excel or a large list of names organized in other documents at once? ex) A1 cs01, A2 cs02 ... A9999 dev0990 A10000 dcw01 > ( A row copy ) > cs01cs02..dev0990dcw01 > search Or, is there a way to import an Excel file into Windchill and search through the contents of Excel?

[Fadel]

https://www.ptc.com/en/support/article/CS360050

[avillanueva]

For some reason your initial post below showed up as "non". Saw this in email.

I am using Windchill PDMLink Release 12.1 and Datecode with CPS 12.1.0.0

We manage data by listing the data checked in to Windchill in Excell. When searching for file names organized in Excell in Windchill, it is very difficult to copy and search each file one by one. ex) A1 cs01 > copy > search .. A10000 ecw01 copy > search ..
Is there a way in Windchill to search through file name lists organized in Excel or a large list of names organized in other documents at once? ex) A1 cs01, A2 cs02 ... A9999 dev0990 A10000 dcw01 > ( A row copy ) > cs01cs02..dev0990dcw01 > search
Or, is there a way to import an Excel file into Windchill and search through the contents of Excel?

@Fadel is right. I've used this for finding parts by concatenating terms with a semi-colon. There is a limit to how big of a string you can pass in. If you are doing this for a content index search, it will be difficult to know which document hit on what term. I did not know before today that it worked for keywords as well. Thanks for that.

[Catalina]

Hi @JC_12507758,

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution or please feel free to detail in a reply what has helped you and mark it as the Accepted Solution. It will help other members who may have the same question.

Of course, if you have more to share on your issue, please pursue the conversation.

Thanks,

[d_graham]

@JC_12507758 

Are you search for the filename or the Windchill object's number?

Once you've done the search and have results, then what? Are you just looking to see that it's in Windchill?  If yes, a Report can be written to read a file and return the search results.