SharePoint (2003 thru Online)

Thursday, June 26, 2014

No companies found (DEFAULT). TimeClockPlus-TCP


No companies found (DEFAULT).

When you are using multiple companies and login thru Web Clock, sometimes, you may not see the companies drop down and may see the above error.

You need to make sure Multi Company Module is loaded.


And also make sure the Auto Update is done for Web Clock.



To do the Auto Update for Web Clock, type /AutoUpdate30/Login.aspx next to the Web URL and click OK. Select the Company from the Drop down and user ADMIN login.


Click on Update, Accept the License, again click on Update.


Click on Exit once the process is completed.

Now you will be able to see Companies Drop down when logged in as USER and MANAGER.


Thursday, June 19, 2014

STSADM


Microsoft Office SharePoint Server 2007 includes a very powerfull tool the Stsadm, stsadm is for command-line administration of Office SharePoint Server 2007/Moss 2007 you can use this sharepoint 2010 also. it can be used for server and sites stsadm can be used by command line or by using batch files or scripts. There are certain operations and certain parameters that are only available by using theStsadm command-line tool.

Where the STSADM is Located
Stsadm is located at the following path on the drive where SharePoint Products and Technologies is installed: %COMMONPROGRAMFILES%\microsoft shared\web server extensions\12\bin. You must be an administrator on the local computer to use Stsadm.Many a times people think of running stsadm.exe commands from any command prompt.  So here is the way:
1. Open command prompt
2. Type in the following command:  @set PATH=C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN;%PATH% 
(This Command does not work on WSS 2.0)

In WSS 2.0
Try CD C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\BIN
and run the below Commands.

3. You can now run the stsadm.exe commands from anywhere in the command prompt
_________________________________________________________________________________
To get the IDs of the Solutions use the below Command

stsadm -o enumdeployments
_________________________________________________________________

To CANCEL the deployment of the Solution use the below Power Shell Command.

stsadm -o canceldeployment -id "ae9d211d-83d2-47c4-a0c0-c6251a423675"
_________________________________________________________________

STUCK ON DEPLOYING

Make sure all deployments are set to DEPLOYING before stopping the services.
MY ENVIRONMENT
Command prompt, run as Admin on WFE and SQL if you are running SSRS integrated mode.
Stop the SharePoint Admin Service
Stop the SharePoint Timer service
1) Run stsadm -o execadmsvcjobs on your CA server.
2) Run stsadm -o execadmsvcjobs on all the farm members that have stsadm.
3) Restart the Timer Service on all farm members.
4) Restart the SharePoint Admin service
That should fix it. 

Wednesday, June 11, 2014

Sharepoint Permissions Manager

https://permissionsmanager.codeplex.com/

Project Description


Managing permissions in SharePoint is a complex and often difficult to understand by end users. In addition, features for managing permissions on a site are splitted on several screens and must access on each item to finely manage the associated rights. When the site is important, it quickly becomes difficult to obtain an overview of permissions and each change creates a lot of work. 

This version works with WSS 3.0/MOSS 2007 and Sharepoint 2010

Functions


This tool aims to bring together on one screen, most of management capabilities of permissions for an entire site: 
- Overall display permissions for groups on the Sharepoint libraries and website pages 
- Adding, modifying, deleting permissions with a few clicks without having to go through a lot of screens (using JQuery)
- Export as an Excel table permissions 
- Copy permissions between lists and pages

Planned on future version :
- Import / export permissions as XML (very useful in cases of misuse by the user) in order to quickly restore a configuration permissions

SharePoint ULS Logs

Where are the SharePoint ULS Logs?

If you are looking for the SharePoint ULS Logs,  the default path log locations are below:

For SharePoint 2010: 
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\Logs

For SharePoint 2013:
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\Logs

Optionally, if you wish to change the location of the ULS logs, you can do so in Central Administration: 


  1. In Central Administration, click on Monitoring
  2. You can then click on "Configure diagnostic logging" to alter the path to the diagnostic Trace Logs
  3. To alter the usage logs, you can click on "Configure usage and health data collection" and alter the path for the logs under Usage Data collection Settings.












Now, if you wish to view and actually MAKE SENSE of the ULS Logs, then you will want to use one of the various ULS Log Viewers that are available for download:

http://ulsviewer.codeplex.com/

http://sharepointlogviewer.codeplex.com/

http://archive.msdn.microsoft.com/ULSViewer/


