SharePoint - Social Computing Forum

SpQuery CAML code for Blog posts count

Wed, 25 Nov 2009 16:05:32 Z

I have the problme with CAML query for SPQuery to get all the blog posts by a user, I could able to get the all the discussions by a user but I couldnt get the blog posts count. Can Any one please help me. Here is my CAML query for blog posts.

     SPQuery query = new SPQuery();                                  
                                    SPList splist = spWeb.Lists["Posts"];                                 

                                    string spUsrId = spWeb.AllUsers["SqlMembershipProvider:" + username].ID.ToString();
                                    Context.Response.Write("spUsrId : " + spUsrId);
                                    query.Query = "<Where><Or><Eq><FieldRef Name='Author'/>" +
                                       "<Value Type='User'>" + spUsrId + "</Value>" +
                                       "</Eq><Eq><FieldRef Name='Editor'/>" +
                                       "<Value Type='User'>" + spUsrId + "</Value>" +
                                       "</Eq></Or></Where>";

I dont understand what will be the difference between forums and blogposts query.

Any help please.

thanks in advance,

Aruna

MySite recommendations?

Mon, 23 Nov 2009 21:27:00 Z

Hello,

Does anybody have a recommendation and "how-to" for setting up MySite on new farm and migrating MySites from the old farm (all MOSS 2007)? Here is the scenario: current MySite is set up on what seems to be the same web app as the main SharePoint portal. From what I gathered in blogs and Microsoft documentation, it is better to set up MySite on its own application. Our company intranet is http://cointranet and I'd like the users to be able to have their websites at http://cointranet/mysite/personal Is it possible if the company intranet and mysite are set up on two different web applications? IF it is a possibility, how can I migrate some of the users' mysites to the new structure?

So far I configured Shared Services and created new web app for MySite during SSP setup. So my SSP is on port 100 and MySite on port 200, while main portal web app is on port 80.

Thank you!

Wiki page history problems

Tue, 24 Nov 2009 23:43:15 Z

In the wiki page the history gives only system date. I want to display a custom date instead of system date. how to do that? Thanks in advance for your help

Replacing MOSS Forum functions

Tue, 30 Sep 2008 03:18:42 Z

A customer is not happy with MOSS forum features, and we are considering proposing Telligent's Community Server, has any one tried this and does the integration works well?

Need a bit of help getting My Site functionality to work

Sat, 27 Jan 2007 03:20:24 Z

Hi all.

I have installed MOSS 2007 enterprise in a simple-server farm mode using a SQL 2005 backend.

It appears I have everything else working except the My Site functionality.
When I click on My Site, I get:
Your personal site cannot be created because Self-Service Site Creation is not enabled. Contact your site administrator for more information.

So then I enable Self-Service Site Creation for the web app that is hosting the My Site service and try again. This time I receive:

There has been an error creating the personal site. Contact your site administrator for more information.

I have the SSP set up so that the admin site is on one web app on a port other than 80, and the My Site is on a different web app at port 80 at relative url mysite/

I am not sure but think it may have something to do with the permissions on the SQL databases for the account holding up the SSP or the web app's identity account.

My SSP service account is called moss-ssp1 and it has db owner on the 2 shared services databases and the WSS databases.
My web app identity service account is called moss-apppool and it has db owner as well on the SQL databases.

Anyone have ideas on what it could be and/or the fix to get My Sites working?

Thanks a bunch,

How to get get text-only content from a blog list item instead of rich-text?.

Tue, 24 Nov 2009 15:47:54 Z

I am using object model to get the rich-text content from the body of a blog item. Is there an API that would allow me to get simple text instead of rich text?

Issue with MySites

Mon, 23 Nov 2009 19:35:30 Z

I am experiencing a very strange issue for all users, where randomly, upon logging on to the MOSS Portal - MySite, it is creating a new site, as if it were the first time a user was logging on.

Even though it is attempting to create the new MySite, the lists / content still remains, but My Links, the Profile picture, and Collegues are gone. After this, if I log on again, everything is fine, until one day, randomly this cycle repeats itself.

Has anyone seen such an issue before?

TIA,

Ian

How do I display department inbox using My Inbox

Fri, 20 Nov 2009 08:33:48 Z

Hi,

I configured the My Inbox webpart for several users so they can see there mail. Works great.

