Account Database

已完成 已发布的 Oct 13, 2008 货到付款
已完成 货到付款

I need a very simple db/management system that allows me to forward emails from my inbox which will in turn create a database listing from the subject line, the from address, and the body of email as field in the database.

It can be a simple file with indexes on who and the company name.

note: this can be a stand alone application. For example, an extension of Outlook with an MS-Access dB on the back end. All of this can reside on a dedicated machine.

## Deliverables

Here are the steps I want my partners to be able to use:

1. Get an email from company X. Subject line can be anything, doesn't matter.

2. They forward the email to bizop@xxxxxx.

3. They change the subject line to just the name of the company.

4. They remove any attachments (they are ignored anyway).

5. They press the send key.

The email hits the contact system. It only accepts email from a specific set of domains and simply ignores all others. I can input the domains to accept email from.

1. The email is parsed into four 'fields': date, partner, company, information.

date = email time stamp

partner = the from email address

company = the subject line

information = the plain text version of the email body.

2. A look up is performed on the company name. If the name exists already, and automatic email is sent back with the text "company is already in contact with us" as body of the reply. With the next line being company name/partner data fields.

3. The process will then end. You do not create a second record or add anything to the record which exists. You just stop the process at this point.

4. If the look up is performed and there is no company record which exists, you create an automatic reply with the words "record successfully added" and the next line being company name/partner.

5. The process with then end.

The database has indexes on company name and partner.

The other email query requirements:

a. email to the dB with subject line:"query: company name". The auto reply is either a no company found or the company in db answer as above with company name and partner.

b. email to db with subject line: "list all" which gives an auto reply consisting of text based email showing company name/partner

c. email to db with subject line: list partner" which gives an auto reply consisting of a text based email showing just a particular partner's name and companies associated with him.

* * *This broadcast message was sent to all bidders on Monday Oct 13, 2008 5:59:23 PM:

An update to the bid request. This project can be done as a stand alone email responder. By this I mean that I can/will set up a dedicated PC to run the application created. It can be an Outlook Plug-in with an MS-Access back end. This is fine. This does not have to be a web based service or hosted if it is easier to build as a stand alone applications/service. I control the email system and the PC so I can set anything up. The objectives remain the same.

PHP

项目ID: #3305894

关于项目

27个方案 远程项目 活跃的Oct 14, 2008

授予:

dpovshed

See private message.

$509.15 USD 在14天内
(46条评论)
5.9

有27名威客正在参与此工作的竞标,均价$620/小时

arhamsoftltd

See private message.

$425 USD 在14天内
(137条评论)
8.7
hwanghendra

See private message.

$425 USD 在14天内
(381条评论)
7.3
fastudiovw

See private message.

$467.5 USD 在14天内
(584条评论)
7.2
mywhitelotus

See private message.

$510 USD 在14天内
(111条评论)
6.3
neo010

See private message.

$722.5 USD 在14天内
(103条评论)
6.1
mujtabapanjwani

See private message.

$425 USD 在14天内
(77条评论)
6.1
amrelgarhy

See private message.

$425 USD 在14天内
(77条评论)
6.2
allenjonessl

See private message.

$2125 USD 在14天内
(191条评论)
8.1
slavisatosic

See private message.

$425 USD 在14天内
(93条评论)
5.9
abstractsagacity

See private message.

$425 USD 在14天内
(34条评论)
5.9
asawyer13

See private message.

$425 USD 在14天内
(41条评论)
5.7
mdsoftsl

See private message.

$493 USD 在14天内
(10条评论)
5.0
vw6977538vw

See private message.

$425 USD 在14天内
(93条评论)
5.1
thewebspidy

See private message.

$595 USD 在14天内
(10条评论)
4.8
shahidbabar

See private message.

$425 USD 在14天内
(27条评论)
5.0
maruidea

See private message.

$425 USD 在14天内
(12条评论)
4.7
whitelightervw

See private message.

$1530 USD 在14天内
(14条评论)
5.0
rsmerker

See private message.

$425 USD 在14天内
(10条评论)
4.1
sestoculo

See private message.

$425 USD 在14天内
(6条评论)
3.3
vw921vw

See private message.

$1275 USD 在14天内
(2条评论)
3.5