I'm importing from a CSV, data that looks like this:
"Created","Alias","Name","Content","Category"
"2015-03-05 10:58:38","banners-bands-and-bitter-pills-comes-to-town","Banners, Bands and Bitter Pills comes to Barnsley","HTML CONTENT HERE","News"
In the settings for the Created field, I'm specifying the date format yyyy-MM-dd HH:mm:ss but when I review the import (which seems to work great), the Created date just shows the date and time that I ran the import.
I'm using CMS Import 3.0.1 with Umbraco v7.2.2 Assembly 1.0.5529.18522 which I appreciate isn't marked as a supported platform yet but thought it best to highlight it and make sure I'm not just doing something wrong.
It could be a caching issue maybe? Since Umbraco will always handles the create date I uses a Database call to update the date field directly. Could you try to see if it's fixed after an IIS reset? I assume you don't use any events?
Unfortunately not. I've imported just 10 items this morning and then closed down the solution / IISEXPRESS instance and restarted both. The dates remain as today though.
A quick peak in the database at the cmsContentXML table confirms it:
You are right. I have tested with unpublished data, but the publish action overwrites the value. Work around for now could be to not publish the data that is being imported. I will see what I can do about this.
You're absolutely right. With the "Publish automatically" box unchecked, it sets the creation date correctly. Last edited date reflects today which is appropriate too.
I can then just simply mass publish inside Umbraco.
Not setting the Created Date
Hi,
I'm importing from a CSV, data that looks like this:
"Created","Alias","Name","Content","Category"
"2015-03-05 10:58:38","banners-bands-and-bitter-pills-comes-to-town","Banners, Bands and Bitter Pills comes to Barnsley","HTML CONTENT HERE","News"
In the settings for the Created field, I'm specifying the date format yyyy-MM-dd HH:mm:ss but when I review the import (which seems to work great), the Created date just shows the date and time that I ran the import.
I'm using CMS Import 3.0.1 with Umbraco v7.2.2 Assembly 1.0.5529.18522 which I appreciate isn't marked as a supported platform yet but thought it best to highlight it and make sure I'm not just doing something wrong.
Thanks
Rich
Hi Richard,
It could be a caching issue maybe? Since Umbraco will always handles the create date I uses a Database call to update the date field directly. Could you try to see if it's fixed after an IIS reset? I assume you don't use any events?
Best,
Richard
Hi Richard,
Unfortunately not. I've imported just 10 items this morning and then closed down the solution / IISEXPRESS instance and restarted both. The dates remain as today though.
A quick peak in the database at the cmsContentXML table confirms it:
The date on that particular item should be 2015-02-26 12:13:46.
Rich
Hi Richard,
You are right. I have tested with unpublished data, but the publish action overwrites the value. Work around for now could be to not publish the data that is being imported. I will see what I can do about this.
Best,
Richard
Hi Richard,
You're absolutely right. With the "Publish automatically" box unchecked, it sets the creation date correctly. Last edited date reflects today which is appropriate too.
I can then just simply mass publish inside Umbraco.
Thanks for your help.
Rich
Hi Rich,
The release that contains the fix is available now. (3.1.1)
Best,
Richard
Thanks Richard, that's great!
is working on a reply...