Forums

Hi, I am having a problem in that the data that people are entering into the text boxes is being truncated when I download the data as an excel file. The form is here
I have made the boxes bigger, but the data is still truncated. If I look at it at the site, all the text is in there.
Any ideas?

Inelia

Edited to add url tags<br><br>Post edited by: GreyHead, at: 2007/12/04 10:53

Hi inelia,

If the data is in the database then the trimming seems to be in the export. Checking the ExcelWriter docs here it looks like there is an Excel imposed limit of 255 characters. Does this fit with what is happening?

What happens when you try the CSV export?

I think we could probably create a work-around to split the code into chunks of less than 255 characters but this might be a bit messy to use.

Bob

My bad. When you mentioned the CSV download I realised that I didn't have the new upgrade. I downloaded the upgrade and installed it. The cvs has all the data in it! You are right about the excel truncating at 255.
Now I have a different problem, on the back end, I now can't see the individual files. I can see their number and date/time they were created, but not the linkable name files.
<br><br>Post edited by: inelia, at: 2007/12/04 23:53

Hi inelia,

Max posted this in another thread:

In order to have file name stored you will need to edit the autogenerated code a little, find the $_POST['file_field_name'] and replace it with $_FILES['file_field_name']['name']

Bob

AH! thank you!!😀

Hi
I was having the the same issue with long text being truncated at 255

I read on another forum that this uses PEAR excel writer and that its because it builds csv for older 95 excel version

But you can change the version by adding $xls->setVersion(8);

Works a treat! 😀