Recently, we had a client that wanted to extract data from xConnect using Power BI. One option available was through the built-in OData service – https://site-prefix.xconnect/odata endpoint. The challenge was that Power BI (among other tools) doesn’t support the kind of authentication that xConnect implements.
Continue reading “Enable different authentication methods to xConnect OData”Author: João Neto
João Neto is a Sitecore MVP, 2x Sitecore Hackathon champion, and a Certified Sitecore Developer. The views he expresses are his own and not in any official capacity for Sitecore or any other companies/clients he works for.
Understanding Sitecore logs – Part 2: Caches and XML configuration load
Continuing with my series of blogs describing what each line in the Sitecore logs mean, today I want to talk about Caches and XML Configuration load.
In this post, we are still examining the log file. In future posts, we will explore Client, Crawling, Eds, Exm, Fxm, Search, Publishing, Aggregation and WebDAV logs. Phew… sounds like a lot of work.
Continue reading “Understanding Sitecore logs – Part 2: Caches and XML configuration load”Create a dropdown list with external data in Sitecore Forms
Sitecore Forms comes with an out-of-the-box dropdown list field that allows you to choose between a static or a dynamic data source. In today’s blog post I am sharing a simple way to create a custom dropdown list that displays external data from systems such as Salesforce.
Continue reading “Create a dropdown list with external data in Sitecore Forms”Understanding Sitecore logs – Part 1: xDB, Tracking, License, Path Analyzer and Memory Monitor
I want to start a series of blogs describing what each line in the Sitecore logs mean. I am basing my research on the log information extracted from Sitecore 9.1 Update-1 with the log priority level set to “INFO”.
Let’s start with the log file.
Continue reading “Understanding Sitecore logs – Part 1: xDB, Tracking, License, Path Analyzer and Memory Monitor”How to create a Fieldset HTML element in Forms
The scope of this post is to walk you through a detailed process of how to create a custom Form element. You can achieve the same by following the Walkthrough: Creating a custom form element page. However, I want to share a step by step process with some extra explanations and tips.
Continue reading “How to create a Fieldset HTML element in Forms”Sitecore Publishing Service and publishing targets
Recently, I was working on a Sitecore implementation that has 3 publishing targets: “staging”, “web1”, “web2”. As the number of items in that site goes beyond the millions due to the number of languages and versions, we decided to install Sitecore Publishing Service. Among all the items, one specific page was never published to “web1” and “web2”. After some time, I figured out why.
Continue reading “Sitecore Publishing Service and publishing targets”Automatically bootstrap fields in Sitecore 9 Forms
Sitecore Forms enables you to easily create forms by dragging and dropping fields. It also supports Bootstrap. However, if you want to use Bootstrap framework, you must follow a set of steps to add the proper wrapper and classes around each field. Needless to say, this approach is not user friendly at all.
In this post, I share with you a custom processor that automatically wraps fields and adds the proper classes to each input and label.
Continue reading “Automatically bootstrap fields in Sitecore 9 Forms”XConnect IndexWorker error “Tokens are incompatible, they have different set of shards.”
Recently, I had restored a “production” backup of the master and core databases from a Sitecore 9.0 Update-1 instance to my local SQL server installation. After that, the Sitecore log started filling up with the exception:
Sitecore.XConnect.XdbSearchUnavailableException Message: The HTTP response was not successful: InternalServerError.
Go home Core database, you’re drunk.
Recently, after pulling the latest changes from my team, my local Sitecore installation started showing every item duplicated. Not only the LaunchPad was behaving like that, but also the Content Editor.
This issue only appeared in local Sitecore installation. Azure environments (DTAP) where not reproducing this issue. What was happening?
Continue reading “Go home Core database, you’re drunk.”Applying personalization per host name
Recently, we had a requirement where we needed to personalize content based on the current host.
The requested scenario was: visitor can access the same site from different hosts. For example: pension.company.nl, insurance.company.nl, mysafety.company.nl. Based on the current host, the visitor should see a different icon and text on the page.
How did we meet this requirement?
Continue reading “Applying personalization per host name”