in

SharePoint Blogs

The Best Place for SharePoint-related Blogs

This Blog

Syndication

All About SharePoint - S.S. Ahmed - MVP Microsoft SharePoint

All About SharePoint, as the name suggests, is all about SharePoint. It has articles, tutorials, source code, FAQs, and tips about SharePoint, InfoPath, C#, Microsoft Office, SQL Server, XML, etc.

Published by

Comments

 

MS CRM and SharePoint 2007 Integration - ssa's blog said:

Pingback from  MS CRM and SharePoint 2007 Integration - ssa's blog

June 18, 2007 10:50 AM
 

Unblocking blocked files - ssa's blog said:

Pingback from  Unblocking blocked files - ssa's blog

June 18, 2007 10:50 AM
 

Creating an Installer for your web service - ssa's blog said:

Pingback from  Creating an Installer for your web service - ssa's blog

June 18, 2007 10:50 AM
 

Installing WSUploadService manually - ssa's blog said:

Pingback from  Installing WSUploadService manually - ssa's blog

June 18, 2007 10:50 AM
 

Searching PHP Sites With SharePoint - ssa's blog said:

Pingback from  Searching PHP Sites With SharePoint - ssa's blog

June 18, 2007 10:50 AM
 

Showing web service data in a Data View web part - ssa's blog said:

Pingback from  Showing web service data in a Data View web part - ssa's blog

June 18, 2007 10:50 AM
 

TechnoService Source Code - ssa's blog said:

Pingback from  TechnoService Source Code - ssa's blog

June 18, 2007 10:50 AM
 

TechnoService: Web service that retrieves blog information from Technorati.com - ssa's blog said:

Pingback from  TechnoService: Web service that retrieves blog information from Technorati.com - ssa's blog

June 18, 2007 10:50 AM
 

r.a.d.editor for MOSS - review with screenshots - ssa's blog said:

Pingback from  r.a.d.editor for MOSS - review with screenshots - ssa's blog

June 18, 2007 10:50 AM
 

Colligo Reader Review - ssa's blog said:

Pingback from  Colligo Reader Review - ssa's blog

June 18, 2007 10:50 AM
 

TechnoPart Source Code - ssa's blog said:

Pingback from  TechnoPart Source Code - ssa's blog

June 18, 2007 10:50 AM
 

Integrating ASP.NET AJAX with SharePoint (By Mike Ammerlaan) - ssa's blog said:

Pingback from  Integrating ASP.NET AJAX with SharePoint (By Mike Ammerlaan) - ssa's blog

June 18, 2007 10:50 AM
 

TechnoPart: Display your blog/site statistics in SharePoint sites. - ssa's blog said:

Pingback from  TechnoPart: Display your blog/site statistics in SharePoint sites. - ssa's blog

June 18, 2007 10:50 AM
 

Microsoft GroupBoard Workspace - ssa's blog said:

Pingback from  Microsoft GroupBoard Workspace - ssa's blog

June 18, 2007 10:50 AM
 

Publishing, Sharing And Searching PowerPoint Files in SharePoint - ssa's blog said:

Pingback from  Publishing, Sharing And Searching PowerPoint Files in SharePoint - ssa's blog

June 18, 2007 10:50 AM
 

arijitrc said:

I need to know how to change the blocked files into unblocked state in MS office Groove 2007. I dont know how to use the share point tool and want to download it. Please give a solution. Waitng for your response.

June 19, 2007 1:33 AM
 

Paul Hepple said:

anyone got his article, this sites seems broken?

June 21, 2007 5:47 AM
 

Elena said:

Hello!!

I read your last post about how to create a custom Web Service for SharePoint, and it helped me very much. Thank you

I very interested on read this post about how to create an installer for the WSUploadService but i think that there are problems with the web...

June 26, 2007 2:38 AM
 

Paul said:

Hi Paul,

Try here this is without a doubt the best "how to" out there:

blogs.ittoolbox.com/.../creating-a-custom-web-service-for-sharepoint-13553

Paul

June 26, 2007 2:10 PM
 

Starrose said:

where is the webservice????

June 28, 2007 5:16 AM
 

anip said:

how do you make a .ssa file work

June 29, 2007 9:10 AM
 

aidan said:

i need websites 2 get into you-tube, bebo , myspace and other websites plz wr bk

July 10, 2007 4:45 AM
 

aidan said:

i need websites 2 get on bebo myspace and you-tube and other websites plz wr bk