The ULS Log Viewer that you choose is largely a matter of personal preference, but it seems that the CodePlex projects seem to provide more functionality than the ULS Log Viewer provided on the MSDN Code site.

If you need to view ULS Logs from a SharePoint 2013 installation, ONLYthe http://sharepointlogviewer.codeplex.com/ project provides SharePoint 2013 support.

"Remove Server Farm Configuration Not Complete" Warning




The Central Admin URL should be part of Trusted Sites. Otherwise, many features will not work properly.




Go to Central Administration > Application Management > Check Services Enabled in this Farm
Clear the Errors logged here.



Once all the Errors are cleared in the above screenshot,

1. We need to create New Web Application (Root Web App).
2. We need to create a SSP (Shared Service Provider) for the farm.

If you don't see any other errors while going thru the process, this will help you to get rid of the above message.

Tuesday, June 10, 2014

Your changes could not be saved because this SharePoint Web site has exceeded the storage quota limit. You must save your work to another location. Contact your administrator to change the quota limits for the Web site.



Error Messages:

Your changes could not be saved because this SharePoint Web site has exceeded the storage quota limit. You must save your work to another location. Contact your administrator to change the quota limits for the Web site.

You see the below error when you try to upload the Files to a Document Library.



You see the below error while trying to drag files in the Folder opening the Library with Windows Explorer.

"Error 0x8007050F: The requested file Operation failed because the storage quota was exceeded.


To free up disk space, move files to a different location or delete unnecessary files. For more information, contact your system administrator."





You see the below error message while working with Workflows.




Solution:

Run this query on all the content databases : get the site which has the Quota limit set.

SELECT s.DiskUsed, s.DiskQuota, w.FullUrl from webs w join Sites s on w.SiteId = s.Id where s.DiskUsed > (s.DiskQuota * 0.9) and DiskQuota != 0

Make a note of the output of the above query. 

Run the following command and make sure what is the quota limit on the site collections on individual web applications and check the Quota Size:

Stsadm -o enumsites  -url


Run the below command to update the quota.

stsadm -o updatequota
 -quotaname <quotaTemplateName> [-contentdb <database name>]     [-nologfile][-quiet]


stsadm –o updatequota –contentdb WSS_Content

In my case, we don't have Quota Template and any Quota already set. I think the default Quota Limit came into picture and caused the error.
It also showed error message when i ran the above command. But looks like the limit was set to "0".

I was able to upload files directly and using Windows Explorer.


You can use the above tool to updates Site Quotas using Quota Template.




Tuesday, June 3, 2014

NINTEX - Problems and Solutions


"The workflow name is used elsewhere on this site. Please choose another name."

Problem: 
I had a list that implemented ABC workflow, but I deleted this list without remove it. Could you tell me how can I import ABC workflow with the same name? While importing a workflow, If you receive a message: "The workflow name is used elsewhere on this site. Please choose another name". The list is really deleted. Checked in the bin + the admin bin.

Solution:
Suggestion from Nintex Support: There is a hidden list that contains the workflow definition files. You may need to remove the relevant folder (with the workflow name) to remove the workflow completely. 
If your site is http://devtest.dev.com/sites/devtest/ 
the URL would be http://devtest.dev.com/sites/devtest/NintexWorkflows/

Please note after deleting the folder name with problematic workflow name it will be removed completely and not be able to be recovered unless you re import and publish the workflow.

You may also find the following document of interest 

______________________________________________________________________________________________
"Nintex Workflow Settings missing"

Problem: 
Nintex feature is enabled at Site Collection Features and Site Features but still when you go to Workflow Settings of List or Document Library you are unable to see the Nintex workflow menu thru Workflow Settings. 



Work around Solution:
Add the below part to the end of the URL after Sites or Lists or Libraries.
Use the the ListId of the List or Doucment Library for which you  want to go to Nintex Workflows Gallery.

"_layouts/NintexWorkflow/WorkflowGallery.aspx?ListId={7C1FC2A8-27B8-4730-ACD1-D269C53ABCC1}"

This will take you to the page where you can see the option to view the existing workflows and create new workflows (as shown below).



For Example:
https://dev.devsp.com/sites/corp/test/Nin_test/_layouts/NintexWorkflow/WorkflowGallery.aspx?ListId={7C1FC2A8-27B8-4730-ACD1-D269C53ABCC1}

Thursday, May 29, 2014

NINTEX - Fixing "User Cannot Be Found" in SharePoint 2010 Workflow Settings - Nintex Workflows


Fixing "User Cannot Be Found" in SharePoint 2010 Workflow Settings