Now I want to display the inbox of another user (e.g. info@mycompany.com or recruitment@mycompany.com) to a select few but the webpart remains blank.
When I log in as the info user or the recruitment user the webpart displays the inbox just fine.

My questions:
Can I configure the My Inbox webpart to display another users inbox?
If so: how?

BTW we are using Exchange 2007

Thnx!

Sander

what are the prerequisties for MySite in the sharepoint 2007?

Mon, 23 Nov 2009 12:51:53 Z

what are the prerequisties for MySite in the sharepoint 2007?

"EMail This Post" link not working

Wed, 19 Mar 2008 10:38:40 Z

Hello,

When we create blogs under MOSS 2007 there is a problem with the "Email this Post" link under each blog post. The link opens a new email message with a link to the post but this link will work only work for URLs that do not contain a space e.g.

http://sharepointsite/mysite/myblog/lists/posts/post.aspx?id=1

The problem is with any url containing a space as it is being double-encoded in the email e.g.

http://sharepointsite/my%20site/my%20blog/lists/posts/post.aspx?id=1

in the email actually reads:

http://sharepointsite/my%2520site/my%2520blog/lists/posts/post.aspx?id=1

where the "%" in "%20" is encoded into "%25". I managed to find a blog that mentioned this problem but the solution was only for the link in the list view, not the link visible on the blog page. Has anyone else seen this and/or know of a fix?

Thanks very much in advance,

SP2 fixed the mySites bug that I did not want fixed

Tue, 16 Jun 2009 14:03:46 Z

After installing my MOSS 2007 service pack 2 I noticed user getting redirected to mySites instead of the userdisp.aspx. I would like to have my users only go to the userdisp.aspx page. I understand that on the click of a user name the userdisp.aspx page redirects to person.aspx on port 3142 (mySites). I tried to remove the redirect with no luck. Could anybody please tell me how do I configure SharePoint to display only the userdisplay.aspx profile page rather than going to mySites. In addition, I changed the profile service link to something random I a hope that if SharePoint could not find mySites it would default to the userdisp.aspx but this did not seem to work either. Any suggestions would be welcome...

Wiki Usage?

Thu, 19 Nov 2009 17:04:46 Z

Any idea how I might go about tracking wiki usage. I would like to know how many people visit particular pages.

tabrandt

Disabling ability to create blogs only on mysites

Thu, 12 Nov 2009 19:19:46 Z

Hello All
We are in MOSS 2007 Feb CU. We would like to prevent the ability to create blogs on Mysites. We would still like to be able to create blogs in other webapplications within Sharepoint. Can you give me a few pointers and let me know how this can be done?

Thank you

can you put an alert on a single blog post so any time anyone adds a comment you will get an email?

Thu, 19 Nov 2009 19:17:24 Z

can you put an alert on a single blog post so any time anyone adds a comment you will get an email?

nonam

Renaming the Default Libraries in MySites with Feature Stapling

Sat, 14 Nov 2009 14:09:26 Z

Dear All

I've just managed to get feature stapling to work on MySites (with a lot of help from the codeplex MySiteCreate sample) to change the master page, theme and some web parts.

I really need to be able to change the name of the "Personal Documents" and "Shared Documents" libaries too as they the wording isn't really applicable for our students. Please could you help me do this? Is there something I can add into my feature so that when the MySite is generated, the names are changed?

Is it also possible to delete unwanted libraries and pages? For example, "colleagues" would not be applicable to our students.

Any help would be greatly appreciated.

Many thanks

Daniel

sharepoint blog summary web part

Thu, 12 Nov 2009 15:23:29 Z

someone wants to put a webpart on the front page of our site that will show a title and brief description of the last 2 or 3 blog posts. The blog exists on a subsite.

Is there something built in that I could use for this?

I should have been more specific. I can get the Content Query Web Part to work, but that will only show the title. Is there a way to get some of the post as well?

My site creation failure

Wed, 11 Nov 2009 20:25:03 Z

Just noticed that when creating a mysite for a new user, we get an event log error ID =5187. "My site creation failure for user xxxx. ......A failure was encountered while attempting to create the site........Error during encryption or decryption. System error code 0"

My sites work for existing sites. We only get this error when creating mysites for new users. Getting this same error on two separate farms.

"My SharePoint Sites" in Office Save As Dialog

Wed, 18 Nov 2009 14:43:27 Z

Hi,

