Random Stuff - Comments

Howard: Secure POP3 client for C#

paynehd@gmail.com (Howard) — Thu, 18 Dec 2008 18:24:56 +0000

to add the NET 2.0 code...

Add two new includes:
using System.Net.Security;
using System.Security.Cryptography.X509Certificates;

Commneted out this include
//using Org.Mentalis.Security.Ssl;

Next, locate the Connect method:

public void Connect(string strHost, int intPort, bool secure)...

Comment out the existing lines:
//reader = new StreamReader(clientSocket.GetStream(), Encoding.Default, true);

//writer = new StreamWriter(clientSocket.GetStream());

Replace with code mentioned above.(repeated here...)

//Create a new SslStream and then pass that SslStream into the constructor

// of the StreamReader and the StreamWriter. The rest of POPClient will work as-is.

SslStream stream = new SslStream(clientSocket.GetStream(), false, delegate(object sender, X509Certificate cert, X509Chain chain, SslPolicyErrors errors) { return true; });

stream.AuthenticateAsClient(strHost);

reader = new StreamReader(stream);
writer = new StreamWriter(stream);

I tested the changes using the POP3TEST that was part of the download

I used a gmail account and was able to retrieve all email from that gmail account...

Howard

Hauke: CSV file parser and writer in C# (Part 1)

pauke@web.de (Hauke) — Fri, 12 Dec 2008 11:01:52 +0000

I used stream.WriteLine() instead of stream.Write('\n').
So the stream can decide itself which end of line chars to use.

Paul: CSV file parser and writer in C# (Part 1)

pauldevis@saturnvibes.com (Paul) — Fri, 12 Dec 2008 04:25:18 +0000

Thank You for the code Andreas. Works perfectly. But you might wanna add 'stream.flush()' at the end of the code.

terry: Secure POP3 client for C#

flesheatingmonkeyvirus@hotmail.com (terry) — Fri, 05 Dec 2008 20:57:08 +0000

kevins change is the one you want. works and is dead easy to implement.

tinki98: CSV file parser and writer in C# (Part 2)

pujain@hotmail.com (tinki98) — Wed, 22 Oct 2008 19:15:40 +0000

I am able to create/write/save csv file .
excellent code.
But I need further assistance as to saving that csv file in a particular type. Currently my file is being saved as "CSV(Comma delimited) (*.csv).
But i would like to save it as CSV(MS-DOS)(*.csv).
Please let me know.

Craig Fowler: CSV file parser and writer in C# (Part 2)

craig@craigfowler.me.uk (Craig Fowler) — Mon, 13 Oct 2008 12:14:05 +0000

This looks like excellent work, and is just what I needed. Added to StumbleUpon

Andreas Knab: CSV file parser and writer in C# (Part 2)

andreas@knab.ws (Andreas Knab) — Wed, 06 Aug 2008 22:12:44 +0000

I'll have to check that out, should be easy to fix...

Joseph: CSV file parser and writer in C# (Part 2)

joseph.marks@pinerivercapital.com (Joseph) — Wed, 30 Jul 2008 22:37:48 +0000

Hi.

This is a great article, but could you show some example code how to call the example code from main? I'm thinking of having some line to open file "a.csv" in the current directory.

Is this code meant to be run from Command Prompt, or some other way, such as through Excel?

Or is it part of a VSTO project or something?

Thanks.

Sachin: CSV file parser and writer in C# (Part 2)

sachindubey2@gmail.com (Sachin) — Wed, 02 Jul 2008 07:51:20 +0000

COde Not working...

if csv file has any unsigned values like / or blank space the loop break at that point..

so not validated

Walter: CSV file parser and writer in C# (Part 2)

waltertboyd@yahoo.com (Walter) — Wed, 11 Jun 2008 18:56:59 +0000

Nice job. Found a bug: If the last "cell" in the file is an empty string it's ignored. (IE, "1,2,3,4," would return 4 elements instead of 5, with the 5th element being just an empty string)

I modified CsvStream.GetNextRow() to resolve this. Modified the "if (EOL)" block to this:
if (EOL || EOS)
{
EOL = false;
EOS = false;
return null;
}
and in the loop, modified the "if (EOS)" block to this:
if (EOS)
return item.ToString();

(got rid of "return item.Length > 0 ? item.ToString() : null;")

Steve Trefethen: CSV file parser and writer in C# (Part 1)

stref@yahoo.com (Steve Trefethen) — Wed, 28 May 2008 22:30:31 +0000

You may be interested in the Open Source FileHelpers library for parsing CVS files it's very handy. Here is a post I wrote about it:

http://www.stevetrefethen.com/blog/ProcessingCSVFilesInCUsingOpenSourceFileHelpersLibrary.aspx

clay: CSV file parser and writer in C# (Part 2)

calberty[at]iwanttss[dot]com (clay) — Thu, 10 Apr 2008 19:06:47 +0000

