filehelpers

FileHelpers performance

Does anybody has some comments of performance of Filehelpers ? EDIT: Maybe some experience from day life usage ? @omaxx: what was toal size of your file?...

Using an array in the FileHelpers mapping class

I have been searching for a way to allow one element of my FileHelpers mappling class to be an array of specific length. For instance, I have a class like this: [DelimitedRecord(",")] public class Example { public string code; public int month; public int day; public double h1; public double h2; public double h3...

Skipping a column in FileHelper

Using the FileHelper library for .Net, can I somehow skip a number of columns from the source file? According to docs and samples, I have to add fields for all columns. Alas, I have an excel sheet with 216 columns to import, from which as few as 13 are necessary. ...

Exporting DataTable using FileHelpers

I want to export the contents of a DataTable to a text delimited file using FileHelpers, is this possible? Here is what I have so far: // dt is a DataTable with Rows in it DelimitedClassBuilder cb = new DelimitedClassBuilder("MyClassName", "|", dt); Type t = cb.CreateRecordClass(); FileHelperEngine engine = new FileHelperEngine(t); I ...

Using FileHelpers; how to parse this CSV type

Hi all, Having a few problems trying to parse a CSV in the following format using the FileHelpers library. It's confusing me slightly because the field delimiter appears to be a space, but the fields themselves are sometimes quoted with quotation marks, and other times by square brackets. I'm trying to produce a RecordClass capable of p...

FileHelpers-like data import/export utility for binary data?

I use the excellent FileHelpers library when I work with text data. It allows me to very easily dump text fields from a file or in-memory string into a class that represents the data. In working with a big endian microcontroller-based system I need to read a serial data stream. In order to save space on the very limited microcontroller ...

Filehelpers ExcelStorage.ExtractRecords fails when first cell is empty

Hello, When the first cell of an excel sheet to import using ExcelStorage.ExtractRecords is empty, the process fail. Ie. If the data starts at col 1, row 2, if the cell (2,1) has an empty value, the method fails. Does anybody know how to work-around this? I've tried adding a FieldNullValue attribute to the mapping class with no luck. ...

Exporting to CSV - C#

Hello, I need to export a generic list to CSV. Obviously I could write my own, but would like to avoid this! I am able to google and find a lot of CSV parsers, but not many writers. I have downloaded FileHelpers but it doesn't properly escape output. For instance if a field is equal to ,,",,, the output is simply: ,,",,, For t...

error when using filehelpers on IIS; sometimes :S : [PolicyException: Required permissions cannot be acquired.]

FileHelpers.dll (2.0) are referenced within 2 class libraryies (Dto and Services) in my solution My webapp (asp.net mvc) is on IIS7 (Full Trust) Windows 7 PRO 64 and I sometimes get this exception when starting my app from VS2008: (to get rid of it I delete the FileHelpers.dll from bin, run, close browser, rebuild the solution and run ag...

How to define a default value for a field of a FileHelpers element class

I'm trying to load a CSV file (delims are ';' and quotes are '"'). I have successfully created everything (the wizard tool is awesome), but there's one thing that I can't find a solution for. Basically, I have an integer (System.Int32) column. In theory most of the records will have a positive integer value in that column. Sometimes, h...

how to handle null values for SQLDecimal datatype in FileHelper classes

Hi, I am trying to load a file using FileHelpers (like it already except for this one issue :P ) I have to save CSV file data into the database, and so am using a SqlDecimal datatype to store the decimal values of the CSV files. [FileHelpers.FieldOptional()] [FileHelpers.FieldConverter(typeof(SqlDecimalConverter))] public SqlDecimal ...

how to create records for writing a csv file with FileHelpers

I am using Filehelpers to import my database from files. I am now working on the reverse process and am having trouble seeing how to create the records from my data objects. All the examples I can find show going from file -> table -> file I am using interfaces with generics to convert. I use this one on the inbound conversion: publi...

Dynamically create a CSV file with FileHelpers

FileHelpers supports a feature called "RunTime Records" which lets you read a CSV file into a DataTable when you don't know the layout until runtime. Is it possible to use FileHelpers to create a CSV file at runtime in the same manner? Based on some user input, the CSV file that must be created will have different fields that can only ...

Filehelpers Excel to Oracle db

Hi,I want to import excel data to oracle DB. I got enough help for Excel part, can you guys help me in Oracle side? Is it possible to import to oracledb with filehelpers? Please provide some sample code for reference. Thanks Dee ...

How do you access an object whose type is defined at run-time?

I am using FileHelpers to parse CSV files whose structure is unknown using the following code: string cd = string.Format(@"[DelimitedRecord(""{0}"")] public sealed class ImportClass {{ [FieldQuoted('{1}')] ...

FileHelpers and CSV: what to do when a record can expand unbounded, horizontally

I'm trying to parse this type of CSV file with FileHelpers: Tom,1,2,3,4,5,6,7,8,9,10 Steve,1,2,3 Bob,1,2,3,4,5,6 Cthulhu,1,2,3,4,5 Greg,1,2,3,4,5,6,7,8,9,10,11,12,13,14 I can't figure out how to parse this with FileHelpers. I would imagine I should be able to do something like this: [DelimitedRecord(",")] public class MyRecord { ...

C# - Can FileHelper FieldConverter routines refer to other fields in the record?

I am using the excellent FileHelpers library to process a fixed-length airline schedule file. I have a date field, then a few fields later on in the record, a time field. I want to combine both of these in the FileHelpers record class, and know there is a custom FieldConverter attribute. With this attribute, you provide a custom functi...

Thread locking issue with FileHelpers between calling engine.ReadNext() method and readign engine.LineNumber property

I use producer/consumer pattern with FileHelpers library to import data from one file (which can be huge) using multiple threads. Each thread is supposed to import a chunk of that file and I would like to use LineNumber property of the FileHelperAsyncEngine instance that is reading the file as primary key for imported rows. FileHelperAs...

.NET how to output csv from enumeration of anonymous type?

Using FileHelpers, I decorated a class with [DelimitedRecord(",")] and was going to output an enumeration of objects of that type as CSV. But, it didn't work because my class inherits from ActiveRecordLinqBase<T>, which caused some problems. So, I was wondering if I could just select an enumeration of anonymous types and somehow have f...

How do you control the output format of a date when writing a CSV file with FileHelpers?

I'm using the FileHelpers 2.0 library to write a CSV file using the ClassBuilder class to generate a record type. My data contains dates and so I create a field of type DateTime, but when the file is generated the date values come out in the format ddmmyyyy rather than dd/mm/yyyy e.g. 28042000 instead of 28/04/2000. I've set the DateFo...