Hi, I seem to be having major problems getting the application devel server (my_app_server.pl) to accept an IO::File Handle as CSV and correctly encode as UTF-8.
I have Unicode::Encoding in my_app.pm and am using the following to wrap up the CSV string. # create an IO::File for Catalyst use IO::File; my $iof = IO::File->new; $iof->open(\$xls, "r"); $iof->binmode(":encoding(UTF-8)"); # output XLS data $c->response->body($iof); # close file undef $iof; Only this errors with : [error] Caught exception in engine "Wide character in syswrite at C:/Perl/lib/IO/Handle.pm line 474." If I remove the binmode encoding line , the server doesn’t error, but I get funny characters in my spread sheet output…. ----------------------------------------------------- File Check: xxxx, xxxx & xxxx – Residential Remortgage – xxxx Rated • In the fact find you have referenced the clients rental income. Please ensure that on future cases a copy of the rental agreement or other proof is added to the compliance file. • Suitability Letter – States that mortgage was for £180,000 rather than £170,000. Please reproduce this letter, making the appropriate amendments and send out to the client to sign. You should also check that all other figures are correct. • Suitability Letter – States that the product recommended tracks another rate; this does not appear to be the case as it is a fixed rate. Please reproduce this letter, making the appropriate amendments and send out to the client to sign. ----------------------------------------------------- What do I need to do to fix this problem? Thanks, Craig Chant Information Technology Manager [Description: Description: HLP_IT_Sig1] Direct Line: 01903 227 753 Main Line: 01903 602 664 Website: www.homeloanpartnership.com<http://www.homeloanpartnership.com> [Description: Description: HLP_Sig2_variant] This Email and any attachments contain confidential information and is intended solely for the individual to whom it is addressed. If this Email has been misdirected, please notify the author as soon as possible. If you are not the intended recipient you must not disclose, distribute, copy, print or rely on any of the information contained, and all copies must be deleted immediately. Whilst we take reasonable steps to try to identify any software viruses, any attachments to this e-mail may nevertheless contain viruses, which our anti-virus software has failed to identify. You should therefore carry out your own anti-virus checks before opening any documents. HomeLoan Partnership will not accept any liability for damage caused by computer viruses emanating from any attachment or other document supplied with this e-mail. HomeLoan Partnership reserves the right to monitor and archive all e-mail communications through its network. No representative or employee of HomeLoan Partnership has the authority to enter into any contract on behalf of HomeLoan Partnership by email. HomeLoan Partnership is a trading name of H L Partnership Limited, registered in England and Wales with Registration Number 5011722. Registered office: 26-34 Old Street, London, EC1V 9QQ. H L Partnership Limited is authorised and regulated by the Financial Conduct Authority.
<<inline: image005.jpg>>
<<inline: image006.jpg>>
_______________________________________________ List: Catalyst@lists.scsys.co.uk Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ Dev site: http://dev.catalyst.perl.org/