FileHelpers Support

Library Support :: Decimal separator problem

PRA — Wed, 20 Aug 2008 02:44:50 GMT

Author: PRA
Subject: Decimal separator problem
Posted: Wed Aug 20, 2008 2:44 (GMT 0)

Hi,
The decimal separator is not treated at all.
In my file : 12,34 is rendered like this : 1234.
So I used this :

[FieldConverter(ConverterKind.Decimal, ",")]
public Decimal Field8;

but it's still 1234.

This problem has been reported and fixed, so I don't see what happens. I'm using the version 2.0 of the library.

Any idea ?

Thanks,

Patrice.

Library Support :: How to read into a DBTable, modify data and save it ?

PRA — Tue, 19 Aug 2008 23:16:51 GMT

Author: PRA
Subject: How to read into a DBTable, modify data and save it ?
Posted: Tue Aug 19, 2008 23:16 (GMT 0)

Hi,
I'm a newbie with this wonderfull library.
I'm able to load my data into a DBTable dt = engine.ReadFileAsDT(@"In.txt").
I've created my object with the wizard.
The problem is that when I bind a DBGrid to the array of objects, the records are readonly.
So I put the records into a table created in a Dataset :myDS.MyTable.Merge(dt);
At this point, my data are updatable.
But I can't use the engine to write my Table into a file since the method engine.WriteFile("Out.txt", ?) only works with an array of myObjects.

So, how to manipulate the data into a DBGrid and save the updated data ?

Thanks in advance,

Patrice.

Developers Discussions :: FixedLengthClassBuilder field with start and end position

atambavekar — Tue, 19 Aug 2008 13:32:50 GMT

Author: atambavekar
Subject: FixedLengthClassBuilder field with start and end position
Posted: Tue Aug 19, 2008 13:32 (GMT 0)

Hi,
Currently I am evaluating this library for my project. I have very large (few hundred columns/fields) fixed length text file to read. I would like to read only the certain columns from the file based on start position and end position of a field. How can it be done with the FixedLengthClassBuilder? I noticed the AddField needs the length of a field but couldnt find a way to add field based on position.
Thanks,
Ajit

Library Support :: Header Trailer

mettlus — Mon, 18 Aug 2008 12:52:40 GMT

Author: mettlus
Subject: Header Trailer
Posted: Mon Aug 18, 2008 12:52 (GMT 0)

How about parsing a file with Header Trailer Format?

01 5555555555 JOHNSON CO IN 88888888888888888 // HEADER
210 145 21 33.00
541 010 11 9.99
99 5555555555 JOHNSON CO IN 88888888888888888 // TRAILER
_________________
SV

