simia
skipping stones
Posts:7
 |
| 10-26-2010 06:33 AM |
|
hi
i have a problem with dynamic form while exporting data to excel.
i fill my forms by arabic language but when i export my forms data to excel, instead of arabic charachters i see question sign(?) character.
why?
|
|
|
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 10-26-2010 09:40 AM |
|
Hello Simia,
I believe the '?' symbol is coming up because of the unknown characters being used from the Arabic language. So when exporting to excel, excel doesn't know how to convert the character.
Just as a question, what DNN version along with the Dynamic Forms version are you using??
If you have any questions please let me know.
Thanks,
Ryan |
|
|
|
|
simia
skipping stones
Posts:7
|
| 10-26-2010 10:16 AM |
|
i use it on 5.x dnn versions
thanks for your attention |
|
|
|
|
Chad Nash
Posts:5260
|
| 10-26-2010 01:50 PM |
|
Hi. I saw that you emailed us as well and duplicated this on Beta Springs. Please give us a couple of days to test this and hopefully we can have a patch out in the next patch or release. For future reference can you also post here what some of the characters are that are having problems?
-Chad
|
|
|
|
|
simia
skipping stones
Posts:7
|
| 10-26-2010 09:36 PM |
|
hi
all arabic charachters.
im waiting ...
Thanks a lot |
|
|
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 10-28-2010 09:12 AM |
|
Hello Simia,
We will post the updates in this forum thread.
Thanks for your patience.
In the meantime, if you have any questions please let us know.
Thanks,
Ryan |
|
|
|
|
simia
skipping stones
Posts:7
|
| 11-12-2010 02:37 AM |
|
Hi
im stil waiting.
i must present my project next week and i really need this path,
its very urgent ,Please help me
thank you
|
|
|
|
|
Chad Nash
Posts:5260
|
| 11-12-2010 07:55 AM |
|
Hi Simia - Actually I think we figured this out...
Can you:
1. Save the file that is exported (don't immediately open it in Excel)
2. Open a new export file, choose import from CSV
3. Open the file you save..
-Chad
|
|
|
|
|
simia
skipping stones
Posts:7
|
| 11-12-2010 08:16 AM |
|
excuse me
would you mind explain more?
at first i dont khnow how to export from csv in excel 2007
the next question is that the exported file extension is .xls, then why and how "export from .csv"?
thanks |
|
|
|
|
Chad Nash
Posts:5260
|
| 11-12-2010 08:21 AM |
|
Hi. Yes, well what happens is that although I think the encoding is ok its opening it up thinking its really XLS (because we save it as that type).
So if you:
1. Save the file
2. Rename the file as .csv instead of .xls
3. Click Import from Text file within Excel
Do the characters show them up?
-Chad
|
|
|
|
|
simia
skipping stones
Posts:7
|
| 11-12-2010 08:31 AM |
|
no, it doesnt it stil show me serious of "?"  |
|
|
|
|
simia
skipping stones
Posts:7
|
| 11-12-2010 08:44 AM |
|
is there any difrence between local portal and an uploaded portal on a server?
because on local this module works well but on server, i have this problem. |
|
|
|
|
Chad Nash
Posts:5260
|
| 02-25-2011 06:42 AM |
|
Just wanted to update this thread and another related to XLS export and CSV export in Dynamic Forms 3.4 release.
Basically here is what happened:
1. We use to render the file with code where we could had our own ‘Header’ to the file letting Excel know to open it as a text file
2. We saved it as XLS and it never really was a problem because of #1 above
3. The solution above wouldn’t work if the site used SSL
4. We modified the solution to just pull the file directly by itself off of the server instead of streaming it… that’s apparently what is causing the problem. So we fixed the bug for users with SSL but it caused another bug. This wasn’t fixed until 3.3 or 3.4 which is why this problem came about after your upgrade.
Thanks,
Chad
|
|
|
|
|
Chad Nash
Posts:5260
|
| 03-05-2012 02:21 PM |
|
For anyone having performance or timeout issues with Dynamic Forms and exporting to Excel please execute this query. We are including this in the next update/release.
CREATE NONCLUSTERED INDEX IX_DynamicForms_QuestionResponse
ON dbo.DynamicForms_QuestionResponse(DynamicQuestionID, UniqueResponseID
)
Thanks,
Chad
|
|
|
|
|