*****Do not delete and try to republish the workflows after deletion. This will cause many issues and the related Workflow Tasks from the "Workflow Tasks" library will get deleted automatically.*****

SharePoint Designer Workflows

We started getting this error overnight on our SharePoint 2010 farm. Workflows stopped working, we couldn't republish list workflows, and we couldn't access the Workflow Settings page for any list or library on the entire site collection. The following error would appear:

"User Cannot Be Found"





Opening SharePoint Designer at the site collection level, we discovered that the Globally Reusable Workflows and Reusable Workflows were owned by user accounts that had been deleted. In order to fix this we used SharePoint Designer to open every workflow and clicked Publish with a static user account (i.e. the Farm service account or App pool service account). After republishing, all started working again.

______________________________________________________________________________________________
Files
However, it seems as though files stored under the OLD profile in SharePoint do NOT automatically get updated with new owner settings when this happens.  Again, in our case, I was trying to run the Copy To SharePoint on files uploaded last April, before the change.  NONE of them would copy; all would fail with the above error string.  Yesterday with Nintex Support on the phone, we tried an experiment by downloading and re-uploading the affected files.  Once that was done, they could be copied without error. 
This post is just to make you all aware that IF you have made any AD profile changes like the one here, it *may* cause issues with the Copy to SharePoint action.  

________________________________________________________________________________________________
Nintex Workflows

You can resolve the issue using SharePoint Designer. You need to run the SharePoint Designer with the account listed in Farms Administrator & Site Collection Administrator Groups.



You can also use Command Prompt to start the SharePoint Designer using the below Command

C:\>runas /profile /user:dev\devacct "C:\Program Files (x86)\Microsoft Office\Office14\SPDESIGN.EXE"
Enter the password for dev\devacct:





When you see the above error while you are using Nintex Workflows, you need to use SharePoint Designer and go to the location >> sites/corporate/_catalogs/wfpub/



Click on "Approval - SharePoint 2010", you will see the below listings. check in and check out the item for which you see the username which doesn't exist (found that the out of the box user was set to a claims based format e.g. "0;#id")


After checking in the item, REFRESH the page, you will see the sign changed after which the workflows started working.


Check all the root Site Collections and clear the usernames which has issues.



Monday, May 19, 2014

Reset and Fix Incorrect or Wrong Password for Windows XP Mode (XPMUser)

Reset and Fix Incorrect or Wrong Password for Windows XP Mode (XPMUser)


Log On with Default Administrator Account
It’s possible to try accessing Windows XP Mode with the default administrator account named “Administrator”, which has been made to only display in Safe Mode. By default, there is no password for Administrator account, so it can be used to reset the password of the password of other accounts.
To do this, please perform the steps below:
  1. On Windows XP Mode window, click on Tools -> Disable the Integration Features.
  2. Restart the Windows XP Mode.
  3. When the Boot Menu appears at startup, press F8.
    Note: Keep pressing the F8 key until the Windows Startup menu appears.
  4. On the Windows Advanced Options Menu, select Safe Mode and press ENTER.
  5. Log into Windows by using the Administrator account and password.
    Note: The password is blank by default unless you already set a password.
  6. After logging into Safe Mode, click Start, go to Run, type in nusrmgr.cpl and press ENTER.
  7. Choose the user you want to modify and Click Reset Password.
  8. Set a new password.
  9. Click Advanced tab, Click Advanced button.
  10. Click Users.
  11. Choose the user you want to modify in the right pane. Right it and Click Properties.
  12. Check and tick the box of Password never expires.
  13. Click OK.
  14. Quit the settings and restart Windows XP Mode to the normal mode.
  15. When log on to Windows XP Mode, remember to check the box Remember my credentials so that you no need to enter the password again.

Thursday, May 8, 2014

"An error has occurred while accessing the SQL Server database or the Office SharePoint Server Search service. If this is the first time you have seen this message, try again later. If this problem persists, contact your administrator.”

I recently had an interesting issue where we were getting the following errors accessing the User Profiles and properties link within SSP.

“An error has occurred while accessing the SQL Server database or the Office SharePoint Server Search service. If this is the first time you have seen this message, try again later. If this problem persists, contact your administrator.”

Notice in the below picture that the schedule fields are blank.

When accessing “Configure Profile Import”, you will see the following error:

An error has occurred while accessing the SQL Server database or the Office SharePoint Server Search service. If this is the first time you have seen this message, try again later. If this problem persists, contact your administrator.



