Guriddo » Topic: sopport for “Microsoft” date format: “/Date(1285128000000)/”

sopport for “Microsoft” date format: “/Date(1285128000000)/”

Guriddo
sopport for “Microsoft” date format: “/Date(1285128000000)/”

This topic has 17 replies, 6 voices, and was last updated 15 years, 3 months ago by OlegK.

Creator

Topic
September 23, 2010 at 12:14 am #77195

OlegK
Participant

Hello Tony!

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) {
Creator

Topic

Viewing 15 replies - 1 through 15 (of 17 total)

1 2 →

Author

Replies
December 9, 2010 at 2:55 pm #96867

OlegK
Participant

Hello Tony!

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-us/library/bb412170.aspx.

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

if(date.constructor === Number) {

December 19, 2010 at 8:04 pm #96938

zippy1981
Participant

Tony,

I would really like to see this feature too.

Oleg,

Thanks for writing this patch.

December 20, 2010 at 1:16 am #96940

OlegK
Participant

Hello zippy1981,

Thanks for your assistance.

January 4, 2011 at 9:15 am #97046

sugden
Participant

Hi Tony/Oleg,

jqGrid 3.8.1 is not working with the .Net DateTime for me.

January 4, 2011 at 2:33 pm #97049

OlegK
Participant

Sorry 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

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

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

Best regards
Oleg

January 4, 2011 at 9:28 pm #97060

sugden
Participant

Hi Oleg

My

January 4, 2011 at 9:29 pm #97061

sugden
Participant

Ah – Its done it again. Lets try:

var

1

var

January 4, 2011 at 11:39 pm #97063

OlegK
Participant

Thank you very much 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}))?\$\/$"

1

"^\/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}))?$/$"

1

"^/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}))?\$\/$".

1

"^\/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

January 5, 2011 at 12:27 am #97064

sugden
Participant

Oleg,

I agree – very frustrating

Many thanks,

Scott

January 9, 2011 at 2:25 pm #97085

tony
Keymaster

Hello,

Will be fixed. Thanks.

Tony

January 11, 2011 at 4:16 pm #97102

typhoon1978
Participant

Hi all !

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

January 13, 2011 at 3:16 am #97121

sugden
Participant

It's the same (open) issue. Tony has noted that it will be fixed.

Scott

January 15, 2011 at 3:11 pm #97142

tony
Keymaster

Hello,

Also fixed in GitHub.

January 16, 2011 at 8:01 pm #97171

nowol
Participant

Hi,

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

January 16, 2011 at 11:59 pm #97175

OlegK
Participant

Hi 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
Author

Replies