Azure C# Gmail extractor and test application

Please read fully. We will not accept bids that are generic responses.

The end goal of this project is to build and keep updated a centralized database of all user emails (from gmail) across the company. Next, do some analytics on the data, and keep it updated.

We need an Azure application that builds a database and a test application for reviewing the data.

The system needs to:

-Authenticate the azure service with the users gmail

-Keep track of users. A list of users should be visible in the test application. Add/delete a user through the test application.

-Each user authenticates with the Azure Service/gmail, so the service can automatically connect and access all email folders

-First pass, the server gets all archived and current emails across all folders

-Regularly the system connects and gets processes emails. Test application should have an “update” button which processes all updates.

All emails should be stored in a MSSQL database. The test application should be done in C# using the .NET framework. The test app will connect to the database.

After each user’s email is collected, the emails should be processed to determine the total count of emails sent and received to/from each person. This will be a relationships table associated with each user.

Example: if john AT [url removed, login to view] (john) is the user and he sent 22 emails to frank AT [url removed, login to view] (frank) and frank sent john 12 emails, then the following values would be detailed

frank AT [url removed, login to view]

sent = 22

received = 11

The test app is for reviewing data. It needs to show the following grids:

-MainAll: Grid of all emails, by organization and by user: org, user, from, to, from, cc, bcc, subject, body, attachments (body can be detail memo field, attachments should be clickable to open.)

-ViewUser: For the selected user in ViewAll, show every unique email with sent/received stats

-ViewOrg. For each selected user in ViewAll. show the combined sent/received (all user stats) across all users

Each time the service updates (processes recent emails) the to/from stats should be updated. Make sure the system allows any gmail user to be added to a group/org (they may not be part of a specific domain).

The service needs to be able to scale to many users, so plan accordingly.

If you have had experience with Azure/C#/gmail apps and similar projects, let us know specifically. The GUI in the test application needs to be functional, not user-facing. Focus on functionality & the ability to see the data from different angles.

Skills: .NET, Azure, C# Programming

See more: time track application, programming ability test, gui test plan, goal programming example, gets in c programming, gets c programming, generic programming, generic data access, c sharp test, c # sharp test, c sharp service, c read example, c# functional programming project, c# functional programming, c gui programming, net c# azure, data extractor, c# MSSQL, c# azure, azure, azure database, azure app, read email gmail, gui framework net, gmail database list

About the Employer:
( 83 reviews ) Oconomowoc, United States

Project ID: #6929331

Awarded to:


hello sir, first of all I have bid too much high to get your attention towards my bid only. we can discuss price later no hurry. I have 2 year of experience in azure technology. also for my one of offline client I ha More

$800 USD in 15 days
(2 Reviews)

10 freelancers are bidding on average $848 for this job


Hello Sir, We have experienced programmers [url removed, login to view] have worked in C# project. How can we discuss about job? Here is the link of feedback "[url removed, login to view]" We would like to work More

$736 USD in 10 days
(116 Reviews)

Hello.... I have gone through your requirements and have understood it partially. Few Questions 1. How emails will be inserted? 2. How application will get data regarding email communication? Brief info ab More

$526 USD in 10 days
(82 Reviews)

Hi there, What you want to do is in two parts. 1) Harvesting the gmail emails and putting them into a database 2) Running this on azure. 1. Backend can be realized as a separate stand alone program that will run More

$555 USD in 10 days
(48 Reviews)

Hi, We’ve had a good look at your project description and we’re very interested in providing a solution. We are a professional development company head-quartered in Pakistan. If you like what you see and if our qu More

$750 USD in 15 days
(23 Reviews)

Hi, I understood your high level requirement. I am interested to work on this project. I have 6+ years experience in software development and customization using wide range of Microsoft technologies (C#, ASP.NET, MV More

$688 USD in 25 days
(29 Reviews)

Hi, Please feel free to discuss the project with me ............................................................................ Thanks, Murtaza

$650 USD in 14 days
(11 Reviews)

Hi, I have done two projects that store emails in a database. One of them is a windows service written in C#. It was for a legal software and the purpose of the service was to find emails that contain file reference More

$750 USD in 30 days
(9 Reviews)

Greetings, Happy new Year :)) Experience: Azure 1.5 years /C# 10 years gmail apps - 0 and similar projects - 3 years It seems that what your team is doing is a proof of concept of a bigger project or some More

$2777 USD in 30 days
(2 Reviews)

Skype: expertweblady 'I am a private freelancer thats why I have no reviews because I usually got my clients from other freelancers company such as craigslist, easyoutsource, onlinejobs, warrior forum.. Somebody tol More

$250 USD in 10 days
(0 Reviews)