Home
LimeSurvey Forums
Welcome, Guest
Please Login or Register.    Lost Password?
Excel Export does not export all the text (1.53+) (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: Excel Export does not export all the text (1.53+)
#13317
rainer (User)
Fresh Lemon
Posts: 18
graphgraph
User Offline Click here to see the profile of this user
Excel Export does not export all the text (1.53+) 6 Months, 3 Weeks ago Karma: 0  
Hi,

i collected some long texts having a survey. The texts are completely saved in database (i can see while "Browsing Responses". But when i export my survey to excel - then some fields don't contain the whole text.

It seems to me as if there is a cut... Maybe 150 characters are rendered and then in the moddle of a word it breaks.

Is this behaviour known?

Greeting and thx
rainer
 
Logged Logged  
  The administrator has disabled public write access.
#13318
rainer (User)
Fresh Lemon
Posts: 18
graphgraph
User Offline Click here to see the profile of this user
Re:Excel Export does not export all the text (1.53+) 6 Months, 3 Weeks ago Karma: 0  
i just found a surprising information: after 255 characters the output gets lost!

that is a magic number

maybe this helps to solve the problem...

thx a lot
 
Logged Logged  
  The administrator has disabled public write access.
#13319
ElMatador69 (Moderator)
LimeSurvey Team
Posts: 1584
graphgraph
User Offline Click here to see the profile of this user
Re:Excel Export does not export all the text (1.53 6 Months, 3 Weeks ago Karma: 31  
Upgrade to the latest version; on my knowledge this has been fixed in the meantime!
 
Logged Logged  
 
Get in touch with the LimeSurvey Development Team via IRC
If our informations and answers were useful to you, please consider a donation to the LimeSurvey Project!
  The administrator has disabled public write access.
#13320
rainer (User)
Fresh Lemon
Posts: 18
graphgraph
User Offline Click here to see the profile of this user
Re:Excel Export does not export all the text (1.53 6 Months, 3 Weeks ago Karma: 0  
we nedded to customize some PHP code... so the migration to 1.70 wont be as easy as usual... hmmm.

Is it possible to export the data from 1.53 - import in a local version of 1.70 and excel export it from there?

thx a lot
rainer
 
Logged Logged  
  The administrator has disabled public write access.
#13321
rainer (User)
Fresh Lemon
Posts: 18
graphgraph
User Offline Click here to see the profile of this user
Re:Excel Export does not export all the text (1.53 6 Months, 3 Weeks ago Karma: 0  
i have fond the bugfix here (Bugtracker)

01476: Character Limit on exporting Long Free Text-Question to .XLS or .CSV

Is there a way to get to know what the fix looks like? i just know that in 1.60 it was fixed...

I guess it is more easy for me to path a PHP file instead of upgrading... cause of the things mentionend above

greetings
rainer
 
Logged Logged  
  The administrator has disabled public write access.
#13340
Mazi (Moderator)
Moderator Lime
Posts: 3349
graph
User Offline Click here to see the profile of this user
Re:Excel Export does not export all the text (1.53 6 Months, 3 Weeks ago Karma: 28  
Maybe you can find out more in the changelog.

Otherwise contact El-Matador or c_schmitz and ask which file has been updated. Then you can compare your version and the updated one and take over the fix into your version.
 
Logged Logged  
 
Best regards,
Mazi
______________________
Need help? I can: set up Limesurvey for you / create your survey / implement additional features / design your template / offer premium support -> Contact.
  The administrator has disabled public write access.
Go to top