[ic] XLS import failure - 255 character limit issue.

Reid Sutherland interchange-users@icdevgroup.org
Wed Sep 4 11:50:02 2002


Jonathan Clark wrote:
>>I've having an issue where I'm trying to import an Excel 97+ spreadsheet
>>  into IC.  The problem is that IC takes a violent fit when the
>>description/comment field is over 255 characters.  It will start to push
>>MySQL errors.  Now I'm from me looking at the
>>UI/usertags/import_fields.tag, I don't see anything that would cause any
>>fields to be truncated/filled with upper ASCII chars by IC.  But then
>>again the code is very well written, making it painful for me to read :)
>>
>>Now I've tested my install of Spreadsheet::ParseExcel and it reads the
>>long descriptions fine.  I'm not sure what else I can do to aid in this
>>matter.
>>
>>Any ideas?
> 
> 
> Might be a daft question, but are you sure its a MySQL table? Only dbm
> tables have a field size limit of 255 chars.

Very sure :)

I wish it was something so silly.  I've read other threads relating to 
this problem, it seems it was ParseExcel issue at the time.  It was only 
supporting Excel 95 which has a 255 char limit.

-reid