Import_asset_csv_to_matrix.php metadata date format


(Nic Hubbard) #1

I am using the import_asset_csv_to_matrix.php script and need to set a metadata date field. However, I cannot figure out the format that it is expecting, so that date always gets set incorrectly. Here is the format I am giving it:

2010-12-23 00:00:00

What format is it expecting when setting a Metadata date field?


(Nic Hubbard) #2

Anyone? Really need to figure this out. I cannot find it documented anywhere.


(Nic Hubbard) #3

Update. The date does seem to get set, and it looks correct before I get locks:

 

Screen-Shot-2016-03-23-at-9.31.26-AM.png

 

But when getting the locks, the date is incorrect and doesn't seem to respect the year:

 

Screen-Shot-2016-03-23-at-9.31.33-AM.png

 

Ideas on what could be going wrong?


(Nic Hubbard) #4

Update:

 

I figured it out. The metadata date field had a Min year default set to 2016, so 2010 wasn't allowed. Don't I feel silly now. :)