Hi Dave
I will remove this subdirectory from the .zip file.
Thanks for the feedbackChristian
-------- Ursprüngliche Nachricht --------
Von: Dave Koelmeyer <dave.koelme...@davekoelmeyer.co.nz>
Datum: 29.03.2016 06:20 (GMT+01:00)
An: dev@jspwiki.apache.org
Betreff: Re: WorksheetPlugin
Hi Christian,
Just about to give this a whirl, when the
"WorksheetPlugin-jar-dependencies.zip" file is extracted it seems to
also create a subdirectory containing what looks like OS X resource
forks ("__MACOSX") – is this needed at all?
Cheers,
Dave
On 26/03/16 02:57, Christian Froehler wrote:
> Hi,
>
> so I spent some work on the Plugin...
>
> - Apache POI offers a class "ToHtml" in its "poi-examples.jar" which does an
> excellent job, including .css formatting.
> Therefore I removed the dependency to the "Table" plugin
>
> - Had a hard time understanding why the Plugin would break my existing
> JSPWiki installation at work....
> We are still on JSPWiki 2.8.2, and the Java import statements are different
> with the old version of JSPWiki.
> Therefore I have two dev branches of the WorksheetPlugin now, one for JSPWiki
> 2.8+, the other one for JSPWiki 2.10. Haven't tried with 2.9
> (We'll update to 2.10 soon.)
>
> - License is now Apache License 2.0
>
> - Created the page
> https://jspwiki-wiki.apache.org/Wiki.jsp?page=WorksheetPlugin
> <https://jspwiki-wiki.apache.org/Wiki.jsp?page=WorksheetPlugin>, but it seems
> to be visible only when logged in.
> Could someone please review the page and make it accessible (if everything is
> fine with it).
>
> - I added the following "warning" text on the wiki page:
> While the WorksheetPlugin seems to work quite well, it is still new software.
> Please report any errors/problems with the plugin in the Github issue tracker
> <https://github.com/generatorr/WorksheetPlugin/issues> or on one of the
> mailing lists <http://jspwiki.apache.org/community/mailing_lists.html>
>
> - Source code of the Plugin is actually only 141 lines of code, including
> comments.
> With JSPWiki and POI it feels literally like standing on the shoulders of
> giants.
>
> - Feedback is very welcome
>
> best regards
>
> Christian
>
>
>
>
>> Am 21.03.2016 um 01:21 schrieb David Vittor <dvit...@gmail.com>:
>>
>> Hi Christian,
>>
>> Glad to hear you liked my "How To Write A Plugin" page :)
>>
>> Yes the log4j part I added in there for debugging and ensuring the code in
>> the plugin used the log4j framework, but I think Juan is right that it
>> probably does not need to be bundled into the plugin. This page will have
>> to be updated.
>>
>> I'm very excited by your plugin, as I'm currently working on something
>> similar. I'm building an Javascript/AJAX plugin for storing, adding and
>> editing data information (Excel for the cloud).
>>
>> I'll check out your plugin when I return from my holidays in a few weeks.
>> But good on you for writing and sharing it with the community!
>>
>> Cheers,
>> David V
>>
>>
>>
>>
>>
>>
>> On Mon, Mar 21, 2016 at 7:48 AM, cfr Mails 2016 <cfr2...@gmx.net> wrote:
>>
>>> Thanks Harry, I could create my account now.
>>>
>>> Thanks Juan Pablo, for your feedback; I will do as suggested.
>>> Just one remark:
>>> I added the "log4j.properties" file because it was written here:
>>> https://jspwiki-wiki.apache.org/Wiki.jsp?page=HowToWriteAPlugin <
>>> https://jspwiki-wiki.apache.org/Wiki.jsp?page=HowToWriteAPlugin>
>>> The page was an excellent help to implement the Plugin, but in that point
>>> it might have to be updated.
>>>
>>> I will use and test the plugin in this week, then update repository and
>>> wiki.
>>>
>>> best regards
>>> Christian
>>>
>>>
>>>
>>>> Am 20.03.2016 um 21:26 schrieb Harry Metske <harry.met...@gmail.com>:
>>>>
>>>> I re-enabled user registration on the wiki, you should be able to
>>> register
>>>> now.
>>>>
>>>> Regards,
>>>> Harry
>>>> Op 20 mrt. 2016 9:21 p.m. schreef "Juan Pablo Santos Rodríguez" <
>>>> juanpablo.san...@gmail.com>:
>>>>
>>>>> Hi Christian,
>>>>>
>>>>> thanks for sharing your plugin!
>>>>>
>>>>> - re. packaging additional files, as you're shipping a maven project,
>>> the
>>>>> easiest way to distribute your plugin is to declare the additional jars
>>> as
>>>>> dependecies (as you've done). That way, anyone retrieving your plugin is
>>>>> going to get the additional jars as part of their build
>>>>>
>>>>> - re. adding Table plugin, IMO is ok (Dirk can correct me, as he's the
>>>>> author), but I think at least you should explicitly note it, either in
>>> the
>>>>> code or in the readme.md file..
>>>>>
>>>>> - re. licenses, AL is fine, but if you are unsure, you can check
>>>>> http://choosealicense.com/ to see which license fits you more
>>>>>
>>>>> - re. jspwiki-wiki.a.o issues, we recently got a huge wave of spam, so
>>> the
>>>>> wiki's policies have been changed in order to not allow indiscriminated
>>>>> edits, or users or groups creation. In the meantime, I'll add a link to
>>>>> https://jspwiki-wiki.apache.org/Wiki.jsp?page=ContributedPlugins
>>> pointing
>>>>> to https://github.com/generatorr/WorksheetPlugin with proper credits.
>>> As
>>>>> for the upload section, it looks like a permissions issue + a bug (you
>>>>> shouldn't see an error page). I'll try to take a look at it this week..
>>>>>
>>>>> - Finally, re. the code itself, overall it looks ok to me, only 3 small
>>>>> things:
>>>>> * I'd delete the log4j.properties file
>>>>> * add some more tests
>>>>> * on the pom.xml file, remove the use of the copy-dependencies plugin,
>>> the
>>>>> poi dependencies are going to be pushed with your plugin.
>>>>>
>>>>>
>>>>> br,
>>>>> juan pablo
>>>>>
>>>>> On Sun, Mar 20, 2016 at 7:29 PM, cfr Mails 2016 <cfr2...@gmx.net>
>>> wrote:
>>>>>> Hi JSPWiki developers,
>>>>>>
>>>>>> I am working with JSPWiki since a few years now (as a user) and it is
>>>>>> really useful for distributing up-to-date information to the team.
>>>>>>
>>>>>> We are working a lot with Microsoft Office products, and people like
>>>>>> having their data stored in Excel tables.
>>>>>> In order to get this data into JSPWiki, I have been working with the
>>>>>> "Table" plugin.
>>>>>> It works, and looks good, but formatting is a bit time consuming.
>>>>>>
>>>>>> Now I have played around with Apache POI, which is a library to
>>> directly
>>>>>> access Excel Workbooks from Java Code:
>>>>>> The "Worksheet Plugin" extracts the data from from an Excel Workbook,
>>> and
>>>>>> generates a string which then will be parsed by the Table plugin.
>>>>>>
>>>>>> Through this, JSPWiki can have a Excel workbook as Attachment on a
>>> page,
>>>>>> and present its content in an ordinary wiki table.
>>>>>>
>>>>>> Usage:
>>>>>>
>>>>>> [{WorksheetPlugin src='NameOfAttachedExcel.xlsx' sheetName='MyData' }]
>>>>>>
>>>>>> For sure this is just a basic version, which just prints the content of
>>>>>> the cells.
>>>>>> Improvements could be:
>>>>>> - take care of cell formatting,
>>>>>> - support merged cells,
>>>>>> - Caching of the content, so that the excel doesn't need to be parsed
>>>>>> again and again;
>>>>>> - directly create html from the cells instead of using the "Table"
>>>>> plugin,
>>>>>> - support images and diagrams
>>>>>> - etc.
>>>>>> But this first version works.
>>>>>>
>>>>>> There are a few questions:
>>>>>> - the plugin requires a number of additional .jar files (poi.xml and
>>>>>> others).
>>>>>> Can I package these additional jar files together with "my" plugin, so
>>>>>> that the user needs to copy only one .jar file into the WEB-INF/lib
>>>>>> directory?
>>>>>>
>>>>>> - As I didn't want that the user must install the "Table" Plugin
>>>>>> additionally, I have included it's unchanged source code into the new
>>>>>> plugin.
>>>>>> Is it ok to do so? Is there a better approach?
>>>>>>
>>>>>> - under which license should I publish the plugin?
>>>>>> Everybody should be able to use and improve free of charge. JSPWiki is
>>>>>> under Apache Software License 2.0; is this what I want for
>>>>> WorksheetPlugin?
>>>>>> - I don't have access to the attachments at
>>>>>> https://jspwiki-wiki.apache.org/ <https://jspwiki-wiki.apache.org/>.
>>> The
>>>>>> wiki won't let me create an Account.
>>>>>> How can I get an account here? If the plugin proves useful, should I
>>>>>> create a page in that wiki?
>>>>>>
>>>>>> Sources are here. Please review. This is my first JSPWiki plugin.
>>> Looking
>>>>>> forward to feedback
>>>>>> https://github.com/generatorr/WorksheetPlugin <
>>>>>> https://github.com/generatorr/WorksheetPlugin>
>>>>>>
>>>>>> Download v0.1-alpha:
>>>>>> https://github.com/generatorr/WorksheetPlugin/releases <
>>>>>> https://github.com/generatorr/WorksheetPlugin/releases>
>>>>>>
>>>>>> Thanks!
>>>>>>
>>>>>> Christian
>>>
>
--
Dave Koelmeyer
http://blog.davekoelmeyer.co.nz
GPG Key ID: 0x238BFF87
