Forums

importing to excel issues

drb 25 Aug, 2007
Hello,
I am using v2.3RC1. I selected few data and tried to export to excel. When I open the excel. I see this:

<br />
<b>Fatal error</b>: Call to undefined function: writestring() in <b>/home/myname/public_html/mydomain/main/administrator/components/com_chronocontact/admin.chronocontact.php</b> on line <b>615</b><br />


Any help please?

drb
GreyHead 25 Aug, 2007
Hi drb,

That error makes it look as though the file administrator/components/com-chronocontact/
excelwriter/Writer/Worksheet.php isn't being found. Please will you check that this has installed properly.

Bob
drb 25 Aug, 2007
Yep. I did a fresh install with the latest version. It is there 113.14 kb.

drb
GreyHead 25 Aug, 2007
Hi drb,

I just ran some tests on my install and I can't reproduce that error. Everything seems to run fine.

If you have a moment please will you back up your form and table and send the files to me at info at greyhead.net and I'll see if they work OK here.

Bob
drb 26 Aug, 2007
Hello Bob,
I have sent you the backed up file.

THanks so much.

drb
GreyHead 26 Aug, 2007
Hi drb,

Well, the good news is that I get the same error message with your form. Now I just have to work out what's causing it.

Bob

Later: Actually I get a slightly different error message:
Fatal error: Call to undefined method PEAR_Error::writeString() 
in <path snipped> \administrator\components\com_chronocontact\admin.chronocontact.php on line nnn
Later still: Solved it! Your form ID 'Anonymous_feedback' is too long. There's a limit on Excel sheetnames of 31 characters and the sheetname that ChronoForoms creates 'Anonymous_feedback at 2007-08-26' is 34 characters long.

I've got a coding fix working to trim down long names that I'll pass on to Max, meanwhile I suggest that you just shorten the Form ID to 'Anon_feedback' and it should work OK.<br><br>Post edited by: GreyHead, at: 2007/08/26 16:04
This topic is locked and no more replies can be posted.