January 15, 2014 at 10:24 am
I'm not exactly a noob but compared to most I still qualify for that title. I'm using v2012 standard.
I have a data capture system that populates several tables with different instrument data. SSRS then uses that data to create reports on a schedule. All that works. The problem I have is that when I have an instrument return bogus data I need to take it out of the table or the report dutifully reports it.
So....
I have a script I run that queries for the specific value within the date span I am looking for and returns the data id of that record.
Then I query for the data timestamped AROUND that data to see how long that event lasted to see if its valid or not. A short spike is invalid,(bubble in sample stream) a longer duration is valid.
THEN I update the records one at a time using the ID as the search criteria. All this takes about an hour because I modify the scripts by hand each time am so careful to not make a mistake.
This process works and I can deal with it but I am the ONLY one than can do this. I need to create something that makes this easier for even a casual office clerk to make these edits so I am not so critical to the process.
Would it be practical for me to delve into VB (or ?) and create an application for this purpose. For me it would be as difficult as the original data capture and report creation has been, but if there is no other way I am up for it. And if so, where is the best forum to get VB/SQL interface noob questions answered. Many forums like that are experienced developers and they don't have time for someone like me. And I really do understand that it is a burden, but I have to do something. I'm not sure this could be automated because the criteria for "bogus data" is relevant to the data surrounding it.
Oddly I have money for whatever software I need to make this happen.
Ideas ?
January 15, 2014 at 11:27 am
First you need to clearly define the business rules to describe your update proces. (When do you update, what do you update, which new value do you use to update, etc.). Try to write this into a flow chart and make sure it is as generic as possible (i.e. can be used for every abnomally in the measured results).
With these business rules defined you can build one (or a few) stored procedures to make your actions easier to understand and easier to execute. If these stored procedures aren't easy enough you could ask a programmer to build a simple front-end to accommodate these business rules.
If you don't have the knowledge to do this yourself you can ask more specific questions on the forum or hire a consultant / senior DBA / programmer to help you.
January 15, 2014 at 11:59 am
I am a PLC programmer by trade so logical flow is not completely foreign to me. But I'm not sure which direction I should attempt. Access can be used as a front end (i'd rather not) and Lightswitch, VB (and I now hear F#?) all are commonly used to create a user front end and one of these is what I would like to use in my attempt. I looking for guidance on which one is easiest to produce results for a fledgling developer. and has the best support community.
I have money for development software, but not for contractors.
January 20, 2014 at 8:53 am
DataMinder (1/15/2014)
I am a PLC programmer by trade so logical flow is not completely foreign to me. But I'm not sure which direction I should attempt. Access can be used as a front end (i'd rather not) and Lightswitch, VB (and I now hear F#?) all are commonly used to create a user front end and one of these is what I would like to use in my attempt. I looking for guidance on which one is easiest to produce results for a fledgling developer. and has the best support community.I have money for development software, but not for contractors.
I think as HanShi has suggested, you do need to clearly define the business rules that determine how and when you will change data. Infact, I think once this is done it will actually go towards helping you be a little clearer on what front end might be best suited.
For instance, it might suffice to have a simple Console Application that overlays a few Stored Procedures and Views to manage your process, negating the need for a fully fledged Windows Forms UI or some such.
January 21, 2014 at 1:56 pm
DataMinder, are you asking for an interface that allows you to do the same thing you do now (find anomalous values, review values from adjacent rows, and execute an update if warranted) or a process that will do all this without human intervention (e.g., a push-button solution - see bad data in report, push the button, et voila, it's fixed)?
I'm almost certain that you could do the latter as a stored procedure. Then, all you'd need is some means of launching the stored proc, and there are plenty of ways to do so that will be easy to implement.
Jason Wolfkill
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply