Recently, an IID user reported an interesting problem in the Relationship component.
The user created a relationship with 3 roles defined and static instance data.
He then wanted to import additional instance data from a CSV file, as described in this developerworks article.
Here is a sample CSV file:
Now when he imported the CSV, and appended the data...
...an exception was fired:
And the Instance Data table only contained the original data, nothing else:
Now, this is a product defect that will be fixed in an upcoming release. However, I want to share a neat little workaround, which you can use until an iFix is available.
When you create a new role, it is created with a key attribute 'Data' as default:
Rename the key attributes of your defined roles back to the default value 'Data'. So from this
Now run the import of the CSV again:
This time the append will work and will add the data:
As a last step, simply change back your key attributes of the roles to the previous values:
I hope this will one day help you work around this issue if you ever encounter it. And if it does not, take two of these and call me in the morning.
Your Doc D