Thursday, April 16, 2009

Deploy InfoPath Form Templates to a SharePoint Library

Creating a browser-compatible form template


The compatibility setting of a form template can be InfoPath, in which case it will only work in the InfoPath client, or InfoPath and InfoPath Forms Services. This compatiblity setting is made when designing the form template, but can be changed at any point during form template design. To check the compatiblity settings of a form template, use the following steps:


Open Infopath 2007






On right hand side we can add controls to the form




Drag & Drop controls to the form




We added a Text box




1.     On the Tools menu, click Form Options.




2.     Select the Compatibility category.


3.     To make a form template browser-compatible, select the appropriate setting in the Browser compatibility section of the dialog box.


4.     Click OK.




 


You can click Change compatibility settings on the Design Checker task pane to go directly to this category in the Form Options dialog box. The Design Checker task pane and the status bar indicate the form template's current compatiblity setting. For more information about using this task pane, click Help with Design Checker at the bottom of the task pane.


 


In Tools Menu click on Submit Options




Check checkbox "Allow users to submit this form"


Select radio button "Send form data to a single destination"


Select "SharePoint document library" from drop down list


Choose a data connection for submit>Click on Add button


 



Provide Custom List URL  [copy from IE address bar]


We created a custom list called "Infopath Form Results" on http://app


 




Filename format can be selected as shown below. verify it using fx button on right.


If you want to overwrite file with same name check checkbox "Allow overwrite if file exists"


Click Next




We can change the name of data connection


Click Finish



Click Ok on submit options




Publishing a browser-compatible form template


Publishing a browser-compatible form template that does not contain code creates a browser-enabled form template. The form template compatibility setting must be InfoPath and InfoPath Forms Services before it can be published. To publish a browser-compatible form template to a SharePoint library, follow these steps:


1.     On the File menu, click Publish.


 



2.     Select To a SharePoint server with or without InfoPath Forms Services and click Next.




3.     Type the URL location of a server running Office SharePoint Server or InfoPath Forms Services and click Next.





4.     Select Document Library and click Next.




5.     Select Create a new document library and click Next.




6.     Enter a name and optional description for the new document library and click Next.



7.     Select fields from the form template that you wish to display as columns in the document library and click Next.


Click on Add



Select a field to display as column name We selected field1 which is the textbox we added to form


Check Allow users to edit data in this field by using a datasheet or properties page




On warning prompt click OK




After adding all columns Click Next




8.     Click Publish.




9.     Once the form template is published, you can choose to e-mail the location of the form template or open the library in the default Web browser by checking the appropriate boxes.


10.  We checked following option> Open this document library


Click Close.


 



 


By default, when you create a new form in a SharePoint library containing a form template, the form will open in InfoPath if Office InfoPath 2007 is installed on the computer. To see what the browser-enabled form template looks like in the Web browser, follows these steps:




1.     In the newly-created document library, choose Form Library Settings from the Settings menu.




2.     In the General Settings section, click Advanced settings.




3.     Click Display as a Web page in the Browser-enabled Documents section of the Form Library Advanced Settings page.




4.     Click OK.


5.     Click the link near the top of the page to return to the document library.


6.     Click New to open the form in the Web browser.



7.     Form opens in Browser


 



Change data in Text box and click on Submit


 We will get following message "The form was submitted succesfully"




We can check the data submitted in the document library "Infopath1" on SharePoint site.










  Note


Change this setting back to Open in the client application if you prefer users to fill out the form in InfoPath when it is available on the client computer. If Office InfoPath 2007 is not available, users will be able to fill out the browser-enabled version of the form template in a Web browser.


 



If Form prompts with following message Click on Replace Form Template on your computer


 


Form opens in Infopath




Fill the form and click on Submit


Reference :  http://msdn2.microsoft.com/en-us/library/bb250997.aspx


===THANK YOU===

SharePoint Service Account Requirements