We have reinstalled a number of users Operating Systems onto their machines. They are also using Office 2007.
They previously had access to SharePoint on their old machine and had clicked on their "My Site" link in SharePoint.
On their old machine they had a link in the Office 2007 Save As dialog to "My SharePoint Sites".

On their re-built machine the "My SharePoint Sites" link is not there now.
There seems to be no obvious way as to how these links get there in the first place.

How do we get it back on all machines?

MySite, hide the site actions menu.

Thu, 30 Jul 2009 20:06:24 Z

So I like the idea of each person having their own Profile and basic MySite.
What I don't like is that each Mystie is a root Site Collection with the MySite user as Owner.
Is there a permission model I'm not understanding here or something else.
Specifically I want to remove the MySite Create ability, and Site Settings page from the Mysite users.
Goal is I don't want 100's of users calling me up and asking "what does this do???"

SharePoint Profile Privacy

Tue, 17 Nov 2009 18:01:13 Z

For a small set specific users in my organization, personal data needs to be hidden from everyone else in the organization. This means that searching for a protected name or email should not return SharePont profile results, and viewing the Person.aspx page for that account should not show the name or email address. Is there a way to set the privacy policy on these fields?
I considered not importing these users from Active Directory into SharePoint, but I do not want to deny them any services. Is having a profile a technical requirement of the My Site service?

OWA in mysite area

Wed, 18 Nov 2009 10:40:39 Z

Hi, Not sure if i am doing something wrong with the setup of sharepoint but i cannot get users to be automatically logged into the owa sections of their mysite (calendar and inbox). Each time they laccess sharepoint they need to re-enter their username and password into the owa boxes even though they are automatically logged into sharepoint through AD which they find very annoying. It keeps the server settings fine. On another note (not sure if i should post it elsewhere) how do i edit the default mysite template so they i can give them all a consistent branded mysite to begin with. I am using sharepoint designer
Thanks very much
Gavin

Blog Webpart?

Mon, 06 Jul 2009 09:01:50 Z

Hi,

Is there a blog webpart? I want to display the first few posts of this blog on a home page. It seems that in MOSS 2007 the Blog is a site, I am looking to somehow show a webpart with the latest blog posts from the blog. Any way to do this?

Thanks,

-Westside

how to have publishing, blog and wiki features together?

Tue, 17 Nov 2009 17:38:18 Z

Hello everyone,

I am using SharePoint 2007 Enterprise + Publishing portal template + Windows Server 2008. I want to have blog and wiki features as well as publishing portal features. Any ideas how to integrate publishing portal, blog and wiki? For integrate, I mean using the same user name and password to pass through authentication of publishing portal, blog and wiki. And should I setup 3 different site collections for publishing portal, blog and wiki (I find if I setup publishing portal site collection, I can not create blog and wiki sub-site)?

thanks in advance,
George

Restoring "Add Comments" web part

Fri, 06 Mar 2009 16:00:50 Z

Hi All,

I created a site based on "blog site" template. Usually, these sites come with certain content types like Posts, Comments and page layouts like creating a new post, adding a comment etc.

Something happened when I created a blog site that I am now unable to add comments to existing posts. I can see the link that says "Comments(0)" but it is not an hyperlink and text boxes for creating comments are missing. Even if I go at the list level and add a comment, the post for which that I created the comment does not say "Comments(1)". I verified that there is a lookup column in the Posts list that ties the post to its comments.

I am trying to restore these web parts but do not know how...

If I open the site in SP Designer, I can see that one of the web parts is missing but when I try to copy this web part from an existing site (which is working fine) and paste it into my existing site (of course, I changed the list ID etc.) it does not work.

In essense, the problems that I am facing right now are :

1. I cannot see add new comment web part when I click on a post.
2. Even if I create comments at the list level, they are not displayed when I click the corresponding post. I have ensured that there is a lookup column that ties post list to comments list.

Any ideas, suggestions or pointers?

Thanks!

Issue with Wiki site - German keyboard

Fri, 05 Jun 2009 13:23:49 Z

Since a long time we are facing very wearied issue with wikisite

Some of our colleagues work from Switzerland and they use “German” Keyboard,

Now the problem is only in wiki site they could not able to type “]” but they could type “[“.

They have MOSS sp1 infrastructure,

I too have tested the same here in German keyboard – Laptop D410,

The regional language for the keyboard is “Switzerland (German)”. (DE)

The strange thing here is we could type “]” in notepad as well as WordPad when Keyboard is in DE mode but not in Wiki site.

