I gang

E-mail Parser running as Windows Service

SUMMARY

Project is about upgrading/creating a Windows Service that will parse data-emails from an e-mail account, and store their data into a database on Microsoft SQL Server. A working code base from a similar project already exists, but this must be modified (VB.NET project incl. binaries) .

TIME ESTIMATE & DEADLINE

This project can be completed in less than 1 day by a skilled developer. Project must be completed within a maximum of 8 days.

BACKGROUND INFO

The purpose is to supply data to our visitor monitoring webapplication which is already in operation. Data are captured by controller boxes in the buildings, that sends data by mail to a mail account. A Windows Service on our server periodically downloads and parses the mails, and stores their visitor data in the database titled xxxxxx-xxxxx-2x > tbl.Observations.

Fortunately we already have a Windows Service coded on a completely different project that can be easily modified to what we need.

DO THE FOLLOWING

1. Log onto our issue tracker and view the ticket incl. attached video for a general explanation & overview.

2. Familiarize yourself with the emails that you must parse by logging into mail account.

3. Familiarize yourself with the front end system on the demo server.

4. Familiarize yourself with the backend Windows 2008 Server. Remote desktop to: xxx.xxx.xxx.xxxx.

5. Similar mail parser project from KKEDI3X has been duplicated to KKEDI2X to this location. Check out the code to your local machine from our springloops SVN using tortoise og similar SVN client.

6. Modify it to parse one-by-one each mail on and store its data using the following logic :

a) Read the IMEI (PLCId) from the email (marked with underline):

$#UTC09:59:59-IMEI-355797032022248[at]28.05.2014-12:00|26|12|44|#*1A

b) Use this to determine the corresponding Location ID by looking into tbl.Locations. In this table the IMEI is present in the last column titled 'PLC-ID and consequently you can determine the Location ID which is in the tables first column.

c) Then use the above Id to determine the corresponding 1-3 (objects that we will store data onto) by looking into tbl.Objects. In this table the LocationId is present in the last column and consequently you can determine the 1-3 Object ID's which is in the tables first column.

d) Now for each Object ID found above, write 1 row into [url removed, login to view] based on the combination of the emails encapsulated data and the info found in 2. & 3:

SYNTAX: [Id][ObjectId][oDate][oTime][oValue]

[Id] Autogenerated

[ObjectId] Captured in above point 2. & 3.

[oDate] Extract from the mail ([at]28.05.2014-12:00|26|12|44|) and store in format 20140528

[oTime] Extract from the mail ([at]28.05.2014-12:00|26|12|44|) and store in format 120000

[oValue] Extract from the mail:

For Objects with ObjectSubTypeId=1 store this underlined value divided by 2: ([at]28.05.2014-12:00|26|12|44|). So in this example store the value 13.

For Objects with ObjectSubTypeId=2 store this underlined value divided by 2: ([at]28.05.2014-12:00|26|12|44|). So in this example store the value 22.

For Objects with ObjectSubTypeId=3 store this underlined value divided by 2: ([at]28.05.2014-12:00|26|12|44|). So in this example store the value 6.

NOTE: These 3 numbers are actually visitors entering and exiting door 1, 2 and 3 in the building (sometimes there are just 1 or 2 doors). We need to divide the numbers with 2 because 1 entering+1 exit = 1 visit.

e) Copy your locally working Windows Service to TST10 Server (.200) and test by parsing a couple of mails.

Færdigheder: ASP.NET, Microsoft SQL Server, VB.NET

Se mere: write an e mail, we looking for sql server developer, time tracker desktop, remote front end developer, project deadline tracker, og&e, looking for sql developer remote, logic supply, front controller asp.net, e value, asp store front, asp.net controller, tortoise svn, sql less than, plc code, plc service, windows service, windows 2008, webapplication, svn server, mail client, front end developer remote, email parser, e-mail database, e ticket

Om arbejdsgiveren:
( 11 bedømmelser ) Copenhagen, Denmark

Projekt-ID: #6003554

Tildelt til:

ltfdigital

Hello We are a small digital agency located in Novi Sad, Serbia. In our team, we have a highly experienced software engineer, who is also highly skilled in debugging and maintenance of existing code. We are sure he Mere

$210 USD in 5 dage
(0 bedømmelser)
0.0

6 freelancere byder i gennemsnit $245 for dette job

biddyweb

I can develop within 5 days or less. I would need access to a sample email account or the main account, the database. I would prefer to do this in c#. Kindly contact me and lets discuss more.

$400 USD in 5 dage
(0 bedømmelser)
0.0
jasminery

Question: - the email is in POP3 or IMAP - the windows service would be for server or desktop? - what windows operating system?

$184 USD in 3 dage
(0 bedømmelser)
0.0
acronymsolutions

Hi, I have gone through your descriptions,I understand it thoroughly,I am 5+ years experienced ASP.NET,C#,SQL Server developer at CMM5 level company.I can do your job easily before your deadline . I am very much Inte Mere

$315 USD in 7 dage
(0 bedømmelser)
0.0
mainpoint

Hi, I have experience in doing similar tasks. I can do this task quickly. Thanks and best regards, Ramakrishna

$111 USD på 1 dag
(0 bedømmelser)
0.0
shallufreelancer

A proposal has not yet been provided

$252 USD på 1 dag
(0 bedømmelser)
0.0