Recent posts

嘿嘿,上两张图图

 

 

[More]

Currently rated 3.0 by 1 people

  • Currently 3/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
  SharePoint SP2正式发布!   相关链接如下:   WSS 3.0 SP2 (KB953338): English:http://www.microsoft.com/downloads/details.aspx?FamilyId=79BADA82-C13F-44C1-BDC1-D0447337051B&displaylang=en English 32位 (x86) 下载地址:http://download.microsoft.com/download/B/2/C/B2CFEE1B-6C7A-438B-A5EB-C9EB04CBBCC3/ws... [More]

Currently rated 5.0 by 2 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

[More]

Currently rated 3.0 by 10 people

  • Currently 3/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

目录

感谢
介绍

第一部分:Excel Services 介绍
     第一章:Excel Services 介绍
              为什么要使用Excel Services
                            Excel客户端Farm
                            模型重写
                            Excel Services达到的效果
              Excel Services的实现目标
                            第一目标——100%地仿真Excel
                            第二目标——安全性
                            第三目标——健壮性和可靠性

     第二章:用户和管理员备忘录
              Excel 2007和Excel Services
                            对象模型支持
                            可扩展模型支持
              开箱即用的Excel Services
                            Excel Web Access
              拓展
                            部分应用
                            大规模应用
              不被支持的功能
                            以前的文件格式
                            VBA
                            Table查询
                            外部工作簿
                            实时数据
                            图片和图形
                            密码保护
                            其他不受支持的功能
                            单向功能
              如何管理Excel Services
                            Excel Services设置
                            受信任文件路径
                            用户自定义函数集
              总结
 
     第三章:深入Excel Services
              会话、状态、工作簿
              缓存
                            工作簿缓存
                            数据缓存
                            缓存考虑
              总结

     第四章:可编程性支持
              Excel Web Services
                            打开和关闭工作表
                            从工作表中得到值
                            写入数据到工作表
                            工作表交互
                            获取整个工作表
                            多种方法
              用户自定义函数集
              EWA Web部件
              总结

 第二部分:Excel Web Services
     第五章:Hello World 例子
              

 

[More]

Currently rated 3.0 by 15 people

  • Currently 3/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

翻译如下:

关于作者

  Shahar Prish出生于以色列。在从事10年之久的电脑工作后,毫无意料地突然成为有熟练技能的专业人员。在他16岁的时候,Shahar在一家对个人电脑做各种备份和加密的公司工作。18岁的时候被征召入伍,在军队里,他用敲过键盘、当过监听员、发放无牛奶巧克力面包等多种方式做着保卫国家的工作。离开军队后,他尝试得到一个控制信号学位但以悲惨失败而告终。他在一个大型电讯公司(在那儿为国际犯罪侦查开发软件)工作有些起色(一些和浏览器有关的工作)。在1998年,他成为一个开发商务智能软件小公司(Maximal Innovative Intelligence简称Maximal)的第一个员工。在2001年,Maximal被微软收购,其产品被重新包装为“Microsoft Data Analyzer”进行销售。Maximal的11个员工迁移到美国开始在Office工作组中工作。到美国一年后,Shahar和其他成员一起开始从事Excel Services(那时候还被称为“Excel Server”)工作。他花费他所有的时间编写代码,并且他打算继续编写代码直到杂草能把他冰冷的双手从键盘撬开为止。(译者love9:英语的玩笑话好玄妙)

原稿如下:

About the Author

  Shahar Prish was born and raised in Israel. He was playing around with computers for 10 years or so when suddenly and unexpectedly it became a useful skill to have. At the age of 16, Shahar started working in a company that did various backup and encryption applications for the PC. When he turned 18 he was drafted to the army where he defended his country from behind a keyboard, a monitor, and way too much non-dairy chocolate bread-spread. When he got out of the army, he tried to get a degree in CS, but failed miserably due to work getting in the way. He worked for a big telecommunication company (where he developed software for international calls fraud detection) and in a small startup (which did something with browsers — it was never really clear). In 1998 he was the first employee in a small company called “Maximal Innovative Intelligence” that developed Business Intelligence software.
In 2001 Maximal was purchased by Microsoft and the product it was selling was rebranded and sold as “Microsoft Data Analyzer”. From Maximal, eleven employees moved over to the US where they started working in the Office group. A year after moving, Shahar started working with the rest of the team on Excel Services (then called Excel Server). After spending most of his life writing code, Shahar intends to keep doing so until the medics pry the keyboard from his dead cold hands.

[More]

