simdugas/childcare — pull request #4 by pannellr (2013-10-13 19:59:09+00:00)
Title: Rickey - file upload functinal

Hey man,

Here is a working version of the file upload.

The data is pretty dirty and instead of cleaning it all up I am going to send Aubrie a note about fixing some things like ages that are floats and multiple agencies with the same name.

This version is not perfect, but it will get you where you need to be to start doing searches.

Things that I have to do are:

sanitize the 2 date fields in the agency table and insert them
connect phone numbers and their types to the agencies
refactor the upload code into some smaller easier to read functions

I will upload a good version of the csv (without floating point ages and funny chars) to the repo so you can use that to load your db.

Happy holiday!

Rickey