Also, within the Configure Profile Import page, you will see the following error within Incremental Import Schedule & Full Import Schedule:

“Unable to obtain schedule information. Please verify that the job server is up and connected to the farm.”


As a result, profile imports are unable to be scheduled.

This can happen when one of the hidden SSP timer jobs is deleted via pwoershell command (stsadm –o deletessptimerjobs) or accidentally while mis-handling the server re-boot hierarchy. Specifically in this case, the User Profile Incremental Import Job timer job was missing accidentally while mis-handling the server re-boot hierarchy.

 You can run the following from the bin directory to validate the missing one of the SSP timer jobs.

stsadm –o enumssptimerjobs –title “nameofssp”

SSP Timer Job Id="d29a1e4b-268d-4bb8-90b9-003935407f6b" Display Name="User Profile Change Job"
SSP Timer Job Id="80395702-10aa-46bb-91f8-014bedaf7184" Display Name="Audience Compilation Job"
SSP Timer Job Id="3565824b-d79a-4b5e-9af9-06653c8564b0" Display Name="User Profile Full Import Job"
SSP Timer Job Id="a7e410e3-abdf-4833-b9fe-a2e8b2863182" Display Name="Distribution List Import Job"
SSP Timer Job Id="1fad8b5e-6b2b-48f3-ae79-aa17afb5ca11" Display Name="User Profile Change Cleanup Job"
SSP Timer Job Id="1zfl8b5a-9g3g-59q9-wr41-mm22afb7kia1" Display Name="User Profile Incremental Import Job"

In this particular case, the User Profile Incremental Import Job was missing. Unfortunately, the only supported resolution is creating a new SSP or restoring the SSP from backup. I've seen some external public documentation suggesting a fix which includes directly editing the associated SharePoint SSP database. Please be aware that any direct edits to the database is strictly unsupported by Microsoft. 

Friday, May 2, 2014

Time Clock Plus - Database Connection Settings


Below are the settings for Web Edition of the Time Clock Plus on Server.

1. Open the TCPCONN.XML existing in C:\TimeClockPlus-WebEdition-30\tcp-we-30\Config  using Notepad.


and


ConnectionOptions in TCPCONN.XML


<?xml version="1.0" encoding="utf-8"?>
<ConnectionOptions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Port>0</Port>
  <Pooling>true</Pooling>
  <NetworkLibrary />
  <MaxPoolSize>0</MaxPoolSize>
  <Encrypt>false</Encrypt>
  <ConnectTimeout>10</ConnectTimeout>
  <ServerName>dev\dev</ServerName>
  <DatabaseName>TCPlus</DatabaseName>
  <UserId>Username</UserId>
  <Password>Password</Password>
  <Integrated>false</Integrated>
</ConnectionOptions>

2. Update the ServerName, DatabaseName, Username and password correctly.

Open the TCP Client and verify that you are connected to correct database. You can see the server name in the right -down corner.
_______________________________________________________________________________
Below are the settings for Client Edition of the Time Clock Plus for Users.

Open the TCPCONN.XML existing in C:\Program Files\TimeClock Plus 6.0  using Notepad.



The rest is the same process as above.

Thursday, May 1, 2014

Change from "Detail View" to "List View" of for all the Groups in the Site Collection.

On Site Collection, go to Site Actions >> Site Settings.
Under User Permissions, click on People and Group. On the default Group, go to Settings >> List Settings.


Open the List view and make it default. You can also add more columns like Email.


You can see the List Settings,  when your Account listed  "Site Collections Administrators".


Tuesday, April 29, 2014

Color coding to your SharePoint list columns

Color coding to your SharePoint list columns

We can also try this awesome FREE Tool. We need to install on the server where SharePoint is installed.While installation, this tool will verify the pre requisites.


