Quinn-Curtis Forums
Quinn-Curtis Forums
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Tools for Microsoft .Net
 SPC Control Chart Tools for .Net
 Export CSV		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

VBCCC

France
8 Posts
Posted - 01 Sep 2014 :  08:04:22  Show Profile  Reply with Quote
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.

quinncurtis

1586 Posts
Posted - 01 Sep 2014 :  08:40:07  Show Profile  Reply with Quote
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.
Go to Top of Page

VBCCC

France
8 Posts
Posted - 01 Sep 2014 :  09:02:36  Show Profile  Reply with Quote
with this method, I have the same problem
Go to Top of Page

quinncurtis

1586 Posts
Posted - 01 Sep 2014 :  09:25:18  Show Profile  Reply with Quote
Show the first few lines of the log file when you ran our SPCApplication1 example program.
Go to Top of Page

VBCCC

France
8 Posts
Posted - 01 Sep 2014 :  09:35:49  Show Profile  Reply with Quote
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,,
Go to Top of Page

quinncurtis

1586 Posts
Posted - 01 Sep 2014 :  09:45:32  Show Profile  Reply with Quote
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.
Go to Top of Page

VBCCC

France
8 Posts
Posted - 01 Sep 2014 :  10:08:11  Show Profile  Reply with Quote
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,
Go to Top of Page

quinncurtis

1586 Posts
Posted - 01 Sep 2014 :  10:21:21  Show Profile  Reply with Quote
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?
Go to Top of Page

VBCCC

France
8 Posts
Posted - 01 Sep 2014 :  10:27:10  Show Profile  Reply with Quote
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
Go to Top of Page

quinncurtis

1586 Posts
Posted - 01 Sep 2014 :  12:24:22  Show Profile  Reply with Quote
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.
Go to Top of Page

VBCCC

France
8 Posts
Posted - 04 Sep 2014 :  03:46:11  Show Profile  Reply with Quote
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
Go to Top of Page

quinncurtis

1586 Posts
Posted - 04 Sep 2014 :  07:39:13  Show Profile  Reply with Quote
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?
Go to Top of Page

VBCCC

France
8 Posts
Posted - 09 Sep 2014 :  07:49:20  Show Profile  Reply with Quote
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
Go to Top of Page

quinncurtis

1586 Posts
Posted - 09 Sep 2014 :  08:43:13  Show Profile  Reply with Quote
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.
Go to Top of Page

VBCCC

France
8 Posts
Posted - 15 Sep 2014 :  08:51:41  Show Profile  Reply with Quote
Thank you.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Quinn-Curtis Forums © 2000-2018 Quinn-Curtis, Inc. Go To Top Of Page
Powered By: Snitz Forums 2000 Version 3.4.07