Asontu

Herman Scheele
.NET, C#, Sitecore developer and Data Science engineer @ theFactor.e.

profile for asontu at Stack Overflow, Q&A for professional and enthusiast programmers

Tech-blog about C#, Sitecore, T-SQL, Front-end, Python, Data Science and everything in between run by Herman Scheele

RSS Archive

Tag: Sitecore

9 May 2022

Revisited: Sitecore path in SQL Query

A little over 2 years ago, when we all thought the pandemic might just be a 2-3 month ordeal, I wrote the first article of this blog about how to get Sitecore item paths when directly querying the (master) database. A lot has happened since then, let’s talk about it.

tags: Sitecore - T-sql - Back-end


15 December 2021

Group by folder in Sitecore Forms

Recently I was made aware of Mohammad Abujaffal’s excellent article on how to View Sitecore Forms in Groups or Categories in Forms Dashboard and while implementing it I found some optimizations.

tags: Back-end - Sitecore


15 August 2021

Sorting Sitecore Forms exports

If you’ve ever exported form submissions as CSV file from Sitecore 9+ Forms, you might’ve noticed the order in which the columns are exported seems completely random. We can fix this by implementing our own IExportDataProvider.

tags: C# - Back-end - Sitecore


28 December 2020

Admin-panel to whitelist IP's for identity server

One of our clients wanted to be sure that only white-listed IP’s can log into Sitecore to manage their site. We solved this by utilizing IIS’s IP Address and Domain Restrictions feature on the Sitecore Identity Server. That way adding or removing an IP only restarts the app-pool for the Identity Server, not the Sitecore instance. Annoyingly this has meant that every so often I have to log into the production server just to add an IP address to IIS, until I made this admin-page that let’s anyone with the developer role in Sitecore do this without all the hassle.

tags: Sitecore - C# - Back-end


12 September 2020

Using jQuery without breaking Sitecore 9 Forms validation

If the front-end code of you Sitecore 9 site is using jQuery, you might have run into some issues on pages with Sitecore Forms. This is because vanilla Sitecore Forms uses an unobtrusive form validation library that’s dependent on jQuery, but might not use the same version of jQuery that you wanna use in your front-end. jQuery has a .noConflict() method to deal with this, but how do you actually properly use it?

tags: Sitecore - Javascript - Front-end


26 May 2020

Introducing nifty Sitecore userscript and filtering MutationObserver events

Like I’m sure many developers, when I use the same tool a lot I start see possibilities for improvement to suite my workflow. So too with the Sitecore client. So to automate everything I find myself doing twice, to the Tampermobile!

tags: Sitecore - Front-end - Javascript


22 March 2020

Sitecore path in SQL Query

When trouble-shooting Sitecore issues, sometimes you wanna dive directly into the SQL Database and query around in dbo.Items. But you might want to query an item’s Sitecore-path, like in the where clause. This recursive common table expression makes that very easy:

tags: Sitecore - T-sql - Back-end