NVK
skipping stones
Posts:11
 |
| 08-21-2013 12:16 AM |
|
Since a DNN update a problem occurs when exporting the results of a dynamic form to Excel: A return in a multi-line text box results in a new row in excel. The return of the multi-line text is HEX 0A (a line feed).
Previously, a return resulted in a text return in Excel.
But now, because of the new rows, the results in Excel are cluttered.
How can I solve this problem?
Thanks in advance
|
|
|
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 08-21-2013 05:36 AM |
|
Hello NVK,
What version of DotNetNuke did you upgrade to?
What version of Dynamic Forms is installed?
Please let me know.
Thanks,
Ryan |
|
|
|
|
NVK
skipping stones
Posts:11
|
| 08-23-2013 12:13 AM |
|
hi we use forms version Ver:4.10.0.5601 / dnn 6.2.3
regards |
|
|
|
|
Candace
river guide
Posts:2431
|
| 08-23-2013 07:17 AM |
|
Hello. Please get the latest patch which is Dynamic Forms 4.1.40. From your DNN STore account, you can get this either from Patches or My Downloads and let us know if it clears up the issue for you.
Thanks!
Candace
|
|
|
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 08-26-2013 07:08 AM |
|
Hello NVK, If the upgrade doesn't fix the issue, you can use JavaScript to disable the use of the ENTER key for your Multi-lined textboxes. You would apply the necessary JavaScript in the Client side section of your Dynamic Form multi-lined textboxes that are vulnerable to this. Both of these threads offer a great insight as to how to perform this: http://stackoverflow.com/questions/...-enter-key http://stackoverflow.com/questions/...-enter-key You can always go to Google and search for "JavaScript disable return key", you'll find an abundance of examples of how to achieve this. Please let us know if you have any questions. Thanks, Ryan |
|
|
|
|
NVK
skipping stones
Posts:11
|
| 08-27-2013 06:08 AM |
|
hi ryan,
thx for your answer, but there is no new release in the store.(in My Account> My Downloads> Files) we installed the version which is in the 6.0 collection.
thx
antoine |
|
|
|
|
Candace
river guide
Posts:2431
|
| 08-27-2013 06:54 AM |
|
Hi Antoine,
Let me jump in here for a moment. The initial zip file for the Collection 6.0 should have the Dynamic Forms 4.1.40. Would you please check your Collection file again or check your version? I just want to make sure you get the right file. If you still don't see it, would you please use the Contact form and send me your invoice number so I can investigate for you? Please add a link to the forum thread in your message.
Thanks!
Candace
|
|
|
|
|
NVK
skipping stones
Posts:11
|
| 08-27-2013 10:15 PM |
|
hi candace and ryan,
sorry didn't look well... I have updated to 4.1.40, but that didn't solve the problem.
I don't like to juggle with java script myself; can you solve this in the the next release and if yes, when will that be ??
Regards
antoine |
|
|
|
|
NVK
skipping stones
Posts:11
|
| 08-28-2013 12:00 AM |
|
hi,
did some additional testing; the use of a ; in a multiline textfield also leads to export problems. it creates an extra field in excel because it is used as a delimiter....
so maybe we need a whole range of characters to be excluded ???? or is there a better solution ??
regards
antoine |
|
|
|
|
Rob
skipping stones
Posts:8
|
| 08-31-2013 06:58 AM |
|
Just wanted to let you know I have this exact same problem and posted my own question in the forums for how to solve this. I found that if dynamic forms were to use quotation marks around multi-line text fields when exporting to Excel, the problem is solved.
To me, disabling the Return key in javascript is cumbersome and not the best solution since we want to be able to keep line feeds in the data. We just don't want it to export them as it causes problems with Excel as you have found. |
|
|
|
|
NVK
skipping stones
Posts:11
|
| 09-02-2013 11:38 PM |
|
thx rob, hope that datasprings will solve the problem in the next release. I don'want to use javascript either......
I now use notepad++ to remove the linefeeds in the csv-file before importing in excel as a workaround |
|
|
|
|
Chad Nash
Posts:5260
|
| 10-07-2013 06:32 AM |
|
Hi Guys - So the solution you want us to implement is to wrap multi line textbox field values with quotes when exporting to Excel?
Thanks,
Chad
|
|
|
|
|
NVK
skipping stones
Posts:11
|
| 10-07-2013 11:24 PM |
|
Hi Chad,
no; we want you to delete the the line feed in multi textboxes because when you import a row with a line feed in it in excel, excel starts a new row. and this messes up the exports we make of the form results (see the first post in this thread)
if you want we can send you examples by mail ??
regards
antoine |
|
|
|
|