For SINGLESERVER installation which uses SQL Desktop Engine (\MICROSOFT##SSEE for WSS3.0 & \OFFICESERVERS for MOSS 2007)Network Service can be used as Service Account

For WFE or APPLICATION (Not available in WSS3.0) installation which uses SQL Server Full version SQL 2000+SP4 OR SQL 2005+SP2 We need a Domain Account

SharePoint can also be installed in a Workgroup where the Service Account is a Local Administrator account

SharePoint Service Account Requirements are as follows:

1. Domain Admin OR Domain User + Local Admin on SharePoint Server

2. In User Properties, Check Passoword never expires

To Change the password:
A. Change password from AD
B. Run Script in KB 934838 How to change service accounts and service account passwords in SharePoint Server 2007 and in Windows SharePoint Services
http://support.microsoft.com/kb/934838

3.Member of Local Groups all _WPG groups on SharePoint Server (For WSS3.0 & MOSS 2007: IIS_WPG, WSS_WPG, WSS_ADMIN_WPG & WSS_RESTRICTED_WPG)

4. Add Service Account on SQL Server Management Studio>SQL Instance>Security>Logins

5. Minimum Server Roles required :DBCREATOR & SECURITY ADMIN

6. DBOWNER for all SharePoint databases

We can use multiple accounts for multiple roles but they need to be configured with care
Detailed Information is available at following link:

Plan for administrative and service accounts (Office SharePoint Server)http://technet.microsoft.com/en-us/library/cc263445.aspx

Installing Windows SharePoint Services 3.0 for the first time

1. Install Windows 2003 Server, member of a Domain

2. Install IIS 6.0 (If Upgraded from IIS5.0 Run WWW service in IIS 5.0 isolation mode check box must be unchecked)

3. Download Microsoft .NET Framework 3.0 Redistributable Package
http://www.microsoft.com/downloads/details.aspx?familyid=10CC340B-F857-4A14-83F5-25634C3BF043&displaylang=en

OR

Download Microsoft .NET Framework 3.0 Service Pack 1
http://www.microsoft.com/downloads/details.aspx?familyid=EC2CA85D-B255-4425-9E65-1E88A0BDB72A&displaylang=en

4. Install Microsoft .NET Framework version 3.0

5. Enable ASP.NET 2.0
In the IIS Manager tree, click the plus sign (+) next to the server name, and then click the Web Service Extensions folder.In the details pane, click ASP.NET v2.0.50727, and then click Allow.

6. Download Windows SharePoint Services 3.0http://technet.microsoft.com/hi-in/windowsserver/sharepoint/bb400747(en-us).aspx

OR
Download Windows SharePoint Services 3.0 with Service Pack 1 (SP1) [Must for Windows 2008 Server]http://www.microsoft.com/downloads/details.aspx?FamilyID=ef93e453-75f1-45df-8c6f-4565e8549c2a&displaylang=en

(Note - For Simplicity we are doing SINGLESERVER Installation which means we are using SQL Desktop engine & do not need SQL Server Full version)

7. Run Setup
1. On the Read the Microsoft Software License Terms page, review the terms, select the I accept the terms of this agreement check box, and then click Continue.
2. On the Choose the installation you want page, click Basic to install to the default location. To install to a different location, click Advanced, and then on the Data Location tab, specify the location you want to install to and finish the installation.
3. When Setup finishes, a dialog box prompts you to complete the configuration of your server. Be sure that the Run the SharePoint Products and Technologies Configuration Wizard now check box is selected.
4. Click Close to start the configuration wizard.

8.Run the SharePoint Products and Technologies Configuration Wizard
A. On the Welcome to SharePoint Products and Technologies page, click Next.
B. In the dialog box that notifies you that some services might need to be restarted or reset during configuration, click Yes.
C. On the Configuration Successful page, click Finish. Your new SharePoint site opens :-)

For Details & Advanced Installation Options Please Refer:
Installation Guide for Windows SharePoint Services 3.0http://go.microsoft.com/fwlink/?LinkID=107358

Monday, April 13, 2009

Configure SQL Reporting Services with WSS3.0 / MOSS 2007

Install SQL Server 2005 with Reporting Services
Install MOSS 2007
Install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies from
http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en



Report Server databases in SQL Server 2005

In IIS, We created a web site "RS" and an Application pool "RSAppPool"






On SQL Server:

Go to All Programs>Microsoft SQL Server 2005>Configuration Tools>Reporting Services Configuration



Select Machine name on which Reporting services are installed
Choose instance name & click on Connect



If Service Status is stopped click on Start button



Service status will change to running











Select website that we created "RS" & Click Ok

