Carriage Returns Stripped from TextArea Submissions

[Ben]

Hmmm... I wonder about csv, though. The Excel fix is for specifically Excel: it inserts a <Br /> with a proprietary Microsoft style attribute value. I couldn't do that for CSV because it could be used anywhere - imported into any application, not just CSV. I'll have to think about this one!

Ben

[waizen]

Hello, Ben:

I'm seeing this same problem, but I'm using version 2.0. Excel 2007, if that helps.

Unfortunately, when a visitor writes a long message in the text area within the form in question and creates multiple paragraphs, the separate paragraphs appear on separate rows within Excel. That screws up my client's data when imported into his Act program.

I tried employing your fix above (although I know it's for an older version) but when I try to generate a report, the browser opens up to this page:

http://www.domain.com/modules/export_manager/export.php

and shows just a white blank screen.

Any thoughts? Thank you in advance.

Thanks.

[Ben]

Hi waizen,

Sorry you're having trouble with it!

The white screen lets us know that something seriously bad just happened. That can occur if there's a PHP or Smarty syntax error - the script doesn't know how to handle it and just dies, seeing the web equivalent of the Windows' Blue Screen of Death.

Double check the change you made to the email template. It sounds like there's a syntax error in the Smarty content. If you don't have any luck with it, post the entire content here and I'll take a look at it.

All the best -

Ben

[waizen]

I hadn't changed anything within any smarty file. Not sure where I should have or if I should have...please advise.

No, the change I had made was within the control panel...in the module section, export manager, clicked on edit link of Excel, chose Export Types and then clicked on edit link.

That's where I changed:

Code:

{elseif $field_type == "textarea"}
        {$value|nl2br}
      {else}
        {$value}
      {/if}

to:

Code:

{elseif $field_type == "textarea"}
        {$value|nl2br_excel}
      {else}
        {$value}
      {/if}

Again, I'm using version 2.0.0, so all this should have been unnecessary, right?