[Tfug] OT: Fairly simple relational database quick job bids...

[Don Freeman]

This is fairly straight forward. Does the result file contain 1 row per
person or 1 row per person/event combination?

IE
Person1, event1, event2, event3, etc.

Or

Person1, Event1
Person1, Event2
Person1, Event3
Etc.



-----Original Message-----
From: tfug-bounces at tfug.org [mailto:tfug-bounces at tfug.org] On Behalf Of Jim
March
Sent: Friday, October 01, 2010 10:48 AM
To: Tucson Free Unix Group; Main PLUG discussion list
Subject: [Tfug] OT: Fairly simple relational database quick job bids...

Folks,

I need a contract on what we think is a fairly simple relational
database problem.

What he's got is "raw data" somebody to chew on.

He has two .CSV files.

The first is 112megs, listing people and details about them as a
single line (record).  There's a unique ID number in one field.

The second is 100megs, with each record only three fields long.  The
first field contains the unique ID number, the second contains a
number for an event they participated in, the third is not really
relevant.  For each person there will be several lines (records).

Example:

1234543,2
1234543,5
1234543,6
1234543,7

This tells us that voter 1234543 was involved in events 2, 5, 6 and 7.

One complication: it's common for the data on events to contain a ID
number of "123456" where the main data on the people lists the ID
number as "00123456".  That'll have to be parsed somehow.

What we need is all this combined into a flat database, still a .CSV
so he can import it into Filemaker Pro.  In other words, it'll have
extra fields showing which events this particular person was involved
in.

I'm thinking probably a simple bash script could do it, or use the
database tool of your choice with .CSV output.

There would be a strict non-disclosure on this - nobody is supposed to
ever sell this mailing list for commercial purposes.  You'll get it in
an encrypted .ZIP file and give it back that way, passwords
transmitted by phone.

What would this cost?

Thanks!

Jim

_______________________________________________
Tucson Free Unix Group - tfug at tfug.org
Subscription Options:
http://www.tfug.org/mailman/listinfo/tfug_tfug.org