Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

CSV Asset Importer - Import multi field items in metadata of asset

sagarv13144480
Level 3
Level 3

Hi All,

I want to import asset metadata using asset importer. But few of the metadata has multifield dialouge.

Like for a multifield value we use {{Type : multi }}

But is there any way to create structure like below using csv asset importer.

1718506_pastedImage_0.png

I am able to create till item 0 by writing ../metadata/links/item0 in my csv, but when I am giving one more for creating item1 i.e ../metadata/links/item1

It is overriding item 0 and creating item1.

1 Accepted Solution
Hemant_arora
Correct answer by
Level 8
Level 8

How many such item nodes are there under links node ? if only 2 then you have to update one by one.

first create column like this  ../jcr:content/test/item0/value {{ Long }}

upload the sheet and import.

then rename the column name to  ../jcr:content/test/item1/value {{ Long }}, update the values in rows

upload the sheet and select delta and import.

View solution in original post

0 Replies
Gaurav-Behl
Community Advisor
Community Advisor

Did you try CSV Asset Importer?

Multi-values

If a row is marked as multi via propertyName {{ Type : multi }}, multi-values are delimited by default via |. The multi-value delimiter is configurable via the Web UI.

  • Since v0.0.28 CSV Asset Importer supports changing property types from Single to Multi (and vice versa). Note that the data in the CSV will replace any existing data at the defined property (This is not a Patch operation)
  • Since v0.0.28 CSV Asset Importer handles changing existing Multi properties to single value, and vice-versa. Any prior values will be removed (this is not a Patch operation, rather a remove and add).
sagarv13144480
Level 3
Level 3

So you mean to say it will remove item 0 and add the node item 1 that I am trying in my case?

Hemant_arora
Correct answer by
Level 8
Level 8

How many such item nodes are there under links node ? if only 2 then you have to update one by one.

first create column like this  ../jcr:content/test/item0/value {{ Long }}

upload the sheet and import.

then rename the column name to  ../jcr:content/test/item1/value {{ Long }}, update the values in rows

upload the sheet and select delta and import.