http://www.pentalogic.net/sharepoint-products/free-stuff/html-calculated-column
MOSS 2007 setup
  1. Go to http://pathtosharepoint.com/Downloads/Forms/AllItems.aspx, expand the HTML Calculated Column group header and download a copy of the TextToHTML-v2.1.1 text file.
  2. Upload the HTML script file to a document library on your site. As you can see in the screen shot below, I uploaded my file to a document library named Site config files. It doesn't matter what document library you use to store your file, but make sure all site users have at least read-only access to the library you use. This will ensure the HTML script file can be accessed to render the color coding you’re going to set up.
  3. Validate that the SharePoint list or document library that you want to color code is set up with a Priority field with the following basic settings. (Note that these settings come with the out-of-the-box Priority site column, which you can add to your list or document library.)
  4. Browse the color formatting options at http://blog.pathtosharepoint.com/2008/09/01/apply-color-coding-to-your-sharepoint-lists/ and determine which option (e.g. traffic light indicator, font color shading, background shading, KPI icon indicator) you’d like to implement.
  5. Copy the formula provided for your desired formatting. In my case, I’m looking to implement a traffic light indicator so I copied the following formula:
    ="<DIV style=’font-weight:bold; font-size:24px; color:"&CHOOSE(RIGHT(LEFT(Priority,2),1),"red","orange","green")&";’>&bull;</DIV>"
  6. Add a new calculated column to your SharePoint list. Paste the HTML formula string you copied into the new column’s Formula field. Click OK to save your changes.

  1. When you return to your list view, you’ll see your new calculated column displaying with <DIV> tags. Not very attractive.

  1. To correct this issue, we’re going to add our HTML script to the page. Click on Site Actions > Edit Page.
  2. Click Add a Web Part and add a new Content Editor Web Part to your page.
  3. Move your new Content Editor Web Part (CEWP) to the bottom of the page. You need it to display below your list view web part.
  4. Click on the CEWP’s open the tool pane hyperlink.
  5. When the web part configuration panel appears, place your cursor in the Content Link field and enter the location where you stored your HTML script file. Click OK to save your changes.
That’s it! Your formatting is applied and your page should now display your new color coded field. Here’s a screen shot of my finished view, complete with a Priority Level column that displays red, yellow and green traffic lights that correlate with the priority level of each help desk request:

Now that you've set up color coding on one list view, you can continue adding more color coding to this view or add color coding to other views. Note that you will need to add one CEWP to each list view page that you want to color code. There is no limit, however, to the number of calculated columns with HTML encoding you can add to your list.
SharePoint 2010 setup
  1. Validate that the SharePoint list or document library that you want to color code is set up with a Priority field with the following basic settings. (Note that these settings come with the out-of-the-box Priority site column, which you can add to your list or document library.)
  2. Browse the color formatting options at http://blog.pathtosharepoint.com/2008/09/01/apply-color-coding-to-your-sharepoint-lists/ and determine which option (e.g. traffic light indicator, font color shading, background shading, KPI icon indicator) you’d like to implement.
  3. Copy the formula provided for your desired formatting. In my case, I’m looking to implement a traffic light indicator so I copied the following formula:
    ="<DIV style=’font-weight:bold; font-size:24px; color:"&CHOOSE(RIGHT(LEFT(Priority,2),1),"red","orange","green")&";’>&bull;</DIV>"
  4. Add a new calculated column to your SharePoint list. Paste the HTML formula string you copied into the new column’s Formula field. Click OK to save your changes.
  5. When you return to your list view, you’ll see your new calculated column displaying with <DIV> tags. Not very attractive.
  6. To correct this issue, we’re going to need to modify this new calculated column. Open your site in SharePoint Designer 2010.
  7. Click on Lists and Libraries in your SharePoint Designer 2010 navigation bar. When the list of your site’s document libraries and lists display, click on the list or document library we’re working on.
  8. When the list or document library details page displays, look for and click on the name of the view you’re applying color coding to. In my case, I am updating the All Issues view.
  9. Once your view opens, click on of the fields that are displaying those ugly
    tags. Notice that the <xsl:value-of> tag in the bottom right-hand corner of your screen lights up in yellow once your field is selected.
  10. Hover over the <xsl:value-of> tag until a black drop-down arrow appears. Click on the drop-down arrow and select Edit Tag…
  11. A dialog box will pop up with the following text:
    Place your cursor between the last quotation mark and the closing > bracket. Now type the text disable-output-escaping=“yes”
  12. Your Quick Tag Editor box should now read like this:
  13. Click on the Quick Tag Editor box’s green check mark icon to save your changes. Your SharePoint Designer page will refresh and your color coding will appear!
  14. Click File > Save to save your changes.
That’s it! Your formatting is applied and your page should now display your new color coded field. Here’s a screen shot of my finished view, complete with a Priority Indicator column that displays red, yellow and green traffic lights that correlate with the priority level of each help desk request:
Now that you've set up color coding on one list view, you can continue adding more color coding to this view or add color coding to other views. Note that you will need to modify the <xsl:value-of> tag for each column you want to display in HTML format. There is no limit, however, to the number of calculated columns with HTML encoding you can add to your list.