Upload Xsn With Code to Sharepoint 365

VIDEO – PowerShell PNP to parse InfoPath XML Attachments

Wanted to share quick tutorial on how to parse InfoPath attachment XML. Source Form Library contains XML with Base64 encoded attachments which we tin parse into local TEMP folder and so upload to destination Certificate Library. Extract filename and file content for each InfoPath attachment XML node. Save into subfolders and lucifer original file naming. Helpful for Office 365 migration and scenarios where InfoPath client is no longer available and users prefer to view attachments directly.

Video, screenshots, and source code below.

Thanks

GitHub Repo

https://github.com/spjeff/O365-Dissever-InfoPath-Attach-XML

Video

Screenshots

InfoPath – search replace URLs within XSN

Need to migrate forms to another URL? But not sure how to update many information connections? Endeavour the script beneath.

This PowerShell volition extract XSN contents to a binder, execute cord search replace, and "package" dorsum into CAB format with XSN extension. A unproblematic way to migrate InfoPath forms to another DNS proper noun for scenarios like AAM Alternate Access Mapping redirection and SharePoint major version upgrade (2007 > 2010 > 2013).

Enjoy!

NOTE – Requires CABARC.EXE http://stackoverflow.com/questions/3361928/where-can-i-become-the-cabarc-utility

InfoPath_UpdateDataConnetions.ps1

# Update InfoPath form URLs by extracting CAB and performing search supplant Param( 	[cord]$xsnFile ) Write-Host "Fix folders..." doctor c:\InfoPath\before md c:\InfoPath\temp physician c:\InfoPath\after Write-Host "Clean temp..." Remove-ChildItem c:\InfoPath\temp\*.* -Recurse Write-Host "Extract XSN... $xsnFile" cabarc ten "c:\InfoPath\before\$xsnFile" *.* c:\InfoPath\temp\ Write-Host "Supercede URL..." $txt = Get-Content c:\InfoPath\temp\Manifest.xsf $txt |% {$_ -replace "//sharepoint/" "//sharepnt07/"} | Out-File -FilePath "c:\InfoPath\temp\Manifest.xsf" -Encoding UTF8 -Force Write-Host "package XSN..." cabarc due north "c:\InfoPath\afterwards\$xsnFile" c:\InfoPath\temp\*.* Write-Host "Washed"

BreezeJS – Edit SQL tabular array with < 100 lines of JS code [VIDEO]

With SharePoint 2013 and industry movement towards the deject I've been exploring JavaScript as a chief way to develop rich applications.

One mutual challenge is data access.

With C# I accept years of experience with [Arrangement.Data] and tin perform Grime confronting SQL relational databases in my sleep. Open up connectedness, query, data adapter, fill DataTable, and voila! Muscle retentivity. Second nature. Tried and true methods. However, in the new client side JS world I had no clue where to begin.

Enter Breeze.

People depict Cakewalk equally "Entity Framework on the client in JavaScript" which sounds simple nonetheless has profound implication for the developer. CRUD operations, LINQ style query, navigating primary/foreign keys, input validation, caching, batch updates, and more. That's a lot to consider and new ideas have time to absorb. Breeze could potentially supplant:

ASP.Net (ASPX) web forms
ASCX user controls
InfoPath forms
SharePoint web parts
WCF 5.6 information services
OData
Classic WebAPI

I set up out to code an example with a few goals:

Create simple SQL schema (two tables – parent/child – one to many)
Execute Grime operations in JS against SQL tables
Leverage JS plugins and NuGet "Install-Package" to load third party components
- Install-Package cakewalk.webapi2.ef6
- Install-Packet breeze.athwart
- Install-Package angularjs.core
Petty code every bit possible

The whole thing took less than 30 minutes and I edited video downwards to just xv. I was impressed past how straightforward and piece of cake the process was. Breeze# in ASP.Net MVC for the back terminate WebAPI controller was most identical to the Breeze instance lawmaking. Add one C# method per entity (SQL tabular array) and Cakewalk does the rest. The JS front terminate took a little more time to understand but was also like shooting fish in a barrel to apply. Connect Entity Manager to the Cakewalk URL and you're set for CRUD queries. Amazing! Given how like shooting fish in a barrel Cakewalk is I would be difficult pressed to use OData or manually created WebAPI controllers with C# code to query a database. If you lot can utilise Breeze, then use it! You'll save lots of effort.

Please leave a comment if you plant this helpful. Thank you!

Watch Video

[BreezeJS and WebAPI – Edit SQL table in JS with less than 100 lines of lawmaking]

Download Code

Screenshots

References

http://cakewalk.github.io/physician-samples/spider web-api-odata.html
https://www.nuget.org/packages/Breeze.WebApi2.EF6/
https://www.nuget.org/packages/Breeze.Angular/
https://www.nuget.org/packages/AngularJS.Core/
https://chrome.google.com/webstore/detail/postman-rest-client/fdmmgilgnpjigdojojpjoooidkmcomcm?hl=en
http://www.microsoft.com/en-united states/server-cloud/products/sql-server-editions/sql-server-express.aspx
http://world wide web.visualstudio.com/products/visual-studio-community-vs
http://world wide web.getbreezenow.com/samples/introduction-single-page-apps-sharepoint
http://www.getbreezenow.com/samples/todo-angular

InfoPath tip – detect Security Grouping with List Detail permissions

Aye, everyone says InfoPath is dead … only we're all however supporting it for a while then I wanted to share ane of my favorite tips. Forms often need part based security at the field level. Table below with example security matrix.

How can InfoPath detect that? Don't some people query Lather ASMX? Or even a custom WSP with a custom ASMX? There is a simpler mode with List Particular permission.

Create a new Custom List named "SecurityLevel" with just the default "Title" cavalcade.
Go create the needed SharePoint Groups nether Site Permissions.
Dorsum in "SecurityLevel" add one new item for each SharePoint Grouping with an identical name. Hover that item, pull down the menu, and set Item Level Permissions for that group ONLY to have "Read" on that item only.
With InfoPath Designer edit the XSN Course Template and create a new Data Connectedness to the list "SecurityLevel" with auto refresh.
Under Form Load create a rule … if count(SecurityLevel ["Analyst"]) > 0 then set field "SecurityLevel=Annotator".
With that in place yous are ready to apply formatting rules anywhere needed that use "SecurityLevel" to determine hide/evidence or read/write.

Voila!

At present when a user open the InfoPath form, the information connectedness "SecurityLevel" will just show the items they have access to (which is the aforementioned every bit the SharePoint Group membership!). Works on MOSS 2007, SharePoint 2010, SharePoint 2013, and Office 365.

Hope this helps. Please leave a comment if information technology did.