Lessons Learned from importing data for Parts with xClassification data and a thumbnail image

You bring up a couple of interesting points:

• Can it include logic such as IF statements that depend on the content of the file being imported (i.e. an SQL where condition doesn’t help here)
• Can one concatenate input data. See below where this would have been useful for loading the thumbnail images.
• Can one import files (e.g. image files) along with the data by using pointers to the file locations with the import sheet?

I really like the first idea. You can use some and/or/where statements, but the BatchLoader has it´s limits. It´s not uncommon to split the imports for this purpose and make multiple imports.

Regard 2nd one: Without having tested it, maybe this one would work: <thumbnail>vault://@1</thumbnail>
More easy approach: Already use correct format in your excel import file

Regard 3rd one:You can upload a local file in combination with an add/edit AML query. There are a couple of samples around in this forum.

Some tip: Watch your performance, cause vaulted images in Innovator often cause trouble, e.g. when you display the thumbnail column in the Pstz grid. When you have a lot of identical images and users shall be able to reuse them, use codetree images. You mentioned that you had trouble with the internal image picker where it doesn´t allow you do pick images in your customer folder. This is a minor bug in a few Innovator versions but easy to fix. 

Otherwise, thank you for your effort!