cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Design Interface (ODBC like ) for Data Import in Windchill FRACAS Qualitiy Solutions

0 Kudos

Design Interface (ODBC like ) for Data Import in Windchill FRACAS Qualitiy Solutions

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.

 

Kind regards,

 

Tobias

 

Kind regards,

 

Tobias