The problem, which you describe with index having period seems for me a bug. The same problem are described here and here. I can imagine that having periods in the index can be important if database schema used on the database, but having index with period in case of pure local data (not "json" datatype and loadonce:true) and can be replaced with jsonmap. So the bug in the case makes have a simple workaround. Which scenario has you?

Nevertheless it is absolutely another problem not connected with the "Microsoft" data format. You can post additional information to the bug report to remind Tony about the problem. I am not a developer of jqGrid and I am additionally busy for at least next two weeks. So please contact Tony about the problem yourself.

Best regards
Oleg 

You are correct, I did not expect the code to change from the /pattern/modifier to the RexExp object.

Is there a design document for this grid?  I just upgraded from 3.6.4 to 3.8.2 for the new date formatter and I found a bug and I would like to try my hand at fixing it.  This is the bug: if the value of index in a colModel contains a period e.g.: "Person.Name" the value passed (sidx) to the web service contains only "Name".  It worked in 3.6.4 but it was broken in 3.6.5.

Best regards,

NoWoL

do you tested the code published from in GitHub or it seems to you that the RegEx is wrong? I don't yet tested the code one more time, but now the RegEx is exactly like in the version which I used and tested many times with different data before I posted the information here.

Probably you use frequently the form /pattern/modifier of RegEx and not constructor of RegEx with the string literal. There are some difference in coding of backslashes in the two forms. See for example "How to Use The JavaScript RegExp Object" section of this.

If you will find a bug in the code you are welcome, but please test the code and post exactly which input data will be wrong converted by the code. Which result should be and which wrong result produce the code.

Best regards
Oleg 

I checked the RegEx code in GitHub and there is an error in the regular expression. 

You only need one backslash before the parentheses instead of two.

Cheers,

NoWoL

Also fixed in GitHub. 

Hope in the future to use GitHub for such kind of patches

Thanks again to all.

P.S. It is quite possible that this is not the last fix

Best Regards

Tony

Scott

I'm using jqGrid 3.8.2 to show data coming from a ASP.NET web service.

As far as I understood jqGrid natively understands MS DateTime Wire Format by default (since 3.8.2) and this is good, but it renders something like:

NaN/NaN/NaN

Probably I have to set some "magic" string to make jqGrid understand it is reading a MS DateTime ? Is there any particular configuration ?

Or probably we are talking about an open issue (because I read "will be fixed") ?

Thanks in advance,

Alex

Will be fixed. Thanks.

Tony

I agree - very frustrating

Many thanks,

Scott

It is very hard to here, but the forum software has really hard and evil bug. I tested carefully my code before past it here. Of cause I didn't verify the code character per character after the pasting. Not I see that from the original RegEx

"^\\/Date\\\\((([-+])?[0-9]+)(([-+])([0-9]{2})([0-9]{2}))?\\\\)\\\/$"

4 characters (4 backslashes) was cut and we have the text

"^\/Date\\((([-+])?[0-9]+)(([-+])([0-9]{2})([0-9]{2}))?\\)\/$"

in the code of jqGrid 3.8.2. Please try one more time with the RegEx

"^\\/Date\\\\((([-+])?[0-9]+)(([-+])([0-9]{2})([0-9]{2}))?\\\\)\\\/$".

I don't verified other parts of the code. I'm really frustrated. Moreover curently I have less free time as before.
It all will works OK.
I hope Tony will read the post and fix the code of jqGrid. If he write no comments in the next 7 days I'll post a new bug report.

Best regards and thanks one more time
Oleg

var msDateRegExp = new RegExp("^/Date\\\\((([-+])?[0-9]+)(([-+])([0-9]{2})([0-9]{2}))?\\\\)/$");

My apologies - a late night.

I am using jqGrid 3.8.2 and it is not working with a .Net DateTime. I get NaN/NaN/NaN.

When I posted the reg expression I did not notice that the forum was trimming a "".

I feel it should be - note the double "\" before the the "(":

var msDateRegExp = new RegExp("^/Date\\((([-+])?[0-9]+)(([-+])([0-9]{2})([0-9]{2}))?\\)/$")

Thanks,

Scott

but if you will read carefully the current thread, .NET DateTime format are supported starting with jqGrid 3.8.2 and not exist in jqGrid 3.8.1 which you use. Moreover in the code which I suggested and which is included in jqGrid 3.8.2 the msDateRegExp is already defined as

So it seems to me you should just use jqGrid 3.8.2.

Best regards
Oleg

jqGrid 3.8.1 is not working with the .Net DateTime for me. I think your line:

var msDateRegExp = new RegExp("^/Date\((([-+])?[0-9]+)(([-+])([0-9]{2})([0-9]{2}))?\)/$");

should be:

var msDateRegExp = new RegExp("^/Date\\((([-+])?[0-9]+)(([-+])([0-9]{2})([0-9]{2}))?\\)/$");

Note the extra escape characters - let me know what you think.

Regards,

Scott

Thanks for your assistance. Tony not wrote this information here, but he made the fix which I suggested (see here) and the corresponding feature is already a part of jqGrid 3.8.2 (see the last line in the list of "additions and changes" of the jqGrid 3.8.1 here).

Best regards
Oleg 

I would really like to see this feature too.

Oleg,

Thanks for writing this patch.

I made some more tests and improved my suggestion to have full support of the DateTime .NET format used by Microsoft for serialization in WFC, ASP.NET MVC or ASMX Web Services (so in all kinds of JSON DateTime serialization). The serialized format of DateTime class is described in the section "DateTime Wire Format" of http://msdn.microsoft.com/en-u.....12170.aspx.

The corresponding changes in the jquery.fmatter.js can be following. The lines 142-146

should be replaced to the following

The changes will be useful for all .NET developers. How you can see I use in the code RegExp matching, so I can really sure that the new piece of code will be executed only if the input is exactly in the correct "DateTime Wire Format" used Microsoft.

Best regards
Oleg

From time to time somebody ask why the date format like "/Date(1285128000000)/" are not suported by jqGrid. Today I answerd one more time on the question on the stackoverflow.

Why not make a small modification of the jquery.fmatter.js to support this? It seems to me that one need to add only two lines of code for example atfter the line 144:

if(date.constructor === Number) {
    timestamp = new Date(date);
} else if (typedef date === "string" && /^\/Date\(\d+\)\/$/.test(date)) {
    // Microsoft serialization format for date: "/Date()/"
    timestamp = new Date(parseInt(date.substr(6,date.length-8),10));
} else if(date.constructor === Date) {
    timestamp = date;

Bold text are the suggested lines. What do you think about this?

Best regards
Oleg