Report manager Virtual Directory Settings Click on New


Select website that we created "RS" & Click Ok










Enter password & click on button to browse a location for encryption file



Click Ok




Click Ok



Click on Apply

Click Ok









In Email Settings Enter Sender address & SMTP Server name


In Execution Account Check checkbox Specify an execution account
Enter Account and password


Click on Exit

On SharePoint Server:


1] Central Admin >Application Management>Reporting Services>Manage Integration Settings

Report Server Web Service URL = Enter :/reportserver">http://:/reportserver

Authentication Mode = Trusted Account


2] Central Admin >Application Management>Reporting Services>Grant Database Acces

Servername = Enter Report Server

In the pop up box enter credentials used for retrieving Reporting Services

Choose Default or Named Instance as applicable

Click Ok


3] Central Admin >Application Management>Reporting Services>Set Server Defaults
Above this step may error out

On Content Site>Site Actions>Edit Page>Add a webpart>Miscellaneous>
Select SQL Server Reporting Services Report Viewer & Click Add

Go to web part properties & configure Report Source

Monday, December 29, 2008

December Cumulative Update SharePoint



















December Cumulative Update for Windows SharePoint Services 3.0
http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=960010&kbln=en-us
December Cumulative Update for Microsoft Office Servers
http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=960011&kbln=en-us

Disclaimer: Follow Official Documentation before Installation.

Thursday, December 18, 2008

SharePoint Download Links at One Place

WSS2.0:

=======
Windows SharePoint Services 2.0 with Service Pack 2http://www.microsoft.com/downloads/details.aspx?FamilyId=B922B28D-806A-427B-A4C5-AB0F1AA0F7F9&displaylang=en

Windows SharePoint Services Service Pack 3 (SP3)http://www.microsoft.com/downloads/details.aspx?familyid=2BBFC89B-EB59-49FF-B58F-684693CB25A7&displaylang=en

Post SP3 hotfixes

http://support.microsoft.com/kb/941412

http://support.microsoft.com/kb/948919

http://support.microsoft.com/kb/950386

http://support.microsoft.com/kb/952903

http://support.microsoft.com/kb/958706

SPS2003:

========
Microsoft Office SharePoint Portal Server 2003 - Evaluation Edition http://www.microsoft.com/downloads/details.aspx?FamilyID=16006564-4575-4463-920d-c920b4aeae64&DisplayLang=en

SharePoint Portal Server 2003 Service Pack 3 (SP3)http://www.microsoft.com/downloads/details.aspx?familyid=AB086D48-1148-48DE-B4EC-A6298367E5F0&displaylang=en

Description of the SharePoint Portal Server 2003 post-Service Pack 3 hotfix package: February 26, 2008http://support.microsoft.com/kb/943167

SharePoint Products and Technologies Utility: Upgrade Pre-scan Tool

http://www.microsoft.com/downloads/details.aspx?familyid=e8a00b1f-6f45-42cd-8e56-e62c20feb2f1&displaylang=en

WSS3.0:

=======
Download Windows SharePoint Services 3.0http://technet.microsoft.com/hi-in/windowsserver/sharepoint/bb400747(en-us).aspx

Windows SharePoint Services 3.0 Service Pack 1 (SP1)http://www.microsoft.com/downloads/details.aspx?familyid=4191A531-A2E9-45E4-B71E-5B0B17108BD2&displaylang=en

Description of the Windows SharePoint Services 3.0 post-Service Pack 1 hotfix package: January 31, 2008
http://support.microsoft.com/kb/941422

Description of the Infrastructure Update for Windows SharePoint Services 3.0: July 15, 2008http://support.microsoft.com/kb/951695

Description of the Windows SharePoint Services 3.0 hotfix package (Sts.msp): August 26, 2008http://support.microsoft.com/kb/956057

MOSS 2007:

==========
Microsoft Office SharePoint Server 2007 Trial Versionhttp://www.microsoft.com/downloads/details.aspx?FamilyID=2e6e5a9c-ebf6-4f7f-8467-f4de6bd6b831&displaylang=en

The 2007 Microsoft Office Servers Service Pack 1 (SP1)http://www.microsoft.com/downloads/details.aspx?FamilyID=ad59175c-ad6a-4027-8c2f-db25322f791b&displaylang=en

