[kwlug-disc] Tools to get data into a mysql database
rarsa at yahoo.com
Tue Mar 2 10:37:46 EST 2010
I meant : If you do TWO OCR scans you can then compare them.
Software, Hardware and Practices
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
> An eclectic collection of random thoughts
> --- On Mon, 3/1/10, Insurance Squared Inc. <gcooke at insurancesquared.com>
> > From: Insurance Squared Inc. <gcooke at insurancesquared.com>
> > Subject: [kwlug-disc] Tools to get data into a mysql
> > 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
> > 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
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