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

M
22-Sapphire I
MikeLockwood22-Sapphire I
22-Sapphire I
August 5, 2010
We have this exact need as well and I suspect that it is very common - please post if you get a good answer and process.
D
ddemay1-Visitor
1-Visitor
August 5, 2010
So you need a StringValue insert statement?


Sent from my Verizon Wireless BlackBerry
M
22-Sapphire I
MikeLockwood22-Sapphire I
22-Sapphire I
August 5, 2010
Seems like an Import from Spreadsheet or a LoadFromFile process would be much more robust - bad, bad things can happen from touching the database directly.
A
achukwuka1-Visitor
1-Visitor
August 5, 2010
I agree with Mike Lockwood, completely..

Alexius C. Chukwuka
IT Analyst, PDP Systems
John Deere Power Systems
Product Engineering Center
*Voice: 319-292-8575
*Mobile: 319-429-5336
*Fax:319-292-6282
*E-Mail: -
CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere & Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail.
From: Lockwood,Mike,IRVINE,R&D [
D
ddemay1-Visitor
1-Visitor
August 5, 2010
Takes longer to write a loader...but I do agree in principal.

The same sequence is used across all tables to create their respective ida2a2 value.

I'll take a look at this in sqldeveloper in the AM to create an insert statement.



Sent from my Verizon Wireless BlackBerry
A
achukwuka1-Visitor
1-Visitor
August 5, 2010
There is really nothing to write. The import from spreadsheet and LoadFromFile are OOTB tools.

Alexius C. Chukwuka
IT Analyst, PDP Systems
John Deere Power Systems
Product Engineering Center
*Voice: 319-292-8575
*Mobile: 319-429-5336
*Fax:319-292-6282
*E-Mail: -
CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere & Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail.
From: - [
D
ddemay1-Visitor
1-Visitor
August 5, 2010
They iterate your parts.

Sent from my Verizon Wireless BlackBerry
D
DarinS1-VisitorAuthor
1-Visitor
August 5, 2010
Correct, which in turn takes your transaction history out of sync. You would have to resend everything to the distribution target.


From: Dave DeMay [
A
achukwuka1-Visitor
1-Visitor
August 5, 2010
Yes, only if there is an existing version/iteration already in the database.

Alexius C. Chukwuka
IT Analyst, PDP Systems
John Deere Power Systems
Product Engineering Center
*Voice: 319-292-8575
*Mobile: 319-429-5336
*Fax:319-292-6282
*E-Mail: -
CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere & Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail.
From: - [
S
skasoverskiy1-Visitor
1-Visitor
August 24, 2010
I can quickly (1 day) write you a loader for this. Please contact me if you need it (-).
Show more replies
Terms & ConditionsAccessibility statement