What to do with lots of CSV files

Hello all,

I've asked this on a couple of Open Office forums, and not received much
help. I know it's not an Ubuntu question, but given the excellent
responses to the "Getting addresses OUT of a spreadsheet" thread, I
thought I should ask here.

Every week, I receive a CSV file which has a between 3 and 50 people's
names on it who I should contact. Some of these people have email
addresses in there, some have snail mail addresses, most have relevant
dates etc. At the moment, I'm finding these lists unusable and the
thought of going through them all manually is just too intimidating.

Is there a way to set up Base (or any other part of OpenOffice, or any
other apps) that could make all of this information more user friendly?
Could it, for example, just give me a list of all people to contact and
all of their relevant dates? Which ones are to email and which to write
to? Maybe even automate the mailing somewhat? And then do the same thing
with the next file and create a big database of information?

Could I then combine this with my own contacts database (which I've
never actually set up yet .. still using text files in a folder) to have
a database of people and to know when my last contact with them was, who
do I need to chase up? Maybe tag people with X, Y and X options of what
needs to be done with that contact.

Hope all that makes sense and that someone can help me out. I've got so
far with an individual file in testing, but doing this with multiple
files was beyond me and the rest I had no idea at all about.

Maybe I'm trying to be too ambitious and should try to do mail merge
directly with the CSV files (are letter and email mail merges possible
from csv files?) and forget the database bit?

Thanks for your time
Damian

--
ubuntu-users mailing list
ubuntu-users@xxxxxxxxxxxxxxxx
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

Relevant Pages

  • Re: What to do with lots of CSV files
    ... I know it's not an Ubuntu question, ... I'm finding these lists unusable and the ... If the CSV files have a standard field order and field separator, ... information into a database to your liking. ...
    (Ubuntu)
  • Re: Database / Loading CSV file into a HP48
    ... and what a "database" means, ... If it means a spreadsheet, with some export/import abilities, ... "Lists of lists" are not as easily handled natively ... My CSV files are exported from Excel, one record per line, each record ...
    (comp.sys.hp48)
  • Re: Getting a list of list permissions for WSS
    ... this on a backup copy of the database so you're not hitting the live DB. ... Now when you run the script and refresh the SPS Event List which this ... my departmental Event Lists roll-up flawlessly to a single Portal list. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: The Sorrows of Record Cataloguing
    ... but the database ... needed was a list so that I wouldn't buy records or CDs over again. ... to see on the shelves and were in alpha-order by composer. ... recordings, there is an entirely different set of lists -- five lists, ...
    (rec.music.classical.recordings)
  • Re: Are you one of the EIGHT MILLION who will be arrested when Bush declares martial law in October?
    ... Called "Main Core," the database's origins date back to the 1980s when ... "There exists a database ... of Americans, who, often for the slightest and most trivial reason, ... called someone on those lists, you get added to the master list. ...
    (alt.politics)