Using Excel Spreadsheet to autopopulate metadata on assets in AEM 6.5

Avatar

Avatar
Level 1
markherbalife
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
markherbalife
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
markherbalife
Level 1

01-07-2020

Hello. Our company is currently using AEM 6.5.

 

We want to auto-populate metadata for ingested assets via spreadsheet, bypassing our current manual metadata tagging.

 

I know this is possible because our Adobe Consultant has shared this information.

 

I’m sure I'm oversimplifying things, but it seems that much of the heavy lifting involves creating formulas on the spreadsheet file that would translate the metadata on the spreadsheet into the language that AEM uses.

 

Has anyone used this functionality successfully? I would really appreciate it any details that you could share.

 

Mark W. Holmes

Herbalife Nutrition
Los Angeles, CA.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
Veena_Vikram
MVP

Likes

484 likes

Total Posts

1,049 posts

Correct reply

121 solutions
Top badges earned
Establish
Coach
Contributor 2
Seeker
Ignite 5
View profile

Avatar
Establish
MVP
Veena_Vikram
MVP

Likes

484 likes

Total Posts

1,049 posts

Correct reply

121 solutions
Top badges earned
Establish
Coach
Contributor 2
Seeker
Ignite 5
View profile
Veena_Vikram
MVP

01-07-2020

Hi @markherbalife 

    You are right. There is an inbuilt feature in AEM Assets for importing the metadata. You can find the same along with a video tutorial here 

https://docs.adobe.com/content/help/en/experience-manager-learn/assets/metadata/metadata-import-feat...

 

Hope this helps. Let us know if you have any more questions.

Veena

Answers (0)