WSS 3.0: Current date in calculated fields

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Windows Services
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - IE 7 crashes in WSS2.0 Hello: The browser crashes with the following error in the Event Log whenever I try to open any document (Word, Excel, Powerpoint) in a document library using IE7; however the same documents open fine suing IE6. The documents have been created and uploaded to WSS using Office 2003 but are being opened in Office 2007. *** Error***** EverFaulting application iexplore.exe, version 7.0.5730.11, faulting module kernel32.dll, version 5.1.2600.2945, fault address 0x00012a5b. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. ****** Is this caused due to a mismatch in the default file types for Office 2003 versus Office 2007? I have potentially 4000-5000 users that may have issues opening many of the documents. Any help is greatly appreciated. Thanks, -- ashok Tag: WSS 3.0: Current date in calculated fields Tag: 56421
  - 2
    - Nonduplicate list values Hi, Can anyone guide me to how and where I can find information on creating lists that don't accept duplicate values, like setting a primary key on a list column or something. thanks rooz Tag: WSS 3.0: Current date in calculated fields Tag: 56420
  - 3
    - Consolidate Blogs Playing around with STS ver 3, and like the new blog feature. Is there a way to display consolidated the multiple blogs that may be on my site into on view. I was thinking displaying the last 10 blog entries from any one of the 10 blogs that will be listed. At first I thought there would be a web part but could not find a obvious one. Then I tried to add the Blog's RSS feed to the default page. Any suggestions? I like the RSS way, because in theory I could add external RSS feeds also. (Baby steps, got to remember baby steps) Thanks in Advanced! -- Keith Templin ktemplin@templintek.REMOVEME.com This post is based on my past experiences, and is free. You get what you paid for, no warranty implied. -- Tag: WSS 3.0: Current date in calculated fields Tag: 56419
  - 4
    - Dataview webpart DVWP to find Username of current user I would like to use the frontpage dataview web part on a WSS page to pick up the username (not the domain\username) bit of the current user and query the Sql profile database to pull up extra infomation (name, Date of birth etc) and show that in the Dataview webpart. I have created the database connection and the queryand I have created the filter 'Username equals [Current user]' .Username is a field name that contain username (without the domain name attached) in the database. The dataview webpart returns no records found even though the users have information in the database. Change the filter to a known username, the DVWP returns the user's record ok It does not seem to pick up and compare the logged on user's username and that in the database well. Any help. Tag: WSS 3.0: Current date in calculated fields Tag: 56415
  - 5
    - incoming e-mail I'm not able to do any testing yet on the incoming e-mail settings but I was wondering if you have incoming e-mail configured for a certain document library, would it be possible to remove the emails from the mailbox when they are automatically moved into the shared library? I basically don't want to clog up the exchange server and a shared library. TIA, Jackson Tag: WSS 3.0: Current date in calculated fields Tag: 56414
  - 6
    - Access to fully qualified name forces login dialogue v3 I have sharepoint services v3 installed. I created a new site: http://fp1/sites/whrservices. Which works great. However, if I use the url http://fp1.mydomainname.com/sites/wharservices.com I get prompted with an authentication dialogue box. So I enter my credentials, click the save password setting and I'm in. However, I always get prompted. What obvious thing am I missing?? Tag: WSS 3.0: Current date in calculated fields Tag: 56412
  - 7
    - MOSS 2007 - Grouping list by weeks Is it possible to extract the "week" value from a date so that I can group a list view by week? I want to display too much information for a cal view, and grouping by week is pretty clutch. Any ideas are apperciated. Thanks! Tag: WSS 3.0: Current date in calculated fields Tag: 56409
  - 8
    - Upload file using Explorer View when "'Require documents to be checked out before they can be edited" is used Hi, I am using WSS3 and I just activated the 'Require documents to be checked out before they can be edited?' option. Now when I upload a file I am asked to check the file in ... But if I do use the Explorer View to store files on my Sharepoint I am not able to check them in and they will not appear in the document view ! What am I doing wrong ? Thanks, Ark Tag: WSS 3.0: Current date in calculated fields Tag: 56408
  - 9
    - Site Search Pro Gold 2.0 We have come across a typical problem with Site Search Pro Gold 2.0 - Any text/word/searchkey having apostrophe mark are not getting indexed by the system as the search result is not displaying any of them. For example: If we have a paragraph in a page A as "I have a big brother named Apurba. Apurba's attitude towards work is very nice. Apurba is also fond of Music." and another page B having a paragraph as "Apurba's achievements are numerous and scores are high." Now when we search for Apurba, only page A is appearing in the search result with the following highlighted. "I have a big brother named Apurba. Apurba's attitude towards work is very nice. Apurba is also fond of Music." but the word Apurba's is NOT at all considered and also PAGE B is not listed in the search result. Further, if we search for Apurba's, no search result is displayed. Please note in both the cases, we have NOT done exact word search. We feel there is a problem with the engine doing the indexing of the pages. If anybody has solution using Site Search Pro Gold 2.0 itself, please let us know. It is quite URGENT. Tag: WSS 3.0: Current date in calculated fields Tag: 56405
  - 10
    - old alerts Wss V2.0 On Windows Sharepoint Services V2.0. , users are complaing me about old alerts,they have received them already, so they receive for some items a duplicate alerts. First alert is OK, but the second is FAKE. It is possible that SPTimer sends them after reboot? Is there any information or tutorial how to avoid this. Best regards. Tag: WSS 3.0: Current date in calculated fields Tag: 56404
  - 11
    - Changing a library to xslt data view If I have a library that contains an edit field, every time i try and convert the library webpart to an xslt dataview in sharepoint designer, I get an error message saying there is an invalid xslt stylesheet. Invalid character. If I remove the edit field, it converts to a data view with no problem. Does anyone know how to convert the webpart with the edit field? Also, I know you can have a field right click and choose edit but I need the edit column to make the site consistent with the way it already works for the existing lists. Tag: WSS 3.0: Current date in calculated fields Tag: 56403
  - 12
    - Folder Name Length for Explorer View Hi, This is my update from my previous post for upload file not being shown in explorer view and I have a couple of questions for the below: I have found that I need to close the IE browser, open a new browser and access the document library list with Explorer View, it will then show my new uploaded file. 1.So is there any way not to reopen the browser in order to see get both views updated? Is there any cache for the Explorer View? And may I know is there any folder name length limit in the SharePoint Document Library? Because I noticed that when I have a folder name with a length of around 50 characters, it gives me a page cannot be display when I change the view to Explorer View...However, I can navigate to this folder from its' top folder in Explorer View...So from my inverstigation, I found out that if the folder name length is more than 40, I cannot change the view to Explorer View from the All Documents view of the current folder(the one with long name).. But when I navigate to the folder with the name length of 50, from the top folder in Explorer View, it does not gives me the page cannot be displayed error page..It just works fine through this channel. 2. So is there any restriction on the folder naming length for changing to Explorer View from All Documents View? Thanks. Tag: WSS 3.0: Current date in calculated fields Tag: 56397
  - 13
    - Upload File not shown Explorer View Hi, I am using WSS v3 and when I was trying to upload a .dwg file to my document library list from the normal single file upload form ie. All Documents View, I noticed that when i changed the view to Explorer View, the uploaded .dwg file is not being shown..but it does shown in the All Documents View. I actually did some testings..Here is it: 1. Create a new document library 2. Upload a .dwg file from normal single file upload form 3. Change the view to Explorer View, the uploaded .dwg file being shown. 4. Upload any file again to the document library using single file upload form, change the view to Explorer View, it only shown the first .dwg file uploaded in steps 2. All subsequent uploaded files doesn't shown in Explorer View. Is this a bug in the Explorer View when uploading a .dwg file to the document list? Thanks. Tag: WSS 3.0: Current date in calculated fields Tag: 56396
  - 14
    - InvalidOperationException Hello, I just installed SharePoint Services 2.0 on Server 2003 (both with the latest updates). When I open SharePoint Services I receive the following error: System.InvalidOperationException: Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\rmqdauor.0.cs' could not be found error CS2008: No inputs specified at Microsoft.UpdateServices.Internal.ClassFactory.CallStaticMethod(Type type, String methodName, Object[] args) at Microsoft.UpdateServices.Internal.BaseApi.Subscription.GetSynchronizationHistory(DateTime fromDate, DateTime toDate) at Microsoft.UpdateServices.Internal.BaseApi.Subscription.GetLastSynchronizationInfo() at Administration.Manage.Subscriptions.SubscriptionProxy.GetSynchronizationStatus() at Administration.Manage.Toc.GetTasksHtml() at Microsoft.UpdateServices.Internal.ClassFactory.CallStaticMethod(Type type, String methodName, Object[] args) at Microsoft.UpdateServices.Internal.BaseApi.Subscription.GetSynchronizationHistory(DateTime fromDate, DateTime toDate) at Microsoft.UpdateServices.Internal.BaseApi.Subscription.GetLastSynchronizationInfo() at Administration.Manage.Subscriptions.SubscriptionProxy.GetSynchronizationStatus() at Administration.Manage.Toc.GetTasksHtml() Specifically I get this message within the Computer Options section. No computers are showing up under the Computers. Updates are synchronizing correctly and approve appropriatly. JCLSB Tag: WSS 3.0: Current date in calculated fields Tag: 56395
  - 15
    - WSS 3.0 upgrade, stand-alone problem Hi everyone, in this moment we have SharePoint 2.0 with companywebs migrated into SQL 2005. I want to install WSS v 3.0 on our SBS 2003 R2 SP1 Premium PL server as a side-be-side installation according to Microsofts whitepaper. I have problem on Step 2 point 4b â??On the Server type tab, ensure that Stand-alone is selectedâ?? because Stand-alone option is not allowed. The â??web front endâ?? is only one active option. What is reason? Anyone know what can I do? Best Regards, Jakub Tag: WSS 3.0: Current date in calculated fields Tag: 56393
  - 16
    - sharepoint: file locked issue Hi all, I had a weird case, once a while a checked out spreadsheet, during editing, Excel frozen up, then the file gets locked up. Is it share point problem or because Excel corrupt, then it locks the file. Any Excel always corrupt when using with sharepoint, and it never corrupt for local spreadsheet editing. please advise. Tag: WSS 3.0: Current date in calculated fields Tag: 56392
  - 17
    - Site Actions Problem I recently used smigrate to move some content as a template over to a new server etc etc. Running WSS 3.0. I have created a site eg /site and if I go to Site Actions--->Create I get the usual list of Libraries, Communications, Tracking, Custom Lists and Web Pages. However, if i goto /site/migratedweb, and then to Site Actions--- >Create, I only get Tracking and Custom Lists where tracking only contains Agenda. (This web is a team meeting one). All the others such as the ability to create a document library or discussion board are missing. If I create a new web (team meeting one) under /site/newweb and then go to Site Actions--->Create, I get all of this. Therefore it seems the migration process missed the templates or ignored the default ones. Any ideas appreciated! Chris Tag: WSS 3.0: Current date in calculated fields Tag: 56389
  - 18
    - listbox databind problem web part. Hi, I have rather a simple webpart that has a listbox with two buttons - one to add users and other to remove users. I am calling Usergroup.asmx webservice for getting the info in the listbox. When i select an item in listbox and click delete, the list box is not refreshing with new data(deleted data)... I am kind of surprised at this rather strange behavior.. If i manually refresh the page, it shows the updated list... strangely enough, its working fine for adding users to the list(the listbox shows newly added members on postback).. using System; using System.Runtime.InteropServices; using System.Web.UI; //using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using Microsoft.SharePoint.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Serialization; using Microsoft.SharePoint; using Microsoft.SharePoint.Utilities; using Microsoft.SharePoint.WebPartPages; using System.Xml; //using System.ComponentModel; using System.Collections; //web service related //using System.Web.Services; //using System.Xml.Serialization; //using System.Web.Services.Description; //using System.Web.Services.Discovery; //using System.Net; using TestWebPart2.AlterUserDetails; namespace MyWebParts { [XmlRoot(Namespace = "MyWebParts")] [Guid("da80a2e7-d4e2-49f0-b802-de12c2745ed7")] //public class TestWebPart2 : System.Web.UI.WebControls.WebParts.WebPart public class TestWebPart2 : Microsoft.SharePoint.WebPartPages.WebPart { //HtmlButton btnAddToReadOnlyList; //HtmlButton btnRemoveFromReadOnlyList; //HtmlButton btnAddToReadWriteList; //HtmlButton btnRemoveFromReadWriteList; System.Web.UI.WebControls.Button btnAddToReadOnlyList; System.Web.UI.WebControls.Button btnRemoveFromReadOnlyList; System.Web.UI.WebControls.Button btnAddToReadWriteList; System.Web.UI.WebControls.Button btnRemoveFromReadWriteList; PeopleEditor objPeopleEditor; System.Web.UI.WebControls.ListBox lstReadOnlyUsers; System.Web.UI.WebControls.ListBox lstReadWriteUsers; private string strText; private void btnRemoveFromReadOnlyList_click(object sender, EventArgs e) { try { if (lstReadOnlyUsers.SelectedIndex != -1) { RemoveUserFromRole("ReadOnly", lstReadOnlyUsers.SelectedValue); strText += "Remove Clicked"; } this.SaveProperties = true; } catch (Exception objException) { this.objPeopleEditor.ErrorMessage = "Error... Could not remove name(s) from the Read Only list."; this.objPeopleEditor.ErrorMessage += objException.StackTrace; } } private void btnAddToReadWriteList_click(object sender, EventArgs e) { try { foreach (string strLoginName in objPeopleEditor.Accounts) { AddUserToRole("FieldReadWrite", strLoginName); } this.SaveProperties = true; } catch(Exception objException) { this.objPeopleEditor.ErrorMessage = "Error... Could not add name(s) to Read Write list."; this.objPeopleEditor.ErrorMessage += objException.StackTrace; } } private void btnRemoveFromReadWriteList_click(object sender, System.EventArgs e) { try { strText = lstReadOnlyUsers.SelectedValue + "::" + lstReadOnlyUsers.SelectedIndex; if (lstReadWriteUsers.SelectedIndex != -1) { RemoveUserFromRole("FieldReadWrite", lstReadWriteUsers.SelectedValue); } this.SaveProperties = true; } catch (Exception objException) { this.objPeopleEditor.ErrorMessage = "Error... Could not remove name(s) from the Read Write list."; this.objPeopleEditor.ErrorMessage += objException.StackTrace; } } private void btnAddToReadOnlyList_click(object sender, EventArgs e) { try { foreach (string strLoginName in objPeopleEditor.Accounts) { //1073741924 //bool blnUserInReadWriteRole = CheckIfUserIsInRole("FieldReadWrite", strLoginName); //1073741925 AddUserToRole("FieldReadOnly", strLoginName); } this.SaveProperties = true; } catch (Exception objException) { this.objPeopleEditor.ErrorMessage = "Error... Could not add name(s) to Read Only list."; this.objPeopleEditor.ErrorMessage += objException.StackTrace; } } private bool CheckIfUserIsInRole(string strRole, string strUserName) { bool blnUserIsInThisRole = false; SPWeb objWeb = SPControl.GetContextWeb(System.Web.HttpContext.Current); //test UserGroup objService = new UserGroup(); objService.Url = objWeb.Url + "/_vti_bin/usergroup.asmx"; objService.Credentials = System.Net.CredentialCache.DefaultCredentials; XmlNode xnUsers = objService.GetUserCollectionFromRole(strRole); XmlTextReader xr = new XmlTextReader(xnUsers.OuterXml, XmlNodeType.Element, null); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(xr); xr.Close(); if (ds.Tables["User"] != null) { System.Data.DataRow[] drRows = ds.Tables["User"].Select("LoginName = '" + strUserName + "'"); if (drRows.Length > 0) { blnUserIsInThisRole = true; } } return blnUserIsInThisRole; } private void RemoveUserFromRole(string strRole, string strUserLoginName) { SPWeb objWeb = SPControl.GetContextWeb(System.Web.HttpContext.Current); UserGroup objService = new UserGroup(); objService.Url = objWeb.Url + "/_vti_bin/usergroup.asmx"; objService.Credentials = System.Net.CredentialCache.DefaultCredentials; objService.RemoveUserFromRole(strRole,strUserLoginName); } private void AddUserToRole(string strRole, string strUserLoginName) { SPWeb objWeb = SPControl.GetContextWeb(System.Web.HttpContext.Current); UserGroup objService = new UserGroup(); objService.Url = objWeb.Url + "/_vti_bin/usergroup.asmx"; objService.Credentials = System.Net.CredentialCache.DefaultCredentials; objService.AddUserToRole(strRole, string.Empty, strUserLoginName, string.Empty, string.Empty); //AddUserToRole(strRole, string.Empty, strUserLoginName, string.Empty, string.Empty); //remove from the other role, if applicable string strOtherRole = "FieldReadOnly"; if (strRole.Equals("ReadOnly")) { strOtherRole = "ReadWrite"; } bool blnUserInOtherRole = CheckIfUserIsInRole(strOtherRole, strUserLoginName); if (blnUserInOtherRole) { RemoveUserFromRole(strOtherRole, strUserLoginName); } } protected override void CreateChildControls() { // Create btnAddToReadOnlyList control and wire its event handler. //btnAddToReadOnlyList = new HtmlButton(); //btnRemoveFromReadOnlyList = new HtmlButton(); //btnAddToReadWriteList = new HtmlButton(); //btnRemoveFromReadWriteList = new HtmlButton(); btnAddToReadOnlyList = new System.Web.UI.WebControls.Button(); btnRemoveFromReadOnlyList = new System.Web.UI.WebControls.Button(); btnAddToReadWriteList = new System.Web.UI.WebControls.Button(); btnRemoveFromReadWriteList = new System.Web.UI.WebControls.Button(); //lstReadOnlyUsers = new HtmlSelect(); //btnAddReadOnlyUsers = new System.Web.UI.WebControls.Button(); //btnAddReadOnlyUsers.Text = "Add to Read Only List -->"; lstReadOnlyUsers = new System.Web.UI.WebControls.ListBox(); //lstReadWriteUsers.ID = "READONLYLIST"; lstReadOnlyUsers.EnableViewState = false; this.Controls.Add(lstReadOnlyUsers); lstReadWriteUsers = new System.Web.UI.WebControls.ListBox(); //lstReadWriteUsers.ID = "READWRITELIST"; lstReadWriteUsers.EnableViewState = false; this.Controls.Add(lstReadWriteUsers); objPeopleEditor = new PeopleEditor(); objPeopleEditor.AllowEmpty = false; objPeopleEditor.MultiSelect = true; this.Controls.Add(objPeopleEditor); //btnAddToReadOnlyList.InnerText = "+ Add to Read Only -->"; //btnAddToReadOnlyList.ServerClick += new EventHandler(btnAddToReadOnlyList_click); btnAddToReadOnlyList.ID = "ADDTOREADONLY"; btnAddToReadOnlyList.Text = "+ Add to Read Only -->"; btnAddToReadOnlyList.Click += new EventHandler(this.btnAddToReadOnlyList_click); this.Controls.Add(btnAddToReadOnlyList); //btnRemoveFromReadOnlyList.InnerText = "X Remove"; //btnRemoveFromReadOnlyList.ServerClick += new EventHandler(btnRemoveFromReadOnlyList_click); btnRemoveFromReadOnlyList.ID = "REMOVEFROMREADONLY"; btnRemoveFromReadOnlyList.Text = "X Remove"; this.btnRemoveFromReadOnlyList.Click += new EventHandler(this.btnRemoveFromReadOnlyList_click); this.Controls.Add(btnRemoveFromReadOnlyList); //btnAddToReadWriteList.InnerText = "+ Add to Read Write -->"; //btnAddToReadWriteList.ServerClick += new EventHandler(btnAddToReadWriteList_click); btnAddToReadWriteList.ID = "ADDTOREADWRITE"; btnAddToReadWriteList.Text = "+ Add to Read Write -->"; btnAddToReadWriteList.Click += new EventHandler(this.btnAddToReadWriteList_click); this.Controls.Add(btnAddToReadWriteList); //btnRemoveFromReadWriteList.InnerText = "X Remove X"; //btnRemoveFromReadWriteList.ServerClick += new EventHandler(btnRemoveFromReadWriteList_click); btnRemoveFromReadWriteList.ID = "REMOVEFROMREADWRITE"; btnRemoveFromReadWriteList.Text= "X Remove X"; this.btnRemoveFromReadWriteList.Click += new EventHandler(this.btnRemoveFromReadWriteList_click); this.Controls.Add(btnRemoveFromReadWriteList); //base.CreateChildControls(); LoadData(); strText += "LoadData called"; //base.CreateChildControls(); } private void LoadData() { SPWeb objWeb = SPControl.GetContextWeb(System.Web.HttpContext.Current); UserGroup objService = new UserGroup(); objService.Url = objWeb.Url + "/_vti_bin/usergroup.asmx"; objService.Credentials = System.Net.CredentialCache.DefaultCredentials; XmlNode ndUsers = objService.GetUserCollectionFromRole("ReadOnly"); XmlTextReader xr = new XmlTextReader(ndUsers.OuterXml, XmlNodeType.Element, null); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(xr); xr.Close(); lstReadOnlyUsers.DataTextField = "Name"; lstReadOnlyUsers.DataValueField = "LoginName"; lstReadOnlyUsers.DataSource = ds.Tables["User"] ; lstReadOnlyUsers.DataBind(); ndUsers = objService.GetUserCollectionFromRole("ReadWrite"); xr = new XmlTextReader(ndUsers.OuterXml, XmlNodeType.Element, null); System.Data.DataSet ds1 = new System.Data.DataSet(); ds1.ReadXml(xr); xr.Close(); lstReadWriteUsers.DataTextField = "Name"; lstReadWriteUsers.DataValueField = "LoginName"; lstReadWriteUsers.DataSource = ds1.Tables["User"]; lstReadWriteUsers.DataBind(); } protected override void OnPreRender(EventArgs e) { base.OnPreRender(e); } protected override void RenderWebPart(HtmlTextWriter output) { LoadData(); this.EnsureChildControls(); //RenderChildren(output); output.Write("<br>"); objPeopleEditor.RenderControl(output); //begin output.Write("<table>"); output.Write("<tr>"); output.Write("<td>"); btnAddToReadOnlyList.RenderControl(output); output.Write("</td>"); output.Write("<td >"); lstReadOnlyUsers.RenderControl(output); output.Write("</td>"); output.Write("<td >"); btnRemoveFromReadOnlyList.RenderControl(output); output.Write("</td>"); output.Write("</tr>"); output.Write("<tr>"); output.Write("<td >"); btnAddToReadWriteList.RenderControl(output); output.Write("</td>"); output.Write("<td >"); lstReadWriteUsers.RenderControl(output); output.Write("</td>"); output.Write("<td >"); btnRemoveFromReadWriteList.RenderControl(output); output.Write("</td>"); output.Write("</tr>"); output.Write("</table>"); output.Write("<BR>Debug Text:" + SPEncode.HtmlEncode(strText)); } } } am i missing something here.? following is the code : Tag: WSS 3.0: Current date in calculated fields Tag: 56387
  - 19
    - SharePoint Designer/Frontpage/WSS question I was never a big user of Frontpage but Designer plays a huge role in MOSS/WSS 3. So, I have the following question: If you use SPD to create a folder arbitrarily in the structure of a WSS site and then start stuffing files, e.g. images, aspx pages, etc., how are they treated by WSS? Are the files content? Is everything handled by the safe mode parser? Since the files have to be in the contentdb, I expect they're backed up with the site. Are they accessible through the object model? Tag: WSS 3.0: Current date in calculated fields Tag: 56382
  - 20
    - Breadcrumbs Not Working Correctly This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C74B66.DB8FF2E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, For some reason our breadcrumbs stopped working and wondering if anyone = has seen this before. Our structure is: = "http://server_name/sitedirectory/site_name/subsite_name" So up top in the breadcrumbs when I am in a subsite I should see: = "SharePoint > Site_Name > SubSite_Name" However all I see is either "SharePoint" when I am at the site level or = "SharePoint > SubSite_Name" when I am at the subsite level. =20 Anyone know what might be happening here? Alan ------=_NextPart_000_0006_01C74B66.DB8FF2E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>For some reason our breadcrumbs stopped = working and=20 wondering if anyone has seen this before.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Our structure is:  "<A=20 href=3D"http://server_name/sitedirectory/site_name/subsite_name">http://s= erver_name/sitedirectory/site_name/subsite_name</A>"</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>So up top in the breadcrumbs when I am = in a subsite=20 I should see:  "SharePoint > Site_Name > = SubSite_Name"</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>However all I see is either = "SharePoint" when I am=20 at the site level or "SharePoint > SubSite_Name" when I am at the = subsite=20 level.  </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Anyone know what might be happening=20 here?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Alan</FONT></DIV></BODY></HTML> ------=_NextPart_000_0006_01C74B66.DB8FF2E0-- Tag: WSS 3.0: Current date in calculated fields Tag: 56379
  - 21
    - Windows authentication after session expiry Hi, I am using WSS 3.0 for my site development. For this, i want that at the time of initial login it sohuld not ask for Windows Authentication (Should use looged in user's credentials). Now, i have set up a timeout of 1minute for my site. If 1minue of inactivity is there then i want to show the Login Screen again (Windows Authentication) and then redirect to the same page where user was originally working e.g. if user is at Mypage.aspx and login session expires, then on session_start, it should ask for Login Credentials and then go to Mypage.aspx again. I have been able tosetup the timeout period and on Session_Start, i am trying to redirect it to Authenticate.aspx. Now the problem is that, i have not been able to distinguish between the initial login and login after session expiry. Also when i use authenticate.aspx, it tries to authenticate user for 3times i.e. asks the credentials for 3times. Please help me in solving this problem. Here is the code that i am using for this: void Session_Start(object sender, EventArgs e) { Response.Write(HttpContext.Current.Request.Url.Host + HttpContext.Current.Request.ApplicationPath + "Session is Starting...<br>"); // Redirect here to Authenticate.aspx which is used by default by IIS. Session.Timeout = 1; } void Session_End(object sender, EventArgs e) { Response.Write("Session is Ending...<br>"); Response.End(); } Regards, Shreshth Tag: WSS 3.0: Current date in calculated fields Tag: 56375
  - 22
    - [WSS 3][SessionState] Don't succeed in using session in a web application in the _layouts Hello, I've done a web application which put in session non serializable object. In LAYOUTS/MyWebApp/web.config : I've put the lines : <system.web> <sessionState mode=3D"InProc" cookieless=3D"false" timeout=3D"20"/> <trust level=3D"Full" originUrl=3D"" /> <pages enableSessionState=3D"true" enableViewState=3D"true" enableViewStateMac=3D"true" validateRequest=3D"false" /> <httpModules> <add name=3D"Session" type=3D"System.Web.SessionState.SessionStateModule"/> </httpModules> </system.web> but when i launch my webApp in the layouts, I've the following mistake: ___________________________________________________________________________= _________________ Erreur de configuration Description : Une erreur s'est produite lors du traitement d'un fichier de configuration requis pour r=E9pondre =E0 cette demande. Veuillez consulter ci-dessous les d=E9tails relatifs =E0 l'erreur en question, puis modifier votre fichier de configuration de mani=E8re appropri=E9e. Message d'erreur de l'analyseur: Impossible d'utiliser 'partitionResolver' sauf si le mode est 'StateServer' ou 'SQLServer'. Erreur source: Ligne 178 : </webParts> Ligne 179 : <machineKey validationKey=3D"1A855F9919DF4F49D5FDE57747D48A6EA4BCFFED56D1E404" decryptionKey=3D"9FE6FCE1A3A316D9519A091904DBC338AB71B6603673122B" validation=3D"SHA1" /> Ligne 180 : <sessionState mode=3D"SQLServer" timeout=3D"60" allowCustomSqlDatabase=3D"true" partitionResolverType=3D"Microsoft.Office.Server.Administration.SqlSessionS= tateResolver, Microsoft.Office.Server, Version=3D12.0.0.0, Culture=3Dneutral, PublicKeyToken=3D71e9bce111e9429c" /> Ligne 181 : </system.web> Ligne 182 : <runtime> Fichier source : C:\Inetpub\wwwroot\wss\VirtualDirectories \39513\web.config Ligne : 180 ___________________________________________________________________________= _________________ Why is there a mistake in the web.config of the wss site? thx for your replies, Yann Tag: WSS 3.0: Current date in calculated fields Tag: 56374
  - 23
    - WSS V3 Hi, I've just installed WSS V3 on a standard Win 2003 server and it does not work. I cannot access the central administartion website, it doesn't load up. The configuration izard wen tthrough fine and there were no errors. Where do I start to find out what is wrong and how do I fix it? Cheers, Alex Tag: WSS 3.0: Current date in calculated fields Tag: 56362
  - 24
    - Daylight saving modificatio and testing Hi We are trying to patch the new daylight saving definition to our us sharepoint server. We go for the method by modifying the xml file. Due to insufficient experience dealing with timezone problems, we are required to create some test case to make sure the new definition work. Can anyone help to provide some idea how should I test if the patch work? I try to create some calendar entry before and after the patch during the DST period, but cannot reproduce any case that can prove the patch work. thanks in advance! Tag: WSS 3.0: Current date in calculated fields Tag: 56361
  - 25
    - Receive "Cannot connect to the configuration database" when attempting to install a new web part I've create a new web part. I'm trying to install this web part on a Sharepoint Portal Server 2003 instance. In my development environment, Sharepoint is set up on a single server with SQL Server 2000 on the same box. I can install the web part just fine there. On the production instance, Sharepoint is set up different. SQL Server 2000 is on a separate box. Using the same steps (as I do on the development instance), I get a "cannot connect to the configuration database" error message. As far as I know, everything else on the production Sharepoint instance is working just fine. I've seen the troubleshooting steps at http://support.microsoft.com/kb/ 823287/en-us. On the web server, the app pool identity is set to "NETWORK SERVICE". On the SQL Server 2000 instance, the "NETWORK SERVICE" account is not a member of any of the roles listed in the knowledge base article. If I add the SQL Server 2000 instance's 'NETWORK SERVICE" account to the proper roles, would that fix my problem? Do I need to create another account that is the same for both servers? I'm not sure why I get this error on the production server. Any help would be greatly appreciated. Tag: WSS 3.0: Current date in calculated fields Tag: 56359
- Next
  - 1
    - Field type Comments is not installed properly error I am getting the following error: Field type Comments is not installed properly. Go to the list settings page to delete this field. I don't know where to go to fix this. Everytime I try to access it with SharePoint designer or through site settings, I get this error. I am running WSS 3.0. -- Vincent Wright Tag: WSS 3.0: Current date in calculated fields Tag: 56358
  - 2
    - WSS V3 - change name in tab I made a sub-site but mis-spelled the name... how can I change the name in the tab??? Thanks! Tag: WSS 3.0: Current date in calculated fields Tag: 56357
  - 3
    - WSS - Error using stsadm "-o deletesite", (corrupted site?) I am having an issue with a site collection on my sharepoint server. I used stsadm.exe with the -o createsite parameter to create a blank corporate IT test site on our intranet (http://intranet/sites/corporateIT2). Before the command was finished running however, the command window was closed by accident. Now when I go to enumsites for http://intranet, I get the following entry among the others: <Site Url="http://intranet/sites/corporateIT2" Error="There is no Web named "/sites/corporateIT2"."> If I try to run stsadm.exe -o deletesite or -o backup with the CorprorateIT2 url, I get: "The system cannot find the path specified" If I try to run: stsadm.exe -o deletepath with the CorporateIT2 url, I get: "The managed path you specified does not exist" If I try to run: stsadm.exe -o restore -url http://intranet/sites/corporateIT2 -filename -overwrite from a backup I have of the production corporate IT site I get: "The Web site address "http://intranet/sites/corporateIT2" is already in use" If I try to access the site through a browser, I get: 400 error, "Bad Request" At this point, I'm just trying to clean up/delete the http://intranet/sites/corporateIT2 path/site that I've created. It's not hurting much right now as the intranet is still a development platform, and no one needs the corporateIT2 url, but I want to get a better picture of what's going on and how to fix it moving forward. Any input is greatly appreciated. Thanks in advance, Chris Tag: WSS 3.0: Current date in calculated fields Tag: 56356
  - 4
    - Uploading 1000s of files without needing to check in Hi, I need to upload literally 1000s of files into a Doc Repository in SharePoint 3. I can do this easily through Explorer view, however I notice that all the files are checked out to me when I do this. Is there any easy way to check-in all the files at once OR Upload multiple files so that they are not checked out when the upload / copy completes? TIA. Tag: WSS 3.0: Current date in calculated fields Tag: 56354
  - 5
    - Issue upgrading Sharepoint 2003 sp2 to MOSS 2007 trial version I downloaded the trial version of MOSS 2007 until my CD and license comes in. I have a test environment with 1 server which is the front end webserver, the 2nd server is the job server and indexer and the 3rd server is running SQL 200 sp4. In my actual environment its a 3 server farm as opposed to the 2 server farm I have in my test environment. I ran all windows updates on all 3 boxes including grabbing the DST update for Sharepoint 2003. I ran the prescan.exe and cleared all errors. I installed .NET 3.0 on both the front end and job/indexer. I also enabled .NET 2.0 in IIS.I upgraded the frontend first without running the config wizard. I then upgraded the job/index server second and stopped at running the config wizard. Ran the config wizard on frontend and it bombed on step 2 with the following error: "Failed to initiate the upgrade process" Logfile has the following error: 02/07/2007 13:44:45 8 ERR Task upgradebootstrap has failed with an unknown exception 02/07/2007 13:44:45 8 ERR Exception: Microsoft.SharePoint.Upgrade.SPUpgradeException: Action 12.0.1.0 of Microsoft.Office.Server.Search.Upgrade.SearchServiceInstanceSequence failed. ---> System.ArgumentNullException: Value cannot be null. Parameter name: path at System.IO.DirectoryInfo..ctor(String path) at Microsoft.Search.Administration.Security.BinFolder.EnsureACL(String username) at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.Provision() at Microsoft.Office.Server.Search.Upgrade.ProvisionSearchServiceInstance.Upgrade() at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade() --- End of inner exception stack trace --- at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade() at Microsoft.SharePoint.Upgrade.SPManager.Upgrade(Object o, Boolean bRecurse) at Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean recursively) at Microsoft.SharePoint.Upgrade.SPManager.Initialize() at Microsoft.SharePoint.PostSetupConfiguration.UpgradeBootstrapTask.Run() at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask() I called MS and the tech had me run the config wizard on the job/ indexer and it ran successfully (even though there documentation says to run it on the front end first). Next, he had me run it on the front- end again and it bombed with the same error. I sent him all of my logs and have yet to hear from him. I have been unable to find a solution to this error message either by my own accord or through MS. Hopefully, someone out here has had this issue before and can tell me how to resolve it. Thanks for any help. Tag: WSS 3.0: Current date in calculated fields Tag: 56352
  - 6
    - Daylight Savings Time Date Change I am running Sharepoint 3.0. It is my understanding that I don't need to apply any patches for the DST date change, is that correct? Thank you. -- Mike Stevens Tag: WSS 3.0: Current date in calculated fields Tag: 56351
  - 7
    - Migrating Sharepoint structure from one hosted service supplier to another Our Sharepoint site is hosted by a commercial hosted Sharepoint supplier but I need to move it to one that works (!). How do I achieve this? The underlying domain name is the same on each service in case that helps. I was hoing to save the Sites as Templates with content but it says my Sites are too big to do that Tag: WSS 3.0: Current date in calculated fields Tag: 56348
  - 8
    - Renaming SharePoint Databases (not server name) I have a need to rename the SharePoint dbs that were created when I installed Project 2007. The databases in question are the WSS_Content and SharePoint_Admin_Content. If someone could tell me how to rename these databases without affecting functionality that would be very helpful. Or would it be easier to create new content databases and attach them to the web applications and delete the old ones? Any help is greatly appreciated! Damon Steele steeled@ninds.nih.gov Tag: WSS 3.0: Current date in calculated fields Tag: 56346
  - 9
    - IE Locks when trying to access Sharepoint I posted this on the portal server group and thought I'd try over here too. I have several members on my team with an issue when trying to access our sharepoint site. IE will show one bar on the progress bar, but lock up and I have to end program to get out. It doesn't even get to the login popup. They can get to other internal and external websites. They can login in to the sharepoint site from other PCs. Here's what I've tried: 1. Delete all temp files 2. I can ping the server from a command prompt 3. I can get the the sharepoint site through firefox (although we have no functionality) 4. I removed all the webparts on the opening page - still nothing 5. I added the website to their trusted sites. 6. I've matched all the security settings to my PC. Nothing changed on their machines to cause this. I even get it on my machine from time to time, but once I end program and restart IE, I can get in. Any suggestions? Shelly Tag: WSS 3.0: Current date in calculated fields Tag: 56345
  - 10
    - Create reports using SQL reporting services Hi all I want to create reports in SQL 2000 Reporting services on a WSS site & subsites (ie report on all tasks across all subsites). Is it possible to expose sharepoint as a datasource in order to query it in Reporting Services?? THanks in advance George Tag: WSS 3.0: Current date in calculated fields Tag: 56336
  - 11
    - How to enable auditing on WSS v3 Hello. Can anyone point me in the direction for instructions on how you enable and view auditing in WSS v3? I am aware you it's not a GUI option in WSS v3 The admin section of the MS technet library is still down as "TBD", so no help there. I've tried Mike Walsh's excellent WSS FAQ, however it states that it must be performed by the object model. "Note: In WSS v3 Audit Logging needs to be turned on (and accessed) via the Object Model (OM)" The following link, seems to relate to MOSS 2007 and not WSS v3 http://markharrison.co.uk/blog/archive%5C2006_07_01_archive.htm Any pointers will be great (I'm guessing you need to use SP designer 2007?) Thanks in advance. Tag: WSS 3.0: Current date in calculated fields Tag: 56331
  - 12
    - Toolpart postback problem Hi, I'm currently having a problem getting my toolpart to retain its viewstate on postback. I have several list that need to be populated depending on what was selected above them. At the moment i'm trying to get the lists to load on the click event of a button. My problem is when this click event is called, the page does a postback and all the current values of the lists are lost and the toolpart is reloaded with its original values. I'm sure i'm missing some awfully simple but I can't think what. thanks Adam ************************************************************************************************************************** ********************** Code ******************************************************************************************** [ToolboxData("<{0}:CustomToolPart runat=server></ {0}:CustomToolPart>")] public class GroupingListByCategoryToolPart : ToolPart { private Label lblTargetSite = new Label(); private TextBox tbTargetSite = new TextBox(); private Button btnLoadSiteLists = new Button(); private Label lblLists = new Label(); private DropDownList ddlLists = new DropDownList(); private Button btnLoadListFields = new Button(); private Label lblCategory = new Label(); private DropDownList ddlCategory = new DropDownList(); private Label lblLink = new Label(); private DropDownList ddlLink = new DropDownList(); private Label lblFilterField = new Label(); private DropDownList ddlFilterField = new DropDownList(); private Label lblFilterValue = new Label(); private TextBox tbFilterValue = new TextBox(); private HiddenField hdnLoadOnce = new HiddenField(); private const string CSSUSERINPUT = "UserInput"; private const string DIVUSERCONTROLGROUP = "<div class= \"UserControlGroup\">"; private const string DIVUSERDOTTEDLINE = "<div style='width: 100%' class='UserDottedLine'></div>"; private const string DIVUSERSECTIONHEAD = "<div class= \"UserSectionHead\">"; private const string DIVEND = "</div>"; private const string NEWROW = "<tr><td>"; private const string ENDROW = "</td></tr>"; private string wpID; public GroupingListByCategoryToolPart() { //Set some properties and event handlers for the tool part this.Title = "Grouping List Setup"; this.Init += new EventHandler(GroupingListByCategoryToolPart_Init); } private void GroupingListByCategoryToolPart_Init(object sender, System.EventArgs e) { wpID = this.UniqueID + "ID"; } private void btnLoadSiteLists_Click(object sender, EventArgs e) { LoadSiteLists(tbTargetSite.Text); } private void btnLoadListFields_Click(object sender, EventArgs e) { LoadListFields(ddlLists.SelectedValue, ""); } private void LoadSiteLists(string sitePath) { using (SPSite site = new SPSite(sitePath)) { using (SPWeb web = site.OpenWeb()) { ClearAllFields(); foreach (SPList list in web.Lists) { ddlLists.Items.Add(list.Title); } } } } private void LoadListFields(string sitePath, string currentValue) { using (SPSite site = new SPSite(sitePath)) { using (SPWeb web = site.OpenWeb()) { SPList list = web.Lists[currentValue]; ddlCategory.Items.Clear(); ddlCategory.Items.Add(""); ddlLink.Items.Clear(); ddlLink.Items.Add(""); ddlFilterField.Items.Clear(); ddlFilterField.Items.Add(""); foreach (SPField field in list.Fields) { if (field.Type == SPFieldType.MultiChoice) ddlCategory.Items.Add(field.Title); if (field.Type == SPFieldType.URL || field.Type == SPFieldType.File) ddlLink.Items.Add(field.Title); if (field.Filterable) ddlFilterField.Items.Add(field.Title); } } } } private void ClearAllFields() { ddlLists.Items.Clear(); ddlLists.Items.Add(""); ddlCategory.Items.Clear(); ddlCategory.Items.Add(""); ddlLink.Items.Clear(); ddlLink.Items.Add(""); ddlFilterField.Items.Clear(); ddlFilterField.Items.Add(""); tbFilterValue.Text = ""; } protected override void RenderToolPart(HtmlTextWriter output) { //Get a reference to the web part associated with this tool part ToolPane tpPane = this.ParentToolPane; GroupingListByCategory wp = (GroupingListByCategory) (tpPane.SelectedWebPart); lblTargetSite.Text = "Target Site Address."; lblTargetSite.ToolTip = "This field defaults to the current site. Site address must be a valid SharePoint site."; lblTargetSite.EnableViewState = true; tbTargetSite.Text = wp.SitePath; tbTargetSite.CssClass = CSSUSERINPUT; tbTargetSite.EnableViewState = true; btnLoadSiteLists.Text = "Load site lists"; btnLoadSiteLists.CssClass = "UserButton"; btnLoadSiteLists.Click += new EventHandler(btnLoadSiteLists_Click); lblLists.Text = "The name of the list which you would like to display."; lblLists.ToolTip = "Set the name of the list which you would like to display."; btnLoadListFields.Text = "Load list fields"; btnLoadListFields.CssClass = "UserButton"; btnLoadListFields.Click += new EventHandler(btnLoadListFields_Click); lblCategory.Text = "The name of the field which you would like to set as the category."; lblCategory.ToolTip = "Set the name of the field which you would like to set as the category. This field must be a Multichoice field. Only Multichoice fields are displayed in the list below."; lblLink.Text = "The name of the field which contains the link to a file or url."; lblLink.ToolTip = "Set the name of the field which you would like to set as the link field. This is the field that is displayed in the categorised list."; lblFilterField.Text = "The name of the field that you would like to filter the results by."; lblFilterField.ToolTip = "To filter the results of the Categorised list select the name of the field that you would like to filter the results by."; lblFilterValue.Text = "The value of the field that you would like to filter the results by."; lblFilterValue.ToolTip = "If you have set a filter field you must give then set a filter value which will determine what will be displayed on the list."; tbFilterValue.Text = wp.FilterFieldValue; tbFilterValue.CssClass = CSSUSERINPUT; //Load ddlLists ddlLists.CssClass = CSSUSERINPUT; ddlLists.EnableViewState = true; if (wp.SitePath != string.Empty) { LoadSiteLists(wp.SitePath); ddlLists.Text = wp.DisplayList; //Load ddlCategory //Load ddlLink //Load ddlFilterField ddlCategory.CssClass = CSSUSERINPUT; ddlLink.CssClass = CSSUSERINPUT; ddlFilterField.CssClass = CSSUSERINPUT; if (wp.DisplayList != string.Empty) { LoadListFields(wp.SitePath, wp.DisplayList); ddlCategory.SelectedValue = wp.CategoryField; ddlLink.SelectedValue = wp.LinkField; ddlFilterField.SelectedValue = wp.FilterField; } } output.Write(@"<div class='ms-ToolPartSpacing'></div><div> <table cellspacing='0' border='0' style='border-width:0px;width: 100%;border-collapse:collapse;'>"); RenderToolPartItem(output, lblTargetSite, tbTargetSite, null, btnLoadSiteLists); RenderToolPartItem(output, lblLists, null, ddlLists, btnLoadListFields); RenderToolPartItem(output, lblCategory, null, ddlCategory, null); RenderToolPartItem(output, lblLink, null, ddlLink, null); RenderToolPartItem(output, lblFilterField, null, ddlFilterField, null); RenderToolPartItem(output, lblFilterValue, tbFilterValue, null, null); output.Write("</table></div>"); hdnLoadOnce.ID = wpID; hdnLoadOnce.Value = "true"; hdnLoadOnce.RenderControl(output); } private void RenderToolPartItem(HtmlTextWriter output, Label lbl, TextBox tb, DropDownList ddl, Button btn) { output.Write(NEWROW); output.Write(DIVUSERDOTTEDLINE); output.Write(DIVUSERCONTROLGROUP); output.Write(DIVUSERSECTIONHEAD); lbl.RenderControl(output); output.Write(DIVEND); if(ddl!=null) ddl.RenderControl(output); if (tb != null) tb.RenderControl(output); if(btn!=null) btn.RenderControl(output); output.Write(DIVEND); output.Write(ENDROW); } ///<summary> ///Called by the tool pane to apply property changes to the selected Web Part. ///</summary> public override void ApplyChanges() { // Apply property values here // Get a reference to the web part class GroupingListByCategory wp = (GroupingListByCategory)this.ParentToolPane.SelectedWebPart; UpdateWebPartProperties(wp); base.ApplyChanges(); } public override void SyncChanges() { GroupingListByCategory wp = (GroupingListByCategory)this.ParentToolPane.SelectedWebPart; UpdateWebPartProperties(wp); base.SyncChanges(); } private void UpdateWebPartProperties(GroupingListByCategory wp) { if(ddlLists.SelectedValue!="") wp.DisplayList = ddlLists.SelectedValue; if (ddlCategory.SelectedValue != "") wp.CategoryField = ddlCategory.SelectedValue; if (ddlLink.SelectedValue != "") wp.LinkField = ddlLink.SelectedValue; if (tbTargetSite.Text != "") wp.SitePath = tbTargetSite.Text; if (ddlFilterField.SelectedValue != "") wp.FilterField = ddlFilterField.SelectedValue; if (tbFilterValue.Text != "") wp.FilterFieldValue = tbFilterValue.Text; } } Tag: WSS 3.0: Current date in calculated fields Tag: 56330
  - 13
    - Smigrate and Original Site I have a WSS 2.0 sp2 (6.0.28117) server. It's a single server with the config and content DBs on another server running SQL 2000 sp4. We're looking at upgrading to WSS 3.0 and to do so wanted to setup a test environment. Smart aye? :) So I created a backup using the smigrate tool. Setup a new server, installed WSS 2.0 and patched it to the same version. Re-created all the sites without templates. Setup all the databases like on the original server but pointing at a different SQL server (2005 in this instance). I copied the smigrate backup files over to the new server and ran the tool to restore to the new web. as in http://site2 instead of http://site1 It all seemed to work just fine except that after running the tool, my ORIGINAL sharepoint site gives a 404 Bad Request error. For the life of me, I see no reason why the 2 would be connected but that is the only change done to that server recently. Help would be appreciated. Thanks Tag: WSS 3.0: Current date in calculated fields Tag: 56328
  - 14
    - Alternate url synchronizer job error I'm recieving this error every 60 seconds in the Windows Application log the specifics of which are below. This is on a server hosting a MOSS installation of an upgraded v2 SPS portal. These WSS errors are new and I'm getting MOSS errors of the same type as well. I've had this MOSS portal up since before the RTM release and I believe they're related to the re-direct mechanism deployed when upgrading from SPS to MOSS associated with Areas being converted to sub sites within the site collection. I'm unaware of any changes that I've made that could possibly be related but clearly something has changed. Any help or insight would be greatly appreciated. Thanks, Larry Event Type: Error Event Source: Windows SharePoint Services 3 Event Category: Timer Event ID: 6398 Date: 2/6/2007 Time: 1:59:10 PM User: N/A Computer: DS-DEV Description: The Execute method of job definition Microsoft.Office.Server.Administration.AlternateUrlSynchronizerJob (ID 0d356677-df2f-4277-a515-9d253e79565c) threw an exception. More information is included below. You must specify the default zone URL for all Web applications. To delete the Alternate URL Collection, remove the public URLs in all other zones, and then remove the default zone URL. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Tag: WSS 3.0: Current date in calculated fields Tag: 56327
  - 15
    - Security on views Using WSS 3.0, is there any way of enforcing security on a view? Can it be done programatically? Any help appreciated. Thanks. Tag: WSS 3.0: Current date in calculated fields Tag: 56326
  - 16
    - Migrate wss 2.0 and sql 2000 to new hardware All, Maybe someone can help me out with this. I've been reading and reading for days and I see a lot of different posts and doc's but none that seem to address my particular situation. I have a server 2003 box with wss v 2.0 and sql 2000 on it and it seems to be dying. I would like to move my exsisting installations to a new server. The server will be a completely different machine, with different hard drive set-up and with a different box name and domain. Does anyone have any suggestions as to what steps I should take to make this change? What about my AD users, will they have to be migrated as well or will stsadmin do all of that? What about my sql 2000 databases and form libraries? I'm scared!!! Tag: WSS 3.0: Current date in calculated fields Tag: 56321
  - 17
    - drop-down for top navigation bar I noticed in MOSS 2007 they've added the functionality of showing a drop downlist of subsites. for instance I have a IT site and underneath it is a wiki and a blog that I can just click on from MOSS 2007 from the top navigation drop-down list. Is it possible to do this in Sharepoint services 3.0? TIA, Jackson Tag: WSS 3.0: Current date in calculated fields Tag: 56317
  - 18
    - Error opening documents I'm getting the following error when opening a new or existing document in WSS v2. SysFader: iexplore.exe - Application Error : The exception unknown software exception (0xc06d007f) occurred in the application at location 0x7c812a5b. It will allow me to open when i'm in Explorer view. I can also open it in office using the http:// path. I'm running IE 7 and Office 2003. I've reinstalled IE7 and done a repair in Office. I've used a different machine and it worked fine, so it can't be an issue with my account. Any help will be most appreciated. Thanks in advance. -Andy Tag: WSS 3.0: Current date in calculated fields Tag: 56316
  - 19
    - Please Help-Server Farm Configuration Not Complete I have installed Sharepoint 2007 (advanced), with Sql server 2005 on separate server. Upon completion when go to Central Administration, I get 'Server Farm Configuration Not Complete' on top left corner, click on Admin tasks, get the following:- Administrator Tasks 1 READ FIRST - Click this link for deployment instructions Not Started 1 Initial deployment: Add servers to farm Not Started 1 Initial deployment: Assign services to servers Not Started 1 Configure server farm's shared services Not Started Farm Topology Server Services Running BACSPS02 Central Administration Windows SharePoint Services Help Search Windows SharePoint Services Incoming E-Mail Windows SharePoint Services Web Application BACSQL03 Windows SharePoint Services Database When I try to start 'Windows SharePoint Services Help Search ' it will not start with the same account which I used to install sharepoint, I had to used different one(is that right?). Now, when I try to create new SSP, I create new web application (Sharepoint - 80), but it comes with the error 'no indexers', but there is no index server to choose from. Sorry about the long question, been at it for days, just found this forum. Thanks Tag: WSS 3.0: Current date in calculated fields Tag: 56313
  - 20
    - Potentially excessive number of SPRequest objects I got this error when trying to go to edit mode on my web part pages. The error was caused by an invalid XSL transformation that I created in Site Root > Style Library > XSL Style Sheets > ItemStyle.xsl. Try reverting to the original .xsl file to fix the problem. Note that your web parts may function correctly in non-edit modes, and that your XSL transformations may even render correctly. EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com Tag: WSS 3.0: Current date in calculated fields Tag: 56312
  - 21
    - Pass an argument to a survey? Hi all, is it possible to pass an argument into a survey, via the URL? I would like to create a customer survey response from our CRM tool, passing it the event reference number. So, for example, we'd automatically send an email to the user inviting them to complete the survey at the following URL; http://edn-web-02/sites/ServiceCentre/Lists/InternalIncidentSurvey/NewForm.aspx?THE-INCIDENT-IS=12345 And the last bit (I know the syntax is wrong!) would update one of the columns in the survey response. Ideally that field would be hidden / read-only, but that's less of an issue than passing in the correct reference in the first place. I guess this query would apply to any new-item form, not just the survey list. Appreciate your thoughts. Regards, Scott Tag: WSS 3.0: Current date in calculated fields Tag: 56310
  - 22
    - Using Sharepoint's Windows explorer funtion not working with Vista Hi I have been using sharepoint 3.0 with my clinet PC running XP pro and office 2007 beta2 for some time now and have been using the document folder browsing trough windows explorer feature on a daily basis as it have been working great for me! But when I upgraded to Vista and Office 2007 this does not work anymore! I can syncronize a document folder trough Outlook but when I click on "open in windows explorer" trough the WSS 3.0 web page nothing happens! Its really frustrating that this does not work anymore! Can anyone help me! Is this a problem with my configuration or a Vista problem. By the way, one of the folders I have tried to map have shown up in web folders in my explorer view. How I managed to get it showing here, and why just only this one folder I don't know. And an other issue, how the h**** am I'm supposed to use Groove with the sharepoint doc folder when groove won't let you add a Web folder??? I managed to find a way around it but I guess I'm doing something wrong. Everything worked perfectly with XP, with Vista? really nothing yet Tag: WSS 3.0: Current date in calculated fields Tag: 56308
  - 23
    - Migration problems When we migrate the data from sharepoint 2003 to 2007 we are facing some key violation problems during the population of alluserdata from previous userdata table. Have anyone faced these problems. Any ideas will be great! Tag: WSS 3.0: Current date in calculated fields Tag: 56307
  - 24
    - workflow setting I had upgraded the wss2.0 to wss3.0, I want try the workflow function, but I couldn't find the "workflow setting" in "Permissions and Policies". Why? please help me, thanks! Tag: WSS 3.0: Current date in calculated fields Tag: 56305
  - 25
    - Sharepoint supported in AD 2000 and Exchange 2000 - incoming email Hi, Are WSS3 and also MOSS2007 supported in an Active Directory 2000 domain with Exchange Server 2000?? I've tried to enable incoming email in both WSS3 and MOSS2007, but both seems to have the same issue. I've setup incoming email as described (also followed the guidelines from other people like the Whitepaper on Combined Knowledge), but without any luck. When I create a distribution group with email address (without creating new list) and want to approve the creation of Distribution group, I get an error. When I look in the Sharepoint log file I see the following error: "System.DirectoryServices.DirectoryServicesCOMException (0x8007200A): The specified directory service attribute or value does not exist. (Exception from HRESULT: 0x8007200A) at System.DirectoryServices.DirectoryEntry.CommitChanges() at Microsoft.SharePoint.EmailIntegration.SPEWSADManager.CreateDistributionGroup(String Alias, String Name, String Description, Object memberList, Boolean RequireContactValidation, DistributionGroupFlags Flags)SPEWSADManager::CreateDistributionGroup" Is this because AD 2000 and Exchange 2000 are not supported or is it something else? /dsa Tag: WSS 3.0: Current date in calculated fields Tag: 56303

It doesn't look like it, but is there a way to reference "today's
date" in a calculated column? I want to determine the number of days
between today's date, and the date in another column, and all signs
point to that not being possible.

If not, are there any possible workarounds?

Top

RE: WSS 3.0: Current date in calculated fields by Jon

Jon
Tue Feb 13 13:20:00 CST 2007

"Mark Roberts" wrote:

> It doesn't look like it, but is there a way to reference "today's
> date" in a calculated column? I want to determine the number of days
> between today's date, and the date in another column, and all signs
> point to that not being possible.
>
> If not, are there any possible workarounds?
>
>

Mark,
Use [Today] with the brackets. The calculation then *may* be "=[Today] -
[Created]"

Top