SID-01782: ExcelImportExportPlugin results in 404 error

Status:	Answered	TWiki version:	5.1.4	Perl version:	5.8.8
Category:	CategoryPlugins	Server OS:	Linux	Last update:	10 years ago

I've just installed the most current version of ExcelImportExportPlugin and was testing it out using the examples provided (IssueExcelExportImport). Both export and import result in a 404 error. The one from the Export is:

The requested URL /twiki514/bin/topics2excel/Sandbox/IssueExcelExportImport was not found on this server.

The installation successfully completed and all of the files are where they are supposed to be. This plugin worked perfectly in TWiki 4.2.1.

I'll be happy to make changes to the code and share it with the community if that's what it takes. Just not sure where to start. Any thoughts, insights or guidance?

Thanks.

-- Bob Mellinger - 2013-08-08

Discussion and Answer

The ExcelImportExportPlugin is listed to be tested up to TWiki-4.3 - it needs some TLC.

Make sure you have topics2excel in the twiki/bin directory. Check the file permission and ownership. Compare with other scripts in this directory.

-- Peter Thoeny - 2013-08-09

Any suggestions as to how to bring the ExcelImportExportPlugin up to 5.1.4? What are the types of things that typically need to be reviewed, revised and/or checked-out when transitioning a plugin from 4.3 to 5.1.4?

Have not previously been involved in updating/revising plugin code to ensure it will run on a higher version. Any insight would be helpful.

Thanks.

-- Bob Mellinger - 2013-08-14

Possibly a Config.spec issue, incorrect $TWiki::cfg{SwitchBoard} settings? Compare bin scripts and Config.spec with SVN:SendEmailPlugin.

-- Peter Thoeny - 2013-08-14

I compared bin scripts and Config.spec with SVN:SendEmailPlugin as suggested, but I must be missing something. Can you direct me to documentation on how to ensure that a script like topics2excel will execute when contained in a URL? In looking at the Config.spec in SVN:SendEmailPlugin there are entries targeting the executable scripts. When I parallel that for ExcelImportExportPlugin, nothing different happens.

Hope you can provide me with just a bit more guidance.

Thanks.

-- Bob Mellinger - 2013-10-07

You need to do several things:

• Set the equivalent to $TWiki::cfg{SwitchBoard}{sendemail}, such as: $TWiki::cfg{SwitchBoard}{topics2excel} = [ 'TWiki::Plugins::ExcelImportExportPlugin::Export', 'topics2excel', { 'topics2excel' => 1 } ];1;
• Change the script in the bin to call $TWiki::engine->run();
• Implement a function that handles topics2excel, such as sub topics2excel in lib/TWiki/Plugins/ExcelImportExportPlugin/Export.pm as directed in the switchboard.

Granted the whole process of invoking a script is convoluted. The complication was done as part of TWikiStandAlone. I recommend to study how the SendEmailPlugin does it.

-- Peter Thoeny - 2013-10-08

We've recently upgraded to TWiki 6.0.1 (from 4.2.1) and I'd like to know if the above recommendations for making the ExcelImportExportPlugin operate are still valid. We are still encountering the same issue when running the ExcelImportExportPlugin using the topics2excel or excel2topics functionality. What is returned is:

The requested URL /TWiki601/bin/topics2excel/Main/RosterExport was not found on this server.

Any update guidance would be greatly appreciated.

Thanks very much.

-- Bob Mellinger - 2015-02-26

The TWiki::cfg{SwitchBoard} has been introduced in TWiki-4. No changes in this regards up to today, so same fix needs to be done to extensions that are not up to date.

-- Peter Thoeny - 2015-02-27

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!

-- Peter Thoeny - 2015-12-03

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.