Converting the spreadsheet into a list

Here are the steps we took to convert an Excel spreadsheet to a SharePoint list.

1. Browse to the Create page in your site by click on the All Site Content on the quick launch. 
2. Click the Import Spreadsheet link in the Custom Lists section. The New List page opens.
3. Type the name for the list in the Name field, and then type a description for the list in the Description field.
4. Click the Browse button. Locate the Excel spreadsheet that contains the data you want in your list, then click on the file name, and then click the Open button.
5. Click the Import button on the New List page. The Import to SharePoint list dialog box opens.
6. Click the Range of Cells option in the Range Type drop down list.
   
   
    
7. Click the button on the Select Range drop down list. Your Excel spreadsheet opens with the Import to Windows SharePoint Services window.
   
   
    
8. Click and drag to highlight the areas of your spreadsheet you want to be included in your list. Be sure to include the column headings; they will become the field names and column titles in the list.
9. Click the button on the Import to Windows SharePoint Services window. The Import to Windows SharePoint Services list dialog box opens.
10. Click the Import button.  Your list is created.
    
    

Since Sharepoint is no longer included in Windows Server 2008, you have to install it yourself. The issue is this.  If you try to install WSS 3.0 on Windows 2008, it will not install.  It will tell you that you have to install SP1 and you will probably wonder how you can do that without first installing WSS 3.0.  The answer is that you need to install the Windows Sharepoint Services 3.0 with SP1 installer that bundles Sharepoint 3.0 and SP1 together. download Windows SharePoint Services 3.0 with SP1.

 

 

 

 

 

Explore several new features for authentication and authorization in Microsoft Office SharePoint Server (MOSS) 2007 and Windows SharePoint Services 3.0 that make it easier to develop and deploy solutions in Internet-facing and extranet environments. Here is the useful content from MSDN:

 

http://msdn.microsoft.com/en-us/library/bb975136.aspx
Introduction to Forms Authentication in SharePoint Products and Technologies
Deciding to Use Forms Authentication
Reviewing a Typical Scenario for Authentication
Reviewing Changes to Authentication Terminology
Setting Up Forms Authentication
Granting Permissions to Create My Sites

 

http://msdn.microsoft.com/en-us/library/bb975135.aspx
Developing Custom Membership and Role Providers
Applying the XML File for the Data Source
Inheriting from the Membership and Role Base Classes
Minimum Interfaces Required by MOSS and Windows SharePoint Services
Registering the Custom Provider
Debugging the Custom Provider
Writing a Custom Forms Logon Page
Using Web Services with a Site Protected by Forms Authentication

 

http://msdn.microsoft.com/en-us/library/bb977430.aspx
Introduction to Differences Between Forms Authentication and Windows Authentication
Crawling Content
Integrating with the 2007 Microsoft Office System
Opening Documents in Internet Explorer
Checking the "Sign me in automatically" Check Box at Logon
Using an HttpModule During Authentication
User Profile Imports
Resolving Names
Using an LDAP Provider
Using the Microsoft Single Sign-On Service
Conclusion

 

Do we really have to know XML coding to create an application defination for SharePoint Business Data Catalog? Here is the GUI tool can do it without coding XML. 

BDC Meta Man is the first Business Data Catalog tool for all SharePoint Developers and Administrators interested in line of business data integration with SharePoint. Without writing a single line of code you can be viewing and searching across your business data through Microsoft Office SharePoint Server 2007 in minutes.

To download a trial copy click here http://www.lightningtools.com/bdc-meta-man/default.aspx

 

So, what is the applicaiton defination? An application definition describes a database or web service. It includes connection settings, authentication mode, definitions of available entities, and other information. After you upload an application definition to the Business Data Catalog, you can use its entities in lists, web parts, search, user profiles and custom applications.