Item10072: Excel2topics needs to use Foswiki::Func::saveTopic

It used to work fine in 1.0.9 . Now when calling the /bin/excel2topics i get:

"Foswiki detected an internal error - please check ..... Can't locate object method "getEmbeddedStoreForm" via package "EnrikGuenther" (perhaps you forgot to load "EnrikGuenther"?)"

Can anyone confirm?

Kind regard,

-- EnrikGuenter - 24 Nov 2010

Reinstalled, disable all plugins - still the same. Is it a confirmed problem?

-- EnrikGuenter - 08 Dec 2010

I would still be very interested in a solution. Might this Problem be related to our Windows 2003 Server enviroment?

-- EnrikGuenter - 30 Dec 2010

Enrik - let's talk.

Find me on IRC: MartinCleaver on irc.freenode.net - am usually in the #foswiki channel.

-- MartinCleaver - 06 Jan 2011

I just diagnosed the issue. The plugin should use Foswiki::Func::saveTopic( $webName, $newtopic, $meta, $text, {} );

instead of going through store.

Note also that the text and meta parameters are inversed in Func.

-- MartinCleaver - 18 Apr 2011

Hello Martin, I am experimenting same issue. I am using Foswiki 1.1.3 debian package on Ubuntu. I wonder if this problem has a fix. Does the instruction above (saveTopic) should be added to the Excel2topics script? Thank you in advance for your advice!

-- AlexWayne - 10 Nov 2011

I'm running Foswiki-1.1.3, Sat, 16 Apr 2011, build 11475, Plugin API version 2.1 and have the same issue. See my comments on Item8494 for how I got here. Just to clarify Martin's comment above, I edited the file Import.pm in the /var/www/Foswiki/lib/Foswiki/Plugins/ExcelImportExportPlugin directory and made the following changes:

# WMK per Task Item10072 at foswiki.org
#                    $session->{store}
#                      ->saveTopic( $user, $webName, $newtopic, $text, $meta,
#                        {} );
# Use Foswiki::Func:saveTopic
                    Foswiki::Func::saveTopic( $webName, $newtopic, $meta, $text,
 {} );

We are migrating a parts database from excel to the wiki so this plugin is really useful.

-- BillyKoos - 29 Dec 2011

Billy Koos, thank you for your detailed response. Did the change work for you? It did not work for me after the change.

-- AlexWayne - 01 Feb 2012

Hi, I am hoping that the Excel2Topics functionality of this plugin has not become completely abandoned and obsolete, and that someone still monitoring this issue can lend a helping hand.

I am using Foswiki 1.1.4 and even attempting to invoke the test/example Import via the IssueExcelExportImport topic in the Sandbox produces the following error:

** Foswiki detected an internal error - please check your Foswiki logs and webserver logs for more information.

Can't locate object method "get" via package "DylanMaccarone" (perhaps you forgot to load "DylanMaccarone"?) **

Interestingly enough the Export example from the same topic seems to work fine, but Import fails every time. None of the apache/perl configuration edits suggested here or in Item8494 have made any difference.

Are there any other suggestions for restoring the functionality of this potentially extremely useful plugin feature? Any guidance would be greatly appreciated, thanks...

-- DylanMaccarone - 07 Aug 2012

I ran into this same issue in a Foswiki 2.1.2 installation (see Item14190) and later reviewed this task and tried out the modification mentioned above. It works! Just to add to that, the change described there is around line 280 of lib/Foswiki/Plugins/ExcelImportExportPlugin/Import.pm. I'm changing the status task to "confirmed" and modifying the title to be more descriptive of change needed.

-- Main.LynnwoodBrown - 30 Sep 2016 - 21:47

Commenting is disabled while not logged in