| T O P I C R E V I E W |
| VBCCC |
Posted - 01 Sep 2014 : 08:04:22
Hello, I would like to save the data (notes added, ...) in a CSV file, but it does not work.
I use the function : Me.ChartData.Save("C:\Users\Public\save.csv")
In the CSV file, There are many records as of displayed points but each line contains the values #8203;#8203;of the last point ...
Example:
Batch #,Time Stamp,Sample #0,Sample #1,MEAN,RANGE,SUM,XBAR,L Std1,H Std1,RBAR,L Std2,H Std2,Notes
18,8/29/2014 23:30:00,40,0,20,40,40,"47,7631578947368",0,100,4,0,80,,
18,8/29/2014 23:30:00,40,0,20,40,40,"47,7631578947368",0,100,4,0,80,,
18,8/29/2014 23:30:00,40,0,20,40,40,"47,7631578947368",0,100,4,0,80,,
Hence the problem can come? In advance thank you.
|
| 14 L A T E S T R E P L I E S (Newest First) |
| VBCCC |
Posted - 15 Sep 2014 : 08:51:41
Thank you. |
| quinncurtis |
Posted - 09 Sep 2014 : 08:43:13
You can change the default high and low limit alarm colors using static properties of the SPCControlLimitRecordclass.
SPCControlLimitRecord.DefaultHighAlarmColor = Color.Yellow;
SPCControlLimitRecord.DefaultLowAlarmColor = Color.Green;
Place these calls at the beginning of your program, in the main Form of the program, before any of the SPC charts are actually created. |
| VBCCC |
Posted - 09 Sep 2014 : 07:49:20
Hello, I solved all problems but I would like to change the default colors :
for lower limits (which are blue).
for high limits (which are red).
and the detection limits are exceeded with : Me.TableAlarmEmphasisMode = SPCChartBase.ALARM_HIGHLIGHT_BAR
Thank you |
| quinncurtis |
Posted - 04 Sep 2014 : 07:39:13
We only have two types of x-axis scales. The first is the time scale, which as its name implies, is linear with time. The second is the batch scale, which is linear by batch. However, the batch mode has the option of labeling the tick mark for each batch with the actual batch number, a time stamp, or a unique string id you can define. If you define the string ids correctly, that may give you visually the same look as your alternative scale. This is all describde in detail in the manual and demonstrated in the batch control chart examples.
What is an example of an alternative scale which is not time or batch? |
| VBCCC |
Posted - 04 Sep 2014 : 03:46:11
Sorry not answer that now, I will test. I have another request, is it possible to define another unit for the x-axis (use a numeric variable instead of the time)?
Thanks |
| quinncurtis |
Posted - 01 Sep 2014 : 12:24:22
We updated the Trial download with a corrected version which outputs the records of the current chart using the ChartData.Save method. You must specify the ChartData.DataLogFlags property if you want the Notes to be included.
ChartData.DataLogFlags = SPCControlChartData.DATALOG_FILE_TIME_STAMP |
SPCControlChartData.DATALOG_FILE_SAMPLED_VALUES | SPCControlChartData.DATALOG_FILE_NOTES;
ChartData.Save("DatalogFile2.txt");
The ChartData.Save method should only be called after all data and notes have been added to the chart.
Please let us know the results.
|
| VBCCC |
Posted - 01 Sep 2014 : 10:27:10
Currently, I work with the trial version to see if your product meets the needs of my application. If this is the case, we will buy |
| quinncurtis |
Posted - 01 Sep 2014 : 10:21:21
The datalog function logs data as it added to the chart. Adding notes after the fact cannot go back and add the note into the data log file.
However, saving a file after all of the data has been added, including added notes should be possible, using the ChartData.Save method, which is what you were using initially. And that does have the problem you initially described, of only saving the last value. This is something we will have to investigate and fix if needed.
Are you a trial user of this software or do you have a Developer License?
|
| VBCCC |
Posted - 01 Sep 2014 : 10:08:11
Your example works well to initialize the notes to load curves, however I would like to save when I leave my screen to save the potentially modified notes by any person.
For example:
Before:
18,1,126,2,3,6,0
Time Stamp,Sample #0,Sample #1,MEAN,RANGE,SUM,XBAR,L Std1,H Std1,RBAR,L Std2,H Std2,Notes
8/29/2014 22:00:00,0,24,12,24,24,"47,7631578947368",0,100,4,0,80,Notes0,
8/29/2014 22:05:00,20,2,11,18,22,"47,7631578947368",0,100,4,0,80,Notes2,
8/29/2014 22:10:00,40,38,39,2,78,"47,7631578947368",0,100,4,0,80,Notes4,
8/29/2014 22:15:00,42,70,56,28,112,"47,7631578947368",0,100,4,0,80,Notes6,
8/29/2014 22:20:00,21,65,43,44,86,"47,7631578947368",0,100,4,0,80,Notes8,
8/29/2014 22:25:00,100,47,"73,5",53,147,"47,7631578947368",0,100,4,0,80,Notes10,
8/29/2014 22:30:00,85,70,"77,5",15,155,"47,7631578947368",0,100,4,0,80,Notes12,
8/29/2014 22:35:00,96,20,58,76,116,"47,7631578947368",0,100,4,0,80,Notes14,
8/29/2014 22:40:00,12,45,"28,5",33,57,"47,7631578947368",0,100,4,0,80,Notes16,
8/29/2014 22:45:00,69,55,62,14,124,"47,7631578947368",0,100,4,0,80,Notes18,
8/29/2014 22:50:00,0,42,21,42,42,"47,7631578947368",0,100,4,0,80,Notes20,
8/29/2014 22:55:00,66,53,"59,5",13,119,"47,7631578947368",0,100,4,0,80,Notes22,
8/29/2014 23:00:00,21,23,22,2,44,"47,7631578947368",0,100,4,0,80,Notes24,
8/29/2014 23:05:00,88,57,"72,5",31,145,"47,7631578947368",0,100,4,0,80,Notes26,
8/29/2014 23:10:00,89,90,"89,5",1,179,"47,7631578947368",0,100,4,0,80,Notes28,
8/29/2014 23:15:00,100,56,78,44,156,"47,7631578947368",0,100,4,0,80,Notes30,
8/29/2014 23:20:00,23,12,"17,5",11,35,"47,7631578947368",0,100,4,0,80,Notes32,
8/29/2014 23:25:00,78,56,67,22,134,"47,7631578947368",0,100,4,0,80,Notes34,
8/29/2014 23:30:00,40,0,20,40,40,"47,7631578947368",0,100,4,0,80,Notes36,
After :
18,1,126,2,3,6,0
Time Stamp,Sample #0,Sample #1,MEAN,RANGE,SUM,XBAR,L Std1,H Std1,RBAR,L Std2,H Std2,Notes
8/29/2014 22:00:00,0,24,12,24,24,"47,7631578947368",0,100,4,0,80,Notes0 MODIFIED,
8/29/2014 22:05:00,20,2,11,18,22,"47,7631578947368",0,100,4,0,80,Notes2 MODIFIED,
8/29/2014 22:10:00,40,38,39,2,78,"47,7631578947368",0,100,4,0,80,Notes4,
8/29/2014 22:15:00,42,70,56,28,112,"47,7631578947368",0,100,4,0,80,Notes6,
8/29/2014 22:20:00,21,65,43,44,86,"47,7631578947368",0,100,4,0,80,Notes8,
8/29/2014 22:25:00,100,47,"73,5",53,147,"47,7631578947368",0,100,4,0,80,Notes10,
8/29/2014 22:30:00,85,70,"77,5",15,155,"47,7631578947368",0,100,4,0,80,Notes12,
8/29/2014 22:35:00,96,20,58,76,116,"47,7631578947368",0,100,4,0,80,Notes14,
8/29/2014 22:40:00,12,45,"28,5",33,57,"47,7631578947368",0,100,4,0,80,Notes16,
8/29/2014 22:45:00,69,55,62,14,124,"47,7631578947368",0,100,4,0,80,Notes18,
8/29/2014 22:50:00,0,42,21,42,42,"47,7631578947368",0,100,4,0,80,Notes20,
8/29/2014 22:55:00,66,53,"59,5",13,119,"47,7631578947368",0,100,4,0,80,Notes22,
8/29/2014 23:00:00,21,23,22,2,44,"47,7631578947368",0,100,4,0,80,Notes24,
8/29/2014 23:05:00,88,57,"72,5",31,145,"47,7631578947368",0,100,4,0,80,Notes26,
8/29/2014 23:10:00,89,90,"89,5",1,179,"47,7631578947368",0,100,4,0,80,Notes28,
8/29/2014 23:15:00,100,56,78,44,156,"47,7631578947368",0,100,4,0,80,Notes30,
8/29/2014 23:20:00,23,12,"17,5",11,35,"47,7631578947368",0,100,4,0,80,Notes32,
8/29/2014 23:25:00,78,56,67,22,134,"47,7631578947368",0,100,4,0,80,Notes34,
8/29/2014 23:30:00,40,0,20,40,40,"47,7631578947368",0,100,4,0,80,Notes36, |
| quinncurtis |
Posted - 01 Sep 2014 : 09:45:32
I changed the datalog flags to include SPCControlChartData.DATALOG_FILE_NOTES:
int datalogflags = SPCControlChartData.DATALOG_FILE_TIME_STAMP |
SPCControlChartData.DATALOG_FILE_SAMPLED_VALUES | SPCControlChartData.DATALOG_FILE_NOTES;
to include Notes in the datalog. I added notes using:
String notesstring = "Notes" + i.ToString();
// Add the new sample subgroup to the chart
this.ChartData.AddNewSampleRecord(timestamp, samples, notesstring);
and Notes appear in the data log.
If you are doing something different, you need to show exactly what you are doing.
|
| VBCCC |
Posted - 01 Sep 2014 : 09:35:49
The code was in the example TimeVariableControlCharts. I retested and it's good. example below. However I would like to save notes manually filled and it does not work...
18,1,126,2,3,6,0
Time Stamp,Sample #0,Sample #1,MEAN,RANGE,SUM,XBAR,L Std1,H Std1,RBAR,L Std2,H Std2,Notes
8/29/2014 22:00:00,0,24,12,24,24,"47,7631578947368",0,100,4,0,80,,
8/29/2014 22:05:00,20,2,11,18,22,"47,7631578947368",0,100,4,0,80,,
8/29/2014 22:10:00,40,38,39,2,78,"47,7631578947368",0,100,4,0,80,,
8/29/2014 22:15:00,42,70,56,28,112,"47,7631578947368",0,100,4,0,80,,
8/29/2014 22:20:00,21,65,43,44,86,"47,7631578947368",0,100,4,0,80,,
8/29/2014 22:25:00,100,47,"73,5",53,147,"47,7631578947368",0,100,4,0,80,,
8/29/2014 22:30:00,85,70,"77,5",15,155,"47,7631578947368",0,100,4,0,80,,
8/29/2014 22:35:00,96,20,58,76,116,"47,7631578947368",0,100,4,0,80,,
8/29/2014 22:40:00,12,45,"28,5",33,57,"47,7631578947368",0,100,4,0,80,,
8/29/2014 22:45:00,69,55,62,14,124,"47,7631578947368",0,100,4,0,80,,
8/29/2014 22:50:00,0,42,21,42,42,"47,7631578947368",0,100,4,0,80,,
8/29/2014 22:55:00,66,53,"59,5",13,119,"47,7631578947368",0,100,4,0,80,,
8/29/2014 23:00:00,21,23,22,2,44,"47,7631578947368",0,100,4,0,80,,
8/29/2014 23:05:00,88,57,"72,5",31,145,"47,7631578947368",0,100,4,0,80,,
8/29/2014 23:10:00,89,90,"89,5",1,179,"47,7631578947368",0,100,4,0,80,,
8/29/2014 23:15:00,100,56,78,44,156,"47,7631578947368",0,100,4,0,80,,
8/29/2014 23:20:00,23,12,"17,5",11,35,"47,7631578947368",0,100,4,0,80,,
8/29/2014 23:25:00,78,56,67,22,134,"47,7631578947368",0,100,4,0,80,,
8/29/2014 23:30:00,40,0,20,40,40,"47,7631578947368",0,100,4,0,80,,
|
| quinncurtis |
Posted - 01 Sep 2014 : 09:25:18
Show the first few lines of the log file when you ran our SPCApplication1 example program. |
| VBCCC |
Posted - 01 Sep 2014 : 09:02:36
with this method, I have the same problem |
| quinncurtis |
Posted - 01 Sep 2014 : 08:40:07
The example program SPCApplication1 demonstrates how to log data to a file using the DataLogFileOpenForWrite, found in the UserChartControl1.SimulateData method. I'm not sure what you are using. Run that program, exit, and then load the resulting DatalogFile1.txt file(found in the projects bin\debug folder). Do you see anything wrong with that file? If not, then incorporate those routines into your own program. |
|
|
