Paving the Way for Chart Data
Before we began importing the data, we had to carve out a place in Sitecore to put it. Storing each data point as a content item seemed like a natural fit but posed a problem; the amount of data points we would need to store would greatly slow down the content tree and any data retrieval on the frontend. Our solution was to leverage specialized Sitecore containers, called item buckets, for storing and retrieving large amounts of content items.
With the chart data set, we needed to plan out the Sitecore infrastructure behind displaying and navigating the chart data for each facility. Most of the setup was straight forward with Sitecore templates, however, because of the repetitive nature of the data for each facility, we were able to leverage Sitecore cloning. Cloning helped to speed up the content creation process for the initial import and for adding new facilities in the future. It allowed us to create a set of content items to use as the “master copies” of the content that could then be cloned into the proper location for each new facility.
Migrating the Data to Sitecore
Having the groundwork laid out, we could start bringing in the data to Sitecore. The data was exported into a CSV file which we had to find a way to import. That was when we found a module from the Sitecore marketplace called EZ Importer. This allowed us to create a field map and then use that map while performing the import.
Navigating a Sea of Charts
With the data migrated and templates set up, we now had a navigable experience through 1,000+ charts that successfully mimicked and improved upon the original content. The content was easily maintainable and expandable by content authors, effortlessly navigated by users and had the look and feel that the client asked for.