We have added a date field to the Extended Content for a Product using the standard Date Picker (Umbraco.Date).
If we select 5 Jan 2016, the value appears to save correctly and the date field on the Content tab shows 2016-01-05. However, when you refresh the page, the date field then shows 2016-05-01, so it appears that the date is being saved incorrectly as 1 May 2016.
I've tried changing the Date Format in the Merchello Settings page to see if that solves the problem, but date is still saved incorrectly.
The Date Picker saves the date correctly when added to a standard Umbraco page.
I've bumped the priority of this issue to be addressed in the next release (but it's a big release so it will be a while before it's actually packaged). I think the problems are going to be inconsistencies in the actual datatypes as Merchello is literally only saving data that the datatype itself gives it.
I've compared the same date data type in umbraco and merchello tables.
In cmsContentXml table umbraco stores date value in default format (YYYY-MM-DD). But i use "custom" format for current data type (e.g. DD-MM-YYYY).
In merchProductVariantDetachedContent merchello stores date in DD/MM/YYYY format always! However, if i change manually the date in current table to default format, merchello shows date correctly in extended content.
Tags data type does not work as well... It inserts object type "System.Linq.Enumerable+WhereSelectEnumerableIterator`2[Newtonsoft.Json.Linq.JToken,System.String]" in merchProductVariantDetachedContent table
@proproger - I don't think we'll ever be able to get the tags property to work with virtual content as it requires an actual content Id. Is there a way for you to use a custom property editor for this case?
I was just testing merchello extended content, if it will work in my case.
I have something different for this. I'm inserting/updating product data programmatically using custom document type, which contains information about merchello product. It's not the best way ofc, as system contains duplicate information about product in merchello tables and umbraco content as well, but at least it works for all data types
Issue with Date Picker and Merchello
We have added a date field to the Extended Content for a Product using the standard Date Picker (Umbraco.Date).
If we select 5 Jan 2016, the value appears to save correctly and the date field on the Content tab shows 2016-01-05. However, when you refresh the page, the date field then shows 2016-05-01, so it appears that the date is being saved incorrectly as 1 May 2016.
I've tried changing the Date Format in the Merchello Settings page to see if that solves the problem, but date is still saved incorrectly.
The Date Picker saves the date correctly when added to a standard Umbraco page.
Can you write this up as an issue in http://issues.merchello.com
Hi Rusty,
Almost the same issue is with CheckBox List DataType...
Done - Issue # : M-926
Hi Lesley,
Any update on this?
Hey guys,
I've bumped the priority of this issue to be addressed in the next release (but it's a big release so it will be a while before it's actually packaged). I think the problems are going to be inconsistencies in the actual datatypes as Merchello is literally only saving data that the datatype itself gives it.
Hi Rusty,
I've compared the same date data type in umbraco and merchello tables. In cmsContentXml table umbraco stores date value in default format (YYYY-MM-DD). But i use "custom" format for current data type (e.g. DD-MM-YYYY).
In merchProductVariantDetachedContent merchello stores date in DD/MM/YYYY format always! However, if i change manually the date in current table to default format, merchello shows date correctly in extended content.
@progproger - Really appreciate you digging into that a bit and awesome info!
Hi Rusty,
Tags data type does not work as well... It inserts object type "System.Linq.Enumerable+WhereSelectEnumerableIterator`2[Newtonsoft.Json.Linq.JToken,System.String]" in merchProductVariantDetachedContent table
@proproger - I don't think we'll ever be able to get the tags property to work with virtual content as it requires an actual content Id. Is there a way for you to use a custom property editor for this case?
Hi Rusty,
I was just testing merchello extended content, if it will work in my case. I have something different for this. I'm inserting/updating product data programmatically using custom document type, which contains information about merchello product. It's not the best way ofc, as system contains duplicate information about product in merchello tables and umbraco content as well, but at least it works for all data types
is working on a reply...