on 07-03-2012 8:40 AM
Hi,all:
Recently,I have a project need to use mii spc technology,customers want to achieve the alarm and send email to manager by mii spc.
I don't konw how to do this,I have seen the help document but I still confused, I want to konw step by step,so anybody who can give me an example?
an simple example?
or tell me like this:
1.xxxxxxx
2.xxxxxxx
...........
for exmaple:
1. create a iSPCChart ......
2.create a transactions, add a SPC/SQC Chart action ......
.....
thanks very much! I'm Looking forward to your help!
anybody who can help me. I am very confused. any suggestion?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Do you have the query template and SPC chart display template configured with the desired alarms?
If so, and you have a working applet with a red marker that you would like to send the information in an email, then use the right click menu to get the SPC Results detail (not the standard data). If you can see this in XML, please look for the proper section in the results (in XML is preferred) for the chart alarms.
This xml data is also what is produced by the SPC/SQC action block in a business logic transaction. You will need to combine the same query template/display template to produce the data. Match up the data point number with the relevant information about the data record, limits, etc. and the alarm text.
Determine your logic for building the relevant message from the SPC/SQC results, and send your email accordingly.
Thank you very much, Jeremy.It was very helpful to me.
But I still have some questions(please forgive me rookie):
1. I have the SPC chart display template configured with the desired alarms
2. Which section in the results I need to look for? I can't find any information about chart alarms but I can see the red marker in applet
3. I combine the same query template/display template to produce the data. the next, how to match up the data? the "EncodedImage"? I don't quite understand that you said "Match up the data point number with the relevant information about the data record, limits, etc. and the alarm text".
can you give me some operating documents for this(preferably with pictures)?
hope your help! thanks!
Use the other action block in the quality category - the analysis one, not the chart image. The correct action will provide you with the calculation data and information (including alarms). If you have a working iSPCChart applet on a web page and use the right click menu to show the spec results (not the raw query data) you will see the same dataset that the spc/sqc analysis action block generates.
In your Results XML you will see Rowsets with 6 different Rowset documents inside. Rowset[2] is the Upper Chart Data Points, and Rowset[3] are the alarms for the upper chart.
I will repeat one more time - please test your QT/DT as an applet and use the right click menu Data...SPC Results (this has helper text in the output for you to read and follow). Using the right click menu and selecting Data...SPC Results as XML should show you the same data but display it in xml without the helper text. This is the XML results that are produced by the SPC/SQC Analysis action block.
You will see something like this in your Rowset[3], which you can easily use in a Repeater action, and the POSITION is the same as found in Rowset[2], along with the data point values, limits, and other attributes.:
</Columns>
</Row>
</Row>
</Row>
</Row>
</Rowset>
Thanks,Jeremy.Maybe I expression is not clear enough.
Yes,I saw you said but I mean is that I don't know how to judge whether have alarm information and then decide whether to send email.
If upper chart no alarm, the Rowset[3] don't have "Row" node.
If upper chart no alarm but lower alarm,the Rowset[6] have "Row" node what include alarm information.
Now the problem is that I don't know how to write the judgment expression in Conditional action block.
Like the upper chart no alarm or have alarm, what is the judgment expression?
Please forgive me this stupid student.
Really appreciate you help me so much!
To repeat on the SPC SQC results xml use: SPC_SQC.Results{/Rowsets/Rowset[3]/Row} - every iteration in the repeater will give you access to the Row and POSITION and DESCRIPTION information. The same can be done for the lower chart alarms with SPC_SQC.Results{/Rowsets/Rowset[5]/Row}
Not all charts have both upper and lower, such as XBAR, EWMA, etc.
Concerning the rules for your conditional logic I can't help very much here since I don't have any idea what you are trying to accomplish. I was attempting to explain where the alarms would appear, and how to get the relevant information from the results of the SPC_SQC Analysis block. Using the runtime applet helps you to visualize the information and see the alarm details. If you can point to an alarm(s) on the running chart and say that an email should be sent to alert someone about the alarm, then the logic in your transaction would have to use the proper approach to check the xml results.
Jemery,Really thank you very much! all your replies were very helpful to me and give me great encouragement,so thank you! thank you very much!
Actually,I want to do only two things:
1. Judge whether the running chart is abnormal.
2. If have,get the alarms information and send email to alert someone.
Concerning the rules for my conditional logic, in fact,I just judge whether the RowSet is I want,such as RowSet[3]. Now it seems as if that isn't necessary,you have gave me a right way.
Now,I met the problem has basically solved. Thanks for your help! I learned a lot from your replies.
User | Count |
---|---|
8 | |
7 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.