New Post: Please support Null Dates

cwhankey — Fri, 16 Jan 2009 21:25:39 GMT

I have a suggested update, with sample code. Some of the date fields in the test DBF I'm working with are empty. The following updates seem to handle this.

Chris Hankey

CProgram.Main()

if (orec.GetDateValue(i).HasValue == true)

{

swcsv.Write(orec.GetDateValue(i).Value.ToString(

"MM-dd-yyyy"));

}

DBFRecord.cs
public Nullable<DateTime> GetDateValue(int nColIndex)

{

DbfColumn ocol = mHeader[nColIndex];

if (ocol.ColumnType == DbfColumn.DbfColumnType.Date)

{

string sDateVal = ASCIIEncoder.GetString(mData, ocol.DataAddress, ocol.Length);

try

{

return DateTime.ParseExact(sDateVal, "yyyyMMdd", CultureInfo.InvariantCulture);

}

catch

{

return null;

}

else

throw new Exception("Invalid data type. Column '" + ocol.Name + "' is not a date column.");

}

New Post: Error on finding Unknown DbfColumnType

briankb — Mon, 29 Sep 2008 20:52:02 GMT

I'm using a datasource from http://wvgis.wvu.edu/data/dataset.php?action=search&ID=268#Fullmd and it was throwing an exception because of an unknown column type of "F".

I could not find what column type "F" actually was so I just assigned it as a memo.

If you know what it is could you please add it as a known column type.

Btw the program worked beautifully after I added the case for "F" add a writeln to show the unknown column type.

SocialExplorer.FastDBF / DbfColumn.cs Line 357-376

public static DbfColumnType GetDbaseType(char c)
    {
      switch(c.ToString().ToUpper())
      {
        case "C": return DbfColumnType.Character;
        case "N": return DbfColumnType.Number;
        case "B": return DbfColumnType.Binary;
        case "L": return DbfColumnType.Boolean;
        case "D": return DbfColumnType.Date;
        case "I": return DbfColumnType.Integer;
        case "M": return DbfColumnType.Memo;
        case "F": return DbfColumnType.Memo;
      }

      Console.WriteLine("Unknown Column Type: " + c.ToString().ToUpper());

      //return DbfColumnType.Memo;
      throw new NotSupportedException(String.Format("{0} does not have a corresponding dbase type.", c));

    }

fastdbf Forum Rss Feed

New Post: Please support Null Dates

New Post: Error on finding Unknown DbfColumnType