tag:blogger.com,1999:blog-65080452239480204442024-02-19T01:39:05.712-08:00SharePoint/MOSS, .NET, Accessibility, Usability Blog - Markus SchneiderQualidatorhttp://www.blogger.com/profile/05257776807378008045noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-6508045223948020444.post-73022707326636935782014-06-11T00:30:00.000-07:002014-06-11T00:31:00.946-07:00RestSharp - Simple REST and HTTP API Client for .NET <a href="https://github.com/restsharp/RestSharp/wiki/Getting-Started">https://github.com/restsharp/RestSharp/wiki/Getting-Started</a> Qualidatorhttp://www.blogger.com/profile/05257776807378008045noreply@blogger.com0tag:blogger.com,1999:blog-6508045223948020444.post-2366612905943457942012-02-09T12:52:00.001-08:002012-02-09T12:53:42.851-08:00How to extract a DLL from GAC in a minute<strong><span style="font-weight: normal;">Simply map a network drive to: \\YourMachineName\c$\windows\assembly</span><br style="font-weight: normal;"><br style="font-weight: normal;"><span style="font-weight: normal;">You must be an Admin for that.</span><br /></strong>Qualidatorhttp://www.blogger.com/profile/05257776807378008045noreply@blogger.com0tag:blogger.com,1999:blog-6508045223948020444.post-59599602763063171162011-03-08T09:14:00.001-08:002011-03-08T09:22:41.339-08:00LINQ in upgraded VB.NET projectIf you want to use LINQ in VB.NET and if the project was upgraded from .NET 2.0 to a newer version please make sure to set <strong>"Option infer" on</strong> under compile options. Otherwise you might no be able to use the methods of System.Linq.Enumerable methods like count, average etc.<br /><br />You might also need the following namespaces depending on your current task:<br /><br /><em>Imports System.Linq<br />Imports System.Data.Linq<br />Imports System.Xml.Linq </em><br /><p><em>The <strong>rest</strong> of the configuration tasks can be found here: </em><em><a href="http://msdn.microsoft.com/de-de/library/bb546156.aspx">http://msdn.microsoft.com/de-de/library/bb546156.aspx</a><br /></p></em>Qualidatorhttp://www.blogger.com/profile/05257776807378008045noreply@blogger.com0tag:blogger.com,1999:blog-6508045223948020444.post-52432603501741140702010-12-10T06:54:00.001-08:002010-12-10T07:01:38.284-08:00Load DataSet Error: Cannot add a DataRelation or ConstraintIf you work in an international team there may occur problems with the <strong>Locale</strong> property of <strong>datasets</strong>.<br /><br />The error may also occur when running the application: "<strong>Cannot add a DataRelation or constraint that has different Locale</strong>..."<br /><br />Often you can not fix this within visual studio but there is a simple way to fix it with <strong>notepad</strong>:<br /><br />Search and replace the string "<strong>msdata:Locale="de-CH"</strong> (example for German-Switzerland) with an empty string using notepad. Simply open the <strong>xsd</strong> file with notepad.<br /><br />Make sure to create a backup before. If you have a versioning tool this should be no problem anyway.Qualidatorhttp://www.blogger.com/profile/05257776807378008045noreply@blogger.com0tag:blogger.com,1999:blog-6508045223948020444.post-90811741394855523382010-03-23T09:15:00.000-07:002010-03-23T09:21:01.517-07:00Strong Name an existing assembly (dll)Today I needed to strong name an existing third party assembly in order to use it for SharePoint (GAC). I found a great solution from "DoubleJ" at <a href="http://sadeveloper.net/forums/p/1195/5115.aspx">http://sadeveloper.net/forums/p/1195/5115.aspx</a><br /><br />I copied it here in order to make sure I does not get lost:<br /><br />"From a VS.NET command prompt, enter the following:<br /><br />1. Generate a KeyFile<br />sn -k keyPair.snk<br /><br />2. Obtain the MSIL for the provided assembly<br />ildasm providedAssembly.dll /out:providedAssembly.il<br /><br />3. Rename/move the original assembly<br />ren providedAssembly.dll providedAssembly.dll.orig<br /><br />4. Create a new assembly from the MSIL output and your assembly KeyFile<br />ilasm providedAssembly.il /dll /key= keyPair.snk<br /><br />Viola! You now have a strong named assembly."Qualidatorhttp://www.blogger.com/profile/05257776807378008045noreply@blogger.com1tag:blogger.com,1999:blog-6508045223948020444.post-9144822224819923372010-03-07T10:27:00.000-08:002010-03-07T10:30:48.692-08:00WebPart button event fires only onceIn order to make sure a button in a WebPart (for example to export data to excel) can be clicked more than once add the following to the OnClientClick event:<br /><br />buttonExportToExcel.OnClientClick = "_spFormOnSubmitCalled = false;_spSuppressFormOnSubmitWrapper=true;";Qualidatorhttp://www.blogger.com/profile/05257776807378008045noreply@blogger.com0tag:blogger.com,1999:blog-6508045223948020444.post-89718145276623767932009-11-03T07:52:00.000-08:002010-09-25T07:48:11.282-07:00Virtual PC: Performance Issues on Notebook, Mini-PC etc.Power management may slow down virtual PC. I found a solution that works perfectly on my Notebook:<br /><a href="http://svengillis.blogspot.com/2008/01/performance-issues-with-virtual-pc-on.html">http://svengillis.blogspot.com/2008/01/performance-issues-with-virtual-pc-on.html</a><br /><br />Essentialy I had to change the <strong>enable_idle_thread</strong> setting in the options file located at<br />C:\Users\[My User Name]\AppData\Local\Microsoft\Windows Virtual PC in my windows machine.<br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDLyQcbwKBjzmNkbasSYNNRjOcngwf9BOxRxTkSTysmlc5yRL82QP7TaRNTHsaf4cIkbtiP3u_zGJB3wypQUWNlXDPF0X1xdYiJ9PB8t0QY_8oOMnCwNfZjbDKiLf5DACGQRTIVnRBZvO2/s1600/VirtMachinePerformanceNotebook.png"><img style="WIDTH: 540px; HEIGHT: 205px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5520862543313240482" border="0" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDLyQcbwKBjzmNkbasSYNNRjOcngwf9BOxRxTkSTysmlc5yRL82QP7TaRNTHsaf4cIkbtiP3u_zGJB3wypQUWNlXDPF0X1xdYiJ9PB8t0QY_8oOMnCwNfZjbDKiLf5DACGQRTIVnRBZvO2/s400/VirtMachinePerformanceNotebook.png" /></a><br /><br /><br /><br /><br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi55VSuBD9_eLi59h7LpF17fcHtgG8Bm6NUiIdfPnq4sxGEOoV6S8xFPSmIT0z1X0wXKT49Z9wEj_2sIdtDuLBFRPPXccbMHwwlDL0lhk23B0pBIarchfrLRPDMIjZr8-efcwMPYAXR6HD-/s1600/VirtMachinePerformanceNotebook.png"></a>Qualidatorhttp://www.blogger.com/profile/05257776807378008045noreply@blogger.com0tag:blogger.com,1999:blog-6508045223948020444.post-19959520141209572782009-11-03T05:24:00.000-08:002009-11-03T05:27:41.132-08:00The secrets of SQL Syntax Queries for Relevant Results in MOSS 2007 Enterprise SearchI just found a very helpful post from Lars Fastrup containing a nice overview and samples for SQL syntax queries in MOSS 2007 Enterprise Search:<br /><a href="http://blog.sharepointproducts.com/archive/2009/03/31/repost-the-secrets-of-sql-syntax-queries-for-relevant-results-in-moss-2007-enterprise-search.aspx">http://blog.sharepointproducts.com/archive/2009/03/31/repost-the-secrets-of-sql-syntax-queries-for-relevant-results-in-moss-2007-enterprise-search.aspx</a>Qualidatorhttp://www.blogger.com/profile/05257776807378008045noreply@blogger.com0tag:blogger.com,1999:blog-6508045223948020444.post-54049154450500812722009-09-28T01:10:00.001-07:002009-09-28T04:11:29.611-07:00Wildcards in the CONTAINS Predicate in Windows SharePoint Services Search SQL Syntax - no resultsIf you get no results with CONTAINS and wildcard search in MOSS make sure you don't forget the " in the query. The MSDN documentation does not include them.<br /><br /><strong>wrong:</strong> select title, author, rank from scope() where CONTAINS (defaultproperties, 'sharep*') order by rank desc<br /><br /><strong>correct:</strong> select title, author, rank from scope() where CONTAINS (defaultproperties, '"sharep*"') order by rank desc<br /><br />I recommend <a href="http://www.codeplex.com/SPSearchBench">http://www.codeplex.com/SPSearchBench</a> for testing.Qualidatorhttp://www.blogger.com/profile/05257776807378008045noreply@blogger.com0tag:blogger.com,1999:blog-6508045223948020444.post-14036227230239578612009-09-14T06:55:00.000-07:002009-09-14T07:05:26.438-07:00Content for this URL is excluded by the server because a no-index attributeIn SharePoint/MOSS server search crawl log you may see "Content for this URL is excluded by the server because a no-index attribute" apear for pages that you would like to be indexed.<br /><br />What to check in this case:<br /><ul><li>Rules</li><li>Robots.txt file</li><li>Page Source (robots meta)</li><li>Page library advanced settings</li><li>'Site Settings' - 'Search Visibility' under 'Site Administration' </li><li>and last but not least: Make sure you can <strong>access the page with the user that you definied as robots/crawler user</strong>. See central administration:<br />/ssp/admin/_layouts/contentaccessaccount.aspx<br />(log on to your site with this user)</li></ul><p>Hint fot German users: The error message in German is "Der Inhalt für diese URL wird wegen eines Nichtindexattributs vom Server ausgeschlossen".</p>Qualidatorhttp://www.blogger.com/profile/05257776807378008045noreply@blogger.com1tag:blogger.com,1999:blog-6508045223948020444.post-50712452398217384762009-08-06T06:34:00.000-07:002011-05-14T02:48:58.613-07:00How to copy a MS SQL database from one server to another without server admin rights on source machine<strong>Step 1:</strong> Generate a SQL script including data by using <strong>SQL Server Database Publishing Wizard</strong>:<br />The wizard is integrated in Visual Studio Server Manager. Alternate download for older versions: <a href="http://www.microsoft.com/Downloads/details.aspx?displaylang=en&FamilyID=56e5b1c5-bf17-42e0-a410-371a838e570a">http://www.microsoft.com/Downloads/details.aspx?displaylang=en&FamilyID=56e5b1c5-bf17-42e0-a410-371a838e570a</a><br /><br /><strong>Step 2:</strong> Use <strong>SQLCMD</strong>.exe to execute the file.<br />Normally you can't use the query analyzer because it would throw an exception of type System.OutOfMemoryException:<br /><br /><em>sqlcmd -S servername -d TargetDBName -i C:\SQLFileGeneratedByDBPubWizard.sql -o C:\DBImportLog.txt</em><br /><br />Have a look at the log file to see what's going on.<br /><br />If you can not execute sqlcmd on the target machine you might for example want to write a command line tool that executes the sql commands in smaller blocks.Qualidatorhttp://www.blogger.com/profile/05257776807378008045noreply@blogger.com0tag:blogger.com,1999:blog-6508045223948020444.post-35525132421617008722009-07-30T07:23:00.000-07:002009-07-30T07:26:42.018-07:00SharePoint Search Queries Test UtilityFound a new very helpful windows utility today to test SharePoint Search Queries. Also displays scopes and managed properties.<br /><a href="http://www.codeplex.com/SPSearchBench">http://www.codeplex.com/SPSearchBench</a>Qualidatorhttp://www.blogger.com/profile/05257776807378008045noreply@blogger.com0tag:blogger.com,1999:blog-6508045223948020444.post-3682879222802801972009-07-24T07:47:00.000-07:002009-07-24T07:53:36.281-07:00Export MOSS (SharePoint) page library (or any other List) to file systemExporting a page library in MOSS can be quite tricky. One great alternative ist to use SPIEFolder (<a href="http://www.codeplex.com/SPIEFolder">http://www.codeplex.com/SPIEFolder</a>) that can export the files quite fast to a file system folder of your choice as follows.<br /><br />Example command:<br />SPIEFolder.exe <a href="http://win2003-moss1/DE/MediaMessageImport">http://win2003-moss1/DE/MediaMessageImport</a> Seiten C:\OutputTest export<br /><br />The files can then easily be reimported for instance via web browser (upload files).Qualidatorhttp://www.blogger.com/profile/05257776807378008045noreply@blogger.com0tag:blogger.com,1999:blog-6508045223948020444.post-46198526166694673972009-07-20T01:40:00.000-07:002009-07-24T07:53:57.918-07:00Save/export MOSS (SharePoint) Page Library as STPUnfortunately there is no "save list as template" option in MOSS for page libraries. A simple work around is to use the /_layouts/savetmpl.aspx page and add the query string value for list manually. This might finally look something like this:<br /><br />http://win2003-moss1/DE/MMImport/_layouts/savetmpl.aspx?List=%7B19216C57%2D1B09%2D4CDB%2DB766%2DF0289E3D28F5%7DQualidatorhttp://www.blogger.com/profile/05257776807378008045noreply@blogger.com0tag:blogger.com,1999:blog-6508045223948020444.post-11891666449313686192009-07-12T08:15:00.000-07:002009-07-24T07:54:20.491-07:00Explorer.exe high CPU on Windows Server 2008I had very high CPU usage for explorer.exe today on a web server running Windows Server 2008. Task manager showed that it was running under the Administrator Account.<br /><br />I did not log off the last time I worked on this machine and it seams that explorer.exe bug out meanwhile. Thus the solution for now is logging of and log on again. If I find out more or if the problem reoccurs I will post that here.Qualidatorhttp://www.blogger.com/profile/05257776807378008045noreply@blogger.com0tag:blogger.com,1999:blog-6508045223948020444.post-501653458694735362009-05-30T08:03:00.000-07:002009-08-13T00:22:42.462-07:00SharePoint Workflows: Delay Activity not working/firing after GAC updateI <span class="blsp-spelling-error" id="SPELLING_ERROR_0">recently</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_1">had</span> an <span class="blsp-spelling-error" id="SPELLING_ERROR_2">issue</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_3">with</span> a <span class="blsp-spelling-error" id="SPELLING_ERROR_4">Delay</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_5">Activity</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_6">not</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_7">firing</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_8">after</span> I <span class="blsp-spelling-error" id="SPELLING_ERROR_9">updated</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_10">the</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_11">GAC</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_12">from</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_13">Visual</span> Studio 2008.<br /><br />I <span class="blsp-spelling-error" id="SPELLING_ERROR_14">finally</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_15">found</span> a MS KB <span class="blsp-spelling-error" id="SPELLING_ERROR_16">that</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_17">helped</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_18">me</span>:<br />"A <span class="blsp-spelling-error" id="SPELLING_ERROR_19">workflow</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_20">does</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_21">not</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_22">resume</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_23">automatically</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_24">when</span> a <span class="blsp-spelling-error" id="SPELLING_ERROR_25">delay</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_26">activity</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_27">is</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_28">triggered</span> in <span class="blsp-spelling-error" id="SPELLING_ERROR_29">Windows</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_30">SharePoint</span> Services 3.0"<br /><a href="http://support.microsoft.com/kb/953630/en-us">http://support.microsoft.com/kb/953630/en-us</a><br /><br /><span class="blsp-spelling-error" id="SPELLING_ERROR_31">Solution</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_32">for</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_33">my</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_34">project</span>: <strong>Restart <span class="blsp-spelling-error" id="SPELLING_ERROR_35">the</span> Service "Windows <span class="blsp-spelling-error" id="SPELLING_ERROR_36">SharePoint</span> Services <span class="blsp-spelling-error" id="SPELLING_ERROR_37">Timer"</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_38">after</span> an update.</strong><br /><strong></strong><br />P.S. The same trick also helps to solve the "System.IO.FileNotFoundException" issue that can occur when installing a wsp with a feature receiver.Qualidatorhttp://www.blogger.com/profile/05257776807378008045noreply@blogger.com0