PDA

View Full Version : DATABASE Experts needed (Compiling CSV Files)




Oliver
12-29-2007, 05:39 AM
Are there some Database experts in here who are able to sort out doubles
within the E-Mail-List and to convert the CSV-File into a valid CSV-File to import
it into this Free-Ware Mail-Program?

Mail-Program:
http://monomailer.sourceforge.net/

.CSV-File:
http://www.mediafire.com/?5z4iugmcjnc

Ron LOL
12-29-2007, 05:43 AM
If you're on a *nix, the uniq utility will do most of what you're asking.

Oliver
12-29-2007, 05:45 AM
If you're on a *nix, the uniq utility will do most of what you're asking.

Nix ??? :confused:

Is that a Email-Program? Are you able to get the CSV-File working with
the Mail-Program I posted? :)

Oliver
12-29-2007, 06:07 AM
*blimp* for the IT-experts in here...

einjun
12-29-2007, 06:11 AM
Nix ??? :confused:

Is that a Email-Program? Are you able to get the CSV-File working with
the Mail-Program I posted? :)


*nix refers to unix/linux/bsd and related opearting systems ........

I'll see what I can do to make a neat csv file out of it. there are mutiple ways of cleaning it up but my laptop doesn't have much software or hardware.

Oliver
12-29-2007, 06:12 AM
*nix refers to unix/linux/bsd and related opearting systems ........

I'll see what I can do to make a neat csv file out of it. there are mutiple ways of cleaning it up but my laptop doesn't have much software or hardware.

That would be awesome, Einjun. :)

einjun
12-29-2007, 06:24 AM
That would be awesome, Einjun. :)
working on it .........
least i can do for a a good cause r3volutionary :-)

Thumper
12-29-2007, 06:50 AM
Here ya go:

Cleaned up MediaMails (http://download.yousendit.com/917A84785F8706BF)

I have included four files in the zip. One CSV, One Tab Delimited, One Excel Spreadsheet, One text file with emails seperated by a hard return. Load into your SMTP mailer of choice and let the party begin.

Oliver
12-29-2007, 06:56 AM
Here ya go:

Cleaned up MediaMails (http://download.yousendit.com/917A84785F8706BF)

I have included four files in the zip. One CSV, One Tab Delimited, One Excel Spreadsheet, One text file with emails seperated by a hard return. Load into your SMTP mailer of choice and let the party begin.

Awesome! :D Thank you for making this work ... Even if I don't
know if the Freeware-Mailer works. It says :"Mail sent", but my
Firewall didn't respond - so I don't know if it worked or not...

Thumper
12-29-2007, 06:59 AM
No problem, if anybody else needs any of this kind of stuff done...let me know. I used to be a Sales/Marketing DBA and Marketing Programs Manager for a software company in Austin. This is kinda what I know...the messier they are, the more fun they are(within reason).

einjun
12-29-2007, 07:11 AM
cool, good job thumper
for what it's worth, here's my cleaned and sorted csv file. Since i don't have excel or any db on my laptop i wrote a java program on notepad :-(
http://rapidshare.com/files/79841668/list.csv.html

einjun
12-29-2007, 07:12 AM
Awesome! :D Thank you for making this work ... Even if I don't
know if the Freeware-Mailer works. It says :"Mail sent", but my
Firewall didn't respond - so I don't know if it worked or not...
just send a mail to all your own email addresses to test ;-)

Oliver
12-29-2007, 07:13 AM
just send a mail to all your own email addresses to test ;-)

:D Did it work? I'm suspicious because my Firewall didn't confirm it ...