July 10, 2007 4:46 AM
 

m said:

mmmunblocking sites

July 12, 2007 2:58 AM
 

puteador said:

anda a la concha de tu hermana

August 9, 2007 11:00 AM
 

zooeyhall said:

I cannot see the rest of your comment.  Clicking on "read more" just brings me back to this page.

August 14, 2007 8:58 AM
 

Steven Van de Craen said:

Welcome back ! :) Hope to see more interesting posts from you !

And congrats on the MVP !

Steven

August 26, 2007 4:25 AM
 

ssa said:

Hi Steven,

Thank you very much! I am glad to hear from you. Yes, I have some interesting stuff lined up, and I am excited about it. Mostly I will publish small tips that would be helpful to the developer community. Thanks once again.

Regards,

S.S. A

August 26, 2007 9:18 PM
 

صور said:

It,s very useful

thank you admin

September 1, 2007 4:36 AM
 

SharePoint 2007 link love 09-04-2007 at Virtual Generations said:

Pingback from  SharePoint 2007 link love 09-04-2007 at  Virtual Generations

September 4, 2007 1:19 AM
 

Blogger Loser » Blog Archive » Fix “calling GetScopeID from a non-Office server binary” error said:

Pingback from  Blogger Loser  » Blog Archive   » Fix “calling GetScopeID from a non-Office server binary” error

September 4, 2007 4:55 AM
 

Blogger Loser » Blog Archive » Importing MS Access data in InfoPath said:

Pingback from  Blogger Loser  » Blog Archive   » Importing MS Access data in InfoPath

September 5, 2007 4:55 AM
 

Venkat M said:

Creating an Work Flow from Sharepoint Designer will help!

But, you cant create neat looking alerts from the SP desgner! :(

September 6, 2007 2:14 PM
 

ssa said:

Hi Venkat,

With new versions of SharePoint, things have become very easy to do, for example, you can also create a component and use it to send out alerts. As you said, you can create a simple workflow to do the same. In earlier days, main headache was to implement the functionality. Now, developers have got rid of that problem, now at least you can implement things easily. With little more effort, you can make the alerts look good! :)

Thanks for the feedback!

SSA

September 6, 2007 11:21 PM
 

Blogger Loser » Blog Archive » Adding content to Word “content control” programmatically said:

Pingback from  Blogger Loser  » Blog Archive   » Adding content to Word “content control” programmatically

September 7, 2007 5:54 AM
 

Blogger Loser » Blog Archive » Using caspol.exe to add assemblies to full trust assembly list said:

Pingback from  Blogger Loser  » Blog Archive   » Using caspol.exe to add assemblies to full trust assembly list

September 7, 2007 5:54 AM
 

SHAREPOINTBlogs.com Mirror said:

Multi select list box that comes with InfoPath 2007 does not work in web forms so you have to create

September 9, 2007 12:19 AM
 

Blogger Loser » Blog Archive » Using powershell to add a policy feature to the collection said:

Pingback from  Blogger Loser  » Blog Archive   » Using powershell to add a policy feature to the collection

September 9, 2007 6:00 AM
 

Blogger Loser » Blog Archive » Populating multiselect list box in InfoPath 2007 web forms programmatically said:

Pingback from  Blogger Loser  » Blog Archive   » Populating multiselect list box in InfoPath 2007 web forms programmatically

September 9, 2007 6:00 AM
 

vivek said:

Does this support for Infopath 2007?

While adding action it shows for database connection in dropdown but it does not give sharepoint connection option in dropdown menu.

Thanks

September 12, 2007 2:23 AM
 

ssa said:

hi Vivek

This post was written for InfoPath 2003. In InfoPath 2007, you can still post to two connections but you are right, the drop down doesn't show two separate options. It only shows one data connection option. You will have to create two connections, both of the type "data connections", one will submit to a SharePoint library, the other will submit to a web service. Using web service, you can send data to the database.

-SSA

September 13, 2007 1:03 PM
 

ssa said:

hi Vivek

This post was written for InfoPath 2003. In InfoPath 2007, you can still post to two connections but you are right, the drop down doesn't show two separate options. It only shows one data connection option. You will have to create two connections, both of the type "data connections", one will submit to a SharePoint library, the other will submit to a web service. Using web service, you can send data to the database.

-SSA

September 13, 2007 1:03 PM
 

Madona said:

Hi....

Do anyoe can help me in unblocking some of my applications.

