.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Extracting information from email and put it into a DB

Posted By:      Posted Date: October 24, 2010    Points: 0   Category :ASP.Net

Every morning we get a few hundred emails from our various customers servers that tell us how their backup went that previous night. Somebody has to go through these and fill out an excel spread sheet. I would like to automate this, we have our own server running a .NET application so i can schedule something every morning.

There are two main parts. The first is i want to know how to create a table that has customers down the left and dates accross the right, they are called pivot tables in access but not sure how to recreate them in MSSQL and to do it on the fly as i dont want to have to sit there entering 100's of days at a time.

The second is that differnt customers use differnt backup solutions, so i want to write some code that scans a particular mailbox in exchange, looks for emails that have come in in the past 12 hours, look at the from email address and match that to one in the database, then according to the subject line it will be able to identify what type of backup solution it is, e.g. if it says "Backup Exec Job completd Sucessfully" it knows its backup exec and will look for a particular text (completed successfully, completed with exceptions, no media etc) and can insert that, or if its a differnet backup solution then go and look at a specific place in that email for it.

I know this could be quite time consuming but any hel

View Complete Post

More Related Resource Links

How to send an email with information in query string


First I will say I googled (Binged to make Bill happy) for this but could not find anything, perhaps I am not stating what I need correctly;

I have a website that a customer creates orders (for a printing company) and after the order, I would like to email the customer a link to view the status of their order;

I need to send the CustomerID in the link so on the returning page if a CustomerID is detected in the querystring, I "auto login" the client and open the "Dashboard" for the order page for that customer.

Can anyone point me in the right direction as to how to send the link and how to parse the querystring to get the values from the link;

Thank you if you can point me in the right direction.

How do I add additional information to email message

I have a contact form that has the standard email fields such as name, email, street address, city, state, and body.  This is being done with System.Net.Mail.  I understand how to use the body, to/from address, and subject.  I don't understand how to include the street address, city, and state with the email though.  I want this additional information to be sent with the email some how so the recipient can have access to it.  I assume this should be included with the body when the email is sent.  I don't understand the best way to so this though.  I thought about appending the values of these fields to the body of the email.  I don't know how to format this so it looks good though.  The formatting I want to do is very basic.  I would like each of these values to be on a separate line before or after the body of the email.  I'm not interested in colors or anything too fancy.   I prefer to send a plain text email, if possible, if these values can be included on their own line.Can anyone provide an example or a link to an article on this?  Do I have to use an html formatted email and create new lines with in the body for these fields?

Document Library incoming email attachments not showing To/From information


I have a document library setup to accept incoming emails as attachments.

When I send an email the document library receives it, the only problem is it doesn't show any of the header information such as who sent it, who it was sent to, who was CC'ed.  Is there any way to have this information shown?

Basically what I'm expecting to see before the body message is the From, To and CC.

Any help would be most appreciated.

How to get more information about the exceptions that can happen in SharePoint 2010 projects?

In case there is an exception anywhere in the SharePoint 2010 project (most common place an exception would happen is during deployment of your SharePoint project, custom deployment configuration or custom deployment steps), there's a registry key EnableDiagnostics available for you to use.

PrintPocketCE Print Pocket Excel, Pocket Word and email files

Version 3.560 (May 15, 2009):

Important bug fix: a slight difference in how some devices create fonts was causing a few devices to have significantly longer print times for large print jobs.

Adjusted PocketJet printer paper feed commands

Other minor fixes and enhancements.

Version 3.559 (Mar 5, 2009):

Added support for Martel MCP78xx printers

Version 3.558 (Aug 20, 2008):

Added support for Martel MCP78xx printers

Version 3.557 (June 27, 2008):

Fixed error in Canon printer support

Fixed COM0 port selection

Version 3.556 (June 15, 2008):

Added support for Brother MW-260

Added support for Sato MB400

Version 3.555 (Aug 8, 2007):

Added support for Pentax RuggedJet 3 and RuggedJet 4 printers

Changed Epson TM-P60 support to maximum page width of 1200 dots

Version 3.551 (Aug 1, 2006):

Added Peripheral Nomad printer support

Version 3.550 (Mar 23, 2006):

Added Panasonic JT-H200PR printer support

Added Pocket Spectrum printer support

Fixed problem with WM5.0 "inverted image" problem

Send Email from SQL Server Express Using a CLR Stored Procedure

One of the nice things about SQL Server is the ability to send email using T-SQL. The downside is that this functionality does not exist in SQL Server Express. In this tip I will show you how to build a basic CLR stored procedure to send email messages from SQL Server Express, although this same technique could be used for any version of SQL Server.

If you have not yet built a CLR stored procedure, please refer to this tip for what needs to be done for the initial setup.

Sending a File Using Email Helper in WebPages/Razor


Note: This is particularly with respect to Email Helper in WebPages/Razor. Please don't post links using System.Net.Mail object.

