Re: How to avoid stumbling over empty lines in csv data loader
Daniel Dekany <[email protected]> Sun, 26 Feb 2006 11:21:17 +0100
| Newsgroups | gmane.comp.text.fmpp |
|---|---|
| Message-ID | <[email protected]> |
Sunday, February 26, 2006, 10:47:12 AM, Ralf Hauser wrote: > Daniel, > > Thanks, if would be great if that wasn't just > "ignoreTrailingEmptyLines", but "ignoreEmptyLinesInAnyPosition"! Empty lines at the end of a file can occur accidentally, but in the middle of the CSV file? How could that happen? > Ralf >> > My CSV file sometimes ends with a few empty extra lines. >> > This causes fmpp to print the following error: >> > >> > <<Caused by: freemarker.core.InvalidReferenceException: Expression >> > d[x] is undefined on line 29, column 70 in sql.fdd.>> >> >> CSV file? Sorry... recently somehow I believed it's about an FTL file. >> >> So, yes, empty lines mean empty (missing) cells. I guess I should add >> an ignoreTrailingEmptyLines option to the CSV data loader. Certainly I >> will have chance to look into this next week. > Perfect - then, you'll have one more reason to go for the .11 release! ;) I want to schedule the .11 release after the FreeMarker 2.3.5 release, which is planned be done next week, but who knows. Anyway, I will create a qfix jar if this CVS thing is done. -- Best regards, Daniel Dekany ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642