[Central Scrutinizer]

I’m adding a new matrix parent with a few children. However, there are two item options that need to be selected. Does anyone know how to format that in the csv what you use.

I’ve tried using a comma, and a comma with no space and neither worked.

My Finish, My Hardware

My Finish,My Hardware

Thanks in advance
This is a cached copy. Click here to see the original post.

[caren]

RE: Import New Matrix Item with multiple Item options

Use the pipe symbol:

My Finish | My Hardware

The pipe symbol will allow you to select multiple entries in a multi-select field.

Regards,

Caren

[OniNoKami]

RE: Import New Matrix Item with multiple Item options

When importing Matrix Items, you file will need to be something like this

Name,Parent,Matrix Type,Matrix Option – Finish,Matrix Option – Hardware

Item A,,Parent Matrix Item,Fine,None

Item A-12,Item A,Child Matrix Item,Matte,1

Parent Matrix and Child Matrix are defined values. The options Finish and Hardware should be setup first prior to the import of the item along with the values for each option

[caren]

RE: Import New Matrix Item with multiple Item options

Originally posted by OniNoKami

View Post

Name,Parent,Matrix Type,Matrix Option – Finish,Matrix Option – Hardware

Item A,,Parent Matrix Item,Fine,None

Item A-12,Item A,Child Matrix Item,Matte,1

Here’s a more complete CSV file format:

Name,Parent,Matrix Type,Matrix Option – Finish,Matrix Option – Hardware,Subitem Of

Item A,,Parent Matrix Item,Fine,None,

Item A-12,Item A,Child Matrix Item,Matte,1,Item A

Don’t forget to include the Subitem Of column field. You enter the parent item under this column for the child items.

[Central Scrutinizer]

RE: Import New Matrix Item with multiple Item options

The pipe did the trick. Thanks!

[Author]

Posts