Currently rated 3.1 by 16 people

  • Currently 3.125/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

  前几天把主系统由x86的Windows Server 2003 换成了x64的Windows Server 2008 Enterprise ,为了充分发挥Server 2008中的Hyper-V技术,忍疼把自己的开发环境全部重新做了一遍。

  经过几次错误的尝试,完美安装AD、VS2008、SQL2008、MOSS2007、Office2007于一机! 

  可能有人会问:有多完美呢?那我可以自豪地说,完美地连一个系统错误日至都没产生,嘿嘿,怎么达到这种神奇的效果呢!

  现在把我的主要开发虚机的装配及顺序列一些,请尽可能完全按照这个顺序安装(强烈推荐此种安装,N次实践的结果!)::

  1.  Windows Server 2003 R2 SP2 x32 的第一张盘
  2. 为解决1052系统错误日志,增加boot.ini增加 /usepmtimer :此步骤是虚拟机同步主系统时间造成的问题。我的主系统的是64位的Widows2008,如果虚机也是64位的Widows2003,则不会出现此1052系统错误;
  3. 安装系统集成插件,重起;
  4. AD(安装AD的时候同时安装好DNS) ,重起
  5. IIS
  6. Framework3.5 SP1 + Framework 3.5 SP1 语言包
  7. Office SharePoint Server Enterprise Edition x32 (未安装补丁包)  [不删除缓存文件]
  8. Office 2007 Enterprise Edition x32 [默认安装]  (未安装补丁包)  [不删除缓存文件]
  9. Office Designer 2007 Enterprise Edition x32 (未安装补丁包)  [不删除缓存文件]
  10. Office 2007 Enterprise Edition x32 SP1
  11. Office Designer 2007 Enterprise Edition x32 SP1
  12. Visual Studio 2008 Team Edition
  13. Visual Studio 2008 Team Edition SP1
  14. KB942288 x86, SQL Server 2008 Enterprise Edition x32
  15. SQL Server 2008 联机丛书(2008年8月)
  16.  运行配置"SharePoint  产品与技术配置向导",产生“管理中心”
  17. Windows SharePoint Services 3.0 Service Pack 1 (SP1) x32
  18. 2007 Microsoft Office Servers Service Pack 1 (SP1) x32
  19.  压缩磁盘后,7-zip压缩备份!

  如果需要安装64位的环境,请把上述列表中的x32换成x64即可!

[More]

Currently rated 3.8 by 16 people

  • Currently 3.75/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

  最近,一直频繁使用SPQuery或SPSiteDataQuery做SharePoint前后台开发,在基于SPUser的Field进行查询时发现一些比较奇怪的、让人莫名其妙的问题:SPWeb.Users、SPWeb.AllUsers和SPWeb.SiteUsers在不同的域环境和本地环境中出现一些让人不可理解的事情。甚至我都直接怀疑SharePoint设计者在设计开发SPUser这一部分时没考虑周全。下面详述:

  (先画个图,改天补上描述)

  经过反复排查、试验过程如下:

 

  (我晕,上图画了我半个多小时,明天继续更新)

  试验结果如下:

[More]

Currently rated 3.2 by 13 people

  • Currently 3.230769/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

  使用过Microsoft SharePoint Portal Server 2003(简称SPS2003)或Windows SharePoint Services 2.0(简称WSS v2)的朋友可能还会记得,在SPS2003及WSS2.0的管理中心(或使用命令行)可以管理路径:管理包含的路径和排除的路径。通过这种方式可以明确把一些路径标识为可由SharePoint 负责管理(路径包含);也可以明确让SharePoint将忽略某些路径(路径排除),排除的路径可由其他应用程序使用,比如普通的asp.net应用程序可使用路径排序的功能来实现。

  但从最近几年对SharePoint2007(很多时候我用“SharePoint2007”来代替MOSS2007或WSS3.0,如果所述内容在两者中有区别我会明确使用MOSS2007或WSS3.0)的使用来看,并没有发现在MOSS2007(或WSS3.0)中发现路径排除的功能,本周五下午与微软某一SharePoint技术人员交流,被告知“设计sharepoint2003中的‘路径排除功能’的人的脑子就有毛病,压根不需要排除……”,呵呵,偶对此话不敢苟同,今天晚上经过一段时间研究,发现虽然在SharePoint2007的默认管理界面和命令行不能实现“路径排除”的功能,但通过一定的配置就可以轻松达到此目的。

  那么如何做呢?

[More]

Currently rated 3.6 by 9 people

  • Currently 3.555556/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

  想实现一个目的
  在不改变现在SharePoint站点的默认登陆机制(域用户验证、不开启匿名登陆)的基础上,想把原有的存于SharePoint内容数据库中的Default.aspx换为本地(物理磁盘下)站点对应根目录的某个文件,以实现给SharePoint增加不需要验证的欢迎页面等需要

  试验结果
  在SharePoint对应的本地路径下(如C:\Inetpub\wwwroot\wss\VirtualDirectories\80)下添加一个文件比如Index.aspx,那么直接通过http://moss.webplat.net/Index.aspx肯定不能解析到!为什么呢?

  原因是
  默认情况下SharePoint站点在web.config中完全remove掉所有动作为"GET,HEAD,POST"的httpHandlers,见下面的代码

 
  1. <httpHandlers>   
  2.     <remove verb="GET,HEAD,POST" path="*" />                 
  3. ……              
  4. </httpHandlers>  

  然后把URL请求的文件重新使用Microsoft.SharePoint.ApplicationRuntime.SPHttpHandler进行解构。所有不管在本地如何添加文件(这里的“本地”指未被SharePoint排除的位置,wpresources、LAYOUTS等除外),是不可能通过看似正确的URL来访问到本地页面文件。

  那么如何解决呢?

[More]

Currently rated 3.3 by 7 people

  • Currently 3.285714/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

使用Microsoft Office SharePoint Designer 2007改变SharePoint内置页面的默认MasterPage时的一个小提醒:

1、在MOSS2007的页面调整过程中,masterpage分为两种,default.master、custom.master 正式的名字和调用的名字有所不同哦(呵呵);

2、如果需要使用更多的masterpage,调用方式一定要类似于 MasterPageFile="/subSite/.../_catalogs/masterpage/WebDisks,其中,"/subSite/.../"之前为WebApplication的根节点。【特别需要注意的问题:不能用Design自带的“RUL查找(智能感知)”找到masterpage的URL,否则一定报错(作为Designer 的一个Bug,做个记号!)】

 

PS:今天翻找机器,偶然发现一个“开发速记2007-05-30.txt ” ,呵呵,公布一下

[More]

Currently rated 3.3 by 6 people

  • Currently 3.333333/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5