Solved

windows service,file wather,msmq

Posted on 2014-02-25
2
296 Views
Last Modified: 2014-06-05
Requirement,

Client will put the file in shared folder for order creation,the file will be as xml file which contains
multiple order(100 + order).everyday we will get the multiple files for order.

we have to read the xml file ,fetch the order and according to order send mail to user.
i am trying to do it with windows service,to read the xml file and send mail to user.

issue :1. like in middle file reading and sending mail,if error comes than
 how we could know that how many successful record we have send via mail?suppose that
 i am having 100 records in 1 order file after reading 50 record errro comes
then could we know that from which record we need to send email to user(how do i excecute file again).

2.after completion of successful read moved that file to Archive folder.I am ok with that i can do it.

some solution which i know as below.
1.take one database,insert data to it from flat file than process record from database with some successful flag,but client is not providing
a database.
2.some one told that use file watcher and msmq,i dont know how to use both things in windows service to implement it.i have not worked on msmq.


overall requirement

xmlfile---->read data from windows service will execute in 5 min ----send mail to user

problem: if error comes in middle of that how we take the latest record from xml file?

could you please provide the better approaches for this requirement?code/Article ?it will help to
to make some small poc before execution
0
Comment
Question by:nicemanish
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 25

Accepted Solution

by:
apeter earned 500 total points
ID: 39890507
Once the file watcher tries, open the xml file and start reading one order at a time and try to process it. If it is success send a success mail or failure email and continue reading the order. Why you need msmq or db for this ?
0
 

Author Comment

by:nicemanish
ID: 40113863
good
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question