Ok, I have formatted the date in the stored procedure and returned as string. Now have another problem.
Seems that if the Web.Sitemap map contains external links, the otput gets formatted in wrong way when using Microsoft.Web.Preview.Search.AspNetSiteMapSearchSiteMapProvider
The result can be seen here: http://test.zikbay.com/SearchSiteMaps.axd?sitemap=Navigation
All the external links in web.sitemap show as follows:
1 - <url>
2 <loc>http://test.zikbay.comhttp://community.zikbay.com/blogs/features/default.aspx</loc>
3 </url>
Here are my settings from web.config:
1 <microsoft.web.preview>
2 <searchSiteMap enabled="true">
3 <providers>
4 <add name="Navigation" type="Microsoft.Web.Preview.Search.AspNetSiteMapSearchSiteMapProvider, Microsoft.Web.Preview" />
5 <add name="Ad" type="AdSiteMapData, App_Code" targetUrl="Ad" pathInfoFormat="true" queryStringDataFields="Id" targetUrlseparator="" lastModifiedDataField="ModifiedOn"/>
6 <add name="Ad2" type="AdSiteMapData2, App_Code" targetUrl="Ad" pathInfoFormat="true" queryStringDataFields="Id" targetUrlseparator="" lastModifiedDataField="ModifiedOn"/>
7 <add name="Category" type="CategorySiteMapData, App_Code" targetUrl="Category" pathInfoFormat="true" queryStringDataFields="Id" targetUrlseparator="" lastModifiedDataField="ModifiedOn" />
8 </providers>
9 </searchSiteMap>
10 </microsoft.web.preview>
This is my sitemap:
1
2 <siteMap>
3 <siteMapNode url="~/" title="Home" description="">
4
5 <siteMapNode url="default.aspx" title="Home" roles="*">
6 <siteMapNode url="Category/0" title="All Categories" description=""/>
7 <!--<siteMapNode url="Category/147412" title="Buy/Sell" description=""/>-->
8
9 <siteMapNode url="Green.aspx" title="Green" description=""/>
10 <siteMapNode url="Category/10542" title="Real Estate" description=""/>
11 <siteMapNode url="Category/147413" title="Jobs" description=""/>
12 <siteMapNode url="Category/316" title="Services" description=""/>
13 <siteMapNode url="Category/147402" title="Personal" description=""/>
14 <!--<siteMapNode url="Category/147447" title="Travel" description=""/>-->
15
16 <siteMapNode url="Category/hotels" title="Hotels" description=""/>
17 <siteMapNode url="LocationSearch_All.aspx" title="All Locations" description=""/>
18
19
20 <!--<siteMapNode url="Registering.aspx" title="Register" description=""/>
21 <siteMapNode url="Registering.aspx" title="Register" description=""/>
22 <siteMapNode url="Registering.aspx" title="Register" description=""/>
23 <siteMapNode url="Registering.aspx" title="Register" description=""/>
24 <siteMapNode url="Registering.aspx" title="Register" description=""/>
25 <siteMapNode url="Registering.aspx" title="Register" description=""/>
26 <siteMapNode url="Registering.aspx" title="Register" description=""/>-->
27 <!--<siteMapNode url="" title="" description=""/>-->
28
29 </siteMapNode>
30
31 <siteMapNode url="Category/147491" title="Coupons" roles="*">
32 </siteMapNode>
33
34 <siteMapNode url="Category/Buy-Sell" title="Buy/Sell" roles="*">
35 <!--<siteMapNode url="" title="" description=""/>-->
36 </siteMapNode>
37
38
39 <!--<siteMapNode url="Category/buysell/default.aspx" title="Buy/Sell" roles="*"/>
40 <siteMapNode url="Category/services/default.aspx" title="Services" roles="*"/>-->
41
42 <siteMapNode url="PostAd.aspx" title="Post FREE Ad" roles="*">
43 <siteMapNode url="" title="" description=""/>
44 </siteMapNode>
45
46 <siteMapNode url="MyAds.aspx" title="My Ads & Profile" roles="*">
47 <siteMapNode url="MyProfile.aspx" title="My Profile" roles="*" />
48 <siteMapNode url="user/userwebsitesettings.aspx" title="My Store/Website" roles="*" />
49
50 <siteMapNode url="Login.aspx" title="Sign In" roles="*" />
51 <siteMapNode url="Register.aspx" title="Create an Account" roles="*" />
52 </siteMapNode>
53
54 <siteMapNode url="Admin/Default.aspx" title="Site Administration" roles="Administrators">
55 <siteMapNode url="Admin/Settings.aspx" title="My Profile" roles="Administrators" />
56 </siteMapNode>
57
58 <siteMapNode url="http://Community.zikbay.com" title="Community" roles="*">
59 <!--<siteMapNode url="" title="" description=""/>-->
60 </siteMapNode>
61
62 <siteMapNode url="Help/Help.aspx" title="Help" roles="*">
63 <siteMapNode url="Help/Registering.aspx" title="Register" description=""/>
64 <siteMapNode url="Help/PostingAd.aspx" title="Post Ad" description=""/>
65 <siteMapNode url="Help/PostingHotelAd.aspx" title="Post Hotel Ad" description=""/>
66 <siteMapNode url="Help/UserStore.aspx" title="User Store/Website" description=""/>
67 <siteMapNode url="Help/FAQ.aspx" title="Questions" description=""/>
68 <siteMapNode url="Help/AvoidScam.aspx" title="Avoid Scam" description=""/>
69 <siteMapNode url="Help/Terms.aspx" title="Terms" description=""/>
70 <siteMapNode url="Help/PrivacyPolicy.aspx" title="Privacy" />
71
72 <siteMapNode url="http://community.zikbay.com/blogs/features/default.aspx" title="What is New" roles="*"/>
73
74 </siteMapNode>
75
76 </siteMapNode>
77 </siteMap>
78
I think this is a bug in SiteMapSearch provider. It just does not work with external links in web.sitemap.
The only solution I can see would be to create another class and generate entries for Web.Sitemap in Google sitemap format by using my own Class like I did with ads and categories.
Please recommend