Tips for creating a custom Web template in SharePoint 2010

1. When compiling the project, if you run into a conflict with features during deployment in Visual Studio while developing the Web template, consider moving different elements, such as lists, site columns, and so forth to different features. Don’t try to put all the elements of the Web template solution in one feature. 2. In […]

Adding Javascript to a sandboxed Visual Web Part

Adding JavaScript to a sandboxed Visual Web Part seems to work best when using the following script inside the .ascx file: <script type="text/javascript">     SP.SOD.executeFunc("~sitecollection/_catalogs/siteassets/MyWebPart/MyWebPartScript.js", null, LoadMyScript);     //the following two variables keep the page with the web part from freezing and becoming uneditable when in edit mode     var inDesignMode = document.forms[MSOWebPartPageFormName].MSOLayout_InDesignMode.value;     var wikiInEditMode = document.forms[MSOWebPartPageFormName]._wikiPageMode.value;     if […]

Applying a theme quickly to subsites

The secret sauce is ThemedCSSFolderURL for applying your theme quickly to many subsites on non-publishing sites with a code based solution. SharePoint: Subsite Theme/Composed Looks Inheritance https://msdn.microsoft.com/en-us/library/office/microsoft.sharepoint.spweb.themedcssfolderurl.aspx

Nintex Best Practices

The following items can help your Nintex workflows run more reliably and efficiently: 1. Disable Nintex history logging in the workflow settings 2. Create one Nintex database per Web application in SharePoint 3. Run the Nintex purge workflow script every six months or more often, depending on your farm https://community.nintex.com/docs/DOC-1218 4. Use workflow constants. Best […]

Can’t get JavaScript files to run in SharePoint?

Having trouble getting JavaScript files to run in your SharePoint site? Make sure you set the¬†LoadAfterUI=”true” attribute in your ScriptLink tag. Here is an example: <SharePoint:ScriptLink ID=”MyBaseID” Name=”~Site/_catalogs/masterpage/MyPathtoJavascriptFile/mycustomjavascriptfile.js” runat=”server” OnDemand=”false” LoadAfterUI=”true” Localizable=”false”/>

SSIS and moving Excel files around

Need to upload an Excel to a SQL Server¬†database on a regular basis? Check out the following article on SQL Server Integration Services (SSIS): http://www.excel-sql-server.com/excel-import-to-sql-server-using-ssis.htm