Sunday, December 18, 2016
Wednesday, November 9, 2016
Incoming Email Sharepoint List workflow is not starting in the new item is created
1- First of all, we have check in SharePoint server setting if workflow trigger on email is enabled or not, and enable it.
Using STSADM
Open the SharePoint 2010 Management Shell as administrator and run following command:
stsadm -o getproperty -pn declarativeworkflowautostartonemailenabled
Output should be:
If Value of property is “No” you have to enable it by typing following command:
stsadm -o setproperty -pn declarativeworkflowautostartonemailenabled -pv true.
Using PowerShell
st
This property was somewhat easier to set using STSADM, however keep in mind that STSADM is being retired. PowerShell is the command line administration tool to use moving forward.
Open the SharePoint 2010 Management Shell as administrator and run the following to determine the value of the DeclarativeWorkflowAutoStartOnEmailEnabled property:
$spWebService = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
$spWebService.DeclarativeWorkflowAutoStartOnEmailEnabled
If the Value of the property is "False" you have to enable it by typing the following commands:
Execute in the powershell script to set true in the DeclarativeWorkflowAutoStartOnEmailEnabled.
By default DeclarativeWorkflowAutoStartOnEmailEnabled property is false.
$spWebService = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
$spWebService.DeclarativeWorkflowAutoStartOnEmailEnabled = $true
$spWebService.Update()
Monday, October 31, 2016
Wednesday, September 21, 2016
Get SQL Server Custom Login Password expiration Details
The below code will execute in the SQL server then you will get the details
--Show all logins password expiration date and creation date
SELECT name AS SQLLoginName,
DATEADD(DAY, CAST(LOGINPROPERTY(name, 'DaysUntilExpiration') AS int), GETDATE())
AS ExpirationDate,
create_date
FROM sys.server_principals
WHERE type = 'S'
-- Show all logins where the password was changed within the last day
SELECT name, LOGINPROPERTY([name], 'PasswordLastSetTime') AS 'PasswordChanged'
FROM sys.sql_logins
WHERE LOGINPROPERTY([name], 'PasswordLastSetTime') > DATEADD(dd, -1, GETDATE());
-- Show all logins where the password is over 60 days old
SELECT name, LOGINPROPERTY([name], 'PasswordLastSetTime') AS 'PasswordChanged'
FROM sys.sql_logins
WHERE LOGINPROPERTY([name], 'PasswordLastSetTime') < DATEADD(dd, -60, GETDATE())
AND NOT (LEFT([name], 2) = '##' AND RIGHT([name], 2) = '##');
--Change Password via code
ALTER LOGIN TestDBs
WITH PASSWORD = 'Asdeft##';
--Show all logins password expiration date and creation date
SELECT name AS SQLLoginName,
DATEADD(DAY, CAST(LOGINPROPERTY(name, 'DaysUntilExpiration') AS int), GETDATE())
AS ExpirationDate,
create_date
FROM sys.server_principals
WHERE type = 'S'
-- Show all logins where the password was changed within the last day
SELECT name, LOGINPROPERTY([name], 'PasswordLastSetTime') AS 'PasswordChanged'
FROM sys.sql_logins
WHERE LOGINPROPERTY([name], 'PasswordLastSetTime') > DATEADD(dd, -1, GETDATE());
-- Show all logins where the password is over 60 days old
SELECT name, LOGINPROPERTY([name], 'PasswordLastSetTime') AS 'PasswordChanged'
FROM sys.sql_logins
WHERE LOGINPROPERTY([name], 'PasswordLastSetTime') < DATEADD(dd, -60, GETDATE())
AND NOT (LEFT([name], 2) = '##' AND RIGHT([name], 2) = '##');
--Change Password via code
ALTER LOGIN TestDBs
WITH PASSWORD = 'Asdeft##';
Wednesday, August 17, 2016
Dynamic hyperlink open in the new window in the Nintex workflow form
Opening a dynamic link in a
new window can also be done by adding a button
(action: JavaScript, type: Link)
in the advanced section you enter window.open("the dynamic link") by on-click.
Now you can click on the Resume Link, it will open the Resume Document.
Friday, July 15, 2016
Thursday, June 23, 2016
Sharepoint 2013: “Access Denied” Error Message While Activating A Timerjob Site-Feature or Custom Web Part Feature
Error:
ULS: Access denied. w3wp.exe (0x1E30) – 6615 – Critical under /_layouts/ManageFeatures.aspx?Scope=Site
Getting a error message while activating a timerjob site-feature (on a production system with uac) as farm and local administrator on a sharepoint site.
Solution:
1) Execute this powershell script as farmadmin:
function Set-AccessDenied-False()
{
# load sharepoint api libs
[System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint”) > $null
[System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint.Administration”) > $null# get content web service
$contentService = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
# turn off remote administration security
$contentService.RemoteAdministratorAccessDenied = $false
# update the web service
$contentService.Update()}Set-AccessDenied-False
3) Active your feature again
Thursday, May 26, 2016
ASP.Net Server Side Code for redirect to another Page
You can use in the below code in your code block
string spurl = SPContext.Current.Site.Url;
string scriptText = "alert('Record has Successfully SavedDraft.'); window.location='" + spurl + "/Test/default.aspx'";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(panel4, Page.GetType(), "alertMessage", scriptText, true);
Once user click on the Button then it will redirect to other page.
Wednesday, April 6, 2016
Friday, March 18, 2016
Sharepoint 2013 Workflow Tasks List - View with Filtered By Assigned To = Sharepoint Groups
Scenario:
I have workflow with three approvers, One approvers is specific person, the other approvers are two sharepoint groups like HR SP Group and CEO SP Group.
I would like to add task webpart in the home page to filter my sharepoint Workflow 2013 Tasks list only to display the tasks assigned to the current user.
Hence I create a HR View and set a filter ‘Assigned To’ is equal to [Me] in the view.
However, I am not seeing the tasks that has a HR SP Group assigned and the HR SP group contains the current user.
Solution:
Here are the steps:
- Create HR Task view in the Task List.
- set a filter ‘Assigned To’ is equal to HR SP Group in the view.
- Open SharePoint Designer.
- Open theHR Task view of the task list in code view.
- Find the tag and within it add the following:
Find the Tag
Replace to
6.Save the view and open it again in the browser.
Labels:
Sharepoint 2013,
Sharepoint Designer 2013
Thursday, February 25, 2016
Load specific text in the dropdown in the Nintex form 2013 using Jquery
var varLocationID=NWF$('#' + varJSLocationID).val();
LocationValue = ko.dataFor(NWF$("#" + ddlJSLocation)[0]);
// Setting value to drop down
LocationValue.initialValue = varLocationID;
Tuesday, January 12, 2016
Subscribe to:
Posts (Atom)