Data conversions. Previously, I was in charge of converting data from legacy systems into an Access database. Upon realizing the tightly bound nature of .Net database objects, I had a problem on my hands. How could I convert 2,000+ databases by myself when each had minor version differences and ran 8-24 hours?

I solved the problem by inventing idxObjects. They are not tightly bound. The run regardless of minor field changes. In fact, a one to one relationship conversion is a simple as pie.

But, life is not so easy. There are relational keys to deal with.

Consider the task for a moment. You have a customer table. It links to a multiple record email table. In a standard conversion you have to query each key back to the customer table, or make an enormous multiple row record set, containing extra data.

Either alternative takes far too long (overnight), with a good chance bad data will break everything. In fact the process used to take 8 hours (x 2,000) - quite a years work.

So, I created binary lookups for idxObjects. When the data is read, the original and new key are loaded into an object. The data is sorted and an indexed binary lookup performed.

Doing this reduced the run time to just 20 minutes! The interesting thing about the idxObjects sorting method is it only sorts keys. The data is held in place, which means it's very fast.

You'll notice the speed of binary indexed searches in action as DocuGrab retrieves it's dictionary entries. It doesn't reload data. It just sorts data keys, keeping the massive data array intact.


Now consider this: Your business may need to convert text reports, column delimited text files email receipts, etc.

I have years of experience breaking down non-traditional data sources making them database compliant.

For an example, take a look at DocuGrab, it parses text to individual words and builds an indexed database.

I can parse most receipts, reports, and other computer generated text files and place them into a format suitable for importing.

If you have the need of my services, please contact me. you.

Currently, I am available for short data conversion projects.