Friday, July 31, 2009
Excel 2007 videos
New Feature in Excel 2007
http://www.youtube.com/watch?v=wQyGS3icS9M
Whats new in Excel 2007
http://www.youtube.com/watch?v=OPaY5g-jiQQ&feature=related
Tracing Formulas in Excel 2007
http://www.youtube.com/watch?v=BllbwfsK7Yw
Excel 2007 Pie Chart
http://www.youtube.com/watch?v=pzSBKrV8C4c
Column-Line 2-Axis Chart in Excel 2007
http://www.youtube.com/watch?v=qrp65AyCzuU
Building a Pivot Table in Excel 2007
http://www.youtube.com/watch?v=7zHLnUCtfUk
Excel 2007 - Removing blank rows
http://www.youtube.com/watch?v=ER0pZQsqyOM
NEW TABLE FEATURE: Dynamic Range
http://www.blogger.com/post-create.g?blogID=6833741015620783493
Excel 2007 Table and Chart feature
http://www.youtube.com/watch?v=206iDkaMAQA
Names & Excel 2007 Tables
http://www.youtube.com/watch?v=ANFC3laJ03Q
Wednesday, July 29, 2009
Updates in Asp.Net Ajax
1) AJAX Control Toolkit -- May 2009 Release
a. http://www.asp.net/ajax/AjaxControlToolkit/Samples/
b. http://www.codeplex.com/Wiki/View.aspx?ProjectName=AjaxControlToolkit
c. http://www.asp.net/learn/Ajax-Control-Toolkit/tutorial-47-cs.aspx
2) Microsoft AJAX Library 3.5
http://msdn.microsoft.com/en-us/asp.net/dd162267.aspx
3) ASP.NET AJAX Preview 4.0
http://www.codeplex.com/aspnet/Wiki/View.aspx?title=AJAX&referringTitle=Home
4) AJAX Videos
http://www.asp.net/learn/ajax-videos/#AJAX
5) AJAX Control Toolkit Videos
http://www.asp.net/learn/ajax-videos/#AjaxControlToolkit
6) AJAX Tutorials
http://www.asp.net/learn/ajax/#ajax
7) AJAX Control Toolkit Tutorials
http://www.asp.net/learn/ajax/#ajaxcontroltoolkit
8) ASP.NET 3.5 Documentation
http://msdn.microsoft.com/en-us/library/bb398874.aspx
9) ASP.NET AJAX 1.0 Documentation and Migration Guides
http://www.asp.net/ajax/documentation/
10) ASP.NET AJAX Forums
Monday, July 27, 2009
InfoPath video links
Convert a Word document into an InfoPath 2007 form template
We can import the Word document and excel document into infopath form. The following link has the video for importing Word document Expense report to Infopath form expense repots.
http://office.microsoft.com/home/video.aspx?assetid=ES102063321033&width=884&height=540&startindex=0&CTT=11&Origin=HA102063221033
and also refer introduction of form template and forms
http://office.microsoft.com/en-us/infopath/HA100626851033.aspx
View the business logic in a form template
Watch the demo to see how the Logic Inspector makes it easy to see what fields and groups have business logic associated with them and how this logic is related to other fields and groups in the form template.
http://office.microsoft.com/home/video.aspx?assetid=ES102063511033&width=884&height=540&startindex=0&CTT=11&Origin=HA102063491033
And also refer the same without video
http://office.microsoft.com/en-us/infopath/HA101663011033.aspx
Use InfoPath e-mail forms to view data in Outlook 2007
http://office.microsoft.com/home/video.aspx?assetid=ES102068991033&width=884&height=540&startindex=0&CTT=11&Origin=HA102068981033
Create reusable template parts in InfoPath 2007
http://office.microsoft.com/home/video.aspx?assetid=ES102379651033&width=884&height=540&startindex=0&CTT=11&Origin=HA102374171033
Publish a form template as an e-mail message
http://office.microsoft.com/home/video.aspx?assetid=ES102390201033&width=884&height=540&startindex=0&CTT=11&Origin=HA102383151033
Help users prevent mistakes by using data validation
http://office.microsoft.com/home/video.aspx?assetid=ES102631131033&width=884&height=540&startindex=0&CTT=11&Origin=HA102549111033
Populate a drop-down list box from a SharePoint list
http://office.microsoft.com/home/video.aspx?assetid=ES102811451033&width=884&height=540&startindex=0&CTT=11&Origin=HA102549121033
Find what you need faster with the redesigned Office Online
http://office.microsoft.com/home/video.aspx?assetid=ES102114031033&width=884&height=540&startindex=0&CTT=11&Origin=HA102114011033
Windows Vista and the 2007 Office system — better together
http://office.microsoft.com/home/video.aspx?assetid=ES102154241033&width=800&height=600&startindex=0&CTT=11&Origin=HA102120011033
Store InfoPath forms in a document library on a SharePoint site
http://office.microsoft.com/home/video.aspx?assetid=ES102811461033&width=884&height=540&startindex=0&CTT=11&Origin=HA102636741033
Backup the windows registry
http://support.microsoft.com/kb/322756/
Windows registry information for advanced users
This article describes the registry. This article also includes information about how to back up the registry, how to edit the registry, and lists references for more information. (For Advance User)
http://support.microsoft.com/kb/256986/
Deploy an InfoPath browser form template to SharePoint
This video shows how to create a Info path template and add it in the Form library and using this template creating the new form in Form library
Create InfoPath documents in SharePoint with SPD
This video shows how to create a info path form template and add it to the Form library, then how to enable settings on the form library and add xml file as a template to the form library, then show steps to create the workflow using Sharepoint Designer and creating a new form using sharepoint List by entering the item.
Friday, July 24, 2009
Anonymous user in sharepoint
1) http://www.learnitfirst.com/Course/225/Video/845/Access-the-SharePoint-Site-as-an-Anonymous-User.aspx
2) http://www.iotap.com/Blogs/tabid/277/EntryId/86/Blocking-Anonymous-Users-from-Sharepoint-List-Pages.aspx
3)https://blogs.msdn.com/pavankumar/archive/2009/02/18/hide-the-sign-in-link-for-the-anonymous-user-sharepoint-moss.aspx
4) http://nirma.org/_layouts/help.aspx?lcid=1033&cid0=MS.WSS.manifest&tid=MS.WSS.HA10113018
User Profiles in Sharepoint
User profile is one of the most important concepts of Sharepoint. It is nothing but adding users to the Sharepoint site and assigns them different kinds of rights to access the resources.
We can add user to the SharePoint from Active directory, LDAP and also from local system user account. There is different types of default users group as below
1) Approvers :
Members of this group can edit and approve pages, list items, and documents.
2) Designers :
Members of this group can edit lists, document libraries, and pages in the site. Designers can create Master Pages and Page Layouts in the Master Page Gallery and can change the behavior and appearance of each site in the site collection by using master pages and CSS files.
3) Hierarchy Managers :
Members of this group can create sites, lists, list items, and documents.
4) NT AUTHORITY\authenticated users :
Use this group to give people contribute permissions to the SharePoint site:
5)
Use this group to give people full control permissions to the SharePoint site:
6)
7)
Use this group to give people read permissions to the SharePoint site:
8) Quick Deploy Users :
Members of this group can schedule Quick Deploy jobs.
9) Records Center Web Service Submitters for Record :
Members of this group can submit records to this Records Center using Web Services.
10) Restricted Readers :
Members of this group can view pages and documents, but cannot view historical versions or review user rights information.
11) Style Resource Readers :
Members of this group are given read permission to the master page gallery and the Restricted read permission to the Style Library. By default, all authenticated users are a member of this group. To further secure this site, you can remove all authenticated users from this group or add users to this group.
12) Viewers :
Members of this group can view pages, list items, and documents. If the document has a server rendering available, they can only view the document using the server rendering.
Individually adding user Permissions
1) Full Control - Has full control.
2) Design - Can view, add, update, delete, approve, and customize.
3) Manage Hierarchy - Can create sites and edit pages, list items, and documents
4) Approve - Can edit and approve pages, list items, and documents
5) Contribute - Can view, add, update, and delete
6) Read - Can view only
7) Restricted Read - Can view pages and documents, but cannot view historical versions or review user rights information
8) View Only - Members of this group can view pages, list items, and documents. If the document has a server-side file handler available, they can only view the document using the server-side file handler
9) Records Center Submission Completion - This role is required to fill in missing properties on records submitted to the Records Center. It is automatically granted to users for each record submitted that is missing properties.
Tuesday, July 21, 2009
Internet Explorer crashes when i try to open an Office document in a SharePoint document library
http://support.microsoft.com/kb/938888/
The reason is I have multiple versions of office product (I think so).
Friday, July 17, 2009
Overview of Sharepoint 2010
1) Overview of Sharepoint 2010
http://sharepoint.microsoft.com/2010/Sneak_Peek/Pages/Overview-Video.aspx
2) Sharepoint 2010 for ITProfessional
http://sharepoint.microsoft.com/2010/Sneak_Peek/Pages/IT-Pro-Video.aspx
3) Sharepoint 2010 for Developer
http://sharepoint.microsoft.com/2010/Sneak_Peek/Pages/Developer-Video.aspx
Building Web Applications with ASP.NET 3.5 and Microsoft Visual Web Developer 2008
Intro to Visual Web Developer
IntelliSense
Intro to Web Forms
Page Lifecycle Events
MasterPages
An Introduction to SOAP Based Web Services with Visual Web Developer 2008
The SharePoint video links - Second CollectionI
1) Adding Documents to a SharePoint Site
2) Create a new SharePoint Site Collection Administrator
3) Add Links to a SharePoint List
4) Add SharePoint Site to your Trusted Sites in Internet Explorer
5) Add Users to a SharePoint Security Group
6) Approve another user's SharePoint Blog Post
7) Change SharePoint Navigation to a Site Tree View
8) Change the SharePoint Site Image
9) Change the SharePoint Site Title and Description
10) Change a SharePoint User's e-mail address
11) Change a SharePoint User's password
12) Create a SharePoint Calendar Appointment
13) Create a Document-specific SharePoint Alert
14) Create a New SharePoint User
15) Create a SharePoint Announcements List
16) Create a SharePoint Blog Posting
17) Create a SharePoint Calendar
18) Create a SharePoint Contacts List
19) Create a SharePoint Discussion Board
20) Create a SharePoint Document Library
21) Create a SharePoint Document Work Space
22) Create a SharePoint Gantt Project Management Chart
23) Create a SharePoint InfoPath form Library
24) Create a SharePoint Links List
25) Create a SharePoint Meeting Site
26) Create a SharePoint Picture Library
27) Create a new SharePoint Security Group
28) Create a new SharePoint Sub-site
29) Create a new Task in a SharePoint Tasks list and assign it to a user
30) Create a SharePoint Wiki Document
31) Create a SharePoint Wiki Library
32) Customize a SharePoint Meeting Site
33) Delete a SharePoint Meeting Site when you are finished with it
34) Edit SharePoint Blog Categories
35) E-mail a SharePoint Document Library
36) E-mail Enable a SharePoint Discussion Forum
37) Enable Multiple SharePoint Blog Categorizations
38) Edit the SharePoint Quick Launch Menu to Customize with your own navigation options
39) Enable SharePoint Document Versioning
40) Change SharePoint Top Link bar navigation options
41) Manage Access Requests to your Site
42) Move Documents between SharePoint Document Libraries
43) Remove Permission Inheritance from SharePoint Sub-sites
44) Remove the SharePoint Quick Launch Menu
45) Remove Top Link Bar Inheritance from a SharePoint Site
46) Restore Deleted Items As the Site Collection Administrator
47) Restore SharePoint Site Permission Inheritance (sub-sites)
48) Work with the SharePoint Recycle Bin
49) Create a SharePoint Sales CRM Application
50) Work with your SharePoint Themes
51) Add Tabbed SharePoint Navigation Options to your Site
52) Add SharePoint Web Parts
53) Sign in as a different SharePoint User
54) Work with a SharePoint Gantt Project Chart
55) Create a Custom Site Column
The SharePoint video links - First Collection
1) Exploring SharePoint's Central Administration
2) Site Delete Capture - Recycle Bin for deleted sites
3) Alerts
4) Target Web Part to an Audience
5) Backing up Sites with STSADM utility
6) Creating and using Blog Sites in SharePoint
7) Understanding and using Content Types
8) Introducing Document Management
9) Understanding and using the new Features concept
10) Convert Word Forms to InfoPath
11) Using a Picture Library and Image Web Part together
12) Creating Lists in Sites
13) Adding Columns and Data to a Custom List
14) Create Custom Lists
15) Understanding Master Pages
16) Introducing Meeting Workspaces
17) Get to know My Sites
18) Customizing Current Navigation in WSS
19) What's new in Microsoft Office SharePoint Server 2007
20) What is SharePoint?
21) Using the Disposition Approval Workflow
22) Using the Recycle Bin
23) Subscribing to List or Library RSS feeds
24) Introducing Search Center
25) Adding Users to a Site
26) Security Overview
27) Delete a SharePoint Site using SharePoint Designer
28) Understanding and using Site Columns
29) Creating a SharePoint Site
30) Adding Web Parts to a Site
31) Publish Web Parts to the Web Part Gallery
32) Exploring built-in MOSS Workflows
Workflow Vedios in sharepoint
2) Extracting Document Details with SharePoint Workflow's
3)Extracting email addresses & Sending emails with SharePoint Workflow
4)Programmatically creating user tasks with SharePoint Workflow
5) Programmatically escalating Overdue Tasks
6)Building Basic Approval Workflow
Click the link
7) Building a Multilevel Approval Workflow
Click me to view in meadia player
8) Using Active Directory Searching/Lookup in a SharePoint/MOSS 2007 Workflow
Click me to view in media player
Shopping cart Application using Sharepoint
http://www.microsoft.com/downloads/details.aspx?FamilyId=2AEB1A5E-43B8-483B-8CB2-86C0E82BF0AB&displaylang=en
Wednesday, July 15, 2009
Integrating User Controls with WebParts
Global Application settings and the web.config file
Microsoft.com is probably always going to have the same name, but .NETOOP is going to be a portal application. Everyone who uses the application will need to .NETOOP to use their own web site name (and lots of other site specific configuration data.)
Now ASP.NET has that clever “Application Settings” feature. For full article click here
Tuesday, July 14, 2009
Monday, July 13, 2009
Joins between sharepoint list
Learn how to extend a custom Relationship field in Microsoft Office SharePoint Server 2007 to enable users to select a relationship type and store information in a secondary table. Click here to read more
==***==
In many scenarios, we SharePoint developers want to take two different lists and join them and present a single set of data. For instance, one list contains customer information and the other list contains products with serial numbers and customer-related specific details like connection information and versions. There is a lookup field in the product list that selects the customer the product belongs to. So far so good :) Click here to read more
how to programatically manage look & feel of web part
Question
I would like to know is there any tool or how to programatically manage look & feel of web part? I'm adding asp.net controls to CreateChildControls method but how to manage theit look and desing? How to set up their positions and so forth? Is there any grid or someting what can I use to do that?
suggestion
Personally, I prefer to load a .ascx user control in my web part and manage the look/markup in the .ascx, it is much easier for me. Basically this is using the web part class as a wrapper for the .ascx control, all of the logic/etc could be in the user control. Just make a normal user control (.ascx with code behind) then use code similar to below:
public class ContactInfo : System.Web.UI.WebControls.WebParts.WebPart
{
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
}
protected override void CreateChildControls()
{
base.CreateChildControls();
WebControls.ContactInfo ctrl = (WebControls.ContactInfo)this.Page.LoadControl("~/_controltemplates/Custom/ContactInfo.ascx");
this.Controls.Add(ctrl);
this.ChildControlsCreated = true;
}
}
Source form MSDN :http://social.msdn.microsoft.com/Forums
Error message when you subscribe to RSS feeds in Windows SharePoint Services 3.0 and in SharePoint Server 2007: “Page cannot be displayed”
1) You may not receive an error message that states that the RSS feeder has not installed as expected.
2) You may receive the following error message: "Page cannot be displayed"
for more click here
.NET/Java Interoperability
http://www.aspnetpro.com/newsletterarticle/2009/01/asp200901wc_l/asp200901wc_l.asp
Friday, July 3, 2009
Microsoft Chart with ASP.NET 3.5
Actually this the part-1 of part-2.This Part 1 of the two part article shows how you may use the new MS Chart control in an ASP.NET web application. In this 1st part, the following details are discussed:
1) Downloading and installing the control
2) Selecting a source of data
3) Creating an ASP.NET Web Site application and adding a Chart Control
3) Configuring the data source using the wizard
4) Identifying elements on the chart’s template
For more http://dotnetslackers.com/articles/aspnet/Microsoft-Chart-with-ASP-NET-35-Part1.aspx
Records Management in SharePoint
Here are some of useful links for Record managment
1) Plan Records Management http://technet.microsoft.com/en-us/library/cc262114.aspx
2) Records Management Roadmap http://technet.microsoft.com/en-us/library/cc263372.aspx
3) Operations Records Management http://technet.microsoft.com/en-us/library/cc262838.aspx
4) Managing Document and Records http://technet.microsoft.com/en-us/library/cc262898.aspx
5) Records Management Default Settings http://technet.microsoft.com/en-us/library/cc824902.aspx
6) Information Management Policy Default Settings http://technet.microsoft.com/en-us/library/cc824908.aspx
7) Sample template: SharePoint Products and Technologies governance plan
8) White paper: Managing enterprise metadata with content types
9) Chaos no more: Steps for building governance into Microsoft Office SharePoint Server 2007 (white paper)
10) Downloadable Book: Records Management Guide for Microsoft Office SharePoint Server 2007 – Click here
11) Demo Video: Add a Library to a Record Center - Click here
Creating new user account in sharepoint
1) In Site Administration page, under Users and roles, click Manage users.
2) Click Add a user.
3) In the User area, click Add a new user, then type the username and password for the new user account.
4) In the User Role area, select a user role for the new account.
5) Click Add User.