I am currently managing a large mailing list in Excel. The file has become too large to handle comfortably (17 columns, 60,000+ rows) and new entries are being added regularly. I am looking for a better way to manage this, possibly a database. I need the database to be configured, and the current data to be added to it. I also need a form to make data entry easier, with automatic checking for repeat records and for correct email address syntax. In addition, I need the ability to pull lists of data sorted in certain particular ways. I would like to be able to have this database on a server, with different workers adding data simultaneously, and reports being run / fields being updated simultaneously. Any suggestions to integrate this with mass-mailing software with easy management of unsubscriptions, etc. will be welcome.
## Deliverables
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the worker's Worker Legal Agreement).
2) The database should be accessible from both Mac and Windows computers. The full database should be able to be downloaded for backup and/or local processing. 3) There may be a need to add a few more columns to the final project (up to 5 more I guess). 4) Example of typical report I need to produce: Non clients from certain country or countries and/or using certain currency and/or speaking certain language who are not unsubscribed or otherwise marked not to receive further emails, who were added to the database after certain date or who were not sent another email since a certain date. I need to be able to see the full list (not full address or phone, just country, but most other fields in view), then easily extract email addresses and first names, use them to send new emails, easily update database with new email sent and date, and easily record returned (undeliverable) mail, new unsubscriptions, and addresses with spam settings that don't let us through. Basically I need to be able to monitor the progress of data entry workers (sorting by worker name and date) see what entries we are getting from which source, and all the normal functions that a database of this kind is expected to permit. I need to have it installed and I need to test it until I am satisfied that it works as expected. If you need any more information before you can bid for the job, please send a message and I'll be happy to respond.
* * *This broadcast message was sent to all bidders on Wednesday Jun 9, 2010 3:28:58 PM:
Having received several bids, I agree that the way to go is a MySQL database with PHP admin forms.
I can't attach my Excel files here, as many of you have asked, but I will detail what they are, so you can consider this when you calculate your bids.
I have two Excel documents. The main document, which has 60,000+ entries, has the following columns:
A Email address
B first name
C country
D currency
E source (where I got their address from)
F when collected (date when added to mailing list)
G collected by (name of worker)
H label (values may be: 1 REMOVE; 2 EMAIL FAILS; 3 EMAIL RETURNED FOR SPAM; 4 REDUNDANT, NO LONGER IN BUSINESS, or IRRELEVANT; 5 CLIENT; CLIENT WS (wholesale client);NONE
I Last mail sent (where I write what offer or newsletter I sent, and when).
This list is quite clean, although there are still some invalid addresses and sometimes I have a few addresses for the same person or business, and this is not currently picked up (I would like to handle this better).
The second list incorporates new columns that I would like to have from now on (such as street address, phone numbers, etc.) Currently not many records on this list (1,000). I would like to merge the two lists into the new database. I would like repeated records to be identified and merged into one, and unique records from both lists to be kept, of course.
In the second list I have the following columns:
A Studio (business name)
B First name
C Last name
D Email
E Main phone number
F Secondary phone number
G Address (street, number, city and state)
H Country
I website
The columns Currency, Source, When collected, Collected by, Label and Last mail sent should still be added to this list.
In your proposals, please let me know, once the system is functional, how will I process returned mail and those that are not delivered because the recepient's system treats as spam (so I don't keep sending emails to an address that fails); can it handle unsubscriptions automatically; can it take opt-in data directly from a user.
When entering new data, how will the system validate email address syntax and how will it detect a repeated record (with the ability to let the user complete the original record, if it was incomplete).
Thank you
## Platform
not sure, to be discussed (depends on server?)