Following this tutorial: http://www.asp.net/webmatrix/tutorials/9-adding-email-to-your-website

Under "Sending a File Using Email" section what exactly is the code trying to do.

1: The SendFile.cshtml does not have any option to select file.

2: ProcessFile.cshtml is running fine. I am getting the email but no attachement.

I tried changing fileAttachment input to type="file" but not file is being sent to my email. I just get the message send in body.

Question: How exactly this file attachment works using Email Helper in WebPages.

Linq - add data to database then email user the details


Hi all

I'm not sure how to structure the code for this but what I want to do is be able to add data to a database, and once this has completed successfully, then email the user to say the details have been added successfully to the database.

I need to:

1. Check that the relevant data has been added into the database then

2. Email the details of the relevant data when completed. 


Thanks in advance for your help,




Using CreateNewUserWizard SendingMail method to email me, not applicatnt.


I have staff area of my site I am protecting with forms authentication using c# and .Net 4.0. What I want to do is let the staff members register on the site but instead of the confermation email being sent to them I want it sent to me so I can go in and approve it. I have been trying to use the SendingMail method  but can not figure out how to get it to email me instead of the person that registered. I have searched around this site and find many topics on the SendingMail method but none seem to properly address my issue. Can anyone help me out?

Information about sessions


Some questions about sessions:

I know sessions information is stored in the form of cookie and you can use qurystring for that if you set cookieless session in web.config. But I don't exactly understand the scope of a session.

What I believe is when you login to a website, a session cookie is created and the scope of that session is within that page only. If you close the browser that session gets killed and when you open the browser again and go to that site then a new session is created ie a new session is created on every request. Is this correct?

But I have seen in many websites, even if you close the browser and open it again the session is not killed, how does that happen?

Can anyone clear out and explain the scope/lifetime of sessions


ERROR [HY000] [Informix .NET provider][Informix]Database locale information mismatch


Hi, there is an upgrade to my infimacs server and my web application encounter this error after the infimacs is upgraded.

Below is the information on the server before/after the upgrade.

Before            After

---------       -----------  

Solaris 8      Solaris 10

IDS 9.40     IDS 11.50

The web server where the web application hosted is running IBM Informix Connect 2.81. There is no such error before the upgrade is done.

As a developer, i have IBM Informix Client-SDK 2.90 installed on my local pc and debug the page where the read is needed from infimacs but no such error found.

The error come out only when it is hosted on the web server where IBM Informix Connect 2.81 is installed.

I have gone through many articles and it suggest me to set the environement  variable in the server :  DB_LOCALE=en_us.819.

I haven't try this solution but i think that this might not be the best solution.

Is it possible to to to have this settin

Fetching the Currently Logged in user Email


Hey Frnds,

I am using the System.DirectoryServices.UserPrincipal.Current.EmailAddress to fetch the Currently logged in users email from AD.

If  debug my sol am getting the Exact mail id of that Particular user for ex:john@in.domain.com.

If i host My Application on iis

And Access my App am getting some other Email id instead of the john@in.domain.com.

I have changed the Application Pool identity to NetWorkService.

Can any one tell what could be wrong




email notification error 5.1.1


 I am getting an error when sending email via asp.net.  The error is "Mailbox unavailable. The server response was: 5.1.1...User unknown."

However, the email is getting sent.  Why is asp.net returning this error?

I'm using VS 2008, vb.net,  running 2.0 framework.  This happens regardless of whether I'm testing my application from my local machine or running production version.  Also, I can send a batch of emails and get the error for some but not all.

I would like to be able to count of the error messages really being accurate, so this situation is unhelpful to our users, because they will start to just ignore all error messages.




Email Help (System.Net.Mail)


Hi I have a annoying problem. 
I have created a page which takes users details for a quote.

I have then created the form to be emailed to both the user and myself. (Which works fine ATM)

However I would also like to be able to attach a file containing terms and conditions to the email.

I have tried doing this using 

EmailMsg.Attachments.Add(new Attachment("C:\\attachme.txt"));

But everytime that line of code is hit it fails and is caught by my try catch.

Take that line out and the email sends fine, put it in and it breaks the whole page.

Am I missing something really obvious?

need information about ironpython



 i have installed visual studio 2008.it works fine

now i want to try ironpython. :)

so please give me details of step for installation and which sources require to start ironpython in visual studio 2008.



.NET Visualization: Visualizing Information with .NET


Having the capability to draw pictures usually isn't enough for a good information visualization platform. The key to building a visualization platform is capabilities such as interactivity, generating metadata, and overlaying related data. You need a level of flexibility that lets you render any data in any way at any time.

Laurence Moroney

MSDN Magazine August 2009

Office Development: Manage Metadata with Document Information Panels


Here the author uses Document Information Panels in the Microsoft 2007 Office system to manipulate metadata from Office docs for better discovery and management.

Ashish Ghoda

MSDN Magazine April 2008

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend