I need to extract a listing of all our ItemRevisions and include handful of properties on the IRs.
What would you recommend as a method to accomplish this? It would be especially helpful if answers briefly summarize advantages/disadvantages to a method.
Hello, query_xml.exe I did not use, but if it solves your problem (exports the data you need), I think it is quite possible to use it
Of utilities, what else you can see, this is tcxml_export, should work fairly quickly, but it will output information in its format, which will need to be processed. It also requires studying for your needs, maybe it will not suit you.
If you write your utility, I recommend writing an executable exe file on ITK, it will work quickly, because it's C code and it is executed on the server and you will be able to output information in almost any form you need
and the data format: txt, xml, json, csv or in another (for some formats you will have to use additional C libraries). You can also easily run it from cmd with the parameters you need
It does not appear to me from the MSA guide that is it possible to include other attributes such as Last Modifying User, Release Status or other attributes. Is this correct?
If this is correct then this would only enable me to extract a list of all ItemRevisions, but not the associated attribute data.
What are you trying to do with the data after you extract it?
I had not thought of that, however using the Details pane is precisely how we are accomplishing the task today in the UI (query, details, export to .csv)
Regarding not liking ITK, we do not have the option to dislike it for this solution, as mentioned before we do not have in-house capability to develop ITK solutions. It may be an very fine option for others.
I like the capability of being able to extract a list of IRs and then populate them to a folder from the command line, could be very useful for a project. Will keep it in mind.
Thank you for your responses,
Post extraction processing would be "unlimited".
Instead of battling with the archaic, legacy iman query tool, we could use modern methods to sift and sort our data.
Also performance, once a day extraction to a flat file would eliminate Teamcenter UI performance limitations.
So on this thread, the goal was to extract all ItemRevisions, along with a selected set of attributes useful for post processing to build a data warehouse("dba maturity level 0";-) from Teamcenter.
No one has yet mentioned a SQL query run from a batch script, I suppose it is feasible if one has enough knowledge of the TC schema and data model and access to the DB cmd line (MSSQL in our case)
Not a trained DBA, but we did buy this as "Engineering Software" ;-) ,