Library Support :: How do I access fields in Run Time Records? (C#)

drbeaker — Thu, 14 Aug 2008 16:19:47 GMT

Author: drbeaker
Subject: How do I access fields in Run Time Records? (C#)
Posted: Thu Aug 14, 2008 16:19 (GMT 0)

The examples I saw read the whole file into a DataTable. I want to read the file async & process each record as I read it. Is this possible in C#? I don't need to refrerence the fields by name, clearly that would not be possible, but by index number would be fine. How can I do this?

Regards

Dave

Library Support :: Error while reading Excel using FileHelper

Irfan — Thu, 14 Aug 2008 05:12:05 GMT

Author: Irfan
Subject: Error while reading Excel using FileHelper
Posted: Thu Aug 14, 2008 5:12 (GMT 0)

Hi,
I am using filehelper to read excel file and i am getting the following error:
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.

Any suggestions for solving this issue...

Library Support :: RE: ConvertException was unhandled by user code

Chris — Fri, 08 Aug 2008 06:40:24 GMT

Author: Chris
Posted: Fri Aug 08, 2008 6:40 (GMT 0)

It seems like it has something to do with the interaction with my code and the non-user code.

I have marked the method StringToField

with the following and it does not break anymore.

Code:

[System.Diagnostics.DebuggerNonUserCode()]
public override object StringToField(string from)
{
}

Can someone confirm that this is the correct way?

Library Support :: ConvertException was unhandled by user code

Chris — Thu, 07 Aug 2008 11:13:14 GMT

Author: Chris
Subject: ConvertException was unhandled by user code
Posted: Thu Aug 07, 2008 11:13 (GMT 0)

Hello,

I'am trying to validate a field in a record by reading a file.
I have created a custom FieldConverter that checks if the string is a number and if the number is not 0

The Field looks like this:

Code:

[FieldFixedLength(5)]
[FieldConverter(typeof(HuisnummerVerplicht))]
public int Huisnummer;

The customConverter looks like this:

Code:

internal class HuisnummerVerplicht : ConverterBase
{
public override object StringToField(string from)
{
object retVal;

try
{
int huisNr = Convert.ToInt32(from);

if (huisNr == 0)
{
throw new ConvertException(from, typeof(Int32), "Huisnummer is een verplicht veld.");
}
else
{
retVal = huisNr;
}
}
catch
{
throw new ConvertException(from, typeof(Int32));
}

return retVal;
}
}

When the convertException is thrown, i get the error:
ConvertException was unhandled by user code

what i would expect is that the record will invalidate, en the errormanager would handle the exception?

someone has an idea what i'am doing wrong?

Library Support :: Navigating the Record structure

iannick — Wed, 06 Aug 2008 19:33:10 GMT

Author: iannick
Subject: Navigating the Record structure
Posted: Wed Aug 06, 2008 19:33 (GMT 0)

Hello,

I'm currently supporting multiple file schemas to import the same information (depending on the source). All is great but I'm now reaching a point where I have too many different schemas and I need to make things easier for my users. I was going to build a screen somewhat like the Wizard listing the details of each and every schema dynamicaly so that my users can select the appropriate import schema more easily.

I was going to reuse the information gathered by the engine at initialization to avoid re-inventing the wheel until I noticed that all of the clases related to the parsed attributes are marked internal and the library uses fields instead of properties. I would like to avoid having to refactor the library and move away from the codebase just for the sake of making those properties available outside the FileHelper library.

Is there any workaround to get access to the schema of the engine? (I would like to avoid having to create a facade from within the FileHelper project)

Library Support :: RE: Date converter in FHW file

Mastrup — Tue, 05 Aug 2008 12:08:32 GMT

Author: Mastrup
Posted: Tue Aug 05, 2008 12:08 (GMT 0)

Open the .FHW in notepad or some other texteditor.

You will see the XML code. here is what you can add to the FHW file to make it work

Code:

<DelimitedClass Delimiter=",">
<ClassName>Custormer</ClassName>
<SealedClass />
<Fields>
<Field Name="CustId" Type="Int32" />
<Field Name="Name" Type="String" />
<Field Name="Balance" Type="Decimal" />
<Field Name="AddedDate" Type="DateTime">
<Converter Kind="Date" Arg1="dd-MM-yyyy"/>
</Field>
</Fields>
</DelimitedClass>

the <Converter Kind="Date" Arg1="dd-MM-yyyy"/> line is where the magic happens

Library Support :: Runtime Records on CF.NET?

jeusdi — Mon, 04 Aug 2008 09:48:21 GMT

Author: jeusdi
Subject: Runtime Records on CF.NET?
Posted: Mon Aug 04, 2008 9:48 (GMT 0)

Hello all, I've imported FileHelpers reference (FileHelpersPPC 2.0) to my Windows CE project. However, I need to use the Runtime classes, but I don't find these classes. Can you help me please? Thanks for all.

Library Support :: RE: Import MT940 files.

Lordas — Fri, 01 Aug 2008 10:57:27 GMT

Author: Lordas
Posted: Fri Aug 01, 2008 10:57 (GMT 0)

have a look at the multirecordengine