[kwlug-disc] Tools to get data into a mysql database

Raul Suarez rarsa at yahoo.com
Tue Mar 2 10:37:46 EST 2010


Typo correction:

I meant : If you do TWO OCR scans you can then compare them.

Raul Suarez

Technology consultant
Software, Hardware and Practices
_________________
http://rarsa.blogspot.com/ 
An eclectic collection of random thoughts


--- On Tue, 3/2/10, Raul Suarez <rarsa at yahoo.com> wrote:

> From: Raul Suarez <rarsa at yahoo.com>
> Subject: Re: [kwlug-disc] Tools to get data into a mysql database
> To: "KWLUG discussion" <kwlug-disc at kwlug.org>
> Received: Tuesday, March 2, 2010, 10:19 AM
> Given your description I am inferring
> that the data is not in a digital format.
> 
> You could 
> A) Digitalize and load
> 1. Scan it and OCR it post processing it column based into
> a CSV file, probably using sed.
> 2. Use the MySQL tools to load the tables
> 3. Proof read it (may be faster than typing)
> 
> My first job was at a data entry company, my job was
> writing programs to clean up the data.
> 
> There I learned that double entry is a very good way to
> ensure cleanliness.
> 
> If you do to OCR scans, convert to CSV and then compare the
> two files, you will be able to find discrepancies using diff
> or a similar tool.
> 
> B) Enter it manually.
> 1. In Open Office Database, connect to your MySQL database
> 
> 2. Enter the data either in a table form or if there are
> fields with value sets then a form with drop downs (may save
> typing time and errors)
> 
> Raul Suarez
> 
> Technology consultant
> Software, Hardware and Practices
> _________________
> http://rarsa.blogspot.com/ 
> An eclectic collection of random thoughts
> 
> 
> --- On Mon, 3/1/10, Insurance Squared Inc. <gcooke at insurancesquared.com>
> wrote:
> 
> > From: Insurance Squared Inc. <gcooke at insurancesquared.com>
> > Subject: [kwlug-disc] Tools to get data into a mysql
> database
> > To: "KWLUG discussion" <kwlug-disc at kwlug.org>
> > Received: Monday, March 1, 2010, 6:29 PM
> > What kind of tools are available to
> > get a decent sized pile of data into a mysql database
> via
> > keyboard?  i.e. I've got tables full of rows and
> > columns of data that I have to input via a keyboard
> and end
> > up as a nice mysql database.
> > 
> > g.
> > 
> > 
> > 
> > _______________________________________________
> > kwlug-disc_kwlug.org mailing list
> > kwlug-disc_kwlug.org at kwlug.org
> > http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org
> > 
> 
> 
>      
> __________________________________________________________________
> Make your browsing faster, safer, and easier with the new
> Internet Explorer® 8. Optimized for Yahoo! Get it Now for
> Free! at http://downloads.yahoo.com/ca/internetexplorer/
> 
> _______________________________________________
> kwlug-disc_kwlug.org mailing list
> kwlug-disc_kwlug.org at kwlug.org
> http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org
> 


      __________________________________________________________________
The new Internet Explorer® 8 - Faster, safer, easier.  Optimized for Yahoo!  Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/




More information about the kwlug-disc mailing list