Need your suggestions to automate the process

Question

0.00/5 (No votes)

See more:

, +

Hi,

I am working in a healthcare project where we have developed lots of stored procedures, web application, and even the ETL involved in it. Very often, we receive a separate data from client in excel file to compare with the data in our system and we need to generate the report for the same along with the reason if any data mismatches.

What I have tried:

Currently, we are importing the excel file into data base and then we have to develop a stored procedure joining all the related tables to see the data mismatch and the reason for the mismatch. This will take at least 2 days to complete the task.

I want to automate this process to reduce the time as client will keep on bugging us to get the data comparison report with reason. Can someone suggest the better way to automate this process?

Posted 28-Jun-18 23:31pm

samisyed80

Updated 29-Jun-18 2:24am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2018-06-29T02:25:00

Without knowing the details, an answer may be opinion-based only and the common answer would be: "It depends on many factors.." ;)

In my opinion, the best way to automate "comparison process" is to distribute a service. I can't tell you exactly how to construct the service (what should it take as an input and how it should return a result), but... you have to define the common reasons of bugging reports. Then you'll be able to create a set of stored procedures for every single reason of bug. Non-standard bugs you'll need to proceed as you did it so far.

Note: some data are "real (actual)" for some piece of time. If healthcare system doesn't provide a picture-in-time for data, you may not be able to compare them.