Show Bid Request
Check POP3, running as service on W2K
Bid Request Id: 25317
|
|
|
|
Posted by: |
vio (9 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Above Average - 33.33%
|
|
Posted: |
Aug 24, 2002
2:01:32 AM EDT
|
|
Bidding Closes: |
Sep 7, 2002
2:07:59 AM EDT
|
|
Viewed (by coders): |
348 times
|
|
Deadline: |
9/22/2002
TIME EXPIRED
|
|
|
|
|
Description:
The program will run as a service in W2k with the following functionality:
Read a configuration file, configuration files enclosed with this project. You can change it or extend it, as you feel fit.
Check a Pop3 for emails, every x minute's base on the configuration file
Run a store procedure (CheckUploadEmail), which pass as a parameter the subject of the email. The store procedure will return two integers and a path.
Base on the return of cmd parameter the following things happen:
1 if SP return 0 save the attached file log the activity with InsertEmailDownload and exit
2 If sp return 1 save the attached file send a confirmation email (see below) log the activity and exit
3 If sp return 2 disregard the attached file and send an email (see below)
4 If sp return 3 forward the email to a new address which is stored in configuration file
Note the saving of the attachment is going to be over the network (from the W2K machine to a different machine which can run Linux), I do not thing this is a problem, but just in case.
When the program has to send an email, the message for the email is coming from a second store procedure (GetMsg) that has as parameter the second integer from the first store procedure.
Please note you need library for the POP3, to decode the attached files and to send an email via SMTP (the value of SMTP is stored in config file). All libraries shall be in public domain.
I'm not interested to write all this components, use the public domain code and provide this functionality.
The store procedure will be runs again SQL Server, so you have to be familiar with ADO too.
Here is the definition of the store procedure to run.
First store procedure will check the email parameter is the subject of the POP3 email:
CheckUploadEmail email, cmd, MsgID, LngID, Path
Where
Email (varchar(60) is the subject line of the original email
Cmd (tinyint OUTPUT) are the 4 option explained above
MsgID (int OUTPUT) message ID, parameter for the second sp
LngID (char(3) OUTPUT) parameter for second sp
Path (varchar(1024) OUTPUT) is the path where the file have been saved
Second store procedure (to receive the message)
GetMsg MsgId, LngID, Message
Where
MsgID (int OUTPUT) message ID, parameter for the second sp
LngID (char(3) OUTPUT) parameter for second sp
Message (nvarchar(4000)) the message for the email. Note that is returning Unicode message (nvarchar)
Deliverables:
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
Complete copyrights to all work purchased.
Platform:
VC++, SQL Server
Must be 100% finished and received by buyer on:
Sep 22, 2002 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
|
|
$60 (USD)
|
Aug 24, 2002
3:47:22 AM EDT
|
10
(Excellent)
|
|
|
Hi ,
I am interested to work in your project
already have developed pop3 checker
If you require a demo it is ok for me I can prepare it
Working with ADO too is ok without any problem
Also developed a library that can decode base64
The application service will run in win2000 environment
You require SMTP it is ok for me
But I have a better idea that we can use CDONTS NewMail object if you like I have no problem with SMTP but just a suggestion
Also give you my vision, as I understand the project
The service will read a configuration file
The service after checks the e-mail and finds a new message save it to SQL server table including encoded attachments. Is that right or what is the relation between the incoming message and SP?
Run stored procedure which
CheckUploadEmail email, cmd, MsgID, LngID, Path
Email: subject of e-mail
cmd: returns (0 1 2 or 3)
MsgID:returns msgID
path: path to save attached file (s) (what if it is more than 1 file) also i did not work with Linux but i think no problem with that i will write the file and system will manage it?
LngID: i do not understand what that used for?
second stored procedure:
GetMsg MsgId, LngID, Message
MsgId ok
LngID ??
Message the messagge body (include encoded attached file????)
need more informations
I believe I can develop this project for you
thank you for take time read this |
|
|
|
|
|
|
waelahmed