December 2013

I recently published a major update to http://infopathdb.codeplex.com/ which enables users to query InfoPath XML data (including repeating tables) over SOAP, JSON, and Excel. It’s great for reporting against data collected with InfoPath forms. Please check out the project and let me know if you have any ideas to improve. Thanks!

Have you ever wanted to report directly against InfoPath Form Library data? Have you been frustrated by the limitations of published columns? Have you had trouble when trying to report on repeating table (one-to-many) data? Do you like working with clean XML web services? Then download and check out this SOAP web service.

This code will aggregate many source XML documents into a single XML for easy reporting. Because InfoPath documents share a common XSD schema from within the template XSN, they may be consolidated using Dot Net objects like DataSet, DataTable, and XmlDocument.

When testing role based security, it can be helpful to right click IE and “Run as different user.” The below PowerShell script automates this process to make it easier to launch multiple IE windows for testing. Keeping a copy on Windows 7/8 workstations can help users jump into testing easily and with fewer password typo lockouts. If you find this helpful, please leave a comment.

PowerShell

1

2

3

4

5

6

7

8

9

10

# Launch multiple IE windows as different test user accounts. Great for testing role based security systems.

# Updated line 3 with user name, line 6 with Active Directory domain, and line 9 with SharePoint URL.

I wanted to thank all of you for reading my blog and wishing you a Happy Holiday season. After passing exam 070-480 about HTML5, it seemed like a great time to practice new skills and draw a <CANVAS> based Christmas Tree here. Enjoy!

I saw the below error when working with Office Web Apps 2013 and SharePoint 2013 in a two farm topology where OWA was installed on the Domain Controller and a separate machine ran SharePoint 2013 and SQL 2012. OWA here is running the October Cumulative Update hotfix KB 2825686 and SharePoint 2013 is also running the October Cumulative Update KB 2825647. Windows Updates were run and appear current.

The cause appears to be applying a patch to the “OWA farm” (not SharePoint farm). Re-creating the farm The PowerShell resolution steps I followed were: