How to set expiration date via csv update? | Community
Skip to main content
J
jdvhflute
October 8, 2021
Solved

How to set expiration date via csv update?

  • October 8, 2021
  • 1 reply
  • 1936 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by manpreetk908

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

1 reply

manpreetk908
manpreetk908Accepted solution
Level 4
October 8, 2021

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

    J
    jdvhfluteAuthor
    October 14, 2021

    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

      manpreetk908
      manpreetk908
      Level 4
      October 15, 2021

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

       

      Regards,

      Manpreet

        Terms & ConditionsAccessibility statement

        Loading footer...