16 January, 2010

Publishing and Synchronizing Excel 2007 Tables to SharePoint Lists

1. Install the excel 2007 add-in on your machine.

http://www.microsoft.com/downloads/details.aspx?FamilyId=25836E52-1892-4E17-AC08-5DF13CFC5295&displaylang=en

2. When you will start the setup then it will ask you where to install the data excetely, so please save at this location on your machine:
C:\Program Files\Microsoft Office\Office12\ADDINS

3. Open the excel sheet in which you have the data that you wants to synchronise in sharepoint.

4.Click the Microsoft Office Button, click Excel Options, and then click the Add-Ins tab.

5. Select Excel Add-ins in the Manage drop-down list and click Go.

6. In the Add-Ins dialog box, click Browse, navigate to the Excel 2007 SharePoint List Synchronizing Add-in, and then click OK.

7. In the Add-Ins dialog box, verify that the SynchronizeWSSandExcel option is selected and then click OK.


To add the add-in to a workbook

1. Save the workbook in the Excel 97-2003 (BIFF8) file format by clicking the Microsoft Office Button, pointing to Save As, and then clicking Excel 97-2003 Workbook.

2. Specify a file name, and then click Save.

To publish the table to a SharePoint list1. Highlight the table. The Table Tools label is displayed above the Design tab.

2. Click the Design tab.

3. In the SharePoint group, click Publish and allow Sync.

4. When you will click on click Publish and allow Sync. then all the data will be disappeared from the excel sheet and transferred to SharePoint List.

5.In the Export Table to SharePoint R/W List dialog box, in the Address text box, type in the page address onthe SharePoint site where you want to publish the list.



6. In the address, Please enter your site link without default.aspx

7. Type the name of the list that you want.

8.When you will click on Publish then the internal process will create a list by the name that you specified and all the data will be transferred to sharepoint site.

Note: When you will click on Publish then you will get some error message.. Dont worry abt that as the data has been transferred to sp-site.
If you have any questions or queries regarding the above procedure then please let me know..

30 December, 2009

Method 'Post' of object 'IOWSPostData' failed

The error message --Method 'Post' of object 'IOWSPostData' failed --appears when I import a spreadsheet in the Create -Import Spreadheet menu of MOSS 2007.
Importing lists from Excel 2007 returns a Method 'Post' of object 'IOWSPostData' failed dialog. The problem is not with the sharepoint but result of a failed Application.SharePointVersion() call in the Excel Add-In which results in Excel attempting to use the IOWSPostData.Post() method to publish the Excel range which is used with SharePoint Services.

By forcing the version lookup result variable to 2 or greater, Excel will use SOAP to communicate with SharePoint and the publish request will be successful.

To make this change, Please follow these steps:

1. open the Excel Add-In EXPTOOWS.XLA locate in

C:\Program Files\Microsoft Office\Office12\1033.

2. Press Alt+F11 to display the Visual Basic code editor and search (Ctrl+F) for the line lVer = Application.SharePointVersion(URL).

3. Comment out that line with a single quote and add the line lVer=2 so your Intialize() method should now look like this:

Sub Initialize(List, Title, URL, QuickLaunch)
strQuickLaunch = QuickLaunch
aTarget(iPublishURL) = URL
aTarget(iPublishListName) = List
aTarget(iPublishListDesc) = Title
'lVer = Application.SharePointVersion(URL)
lVer = 2
End Sub

If you have any doubts or queries regarding the above procedure then please let me know...
I hope the above information will helps you to resolve your issue..Thanks !!


Reff:http://social.technet.microsoft.com/forums/en-US/sharepointgeneral/thread/75b2be6b-44df-4389-bf34-c7a01c12372c/

23 December, 2009

Authenticated Users get Access Denied when Browsing to Site- 403 Forbidden

When NT Authority\Authenticated users were added to a windows sharepoint services 3.0 site, users other than the users directly permissioned to site, or Site Collection Admins would receive a 403 Forbidden error when they woudl try to browse to the Default.aspx page.

