Skip to main content
D
DarinS1-Visitor
1-Visitor
August 5, 2010
Question

Populating Soft Attributes - Batch

  • August 5, 2010
  • 11 replies
  • 2569 views
All,

I have a soft attribute for WTParts that contains text (ERP_DESCRIPTION). This field is passed to our ERP system during an ESI transactions. If the field is blank the transaction rolls back and a task to populate the field is triggered.

There are thousands of WTParts that have empty fields that will at some point need to be populated. I have the required ERP_DESCRIPTION for every WTPart in a csv file and have loaded it into an Oracle table. Using SQL it would be simple enough to insert this data in the STRINGVALUE table but the table entry does not exist until data is actually populated.

What I would like to do is automatically load the ERP_DESCRIPTION, creating a STRINGVALUE entry for each WTPart.

Any ideas?

Windchill 9.1 (m050)

Thanks,
Darin


11 replies

Show previous replies
G
glen.herman11-Visitor
1-Visitor
August 25, 2010


I was unable to create a custom loadfromfile for non-modeled attributes. I had to use info-engine to populate the soft type attributes we added. Here is apiece for illustrationif you want to use an info-engine task. You can read the part/values in with Java from a file

<ie:webject name="CheckOut-Objects" type="OBJ">
<ie:param name="INSTANCE"" data="IE_Adapter_Service_Name"/">
<ie:param name="OBJECT_REF" data="$(gPart[0]obid[0])"/">
<ie:param name="GROUP_OUT" data="gItem"/">
</ie:webject>


<ie:webject name="Update-Objects" type="OBJ">
<ie:param name="INSTANCE"" data="IE_Adapter_Service_Name"/">
<ie:param name="OBJECT_REF" data="$(gItem[0]wt.part.WTPart.obid[0])"/">

<ie:param name="GROUP_OUT" data="gOut"/">
</ie:webject>

<ie:webject name="CheckIn-Objects" type="OBJ">
<ie:param name="INSTANCE"" data="IE_Adapter_Service_Name"/">
<ie:param name="OBJECT_REF" data="$(gItem[0]wt.part.WTPart.obid[0])"/">
<ie:param name="GROUP_OUT" data="gCheckedIn"/">
</ie:webject>

Regards,

Glen Herman
Sr Application Developer
Engineering And Technology
Trane Residential Systems
6200 Troup Hwy
Tyler, Texas, 75701


Terms & ConditionsAccessibility statement