18 New InfoPath Development Articles!

I have finished posting 18 new InfoPath development articles that are available on the main sharepointsecurity.com site for your to browse and learn InfoPath development from, called my “Mastering InfoPath Development Series”. They take you through everything from beginning InfoPath development to building a simple Form WebPart if you don’t have InfoPath available in your environment to use as a design / development tool. I will be extending this series out as I get time, but for those seeking a starting point for InfoPath development, or to maybe pick up some Forms development skills, it should make for some good reading! If you would like, you can visit the main index of the articles here (note, you will be redirected to the main site using these links):

• Q&A for Course 5244 - Introduction to Microsoft WSS 3.0
• Q&A for Course 5245 - Planning the WSS 3.0 Environment
• Q&A for Course 5246 – Deploying WSS 3.0
• Q&A for Course 5248 – Maintaining and Optimizing WSS 3.0
• Q&A for Course 5247 – Administering WSS 3.0

[UPDATE] MOSS-based Internet sites live!!

Content Editor Web Part (CEWP), XML Web Services and JavaScript

As my first blog post, I’ll discuss at a high level three things that I feel are the most powerful tools available to SharePoint admins who have some (client-side) development skills.  The Content Editor Web Part, XML Web Services and JavaScript.  Subsequent posts will describe real-life examples of how this has helped in the SharePoint implementation that I manage.

Step by Step Tutorial. Creating Workflows for Windows Sharepoint Services and MOSS2007 (part 6/20)

step1

step2

step3

step4

step5

step6

  

Semaphore MOSS Edition

Semaphore MOSS Edition adds Semantic Middleware capabilities to the MOSS platform.Semaphore tightly combined with MOSS delivers a world beating search solution, complete with taxonomy management; automatic classification and a contextual user experience at a fraction of the cost of traditional search solutions.

More on SharePoint and Wikis

There’s on article on Collaboration Loop entitled Wither the Enterprise Wiki?

“Meanwhile, companies that have been using wikis internally for a while are now trying to wrestle them into one unified platform—and they need to make sure that as they extend their use to employees throughout the enterprise (or outside of it), the technology is easy to use. “Knowledge workers need tools that are user friendly, that look like something Microsoft would make,” says Jeff Brainard, Director of Product Marketing at SocialText.

FPRPC Call: How to determine if server is 2003 or 2007

To programmatically determine if you are connecting to a server running wssv2 or wssv3 via a FPRPC call, use the server version RPC. 

If the major version is 6, then it’s WSS v2. 

If the major version is 12, then it’s WSS v3.

Pulling Data From SQL Server for Use in Sharepoint 2007

Here is the much anticipated code sample:

Dim Site As New SPSite(”{Enter Your Sharepoint Site}”)

            Dim Web As SPWeb = Site.OpenWeb

            ‘Sql Connection Information
            Dim ClientTable As New DataTable ‘Datatable

            ‘Sql Connection Information
            Dim Connect As New SqlConnection(”Initial Catalog ={Enter a Database};Data Source={Enter a Server};User ID={Enter a User ID};password={Enter a Password}”)
            Dim GetStoredProcedureData As New SqlCommand ‘Gets Stored Procedure
            Dim ClientsDataset As New DataSet ‘Dataset Variable
            Dim StoredProcedureAdapter ‘Data Adapter for Stored Procedure

            Connect.Open()
 

IISReset is bruteforce, there are civilized alternatives (IISApp.vbs) 

I know that bouncing IIS is something that Web Administrators in the past did a lot especially when rolling out new projects to release the memory and release/refresh the cache.  Worker process cycling schedules have reduced some of this, but there are still some cases where when you’ve rolled out a new project, feature, solution, etc… where you need to do this.

I’m sitting in Ted Pattison’s WSS401 class and he has this line in his app and it reminded me there are simplier more civilized ways of doing things.

From the command line

      cscript c:\windows\system32\iisapp.vbs /a “%SharePointAppPool%” /r

Where %SharePointDefaultAppPool% is the app pool you are wanting to cycle.

Unattended and Silent Installs

I haven’t heard much traffic on unattended installs in SharePoint, but hey it is possible, you may want to do it for consistency of building or rebuilding servers in your farm.

Here’s a quick overview.  There are actually 3 commands you need to know.

• Setup.exe - lays down the bits.  Config.xml will answer the setup questions.
• PSconfig.exe - creates the config db, connects to the config db if exists, and creates admin virtual servers, and SSP etc…  This is the equivalent to the configuration wizard.
• STSADM.exe - can create the content web apps, site collections, adding users, deploying features, web parts and solutions.  This is equivalent to the central admin UI for creating your web apps and site collections, but there are deployment things that you can’t do via the web admin.

SharePoint Upgrade Resources

I promised one of my new Facebook friends who is facing a WSS 2.0 to either WSS 3.0 or MOSS 2007 upgrade that I would get some resources for that and post them up. Here you go Angi. Hope these help.

For WSS:

• Plan Web site structure and publishing (Windows SharePoint Services)
• Plan for content and search (Windows SharePoint Services)
• End-to-end deployment scenarios (Windows SharePoint Services)
• Upgrading to Windows SharePoint Services 3.0
• Downloadable books for Windows SharePoint Services
• Development for Windows SharePoint Services 3.0 technology
• Technical Reference for Windows SharePoint Services 3.0 technology

For MOSS 2007:

New and Updated Resources to Help You with SharePoint: Goes Great with a Mocha Latte!

Seems like tonight is resources publishing night. Just got my hands on a slew of new and updated resources that I wanted to make sure I pass along ASAP.

Microsoft Office SharePoint Server 2007: New Places to Find Content:

• Announcing: SharePoint Interoperability Site on TechNet
  • Have you ever wondered how to connect MOSS to ERP systems such as SAP, Oracle Financials, or Siebel? Do you want to know how to setup Search to crawl Lotus Notes datasources? Wondering what WSRP and iViews are? Well, wonder no more!
• Announcing: Enterprise Search Site on Microsoft.com
  • This new site is the focus for Enterprise Search web.
• 10 Information Centers on the MOSS Portal on MSDN
  • Includes new Workflow Information Center and a Web Content Management Information Center.

Microsoft Office SharePoint Server 2007: New Content: