I fully agree on the documentation. But then again it seems that no developer ever offers enough documentation and if they do the quality is poorly lacking good examples or is poorly written.
Will you be posting your theme for others to use?
I just noticed after browsing around a bit, that the nav bar at the top uses the I-Bar cursor instead of the standard link finger pointer cursors. Bug or design?
One more fix for you. ;-)
rockstarguys.com/.../default.aspx if you look your footer for each item is not drawing in the correct position when there is a number of tags.
Thanks Mark! I'll take care of those this weekend along with a few other adds. The theme was adapted from Styleshout (www.styleshout.com/.../index.html). One of the adds I need to drop in is the credit back to them. :) For the rest of the stuff I'm thinking about writing up some smaller posts to talk about integrating upcoming.org/del.icio.us, creative use of Community Server lists, and such. I think that is more useful than just posting the entire theme. That way others can repurpose the smaller bits in their own designs.
Great ideas Colin. As you mention the CS product has such huge potential, but lacks in documentation. Breaking down how you went about creating your theme would be great. I'll look forward to checking it out.
Hi there, Up in Redmond last week attending the Commerce Server 2007 bootcamp I told Max that would be
Pingback from Community Server Byte for June 21, 2007 - Dave Burke
Community Server is great, however, you can still see traces of applications that were pulled together with some folder names in lower case and other's in Sentence case. Obviously this is minor, but it all contributes toward the overall perception of a finely integrated suite.
Amen.
TinyMCE has some built-in support for reprocessing browser-generated markup, but it runs client-side and is very slow on large documents.
CS2007 can be configured via the HtmlScrubber and HtmlNestingCorrectionModule to do much of the same processing server-side (catching both TinyMCE and WLW issues).
I have the configuration for HtmlScrubber that validates XHTML tags/attributes -- I'll probably be blogging about it soon. Or contact me and I'll send you the config.
I'm still waiting for a killer editor that doesn't require a browser plugin and produces usable XHTML.
John -- I totally agree. Half of the time I've spent so far working on my theme submission for the contest is doing some clean up on file casing, formatting, file locations, etc. Beyond Community Server I'm not sure why all developers don't leverage Source Code Formatting in the IDE (albeit they didn't include it in VWD Express or Expression Web which I can't understand). It works wonders and takes two seconds.
Pingback from An articulate description of his overall first impressions of CS2007 - Dave Burke's Community Server Bits
It seems the punch line is that everything shipped pre-maturely in this last round. Whether it's
Hi Collin,
I have added a base property VAT(value added tax) using Catalog and Inventory schema manager, which I should add or subtract according to shipping address selected(country). So what should I do. I know how to add a component. But tell me where should i add the component in Total pipeline(i think i should add it here). what should be the code in execute(). And wether I can get the value of VAT in the pipeline
In your code samples above
1. How you are using "OrderForm orderForm = new OrderForm((IDictionary)pdispOrder); " Its giving me an error saying the constructor accepts only string.
2. How you are using "OrderAddress shippingAddress = orderForm.Addresses[lineItem.ShippingAddressId];" when its not at all showing Addresses[""] after typing "orderFrom."
And how I will get the property "VAT" in similar way.
Please help me, and thanks in advance.
The last regex is buggy, "[0xA-Fa-f0-9]{3,10}" not only accepts hex numbers, for example: ffx
i dont know any thing in windows mobile,how to get start with programs , run and all .so help me how to start with the basic of windows mobile
TITLE: Microsoft Report Designer
------------------------------
An error occurred while executing the query.
Failed to execute web request for the specified URL.
ADDITIONAL INFORMATION:
Failed to execute web request for the specified URL. (Microsoft.ReportingServices.DataExtensions)
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="schemas.xmlsoap.org/.../" xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:xsd="www.w3.org/.../XMLSchema">
<soap:Body>
<soap:Fault>
<faultcode>soap:Server</faultcode>
<faultstring>Exception of type Microsoft.SharePoint.SoapServer.SoapServerException was thrown.</faultstring>
<detail>
<errorstring xmlns="schemas.microsoft.com/.../">Value does not fall within the expected range.</errorstring>
</detail>
</soap:Fault>
</soap:Body>
</soap:Envelope>
BUTTONS:
OK
Hi
When I tried the following code for getting Listitems I am getting
"There is an error in the query. Failed to execute web request for the specified URL."
Error.
Please suggest....
---------------------------
<Query>
<Method Namespace="schemas.microsoft.com/.../soap" Name="GetListItems"/>
<SoapAction>schemas.microsoft.com/.../SoapAction>
<Parameters>
<Parameter Name="listName ">
<DefaultValue>/</DefaultValue>
</Parameter>
<Parameter Name="viewName ">
<Parameter Name="query ">
<Parameter Name="viewFields ">
<Parameter Name="rowLimit ">
<Parameter Name="queryOptions ">
</Parameters>
</Query>
Moojjoo - There is something about your query it doesn't like. It's hard to tell without more information. I would recommend using Fiddler (www.fiddlertool.com) as a proxy to see what the conversation looks like. If you can provide more information on the query I might be able to help further.
Kiran - You need to provide the parameters in the parameter tab per my post.
mNiko - Did you reboot after installing the Virtual Machine Network driver? I've seen some oddities like that.
mtux - The problem with that line of thinking is that the mobile web requires a fundamentally different way of thinking when it comes to user experience. I prefer to keep mobile projects separate and distinct from the core web stuff.
prabhta - Start here: msdn.microsoft.com/windowsmobile
OC - It really depends on your tax situation. We use a tax schedule which takes the IsTaxable flag to another level by factoring in the customer's location as well.
Minah - The OrderForm class is a custom wrapper class. It is likely you are missing a support file from my sample. Likewise for the OrderAddress class.
You've been kicked (a good thing) - Trackback from DotNetKicks.com
I fully agree. The documentation is bad and there are (almost) no good simple samples or jump-start tutorials. A frustrating experience, especially for people who want to start learning it but don't even know what to start with.
P.S. Do you know of any SharePoint sample source on the web? Let alone sample websites running SharePoint?
There are sites running WSS/MOSS on the external side. See www.wssdemo.com/.../websites.aspx for a small list. I suspect that some of them are receiving support through Premier / Partner contracts that have escalation points. As an average joe user out there we are getting the standard level of support with two day callbacks. The sites look great, but that is partly having great graphics designers. My beef is that the documentation and support isn't inline with a product that you might want to come to depend on, especially as a small to mid-sized business.
You have spaces after the end of the parameter names. Remove those and it should work
Can i connect a workflow to pipeline?
Or invoke windows workflow after pipeline
Technically you could connect it to Windows Workflow. We're in the midst of dumping the pipeline system in favour of Windows Workflow. The debugging of a fully managed system alone makes it easier. From what I understand we will likely see full WF implementation in the next Commerce Server release. I suspect that won't see the light of day though for another 24 months.
Thanks for that Colin,
Now I am getting results from SharepointLists. It shows in data tab but when I hit preview I am getting an error which says "Root element is missing"
I have added those 6 parameters as report parameters and assigning them to dataset.
I have also added <?xml version="1.0" encoding="utf-8" ?> tag to query
like <?xml version="1.0" encoding="utf-8" ?>
<Method Namespace="schemas.microsoft.com/.../" Name="GetListItems"/>
But I am still getting that error...
<errorstring xmlns="schemas.microsoft.com/.../">The root element is missing</errorstring>
Thanks
using that conn string:
SqlConnection conn = new SqlConnection(connstr);
won't execute! it says:
Keyword not supported: 'provider'.
I'm not using Enterprise Library, what do i do?
Oh. I guess you have to use OleDbConnection. Weird.
The Provider tag in the connection string is the key differentiator that will tell you that you need to use an OLE DB connection. OLE DB supports numerous connections (Excel, SQL, text files, Oracle, etc...). The Provider keyword tells the stack what connection class to use. We're all SQL here so we've done some SQL-specific calls. I might not have included the snippet that shows the code stripping the Provider key/value pair off the connection string in this case.
Thanks for the info, and great article :)
Thanks for publishing this article. Saved me quite a bit of time. Kiran , what you need to do is add another parameter called webID to the list . This is not documented in the MOSS SDK.Before going further I would like to mention that you can parse lists as well as document libraries in MOSS using the lists webservice. This is not documented and I had heaps of trouble figuring it out , quite silly considering that there is a picture library web service but not one for document library. Anyways I'll stop winging and share my learnings .
As a general approach to creating SSRS 2005 reports based on MOSS webservices( I write this after spending the whole of today doing this and this approach works for me ). I assume basic familiarity with SSRS , webservices and MOSS
1. Download fiddler from the link provided by the author of this article and install it
2. Create your datasource by pointing to the target webservice path which will be sharepointsite/.../webservicename.asmx. Use integrated authentication
3. Browse to the asmx file in your browser and click on the required method. Look at the soap 1.1 request definition . This willl give you the required parameters as well as the schema. Create your query in the following format
<Method Namespace="schemas.microsoft.com/.../" Name="Method name"/>
Both the namespace as well as the soapaction can be seen from the asmx method definiton ( point 3 above)
4. Define the parameters in the same case as defined in the asmx method definition , making sure there are NO BLANK SPACES after or before the parameter names.
Some of these parameters are optional and hence do not need a value, I have been using SOAP UI ( a free tool ,google it ) for finding the optional parameters
5. Run your report and give values for the list name and other non optional parameters .
6. With every report request open fiddler , locate the request and double click on it to see the soap request being sent . Match this request to the method definition from step 3 above . If there are ANY differences , a space, a comma, a difference in case... youll get an error. Another strange thing is that in VS 2005, the parameters seem to keep disappearing so check that periodically .
Best of luck.
Thanks for posting this!
I had nearly the same requirement and this does the trick.
SQLServer2005ReportingServices与MOSS2007集成，使用SSRS制作报表，在MOSS中显示。
AccessingSharePointListIt...
Thanks mate, this article saved a lot of hassle.
Cheers,
Prak.
Could you do this in a pipeline component?
Pingback from Alias » Retrieving the Current User's Active Directory Object
Hi, Thanx, used this instead to get the result, worked fine. But remember to set security permissions on the stored procedure on the SQL server.
string TransactionsConnectionString = "server=myitsql01;database=startersite_transactions;Trusted_Connection=yes";
SqlConnection connection = new SqlConnection(TransactionsConnectionString);
connection.Open();
SqlCommand command = new SqlCommand("RetrieveNextTrackingNumber", connection);
command.CommandType = CommandType.StoredProcedure;
string OrderNO = Convert.ToString(command.ExecuteScalar());
connection.Close();
Andreas - You can certainly use straight ADO.NET. The Enterprise Library is just a wrapper for that. As for using a pipeline question, yes you should be able to do it inside the pipeline.
Pingback from account » Blog Archive » Retrieving the Current User's Active Directory Object
I am passing in the following query for the GetListItems (I've already checked and my DataSource works fine with other parameters).
<Method Namespace="schemas.microsoft.com/.../soap"">schemas.microsoft.com/.../" Name="GetListItems"/>
<SoapAction>schemas.microsoft.com/.../soapGetListItems</SoapAction>">schemas.microsoft.com/.../SoapAction>
<Parameter Name="listName"><DefaultValue></DefaultValue></Parameter>
<Parameter Name="viewName"><DefaultValue></DefaultValue></Parameter>
<Parameter Name="query"><DefaultValue></DefaultValue></Parameter>
<Parameter Name="viewFields"><DefaultValue></DefaultValue></Parameter>
<Parameter Name="rowLimit"><DefaultValue></DefaultValue></Parameter>
<Parameter Name="queryOptions"><DefaultValue></DefaultValue></Parameter>
<Parameter Name="webID"><DefaultValue></DefaultValue></Parameter>
I am getting the following error message back (through fiddler):
errorstring [ xmlns=schemas.microsoft.com/.../soap ]
Value does not fall within the expected range.
Any ideas ?
Colin, this is great!! Exactly what I am looking for. Thanks a lot!
MKeeper
I am not sure how you are setting the listname parameter in your query . I am guessing that the list name is going in as null which is the default value. If you are using the report designer in VS then I would suggest you remove the param definition from your query and place it in the parameter tab for the dataset. Set it up with your list name as the default hardcoded value. Or try by changing your
to
<Parameter Name="listName"><Your list name></Parameter>
Cheers
Shai
I'm looking for a way to update some of the items in my inventory list on WSS3 from Powershell. For example, run a WMI query to determine the IP address of a server and place the result to the IP field of the list:
Server Name: IP Address : CPU Speed:
TestServ : 192.168.0.200 : 6GHz
I got some basic ideas from
www.u2u.info/.../Post.aspx
but can't really put the whole thing together. is it even possible to do?
Aside from the fact that the CleanAppName function is missing from your script it is otherwise interesting. thanks
There is a multitude of blogs that discuss how to access SharePoint data from SQL Reporting Services
Hi Colin,
Just thought I'd point out that, for some reason, the images are not showing up in this post.
Regards,
Wade
What is the status of the case? I'm having the same problem.
I'm hearing a "loose timeframe" of January now. If you can open a PSS case and link to SRZ070803000378 it might add some pressure to get them to tigthen up that timeline. The call should be free as this is a bug on their end (it is for our case).
The Configuration of Commerce Server is stored in SQL Server database using Configuration APIs to manage
Pingback from MSDN Blog Postings » Rub a dub dub, a PUP in my tub Part I!
New post at rockstarguys.com
What I would like someone to formally document is the exact effect of setting a port range for RPC. Let's say I set up a range of 20 ports, and they're all in use. What happens when request 21 comes along? Most apps aren't expecting their RPC's to fail. Granted, they should handle it gracefully, but they're pretty used to it just working.
@johnw - You nailed it on the head. Developers need to assume that remote resources may not be available and handle those failures in the proper fashion. From the user's end if they haven't handled it or just passed the error on up the stack you get the "There are no more endpoints available from the endpoint mapper" message from APIs. RPCDump from the Windows Server 2003 Resource Kit tools is pretty useful if you want to see which RPC endpoints are in use and the ports to which they are allocated. It will give you a breakdown grouped by protocol so you can deal accordingly. As sysadmins we need to understand the message, and to do that we need to understand a bit about how it works which is why I decided to write this post.
Bron: webwereld.nl IBM zet de aanval in op Microsoft via het MKB. Het MKB is typisch een marktsegment
Pingback from TRULY Understanding ViewState, the comment index - Infinities Loop
Hello Colin!
Thanks for this post... I tried to download your PipelineComponentsStarterKit.zip file, but winzip says it's not a valid archive? could you please check it for me? thanks a lot.
Marc
Marc - Works fine from here, try re-downloading it.
Thanks Colin for your reply...
In IE 7, it does not work, but in Firefox yes... Funny one...
Interesting.. I used IE and it worked like a charm. Perhaps a Community Server bug.
My frustraition with a product that is, in theory, action packed, but faultering in execution continues
Good investigation work. I'm curious to see if we get an official response. I can't reproduce the issue or I'd burn a PSS call trying to figure it out.
tk
I've been trying to get this component to work on my site, but I've had no success. I'm utilizing the starter site and attempting to plug your component into the 'total' pipeline. When I go to checkout, I receive the following error:
Component Execution failed for component[0x6] hr: 0x80004003
ProgID: RSG.CalculateTax
Object reference not set to an instance of an object...
in baskethelper.cs. I realize something isn't being created, but I'm having no luck in debugging this portion either.
Any thoughts on where to go from here?
Thanks, Ken
After creating the XML datasource and dataset i simply cannot get the
query to run for even the most basic request. Using Fiddler as suggested,
the error given is
“You do not have permission to view this directory or page using the
credentials that you supplied because your Web browser is sending a
WWW-Authenticate header field that the Web server is not configured to
accept.”
The datasource is configured for integrated security and i can paste in the
http address of the webservice and view it directly thru a browser.
Any idea what i can do to get this working?
Guy
Is there a way to read sharepoint list items directly from SQL Server? Maybe OPENDATASOURCE or something like it, using a similar approach as explained here?
I have had the same problem exactly. I find it ridiculous that the system just forgets the aliases. I also can't believe that WSS would not have a catch all for incoming email with no alias. The emails just disappear. That's a great policy. The whole thing has lead me to deliver messages to both WSS and the public folders WSS is meant to replace. Unbelievable!
Beware the gotcha if you copy to the clipboard and paste to an editor. The ampersand on line 40 may be converted to ampersand-a-n-d-semicolon, and that will fail.
I was having a nightmare getting this to work , I kept getting
after much back and fourth, i cut and pasted
schemas.microsoft.com/.../GetListItems
in the query window out to notepad and back in and hey presto it works.
GREAT Post!
I was able to get my query to work where it returns my fields in my list however, under the Report datasets, when I click on the plus symbol to expand my field list to use on my reports - mine is blank? It seems as if there are no fields returned for my query.
Any thoughts?
Nevermind....I figured it out! newbie mistakes.
Thanks again - Great Post.
Pingback from rockstarguys.com/.../deploying-commerce-server-2007-sites-without-site-packager.aspx
Pingback from rockstarguys.com/.../329.aspx
Pingback from rockstarguys.com/.../now-with-community-server-2007.aspx
Hello Colin,
thank you very much for this little script.
I'll have to change this part
"!(Test-Path Variable:__PscxProfileRanOnce)"
to this
"(Test-Path Variable:__PscxProfileRanOnce)"
to get it working.
Now I'll have to change
"older than today" to "older than a week"
;-)
Pingback from rockstarguys.com/.../retrieving-the-current-user-s-active-directory-object.aspx
Boah, i don't get it.
My logfiles are all saved in this format
u_ex071001.log
u_ex071002.log
The last 2 numbers aren't days, they are parts, because I'm saving the logfiles every week
I'm testing only with this 2 files at the moment.
So, i'll changed this
[String]::Format("u_ex{0}.log", [DateTime]::Now.ToString("yyyyMMdd"));
Get-ChildItem -Path $LogPath -Recurse -Include "u_ex*.log" | sort-object -property LastWriteTime | select-object name -last 1 | select name | fw
to get this string
But this doesn't have an effect and all logfiles will be zipped
Someone has an idea to exclude the last modified logfile
Ps: Nice Blog
Ok I have it.
This modification of colins Script do exactly what I want:
Compress all logfiles Compress all log files older than "today" and get this via lastwrite time
$ErrorActionPreference = "Stop";
trap [System.Exception]
{
Write-Host $_.Exception.ToString();
$EventLog = New-Object System.Diagnostics.EventLog
$EventLog.Set_Log("Windows PowerShell")
$EventLog.Set_Source("PowerShell")
$EventLog.WriteEntry($_.Exception.ToString(), "Error")
}
# Load Dependencies
if ((Test-Path Variable:__PscxProfileRanOnce))
Write-Error "Die PowerShell Community Extensions werden für dieses Script benoetigt.";
# Parse Command Line Arguments
if($args.length -ne 1)
Write-Host "Name";
Write-Host " Compress-LogFiles.ps1";
Write-Host "";
Write-Host "Aufgabe";
Write-Host " Komprimiert alle Logfiles die aelter sind als die Heutige.";
Write-Host "Syntax";
Write-Host " Compress-LogFiles.ps1 {LogPath}";
Write-Host "Beispiel";
Write-Host " Compress-LogFiles.ps1 D:\LogFiles";
$ErrorActionPreference = "ContinueSilent";
Write-Error "Es wird ein Argument mit dem LogPath erwartet" -Category SyntaxError;
Break;
$curTime = [System.DateTime]::get_now()
$LogPath = $args[0];
[array]$LogFiles = Get-ChildItem -Path $LogPath -Recurse -Include "u_ex*.log"
if($LogFiles.Count -gt 0)
$Index = 0;
foreach ($LogFile in $LogFiles)
Write-Progress -Id 1 -activity "Compressing Files" -status $LogFile.FullName
if(Test-Path ("{0}.gz" -f ([Management.Automation.WildcardPattern]::Escape($LogFile.FullName))))
Write-Error "Destination file already exists." -Category ResourceExists;
if ($LogFile.LastWriteTime -le $curTime.Add("-1"))
Write-GZip ([Management.Automation.WildcardPattern]::Escape($LogFile.FullName)) -Level 9;
Remove-Item ([Management.Automation.WildcardPattern]::Escape($LogFile.FullName))
$Index += 1;
else
Write-Host "Es wurde KEINE unkomprimierten Logfiles gefunden";
Remote management of Server Core installations helps you. It prevents you from having to struggle with
Pingback from rockstarguys.com/.../265.aspx
Pingback from rockstarguys.com/.../327.aspx
Not sure if this is exactly the same thing, but I have a problem with MOSS publishing sites. We frequently have a case where our user in the Approvers group for a site collection doesn't get notified when a page has been Submitted For Approval. When we check the user's MySite profile, their Work E-mail field is blank. We have also seen the same scenario with the user who submitted the page for approval not receiving a confirmation email when the page gets approved.
Right now our fix is to remove and re-add the user to the Approvers group.
John
Thanks for taking the time to gather all this up. We're experiencing the same problem and have opened a case; I'm going to forward them to this page to summarily describe what is happening. I'll let you know how this works out.
I have created custom pipeline,I want calculate tax flat $15 for order, i written the code below.
I have to put dll in GAC and working the pipeline fine.But its not written $15 always written $0.
Please help me on this.
using System;
using System.Collections.Generic;
using System.Text;
using System.Runtime.InteropServices;
using Microsoft.CommerceServer.Runtime;
using Microsoft.CommerceServer.Interop;
using Microsoft.CommerceServer.Interop.Orders;
using Microsoft.CommerceServer.Runtime.Orders;
namespace TaxCalculationPipeLine
[ComVisible(true)]
[GuidAttribute("2D99EC4E-1ACF-4720-B525-D7AD25174B54")]
public class TaxCalculation : IPipelineComponent, IPipelineComponentDescription
// Status codes for pipeline components
private const Int32 StatusSuccess = 1; // success
private const Int32 StatusWarning = 2; // warning
private const Int32 StatusError = 3; // error
#region IPipelineComponent Members
void IPipelineComponent.EnableDesign(int fEnable) { }
public int Execute(object pdispOrder, object pdispContext, int lFlags)
Int32 ReturnValue = StatusSuccess;
IDictionary orderForm = (IDictionary)pdispOrder;
IDictionary context = (IDictionary)pdispContext;
// Accessing an IDictionary
orderForm["order._cy_tax_total"] = new CurrencyWrapper(15.00M);
return ReturnValue;
#endregion
public object ContextValuesRead()
List<object> ReturnValue = new List<object>();
ReturnValue.Add("orderform.cy__tax_total");
ReturnValue.TrimExcess();
return (object[])ReturnValue.ToArray();
public object ValuesRead()
return ReturnValue.ToArray();
public System.Object ValuesWritten()
Thanks and Regards,
Peter Balu.
Colin,
Glad i read your blog.I have done i could to configure WSS list o receive incoming mails but NO SUCCESS.
I keep seeing this in WSS LOG:
05/02/2008 14:01:42.09 OWSTIMER.EXE (0x1324) 0x1300 Windows SharePoint Services E-Mail 6871 Information The Incoming E-Mail service has completed a batch. The elapsed time was 00:00:00. The service processed 0 message(s) in total.
I can see my emails in my drop folder for some seconds and then dissapears..
MS Share point Team where are you??
If you have any solutions for this please email me to : naijacoder@hotmail.com
Thanks Colin
Very nice command. I am in a similar situation, migrating a lot of PCs, with several of them having up to 50 certificates. Do you know about any command to export the certificates + key into PFX files, to make a batch file with it?
I am searching all the web, and the Microsoft's documentation, without any luck!
Great work here. I used the script above to re-insert the mysteriously missing entries from EmailEnabledLists. However, when I recycled the timer, and it processed the very next one, the entry was once-again nuked from the EmailEnabledLists table. This is bad...
Any traction anywhere on this???
Hey Collin,
I don have complete idea on poweshell scripting. can I have a script to compress/zip and to delete iis logs older than 7days.
You can mail me at prasanth.rowlo@bt.com
I just wanted to pass on that we are experiencing the same issue (Random and usually discovered by the user community)
Our work around has been un-checking and re-checking the “Overwrite files with the same name” flag in the non-working library (Email Settings).
We are not sure why this flag reset gets the mail “receiving” going again for that library but it does.
Any additional information on the culprit would grateful.
Great blog BTW!
What is the status of this issue? I have a desperate need for a fix.
Here is a link to another option for connecting to Sharepoint List data from Reporting Services- www.teuntostring.net/.../finally-fixed-problem-w-reporting-over.html
Link to the orginal article explaining the code- www.teuntostring.net/.../reporting-over-sharepoint-lists-with.html
The 'Enesys RS Extension' product is based on the code in this blog article.
It helps to read the comments for trouble shooting and installation.
I was able to set this up on a vhd and filter sharepoint list data in the filter tab.
Only supports reporting on one list.
Great diagnostic work. This is exactly what has just happened to us. There seems to be little available from Microsoft about this so I'm gonna log a ticket. THey can't ignore us forever, right?
Hi guys,
Great post! I have discovered the exact same thing as you and I was more than please to see that it was a kind of "known issue". I have tried to populate the EmailEnabledLists table as well ans dame thing.. after the first try, my new entries are gone! I have open a ticket with Microsoft releated to this problem and they seem to be aware of thie situation. On our side this problem beggin when we have move our Content Databases into a new SQL server. They should keep me in touch when they will have a work around.
good effort, i really need it.
This command should resolve the issue, without having to update the config database directly.
technet.microsoft.com/.../cc262558.aspx
I didnt get a response from the config team, so I put together the details in a blog post a few months back. You can find them here: mvolo.com/.../Accessing-IIS-7.0-configuration-remotely-and-on-server-core.aspx.
Also included are a batch file to set up remote MWA access, and a tool to troubleshoot common DCOM access issues for Microsoft.Web.Administration.
Hopefully this helps people deal with these issues.
Thanks,
Mike
We had this issue again. Last time we submitted this to MS (non-premier) support they said it would be difficult to identify the cause, so I droppped the issue. Since the last episode, I have begun to tell my users that incoming email is unreliable and they will need to be okay with lost email.
Pretty rough, but it's better to tell them it doesn't work and have them be pleasantly surprised, than to allow them to rely on it, and have it fail to live up to expectations.
Well my way around at least reducing the error is to create Exchnage Mail boxes that then do a mail flow to the contact that you create from Sharepoint. This way I at least ensure that all mail comes into an account and is not lost before it then is sent over to the libraries - or not as the case may be.
Also I have found an issue in that internal users cannot attach files that are sent to MOSS. This is due to a MAPI attribute not getting set up correctly on the AD Contact account.
Crazy crap... and not really enterprize... Governenace is crap as well. :-)
Dear's
I want to make a report on my "Search-List".
this reports should be customized and filter by user selection?
HOw can i able to do it.
(These lists are filling by one workflow its not working as BDC)
This query string will work... I have removed spaces from it
<Method Namespace="schemas.microsoft.com/.../soap" Name="GetListCollection"/>
Thank you post .:)
Thank You ...
sad
I dug into this problem for almost three days. Moving a content database from a development server to a production server resulted in all the email-enabled lists being dropped. Further, If I manually added them to the emailenabled lists table they were immediately deleted whenever an email was sent to them resulting in the dreaded Unknown Alias Error being thrown. There Sharepoint Logs showed a sqlCommand: 'proc_dropEmailEnabledListsByWeb' was issued just prior to processing the incoming e-mail folder C:\Inetpub\mailroot\Drop.
After restoring and adding the Content Database via STSADM I set the Site Collection Administrator correctly and recycled the Windows Sharepoint Services Timer service.
All the Lists accept email now.
P.s Microsoft can ignore you forever - even if you have Premier Support!!!!
Pingback from Extract SharePoint List Items for SSRS at SEIU IT Development
Have you heard from Microsoft on this?
Exchange 2007 rewrites "From:" address as well if we send locally and use secondary SMTP as From address.
Thanks.
Hi,
Like the same way can we get all the user group available in sharepoint into SSRS 2005.I will have some ADgroup with in the sharepoint Usergroup.I also need to get all the members with in the AD Group.Please help me in this.
thanks in advance
Official answer from MS:
Cause:
Design change in Exchange 2007
Resolution:
This issue is by design in Exchange 2007 and was looked at last year as a bug, but was determined not to be a bug.
Microsoft has determined that this new behaviour will not be changed.
Hello,
Did you ever post the extensions?
posting a few extensions I wrote for TP including Sharepoint event publishing and Outlook calendar/task synchronization over the next few weeks.
Does anyone have the SiteConfig.zip file as the link below doesn't work - file corrupt. Thanks
Pingback from Create a simple SRS report from a MOSS 2007 list | oconndav.com
i m getting error like "Failed to execute web request for the specified URL".
i check my connection string it is correct,working fine but unable to view query result.
Thanks for your paper, and it works perfectly in my machine.
But my question is that this way can only show the top level items, can u help me to get all items in all subfolders?
I tried to add the <Queryoptions><ViewAttributes Scope="Recursive" /><Folder>******/Folder></Queryoptions>
But it didn't work.
Thanks in advance!
Colin, I have returned. I must say I did get this working before back in '07 and now I am asked to look at this way of reporting again.
I am using fiddler and keep getting 2 issues, but not at the same time.
I get a 401 error (twice)
<html><head><title>Error</title></head><body>Error: Access is Denied.</body></html>
Then a 404 error. I have confirmed multiple (10+) times that my GUIDS and URL are all correct. And I do have access to the list.
I am stuck, any advice would be great. Again, GREAT Blog POST.
Hi Colon,
Forgive me if this is a stupid quesiton, but I keep getting the following error after trying to execute a RunTotalPipeline after squeezing your excellent CalculateTax component into total.pcf:
The configuration section for Logging cannot be found in the configuration source.
Any thoughts on why this could be happening?
Thanks, Aaron
Thanks for the steps. It worked and I was able to find the SharePoint data.
However, when I preview the report, why is it only returning 1 row?
Cialis
There are some people who say that top branded drugs are way more effective than the generic ones. However, this does not hold much truth when it comes to the generic medicines which are sold here. An online pharmacy which offers generic medicines at affordable prices. If you have been diagnosed with a sickness and your medication requires you to spend a lot for your medicines, you don't have to worry about this anymore. You can buy <a href="www.onlinepharmacy.vg/.../-c-32_469.html">Cialis</a>">www.onlinepharmacy.vg/.../a> and get a discount when you keep on buying the same drug. When you cannot tolerate the high price of branded medicines, your only option is an online pharmacy, since it is compassionate with your need for reasonably priced drugs.
If your medication calls for high-priced branded medicines, why not <a href="www.onlinepharmacy.vg/.../-c-32_469.html">Generic">www.onlinepharmacy.vg/.../-c-32_469.html">Generic Cialis</a>? This is an alternative which is provided at your affordable online drug store. One of the advantages that you can get from this store is the fact that its medicines can be bought for very low prices. You can order generic drugs at the website. These medicines are formulated with ingredients which are equal to the ones which make up branded drugs. However, the prices of the two are entirely different. Even though the prices of generic drugs and branded drugs vary widely, the effects are still the same. This is due to the fact that the medicines which are sold at this online pharmacy have been approved by worldwide organizations. The effectiveness and the quality of the generic drugs are regarded as excellent. The legality of these drugs has been supported by international regulatory boards. Some of these authorities are South Africa MCC, USA FDA, and WHO.
When you <a href="www.onlinepharmacy.vg/.../-c-32_469.html">Buy">www.onlinepharmacy.vg/.../-c-32_469.html">Buy Cialis</a>, the shipping service is offered for free. If you are residing within the European continent or at the other pole of the globe, the medicines that you have ordered will still be delivered to you. If you are a resident from the USA or from Europe, the duration of the shipping service can take fourteen days. One of the services that this online drug store provides its customers with is the chance to get a discount. Each time you order the same drug, you will be offered with a five-percent discount. Since the online pharmacy is compassionate with the plight of its sick patients, it does not charge you with hidden fees. Nor does it charge you when you consult with its physicians.
You can <a href="www.onlinepharmacy.vg/.../-c-32_469.html">Buy">www.onlinepharmacy.vg/.../-c-32_469.html">Buy Cialis</a> when you are diagnosed with a sickness. Serious ailments such as cancer or manic depression can be treated with some of the medicines sold at this online pharmacy.
Author
John Smith www.onlinepharmacy.vg/.../-c-32_469.html
Talk about pulling your hair out, this was a nightmare to solve, but thanks to the above post regarding 'proc_dropEmailEnabledListsByWeb' I eventually got it to work using WSS 3.0
In my case I alter 'proc_dropEmailEnabledListsByWeb' and just put a return 0, essentially rendering it useless. It was indeed getting called and wiping out the list.
Still no luck!
Tried a STSADM full backup and restore
Tried a stsadm.exe -o refreshdms -url <URL name>
Finally I changed the Sharepoint Timer service account to run under a different account than Local System account and restarted it.
Finally it worked and I was not getting the Alias error.
This really sucks and Microsoft needs to fix it.
thanks
thank you...)
lütfen tıklayın süper
You can Also Solved Problem By Create Different Application pool
www.dotnet-magic.blogspot.com