Duplicate items appear when viewing items in Datasheet view in SharePoint

ISSUE:

Duplicate items appear when viewing items in Datasheet view in SharePoint.  This also happens when using the Export to Spreadsheet (Excel).  If duplicates appear in Datasheet view, they will also appear during Export to Spreadsheet and vice versa.

DESCRIPTION:

The list has got versioning switched off, and views fine in standard list view. However, when you switch to either datasheet view or Excel Export it shows the same rows up to three times in sequential rows.

WORAROUND/SOLUTION:

The affected lists have a REQUIRED lookup field which allows multiple values.

If you have a view that does NOT include this field and it is either a datasheet or you "Switch to Datasheet" then datasheet shows duplicate items depending on how many multi-values are selected. 

Our work-around was to create a specific Datasheet view with the field included.  The multi-value field does not show in datasheet, because multi-value lookup fields don't seem to work in datasheet.  However, it's important to include the field in the view to avoid duplicates.

Unfortunately, if you have a view that does not include the field and then "Switch to Datasheet" you will encounter the same problem.

The duplicates appear also when you try to Export to Excel.  If you have a view that would be affected by the "Switch to Datasheet" duplicates problem, when you try to Export to Excel, it will also appear.

Unable to “Edit series” for a repeating event in sharepoint calendar list

Issue:

Unable to “Edit series” for a repeating event in sharepoint calendar list

Problem Description:

There is a repeating event (event series) in sharepoint calendar list with “All day event” selected and no specific start and end time.

When someone opens an event and then clicks on "Edit series", it opens up the series in edit mode. But after making any type of changes, page can’t be saved and clicking “Ok” returns to same edit page reflecting some validation errors which doesn't allow us to commit the changes.

Workaround\Resolution:

Solution for this problem issue is extremely simple very unobvious.

Whether we make changes to the series or not, we must uncheck the box for “All day event” and then select the check box again.

How to add IM contacts on Blackberry?

How to add IM contacts on Blackberry?

Hello Guys,

Issue: Instant Messenger on Blackberry. When adding new contacts on the Blackberry within Instant Messenger, Contacts always remain unknown status. Contacts show up in contact list within messenger but status is "Presence unknown".

Resolution:

The correct method for adding contacts is to highlight your name in BB Communicator (BB Enterprise IM), then choose “Add a contact”.  In the Sign-in Address field, you will type the user’s SIP address, which is not the same as their email address, although the two addresses may look the same. Using the person’s email address (ie. abc@ocsdomain.com) will not work, as Communicator uses the SIP address for identifying users (ie. sipaddress@ocsadomain.com).

However, there is a bug using that method because it will try to associate the BB Communicator contact with a pre-existing contact card on your BlackBerry. Therefore, you will need to go through and create the BB contact first before adding the BB Communicator contact.  There is also a problem where the “@” symbol may not resolve when performing a look-up function for the SIP address.

Recommend you add contacts through the desktop Communicator software, or the web Communicator client, instead of using the BB Communicator.

Note: Add contact on MOC and then use the same in IM on Blackberry.

  

Thank you.

Creating a Web Part page and Setting Web Part page as your SharePoint Home page.

Creating a Web Part Page:

From the main site collection, click the Site Actions button and choose Create from the dropdown
Under Web Pages on the next screen, click Webpart Page.

Give the Web Part Page a name, choosing desired layout and choose where you would like it saved. Then click Create.

After you click Create, the page will open from the lib. Where you have saved it.

You can start editing the page from here by adding Web Parts of your choice and can edit the page later by going to the doc. lib where you have saved it.

Setting Web Part page as your SharePoint Home page

This can easily be done is SharePoint Designer. If you have not installed SharePoint designer as a part of Office 2007 Enterprise, I highly recommend it. If you do not have Office 2007 Enterprise edition, MS offers a free 30 day trial of SharePoint Designer to test out as well.

In SharePoint Designer, open the site where you saved the web part page you created. In my case it is located in my personal site. When I created the web part page, I chose to save in Documents. Hit the + and expand the Documents folder to find you Web Part page.

Drag the page out of the folder and below the default.aspx page.

This takes it out of the place is SharePoint where is it was stored to prevent other people from making changes. Now it is associated with the site only.

Right click on your web part page and select Set as Home Page.

Click OK to the message.

Click OK to the next message if it appears.

This will be renaming your old default page as default-old.aspx and will name the Web Part page as default.aspx page.

You can also preview this  page in  your browser. Now you can see that your site has the web part page you created earlier, and you are able to edit the page accordingly. SharePoint Designer is incredibly powerful and you can do things much faster here than in SharePoint itself. Try it out for yourself. 

If you have any queries/questions regarding the above mentioned information then please let me know. Thank you.

How to Create a New SharePoint Group

Use the following steps to create a new SharePoint Group:

·         Choose Site Settings from the Site Actions and Click Modify All Site Settings.

·         Click Advanced Permissions from the Users and Permissions column

Caution: Check if the site you are adding the group to is inheriting permissions from its parent site. The site is inheriting permissions from its parent if you see the following message: “This Website inherits permissions from its parent Web site. To manage permissions directly, click Edit Permissions from the Action menu.”

·         To break Inheritance from parent site and give this site unique Permissions, click Edit Permissions from the Actions menu.

Note: You can switch back and forth between these settings as needed by selecting Inherit Permissions from the Actions Menu. However, it is important to realize that whenever a site is switched to inheriting permissions from the parent site, all unique permission settings within the site are discarded.      

·         Click OK on the confirmation pop-up.

·         Click New to open the new menu, and select New Group.

·         Type a Name and Description the new group.

Important: Use the following naming conventions.

SiteName_Designers

SiteName_Contributors

·         Enter the group owner information. The group owner will have complete control over this group, including modifying settings as well as adding or removing group membership. There can only be one group owner.

·         Enter Group Settings, Membership Requests.

Caution: If you select yes for the Auto-accept requests option, any user requesting access to this group will automatically be added as a member of the group and receive the permission level associated with the group.

·         Specify the permission level for the Groups.

·         Click Create to create the new group.