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

Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X

Import from Spreadsheet observation

avillanueva
22-Sapphire I

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.

5 REPLIES 5

We found that as well.

Super big issue when you don't have the original load sheets... Very prone to errors in re-creating.

Agree, at a minimum it should be documented in 87 font bright red.

It might. Its not possible to remember everything. Quick check. Nope
didn't see it but it might be there in legalese. I'd recommend Mike's
suggestion.


I had to do the same thing on hundreds of documents. Had to use info-engine task and jsp to get around the problem.

Rey

We ended up writing our own Import Action Handler by customizing it. We had big mess in production because of this issue.

-Nirmesh

Now, that's just not fair. I corrected my load files to provide all the
attributes all over again with the new changes I needed. It processed
them at 6.7 seconds per item. Not 6.7 items per second, one item every
6.7 seconds (on average)! Oh, and I got saddled with half a gig in log
files. Too slow. Just way too slow. Load file was about 1000 parts with
37 attribute columns (not including the mandatory ones). Need to look
for another way.


Top Tags