If we change the keyboard language mode to EN we could type “]” in wikisite,

In German keyboard the shortcut to type “]” is AltGr+],

Now if we type AltGr+] 24 time we could type “]”, ie, AltGr+] key first goes to all the toolbar controls of wiki edit page and at last it type “]”,

Hence I could see that their could be a problem with Wiki page shortcut keys,

This is not so major but many of our employees in Switzerland uses SharePoint wiki site to updates and they are facing much problem for typing “]”,

Hence can you please let me know is this issue being documented somewhere in Microsoft msdn or any solution for this kind of issue.

Kindly request to help me out, looking forward for your positive response,

Thanks in advance,

Importing formatted html into multi-line list field in Blog

Mon, 16 Nov 2009 16:01:49 Z

Problem: I have formatted html text that I need to get imported into a multiline text field.

Background: In wss 2.0 we wrote a custom template to function as a blog, In 3.0 we are moving all the contents of the blog to the out of the box blog that wss 3.0 offers. In the process of the move, I have been able to extract 3 key fields from our 2.0 db. Title, Body, and publish date. The body field in our database is stored as formatted html (ie <Strong> Hello Board </Strong>). We have multiple custom 2.0 sites with 3000+ post. Our stated direction is to return to an out of the box implementation rather than recreating a custom site definition and mapping it for an upgrade.

The wss 3.0 multiline text is set to hold enhanced rich text.

When I import either by importing a custom sp list or by switching to datasheet view with a simple copy and paste, the end result is always the text field explicitly holding the html tags as entered text instead of recognizing it as the formatting. (ie <Strong> Hello Board </Strong> instead of Hello Board) I understand that this is a non issue with sharepoint and it is functioning properly but has anyone experienced this situation and could you point me in the appropriate direction to handle? I have researched this and found close problem and solutions but none have panned out for me as of yet. Any help would be greatly appreciated.

Best Practices for My Links

Thu, 12 Nov 2009 15:51:22 Z

Are there any best practices available for My Links?

SharePoint Architect

Is there a way to s keep 2 WIKI's in sync (As in update)

Wed, 11 Nov 2009 00:33:55 Z

I have 2 wiki's and i would like to keep the 2 in sync.
I was thinking of using the stsadm restore cmd to do this but it restores the whole site plus the root site.
Anyways to update WIKI's from another WIKI.
Thanks in Adv

Enable a Wall to Write On in My Sites ?

Fri, 13 Nov 2009 07:26:30 Z

I have a new user that is asking whether they can have a "wall" to write on, like on Facebook. Is it possible to enable something like that in MOSS 2007?
Thanks.

Allowing users to manage their email addresses in MySites

Wed, 11 Nov 2009 09:48:13 Z

Environment is MOSS 2007, with one button install for standalone server.

After many Google searches, found that setting email addresses for users is in the Share Services administration area. However, this is an untenable solution for system administrators. Right now in My Sites the Work Email address cannot be entered by the logged in user. Is there any way to let that be edited by the user ?

Thanks,
Mark Story

allow anonymous to post comments in blog

Wed, 08 Jul 2009 22:11:14 Z

Hello,

First of all, sorry about my english, and i am newbie with sharepoint

i have problems allowing anonymous to post comments in blog. i read post like:

http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/865333e6-686d-495b-8390-c837ba173135?persist=True

http://www.alpesh.nakars.com/blog/howto-set-permissions-for-comments-on-sharepoint-blog/

and others about allow anonymous post or comment in blogs but my problem is that the site have the default web aplication to visitors (anonymous) and an extension to extranet. how can allow anonymous to post comments in blog with this scenario? may be disabling the windows autentication in the default aplication? (i read about the windows autentication disable the anonymous post or comment)

thanks in advance, and please, tell me if i am not clear.

How can I show conference room calendars in SharePoint "My Calendar" webparts?

Tue, 16 Jun 2009 14:28:22 Z

I have a generic MOSS 2007 setup trying to connect to exchange 2007. The exchange server houses an existing conference room (aka a reference room)

I have gotten to the point where I can view the calendar of the person logged in is trying to view their own calendar. BUT they see the OWA login prompt first.
Mail server address: https://owa.MyCompany.net/owa
Mailbox: confroom777@MyCompany.net

If I use Http I get a 403 error. If I try to view the confroom77 mailbox by logging in as my user account, I get this error:

"This mailbox cannot be opened. The mailbox may be located in a different forest from the Microsoft Exchange Client Access server. For access to the mailbox or for more information, contact technical support for your organization."

I'm guessing that I'm missing something for an auto login but regardless, I cannot view another users public mailbox. Or am I missing the point of the "My Calendar" webpart?

Simplest way to show current date in sharepoint wiki page?

Wed, 11 Nov 2009 16:18:07 Z

I have a wiki page (which I use as confirmation page when new list entry is submitted).

Sometimes later I will import all data into access and send real confirmation, but for trivial simple start I was thinking about adding trivial javascript printing current date, so the page will look "current".

Like this JS snippet:

http://www.tizag.com/javascriptT/javascriptdate.php

or this, specific to SP:

http://www.jeremysimmons.net/blog/CommentView,guid,932ce6f6-499f-49e9-aedd-2331000032cf.aspx

Well, I have no luck with either approach - when I try to edit HTML of the wiki page to insert JavaScript snippet, SP "helpfully" eliminates the script.

Am I just dumb, or even such a trivial thing requires couple dozens of C# and XML configuration like this overkill solution?

http://www.mtelligent.com/journal/2007/9/29/sharepoint-2007-custom-date-time-field-to-default-the-time-t.html

Moving from main site to My Site without prompting the user to re-enter password

Wed, 19 Aug 2009 13:36:52 Z

Hi all,

My main site is on port 80, and I have configured My Sites on port 82. Users are local users (not domain) but soon they will be configured as FBA users.

When the user goes from the main site to my site, he/she is re-prompted to enter his credentials, even if they are the same.

Is there a way to avoid this? The user should only be asked once for the credentials.

Thanks,
fmtzbalt

How to add a "sharepoint main site" hyperlink for all users' mysite?

Tue, 10 Nov 2009 15:14:08 Z

hi Sir
we just deployed MS SharePoint 2007 in our office recently. everything is fine, but users tell us that they cannot find a hyperlink, so that they can directly click that link and go back to the SharePoint main site (and no need to type the url by themselves).
I would like to ask.. is there any way that can achieve the above purpose for all mysite users (http://mysite.xxx.org.hk/_layouts/MySite.aspx)??
Thanks
CT Lau

SharePoint wiki major vs. minor versioning

Tue, 03 Feb 2009 18:55:14 Z

We've been using SharePoint wiki for 18 months. We're using checkout because it's not clear that the wiki supports merge upon a conflict save.

Recently we've seen that it takes SharePoint 15 seconds to display a wiki article that's of a minor version. Major versions display pretty quickly, less than a second. I suppose we can start saving to all major versions... but why is this happening? Is SharePoint merely saving diffs for minor versions checkins, and thus it needs to rebuild it on demand? Is there anyway to store the most recent doc in the cache?

Upgrading to 64-bit hasn't improved this.

Jon

How to add custom column in Links list in MySite

Wed, 11 Nov 2009 19:02:55 Z

Hello,

How to add custom column to Links in My Site.

Thanks in Advance..

Changing user domain

Tue, 10 Nov 2009 14:32:35 Z

Hi,

We have our sharepoint 2007 entreprise farm importing users from two different AD. Let's say 'potato' and 'orange'.
We have mysite creation activated in our farm.
We have to change one user from potato to orange.
The user domain is not in the mysite url of the user. We have http:\\...\personal\fLastName.
Questions:
1- How can I change potato\fLastName to orange\fLastName?
We wante to disable potato\fLastName AD account and then create orange\fLastName.
Does it impact profile AND mysite?
2- What are the impact on document history?
Will I still be able to see what potato\fLastName changed or it will show orange\fLastName?

Thanks.

Add image in blog content

Fri, 19 Jun 2009 09:49:19 Z

Hi,

i am using wss 3.0.

I have created in one blog site.

In my blog site I need to add an image in post content.

Kindly help me

Edit Details in Sharepoint 2007 My Site Page

Fri, 06 Nov 2009 18:02:15 Z

Our Company is currently using Sharepoint 2007 as our intranet. We want users to start using it for more collaboration and search funtionality. One function we would want to give each user is the ability to modify their extension number. However, users cannot edit the "Work Phone" field in the My Site. Is there a way to be able to modify this field?