iX Talk

Code: Select all

void Button3_Click(System.Object sender, System.EventArgs e)
		{
			Globals.DataLoggerExport.Export("DataLogger1");
		}

Code: Select all

//--------------------------------------------------------------
// Press F1 to get help about using script.
// To access an object that is not located in the current class, start the call with Globals.
// When using events and timers be cautious not to generate memoryleaks,
// please see the help for more information.
//---------------------------------------------------------------

namespace Neo.ApplicationFramework.Generated
{
    using System.Windows.Forms;
    using System;
    using System.Drawing;
    using Neo.ApplicationFramework.Tools;
    using Neo.ApplicationFramework.Common.Graphics.Logic;
    using Neo.ApplicationFramework.Controls;
    using Neo.ApplicationFramework.Interfaces;
	using System.IO;
	using System.Reflection;
  
    public partial class DataLoggerExport
    {
		public void Export(string datalogger)
		{
			// Source datalogger
			var source = @"Project Files\DatabaseExport\"+ datalogger +".csv";
			
			// In a panel with Windows CE the USB stick is mounted into @"\Hard Disk\"
			var target = @"d:\"+ datalogger +".csv";

			try
			{
				StreamReader sR = new StreamReader(source);
				StreamWriter sW = new StreamWriter(target);
				
				// Skip first line (header)
				string row = sR.ReadLine();
				sW.WriteLine(row); 
				
				while (sR.Peek() != -1) // stops when it reachs the end of the file
				{
					row = sR.ReadLine();
					
					// Modify the row
					string[] rowArray = row.Split(';');
					
					// DateTime is in colum 2 (index 1)
					// Remove the time part
					rowArray[1] = rowArray[1].Substring(0,11)+"\"";
					
					// Rejoin the row
					row = String.Join(";",rowArray);
					
					// Write to your custum file
					sW.WriteLine(row); 
				}
				
				sR.Close();
				sW.Close();

				MessageBox.Show("Export OK");
			}
			catch (Exception ex)
			{
				MessageBox.Show(ex.Message);
			}				
		}	
		
		
		/// <summary>
		/// Get the path from where the project is executing.
		/// </summary>
		public string GetExcecutingPath
		{
			get { return Path.GetDirectoryName(Assembly.GetExecutingAssembly().ManifestModule.FullyQualifiedName); }
		}
    }
}

Code: Select all

public void Export(string datalogger)
		{
			// Source datalogger
			var source = @"Project Files\DatabaseExport\"+ datalogger +".csv";
			
			// In a panel with Windows CE the USB stick is mounted into @"\Hard Disk\"
			var target = @"d:\"+ datalogger +".csv";

			try
			{
				StreamReader sR = new StreamReader(source);
				StreamWriter sW = new StreamWriter(target);
				
				// Skip first line (header)
				string row = sR.ReadLine().Replace("Time;", "Date;Time;");
				sW.WriteLine(row); 
				
				while (sR.Peek() != -1) // stops when it reachs the end of the file
				{
					row = sR.ReadLine();
					
					// Modify the row
					string[] rowArray = row.Split(';');
					
					// DateTime is in colum 2 (index 1)
					var dateTime = rowArray[1].Split(' ');
					rowArray[1] = dateTime[0]+"\";\""+ dateTime[1];
					
					// Rejoin the row
					row = String.Join(";",rowArray);
					
					// Write to your custum file
					sW.WriteLine(row); 
				}
				
				sR.Close();
				sW.Close();

				MessageBox.Show("Export OK");
			}
			catch (Exception ex)
			{
				MessageBox.Show("Export Failed (Reason: " + ex.Message + ")");
			}				
		}