bugs in the xls2csv program??

[Cole, Ken (ABRC)]

John,

I would normally do this using Perl and the Excel and CSV CPAN modules.

We create Excel spreadsheets from filePro by creating CSV files and then
using the Spreadsheet::WriteExcel module and that works great.  I know
there are DBD modules for Excel and CSV so you may be best rolling your
own and being Perl it is going to run on *nix.

Just a thought.

Ken

> -----Original Message-----
> From:
> filepro-list-bounces+ken.cole=smiths-aerospace.com.au at lists.ce
> lestial.com
> [mailto:filepro-list-bounces+ken.cole=smiths-aerospace.com.au@
> lists.celestial.com] On Behalf Of John Esak
> Sent: Tuesday, 7 March 2006 4:19 PM
> To: Fplist (E-mail)
> Subject: OT: bugs in the xls2csv program??
>
> There is a program out there called xls2csv. We have been
> using it awhile.
> Recently, we noticed that it is doing something really
> strange... We got the latest version. Same thing.
>
> It is randomly converting whole columns of 2 digit (money
> format) to numbers with 7 extra decimal numbers attached.
> Like 327.02 beocmes 327.020123849.
> The whole column of numbers will have this extra garbage on
> them. Doesn't matter what format we make the column before
> the conversion. Some columns work perfectly fine... others, no.
>
> Also, jusst today, the thing started converting dates badly.
> It has been turning 03/04/2006 into 03-04-10. This now breaks
> the program beyond our using it. The extra 7 digits never
> started with anything in the 3rd decimal position other than
> 0 or 1, so filePro has been doing okay with the first two
> decimal places... not rounding up. However, if one of the 3rd
> digits ever becomes equal to or greater than 5 we would be in
> big trouble. Now with the bad date conversion this program
> becomes useless.
>
> Anyone seen this same trouble. Anyone have an xls to csv
> converter that works proeprly???
>
> Thanks,
>
> (Must, of course, work from the *nix command line. We are on
> SCO O/S 5.6)
>
> John
>
> P.S. - I have written to the keeper of this program, someone
> named Vitus in Russia... sure, I'll get an answer... it's
> been a week. :-(
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>

******************************************
The information contained in, or attached to, this e-mail, may contain confidential information and is intended solely for the use of the individual or entity to whom they are addressed and may be subject to legal privilege.  If you have received this e-mail in error you should notify the sender immediately by reply e-mail, delete the message from your system and notify your system manager.  Please do not copy it for any purpose, or disclose its contents to any other person.  The views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of the company.  The recipient should check this e-mail and any attachments for the presence of viruses.  The company accepts no liability for any damage caused, directly or indirectly, by any virus transmitted in this email.
******************************************