Only experienced coder with data scraping &.NET environment need to respond. The work is explained below:
1) Log into a Microsoft Exchange email account. Go to the folder, scrap new messages and dump the content into 1 or more tables of the SQL server db. Number of tables will be decided by you after discussing with me how we will use this information. This extracted information will be used to find problem with orders or exception items
2) Email is text only and sample is enclosed. (But you should be willing to work with us for at least 1-2 weeks after it goes live to determine all kind of Exception Items message. We don't epxect this to be a problem but just trying to be on the safe side.)
3) After a message is scraped and dumped into a database. Move that email into a folder that is properly names as archive folders yyyy-mm, i.e. 2009-03. so they sort properly in the list of folder.
4) Job has to be run as an exe that we will schedule to run every couple of hours as a sql server job. It should close automaticlaly like other sql jobs we have.
5) Last part of the job will send an email to other? email address that summarize the information like this:
A) OrderNum, SNOrderNum, Exception message details (Line? PROD? ? ? ? UPC? ? ? ? ? ? ? ? ? ? ? ? ? ? Brand? ? ? PACK/SIZE? ? ? ? DESCRIPTION? ? ? ? ? ? ? ? ? ? ? ? ? Exception Message)
B) If there are 5 orders that had exceptions, so there will be 5 or more records depending upon number of exception messages.
C) If in any email O/H = 0, it need to be highlighted so that we can see on hand quantity is zero.
**Sample email? :**? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
PRODUC:51116
CONFIRMATION NUMBER: 109558
BUYING CLUB COMMENTS? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? EXCEPTION ITEMS? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
01? 88241-5? 85574800001 VITALE? ? ? ? 1/32 OZ FULVIC MINERAL COMPLEX? ? ? MAY BE OUT OF STOCK? ?
-----------------------------------------------------------------LINE? QTY? O/H? ? PROD? ? ? ? ? ? ? UPC? ? ? ? ? BRAND? PACK/SIZE? ? ? ? DESCRIPTION? ? ? ? ? ? ? ? ? ? ? ? ? ? CASE PR? EXTENSN
2? ? ? 1? 325 168385? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? WORLD? ? ? ? ? 1/2 OZ? ? ? LIQUID KELP? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 2.12? ? ? ? 2.12?
Order Lines:? ? ? ? ? 2? Order Qty:? ? ? ? ? 2? Order Amt:? ? ? ? ? 16.15? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?