ULS Logs would show:
============================================================
Access Denied for /default.aspx.
StackTrace: Microsoft.SharePoint.Utilities.SPUtility:Void
HandleAccessDenied(System.Exception), Microsoft.SharePoint.SPGlobal:Void
HandleUnauthorizedAccessException(System.UnauthorizedAccessException),
Microsoft.SharePoint.SPWeb:System.String GetWebPartPageContent(System.Uri,
Microsoft.SharePoint.WebPartPages.PageView, System.Web.HttpContext, Boolean,
Boolean, Boolean, Boolean, Boolean ByRef, Byte ByRef, System.String ByRef,
System.Guid ByRef, Int64 ByRef, System.Guid ByRef, UInt32 ByRef, System.String
ByRef, Byte ByRef, System.Object ByRef, UInt32 ByRef, System.Object ByRef,
Microsoft.SharePoint.SPWebPartCollectionInitialState ByRef, System.Object ByRef,
System.String ByRef, Boolean ByRef, System.Guid ByRef),
Microsoft.SharePoint.ApplicationRuntime.SPRequestModuleData:System.String
FetchWebPartPageInformationForInit(System.Web.HttpContext,
Microsoft.SharePoint.SPWeb, Boolean, System.String, Boolean, Boolean ByRef, Byte
ByRef, System.Guid ByRef, UInt32 ByRef, System.String ByRef,
Microsoft.SharePoint.SPFileLevel ByRef, System.String ByRef, System.String ByRef,
System.String ByRef, System.String ByRef, System.Guid ByRef, System.Object ByRef,
Microsoft.SharePoint.SPWebPartCollectionInitialState ByRef, System.String ByRef,
System.String ByRef, System.Object ByRef, Boolean ByRef, System.Guid ByRef, Int64
ByRef), Microsoft.SharePoint.ApplicationRuntime.SPRequestModuleData:Void
GetFileForRequest(System.Web.HttpContext, Microsoft.SharePoint.SPWeb, Boolean,
System.String), Microsoft.SharePoint.ApplicationRuntime.SPRequestModule:Void
InitContextWeb(System.Web.HttpContext, Microsoft.SharePoint.SPWeb),
Microsoft.SharePoint.WebControls.SPControl:Microsoft.SharePoint.SPWeb
SPWebEnsureSPControl(System.Web.HttpContext),
Microsoft.SharePoint.WebControls.SPControl:Microsoft.SharePoint.SPWeb
GetContextWeb(System.Web.HttpContext),
Microsoft.SharePoint.ApplicationRuntime.SPRequestModule:Void
PostResolveRequestCacheHandler(System.Object, System.EventArgs),
System.Web.HttpApplication+SyncEventExecutionStep:Void
System.Web.HttpApplication.IExecutionStep.Execute(),
System.Web.HttpApplication:System.Exception ExecuteStep(IExecutionStep, Boolean
ByRef), System.Web.HttpApplication+ApplicationStepManager:Void
ResumeSteps(System.Exception), System.Web.HttpApplication:System.IAsyncResult
System.Web.IHttpAsyncHandler.BeginProcessRequest(System.Web.HttpContext,
System.AsyncCallback, System.Object), System.Web.HttpRuntime:Void
ProcessRequestInternal(System.Web.HttpWorkerRequest), System.Web.HttpRuntime:Void
ProcessRequestNoDemand(System.Web.HttpWorkerRequest),
System.Web.Hosting.ISAPIRuntime:Int32 ProcessRequest(IntPtr, Int32),
==================================================================

after detailed analysis and debug of the w3wp process, we found two columns with non standard settings in the content database. In the AllList table the columns called tp_readsecurity and tp_writesecurity, for the “User Information List” have the values set to 2 & 4 respectively. The default value for both columns is 1.

Tp_readsecurity

Value="1">read all items
Value="2">read only my items
Value="4">read none


Tp_writesecurity

Value="1”>write all items
Value="2">write only my items
Value="4">write none

The value 2 for tp_readsecurity will only allow a user to read their own items. So reading the items does not occur because it is trying to read the items in the “user Information list” that are not their own. The value 4 for tp_writesecurity does not allow write to this list so you will not be able to add users. Since they have not or cannot be added into the list, there was an exception being thrown and this is the reason for the 403 Forbidden.

RESOLUTION/WORKAROUND:
===========================
1. Open the site you are having trouble with, but make sure you open the site
with site collection admin/owner rights.
2. Browse to the URL:
http://portal/sites/site/_layouts/advsetng.aspx?list={GUID}
3. This List ID will vary.
4. You can also get to this list by Browsing to the root of your site, Site
Actions> Site Settings> Advanced Permissions> Click on the All People link
in qiuck launch> Then select List Settings, then Advanced Settings
5. This method will also get you to the above URL and probably easier than
having to poke thru the DB to find the GUID of that list.
6. Change the Read Access Value to “All Items”
7. Change the Edit Access to “All Items”
7. This will modify those values in the database back to 1 and 1
8. Authenticated Users should now be able to access the site.

I hope the above information will helps you to resolve this issue !! Thanks !!!

22 December, 2009

Access Denied when attempting to create a new page

When attempting to create a page by clicking Site Actions Create Page, the user immediatly receives an Access Denied. This occurs even if the user is a member of the Site Owners group with Full Control.

ERROR MESSAGE: Access Denied

CAUSE:
===========
The access denied was a result of the user not being a part of the Style Resource Readers group. According to technet, this group allows a user to read the Master Page Gallery and Restricted Read the Style Library. By default, this group contains only the NT AUTHORITY\Authenticated Users group. This will allow all users who have authenticated to the site to read the Master Page gallery and Style Library.

RESOLUTION:
====================
1) Open the site you are having issues with
2) Click Site Actions Site Settings
3) In the Users and Permissions section, click People and Groups
4) Click Groups
5) Click Style Resource Readers
6) Click New Add User
7) In the Add Users section, click the Add all authenticated users link
8) Click OK

I hope the above information will helps you to resolve this issue !! Thanks !!

04 December, 2009

no Next in list of users and groups

Groups.aspx will not display more than 100 groups !!

We have a site collection with many users and groups. It consist of approximately 745 groups created with different depts. When I go to see a list of users and groups, I only see the first page i.e. 100 groups only !! this is actually very strange as i compared with other site collections that are running in our farm, those sites are not facing this wierd issue... The next arrows are gone, we can't advance through the list.

After digging a lot, we were able to resolve this issue and i would like share this resolution with all of u !!!!
--The page on which we can see all the created groups is called as "User Information List"
--or we can add that one as a User Information List web part.
--Every List has the option of "Modify this View" but for this list i.e. "User Information List", this view is hidden (by default).. Microsoft hide this view from the consideration, just to avoid messing !! i can guess :-)
--When we will go inside that view then we have enable these following options:-

1. User Information List.
2. Click Edit > Modify this view
3. Count section
4. Make sure the Item Limit is set to 100 and Display items in batches of the specified size is checked.


Now the question arises as How to go inside that list ?? Dont Worry, Please follow these steps:

-> That page is called as ViewEdit.aspx

->You need to pass the Guid for both the list and view to this page, like this:
->http://MOSS2007.com/_layouts/ViewEdit.aspx?List={00000000-0000-0000-0000-000000000000}&View={00000000-0000-0000-0000-000000000000}

-> You can get the Guid for the User Information List using the GetListCollection web method on /_vti_bin/Lists.asmx.

-> You can get the Guid for the View by passing the Guid for the list to the GetViewCollection web method on /_vti_bin/Views.asmx

I hope the above information will helps u to resolve this issue..Thanks !!