Outlook by the sound : MOSS2007

Automatic file upload to SharePoint Sites in Windows Server 2003 X64

OBTS — Sun, 02 Dec 2007 19:52:30 GMT

Automatic file transfer between SharePoint document libraries (solution version date 6 Dec 2007)

Comment: previous posts mentioned inability of automatic file transfer between document libraries. This is a workaround, in which we use a Windows folder as temporary location in the automatic procedure.

Applies to: Most windows versions, including Windows server 2003 X64.

Reason for this solution:

Mapping network drive for SharePoint sites works unstable (see posts on disappearing files), and in my case I cannot even create one, apparently because my SharePoint site has a specific port number.
Webdrive 7.XX does not support Windows Server 2003 x64: windows service option does not start up, and drives are not visible by other applications that work as windows service.
Automatic transfer of files directly between document libraries gives errors.

Requirements:

Webdrive 7.XX (or comparable web folder drive mapping application, but try WebDrive first)
RoboTask (or comparable automation application, but try Robotask first)
FireDaemon (or comparable ‘run as a service’ application, but try FireDaemon first)

Procedure:

Install Webdrive, RoboTask and FireDaemon. Do NOT make use of the ‘run as a service’ options in WebDrive and RoboTask, because that options use the local machine service account to access drives, which makes certain features inaccessible, or make WebDrive mapped drives inaccessible for needed applications.
Install Webdrive as service in FireDaemon: Choose a distinctive service name like WebdriveFD. Then, browse for the executable [C:\Program Files (x86)\WebDrive\webdrive.exe], Tick ‘Console Application’, use as logon account an account that has full access to the SharePoint site, tick ‘Interact with desktop’, startup mode Automatic, leave the rest as default.
Install RoboTask as a service in FireDaemon, use the procedure as mentioned above, i.e. use RobotaskFD as name etc.)
FireDaemon will cause WebDrive en RoboTask windows to automatically open (and reappear if you close them). This is o.k. for now, for as long as you are working with their settings. Do not start Webdrive or Robotask through the normal way, because then your current windows account will run them, which we don’t want.
In WebDrive, set the SharePoint connections as drive letters the way you like it. I.e. but the top level site of your SharePoint site as one web drive. Use always the same windows account that has full access to SharePoint document libraries.
Although FireDaemon uses the same windows account for WebDrive, the drive letters are not accessible for the current account that is logged in on the Windows console: i.e. in your Windows Explorer you might not see WebDrive drive letters, and if you use the same letters or they are inaccessible; just leave them as they are.
A way to check if the ‘background’ drive letters are successfully created and accessible, is to use Robotask (which uses the same login account in FireDaemon): In Robotask, make a ‘Move’ task that moves files from a pickup folder (a windows folder) to a document library in your newly created drive letter. (Later you can set the Move task to check the windows pickup folder if files change; if they do, a procedure starts to move the contents to a document library. You can add multiple tasks with wildcard filters, i.e. files that start with “XX-“ are moved to the document library that has a topic with code XX- etc.)

Creating a new, or changing settings of the background WebDrive connection:

1. While the FireDaemon services are running, open WebDrive main window by right-clicking on the WebDrive icon in the tray.

2. Add a new connection or change settings the way you want, including correct credentials to login into the MOSS site.

3. Important: tick 'Connect at login/startup'

4. Click 'Connect'

5. There will be a popup error message “Drive XX does not exist”. Ignore that error message because the drive has successfully been made in the background. (it is your current logged on windows account that tries to access the drive)

6. Open de FireDaemon Service Manager,

7. First Restart the FireDaemon WebDrive service

8. Then Restart the FireDaemon RoboTask service

9. The Robotask is now able to use the new WebDrive drive letter for its tasks, which you can check by creating a copy task and browsing inside RoboTask application for the newly created drive letter. Your current logged on windows account you will see network drives as 'Disconnected Network drives' which cannot be accessed or disconnected. I have not been able to remove these icons from the Windows explorer without losing the background drive connections, so leave them as they are.

Disconnecting a background WebDrive connection:

1. While all FireDaemon services are running, open WebDrive (through Start menu or by right-clicking on the icon in the tray)

2. Untick 'Connect at login/startup/'

3. Click Exit.

4. Restart the FireDaemon WebDrive service

5. After that, restart the FireDaemon RoboTask service

Note: when disconnected, the WebDrive drive letter will be visible in the Robotask browse menu, but won't be accessible.

Deleting a background WebDrive connection:

1. First disconnect the network drive as mentioned above (up to restarting the services which is not necessary yet)

2. Then open Webdrive again and delete the network drive connection.

3. Restart the FireDaemon WebDrive service, and after that restart the FireDaemon RoboTask service.

Note: change settings when using the console account, not through a remote desktop account because then you won’t see the icons in the tray.

When installing the Webdrive and Robotask services in FireDaemon, both services should be set running on a Windows user account that can access MOSS sites and that is primarily used for background services like this. Use another account to log into Windows console yourself or things start to conflict if you edit the WebDrive settings.

Comment: You never need to reboot in order to create or delete a drive. Especially for deleting network connections, just follow the instructions mentioned above.

Solution for automatic document transport between document libraries:

Robotask (and other file transfer programs I checked) cannot automatically move files between document libraries, either a copy/move error appear or changes to files on the server side are not noticed.

A workaround is to create two different tasks: one that moves files from a document library to a windows folder, and another task that moves files from the windows folder to a document library. This works like a charm, although you need to take care of the cache settings in WebDrive:

1. Open Webdrive main window - File - Program settings - Cache settings - Options

2. Tick "Multi user, validate cached files with server"

3. Set 'Cache recent file information in memory for' 15 seconds.

If you don’t apply these cache settings, WebDrive won’t notice that files are changed at the server, therefore the task of Robotask to watch folders for changes, won’t work.

Last comments:

· After you tested everything and all works, untick the 'Interact with desktop' option under Settings in FireDaemon for both WebDrive and RoboTask, so that those windows will disappear.
If you want to change any setting in either application, you need to tick "Interact with desktop again', after which the windows and settings become visible again. Remember that opening and using Webdrive and Robotask in the ordinary way won't affect the settings of those applications in FireDaemon, so only do it the way mentioned above.

· If you are feeling creative, you can try to make batch files of all procedures mentioned above. Some will be needed to ‘run as’ the background user account.

From: Orfeo <Orfeo1@gmail.com>Newsgroups: microsoft.public.sharepoint.portalserverSubject: Re: Solution: How to automatically move files in MOSS 2007 using Webdrive and Robotask (applies to Windows Server 2003 X64)
Date: Thu, 6 Dec 2007 09:28:48 -0800 (PST)

Custom Webpart Calendar - corporate calendar on intranet

OBTS — Sat, 21 Jul 2007 23:08:22 GMT

From: ".:J:." <jakobboyeratgmaildotcom>
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Custom Webpart Calendar - corporate calendar on intranet
Date: Mon, 02 Jul 2007 03:04:59 -0700

Hi there

I am searching for a weppart or some code for a custom webpart on my company intranet. The webpart must be able to suck up events from calendars below (hieararchy) the homepage. In other words, I'd like the webpart to grab the events from other Calendar/event lists below - in the same site.

I've got a newspart that can do this, but would like the calendar to do the same.

Anyone ever seen this, or got an idea of how to create such ?

Rgds
Jakob

http://www.boyer-draeby.dk

**************************************

From: "geavdotrodminatgmaildotcom"
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: Custom Webpart Calendar - corporate calendar on intranet
Date: Mon, 02 Jul 2007 20:25:14 -0700

Hi Jakob

Check out kwizcom Calendar Plus web part:
http://www.kwizcom.com

cheers
Geav

Posted using

Web Application No Page Found

OBTS — Sat, 21 Jul 2007 23:03:23 GMT

From:<AndyJones@discussions.microsoft.com>
Subject: Web Application No Page Found
Date: Thu, 28 Jun 2007 16:44:01 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

I have just installed SharePoint Server 2007 on W2K3 server with all the latest updates.

When I create a new web application with a site or without I cannot access the web page. I keep getting a page not found. It doesn't matter if I setup the pages at http or https. I can view the page if I goto IIS and click browse on the web page. I cannot view it from any clients or from the local host. This is also the only server in my deployment.

Does anyone have any idea on what would be causing this? Oh and the default web application and site that was created works fine.

Thanks in advance..

**************************************

From: "Daniel Bugday" <itkonsultatgmaildotcom>
Subject: Re: Web Application No Page Found
Date: Sat, 30 Jun 2007 12:08:59 +0200
Newsgroups: microsoft.public.sharepoint.portalserver

It looks to that it has to be with naming configuration because you say that you can access the site from IIS.

You could make sure that the web site is properly configured in IIS , (port number, address etc)

Then try ping the SharePoint site from a nother computer.. is this successful?

Then maybe the problem is with alternace access mappings in the central administration site-operation-alternace access mapping.

Configure alternate access mapping:
http://technet2.microsoft.com/Office/en-us/library/be9d31d2-b9cb-4442-bfc6-2adcdbff8fae1033.mspx?mfr=true

/Daniel Bugday

**************************************

From: <AndyJones
Subject: Re: Web Application No Page Found
Date: Sun, 1 Jul 2007 15:44:01 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

The alternate mappings fixed the issue. Thanks for the quick response.

Posted using

MOSS 2007 - Search

OBTS — Sat, 21 Jul 2007 22:51:25 GMT

From: "Horst Wutscher" <horst.wutscheratwebdotde>
Subject: MOSS 2007 - Search
Date: Wed, 27 Jun 2007 15:56:07 +0200
Newsgroups: microsoft.public.sharepoint.portalserver

Hello,
I have upload a Excel document wih the name - printerconfig.xls in a document library.

If i type in at MOSS 2007 search - printer, he didn't find the file.

If i type in config, he also didn't find the file.

If i type in .xls, he find the file.

I have tried Wildcards for example printer*, but he also didn't find the file!

Can somebody help me about this?

Thanks Horst

**************************************

From: jerome_vuibertatyahoodotfr
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: MOSS 2007 - Search
Date: Wed, 27 Jun 2007 07:59:42 -0700

Sharepoint search sucks, doesn't it.

But i have found a free edition of a product which permits wildcards in sharepoint server.

http://www.ontolica.com/Download.aspx

It is free but limited to wildcards.

Hope it will help you.

Posted using

Site Def

OBTS — Sat, 21 Jul 2007 22:46:00 GMT

From: Parthi
Subject: Site Def
Newsgroups: microsoft.public.sharepoint.portalserver
Date: Tue, 26 Jun 2007 10:59:00 -0700

Hi,
I added this part to MySiteDef that I created from STS Site def and it seems to work fine (please let me know if I am wrong). I did not create from BLANKINTERNET site def.

The only problem is that i have a default.aspx page in root (from STS site def), but the site gets redirected to pages/default.aspx as home page since it includes this publishing feature.

Other than that i have all the custom lists i added in MySiteDef available.

Am i missing some thing here??

**************************************

From: <bernadou discussions microsoft com>
Subject: RE: Site Def
Date: Tue, 26 Jun 2007 11:30:00 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

I haven't tried this, but, I suspect that is what you are looking for.

Good Luck. Let us know if it works!

Bernadou

**************************************

From: Parthi
Subject: RE: Site Def - bernado
Newsgroups: microsoft.public.sharepoint.portalserver
Date: Wed, 27 Jun 2007 11:13:49 -0700

Bernado,
It does work!! (Hopefully no hidden problems)

Newly created site out of this site def. has publising features, and also it has Basic Site Tempalate files. This is feature node i added in cofiguration section on onet.xml for a team site with some custom webparts in default.aspx

interesting this here is that since in specified "WelcomePageUrl" as a property, SharePoint did not create a default.aspx publishing page in "Pages" document library. It used the default.aspx created from Team Site as welcome page! All the default Lists and document libraries are created for publishing site, but nothing in them.

My default.aspx page (with my cusom webparts) from Team Site is now the default page for my site.(which is what i wanted). Great!!!

One more good thing here is that users can select only one site from Site Creation page from this current site and all its subsites.("AvailableWebTemplates" property). Again great !!!Now i also have the flexibiliy to do conditional site creation template to show for users for different sites (using "AvailableWebTemplates" property for different sites)!!

but now the problem for me is to restrict users from creating Meeting Workspace from Event list. Since the site is from "Team Site" site def., Meeting Workspace creation page shows all the out-of-box available WS sites.

Any one has any idea to go further from here?

Thanks
Parthi

**************************************

From: <bernadou
Subject: RE: Site Def - bernado
Date: Wed, 27 Jun 2007 15:16:02 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

Very cool. Glad that worked for you...

If I understand what you want to do, it seems like you now want to do this...

You can globally hide any site definition (but this will apply to all web apps on this box if you do this...) by setting the Hidden="False" property to true in the webtemp.xml file for the site def you want to hide.

So, MS owns certain things in the SP, and, they reserve the right to overwrite your changes if you decide you are going to mess with them when they release a service pack, so, I made a copy of the webtemp.xml file, called it webtemp-hide.xml and put it in the same directory ....12\TEMPLATE\1033\XML. I then changed the Hidden key to true (Hidden="True") for any site def I didn't want to be available ever (we have a fairly controlled environment).

You'd probably want to do this...
<Template Name="MPS" ID="2">
<Configuration ID="0" Title="Basic Meeting Workspace" Hidden="TRUE" ImageUrl="/_layouts/images/mwsprev.png" Description="A site to plan, organize, and capture the results of a meeting. It provides lists for managing the agenda, meeting attendees, and documents." DisplayCategory="Meetings" >
</Configuration>
</Template>

Good Luck!
B

**************************************

From: Parthi
Subject: RE: Site Def
Newsgroups: microsoft.public.sharepoint.portalserver
Date: Mon, 02 Jul 2007 08:38:47 -0700

Thanks for the suggestion, but i can not do that since we are in a shared environemnt. :(

I also noticed that even you restrict the available Work Space (Meeting) templates for subsites using "Page layouts and site templates", creating a Work Space from a Events list on the same site is not working."_layouts/templatepick.aspx" file that is used to display available WorkSpace template is not following the restriction set using "Page layouts and site templates"!!

This seems wrong though. Is this a know BUG?? Can you please give your insight on this??

Thanks
Parthi

Posted using

Sorting the default listing

OBTS — Sat, 21 Jul 2007 22:32:21 GMT

From: <Stephen discussions microsoft com>
Subject: Sorting the default listing SiteDirectory/Pages/categoryresults.as
Date: Tue, 26 Jun 2007 10:23:01 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

I have a site directory and the listing has been customized. I have added additional sorting criteria which can be clicked on after the initial load but i would like the first load of the list to be sorted by title.

I have tried editing the XSL with the editor and chaning the following in the correct locations but it is still not working.
     <xsl:param name="dvt_adhocmode">sort</xsl:param>
     <xsl:param name="dvt_sortfield">Title</xsl:param>
     <xsl:param name="dvt_sortdir">asc</xsl:param>

Any ideas?
Thank you ahead of time.
-Stephen

**************************************

From: <Stephen
Subject: RE: Sorting the default listing SiteDirectory/Pages/categoryresults.as
Date: Tue, 26 Jun 2007 11:07:04 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

I should also add when editing the webpart i only have the XSL editor and paramenters editor to modify the contents of the web part itself.

-Stephen

**************************************

From: <Stephen
Subject: RE: Sorting the default listing SiteDirectory/Pages/categoryresults.as
Date: Tue, 26 Jun 2007 11:24:01 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

Figured it out: Needed to add the following:

<xsl:sort select="@Title" order="ascending" />

into the area:

    <xsl:template name="dvt_1.body">
       <xsl:param name="Rows"/>
       <xsl:param name="FirstRow"/>
       <xsl:param name="LastRow"/>
       <xsl:for-each select="$Rows">

</...>

Posted using

SharedServices1 won't launch

OBTS — Sat, 21 Jul 2007 20:10:16 GMT

From: <MikeMcBride discussions microsoft com>
Subject: SharedServices1 won't launch
Date: Tue, 19 Jun 2007 16:34:51 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

I hope someone here can help a new SharePoint Admin. Today we had to replace the mother board on the HP server which hosts our SQL2005, SharePoint2007, Reporting Services and Integration Services.

The server came back online with no apparent problems, all of the SQL things run OK, Sharepoint Central Administration loads and shows all services running. However we cannot launch SharedServices1 from Central Administration or load either of the two SharePoint sites we've created.

I think I've done all of the usual things, stopped and started all of the services, IISRESET, checked the event logs for errors, checked in the IIS admin to make sure that the websites were running.

The only other thing we've done to the server was to apply the KB923028 Hot Fix yesterday which was suggested due to the event ID 6482 & 7076 errors we started seeing in the event log.

The SharePoint sites are not fully live yet so I can't say for sure that they were working yesterday after I did the Hot Fix. The first time I tried to load them was after bringing the server up following the replacement of the mother board this morning. That was when I discovered our current problem.

I guess my question is if either of these two things could have caused our sites to stop working? Does SharePoint look at the hardware level in some way for authentication? Has anyone else applied the KB923028 patch on their SP sites?

Any suggestions on things to try or to look at would be appreciated.
--

mike...

**************************************

From: "Corro'll Driskell" <cdriskellatkonzultzdotbiz>
Subject: Re: SharedServices1 won't launch
Date: Tue, 19 Jun 2007 22:58:58 -0400
Newsgroups: microsoft.public.sharepoint.portalserver

Mike, I would recommend taking a step back. I would restore to the point in time before the hot fix.

**************************************

From: MikeMcBride
Subject: Re: SharedServices1 won't launch
Date: Wed, 20 Jun 2007 09:31:01 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

Hi Corro'll,

Thank you for responding. We just tried removing the Hot Fix with no luck. Unfortunatly, since we were in the early stages of deploying SharePoint, any other restore point is before we installed the SP software. I'm hoping to avoid loosing about two weeks of effort spent building up our company's intranet to a point where we were within days of taking it live.
--

mike...

**************************************

From: amol <baviskardotamol gmaildotcom>
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: SharedServices1 won't launch
Date: Fri, 22 Jun 2007 09:50:36 -0700

Hey Mike,
Did you find solution to this problem. I am also facing same issue:

I have installed sharepoint 2007 in farm environment. In sharepoint central admin- Manage this farm services section, if I click on SharedServices1, I get error Page not found. Error details: HTTP Error 404: File or directory not found. To fix this problem, I added other SSP and created SharedServices2. Now when I click on SharedServices2, I get error 'the page cannot be found'.

I need this link working for configuring my excel services like adding trusted file locations.

Any help will be appreciated.

Thanks,
Amol

**************************************

From: MikeMcBride
Subject: Re: SharedServices1 won't launch
Date: Mon, 25 Jun 2007 12:52:00 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

Yes we did find the cause of our problem. It was in the DNS database. The server which hosts our SP site had to have its mother board replaced. When we rebooted the server, it was assigned a different IP address from the one listed in the DNS database. Once we corrected that everything worked as before.

In detail, what we did to make sure we didn't have a repeat of the problem was to make a permanent reservation in the DHCP database for the MAC address for the NIC in the server. That way when we reboot we will always have the same IP address on that machine. Then we created an "A" record in the DNS database for the IP address for the SharePoint sites we had deployed.

Good luck with your problem, I hope my suggestion can help you.

mike...
--

Posted using

Error: Records Center could not be found or accessed

OBTS — Sat, 21 Jul 2007 19:59:27 GMT

From: msulis <msulisatgmaildotcom>
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Error: Records Center could not be found or accessed
Date: Mon, 18 Jun 2007 15:46:26 -0700

I've got a MOSS 2007 document center and records center running on separate Sharepoint applications. When I attempt to send a record from a document library in the document center to the Records Center, I receive:

Error
The RC Records Center could not be found or accessed.

At that time, the system logs the following three entries in the sharepoint logs:

06/18/2007 15:34:55.11 w3wp.exe (0x0AA8)
0x0B84 Windows SharePoint Services    Topology
88gr Monitorable alternateUrl is null
06/18/2007 15:34:55.11 w3wp.exe (0x0AA8)
0x0B84 Windows SharePoint Services    Topology
88gs Monitorable hostHeaderSiteInfo is null
06/18/2007 15:34:55.15 w3wp.exe (0x02F0)
0x0194 Windows SharePoint Services    General
7022 Critical The RC Records Center could not be found or accessed.

Notes:
1. The Records Center URL displays the WSDL response as expected.
2. If I install a new site collection on the same application as the Document Center, and install a records center there, it works perfectly (after changing the Record Center URL, obviously).
3. I can't find anything regarding the "alternateURL is null" and "hostHeaderSiteInfo is null" messages, which I suspect might be a clue.

Any thoughts? I'm suspecting it's permissions-related, but all accounts running the application pools are highly privileged, at least until I figure out the problem.

Michael

**************************************

From: "Corro'll Driskell" <cdriskellatkonzultzdotbiz>
Subject: Re: Error: Records Center could not be found or accessed
Date: Tue, 19 Jun 2007 23:04:46 -0400
Newsgroups: microsoft.public.sharepoint.portalserver

Usually when you receive this type of error message, there is a problem with the configuration of the Record Centers URL. Or, the permission to send items to the record center are not configured. The permissions must be configured on the records center. It is located in the Permissions Management for the entire site.

**************************************

From: msulis
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: Error: Records Center could not be found or accessed
Date: Wed, 20 Jun 2007 18:22:37 -0000

Aha - that was it! I assumed that my authentication would pass across to the Records Center site, and so I was simply allowing *myself* permission to the records center.

But instead I needed to add the account under which the sending site's application pool was running, to the group "Records Center Web Service Submitters".

Seems pretty obvious in retrospect, but I was stuck. Thanks Corro'll for the help!

Posted using

SearchAlert in SharePoint 2007

OBTS — Sat, 21 Jul 2007 19:49:03 GMT

From: palwaipatgmaildotcom
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: SearchAlert in SharePoint 2007
Date: 25 May 2007 07:44:57 -0700

I want to create a SearchAlert in SharePoint 2007 using C# referencing Microsoft.Office.Server, Microsoft.Office.Server.Search and Microsoft.SharePoint dlls. I have used the following code to create one, which creates an alert but does not create in the right place. I mean it gets created in "Intranet > Site Settings > User Alerts". I want it to be created in "Intranet > Search > People and Groups > User Information > My Alerts on this Site".

I think I need to specify the "SearchCenter" web application but donot know where to specify it.

I have looked at the SharePoint table "SchedSubscriptions", it has a wrong value in WebId i.e has Intranet's WebId instead of SearchCenter, WebUrl is empty it should be "/SearchCenter", WebTitle is "Intranet" instead of "Search"

Below is the code -

SPSite spSite = new SPSite("http://localsite:11111");
Query alertQuery = new KeywordQuery(spSite);
alertQuery.QueryText = "test";

SearchAlert searchAlert = new SearchAlert(spSite,
alertQuery);
searchAlert.ChangeType = AlertChangeType.Discovered;
searchAlert.InnerAlert.AlertFrequency = SPAlertFrequency.Daily;
searchAlert.InnerAlert.EventType = SPEventType.Add;
searchAlert.InnerAlert.Title = "Test Search Alert2";
searchAlert.InnerAlert.User.Email = "myname@company.com";
searchAlert.InnerAlert.User.Name = "My Name";
searchAlert.Update();

Thanks
PR

**************************************

From: palwaip
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: SearchAlert in SharePoint 2007
Date: Thu, 05 Jul 2007 19:50:34 -0000

We found the issue with code. When searchAlert.InnerAlert.User.Email is set explicitly it treats it as a System Account and does not even get the initial notification email.

New code is
------------------

SPSite spSite = new SPSite("http://localsite:11111");
Query alertQuery = new KeywordQuery(spSite);
alertQuery.QueryText = "test";

SearchAlert searchAlert = new SearchAlert(spSite,
alertQuery);
searchAlert.ChangeType = AlertChangeType.Discovered;
searchAlert.InnerAlert.AlertFrequency = SPAlertFrequency.Daily;
searchAlert.InnerAlert.EventType = SPEventType.Add;
searchAlert.InnerAlert.Title = "Test Search Alert2";
searchAlert.InnerAlert.User = spSite.OpenWeb().Users["domain\
\userid"];
searchAlert.Update();

After using this code I got the initial notification email and then
later search alert email for the documents that were changed/added
etc..

Good luck,
PR

Posted using

Synchronising Sharepoint Folder With Offline Briefcase

OBTS — Sat, 21 Jul 2007 19:43:02 GMT

From: <SamWardill discussions microsoft com>
Subject: Synchronising Sharepoint Folder With Offline Briefcase
Date: Thu, 10 May 2007 06:06:02 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

Is there a good utility that you can use to syncronise a Sharepoint folder with an offline folder on a laptop

**************************************

From: "Daniel Bugday" <itkonsultatgmaildotcom>
Subject: Re: Synchronising Sharepoint Folder With Offline Briefcase
Date: Thu, 10 May 2007 15:54:45 +0200
Newsgroups: microsoft.public.sharepoint.portalserver

You could use Microsoft groove..

Check here for more info on groove:
http://office.microsoft.com/en-us/groove/HA101656331033.aspx

Also check this webcast
http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032327684&EventCategory=3&culture=en-US&CountryCode=US

/Daniel Bugday

**************************************

From: "S.S. Ahmed" <ss_ahmed1athotmaildotcom>
Subject: Re: Synchronising Sharepoint Folder With Offline Briefcase
Date: Thu, 10 May 2007 09:12:51 -0500
Newsgroups: microsoft.public.sharepoint.portalserver

You could also use Colligo Reader to synchronize files on your computer. There are a bunch of free tools (with code) on my blog that you can use to synchronize files. See uploading and downloading utilities on my blog.

Regards,

S.S. Ahmed
http://www.sharepointblogs.com/ssa

**************************************

From: <UriNissani discussions microsoft com>
Subject: RE: Synchronising Sharepoint Folder With Offline Briefcase
Date: Fri, 6 Jul 2007 08:32:06 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

hi... our solution does exactly that... :)

Hi,

please try our solution - ShareGO - offline sharepoint solution.

KWizCom ShareGo is a solution providing seamless integration between Microsoft SharePoint server and Microsoft Windows Desktop.

ShareGo enables you to keep working in your familiar Windows environment, and be always in sync with your corporate SharePoint server/s.

ShareGo - "SharePoint and Desktop Become OneTM"

This way, work with SharePoint is made much easier, and actually becomes the same as working in your windows desktop environment!

http://www.kwizcom.com/ProductPage.asp?ProductID=212&ProductSubNodeID=254

--
Uri Nissani
KWizCom Corp
http://www.kwizcom.com

Posted using

Yet another Authentication Question--Cerberus with one-head lopped off?

OBTS — Sat, 21 Jul 2007 19:33:38 GMT

From: <ShonMiles discussions microsoft com>
Subject: Authentication Question
Date: Tue, 10 Jul 2007 06:54:04 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

We are currently planning to migrate from SPPS 2003 to MOSS 2007. Right now we use two forms of authentication. One front-end server is running IWA and handles on the intranet requests, and the other server is configured for Basic using SSL andhandles all the Extranet requests. We ended up in this confiuration, working with Microsoft, because IIS 6.0 would not alow the users to not supply the domain information when logging in from the Internet, meaning they had to type DOMAIN\username in the username field. This was a mjor concern for our support staff, since every has already been logging in with just thier username and password for OWA since it was running basic with SSL.

So my questions is this? Am I still going to have to have two seperate front-end boxes to handle the two forms of authentication?

**************************************

From: "Daniel Bugday" <itkonsultatgmaildotcom>
Subject: Re: Authentication Question
Date: Tue, 10 Jul 2007 16:11:45 +0200
Newsgroups: microsoft.public.sharepoint.portalserver

In MOSS 2007 you could use one WFE with two forms of authentication.

Here is a link you can read for more info:

Defining multiple authentication providers to a single MOSS 2007 web application
http://www.sharepointblogs.com/andynoon/archive/2007/07/04/defining-multiple-authentication-providers-to-a-single-moss-2007-web-application.aspx

/Daniel Bugday

**************************************

From: ShonMiles
Subject: Re: Authentication Question
Date: Tue, 10 Jul 2007 08:04:04 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

Excellent, exactly what I was looking for.

Thanks!!

Posted using

How to make a global calendar - show events from a set of sites in

OBTS — Fri, 06 Jul 2007 23:18:18 GMT

From: <umit discussions microsoft com>
Subject: RE: How to make a global calendar - show events from a set of sites in
Date: Fri, 5 Jan 2007 10:47:00 -0800
Newsgroups: microsoft.public.sharepoint.portalserver

Could you find a solution to this question? I face with the same case, but don't know what to do!

Best,
Umit

**************************************

From: <RobertWCrouch discussions microsoft com>
Subject: RE: How to make a global calendar - show events from a set of site
Date: Mon, 19 Feb 2007 06:40:13 -0800
Newsgroups: microsoft.public.sharepoint.portalserver

You can use the Content Query Web part to rollup calendar items (see below)...

http://www.microsoft.com/belux/msdn/nl/community/columns/stevenvandecraen/contentquerywebpart.mspx

http://msdn2.microsoft.com/en-us/library/ms497457.aspx

http://msdn2.microsoft.com/en-us/library/aa981241.aspx

BUT...

I need help putting all of this information together so that I can format the result of the list so that it makes sense for calendar items (i.e. Title, Description, Start, End, Location). I have not found an example of anyone that has done this.

I would like to group by Date, then display start time, title, description location...

February 19, 2007

Meeting One Title
This is the description of the first meeting of the night.
7:00 PM at 123 Location Street

Meeting Two Title
This is the description of the second meeting of the night.
9:00 PM at 456 Location Street

February 20, 2007

Meeting Three Title
This is the description of the first meeting of the night.
8:00 PM at 789 Location Street

Anyone have thoughts?

**************************************

From: <GodzillaBorland discussions microsoft com>
Subject: RE: How to make a global calendar - show events from a set of site
Date: Thu, 15 Mar 2007 14:58:05 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

I have the same need - for a global calendar with events from sub-sites. I created a new site column "roll-up" with a Yes/No to mark events that will be rolled-up to the 'global' calendar.

But I am stuck there. There are articles on CQWP but I need more specifics such as how to add the start date to the CQWP list - it only shows the 'Title'

regards

**************************************

From: "Mike McNett" <michaeldotmcnettatusmadotedu>
Subject: Re: How to make a global calendar - show events from a set of site
Date: Wed, 16 May 2007 20:11:20 -0400
Newsgroups: microsoft.public.sharepoint.portalserver

I have a similar issue, but I am using WSS 3.0. I want each sub-site to have its own calendar, but then allow a view of all sub-site calendar events on the "global" calendar as well. So while the solution using Sharepoint 2007 sounds great, what are the options for WSS3.0?

Thanks in advance.

Mike
michael.mcnett@usma.edu

**************************************

From: "Mike Walsh" <englantilainenathotmaildotcom>
Followup-To: microsoft.public.sharepoint.setup_and_administration
Subject: Re: How to make a global calendar - show events from a set of site
Date: Thu, 17 May 2007 10:03:09 +0300
Newsgroups: microsoft.public.sharepoint.portalserver

CorasWorks used to have cross-site list consolidation in their suite of programs for WSS 2.0 (and SPS 2003) and I presume this is still available in their present suite for the v3 SharePoint products. The suite of course costs quite a bit but it's less than MOSS 2007.

Mike Walsh
WSS FAQ http://www.wssfaq.com
No private e-mail please.

**************************************

From: <UriNissani discussions microsoft com>
Subject: RE: How to make a global calendar - show events from a set of sites in
Date: Fri, 6 Jul 2007 06:54:01 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

Hi,

We have a solution for that - KWizCom Calendar web part - Calendar Plus it can do what you need -

Support both MOSS 2007/WSS 3.0 and SPS 2003/WSS 2.0
Support resizing the calendar to fit your web page's design
Aggregate events from multiple SharePoint sites
Connect to any required list type (not only "Events")
Support viewing data from the user's Outlook calendar
Support viewing Microsoft Outlook shared calendars
Aggregate data from any legacy application
Event coloring according to event source
Event coloring according to event type
Support list views - enabling you to aggregate list items defined by custom SharePoint list views

Printable calendar
Support dynamic URL tokens ï¿½ tokens such as [current site] enable you to use the CalendarPlus web part in a site template using relative URL, eliminating the need to configure the web part after a site is created

No client installation needed ï¿½ fast & easy deployment
Dynamic generated background colors for aggregated list levels
Asynchronous calendar loading
Support different user credentials for SharePoint and Exchange server
Multi-lingual

Product page -
http://www.kwizcom.com/ProductPage.asp?ProductID=175&ProductSubNodeID=176

thanks

Uri
--
Uri Nissani
KWizCom Corp
http://www.kwizcom.com

Posted using

Sent To Link Does not Work

OBTS — Wed, 04 Jul 2007 23:13:41 GMT

From: Jerry <yasirdotattiqatgmailtodcom>
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Sent To Link Does not Work
Date: Tue, 12 Jun 2007 06:25:12 -0700

Hi,

When I use Send To -> Email a Link in SharePoint Server 2007 Document Libary for a specific File and copy the link in the email. The link does not open and clicking on it does nothing. Please help.

Jerry

**************************************

From: <Dan discussions microsoft com>
Subject: RE: Sent To Link Does not Work
Date: Fri, 22 Jun 2007 10:15:00 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

Hi Jerry,

I am seeing the same thing. I am not yet sure of the cause.

**************************************

From: Jerry
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: Sent To Link Does not Work
Date: Wed, 27 Jun 2007 10:19:00 -0000

Dan,

I figured out the root cause. This is due to the URL Encoding in SharePoint 2007. I am sure your site url will be something like this myporta-subport.company.com. This is where problem begings. Url enocder encodes the - to %2e or something and when you click on this it does not have effect. But if you copy and paste the link to IE it will work. The file where this thing is resolve is Core.JS so if you are looking to correct this sit back and read the file.

Jerry

**************************************

From: Dan
Subject: Re: Sent To Link Does not Work
Date: Wed, 27 Jun 2007 04:36:00 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

Found the same thing -

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1440003&SiteID=1

"
Here's how you fix it:

in core.js and ows.js find this string:

fileUrl=escapeProperly(httpRootWithSlash.substr(0, slashLoc))+currentItemUrl;

and replace it (or comment it out with //) with this one:

fileUrl=httpRootWithSlash.substr(0, slashLoc)+currentItemUrl;
"

Posted using

Questions on MOSS 2007

OBTS — Wed, 04 Jul 2007 23:04:21 GMT

From: "Jason W." <jasonwilliams74atgmaildotcom>
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Questions on MOSS 2007
Date: Mon, 11 Jun 2007 20:42:08 -0000

I hope I am in the right place. :)

We are thinking of rolling out MOSS 2007 for our company for group collaboration, share documents etc. I have a good feeling that if and when we do roll this out, other departments will want access to it as well.

Ok. So I have downloaded the trial, done a few test installs and run throughs and have the actual install of MOSS down pretty well.

My real question is configuring Sharepoint AFTER install.

Here is where I am a little confused.

1. Creating a New Web Application

2. Creating a New SSP

3. Creating a new Site collection

Since we are testing this in our IT department right now, so if I wanted to create say:

http://itportal.mycompany.com

Ok...I think I get confused with the difference between "New Web Application" and "New Site Collection".

What is the difference? Which of the two would give me: http://itportal.mycompany.com

Just trying to understand the differences.
Might have to go and buy a book on Sharepoint. :)

I really appreciate the help.

Jason

**************************************

From: "Daniel Bugday" <itkonsultatgmaildotcom>
Subject: Re: Questions on MOSS 2007
Date: Mon, 11 Jun 2007 22:56:15 +0200
Newsgroups: microsoft.public.sharepoint.portalserver

Hi Jason,
I will try to explain this for you:

In Sharepoint 2007 (MOSS and WSS) we have something that is called web application. This is actually an IIS web site.

Then you need to create at least one site collection in that sharepoint web application to hold content. This is a virtual directory in IIS.

Then you can create sub-sites in that site collection or sites in new top site collection depending on your need for that site.

So what you really need to create http://itportal.mycompany.com is a Web application (Sharepoint) and a site collection in that Web application to hold content.

Follow this links for more info:

Create or extend Web applications:
http://technet2.microsoft.com/Office/en-us/library/5ed10d1c-ffdf-4651-b7b6-cac1de6f9ee11033.mspx?mfr=true

Create a site collection:
http://technet2.microsoft.com/Office/en-us/library/5ed10d1c-ffdf-4651-b7b6-cac1de6f9ee11033.mspx?mfr=true

Hope this helps!

/Daniel Bugday

**************************************

From: "Jason W."
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: Questions on MOSS 2007
Date: Mon, 11 Jun 2007 21:05:53 -0000

Thanks Daniel.
That makes sense.

Guess I was just a little confused on how sharepoint addressed things. Also, I was a little confused on the SSP and MySite 'URLs' for management and how they are created (still getting used to it).

Is there by chance a example setup and walkthrough of a web application, SSP and site collection?

Thanks.

Jason

**************************************

From: "Jason W."
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: Questions on MOSS 2007
Date: Mon, 11 Jun 2007 21:28:18 -0000

If I can ask one more question:

I was playing around in CA. I created a new "web application."

I gave it a description: My Company IT Portal
Port 80
Host header: itportal.mycompany.com
Kept everything else pretty much default, but entered the account for the application pool.

Simple enough.

Now, I went to create a SSP (first creation of SSP).

I selected the web application I just made.

The SSP Admin link was: http://itportal.mycompany.com/ssp/admin

Under My Site location:
My site location url: http://itportal.mycompany.com
Relative URL: I added /mysites

Added the service account and then clicked ok. When I do that, i get this message:

WARNING:

SSP Administration site and My Sites on the same Web application. We recommend using different web applications to host the SSP administration site and My sites, so you can backup and restore my sites independetly.

Click CANCEL to go back. Click OK to proceed.

So it really makes sense what they are saying. My main question is, do I create a Web Application for just SSP Administration? If so, is their a naming convention that is recommended?

Something like:

/ssp/admin">http://<servername>/ssp/admin

Thanks.

Jason

[One hour later...]

Nevermind.

I think I figured it out. :)

Still playing with it. this is a lot of new information and I need some time to get my feet wet.

Don't worry. I will be back with more questions. :)

Posted using

MOSS: attach bare content database from other MOSS server Opties

OBTS — Wed, 04 Jul 2007 22:50:58 GMT

From: Orfeo <Orfeo1atgmaildotcom>
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Repost: MOSS: attach bare content database from other MOSS server Opties
Date: Mon, 11 Jun 2007 01:07:02 -0700

I need to open a site collection of another MOSS server (which is no more and had another server name) of which I only have the content and config databases and logs. What is the scenario if I want to attach this database to another MOSS server?

Do I need to first create an empty application or do I have to rename the database of a newly created site collection database?

Anyone, please provide step-by-step guidance

Thank you very much

Orfeo

**************************************

From: "John Timney $MVP$" <x_johnattimneydoteclipsetodcottodduk>
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: Repost: MOSS: attach bare content database from other MOSS server Opties
Date: Mon, 11 Jun 2007 09:32:24 +0100

You should be able to follow the steps outlined here

http://technet2.microsoft.com/windowsserver/WSS/en/library/03c94172-a203-4d47-bf9f-239bb6647aa61033.mspx?mfr=true

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog

**************************************

From: Orfeo
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: Repost: MOSS: attach bare content database from other MOSS server Opties
Date: Thu, 14 Jun 2007 12:04:05 -0700

Thank you.

But that link concerns (as I understand) migration of content databases from servers with the same servername, like a backup-restore operation.

My problem is that I need to attach the content database to a differnt server with a differnt name.

Any thoughts?

**************************************

From: "John Timney $MVP$"
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: Repost: MOSS: attach bare content database from other MOSS server Opties
Date: Thu, 14 Jun 2007 21:05:23 +0100

I've not tried it with a different server name but moving a content database which is really all your doing should be relatively stratightforward. Load it into SQL server first and then attach it using stsadm and the addcontentdb command line option.

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog

**************************************

From: Orfeo
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: Repost: MOSS: attach bare content database from other MOSS server Opties
Date: Sat, 16 Jun 2007 05:01:55 -0700

I managed to attach the db and open the site collection by using a virtual server with the same name. I didn bither anymore about other server name.

The only thing is that I first had to:
1. Attach the db in SQLserver (i.e. in Management Studio)
2. In Cenral Admin create a new web application with the exact same settings as the old one,
3. after that delete the empty content db and add the full content db (still in Central Admin).

This upgraded the db automatically.

Posted using

Photo Gallery

OBTS — Sat, 26 May 2007 20:29:31 GMT

From: Rosalie <rdmacdonald athotmaildotcom>
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Photo Gallery
Date: 22 May 2007 11:54:10 -0700

Can anyone recommend a cheap photo viewer web part for Sharepoint 2007? We have a bunch of company photos we want to post but the out of the box functionality in MOSS is pretty dismal. We'd rather move on to our main development and just buy a quick and cheap solution.

Thanks,
Rosalie

**************************************

From: "John Timney $MVP$"
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: Photo Gallery
Date: Wed, 23 May 2007 17:33:39 +0100

Try using an existing application

http://cutesoft.net/ASP.NET+Image+Gallery/default.aspx

and hosting it sharepoint using smartpart

http://www.smartpart.info/default.aspx

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog

Posted using

How can I see which users are logging on to the site?

OBTS — Sat, 26 May 2007 20:25:50 GMT

From: <Laura discussions microsoft com>
Subject: How can I see which users are logging on to the site?
Date: Tue, 22 May 2007 07:27:00 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

I need to verify which users have logged on to a particular site. Is there a way of doing this in SharePoint? It would also be helpful if I could see how long they were there. I've looked over Central Administration, but cannot find anything helpful.

--
~Laura

**************************************

From: euan.gamble atobsdotcomtodau
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: How can I see which users are logging on to the site?
Date: 22 May 2007 16:23:22 -0700

Hi Laura,

Have you tried the audit log feature? Mark Harrison has a some info on auditing over at http://markharrison.co.uk/blog/2006/07/sharepoint-auditing.htm

You can audit on the entire site collection or down to a site and list which is very helpful. It outputs the information in to excel which is good for further analysis. Have a look at the second worksheet on the audit report.

Regards,
Euan Gamble

**************************************

From: <Laura
Subject: Re: How can I see which users are logging on to the site?
Date: Wed, 23 May 2007 08:48:02 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

Yes! This was great! Thanks for connecting me with this resource!

--
~Laura

Posted using

Gantt Time Scale

OBTS — Sat, 26 May 2007 20:20:50 GMT

From: <Jim discussions microsoft com>
Subject: Gantt Time Scale
Date: Mon, 21 May 2007 09:22:02 -0700
Newsgroups: microsoft.public.sharepoint.portalserver

I am working with a Gantt view and would like to change the timescale - is that possible?

**************************************

From: pentalogic atgmaildotcom
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: Gantt Time Scale
Date: 22 May 2007 06:24:51 -0700

Hi Jim,

If you want more control over the display than is provided by the built in Gantt chart view then you might want to check out some 3rd party web parts such as (shameless plug!) my own companies SharePoint Planner

http://www.pentalogic.net/SharePointPlanner/default.aspx

Regards...Ryan

Posted using

SharePoint 2007 architecture ??

OBTS — Sat, 26 May 2007 20:15:54 GMT

From: Frank <flefe2000 atgmaildotcom>
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: SharePoint 2007 architecture ??
Date: 18 May 2007 06:38:04 -0700

Hi All ...

I have a question regarding the architecture of SharePoint 2007 ...

If I need to upload a document in my site it is pretty easy ..."Upload documents" or "Multiple Documents" ... Where are those documents are stored ? ... (I'm not the one who installed SharePoint) ...

Now if I'm receiving a document by e-mail I need to save it somewhere, then go in my site and upload the document ... Is there a faster way ... like mapping a drive where the documents are stored ???

Thanks
Frank "the newbies"

**************************************

From: piersonal <piers.butler@silverbug.com>
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: SharePoint 2007 architecture ??
Date: 21 May 2007 09:49:08 -0700

As far as I am aware:
1) documents saved to SharePoint are saved within the SharePoint SQL database.
2) if you configure your document libraries with an email address, you can then send / forward the documents directly and the documents will save to those libraries

Piers

**************************************

From: euan.gamble atobsdotcomtodau
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: SharePoint 2007 architecture ??
Date: 22 May 2007 04:20:58 -0700

Thats correct. The content is saved in to the sharepoint content database in SQL. If you are saving a document for personal use (i.e. not collaborating on it) it would be best to save it in your 'my site'.

If you want a quick and easy way to save documents in to your 'my site' document library you can under 'Actions' use the 'open with windows explorer' and map a drive to that path. Its a very good option for migrating people from file shares to sharepoint.

Regards,
Euan Gamble

**************************************

From: Frank
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: SharePoint 2007 architecture ??
Date: 22 May 2007 05:43:53 -0700

Thanks guys for those tips ... I mapped a drive and my users are very happy ... With your help I looked like a billiant guy ... ;-)

Frank

**************************************

From: SmartbizAustralia <tom atsmartbizdotcomtodau>
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: SharePoint 2007 architecture ??
Date: 23 May 2007 04:44:34 -0700

Have you tried the WISDOM Message tool for saving messages and/or attachments to SharePoint. The advantage is that you can save these to any doc library by browsing which is different to mapping just one location.

There is also WISDOM explorer which is great for saving any doco or file to any library in any site that you have rights to..

Tom Bizannes

Try:
http://www.macroview.com.au/WisdomMessage.htm

Posted using

Using list from a top level site in the subsite

OBTS — Sat, 26 May 2007 20:02:17 GMT

From: CathyCarterPrice atgmaildotcom
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Using list from a top level site in the subsite
Date: 17 May 2007 06:24:53 -0700

Hi,

We are building team sites but we need to be able to pull info from a list on the top level site. Just as an example I am on the web team and I have to enter my applications that I have developed but I have to link each application to a sever that is on a list in the top level site. So I would have a lookup column that needs to pull a field from the server list that is located on the top level site. What would be even better is to be able to pull across sites. I have written some event based code, but that seems clunky and I was hoping for an out of the box solution. Does anyone know if there is a way to do this? I know there have been similar questions asked, hopefully I didn't miss the answer when looking.

Thanks in Advance,
Cathy

************

Sorry forgot to say I am currently working with WSS 3.0 and we are getting our server license to upgrade shortly to MOSS. So if it can be done in either version I would be interested in knowing how.

Thanks!

**************************************

From: "Mike Walsh" <englantilainen athotmaildotcom>
Subject: Re: Using list from a top level site in the subsite
Date: Thu, 17 May 2007 21:24:37 +0300
Newsgroups: microsoft.public.sharepoint.portalserver

This blog item

http://www.sharepointblogs.com/agoodwin/archive/2007/04/21/how-to-create-cross-site-list-lookups-in-moss-wss-3-0.aspx

seems to indicate that the proposed method in it would work for both MOSS and WSS.

(I've not done it myself)

Mike Walsh
WSS FAQ http://www.wssfaq.com
No private e-mail please.

*************

There's also a free "Cross-Site Lookup Column Add-On for WSS v3" (free - SharePoint Solutions) which requires registration,

You'll find it here.

http://sharepointsolutions.blogspot.com/2006/11/free-custom-cross-site-lookup-column.html

Mike Walsh
WSS FAQ http://www.wssfaq.com
No private e-mail please.

**************************************

From: piersonal <piers.butler atsilverbugdotcom>
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: Using list from a top level site in the subsite
Date: 18 May 2007 05:39:10 -0700

Hi Cathy - I have a subsite that uses a Filter Web Part to provide users with a list of companies sourced from a Customer List that is saved on the parent site. This in turn filters the site for documents linked to that customer (hope that makes sense!). Is this the sort of thing that you want to do?

**************************************

From: CathyCarterPrice
Newsgroups: microsoft.public.sharepoint.portalserver
Subject: Re: Using list from a top level site in the subsite
Date: 21 May 2007 09:58:48 -0700

Thanks everyone for the responses.

This is sorta what I want to do, but I can use either method Mike replied with to do what I need. They both work. With the add in I can also have lookups between subsites too. It works really well. I am amazed at how easy to set up a custom column also. Thanks again for all the replies, I really appreciate it. - cathy

Posted using