FileHelpers Support

Library Support :: RE: Excel 2000 or newer is not installed in this system"

zlatan24 — Thu, 02 Jul 2009 04:31:54 GMT

Author: zlatan24
Posted: Thu Jul 02, 2009 4:31 (GMT 0)

Five days ago to me came friend and said about a lot of tool,but one of them he marked-recovery excel 2007 files,because it is free as he said and tool helped him,moreover utility can help the users to avoid the loss of important data most often processed using spreadsheets, such as statistical, economic, science information, etc,program scans the specified Microsoft Excel worksheet and gets all available information from it,program can recover information, it will recover and show it,tool recovered from the damaged folder, a single mouse click is enough to export the data to Microsoft Excel and continue working with it,supports almost all existing versions of XLS and XLSX formats: Microsoft Excel 97, 2000, XP, 2002, 2003 and 2007 (xlsx repair).

Developers Discussions :: RE: Fix for bug MultiRecordEngine.BeforeReadRecord in trunk

lucisferre — Fri, 26 Jun 2009 01:52:01 GMT

Author: lucisferre
Posted: Fri Jun 26, 2009 1:52 (GMT 0)

Sorry this line also needs to be added to the ReadStreamMethod:

Code:

ProgressHelper.Notify(mNotifyHandler, mProgressMode, currentRecord, -1);
BeforeReadRecordEventArgs e = new BeforeReadRecordEventArgs(currentLine, LineNumber);
skip = OnBeforeReadRecord(e);
if (e.RecordLineChanged)
line.ReLoad(e.RecordLine);

Developers Discussions :: Fix for bug MultiRecordEngine.BeforeReadRecord in trunk

lucisferre — Fri, 26 Jun 2009 01:46:30 GMT

Author: lucisferre
Subject: Fix for bug MultiRecordEngine.BeforeReadRecord in trunk
Posted: Fri Jun 26, 2009 1:46 (GMT 0)

I am working with the trunk and I found that the behaviour of the e.RecordLine in MultiRecordEngine and the FileHelperEngine is inconsistent.

The FileHelperEngine has been changes to support changing the RecordLine during this event, however the MultiRecordEngine ignores changes to that property. I believe I may have fixed it by changing the event handler to match that of the FileHelperEngine:

Code:

private bool OnBeforeReadRecord(BeforeReadRecordEventArgs e)
{
if (BeforeReadRecord != null)
{
BeforeReadRecord(this, e);

return e.SkipThisRecord;
}

return false;
}

Library Support :: RE: Delimited file column headers

marshy — Thu, 25 Jun 2009 13:37:52 GMT

Author: marshy
Posted: Thu Jun 25, 2009 13:37 (GMT 0)

Thanks

Using the HeaderText seems to work fine for me

Library Support :: RE: Delimited file column headers

Chuk — Thu, 25 Jun 2009 09:42:48 GMT

Author: Chuk
Posted: Thu Jun 25, 2009 9:42 (GMT 0)

Well, you may solve this by setting the engine.HeaderText or by even add an dummy to the Recordarray you want to write out.
That's what I've found so far. Don't know if there is a better solution.

Library Support :: RE: Delimited file column headers

marshy — Wed, 24 Jun 2009 18:56:20 GMT

Author: marshy
Posted: Wed Jun 24, 2009 18:56 (GMT 0)

Anyone get an answer on this, I have the same question?

Library Support :: Column Headers

marshy — Wed, 24 Jun 2009 18:37:54 GMT

Author: marshy
Subject: Column Headers
Posted: Wed Jun 24, 2009 18:37 (GMT 0)

Hi There

I've just started using your dll and it's brilliant!

Just one quick question:

When writing to a new file, is there any way to write column headers as well?

Wish List & Features Requests :: Ideas for the DataLink Redesign

Chuk — Tue, 23 Jun 2009 14:37:07 GMT

Author: Chuk
Subject: Ideas for the DataLink Redesign
Posted: Tue Jun 23, 2009 14:37 (GMT 0)

Hi,

I know a redesign of the DataLink classes are planned for the next big 3.0. release...

Whould there be support for Command Parameters integrated?
Informations about it can be found at MSDN: http://msdn.microsoft.com/en-us/library/ms254953(VS.80).aspx

Something like ReadNextRecord and ReadNextRecords(no_of_records_to_read) whould be cool to as mentioned in another thread.
Large tables with millions of rows could be handeld this way without holding them all in Memory.

Even asynchronous execution of Sql Commands whould be possible using the BeginExecuteNonQuery and EndExecuteNonQuery methods for example.
Long executing sql procedures may be run in an additional thread this way without blocking the FileHelpers Main Thread.
Unfortunately the async methods are not implemented for all data providers, but delegates could be used as a workarround of this
limitation as mentioned on http://oradim.blogspot.com/2008/05/using-delegates-to-make-synchronous.html.

If you are interested in getting this implemented I'll try to help you out.
Best Regards,
Christian

Bugs Reports :: RE: Index out of bounds in CommonEngine.RemoveDuplicateRecords

Chuk — Tue, 23 Jun 2009 14:08:18 GMT

Author: Chuk
Posted: Tue Jun 23, 2009 14:08 (GMT 0)

You are welcome .

Bugs Reports :: RE: Index out of bounds in CommonEngine.RemoveDuplicateRecords

Marcos — Tue, 23 Jun 2009 00:55:33 GMT

Author: Marcos
Posted: Tue Jun 23, 2009 0:55 (GMT 0)

Thanks for the report and the fix

I just applied it to the repository and give u the credits

Thanks for ur words about this unique moment in life, our little baby is now close to turn 1 was a incredible year full of goodness.

Best Regards
_________________
Happy Coding
Marcos ( www.devoo.net )
If you like the library support us with some books or monetary donations
Vote FileHelpers in Codeproject or Bookmark us in Delicious or here, Thanks !

Bugs Reports :: Index out of bounds in CommonEngine.RemoveDuplicateRecords

Chuk — Mon, 22 Jun 2009 20:59:24 GMT

Author: Chuk
Subject: Index out of bounds in CommonEngine.RemoveDuplicateRecords
Posted: Mon Jun 22, 2009 20:59 (GMT 0)

Hi Marcos,
Hi Matt

I've found a little Bug in the RemoveDuplicateRecords of CommonEngine.cs
If the Length of the Array is 1 an Exception will be trown, indicating that the array index is out of bounds.

I've checked the code in the repository and the bug still exist in the current code.

Suggested Changes to fix it:

Code:

return (IComparableRecord[])nodup.ToArray(arr[0].GetType());

in Line 623.

Even trying to Remove Duplicates from an array with Length 1 doesn't make much sense to me...
I think it should be:

Code:

if (arr == null || arr.Length <= 1)

on line 602

@Marcos:
Congratulations of your new offspring. Enjoy this unique and fantastic moment.
Best wishes to you and your family.

Best Regards
Christian

Library Support :: RE: "Item has already been added" exception (patch)

zvolkov — Mon, 15 Jun 2009 12:20:40 GMT

Author: zvolkov
Posted: Mon Jun 15, 2009 12:20 (GMT 0)

u r welcome!