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

pencil
Priority: Normal
Current State: Confirmed
Released In: n/a
Target Release: n/a
Applies To: Extension
Component: ExcelImportExportPlugin
Branches:
Reported By: EnrikGuenter
Waiting For:
Last Change By: LynnwoodBrown
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
 

ItemTemplate edit

Summary Excel2topics needs to use Foswiki::Func::saveTopic
ReportedBy EnrikGuenter
Codebase 2.1.2, 1.1.3, 1.1.2
SVN Range
AppliesTo Extension
Component ExcelImportExportPlugin
Priority Normal
CurrentState Confirmed
WaitingFor
Checkins
TargetRelease n/a
ReleasedIn n/a
CheckinsOnBranches
trunkCheckins
masterCheckins
ItemBranchCheckins
Release02x01Checkins
Release02x00Checkins
Release01x01Checkins
Topic revision: r11 - 30 Sep 2016, LynnwoodBrown
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy