Tuesday, March 31, 2015

SharePoint 2013 Designer Workflow Error : the attempted operation is prohibited because it exceeds the list view threshold

Hello
After some trial and error and tracing I found that the cause of a SharePoint Designer Workflow error: 
"...the attempted operation is prohibited because it exceeds the list view threshold..."

Summary:
This error appears when trying to edit any action that has  a string builder, resulting in a delay, an error prompt and the inability to edit an exiting string.

Cause
The cause is a call to an existing SharePoint 2010 Workflow which results with the below error showing in the Designer. 

Workaround:
A simple re-name of the  SharePoint 2010 Workflow resolves the error, the underlying causing in SP is unknown at this time, however this work-around will allow you to edit your workflow without error. 

See below document for full details.

Sunday, March 1, 2015

How to make Visual Studio 2012 look like 2010 in 3 steps

Tired of 2012 VS.net look and feel? Well change it to preference or in my case change it to 2010:

1. Icons: get rid of the 2012 icons, restore with 2010
2. Color: Get rid of the gnarly Theme and go back to Blue from 2010
3. Text: get rid of the ALL upper case labels (yuk!!)

Here are the tools I did for each:
1. Icons: Download, extract Visual Studio Icon Patcher - http://vsip.codeplex.com
extract
run cmd:
VSIP.exe extract
VSIP.exe inject

2. Color: Download Theme Editor: (2.2 has Blue, latest does not, dont ask me why?)
http://mirror.nienbo.com/visualstudio-extensions/ColorThemeEditor.vsix

Install and set theme to blue, e.g:
http://prntscr.com/6bmj11


3.: Text: Regedit and then this simple DWORD:
HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\11.0\General\SuppressUppercaseConversion 
REG_DWORD value: 1
per:
http://www.richard-banks.org/2012/06/how-to-prevent-visual-studio-2012-all.html


4. end result:

Monday, February 16, 2015

TextPad Encrypt Decrypt Text File AddOn

Summary|:
Author: Jason Doyle
Purpose: To provide encrypt/decrypt text file functionality in the awesome text file editor Textpad!
This AddOn shall allow ad-hoc securing of files. Uses RSA encryption provider for encrypt/decrypt of text files.
PreReqs: Win 7 or above w/ .Net FW

How To Install/Use:
1.      Download and unzip to dir (e.g: C:\TextPadAddons\)
      Open TextpadEncDec.ReadMe.rtf to view figures/screen shots for install.

2.      Open text pad, Configure | Preferences,
3.      Add Program
4.      Add Following Paths:
a.      {InstallDir}" \TextpadEncDec\TextPad.Encrypt.Run.bat"
b.      "{InstallDir}\TextpadEncDec\TextPad.Decrypt.Run.bat"
5.      Tools menu will now have 2 new  tools!
6.      Open or create a new text file
7.      To Encrypt: Add some text, click Tools | TextPad.Encrypt.Run to encrypt
a.      See Figure 6 and 7
b.      The document is encrypted and saved,
c.      Text shall Reload the document
d.      Don’t edit the encrypted content
e.      Your document is now secure
8.      To Decrypt:   Open the file encrypted in step above
a.      Click Tools | TextPad.Decrypt.Run to decrypt
b.      File is decrypted, and original contents are shown!


Tuesday, January 27, 2015

Macro to get around: Outlook Issue : "Send Time" time stamp information is incorrect when you send a delayed delivery message in Outlook

' UPDATED 20160302 to include capability to support specific Outlook Accounts, Set the ACCOUNT_NAME const to mailbox, macro will run in that context.

Download latest here: 

'******************
' This macro module was created because Outlook DeferredDelivery sets the SendTime to the time you click Send not the actual time  the email leaves the Outbox
' SEE HERE: http://support.microsoft.com/kb/247176

' So I created this macro, download below,

'   DeferSendWithRealSentTime
'   This Module will check outbox if item has DeferredDelivery time set then this macro will send that item to recipients with the REAL SEND Time

'   To automate this we use a periodic function via win32/64 Timer will poll outbox every 1 min
'   Items with Defered Deliv set and now is within 10 min of Defered Deliv, this will clone the email item, send it.


Example of how it works:
In Outlook:
Create new email set DelayDeliverTime to something like for example:
As an example Times:
DeferDeliveryTime: 3:00PM
now is 2:30PM
Click Send
At 2:50PM the macro will fire, the email will be sent to recipients and the SentTime will be 2:50PM and NOT 2:30!!!!!!! Voila the MS issue is fixed.


Related MS Issue:  "Send Time" time stamp information is incorrect when you send a delayed delivery message in Outlook


Download the Macro Here, Unzip and add to Outlook!



'   Cloned Item will then appear in SentItems and Original will appear Deleted Items
'    SEE CheckOutbox() code
'
'   Version: BETA
'   Date: 20150127
'   Author: jrd
'   Supports:
OL 2010 and above (tested with 2010)
32 and 64 bit!
'   Known Issues:
'       Embedded images show as attachement
'       Need testing with more Exchange versions
' ******************



Thursday, January 15, 2015

SharePoint 2010/2013 Library Does not Open in Windows Explorer

Its great using the drag/drop features of the shell with SP, however if some pre-req's are not installed then the Toolbar item will not be enabled and we can't use the lovely "windows explorer browse SharePoint document library" feature.

Working on a servers via RDP I have run across this several times where the toolbar item is greyed out, after trial and tribulations here was a solution I found that worked:

1. Make sure the The WebClient Service  feature is added to the Win2008 server (and maybe 2012 server via Desktop Experience feature?) 
2. Ensure the SP Site is added to trusted sites
3. Use IE 7 or above

The toolbar item Open in Explorer should then be enabled. 
See more here:
http://www.sharepointgeoff.com/getting-the-sharepoint-windows-file-explorer-to-work-in-a-server-2012-sandbox/


Thursday, December 25, 2014

Visual Studio 2013 IDE Enhancements


VS 2013 brings in a host of new IDE editor features that 2012 and all prior were lacking, especially elegant is the Peek window with breadcrumbs, We can now go to definition drill down and back multiple levels with ease, Check this out, Alt F12 wil bring up an inline peek window for the selected type:





For more info see this vid starting @ 31:34
https://www.youtube.com/watch?v=wa9Tvr9yiQs

VS 2013 Keyboard Shortcuts here:
https://drive.google.com/file/d/0B_g_1Tnrt6oFcnh4M1NVQV9vLVU/view?usp=sharing

Tuesday, December 16, 2014