Like Utorrent and Gaim messenegr. I'm using Linux ubuntu 6.10 and in my collge our principal suddenly blocked all these applications and i am not able chat  using gaim or download anyhing through utorrent... So anybody can help me in this...

September 15, 2007 1:46 AM
 

All About SharePoint - S.S. Ahmed - MVP Microsoft SharePoint said:

WS-Downloader Web Part I released WS-Downloader tool last week. WS-Downloader is a small tool that downloads

September 15, 2007 10:36 PM
 

All About SharePoint - S.S. Ahmed - MVP Microsoft SharePoint said:

Groove and SharePoint I recently blogged about OneNote and SharePoint . Today, we will see how Groove

September 15, 2007 11:10 PM
 

Vivek said:

Thanks Ahmed !!

September 17, 2007 7:20 AM
 

Vivek said:

Hi Ahmed

Thanks for your suggestion. Can you please tell me in brief how to implement this. Do I need to write code for its implementation.

September 17, 2007 8:30 AM
 

ssa said:

Hi Vivek,

1. Create a new InfoPath project and select database option when creating the form. It will show you 5 options including database, webservice, blank, etc. Select database option and click Ok.

2. Next it will ask you to select a database. Now select a database. It will automatically create a data connection for you.

3. Now go to the submit options and create a connection that would submit data to a SharePoint library.

You may have to do some tweaking to make sure that data is being submitted to both db and SharePoint. I dont think you will have to write any code for this. Simple rules and submit options will solve your problem.

Regards

SSA

September 17, 2007 8:58 AM
 

Vivek said:

Thanks once again !!

Regards

Vivek

September 18, 2007 12:06 AM
 

Brent Tolliver said:

I am having issues with MOSS 2007 Alerts not sending to groups where the test group is called DB Alert and there are 5 users in that group.

All members get the initial subscription email but don't get the daily summary alert of the announcement when is is supposed to send. Do you have any thoughts on this?

September 18, 2007 12:24 PM
 

aks_bharathi said:

I need to pull all the documents from Sharepoint server 2007 (with MSDE installation).

Please help buddy?!

September 19, 2007 4:46 AM
 

aks_bharathi said:

Hey Buddy,

                   I tried your tool, its looking kool.

I followed your instruction and got the option in Sharepoint.

When I entered the Site and Destination.

Its showing error as follows,

WS-SharePoint Downloader: Microsoft.SharePoint - Value does not fall within the expected range.

Please help gentleman..

September 19, 2007 7:08 AM
 

aks_bharathi said:

Hey Buddy,

                   I tried ur tool, its very useful, good work man.

Keep it up!!! :)

I want to download the whole document library of a site in one shot.

Is it possible with your software in Sharepoint server 2007?

September 19, 2007 8:03 AM
 

Tim said:

I've tried this, and although it works in document libraries, the block is still applied to attachments in lists.

Any idea how to get around that one?

September 19, 2007 11:03 AM
 

ssa said:

Hi Brent

Yes, this is a problem with MOSS 2007. If users are members of subsites and have adequate permissions but they are not members of any group in the top level site, then the alerts do not work as expected. Sometimes, they work and sometimes not! The solution is to add the members of your group (DB Alert) in a top level site. You can assign basic permissions (like reader) to the members. Try it and see if it solves your problem!

Regards,

SSA

September 19, 2007 9:33 PM
 

ssa said:

I have yet to see a tool that downloads all the documents from the SharePoint 2007. I thought there would be lot of them available so discarded the idea of upgrading this tool (SP DocPuller) for MOSS 2007. May be I will upgrade it for use with MOSS in future.

Regards

SSA

September 19, 2007 9:39 PM
 

ssa said:

This web part was released as a trial. I didn't see much demand for it when I developed it so left it incomplete. Yes, it will still download the whole library but as far as I remember it won't keep the folder hierarchy intact. All the documents will be downloaded to the same folder.

SSA

September 19, 2007 9:42 PM
 

ssa said:

It depends what type of attachments you upload. If filetype of attachment is included in the blocked list then it wont be uploaded. You will have to remove it from the blocked list.

September 19, 2007 9:45 PM
 

FxProgrm said:

Source would be handy as well... there are a couple of issues when working with large document libraries... like it takes 6+ hours to export 1400 documents thus far.

September 20, 2007 3:49 PM
 

Yash said:

Hi

I dont know why this is not working our for me.

I written same line of code in item updated event handler and i want to remove the latest version after checking some properties of incoming file.

