which country user step here?

Tag Cloud

MOSS (47) SharePoint 2007 (37) SharePoint 2013 (31) SharePoint 2010 (23) MOSS admin (17) PowerShell (17) admin (17) developer (16) List (15) WSS (14) sql query (14) MOSS SP2 (13) end user (11) scripting (11) wss V3 (11) permission (10) sql (9) Moss issue (8) search (8) database (7) RBS (6) Service Pack (6) reportadmin (6) workflow (6) CU (5) Excel (5) Patch (5) client object model (5) Client Code (4) Command (4) Cumulative Updates (4) IIS (4) SharePoint 2019 (4) SharePoint designer (4) office 365 (4) stsadm (4) user porfile (4) ASP.NET (3) Content Database (3) Groove (3) Host Named Site Collections (HNSC) (3) SharePoint 2016 (3) Tutorial (3) alert (3) authentication (3) batch file (3) codeplex (3) domain (3) error (3) incomming email (3) issue (3) restore (3) upload (3) Caching (2) DocAve 6 (2) Folder (2) Index (2) Internet (2) My Site Cleanup Job (2) My Sites (2) News (2) People Picker (2) Share Document (2) SharePoint admin (2) View (2) Web Development with ASP.NET (2) add user (2) audit (2) coding (2) column (2) deploy solution (2) download (2) enumsites (2) exam (2) export (2) june CU (2) load balance (2) mySites (2) network (2) orphan site (2) performance (2) profile (2) project server (2) query (2) security (2) server admin (2) theme (2) timer job (2) training (2) web master (2) web.config (2) wsp (2) 70-346 (1) 70-630 (1) AAM (1) Anonymous (1) Approval (1) AvePoint (1) Cerificate (1) Consultants (1) Content Deployment (1) Content Type (1) DOS (1) Document Library (1) Drive Sapce (1) Excel Services (1) Export to Excel (1) Feature (1) GAC (1) Get-SPContentDatabase (1) Get-WmiObject (1) HTML calculated column (1) ISA2006 (1) IT Knowledge (1) ITIL (1) Install (1) Link (1) MCTS (1) Macro (1) Masking (1) Migration (1) NLBS (1) Nintex (1) Office (1) Open with Explorer (1) ROIScan.vbs (1) Reporting Services (1) SPDisposeCheck.exe (1) SQL Instance name (1) SSRS (1) Sandbox (1) SharePoint Online (1) SharePoint farm (1) Shared Services Administration (1) Site Collection Owner (1) Site template (1) Skype for business (1) Steelhead (1) Teams (1) URLSCAN (1) VLOOKUP (1) WSS SP2 (1) XCOPY (1) abnormal incident (1) admi (1) app (1) application pool (1) aspx (1) availabilty (1) backup (1) binding (1) blob (1) branding sharepoint (1) cache (1) calendar (1) change password (1) connection (1) copy file (1) counter (1) crawl (1) custom list (1) domain security group (1) event (1) excel 2013 (1) facebook (1) filter (1) fun (1) group (1) iis log (1) import (1) import list (1) improment (1) interview (1) keberos (1) licensing (1) log in (1) metada (1) migrate (1) mossrap (1) notepad++ (1) onedrive for business (1) operation (1) owa (1) process (1) publishing feature (1) resource (1) send email (1) size (1) sps2003 (1) sql201 (1) sql2012 (1) sub sites (1) system (1) table (1) task list (1) today date (1) trial (1) vbs (1) video (1) web part (1) web server (1) widget (1) windows 2008 (1) windows 2012 R2 (1) windows Azura (1) windows account (1) windows2012 (1) wmi (1)
Showing posts with label WSS. Show all posts
Showing posts with label WSS. Show all posts

Sunday, May 22, 2011

SharePoint Calculated Value Nested

http://office.microsoft.com/en-us/windows-sharepoint-services-help/if-function-HA001161010.aspx

 

keep track this formula for nested function , so i can use this to select other option to show here as lookup list

Example set 3

image

45
=IF([Score]>89,"A",IF([Score]>79,"B", IF([Score]>69,"C",IF([Score]>59,"D","F"))))
Assigns a letter grade to the first score (F)

90
=IF([Score]>89,"A",IF([Score]>79,"B", IF([Score]>69,"C",IF([Score]>59,"D","F"))))
Assigns a letter grade to the second score (A)

78
=IF([Score]>89,"A",IF([Score]>79,"B", IF([Score]>69,"C",IF([Score]>59,"D","F"))))


Assigns a letter grade to the third score (C)

 

In the preceding example, the second IF statement is also the value_if_false argument to the first IF statement. Similarly, the third IF statement is the value_if_false argument to the second IF statement. For example, if the first logical_test ([Score]>89) is TRUE, "A" is returned. If the first logical_test is FALSE, the second IF statement is evaluated, and so on.

 

The letter grades are assigned to numbers using the following key (assuming use of integers only).

 

IF SCORE IS
THEN RETURN

image

Thursday, February 24, 2011

sub sites owner with Full Control unable to add Content Editor Web Part

after so many year at sharepoint , just notice web part also have permission setting.

 

below is the detail from the forum.

 

 

http://www.tek-tips.com/viewthread.cfm?qid=1444650&page=3

 

Background: SharePoint V3 on a hosted server. The user is a "site owner" and "site owners" have "full control" over the site.  "full control" has all the options that can be selected for security.  This is a sub-site to the main SharePoint site and it does not inhearit security from the parent site.  I want site owners to have full control over there individual sites, but not have control over other's sites.  
Problem: When the user goes to add a web part to the "Home" page of the site via selecting "Site Actions" - "Edit Page" the only web parts that are available to them are the "Lists and Libraries" web parts that consist of "Announcements", "Calendar", "Links", "Shared Documents", "Tasks", and "Team Discussion".
When a Site Collection Administrator does the same thing as above, they see all the web parts listed above as well as "Miscellaneous" web parts consisting of "Content Editor Web Part", "Form Web Part", "Image Web Part", "Page Viewer Web Part", "Relevant Documents", "Site Users", "User Tasks", and "XML Web Part".  Is it possible to make these web parts accessible to the owners of sub-sites with out giving them full control over the entire SharePoint site hierarchy?

 

 

I believe I figured out a solution.  So, if your curious, here is how I fixed it.
Logged into the top level SharePoint site as a site collection administrator.
Select "Site Actions" - "Site Settings"
In the "Galleries" Colum, select "Web Parts"
With the Web Part Gallery open, select the "Settings" menu and select "Gallery Settings"
Now you should be in the Customize Web Part Gallery window.  In the "Permissions and Management" column, select "Permissions for this gallery".
In the "Permissions: Web Part Gallery" Select "Actions" - "Edit Permissions"
Select "OK" to the pop up that is displayed warning you that you are about to create unique permissions, and now you can select "New" and add additional users to the Gallery.
This will allow whomever you add to see all the Web Parts available.

Wednesday, December 8, 2010

Clean Up Event ID 7888 and 5553.

see the error at your event viewer ?

 

 

failure trying to synch site 51d6d8b3-9ee0-4af3-af2f-fa5f78cc9651 for ContentDB 840eac13-c23e-4123-9fa2-9d2975d0ff13 WebApp 53ea7eb2-ec0f-4250-9d87-1550224223b8.  Exception message was Cannot insert duplicate key row in object 'dbo.UserMemberships' with unique index 'CX_UserMemberships_RecordId_MemberGroupId_SID'.
The statement has been terminated..

 

 

Solution here:

http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/11af8a85-0fca-466d-beac-d29d03297edf

 

solution summary :

 

  • Run 'stsadm- o preparetomove -Site <http://whatevertheguiltysiteis/> -OldContentDb <GUID of the contentdb listed in event log error>'
  • Run 'stsadm -o sync -deleteolddatabases 0'

FQA:

  • How do i know which site is it by GUID ?
    • -- QUERY#1 Run this against your config database, this will give you the content database name

      SELECT *
      FROM [SharePoint_Config].[dbo].[Objects]
      WHERE ID='<Content DB Id from error msg>'

      --QUERY#2
      -- Run followign queries against the database name returned by the QUERY#1

      SELECT [FullUrl]
      ,[Id]
      ,[RootWebId]
      FROM [WSS_Content_##_03].[dbo].[Sites]
      WHERE ID='<Site ID from event log message>'








      or you can run the query at sitemap table at the config database , then you will see all the site under this content db , then manually go to find out on the Path column of the site URL.



      SELECT [Id]

            ,[ApplicationId]


            ,[DatabaseId]


            ,[Path]


            ,[Pairing]


            ,[Status]


            ,[Version]


            ,[RedirectUrl]


            ,[HostHeaderIsSiteName]


        FROM [MOSS_CONFIG_DB].[dbo].[SiteMap]


      where [DatabaseId]='<Content DB Id from error msg>'

      Tuesday, October 19, 2010

      -- Query to get all the SharePoint groups in a site collection

       

      Another cool query from sharepointkings

       

      Customer request the report on all the user in the group on the specify sites collection.

       

      -- Query to get all the SharePoint groups in a site collection
      SELECT dbo.Webs.SiteId, dbo.Webs.Id, dbo.Webs.FullUrl, dbo.Webs.Title, dbo.Groups.ID AS Expr1,
      dbo.Groups.Title AS Expr2, dbo.Groups.Description
      FROM dbo.Groups INNER JOIN
      dbo.Webs ON dbo.Groups.SiteId = dbo.Webs.SiteId

       

      -- Query to get all the members of the SharePoint Groups
      SELECT dbo.Groups.ID, dbo.Groups.Title, dbo.UserInfo.tp_Title, dbo.UserInfo.tp_Login
      FROM dbo.GroupMembership INNER JOIN
      dbo.Groups ON dbo.GroupMembership.SiteId = dbo.Groups.SiteId INNER JOIN
      dbo.UserInfo ON dbo.GroupMembership.MemberId = dbo.UserInfo.tp_ID

       

       

      after query the all the memeber of the group, use excel to remove the duplicate data then you will know how many user in the group :)

      Unable to reorder content type

      Have user copy the list template from another site and want to reorder the content type, when click on the column order at the content type you will see the error :

       

      Object reference not set to an instance of an object.   at Microsoft.SharePoint.ApplicationPages.ChangeFieldOrderPage.OnLoad(EventArgs e)
         at System.Web.UI.Control.LoadRecursive()
         at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

       

      Work around:

      you will not be able to manage the order of your columns on the list settings page again until you switch “Allow management of content types” back to No. When the management of content types if enabled, you can then reorder the columns for each specific content type. You may or may not want this to be your standard setup, so my best practice here would be to turn this feature back off when you are finished managing the content type.

       

      Detail step:

       

      1. change the list setting at Advanced settings and change the Allow management of content types to no. > click ok

      2. under the column, you will see Column ordering. Click on the column ordering and change the order.> click ok when you done

      3. change the list setting at Advanced settings and change the Allow management of content types to yes > click ok

       

      guessing of the root cause:

       

      i think because the content type is attach to the template and no content type created for the sites. once you click on ordering, then will go to search the content type gallery at site level. once cannot found it and error message will show at above. i guess is consider bug :)

      Wednesday, October 6, 2010

      Filter the calendar of today event

      The start time at calendar Filter is not available then we cannot use [Today] to filter the item. In this case you just created one column and select Calculated (calculation based on other columns)  then Formula =[Start Time].

       

      after that you can edit the view with filter on column you created is equal to [Today]:

       

      In this example , i created column name as DOB.

      image

      Friday, October 1, 2010

      How to Move Large SharePoint Document Libraries

      Faced some problem to move large SharePoint Document during migration , so found out the solution here.

       

      Scenario : one document library is over 25GB so unable to use stsadm export and import.

       

      Solution: have 2 post is same, so i not sure who is the owner. anyway just like to keep track on the coding and sharing here :)  [This can move different farm :) ]

       

      http://www.law.com/jsp/lawtechnologynews/PubArticleLTN.jsp?id=1202443237483

      http://pravyns.blogspot.com/2010/08/how-to-move-large-sharepoint-document.html

       

       

       

      EXPORT AND IMPORT WITH THE SHAREPOINT OBJECT MODEL

      To accomplish the goal of copying an arbitrarily large document library, and only that document library, from one site to another, we'll need to use a bit of .NET code and the SharePoint object model. The code will perform two broad tasks:

      1. export the source document library to a set of one or more files on disk; and
      2. import the file-set created in step 1 to the target location.

      You could write this code in a number of ways, but for simplicity, I'll create two .NET console applications: ExportDocLib and ImportDocLib. Both these applications must be run on the SharePoint web front-end server of the farm containing the source and target document libraries respectively.

      ExportDocLib exports the source document library to operating system files. To create the application, open Visual Studio 2005 or later, and create a new C# console application. Next, add a reference to the Windows SharePoint Services .NET assembly, and then add "using" statements at the top of the program to reference the Microsoft.SharePoint and Microsoft.SharePoint.Deployment namespaces.

      The rest of the code is fairly straightforward; you will need to provide references to the site collection and the web site within it that contains your document library (I simply referenced the RootWeb property of my site collection because my document library was contained in the top-level web site), a reference to the list to be copied, and information about where to create the export files and export log. I've also instructed SharePoint to retain the security via the IncludeSecurity switch, and to display progress to a command window as the program runs using the CommandLineVerbose switch. There are many other settings you can use, but those shown below are all you'll need for a basic list export:

       

      using System;

      using System.Collections.Generic;

      using System.Linq;

      using System.Text;

      using Microsoft.SharePoint;

      using Microsoft.SharePoint.Deployment;

      namespace ExportDocLib

      {

      class Program

          {

      static void Main(string[] args)

              {

      // Get handle to web and doclib to export

      SPSite site = new SPSite("http://localhost/sites/SITE1");

      SPWeb web = site.RootWeb;

      SPList list = web.Lists["Shared Documents"];

      // Define export settings

      SPExportSettings settings = new SPExportSettings();

                  settings.SiteUrl = "http://localhost/sites/SITE1";

                  settings.FileLocation = @"C:\Export Files\";

                  settings.BaseFileName = "SITE1.cmp";

                  settings.ExportMethod = SPExportMethodType.ExportAll;

                  settings.LogFilePath =

                        settings.FileLocation + "SITE1_export_log.txt";

                  settings.CommandLineVerbose = true;

                  settings.IncludeSecurity = SPIncludeSecurity.All;

      // Add reference to document library to export

      SPExportObject exportObject =

      new SPExportObject(

                              list.ID,

      SPDeploymentObjectType.List,

                              web.ID, false);

                  settings.ExportObjects.Add(exportObject);

      // Export it

      SPExport export = new SPExport(settings);

                  export.Run();

              }

          }

      }

      ImportDocLib is almost a mirror image of ExportDocLib. ImportDocLib will import the document library from the operating system files created by the ExportDocLib program. As before, start by creating a new C# console application in Visual Studio, adding a reference to the Windows SharePoint Services .NET assembly, and by adding "using" statements to reference the two Microsoft.SharePoint namespaces.

      Next you'll create a SPImportSettings object and set its properties to define the location of the import files, the location of the site collection and web site where you want your new copy of the document library, and a location for the import log.

      Although it’s beyond the scope of this article, the RetainObjectIdentity setting is noteworthy because its value will determine whether you can apply subsequent incremental imports to this same document library. For example, you could copy the full library once, and then periodically import only changed or new items from the source into the target library. To enable these subsequent imports, however, the RetainObjectIdentity setting must be set to "true." However, you may not set it to "true" if you will be importing a document library into the same content database as the source library, because all objects in a SharePoint database must have unique object IDs. The most likely scenario for which you would use the RetainObjectIdentity switch is to create a copy of a document library on a different SharePoint farm, and subsequently to refresh that second library with updates from the original.

       

      using System;

      using System.Collections.Generic;

      using System.Linq;

      using System.Text;

      using Microsoft.SharePoint;

      using Microsoft.SharePoint.Deployment;

      namespace ImportDocLib

      {

      class Program

          {

      static void Main(string[] args)

              {

      // Settings for import

      SPImportSettings settings = new SPImportSettings();

      // File & path

                  settings.FileLocation = @"C:\Export Files\";

                  settings.BaseFileName = "SITE1.cmp";

      // Site and web to import to

                  settings.SiteUrl = "http://localhost/sites/SITE2";

                  settings.WebUrl = "http://localhost/sites/SITE2";

      // Set log file location

                  settings.LogFilePath =

                        settings.FileLocation + "SITE2_import_log.txt";

      // Display messages while running

                  settings.CommandLineVerbose = true;

      // Don't retain object GUIDs, only necessary

      // if want to do incremental imports to same list

      // at a later time

                  settings.RetainObjectIdentity = false;

      // Keep security, versions, and date/time stamps

                  settings.UpdateVersions = SPUpdateVersions.Append;

                  settings.UserInfoDateTime =

      SPImportUserInfoDateTimeOption.ImportAll;

      // Import it

      SPImport import = new SPImport(settings);

                  import.Run();

              }

          }

      }

       

      You might correctly observe that both the ExportDocLib and ImportDocLib routines can be combined into a single program. This would simplify the process in that you wouldn't need to execute two separate programs to complete the copy process. But when copying a document library from one SharePoint farm to another, you will need to run ExportDocLib on a WFE server in the source farm, and the ImportDocLib on a WFE in the target farm. Keeping them separate gives you the flexibility you need in such instances.

       

      CONCLUSION

      With just a bit of .NET coding you can copy document libraries of arbitrary size from one site to another, within or between farms, without the need to purchase a third-party product. With a bit of additional coding you can add the capability of applying incremental updates from a master document library to a copy, thus keeping the secondary library in synch.

      At Fenwick & West we have found this technique invaluable for migrating large document libraries between SharePoint farms, filling the gap between the built-in capability to save small libraries using a list template, and backing up full site collections using the backup and export functions of STSADM.

      Monday, September 13, 2010

      Set searchadcustomquery back to OOB setting

      how do you reset the searchadcustomquery to oob setting? which is <Property Exist = “No”> , normally used stsadm the value will showed as <Property Exit=”Yes”, Value=””>”.

       

      to set the value back to <Property Exist = “No”>  , we can use simple coding as below to reset it.

       

      using System;
      using System.Collections.Generic;
      using System.Linq;
      using System.Text;
      using Microsoft.SharePoint;
      using Microsoft.SharePoint.Administration;

       

      namespace reset_customQuery
      {
          class Program
          {
              static void Main(string[] args)
              {
                  using (SPSite site = new SPSite(@"http://abc.com"))
                  {
                      SPWebApplication apps = site.WebApplication;
                      //reset to null
                      apps.PeoplePickerSettings.ActiveDirectoryCustomQuery = null;
                       apps.Update();

                      Console.WriteLine("Done");
                  }
              }
          }
      }

       

      to checking your value you can use the stsadm below:

       

      stsadm -o getproperty -url "http://abc.com" -pn peoplepicker-activedirectorysearchtimeout
      stsadm -o getproperty -url "http://abc.com" -pn peoplepicker-distributionlistsearchdomains
      stsadm -o getproperty -url "http://abc.com" -pn peoplepicker-nowindowsaccountsfornonwindowsauthenticationmode
      stsadm -o getproperty -url "http://abc.dhl.com" -pn peoplepicker-onlysearchwithinsitecollection
      stsadm -o getproperty -url "http://abc.dhl.com" -pn peoplepicker-searchadcustomquery

      Wednesday, March 17, 2010

      Windows SharePoint Services 3.0 Service Pack 1 Retired at 13/07/2010

      woo!!!  are you already upgrade your sharepoint server up to SP 2? if not please act faster!!! Microsoft going to   stop the support for SP1 soon. http://support.microsoft.com/lifecycle/?p1=12200Windows SharePoint Services 3.0 Service Pack 1 Retired at 13/07/2010

      I have some blog to share about the SP2 installation step at here, feel free to have a look. or you can just do search over internet than you will see a lot people share on this :) . If you environment not really have a lot customization then you will easy for the upgrade :)

      Monday, July 6, 2009

      MOSS and WSS June CU !!

      wah!!! are you done your sharepoint April CU?? not yet? but now the June CU is release again!!
      MS release so fast!! ha ha.. so what is your next step? skip April CU ?

      June CU is included April CU , so do you think we need to apply April CU ? :)

      So below is the suggested from Microsoft of the installation sequence:
      The recommendation is from : MOSS and WSS June CU

      Tuesday, May 12, 2009

      WSS & MOSS SP2 is Avaiable - April 2009

      yeah... this round i have involved on WSS & MOSS SP2 deployment for our environment , so the first step i have do is (Guess what is my first step ??) .... As usual as a engineer the first step is google it , ha ha..see what SP2 is talking about.

      After google around then get to understand what is going on but for the detail to install i have some doubt about it.. example, what is the prequest if my system not yet SP1 should i update to SP1 before go to SP2...and some other doubt.

      At last i get the MS sharepoint team blog about the SP2 , that is very good information to start for SP2 deploment,Announcing Service Pack 2 for Office SharePoint Server 2007 and Windows SharePoint Services 3.0

      some information from the blog:
      FAQ

      Q: Can I install SP2 on RTM? Can I install SP2 on RTM + SP1? Can I install SP2 on RTM + SP1 + IU? Can I insall SP2 on RTM + SP1 + some CU?
      A: All yes. SP2 can be installed directly on any build before Febrary 2009. For CU releases after SP2, we suggest you install SP2 first, then apply those CU packages.

      Q: Do I need to run psconfig after the install of every package?
      A: No, apply all the packages, then run psconfig once. In this way the database will only be updated once, to the newest version. Otherwise it would be updated several times, which is a waste of time.

      Q: Do I need to run psconfig on every machine in the farm? I already run it on one of the machines and the database is already updated.
      A: Yes. Although database is already updated. The files on each servers needed to be set permissions using psconfig. Since the database is already updated, the process would be much faster.

      Q: Will Windows Server 2008 SP2 and WIndows Server 2008 R2 be supported?
      A: Yes, they will be supported on their release

      Q: Will there be a MOSS slipstream build?
      A: So far there is no plan to create a MOSS slipstream build. Customers can refer to the slipstream guide on TechNet mentioned earlier in the blog to create their own build based on their needs.

      Look like is easy for the service pack deployment, but the more complicated step is.... the process for deployment.. ha ha ha.. need to ready the document , get the control board to approve and before this need to do testing on lab, QA...then only go for production.

      not sure when we can have the faster way for service pack?? ha ha ha..why microsoft always have service pack...cannot have the perfect product before RTM ?? maybe human is too complicated ... too much combination then cause the error...hi hi.. why have no AI to auto correct the bug??

      Wednesday, September 24, 2008

      !@#$ Cannot uninstall the WSS V2 before Portal

      Recently try to build some SPS2003 server, after build i have face some problem with the Front end server setting so i think is something wrong with the setting. Decide to uninstall the SPS2003.

      click on add remove program then will see wss and sps there, so i think wss is small one then should remove first....#$@#$ after remove the wss then cause the sps unable to uninstall.

      now i have 2 solution:
      1. follow the complecated change to make it can uninstall and install again..(not sure how is the process from Microsoft)
      2. Rebuild server OS . (ha ha, this is my option)
      so anyone thinking to reinstall share point 2003, please take note. uninstall SPS, WSS then only ISS. :)

      Tuesday, January 1, 2008

      search in WSS 2.0 is unable to search sub-sites Document

      ha ha..today i learn new knowledge that is WSS SS 2.0 is unable to search sub-sites Document. If you really want to search the document from a top level sites to all sub sites , you need to have share point portal install.

      another solution is use WSS V3, hi hi, in new version of WSS you can do this!!!