Not logged in - Login

Data Import Services

Overview

Importing data to the SAFE system is very often a necessary task that clients will have to undertake. How you go about getting that done can take many forms.

Should I import data?

This is a very difficult question to answer, but in most cases, the answer is Yes. In fact, it's almost always an emphatic "yes".
It may take a lot of work to get the data into a working import but it is worth the effort. At least with imported data, you have something to work with.
No data import could mean that it is years before you are completely utilizing the SAFE application to its full capacity.

Should I clean up the data?

You want your data import to be as clean as possible. It may take some time to get your data cleaned up but you want it to be as clean as possible.

Data Import Options

  • Manual Data Import
    You manually enter all your data into the SAFE application because there is no electronic version of your data.
    In this case, there isn't much we can do to ease the burden of this process. It might be a nightmare process but it's better to get it done than not.

  • Client completes import via data importer
    Some of our clients, with the proper technical expertise, might choose to do the data import themselves.
    SAFE support personnel will still be able to assist with the import, but you will do the bulk of the work yourself.

  • Tracker import as a service
    You provide all data to us in a very well-formatted XLSX or SQL (bak) file. Our preference is SQL file.

  • * Formats we will reject for data imports *
    1. Any file format other than XLSX or MsSQL bak file. The data must be in one of these two formats!
      1. 'Why don't you take .CSV' - While a CSV is seemingly a very basic file, there are generally all sorts of data conversion issues when bringing into XLSX or SQL especially when commas are prevalent within your text. There is also common issues with date / time formatting.
    2. Data without proper documentation. Many times it's impossible to figure out the data without a proper explanation of what we are dealing with.
    3. Entire data dumps where we get hundreds of tables but only need five of them. We can use this data but we will need to know what tables to work with.
    4. A dump of your data without any guidelines at all. We have to know what we are working with.