Change Date Format from US to UK in WSS

[Pete Smith]

Hi,

I'd like to change the date format within the Issue List a.s.o. from US to UK.

When I change the Locale area of the Regional Settings page to UK and
synchronize users afterwards, I get the error:

"Failed to synchronize users between Project Server and the selected Windows
SharePoint Services site. XML document must have a top level element."

The KB Article 884454 available under

http://support.microsoft.com/default.aspx?scid=kb;en-us;884454

does not help, because there's no dedicated site template for UK available

What can I do?

Thanks in advance for any advice

Pete

 

[Denis in Brisbane]

Pete,
Sounds like the exact problem I have. See my post from 30 Jan.

I was very sceptical whether it would work but I tried today following the
instructions and downloading French. I got the language, but no template,
even after running WSSWIZ.EXE.

It didn't work though; I still have the problem. My workaround works but
it's not acceptable.

If you find a solution, I'll be very interested to hear it.

Denis

 

[Novica B]

Denis and Pete,
I had the same problem and we worked it out with some help from a few other
people. I tried to install language packs and all the rest of it as well.
The following file if modified STSADUTL.ASP, sets the correct language code
for Australia.

Make a copy of the file at the following location:
\Program Files\Microsoft Office Project Server 2003\IIS Virtual
Root\DOCLIB

and past the new one in.

The difference should only be a section near the end
of the file, in a function called StsAdminUtil_GetStringForSiteLCID.
This is all that was added to include LCID (a.k.a. language identifier)
for English (Australia):

if (sWSSTemplateLCID=="2057")
{
sWSSTemplateLCID="1033";
}
if (sWSSTemplateLCID=="3081")
{
sWSSTemplateLCID="1033";
}

They say that this is only a workaround.


Novica

 

[Denis in Brisbane]

Novica,
Thanks a lot for that.

Just to confirm:
I inserted the code you suggested immediately before the line saying:

this.oStrSiteLCID = this.LoadDoclibStringTable(sWSSTemplateLCID);

Now I find that if I set the language to English (Australian) I get the date
format as DD/MM/YYYY but synchronisation now works, whereas before it failed.

(I wasn't sure whether the change was to fix the date format or make
synchronisation work if the language was reset to get dates in the right
format).

Your blood's worth bottling!

Denis

 

[Novica B]

Denis,
The amendment to the file fixes both problems.

and your script should look like this...to the end of the script.


function StsAdminUtil_GetStringForSiteLCID(nStringID, sWebUrl)
{
if(this.sGetStringWebURL != sWebUrl)
{
this.sGetStringWebURL = sWebUrl;
var sWSSTemplateLCID = GetSiteTemplateLCID(sWebUrl);

if(!sWSSTemplateLCID || (typeof(sWSSTemplateLCID) == "undefined") ||
(sWSSTemplateLCID == 0))
{
sWSSTemplateLCID = oLocalizedStrings.sLCID;
}

if (sWSSTemplateLCID=="2057")
{
sWSSTemplateLCID="1033";
}

if (sWSSTemplateLCID=="3081")
{
sWSSTemplateLCID="1033";
}

this.oStrSiteLCID = this.LoadDoclibStringTable(sWSSTemplateLCID);
}

return this.oStrSiteLCID.GetString(nStringID);

}


function StsAdminUtil_LoadDoclibStringTable(sLCID)
{
var nLCID = Number(sLCID);
if(typeof(this.aStrLCID[nLCID]) != "undefined")
{
return this.aStrLCID[nLCID];
}

var oLocStrings = new LocalizedStrings(sLCID);
this.aStrLCID[nLCID] = oLocStrings.LoadStringTable(IDST_DOCLIB);

return this.aStrLCID[nLCID];

}

%>

<%// Copyright© 1990-2002 Microsoft Corporation. All rights reserved.%>