Import "packaging components" using a CSV file

[pajorelo]

I'm trying to import elements using a CSV file but I'm not been able to import an element of type "Packaging Component". I already imported Package and Component elements but I don't know which type should I put in the CSV file in order to import an element of type "Packaging Component".

Does anyone know how to do it?

Thanks in advance.

[Paolo F Cantoni]

Hi!

Create a packaging component in the model and see what the t_object table contains.  That should provide the information you need.

HTH,
Paolo

[pajorelo]

Thank you so much for your tip.

The problem is that the Type for a Package and for a Packaging Component is exactly the same: Package.

But using your tip about the t_object table I built a custom search that allowed me to find the single difference between a Package and a Packaging Component which is the field NType. A Package has NType=0 and a Packaging Component has NType=20.

Now the issue is how to set the attribute NType in a CSV import file because the NType attribute (or something similar) is not available in the CSV Import/Export Specification fields' list.

[Geert Bellekens]

Pajorelo,

If I were you I would quickly write my own import tool.
You can you the excel vba import tool I've published on the community site as a basis.

Geert

[pajorelo]

Thanks Geert.

Unfortunately I don't have download access to the file or any file of the scripts session for that matter.

Do you know how can I get access?

pajorelo

[Geert Bellekens]

You'll need to create an (community site) account to access the community resources.

Geert