Try our conversational search powered by Generative AI!

Deane Barker
May 9, 2014
  2902
(2 votes)

EPiServer License Data Exporter

EPiServer recently released an API for their license data.  The idea is that you can export license information from EPiServer and bring it down to your own infrastructure to query and otherwise manipulate it.

I had been asking for something like it for years, starting with this blog post: "Why Your App Needs Automated Data Export." In that post, I complained (nicely) about both EPiServer and Insightly, a CRM my company uses.

After that post, Insightly created their API, and it was awesome in its simplicity – it just gave you a basic bulk export, from which you could do anything.  The idea is that your local tools are better at querying and data manipulation than a web-based system, so if I can just get this data down to my local machine, I’m better off.

EPiServer was finally able to take a run at this system, and I worked with the internal team on it. I explained what I was looking for, and they responded with exactly what I asked for: simple, API-driven, bulk export.  It’s not complicated and it works beautifully.

I adapted a library that I wrote for Insightly to download the data and populate SQL database.  It’s now on Github:

EPiServer License Data Exporter

Provide an API key and a connection string, and this command line utility will populate a local SQL Server database with all your license information, enabling you to develop reporting around that information.  It’s extensible as well – all the objects are run through “mapping objects” with properties that use XPath to extract data.  It should be awfully easy for any .Net developer to figure out.

I hope you get some value out of it, and I welcome pull requests if you have changes.

May 09, 2014

Comments

Please login to comment.
Latest blogs
Optimizely Web... 6 Game Changing Features in 2024

If you are interested in learning about what's new within Optimizely Web, you are in the right place. Carry on reading to learn about the 6 greates...

Jon Jones | Mar 3, 2024 | Syndicated blog

Headless forms reloaded (beta)

Forms is used on the vast majority of CMS installations. But using Forms in a headless setup is a bit of pain since the rendering pipeline is based...

MartinOttosen | Mar 1, 2024

Uploading blobs to Optimizely DXP via PowerShell

We had a client moving from an On-Prem v11 Optimizely instance to DXP v12 and we had a lot of blobs (over 40 GB) needing uploading to DXP as a part...

Nick Hamlin | Mar 1, 2024 | Syndicated blog

DbLocalizationProvider v8.0 Released

I’m pleased to announce that Localization Provider v8.0 is finally out.

valdis | Feb 28, 2024 | Syndicated blog

Epinova DXP deployment extension – With Octopus deploy

Example how you can use Epinova DXP deployment extension in Octopus deployment.

Ove Lartelius | Feb 28, 2024 | Syndicated blog

Identify Azure web app instance id's for an Optimizely CMS site

When running Optimizely CMS in Azure, you will be using an instance bound cloud license. What instances are counted, and how can you check them? Le...

Tomas Hensrud Gulla | Feb 27, 2024 | Syndicated blog