Charting tool

7 Antworten [Letzter Beitrag]
dickeytk
Bild von dickeytk
Offline
Beigetreten: 02/08/2009
Easy-karma: 0

I made a quick windows application that will graph the CSV files output by EasyWakeup at the location: /private/var/mobile/Library/EasyWakeup/accelometr.csv when you have the title of your alarm as stat The application is available here: http://oregonstate.edu/~dickeyj/easywakeup/EasyWakeUpGraph.exe
I want to make an iPhone application to do this, but that'll take a lot more work, let me know what you think though.

easy_admin
Bild von easy_admin
Offline
Beigetreten: 11/10/2008
Easy-karma: 500

Hello,
It's very interesting. But unfortunally it doesn't work. When I added csv file - appear error.

Input string has incorrect format.

dickeytk
Bild von dickeytk
Offline
Beigetreten: 02/08/2009
Easy-karma: 0

can you send me your csv file? 

spachal
Bild von spachal
Offline
Beigetreten: 03/03/2009
Easy-karma: 108

Hallo dickeytk, I was trying to run this app too, but I have found the same error message as easy_admin (but in Czech language). Here is a sample csv file, I was trying to open ~ 10 files, but withou any success:
http://rapidshare.com/files/213424761/acc2009.3.22_2_3A3_3A29.csv.html
Error message:
http://www.postimage.org/image.php?v=Pq8oW90

Any ideas how to solve this problem? :]

 
 

EWKd
Bild von EWKd
Offline
Beigetreten: 07/12/2009
Easy-karma: 0

What a great idea! I would love to see that too! I have no idea how to do it but keep trying!

mizpulyn
Bild von mizpulyn
Offline
Beigetreten: 12/01/2009
Easy-karma: 0

- i also get the "unhandled exception" like others here
- the log output is below

- in the meantime somebody might come up with an Microsoft Excel graph equation to apply on the CSV data to turn the numbers into simple Excel graph

LOG OUTPUT:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.FormatException: Input string was not in a correct format.
   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Double.Parse(String s, NumberStyles style, NumberFormatInfo info)
   at EasyWakeupChartTool.EasyWakeupData.ReadFile(String filename)
   at EasyWakeupChartTool.GraphPage.openChartToolStripMenuItem_Click(Object sender, EventArgs e)
   at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ToolStrip.WndProc(Message& m)
   at System.Windows.Forms.MenuStrip.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
EasyWakeUpGraph
    Assembly Version: 1.0.3327.20185
    Win32 Version: 1.0
    CodeBase: file:///C:/Documents%20and%20Settings/admin/Plocha/EasyWakeUpGraph.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5...
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/Sy...
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d...
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

shandilya
Bild von shandilya
Offline
Beigetreten: 12/28/2009
Easy-karma: 0

Thanks dickeytk for this wonderful tool!!

It works on Windows vista... Please see the attached image:

http://img710.imageshack.us/img710/6614/ewct.jpg

I used a file named "acs2009.**********.csv" as input.... the "*" represents that it could be anything.
I guess that the .csv filename should start with "acs".

The first few lines of the file look like this:

42158;30000;50
2009.12.28 16:21:12.83
16:21:12.83;0.018;-0.652;-0.815
16:21:15.83;-0.054;-0.615;-0.887
16:21:18.83;-0.036;-0.615;-0.851
16:21:21.83;0.144;-0.742;-0.833
16:21:24.83;-0.688;-0.47;-0.579
16:21:27.83;0.144;0.036;-0.978
16:21:30.83;0.796;-0.706;-0.47
16:21:33.83;0.199;-0.108;-0.851
16:21:36.83;-0.108;0.09;-1.014
16:21:39.83;-0.597;-0.307;-0.815
16:21:40.87;-2.173;-0.724;-0.688
16:21:41.03;-2.318;-0.615;-0.67
16:21:42.83;0.036;-0.525;-0.959
16:21:45.83;0.344;-0.887;-0.489
16:21:48.83;-0.126;-0.67;-0.76
16:21:52.30;-0.289;-0.778;-0.706
16:21:55.28;0.126;-0.688;-0.778
16:21:57.57;-0.09;-0.652;-0.815
16:21:57.67;-0.09;-0.633;-0.815
16:21:57.77;-0.144;-0.652;-0.923
16:21:57.87;-0.108;-0.67;-0.815
16:21:57.97;-0.108;-0.67;-0.815
16:21:58.07;-0.108;-0.652;-0.815

Hope that will help someone! :-)

saikyou (nicht überprüft)
Bild von saikyou

Great! That worked for me! My graph is a lot messier though, do you use the accurate sensor or the attached method?
And thanks for making the tool TS!