xDB Single node Facets in the xDB database xDB Factets The xDB Mongo database is intended to collect all the data you need for each client that visits your Sitecore site. Out of the box it collects a lot of data about what pages the user clicked on, how long they were on the page, who they are,
Sitecore Bonfire Profile Information API The focus here at Bonfire is on Digital Marketing, the Sitecore XP and all things customer journey. In that work, I often find myself wanting to know how my current test user, or real user, is tracking. * What are my profile scores? * Have I entered any patterns? * Do I have
Sitecore Helix: Your Best Practice Guide to Sitecore Development I like Sitecore. No, I love Sitecore. It is one of the most dynamic and configurable Content Management Systems on the market. If a client can envision something, I am confident that I can develop it in Sitecore. But there is a drawback. With Sitecore being so open, it allows
Moving controllers routes into Sitecore For a long time I have just done customer API controllers in Sitecore, the way I did them in ASP.NET MVC. By modifying the Global.ascx.cs file. public static void RegisterRoutes(RouteCollection routes) { routes.MapRoute( "Profile", // Route name "VisitorData", // URL with parameters new { controller
Getting multilist from SQL I had a recent request from a client to generate a SQL export of the structure of a section of the site. One problem I ran into was that I had several multilist controls that reference other items in the site. To report on them, I would need to follow
Sitecore Order of Pipelines for the Analytics Tracker I have been working on a new Tracker modification that I will be releasing on the marketplace soon. What I had trouble with was the order and running of the pipelines for the Tracker. I have my Tracker calling out to an API to gather some details on the user
Sitecore Parsing the __Tracker object for indexing I was recently working on a project where I had to index Sitecore profile data for aggregation and speed of access. I remember watching this [https://youtu.be/gE_uzncquTM] YouTube video put on by Martin Davies [http://sitecoreskills.blogspot.com/] (Twitter [https://twitter.com/twentygototen]). In the video he
Sitecore AWS vs Azure for Sitecore I was reading a post recently about Sitecore and AWS. The post was from the perspective of performance testing, but I am a hardware nut at heart, have dealt with both platforms for Sitecore and other IaaS required environments, and wanted to examine those details first. Sitecore can be installed
Intellisense issue when using Sitecore local NuGet files In the latest SIM [https://marketplace.sitecore.net/modules/sitecore_instance_manager.aspx] tool, having NuGet local is perfect. Gone are the days of lib folders and trying to keep track of the proper Sitecore dlls version. One issue I found is that when I used the new dlls, all
Ekrton Reset Ektron Search Property on Content The issue you have with Ektron is that when you update the Is Searchable checkbox on a folder, it is for all future content. Existing content is left as is. The SQL will update the Is Searchable to the parent folders setting. DECLARE @folderID int DECLARE @searchable int -------------------------------------------------------- DECLARE
SQL Find size of all SQL tables To find all the sizes of the SQL tables on disk, run the following command in SQL. If you have a large run away database it will help you track down the culprits. SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages)
Sitecore Reseting the admin password to b To reset the admin password to "b" via SQL, just run the following SQL on the core database. UPDATE dbo.aspnet_Membership SET [Password]='qOvF8m8F2IcWMvfOBjJYHmfLABc=', [PasswordSalt]='OM5gu45RQuJ76itRvkSPFw==', [IsApproved] = '1', [IsLockedOut] = '0' WHERE UserId IN (SELECT UserId FROM dbo.aspnet_Users
Sitecore Getting Sitecore out of SQL In a recent project I needed to call Sitecore via SQL. Here are a few snippets that will get most people started. It should be noted that getting Sitecore data via SQL is not always faster than using the API. And when you use SQL you lose all of the