I was having problems with the Jet ODBC engine only loading 255 columns from a csv file, this saved me a bunch of time over writing my own parser. Thanks for the link to csv spec too, I always wondered how it handled line breaks mid-record...

ehehe: Secure POP3 client for C#

aaa@aaa.sk (ehehe) — Thu, 21 Feb 2008 20:17:08 +0000

i have following problems with openPop
1. it seems to fail parsing messages without body
2. there is only one method to disconnect which is called if internal error occurs too

this method commits pop3 transaction => mails are deleted server side but processed with errors => lost

so in POPClient.cs i removed line SendCommand("QUIT", true); in Disconnect method - this rollbacks transaction

and added new method QuitAndDisconnect (original Disconnect) - this commits transaction

john: CSV file parser and writer in C# (Part 2)

john@hotmail.com (john) — Tue, 05 Feb 2008 08:12:55 +0000

Hi. Really nice program. Im having problem with flawed csv with newline in an cell that isnt inclosed in "". Ive tried adding "" manually but cant get it to work.

Adam Schaible: CSV file parser and writer in C# (Part 1)

aschaible@racoindustries.com (Adam Schaible) — Mon, 04 Feb 2008 19:46:10 +0000

I wanted some more flexibility here, so here's my take on it.

using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Reflection;

namespace OmegaWeb.util
{
public class CsvWriter
{
public static string WriteToString(DataTable table, bool header, bool quoteall)
{
StringWriter writer = new StringWriter();
WriteToStream(writer, table, header, quoteall);
return writer.ToString();
}

public static string WriteToString(IEnumerable enumerable, String[] propertiesToSkip, bool header, bool quoteall, IList modifiers)
{
DataTable table = GetDataTableFromIEnumerable(enumerable, propertiesToSkip, modifiers);
StringWriter writer = new StringWriter();
WriteToStream(writer, table, header, quoteall);
return writer.ToString();
}

public static void WriteToStream(TextWriter stream, IEnumerable enumerable, String[] propertiesToSkip, bool header, bool quoteall, IList modifiers)
{
DataTable table = GetDataTableFromIEnumerable(enumerable, propertiesToSkip, modifiers);
WriteToStream(stream, table, header, quoteall);
}

public static void WriteToStream(TextWriter stream, DataTable table, bool header, bool quoteall)
{
if (header)
{
for (int i = 0; i < table.Columns.Count; i++)
{
WriteItem(stream, table.Columns[i].Caption, quoteall);
if (i < table.Columns.Count - 1)
stream.Write(',');
else
stream.Write('\n');
}
}
foreach (DataRow row in table.Rows)
{
for (int i = 0; i < table.Columns.Count; i++)
{
WriteItem(stream, row[i], quoteall);
if (i < table.Columns.Count - 1)
stream.Write(',');
else
stream.Write('\n');
}
}
}

private static void WriteItem(TextWriter stream, object item, bool quoteall)
{
if (item == null)
return;
string s = item.ToString();
if (quoteall || s.IndexOfAny("\",\x0A\x0D".ToCharArray()) > -1)
stream.Write("\"" + s.Replace("\"", "\"\"") + "\"");
else
stream.Write(s);
}

public static DataTable GetDataTableFromIEnumerable(IEnumerable aIEnumerable, String[] propertiesToSkip, IList modifiers)
{
DataTable _returnTable = new DataTable();

if (aIEnumerable.Count() > 0)
{
//Creates the table structure looping in the in the first element of the list
object _baseObj = aIEnumerable.First();

Type objectType = _baseObj.GetType();

PropertyInfo[] properties = objectType.GetProperties();

DataColumn _col;

foreach (PropertyInfo property in properties)
{
if (!propertiesToSkip.Contains((String)property.Name))
{
_col = new DataColumn();
_col.ColumnName = (string)property.Name;
if (property.PropertyType == typeof(DateTime?))
{
_col.DataType = typeof(DateTime);
}
else if (property.PropertyType == typeof(Int32?))
{
_col.DataType = typeof(Int32);
}
else
{
_col.DataType = property.PropertyType;
}
_returnTable.Columns.Add(_col);
}
}

foreach (CsvModifier modifier in modifiers)
{
_col = new DataColumn();
_col.ColumnName = modifier.columnName();
_col.DataType = modifier.getDataType();
_returnTable.Columns.Add(_col);
}

//Adds the rows to the table
DataRow _row;

foreach (object objItem in aIEnumerable)
{

_row = _returnTable.NewRow();

foreach (PropertyInfo property in properties)
{
Object value = property.GetValue(objItem, null);
if (value != null && !propertiesToSkip.Contains(property.Name))
{
_row[property.Name] = value;
}
}

foreach (CsvModifier modifier in modifiers)
{
_row[modifier.columnName()] = modifier.getData(objItem);
}

_returnTable.Rows.Add(_row);
}
}
return _returnTable;
}
}
}

Here's my CSV Modifier interface:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace OmegaWeb.util
{
public interface CsvModifier
{
String columnName();
Object getData(Object inputData);
Type getDataType();
}
}