Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events
SOLVED

How to set expiration date via csv update?

Avatar

Level 1

I have hundreds to assets in a folder I need to set the Expiration date to expire. 

 

To do this, I need to set the field prism:expirationDate{{Date}} in a csv import process. This would entail setting all 100ish fields of 

prism:expirationDate{{Date}} with the same value. 

 

I've set the date to 2021-10-07T17:13:00-07:00 and for some reason the csv doesn't change. I know you need to set the value to a date in the present/future.

 

Am I doing something wrong with the date? Does the "T" value here cause a csv import to have problems? Has anyone else ever done this?

 

Cheers, 


JD

1 Accepted Solution

Avatar

Correct answer by
Level 4

Hi @jdvhflute ,

 

I was able to bulk update the prism:expirationDate{{Date}} for assets using date in the format "2021-08-30T01:00:00.000-00:00". Hope it helps!

 

Regards,

Manpreet

View solution in original post

3 Replies

Avatar

Correct answer by
Level 4

Hi @jdvhflute ,

 

I was able to bulk update the prism:expirationDate{{Date}} for assets using date in the format "2021-08-30T01:00:00.000-00:00". Hope it helps!

 

Regards,

Manpreet

Avatar

Level 1

This is brilliant, THANK YOU!

 

Would you also know how to mass remove the expiration date / set to Null? I've tried to set the field to " ' " and the field doesn't change.

 

Cheers, 

 

JD

Avatar

Level 4

Did you also try by keeping the column value empty for the date in bulk import?

 

Regards,

Manpreet