Data processing
The modern world utilizes many different formats for storing data. Sometimes you get the file in one format and need to convert it to another format in order to use it with your application.
We can convert data between almost any known formats, including, but not limited to: xml, dbf, csv, txt, html, pdf, xls, doc, mdb and others.
There are times when you need to import some data to a database, but the file format your data is stored in, is not supported by this particular database. The situation can also be quite opposite when you need to export data but your database does not support the file format you need to export data to.
We can help you import and export data to / from any format or import data from another database (from Oracle to MS SQL Server, or from XML / Access / Excel to MS SQL Server).
We can also clean and normalize your data by developing custom scripts and handing them to you for future use after normalization is finished.
For example, you have customer data you obtained through your web site and some customers incorrectly stated their ZIP code or street address. We can develop scripts that will match ZIP code and street address information with a street names database of your city and automatically fix most of the incorrect records.
Records, which cannot be fixed automatically (usually less than 5% of incorrect records), will be fixed manually.
After cleaning your data, we will provide you with all the scripts used in the conversion along with documentation on how to use them in the future. The best part is we don't charge anything for this, only the time spent on cleaning will be charged.