Posts

CascadiaJs Best Sessions

Here are the session videos that blew my mind. The session titles are terrible, ignore them. The presenters are amazing. Shay Howe - Css as a Service: Maintaining Style Ben Straub - Hacking Culture with Javascript ANDREI KASHCHA - A story of package managers, graphs, and one million vertices

How to disable Umbraco's Client Dependency Handler (dependencyhandler.axd) for development

Image
One of the tasks of the dependency handler ( dependencyhandler.axd ) used in Umbraco is to manage the return of client-side files such as css and javascript. For live code, caching this makes sense but for development, it just makes the troublesome line of code harder to find. While in development, make sure you change the web.config file's setting of compilation to debug=true. Then when you refresh the page. You should now see the client files in the network trace instead of the dependency handler. For more information, review the docs . For more extensive configuration, find the ClientDependency.config file in the Umbraco website's /Config directory, off of the root.

Azure VM LIcensing Error

When you log in to the Windows Azure VM, you may receive a popup that says you need to configure the licensing server. If you don't configure the licensing server, you only have X days left of access. You need to sign in to the Azure portal, download the RDP file for that virtual server, and only access the VM from that RDP.  The RDP file has access to the server, even after the licensing server grace period ends.

Umbraco CMS Refresh

U mbraco is an Asp.Net based Content Management System. It has many pieces and configuration elements. Recycle/Refresh While I have been working on the Merchello Package, I've learned some ways to cycle Umbraco if something isn't working right. Touch Web.Config Reindex Examine Indexes via Back Office Delete files in \App_Data\Temp Republish content node or entire content tree. 

Parsing Word Document XML via MsXml in VBA

Image
An old friend ping me because while having some success loading word documents saved as xml in his VBA routines in word, he was having massive problems getting XPATH to work. I resolved the basic issue and then asked him to give me his hardest issue for me to show some example code for. I think that the last time that I did this was a few years ago, MsXml was (and is) a bit lame compared to later implementations, so his troubles were very reasonable to have.   Declaring name spaces You can’t use XPath on a document with namespaces without providing the name spaces. The process is pretty simple, just convert the namespaces declare at the top of the XML document to a VB String. There happen to be many of them in a word xml document..   Dim domPrefix As String domPrefix = "xmlns:wpc='http://schemas.microsoft.com/office/word/2010/wordprocessingCanvas' " domPrefix = domPrefix + "xmlns:mc='http://schemas.openxmlformats.org/markup-compatibility/2006...

Merging two AspNet Profiles–more complex then one would think!

During recent code revision, a developer accidentally removed in Web.Config, the applicationName on the SQLProfileProvider element. The consequence became apparent when support started to report customers saved-reports-definitions(which was stored here) had disappeared. < add name ="ErrorProfileProvider" connectionStringName ="LocalSQLServer" type ="System.Web.Profile.SqlProfileProvider" /> The problem was identified, but there was a second problem… We had a significant number of new customers that also saved reports-definitions to this error profile provider. A simple switch back by adding the applicationName would mean that these reports-definitions would disappear (which customer support did not want to see happen to new customers – a rather bad experience). My initial take was “Oh, I have used multiple membership providers in one web application in the past, so we just need to use the same pattern…” Oops that pattern did not w...

Converting SalesForce SOQL results to a Linked Dataset for use by C#

Image
In my last post, I illustrated the 'simple' way of getting the data back - by just creating a Xml Document from the results. This is not always efficient -- in fact, I have gotten out of system memory errors on some queries. In this post I will take the same query and show a little slight of code. The query was: SELECT Name,    (SELECT Name, Email FROM Contacts),    (SELECT CaseNumber, CreatedDate, Subject, Status, Resolution__c,  ClosedDate, SuppliedEmail,SuppliedName FROM Cases    WHERE CreatedDate = LAST_N_DAYS:366     AND Origin != 'Internal'     AND OwnerId !=     '00G40000001RTyyEAG'     AND RecordTypeId IN ('01240000000UTWP', '01240000000UWxM', '01240000000UWxl', '01240000000UWxb')   )   FROM Account    WHERE ID IN (SELECT AccountId FROM Contact Where Email in ({0})) Extension Method to Handle SOQL Result Columns The code ...