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.
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):
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:
[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.
6 freelancers are bidding on average $245 for this job
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.