Computers / Programming / Mobiles (67)
In sharepoint, if it is required to disable the filter and to keep only the
sorting, then following workaround could be the solution one. (Following change are done to sharepoint 2010 using sharepoint designer 2010, might be it works for 2007 aswell)
Please keep the copy of file(s) which you are going to
change, incase if some mishap happen J
·
Open the desired sharepoint
site in sharepoint designer
·
Select Lists and Libraries
from the Site Objects
·
Select desired list /
library
·
Select the desired view from
the views list where you want to remove to remove filter
·
Click on advance mode
·
Search for the <ViewFields>
inside <XmlDefinition>
·
Now add following desired attribute
to all desired columns. (All column are <FieldRef
Name="ModifiedOn" />)
as
<FieldRef
Name=" ModifiedOn " LinkToItem="TRUE"
Filterable="FALSE" FilterDisableMessage="No filter available
"/>
After that, edit the page where the list / library webpart
exists or add webpart (list / library) if not already added on the page, edit webpart properties and select the desired
view again then click apply button to reflect changes.
In above,
·
You can change the default
text for disabled filter using FilterDisableMessage="No filter available
" attribute
·
By adding Filterable="FALSE",
now the filter will not be available
·
If you want to make a
particular column clickable, then add LinkToItem="TRUE"
Pakistan has marked victory in International Cyber Drill Competition, the competition was based on tricks and techniques regarding ” Cyber Security and how to secure systems from hackers and hack attacks”. Pakistan took part in the drill for the first time and beaten experts from 28 other countries
LAHORE – IFTIKHAR ALAM - For the first time in the country’s history an eight member team of computer experts has participated in an international cyber drill and completed all the tasks successfully, various social websites and blogs reported here on Wednesday.
The Pakistani team won the competition held in Kuala Lumpur Malaysia, where 25 teams of experts from 20 countries participated, it was informed. The Pakistani team comprised four members of Pakistan Information Security Association and four students of National University of Science and Technology.
The event was organised by the Asia Pacific Computer Emergency Response Team (APCERT). The annual drill was held to test the response capability of leading Computer Security Incident Response Teams from Asia Pacific economies.
It was the first time that APCERT involved the participation from the Organization of the Islamic Cooperation – Computer Emergency Response Team (OIC-CERT) in the annual drill, following a Memorandum of Understanding on collaboration signed in September, 2011.
The theme of the APCERT Drill 2012 was “Advance Persistent Threats and Global Coordination”.
The objective was for participating teams to exercise incident response handling arrangements locally and internationally to mitigate the impact of advance persistent threats that involved large scale malicious software propagation and attacks capable of impairing the critical infrastructure and economic activities. The main focus of the event was to educate the participants, who were given specific task to complete them within a time limit.
The exercise reflected a strong collaboration amongst the economies, and it also enhanced the communication protocols, technical capabilities and quality of incident responses for assuring Internet security and safety. About 22 CSIRT teams from Australia, Bangladesh, Brunei Darussalam, People’s Republic of China, Chinese Taipei, Hong Kong, India, Indonesia, Japan, Korea, Macao, Malaysia, Myanmar, Singapore, Sri Lanka, Thailand, Vietnam, Tunisia, Egypt and Pakistan participated in the drill.
Courtesy : Daily Nation
Few days before, I was having problem that after clicking on Export to pdf button / image, other controls of web part/user control stops working on the application page on WSS 3.0 environemnt that has RadGrid on it.
While the same thing was working on other asp.net application outside the sharepoint environment.
1st workaround (can be a solution)
The cause for this behavior is that there is a flag (named _spFormOnSubmitCalled) in SharePoint which prevents double form submition. This flag is set when the form is submitted and clear when the response is received. However when exporting the response is redirected and the page is not updated, thus the flag is not cleared and page's postbacks are blocked.
In order to workaround this behavior you should manually clear the flag when exporting. This can be achieve, for example in export button's client click function similar to the following:
MyExportButton.OnClientClick = "_spFormOnSubmitCalled = false;"
Above workaround will allow you to export multiple times, but all the other controls on the page were still not functional after the export.
2nd workaround (Not / Never recommended)
In your sharepoint master page, remove onsubmit attribute from your form tag
<form runat="server" onsubmit="return _spFormOnSubmitWrapper();">
and remove the onsubmit attribute. This is what it looks like now:
<form runat="server">
3rd workaround (so far so good and implementable)
Add the following script to your webpart / custom control that need to have export and other controls functionals, rather then implementing the above workarounds So here you go with the working solution.
<script type="text/javascript" language="javascript">
//sharepoint postback to work after clicking on telerik export to pdf if (typeof (_spBodyOnLoadFunctionNames) != 'undefined' && _spBodyOnLoadFunctionNames != null) { _spBodyOnLoadFunctionNames.push("supressSubmitWraper"); }
function supressSubmitWraper() { _spSuppressFormOnSubmitWrapper = true; } </script>
Hope this will helps.
SPWeb has two sharepoint cross-site group collection, SPWeb.Groups and SPWeb.SiteGroups.
SPWeb.Groups returns collection of cross-site groups which has some permission on the site. So if you add group from a site without any permission on the site, then this group wont appear in SPWeb.Groups collection, but it will appear in SPWeb.SiteGroups collection.
You can not use SPWeb.Groups.Add method to add new cross-site group, you need to use SPWeb.SiteGroup.Add method for this purpose.
In addition to this SPWeb has a property AssociatedOwnerGroup, which will return the required SPGroup. You can iterate the SPGroup users to get the list of all owners of the site.
foreach (SPUser user in web.AssociatedOwnerGroup.Users) { // .. list all the users }
Finding and adding group
SPGroup group = GetSiteGroup(web, "groupName"); if (null == group) { web.SiteGroups.Add("groupName", web.AssociatedOwnerGroup, null, "Test Group description"); }
private static SPGroup GetSiteGroup(SPWeb web, string name) { foreach (SPGroup group in web.SiteGroups) { if (group.Name.ToLower() == name.ToLower()) { return group; } } return null; }
Today I tried to find out which table is taking much space in DB or to find the numbers of columns and rows in all tables of DB
Following query will return the required result
=========
USE DatabaseName GO CREATE TABLE #temp ( table_name sysname , row_count INT, reserved_size VARCHAR(50), data_size VARCHAR(50), index_size VARCHAR(50), unused_size VARCHAR(50)) SET NOCOUNT ON INSERT #temp EXEC sp_msforeachtable 'sp_spaceused "?"' SELECT a.table_name, a.row_count, COUNT(*) AS col_count, a.data_size FROM #temp a INNER JOIN information_schema.columns b ON a.table_name collate database_default = b.table_name collate database_default GROUP BY a.table_name, a.row_count, a.data_size ORDER BY CAST(REPLACE(a.data_size, 'KB', '') AS integer) DESC DROP TABLE #temp
If you want to have signin as different user functionality like sharepoint in your asp.net application, following workaround you might be looking for. After setting your web.config file's
<authentication mode="Windows" />
and in IIS after remove anonymous authentication and enable windows authentication, have following code snippet where you want to have this functionality
In your aspx page
<div>You are logged in as <br /> <%=User.Identity.Name%> <br /><br /> <asp:LinkButton ID="lnkSignOut" runat="server" Text="Sign in as different user" onclick="lnkSignOut_Click"></asp:LinkButton>
In your code behind file
protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { Session["logOutRequested"] = false; //Initialize value. This will be set to true when user will click on sign in as differnet user } }
protected void lnkSignOut_Click(object sender, EventArgs e) { if (null != Session["logOutRequested"] && !Convert.ToBoolean(Session["logOutRequested"])) // Check if user is clicking link first time { Session["logOutRequested"] = true; //Set value that user want to sign in as differnet user Response.StatusCode = 401; Response.StatusDescription = "Unauthorized"; Response.End(); } else { Session["logOutRequested"] = false; //Initialize value again after user is authenticated with differnet or same user again. } }
Hope this workaround will help.
In case if above workaround is not working, you may try following one www.roelvanlisdonk.nl/?p=825
Installing XP on computer with SATA hard drive
I recently come across with a problem downgrading a computer comes with Windows 7 to Windows XP, but during setup following error appears telling about Virus or Checkdisk /F bla bla bla,
***STOP: 0x0000007B (0xf78d2524, 0xc0000034, 0x00000000, 0x00000000)
Dont' worry, give following a try, might be it will work for you aswell,
Go to Computer BIOS by pressing F2 or F10 or Del depending on your computer
Go to Storage Option / Drive Configuration
Search for option saying SATA Emulation and change this to IDE from AHCI.
Accept / Save your setting by pressing F10 or Save and Exit
Run Windows XP Setup again
Hope it will work
Query to find all the Tables and Index with number of days statistics being old. Then run Update Statistics command to update statictics for optimized query plan.
SELECT OBJECT_NAME(A.object_id) AS Object_Name, A.name AS index_name, STATS_DATE(A.OBJECT_ID, index_id) AS StatsUpdated , DATEDIFF(d,STATS_DATE(A.OBJECT_ID, index_id), getdate()) DaysOld FROM sys.indexes A INNER JOIN sys.tables B ON A.object_id = B.object_id WHERE A.name IS NOT NULL ORDER BY DATEDIFF(d,STATS_DATE(A.OBJECT_ID, index_id),getdate()) DESC
Get-SPSite | where {$_.url -like "http://a *"}
Get-SPFarm | Format-List Id, BuildVersion, Servers, Solutions
Add-PSSnapin Microsoft.SharePoint.Powershell
===========
ExecuteHelloWorldScript from batchfile
powershell -Command "& {.\Hello.ps1}" -NoExit pause
powershell -Command "& {Set-ExecutionPolicy bypass}" -NoExit
===========
CreateContosoSite
if($args) { $SiteName = $args[0] $SiteUrl = "http://a:3811/sites/ " + $SiteName Write-Host "Begin creating Contoso site at" $SiteUrl Write-Host $NewSite = New-SPSite -URL $SiteUrl -OwnerAlias Administrator -Template STS#1 -Name $SiteName $RootWeb = $NewSite.RootWeb $RootWeb.Title = "Contoso Site: " + $SiteName $RootWeb.Update() Write-Host "New Contoso site successfully created" Write-Host "-------------------------------------" Write-Host "Title:" $RootWeb.Title -foregroundcolor Yellow Write-Host "URL:" $RootWeb.Url -foregroundcolor Yellow Write-Host "ID:" $RootWeb.Id.ToString() -foregroundcolor Yellow } Else { Write-Host "ERROR: You must supply Name as parameter when calling CreateContosoSite.ps1" }
===========
GetSharePointDlls
$path = "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14"
Get-ChildItem $path -recurse | Where-Object {$_.name -like "*SharePoint*.dll"} | Sort-Object -Property Name -unique | Format-Table Name
===========
GetSharePointPublishingFeatures
Get-SPFeature -Limit ALL | Where-Object {$_.DisplayName -like "*Publishing*"} | Sort-Object -Property Scope Format-Table DisplayName, Id, Scope
===========
.\GetSharePointPublishingFeatures.ps1 Get-SPFarm | Format-List Get-SPSite | where {$_.url -like "http://a *"} .\CreateContosoSite.ps1 lab01test
===========
===========
===========
===========
===========
===========
To view the detailed error information for generic error against 500 Internal Server Error
By default, Windows hosting servers display a generic error when any .NET application generates an exception. They display a generic error because the detailed error messages allow a malicious user to obtain sensitive information.
To troubleshoot the error, you can modify your web.config file and specify that a custom error message displays. A custom error message helps you to locate the specific code that is causing the issue.
CAUTION: The code samples we provide below do not constitute a complete web.config file. Do not replace your existing web.config file with the code we provide. Before changing your web.config file, we recommend creating a backup.
Displaying Custom Error Messages / Enabling Detailed Errors on IIS 6
Use the sample code below to display custom error messages on IIS 6:
<configuration> <system.web> <customErrors mode="Off"/> <compilation debug="true"/> </system.web> </configuration>
Displaying Custom Error Messages / Enabling Detailed Errors on IIS 7
Use the sample code below to display custom error messages on IIS 7:
<configuration> <system.webServer> <httpErrors errorMode="Detailed" /> <asp scriptErrorSentToBrowser="true"/> </system.webServer> <system.web> <customErrors mode="Off"/> <compilation debug="true"/> </system.web> </configuration>
=========================
|
|