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:
The Community Team is working with PTC Product Management to provide status updates to ideas in all the PTC Community Idea boards.
To learn about status descriptions, please visit Community Announcements
New IdeaSubmitted on11-29-201807:10 AMSubmitted bytkriegeron11-29-201807:10 AM
This idea is based on the PTC answer:
“actually importing to db is a different thing, when we do it through WQS, we may have some logic implemented where we insert related records in other tables while inserting records for system tree item table tables seen on UI of WQS don't relate directly to data base table present in sql server or oracle”
Since I figured out, that the Import Manager of PTC Windchill Quality Solution is not able to handle more than a few thousend System Tree item via the EXCEL import and the EXCEL import is not ideal for a lot of data anyway, I suggest to implement in the Windchill DB an additional table admin.import; This table rows should be identical to the import wizzard, but however, there should be no check on this table.
Whoever wants to load now data from one DB (ERP...) to Windchill can transfer them directly into admin.import (SQL DB; POSTGRES... to Windchill SQL) without using EXCEL; A routine or manager can than fetch the data easily into the Windchill tables with whatever logic is required.
... View more