Description of the SharePoint Server 2007 and SharePoint Server 2007 for Search post-2007 Office servers Service Pack 1 hotfix package: January 31, 2008

http://support.microsoft.com/kb/941274

Description of the Microsoft Office Servers Infrastructure Update: July 15, 2008http://support.microsoft.com/kb/951297

Description of the SharePoint Server 2007 hotfix package (Coreserver.msp): August 26, 2008http://support.microsoft.com/kb/956056

.Net Framework:

================
Microsoft .NET Framework Version 2.0 Redistributable Package (x86)http://www.microsoft.com/downloads/details.aspx?FamilyID=0856EACB-4362-4B0D-8EDD-AAB15C5E04F5&displaylang=en

Microsoft .NET Framework 2.0 Service Pack 1 (x86)http://www.microsoft.com/downloads/details.aspx?familyid=79BC3B77-E02C-4AD3-AACF-A7633F706BA5&displaylang=en

Microsoft .NET Framework 3.0 Redistributable Packagehttp://www.microsoft.com/downloads/details.aspx?familyid=10CC340B-F857-4A14-83F5-25634C3BF043&displaylang=en

Microsoft .NET Framework 3.0 Service Pack 1http://www.microsoft.com/downloads/details.aspx?familyid=EC2CA85D-B255-4425-9E65-1E88A0BDB72A&displaylang=en

SQL Server:

===========
Microsoft SQL Server 2000 Service Pack 4http://www.microsoft.com/DOWNLOADS/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en

Microsoft SQL Server 2005 Service Pack 2http://www.microsoft.com/downloads/details.aspx?familyid=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en

Microsoft SQL Server 2005 Express Editionhttp://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en

Microsoft SQL Server Management Studio Expresshttp://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

WINDOWS:

========
Windows Server 2003 Service Pack 2 (32-bit x86)http://www.microsoft.com/downloads/details.aspx?FamilyId=95AC1610-C232-4644-B828-C55EEC605D55&displaylang=en

Windows Server 2003 Service Pack 2 for x64 Editionshttp://www.microsoft.com/downloads/details.aspx?familyid=08FEC2F5-6E3B-4E0D-9314-646414D0A421&displaylang=en

OTHER:

======
SharePoint Designer 2007 Trial Versionhttp://www.microsoft.com/downloads/details.aspx?FamilyID=baa3ad86-bfc1-4bd4-9812-d9e710d44f42&DisplayLang=en

SharePoint Templateshttp://www.microsoft.com/sharepoint/templates.mspx

Diagnostic Tools:

=================

SharePoint Portal Server Support Report Tool (SPSReport)http://www.codeplex.com/spsreport

FileMon for Windows v7.04http://technet.microsoft.com/en-us/sysinternals/bb896642.aspx

RegMon for Windows v7.04http://technet.microsoft.com/hi-in/sysinternals/bb896652(en-us).aspx

Process Monitor v2.03http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx

Microsoft Network Monitor 3.2http://www.microsoft.com/DownLoads/details.aspx?FamilyID=f4db40af-1e08-4a21-a26b-ec2f4dc4190d&displaylang=en

Disclaimer: Follow Official Documentation before Installation.

Thursday, November 27, 2008

Install MOSS 2007 on Windows Server 2008?

Install Windows Server 2008
From Server Manager>Roles Select "Web Server (IIS)" role
From Server Manager>Features Select ".Net Framework 3.0 Features"

To Create Slip Stream Installation package of MOSS
-Copy MOSS RTM Installation on HDD
-Download SP1 for WSS3.0 & SP1 for MOSS
-Additinally you can also download Post SP1/Infrastructure/August Cumulative updates as well
-Extract them in /Updates folder in MOSS RTM Setup Package on HDD
-If Updates are downloaded in "C:\UPDATES" folder & you want to extract them in "C:\EXTRACTED" folder use following command from command prompt
-C:\UPDATES>Filename.EXE /Extract:C:\EXTRACTED
Where Filename.EXE is Actual name of Service Pack or Hot Fix .EXE file
-Once extracted copy contents of C:\EXTRACTED folder to \Updates folder in MOSS RTM Setup package on HDD

Now run Setup.exe for MOSS 2007 Slip Stream package