Question
Import from Spreadsheet observation
I had previous created a few thousand parts via an import job. I had a
whole list of attribute (IBA) values loaded in as well. Today, I wanted
to add an additional attribute to those parts. I defined my attribute in
the type manager and created a matching Excel load sheet but this time I
only added this new attribute column and its values to the right hand
side of the import sheet. Take a guess at what happened.
My assumption was that it would iterate the Part and set this new
attribute with the values from the import job. What I didn't expect was
that it CLEARED all the attribute values from the previous iteration and
import job. This is the kind of thing that should be documented no? So,
without any hidden preference settings that I am unaware of, this means
that when adding a new attribute value, you need to reimport all values
including the new values on import jobs to make sure that the values
carry forward. Grrr.
whole list of attribute (IBA) values loaded in as well. Today, I wanted
to add an additional attribute to those parts. I defined my attribute in
the type manager and created a matching Excel load sheet but this time I
only added this new attribute column and its values to the right hand
side of the import sheet. Take a guess at what happened.
My assumption was that it would iterate the Part and set this new
attribute with the values from the import job. What I didn't expect was
that it CLEARED all the attribute values from the previous iteration and
import job. This is the kind of thing that should be documented no? So,
without any hidden preference settings that I am unaware of, this means
that when adding a new attribute value, you need to reimport all values
including the new values on import jobs to make sure that the values
carry forward. Grrr.