SID-00264: Excel Export causes Internal Server Error

Status:	Unanswered	TWiki version:	4.2.0	Perl version:	5.8.8 (MSWin32)
Category:	CategoryPlugins	Server OS:	Windows Server 2003	Last update:	16 years ago

I'm trying to get the ExcelImportExportPlugin to work on our Wiki but I'm running into problems. I'm using the Sandbox examples that are included with the plugin. I seem to have the excel2table part of it working fine, but I can't get the table2excel to work. Using the supplied ExportExcel1 topic, when I click on the "Export table" button, I get an Internal Server Error page.

The Apache log shows the following error as a result of hitting the export button:

[Sun Apr 12 09:40:04 2009] [error] [client 10.10.20.2] (OS 3)The system cannot find the path specified. : couldn't create child process: 720003: table2excel, referer: http://10.10.20.5/twiki/bin/view/Sandbox/ExcelExport1 [Sun Apr 12 09:40:04 2009] [error] [client 10.10.20.2] (OS 3)The system cannot find the path specified. : couldn't spawn child process: D:/twiki/bin/table2excel, referer: http://10.10.20.5/twiki/bin/view/Sandbox/ExcelExport1

I notice when I hover my mouse over the button, the URL that it is trying to go to is: /twiki/bin/table2excel/Sandbox/ExcelExport1

Unless I'm misinterpreting something, that appears to be an invalid path, and I'm guessing it's causing the error.

I've never programmed a line of Perl so take this for what it's worth, but I noticed the following at the end of the ExcelImportExprtPlugin.pm file:

sub table2excel { my ( $session, $params, $topic, $webName ) = @_; my $filename = $params->{file} || $topic; my $uploadtopic = $params->{"_DEFAULT"} || $params->{topic} || $topic; my $mapping = $params->{map} || ''; my $template = $params->{template} || '';

## SMELL: Parameter "topic" seems to serve no function return "<form action=\"%SCRIPTURLPATH{\"table2excel\"}%/%WEB%/%TOPIC%\"><input type=\"hidden\" value=\"$template\" name=\"template\" /><input type=\"hidden\" value=\"$uploadtopic\" name=\"uploadtopic\" /><input type=\"hidden\" value=\"$filename\" name=\"file\" /><input type=\"hidden\" value=\"$mapping\" name=\"map\" /><input type=\"submit\" value=\"Export table\" /> </form>"; }

The <form action=...> line appears to be what's creating the path in question. Does that look accurate? Given that this is a hard failure, I'm guessing that I installed something incorrectly.

Any ideas would be greatly appreciated.

Thanks, Dave

-- DaveBartolini - 2009-04-12

Discussion and Answer

Closing this question after more than 30 days of inactivity. Feel free to reopen if needed. Consider engaging one of the TWiki consultants if you need timely help. We invite you to get involved with the community, it is more likely you get community support if you support the open source project!

-- PeterThoeny - 2009-06-02

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.