代码改变世界

SharePoint Excel Service - Couldn't Open the Workbook.

2017-11-27 12:44 by 努力学习的小熊, 19 阅读, 收藏, 编辑
摘要: Error meesage: "Couldn't Open the Workbook. Wow, That's a big workbook. Unfortunately, we can't open a workbook larger than 10 MB. You'll need to open阅读全文

User Get 'Access Denied' with Excel Service WebPart

2016-01-20 09:33 by 努力学习的小熊, 60 阅读, 收藏, 编辑
摘要: 用户可以访问网站,并且具有相应的访问权限。用户尝试了其他浏览器和IE的其他版本。解决:将用户添加到 ‘Excel Services Views’ 这个SharePoint组就OK了。阅读全文

How To Search and Restore files from Site Collection Recycle Bin

2015-12-11 15:17 by 努力学习的小熊, 80 阅读, 收藏, 编辑
摘要: $sitecoll = Get-SPSite "http://wheresmydoc.findit.com"$sitecoll.RecycleBin | ?{$_.Title -match "MyDocIsHere.xls"}$sitecoll.RecycleBin.Restore("place ...阅读全文

How To Collect ULS Log from SharePoint Farm

2015-12-11 15:15 by 努力学习的小熊, 126 阅读, 收藏, 编辑
摘要: We can use below commandto collect SharePoint ULS log from all servers in the FarminPowerShell.Merge-SPLogFile--------------EXAMPLE 1-----------------...阅读全文

How To Restart timer service on all servers in farm

2015-12-11 15:11 by 努力学习的小熊, 73 阅读, 收藏, 编辑
摘要: [array]$servers= Get-SPServer | ? {$_.Role -eq "Application"} $farm = Get-SPFarm foreach ($server in $servers) { ...阅读全文

How to Operate SharePoint User Alerts with PowerShell

2015-11-12 10:19 by 努力学习的小熊, 322 阅读, 收藏, 编辑
摘要: When you migrate list or site, the user alerts in the site will not be migrated together with the content. Below content can help you to do this task....阅读全文

How to get Timer Job History

2015-11-12 10:11 by 努力学习的小熊, 119 阅读, 收藏, 编辑
摘要: 1. Get Timer Job internal name with id.Job ID can be found in SharePoint CA.Below PowerShell can help you retrieve all jobs’ Internal Name by keywords...阅读全文

Synchronization Service Manager

2015-11-12 09:56 by 努力学习的小熊, 59 阅读, 收藏, 编辑
摘要: You can use this UI Shell to check the User Profile log for the SharePoint.It's stored in this path.C:\Program Files\Microsoft Office Servers\14.0\Syn...阅读全文

SharePoint 2007 Full Text Searching PowerShell and CS file content with SharePoint Search

2014-02-26 22:20 by 努力学习的小熊, 260 阅读, 收藏, 编辑
摘要: 1. Ensure your site or shared folder in one Content Source. 2. Add file types. 3. The second step in getting the file extensions recognised is to add it to the registry entries the SharePoint Server Search service reads when it starts up. This key is located at HKEY_LOCAL_MACHINE\SOFTWARE\M...阅读全文

0x80040E14 Caused by Max Url Length bug

2013-12-10 16:32 by 努力学习的小熊, 138 阅读, 收藏, 编辑
摘要: We get a case when the customer access a SharePoint site, he meet an error on SharePoint. 0x80040E14.Firstly, I think it’s a SQL Storage space issue.http://www.cnblogs.com/Bear-Study-Hard/archive/2008/05/22/1204794.htmlhttp://www.cnblogs.com/Bear-Study-Hard/archive/2009/06/05/1497133.htmlBut it’s no阅读全文

SharePoint 2007 User Re-created in AD with new SID issue on MySite

2013-12-10 16:26 by 努力学习的小熊, 596 阅读, 收藏, 编辑
摘要: When active directory users get deleted and re-created, even with the same user id, there's a nasty side effect. Each time they try to access their "my site", they will receive the following error: The file exists. (Exception from HRESULT: 0x80070050) The reason is because when active 阅读全文

SharePoint 2007 Prompt for Credentials When Accessing FQDN Sites From a Windows Vista or Windows 7 Computer

2013-04-05 11:07 by 努力学习的小熊, 342 阅读, 收藏, 编辑
摘要: I’d like to sharing a solution of this issue on SharePoint 2007.User was prompted for his/her password when they open document library with Windows Explorer even though he/she was already logged in at the customer portal.I found the solution in Microsoft KB. Almighty MS KB!http://support.microsoft.c阅读全文

SharePoint 2010 找回丢失的Social Collaboration Web Parts

2012-12-29 10:50 by 努力学习的小熊, 423 阅读, 收藏, 编辑
摘要: 这个问题发生在从 SharePoint 2007 升级到 SharePoint 2010之后。一些本来可用的 WebPart 消失掉了,变为不可用。 例如 Social Collaboration Web Parts: 解决办法也很简单,重新激活 PortalLayouts 这个Feature 即可。 1. stsadm命令行方式 stsadm -o deactivateFeature -name “PortalLayouts” -url “http://portal.wherever.com/sites/collectionname” stsadm -o activateFeature ..阅读全文

SharePoint 客户端经常弹出Windows验证登录框问题

2012-08-28 15:40 by 努力学习的小熊, 1363 阅读, 收藏, 编辑
摘要: 场景描述: Site工作人员UserA创建了一个Task,并且Assign给UserB。UserB接到来自Task List的邮件通知。这时UserA发现Assign的人错了,重新修改Task Item,将任务重新Assign给另外一个用户UserC,并且同时收回了UserB的访问权限。UserB报告,每天打开OUTLOOK后,就会遇到很到此弹出Windows验证登录框,要求登录,并且输入多次后仍然弹出。 解决: 让用户Check他在OUTLOOK中的Task,在从SharePoint的Task List中Assign给他任务时,他收到邮件的同时也会在他的OUTLOOK的Task中将T...阅读全文

SharePoint 2007 Edit in Datasheet时遇到"The selected cells are read-only."问题

2012-06-27 13:35 by 努力学习的小熊, 448 阅读, 收藏, 编辑
摘要: SharePoint 2007 的List都具有Edit in Datasheet的特性,当然需要本地安装Office才提供这个功能。通过List的Action菜单中的对应选项即可进入这个编辑功能。 但是对于Multiple lines of text类型的Column在这个模式下编辑就会遇到"The selected cells are read-only."这个问题。 我们需要将这个Column的Setting做一下修改,目前Enhanced rich text (Rich text with pictures, tables, and hyperlinks) 是不支持阅读全文

SharePoint 2007 "Select People and Groups"中搜索不到其他Domain账户的问题[已解决]

2012-06-21 17:00 by 努力学习的小熊, 370 阅读, 收藏, 编辑
摘要: 问题描述: 在一个SiteCollection中添加用户的时候发现来自另外一个Domain的账户无法添加。我们要添加NNEAS\HIKC到当前网站并赋予Full Control权限。但是当点击Add Users后发现在弹出的Select People and Groups中搜索不到这个用户,导致无法添加成功。仅能将来自NNE\HIKC同一个人在不同Domain中的账号添加进去。 登陆CA服务器并检查User Profile发现这个用户在两个不同Domain下的账号是可以在这里搜索到的。 解决办法: 使用stsadm命令行工具在服务器端添加用户。 ...阅读全文

SharePoint 2007 计算列公式错误解决一例: The formula contains a syntax error or is not supported

2012-06-12 13:34 by 努力学习的小熊, 486 阅读, 收藏, 编辑
摘要: SharePoint 2007计算列,按照微软Office的官方说明,我们应该这样使用。 http://office.microsoft.com/en-us/windows-sharepoint-services-help/examples-of-common-formulas-HA010105479.aspx?CTT=3 但是在不同的语言版本的SharePoint上会碰到同样的公式,却变的不可用,并且提示给你这样的错误。 The formula contains a syntax error or is not supported. 例如一个日期的计...阅读全文

How To: 用 SharePoint 计算列做出你自己的KPI列表

2012-06-12 13:17 by 努力学习的小熊, 1124 阅读, 收藏, 编辑
摘要: 关于这个计算列的应用我是利用公司的网络在国外的blog看到的,国内需要翻墙才能看到,真不知道这有什么可封的,唉……分享给大家吧:) 要做成这个KPI效果需要一个辅助的Column。我先简单叙述一下场景。一个SharePoint Task列表,我们要根据Today和Due Date两个时间之间的关系来显示不同的KPI。 规则是这样的: 1 Today < Due Date = Green Status Icon 2 Today >= Due Date = Red Status Icon 3 Due Date not filled out = N/A 1 Cr...阅读全文

SharePoint 2007 如果在计算列中使用Today变量

2012-06-12 10:57 by 努力学习的小熊, 877 阅读, 收藏, 编辑
摘要: 默认情况下在SharePoint计算列的公式中是没办法使用Today这个变量的。如果使用,在保存的时候我们会得到这个错误信息。 Calculated columns cannot contain volatile functions like Today and Me. 这就没办法使用了么?当然不能,我们可以骗过系统使这个Today变量变得可用。 方法就是创建个名为Today的Column。 然后编辑公式,使得公式保存不会出现这个提示错误。但是这时公式的计算结果还是根据这个Today的Column的值来计算的。最后一步,删除掉这个Today Column,这时你会发现计...阅读全文

MOSS 2007 / WSS 3.0 运行在Windows Server 2008上不能上传大于28M的文件【续】

2012-04-16 16:45 by 努力学习的小熊, 553 阅读, 收藏, 编辑
摘要: 今天在群里受教于店饭宝同学:除了要修改SharePoint的Web.config之外,如果还是继续出现这个错误,可以找到这个文件修改C:\Windows\System32\inetsrv\config\schema\IIS_schema.xml <attribute name="maxAllowedContentLength" type="uint" defaultValue="30000000" /> 可以根据实际上传大小的要求增加defaultVaule的大小。有组织就是好啊……感谢邹宝兴同学阅读全文