A client recently told me one of his frustrations: using a site database is like having a great warehouse where you store your belongings with no possibility of taking them out. He noted that if data can be extracted easily, there is no reason it should not also be easy to import. He cited the example of Asset by Teoco, the radio network planning software which seamlessly allows radio engineers to download data, modify it in Excel, then re-upload it.
Our team thought the idea was great but soon we realized that in contrast to a radio planning tool, the ClickOnSite data model differs from one client to another, and it can change over time. But we were inspired and brainstormed how to create a new configurable import feature for ClickOnSite.
A couple of sprints later, we delivered a great tool that allows a user to create his own import templates!
- User browses his files and selects the Excel sheet he wishes to import
- Maps the file content to the database fields
- He automatically gets an audit (number of possible import errors) of his import as well as a preview
- If the user is happy with the result he can proceed to either create or update his database with the data from the Excel file
This is not only great to export, update and import data; it is efficient for migrating data from another system: it avoids the cost of building an interface and allows easy population of the operator’s database with the location of tower companies or site owners.
We were inspired by some clients who will recognize themselves in this story. Listening to our clients’ needs and how they work leads to new ClickOnSite features, and, as in this case, an expanded way of thinking. We truly enjoy the inspiration for improving our products we get from direct conversations with our customers. We strive to #MakeTheEverydayBetter!