I think I need to look for somecollection of SPFile or SPItem....

If it workes will let you know guys!!...

September 20, 2007 6:01 PM
 

ssa said:

Hi Yash

This is an old post. This code works in SharePoint 2003 version.

Regards

SSA

September 20, 2007 7:27 PM
 

MARCIA said:

UNABLE TO OPEN SOME FILES

September 23, 2007 11:47 AM
 

Gunjan Grover said:

HI,

can any one help me out in creating a new folder in a sharepoint library on submitting a form.

Thanks in advance

Regards,

Gunjan

September 26, 2007 1:06 AM
 

SharePoint CRM Connector said:

Have a look at this product, integration CRM to SharePoint

September 26, 2007 12:48 PM
 

Labhesh shrimali said:

It's nice artical.  mostly required for Business Data Catalog and CRM Integration.

Just a question here: is this integration possiable only with MOSS 2007 or WSS 3.0 also can fetch data from CRM using BDC.

I am also not sure weather any tool was available to fetch data from CRM with earlier version of MOSS(WSS 3.0).

September 27, 2007 1:50 AM
 

galina said:

One more question please.

Web service that will be used to submit data to db: can it live on any server or it has to live on the same server where Sharepoint is installed?

Thanks a lot for your help

September 27, 2007 1:22 PM
 

Galina said:

One more question: web service used to submit data to the database- can it live on any web server or have to be installed on the same server where Sharepoint is located?

thanks

September 27, 2007 11:11 PM
 

ssa said:

Galina

The web service should be available on the SharePoint server where data is to be submitted.

SSA

September 28, 2007 10:23 AM
 

ssa said:

Gunjan

You can find the code for creating a folder in SharePoint on the net. For the other task, you can do it in the two ways:

1. By using the eventhandler  in SharePoint. When form is submitted, capture the form in the eventhandler and at that time create a folder.

2. Implement the functionality to create the folder in the form itself. for example,

In the internalstartup(), add the following:

EventManager.FormEvents.Submit += new SubmitEventHandler(FormEvents_Submit);

Then use following code to submit:

 public void FormEvents_Submit(object sender, SubmitEventArgs e)

       {

if (e.InputParameters.ContainsKey("XmlLocation"))

           {

                string Location = e.InputParameters["Source"].ToString();

               Location = Location.Substring(0, Location.IndexOf("/", 8));

               _DocLibLocation = Location + e.InputParameters["XmlLocation"].ToString();

           }

           else

           {

               _DocLibLocation = e.InputParameters["SaveLocation"].ToString();

           }

/////////////////

                   FileSubmitConnection SubmitConnection = (FileSubmitConnection)this.DataConnections["SubmitForm"];

           SubmitConnection.FolderUrl = _DocLibLocation.Substring(0, _DocLibLocation.LastIndexOf("/"));

           SubmitConnection.Execute();

                   e.CancelableArgs.Cancel = false;

               }

Create "SubmitForm" data connection before using the above code. SubmitForm dataconnection will simply submit your form to the SharePoint document library.

September 28, 2007 10:33 AM
 

Gunjan Grover said:

SSA,

Thanks a lot for the solution, but the problem is this that for eventHandling too i need to do scripting either in javascript or VBScript, can you please help me out with that?

October 2, 2007 10:45 PM
 

Gunjan Grover said:

Moreover i tried to do it in javascript... the code is:

function XDocument::OnSubmitRequest(eventObj)

{

// If the submit operation is successful, set

// eventObj.ReturnStatus = true;

// Write your code here

//Create string objects for each field we will use to modify the FolderUrl

var xnLocation = XDocument.DOM.selectSingleNode("my:myFields/my:strLocation").text;

var xnFolderName = XDocument.DOM.selectSingleNode("my:myFields/my:strFolderName").text;

var fc = XDocument.DataAdapters["SubmitForm"];

fc.FolderURL = xnLocation + "/" + xnFolderName;

//Execute the submit connection

try

{

   fc.Submit();

   eventObj.ReturnStatus = true;

}

catch(ex)

{

   var txt = ex.description;

   alert(txt);

   //eventObj.ReturnStatus = false;

}

}

but it throws an exception that folder doesnot exist.

Any comments??

October 2, 2007 11:56 PM
 

Blogger Loser » Invalid column name c2 said:

Pingback from  Blogger Loser » Invalid column name c2

October 3, 2007 9:10 PM
 

Blogger Loser » Invalid column name c2 said: