Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

[Jason Clemons]

I have say, upgrading makes me very nervous too..so, I'd definitely vote for 
anything that changes or enhances that process.  So far, I'm terrified to even 
try an upgrade (currently on 5.4) since my wiki is production and we've done a 
fair bit of customized solutions to unique problems (likely not in a 
"supported" way maybe) .  My fear is that some piece of code or settings will 
get overwritten which will break stuff and I won't know where to look to fix 
them.  😃

A wizard would be awesome to take the guess work out of it.  As is, I've read 
some of the tutorials out there regarding upgrades several times but I'm not 
really able to determine the prescribed steps using those.

I think at the end of the day I'm going to end up exporting my solutions as 
XAR's and then try importing them into an upgraded Xwiki environment too, since 
it seems easier to me.

> On Dec 9, 2014, at 2:58 PM, Jeremie BOUSQUET  
> wrote:
> 
> Le 9 déc. 2014 22:37, "Thomas Mortagne"  a écrit
> :
>> 
>> On Tue, Dec 9, 2014 at 10:28 PM, Guillaume Lerouge 
> wrote:
>>> Hi,
>>> 
>>> On Tue, Dec 9, 2014 at 10:23 PM, Thomas Mortagne <
> thomas.morta...@xwiki.com>
>>> wrote:
>>> 
 On Tue, Dec 9, 2014 at 9:57 PM, Harald Ommang > 
 wrote:
> Hi!
> 
> In one way, I very much appreciate the relatively high frequency of
 updates done by the XWIKI crew. You are doing a great job, making sure
> that
 XWIKI is alive and kicking and always improving.
> 
> The downside to this, is all the work needed to be done when
> upgrading.
 So, I don't do that very often. The basic part of
> installation/migration
 works very well, but when it comes to content, the upgrade procedure is
 messy, as I see it. It is a hassle to have to pick and choose between
 various parts when importing and exported XAR.
> 
> I would very much suggest planning for a future where the parts that
> are
 XWIKI software are clearly separated from the parts where customers
 typically do modifications. Especially items like users and groups. It
 should be possible to have a more separated export/import so that you
> GET
 new versions of e.g. the admin pages, while still KEEPING your setup of
 users, groups, etc., without having to click on a million of
> checkboxes in
 the import.
 
 I don't really understand this comment, doing export/import is really
 not the standard way of doing an upgrade. In typical upgrade you
 backup everything if you want to be safe (or better you have automated
 backups and you don't really need to do it when you upgrade), upgrade
 the WAR part (if you use the Debian package then it's just about doing
 apt-get upgrade or install with a specific version), restart, XWiki
 upgrade the database shema automatically if needed and then you get
 the Distribution Wizard which download and upgrade the wiki pages with
 3 ways merge. Most of the time you don't have anything to do.
>>> 
>>> Sure, but to benefit from all those nice Distribution Wizard features,
>>> Harald would first need to... upgrade to the latest version ;-)
>> 
>> Distribution Wizard has been introduced in 4.2 so not really the
>> latest version. And even before that export/import everything never
>> really been standard upgrade process either.
> 
> Sure, but you usually did reverse way : import new xwiki ui xar (and
> remember to uncheck standard pages customized, or have them overwritten).
> And yes, it was sometimes a hassle, and compared to that distribution
> wizard is really really great :)
> 
>> 
>>> 
>>> Guillaume
>>> ___
>>> users mailing list
>>> users@xwiki.org
>>> http://lists.xwiki.org/mailman/listinfo/users
>> 
>> 
>> 
>> --
>> Thomas Mortagne
>> ___
>> users mailing list
>> users@xwiki.org
>> http://lists.xwiki.org/mailman/listinfo/users
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

[xwiki-users] Reading a file submitted from a form

[Bryn Jeffries]

I think the problem has more to do with the FileUploadPlugin returning an array 
containing entries for all form field items, not just the file inputs. Also, 
the FileItem getFile(FormFieldName) method in the plugin is not exposed in the 
FileUploadPlugin API, so I had to resort to getting the whole List 
and iterating through to finding one with a matching field instead of assuming 
I knew the correct index.

I'm keeping my fingers crossed that the XWiki folks don't start using one-based 
arrays 

> -Original Message-
> From: Hamster [mailto:teun...@hotmail.com]
> Sent: Tuesday, 9 December 2014 9:04 PM
> To: users@xwiki.org
> Subject: Re: [xwiki-users] Reading a file submitted from a form
>
> The joy of zero-based vs one-based arrays :-)
>



___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

[Jeremie BOUSQUET]

Le 9 déc. 2014 22:37, "Thomas Mortagne"  a écrit
:
>
> On Tue, Dec 9, 2014 at 10:28 PM, Guillaume Lerouge 
wrote:
> > Hi,
> >
> > On Tue, Dec 9, 2014 at 10:23 PM, Thomas Mortagne <
thomas.morta...@xwiki.com>
> > wrote:
> >
> >> On Tue, Dec 9, 2014 at 9:57 PM, Harald Ommang 
> >> wrote:
> >> > Hi!
> >> >
> >> > In one way, I very much appreciate the relatively high frequency of
> >> updates done by the XWIKI crew. You are doing a great job, making sure
that
> >> XWIKI is alive and kicking and always improving.
> >> >
> >> > The downside to this, is all the work needed to be done when
upgrading.
> >> So, I don't do that very often. The basic part of
installation/migration
> >> works very well, but when it comes to content, the upgrade procedure is
> >> messy, as I see it. It is a hassle to have to pick and choose between
> >> various parts when importing and exported XAR.
> >> >
> >> > I would very much suggest planning for a future where the parts that
are
> >> XWIKI software are clearly separated from the parts where customers
> >> typically do modifications. Especially items like users and groups. It
> >> should be possible to have a more separated export/import so that you
GET
> >> new versions of e.g. the admin pages, while still KEEPING your setup of
> >> users, groups, etc., without having to click on a million of
checkboxes in
> >> the import.
> >>
> >> I don't really understand this comment, doing export/import is really
> >> not the standard way of doing an upgrade. In typical upgrade you
> >> backup everything if you want to be safe (or better you have automated
> >> backups and you don't really need to do it when you upgrade), upgrade
> >> the WAR part (if you use the Debian package then it's just about doing
> >> apt-get upgrade or install with a specific version), restart, XWiki
> >> upgrade the database shema automatically if needed and then you get
> >> the Distribution Wizard which download and upgrade the wiki pages with
> >> 3 ways merge. Most of the time you don't have anything to do.
> >>
> >
> > Sure, but to benefit from all those nice Distribution Wizard features,
> > Harald would first need to... upgrade to the latest version ;-)
>
> Distribution Wizard has been introduced in 4.2 so not really the
> latest version. And even before that export/import everything never
> really been standard upgrade process either.

Sure, but you usually did reverse way : import new xwiki ui xar (and
remember to uncheck standard pages customized, or have them overwritten).
And yes, it was sometimes a hassle, and compared to that distribution
wizard is really really great :)

>
> >
> > Guillaume
> > ___
> > users mailing list
> > users@xwiki.org
> > http://lists.xwiki.org/mailman/listinfo/users
>
>
>
> --
> Thomas Mortagne
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

[Thomas Mortagne]

On Tue, Dec 9, 2014 at 10:31 PM, Harald Ommang  wrote:
> Good, I was hoping I was wrong.
> If I am not completely wrong, my comment used to be valid...?
>
> What do you mean with "3 ways merge"?
> It is now clear to me that there is more to the Distribution Wizard than has 
> (yet) met my eye :-)

When you install a XAR extension (and the standard UI is a tree of XAR
extension) each page get a 3 ways merge meaning that you get a merge
between 3 versions: the previous standard version, what is currently
in the database (i.e. you modifications) and the new standard version.
That means that your changes are kept when you upgrade unless your
changed conflict with a change between standard previous and new
version in which case you can a detailed conflict UI where you can
choose which version you want (and a proposed merge).

>
> Harald
>
> -Original Message-
> From: users [mailto:users-boun...@xwiki.org] On Behalf Of Thomas Mortagne
> Sent: 9. desember 2014 22:24
> To: XWiki Users
> Subject: Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?
>
> On Tue, Dec 9, 2014 at 9:57 PM, Harald Ommang  
> wrote:
>> Hi!
>>
>> In one way, I very much appreciate the relatively high frequency of updates 
>> done by the XWIKI crew. You are doing a great job, making sure that XWIKI is 
>> alive and kicking and always improving.
>>
>> The downside to this, is all the work needed to be done when upgrading. So, 
>> I don't do that very often. The basic part of installation/migration works 
>> very well, but when it comes to content, the upgrade procedure is messy, as 
>> I see it. It is a hassle to have to pick and choose between various parts 
>> when importing and exported XAR.
>>
>> I would very much suggest planning for a future where the parts that are 
>> XWIKI software are clearly separated from the parts where customers 
>> typically do modifications. Especially items like users and groups. It 
>> should be possible to have a more separated export/import so that you GET 
>> new versions of e.g. the admin pages, while still KEEPING your setup of 
>> users, groups, etc., without having to click on a million of checkboxes in 
>> the import.
>
> I don't really understand this comment, doing export/import is really not the 
> standard way of doing an upgrade. In typical upgrade you backup everything if 
> you want to be safe (or better you have automated backups and you don't 
> really need to do it when you upgrade), upgrade the WAR part (if you use the 
> Debian package then it's just about doing apt-get upgrade or install with a 
> specific version), restart, XWiki upgrade the database shema automatically if 
> needed and then you get the Distribution Wizard which download and upgrade 
> the wiki pages with
> 3 ways merge. Most of the time you don't have anything to do.
>
>>
>> Best regards
>> Harald Ommang
>> Norway
>> ___
>> users mailing list
>> users@xwiki.org
>> http://lists.xwiki.org/mailman/listinfo/users
>
>
>
> --
> Thomas Mortagne
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users



-- 
Thomas Mortagne
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

[Thomas Mortagne]

On Tue, Dec 9, 2014 at 10:28 PM, Guillaume Lerouge  wrote:
> Hi,
>
> On Tue, Dec 9, 2014 at 10:23 PM, Thomas Mortagne 
> wrote:
>
>> On Tue, Dec 9, 2014 at 9:57 PM, Harald Ommang 
>> wrote:
>> > Hi!
>> >
>> > In one way, I very much appreciate the relatively high frequency of
>> updates done by the XWIKI crew. You are doing a great job, making sure that
>> XWIKI is alive and kicking and always improving.
>> >
>> > The downside to this, is all the work needed to be done when upgrading.
>> So, I don't do that very often. The basic part of installation/migration
>> works very well, but when it comes to content, the upgrade procedure is
>> messy, as I see it. It is a hassle to have to pick and choose between
>> various parts when importing and exported XAR.
>> >
>> > I would very much suggest planning for a future where the parts that are
>> XWIKI software are clearly separated from the parts where customers
>> typically do modifications. Especially items like users and groups. It
>> should be possible to have a more separated export/import so that you GET
>> new versions of e.g. the admin pages, while still KEEPING your setup of
>> users, groups, etc., without having to click on a million of checkboxes in
>> the import.
>>
>> I don't really understand this comment, doing export/import is really
>> not the standard way of doing an upgrade. In typical upgrade you
>> backup everything if you want to be safe (or better you have automated
>> backups and you don't really need to do it when you upgrade), upgrade
>> the WAR part (if you use the Debian package then it's just about doing
>> apt-get upgrade or install with a specific version), restart, XWiki
>> upgrade the database shema automatically if needed and then you get
>> the Distribution Wizard which download and upgrade the wiki pages with
>> 3 ways merge. Most of the time you don't have anything to do.
>>
>
> Sure, but to benefit from all those nice Distribution Wizard features,
> Harald would first need to... upgrade to the latest version ;-)

Distribution Wizard has been introduced in 4.2 so not really the
latest version. And even before that export/import everything never
really been standard upgrade process either.

>
> Guillaume
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users



-- 
Thomas Mortagne
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

[xwiki-users] List of special characters to avoid in page title

[Yves Moisan]

Hi,

Using XWiki Enterprise 5.2, standalone install.  We notice dots (.) in 
page titles are escaped in HSQLDB (e.g. when I cat the contents of 
xwiki_db.log and grep something particular in the article I'm seeking) :


INSERT INTO XWIKIDOC VALUES(...,'Ressources.Some page title with 
accented characters in French (2007)\. Plan de rel\u00e8ve bla bla de 
salle d''op\u00e9ration',


We can see all accented characters and special characters like the 
apostrophe in the last word ("d'opération") are escaped, but then the 
dot in the title next to "(2007)" gets escaped too.


I guess the reason it is escaped in the title is that the dot is used as 
a separator for the wiki hierarchy (Resources.Some page really is like 
the directory structure in our XWiki instance, that is Ressources/Some 
page).  Is that so ?  Can we change that behaviour or do I have to tell 
my users to stop using dots (and possibly other special characters ?) in 
page titles ?


Thanx for pointers,

Yves Moisan
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

[Harald Ommang]

-Original Message-
From: users [mailto:users-boun...@xwiki.org] On Behalf Of Guillaume Lerouge
Sent: 9. desember 2014 22:29
To: XWiki Users
Subject: Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

Hi,

On Tue, Dec 9, 2014 at 10:23 PM, Thomas Mortagne 
wrote:

> On Tue, Dec 9, 2014 at 9:57 PM, Harald Ommang 
> 
> wrote:
> > Hi!
> >
> > In one way, I very much appreciate the relatively high frequency of
> updates done by the XWIKI crew. You are doing a great job, making sure 
> that XWIKI is alive and kicking and always improving.
> >
> > The downside to this, is all the work needed to be done when upgrading.
> So, I don't do that very often. The basic part of 
> installation/migration works very well, but when it comes to content, 
> the upgrade procedure is messy, as I see it. It is a hassle to have to 
> pick and choose between various parts when importing and exported XAR.
> >
> > I would very much suggest planning for a future where the parts that 
> > are
> XWIKI software are clearly separated from the parts where customers 
> typically do modifications. Especially items like users and groups. It 
> should be possible to have a more separated export/import so that you 
> GET new versions of e.g. the admin pages, while still KEEPING your 
> setup of users, groups, etc., without having to click on a million of 
> checkboxes in the import.
>
> I don't really understand this comment, doing export/import is really 
> not the standard way of doing an upgrade. In typical upgrade you 
> backup everything if you want to be safe (or better you have automated 
> backups and you don't really need to do it when you upgrade), upgrade 
> the WAR part (if you use the Debian package then it's just about doing 
> apt-get upgrade or install with a specific version), restart, XWiki 
> upgrade the database shema automatically if needed and then you get 
> the Distribution Wizard which download and upgrade the wiki pages with
> 3 ways merge. Most of the time you don't have anything to do.
>

>Sure, but to benefit from all those nice Distribution Wizard features, Harald 
>would first need to... upgrade to the latest version ;-)

>Guillaume

I might just do that, Guillaume :-)
Harald
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

[Harald Ommang]

Good, I was hoping I was wrong.
If I am not completely wrong, my comment used to be valid...?

What do you mean with "3 ways merge"? 
It is now clear to me that there is more to the Distribution Wizard than has 
(yet) met my eye :-)

Harald

-Original Message-
From: users [mailto:users-boun...@xwiki.org] On Behalf Of Thomas Mortagne
Sent: 9. desember 2014 22:24
To: XWiki Users
Subject: Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

On Tue, Dec 9, 2014 at 9:57 PM, Harald Ommang  wrote:
> Hi!
>
> In one way, I very much appreciate the relatively high frequency of updates 
> done by the XWIKI crew. You are doing a great job, making sure that XWIKI is 
> alive and kicking and always improving.
>
> The downside to this, is all the work needed to be done when upgrading. So, I 
> don't do that very often. The basic part of installation/migration works very 
> well, but when it comes to content, the upgrade procedure is messy, as I see 
> it. It is a hassle to have to pick and choose between various parts when 
> importing and exported XAR.
>
> I would very much suggest planning for a future where the parts that are 
> XWIKI software are clearly separated from the parts where customers typically 
> do modifications. Especially items like users and groups. It should be 
> possible to have a more separated export/import so that you GET new versions 
> of e.g. the admin pages, while still KEEPING your setup of users, groups, 
> etc., without having to click on a million of checkboxes in the import.

I don't really understand this comment, doing export/import is really not the 
standard way of doing an upgrade. In typical upgrade you backup everything if 
you want to be safe (or better you have automated backups and you don't really 
need to do it when you upgrade), upgrade the WAR part (if you use the Debian 
package then it's just about doing apt-get upgrade or install with a specific 
version), restart, XWiki upgrade the database shema automatically if needed and 
then you get the Distribution Wizard which download and upgrade the wiki pages 
with
3 ways merge. Most of the time you don't have anything to do.

>
> Best regards
> Harald Ommang
> Norway
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users



--
Thomas Mortagne
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

[Guillaume Lerouge]

Hi,

On Tue, Dec 9, 2014 at 10:23 PM, Thomas Mortagne 
wrote:

> On Tue, Dec 9, 2014 at 9:57 PM, Harald Ommang 
> wrote:
> > Hi!
> >
> > In one way, I very much appreciate the relatively high frequency of
> updates done by the XWIKI crew. You are doing a great job, making sure that
> XWIKI is alive and kicking and always improving.
> >
> > The downside to this, is all the work needed to be done when upgrading.
> So, I don't do that very often. The basic part of installation/migration
> works very well, but when it comes to content, the upgrade procedure is
> messy, as I see it. It is a hassle to have to pick and choose between
> various parts when importing and exported XAR.
> >
> > I would very much suggest planning for a future where the parts that are
> XWIKI software are clearly separated from the parts where customers
> typically do modifications. Especially items like users and groups. It
> should be possible to have a more separated export/import so that you GET
> new versions of e.g. the admin pages, while still KEEPING your setup of
> users, groups, etc., without having to click on a million of checkboxes in
> the import.
>
> I don't really understand this comment, doing export/import is really
> not the standard way of doing an upgrade. In typical upgrade you
> backup everything if you want to be safe (or better you have automated
> backups and you don't really need to do it when you upgrade), upgrade
> the WAR part (if you use the Debian package then it's just about doing
> apt-get upgrade or install with a specific version), restart, XWiki
> upgrade the database shema automatically if needed and then you get
> the Distribution Wizard which download and upgrade the wiki pages with
> 3 ways merge. Most of the time you don't have anything to do.
>

Sure, but to benefit from all those nice Distribution Wizard features,
Harald would first need to... upgrade to the latest version ;-)

Guillaume
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

[Thomas Mortagne]

On Tue, Dec 9, 2014 at 9:57 PM, Harald Ommang  wrote:
> Hi!
>
> In one way, I very much appreciate the relatively high frequency of updates 
> done by the XWIKI crew. You are doing a great job, making sure that XWIKI is 
> alive and kicking and always improving.
>
> The downside to this, is all the work needed to be done when upgrading. So, I 
> don't do that very often. The basic part of installation/migration works very 
> well, but when it comes to content, the upgrade procedure is messy, as I see 
> it. It is a hassle to have to pick and choose between various parts when 
> importing and exported XAR.
>
> I would very much suggest planning for a future where the parts that are 
> XWIKI software are clearly separated from the parts where customers typically 
> do modifications. Especially items like users and groups. It should be 
> possible to have a more separated export/import so that you GET new versions 
> of e.g. the admin pages, while still KEEPING your setup of users, groups, 
> etc., without having to click on a million of checkboxes in the import.

I don't really understand this comment, doing export/import is really
not the standard way of doing an upgrade. In typical upgrade you
backup everything if you want to be safe (or better you have automated
backups and you don't really need to do it when you upgrade), upgrade
the WAR part (if you use the Debian package then it's just about doing
apt-get upgrade or install with a specific version), restart, XWiki
upgrade the database shema automatically if needed and then you get
the Distribution Wizard which download and upgrade the wiki pages with
3 ways merge. Most of the time you don't have anything to do.

>
> Best regards
> Harald Ommang
> Norway
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users



-- 
Thomas Mortagne
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

[xwiki-users] Page created from Velocity with template can't be edited

[Jason Clemons]

Hello all,

I have an issue with some Velocity code I got from here ---> 
http://extensions.xwiki.org/xwiki/bin/view/Extension/Create+Page+With+Object

When the code runs the resulting page is created and the template is used, but 
none of my users can edit the page after (not even the admin).  It looks like 
the template page was actually included in the page, not that the page was 
created "from" the template.  

Here is the code I'm using:

{{velocity}}
 
#set($newDoc = $xwiki.getDocument("Sandbox.TestPage"))
$newDoc.setTitle("TestPage")
$newDoc.setParent("Sandbox.WebHome")
$newDoc.setContent('{{include document="Templates.TemplateToUse"/}}')
 
$newDoc.save()
 
{{/velocity}}

When I go to my space and create a new page manually and select to use a 
template for the new page the resulting page CAN be edited appropriately using 
the EXACT SAME TEMPLATE, so I'm very confused.

Any help is greatly appreciated
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

[Harald Ommang]

Hi!

In one way, I very much appreciate the relatively high frequency of updates 
done by the XWIKI crew. You are doing a great job, making sure that XWIKI is 
alive and kicking and always improving.

The downside to this, is all the work needed to be done when upgrading. So, I 
don't do that very often. The basic part of installation/migration works very 
well, but when it comes to content, the upgrade procedure is messy, as I see 
it. It is a hassle to have to pick and choose between various parts when 
importing and exported XAR.

I would very much suggest planning for a future where the parts that are XWIKI 
software are clearly separated from the parts where customers typically do 
modifications. Especially items like users and groups. It should be possible to 
have a more separated export/import so that you GET new versions of e.g. the 
admin pages, while still KEEPING your setup of users, groups, etc., without 
having to click on a million of checkboxes in the import.

Best regards
Harald Ommang
Norway
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Query external MSSQL DB in a wiki page

[Bryn Jeffries]

I have managed the following with an external PostgreSQL server:
Retrieve and display queried data in a page with Groovy;
Write a Java component to perform query, call and display with Groovy or 
Velocity;
Generate JSON data of query results with Groovy, call and display from 
LiveTable.

Happy to share but not near my computer till later today, so let me know which 
of the above is closest to what you want to do and I'll post something when I 
can.

- Reply message -
From: "Jason Clemons" 
To: "Xwiki Users" 
Cc: "Clemons Jason" 
Subject: [xwiki-users] Query external MSSQL DB in a wiki page
Date: Tue, Dec 9, 2014 08:26


Hello,

Can anyone point me in the right direction?  I'm trying to query and external 
Microsoft SQL database from a wiki page.  My current wiki runs on MSSQL just 
fine using sqljdbc4.jar configured with hibernate.  The DB I want to query is 
actually on the same server, I can actually make it appear in the same DB if 
that makes things easier.

I've looked at SQL Tools extension --> 
http://extensions.xwiki.org/xwiki/bin/view/Extension/SQL+Tools  and I can get 
that to work just fine even querying the other database, but I don't know how 
to make the results of a query from that tool appear in a separate page I've 
created for use in Velocity for example.

I've tried to get the example on the "Execute SQL" page here --> 
http://extensions.xwiki.org/xwiki/bin/view/Extension/Execute+SQL to work but I 
get a Groovy error on the second snippet and nothing at all appears on the page 
using the first snippet (but no error).

I've also looked at this plugin --> 
http://xwikisql.gradsoft.ua/docs/XWikiSqlPluginGuide.html  but it hasn't been 
updated since 2008, so I'm not really sure that's a good idea from a 
sustainability perspective in a production environment.

Ultimately, I will have a flat table in some database, really any database 
(e.g..it can be the XWIKI DB)..and I need to be able to get the rows and 
columns from the table and expose them as an HTML table in my wiki page.  Once 
I figure out how to get the data making it into a table is easy enough, but I 
can't even figure out how to get an object or array with the data in it to 
iterate.

All help is greatly appreciated.

Thanks in advance,

Jason

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Reading a file submitted from a form

[Bryn Jeffries]

I think the problem has more to do with the FileUploadPlugin returning an array 
containing entries for all form field items, not just the file inputs. Also, 
the FileItem getFile(FormFieldName) method in the plugin is not exposed in the 
FileUploadPlugin API, so I had to resort to getting the whole List 
and iterating through to finding one with a matching field instead of assuming 
I knew the correct index.

I'm keeping my fingers crossed that the XWiki folks don't start using one-based 
arrays 

> -Original Message-
> From: Hamster [mailto:teun...@hotmail.com]
> Sent: Tuesday, 9 December 2014 9:04 PM
> To: users@xwiki.org
> Subject: Re: [xwiki-users] Reading a file submitted from a form
> 
> The joy of zero-based vs one-based arrays :-)
> 


___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

[Dmitry Bakbardin]

Hi!
I'd add a list of proposals:

1.  Add SRD documentation for XWiki 6.x
2.  Some URLs are not shortened when using Tuckey's UrlRewriteFilter 
(even it is closed - there are some problems noted in tha last comment)
3.  Admin Tools Application bug in Export pages with ' sign in page name

4.  Broken cross-wiki links on page rename
XWiki works fine in miltiwiki's environment, but page rename breaks cross-wiki 
links :(

5.  Wiki to wiki rename in multiwiki environment

6.  New ADD Link scenario in WYSIWYG editor - wiki -> Space -> Page -> Anchor 
selector in the WYSIWYG editor

7. XWiki.DeletedAttachments shows nothing when filesystem attachments are 
enabled. 

8.  Shrink Recycle Bin works only with main wiki and gives an error in attempt 
to purge all documents in recycle bin


Kind regards,

Dmitry

Fri, 5 Dec 2014 19:19:52 +0200 от Marius Dumitru Florea 
:
>On Fri, Dec 5, 2014 at 2:34 PM, Daniel Lundh < dlu...@gmail.com > wrote:
>> Hello.
>>
>> New XWiki user here.
>>
>> First, a big thanks, we are enjoying XWiki. :)
>>
>> We have a fairly common use case, using the wiki for documenting servers
>> and systems, trying to build an SKMS ala ITIL.
>>
>> What i'd like to see is better formatting of text being cut & pasted from
>> (mainly) Word.
>> The single biggest issue I have heard complaints about is formatting.
>> We are moving away from a Lotus Domino environment and here too the
>> formatting is mangled (this may have everything to do with Domino and
>> nothing with XWiki however) when doing copy/paste.
>>
>> I'd like tables to work like they do in Excel. When I press the tab key I
>> want to move to the next field.
>> I want to be able to size the table with my mouse in real-time.
>> I want the columns to be plainly visible, not just the rows.
>>
>> I want numbered lists to be a core feature.
>>
>
>> Making text different colors and/or fonts should work like in a regular
>> word processor, with a menu item in the WYSIWYG editor.
>
>This is already possible.
>http://platform.xwiki.org/xwiki/bin/view/Features/WysiwygEditor#HQuickReference
>. You need to enable it from the WYSIWYG editor section in the wiki
>administration. It's not very straightforward but this
>http://platform.xwiki.org/xwiki/bin/view/AdminGuide/WysiwygEditor#HPluginsandFeatures
>can help.
>
>The rest is very good feedback.
>
>Thanks,
>Marius
>
>>
>> That's from the top of my head, anyway.
>>
>> Have a great weekend.
>>
>> Regards,
>> Daniel
>>
>>
>>
>> On Fri, Dec 5, 2014 at 1:17 PM,  vinc...@massol.net < vinc...@massol.net >
>> wrote:
>>
>>> Dear XWiki users,
>>>
>>> We’re getting close to the end of the XWiki 6.x cycle (6.4 is planned for
>>> the end of December) and in January we’ll start developing the XWiki 7.x
>>> cycle (which will last the whole 2015 year), starting with XWiki 7.0.
>>>
>>> Thus it’s time for the XWiki devs to start defining the global roadmap for
>>> XWiki 7.x.
>>>
>>> As XWiki users, I’d like to know if you have some needs for XWiki 7.x.
>>> What would you be interested in seeing in XWiki 7.x?
>>>
>>> I’d like to start some proposal on the xwiki devs list (for the XWiki 7.x
>>> cycle) around end of December so it would be nice if you could shoot your
>>> suggestion ideas fast so that we can take them into account in the
>>> discussion! :)
>>>
>>> Thanks a lot for your help and I hope you’re enjoying using XWiki!
>>>
>>> -Vincent Massol
>>> XWiki Committer
>>>
>>>
>>> ___
>>> users mailing list
>>>  users@xwiki.org
>>>  http://lists.xwiki.org/mailman/listinfo/users
>>>
>>
>>
>>
>> --
>>
>> Regards/Mvh
>> Daniel Lundh
>> ___
>> users mailing list
>>  users@xwiki.org
>>  http://lists.xwiki.org/mailman/listinfo/users
>___
>users mailing list
>users@xwiki.org
>http://lists.xwiki.org/mailman/listinfo/users



___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Reading a file submitted from a form

[Hamster]

The joy of zero-based vs one-based arrays :-)



--
View this message in context: 
http://xwiki.475771.n2.nabble.com/Reading-a-file-submitted-from-a-form-tp7593368p7593394.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

[Hamster]

jerem wrote
> For the same reason you talked about numbered headings, because ideally
> I'd
> propose to have titles better by default :)
> BTW there's an extension to get numbered headings:
> http://extensions.xwiki.org/xwiki/bin/view/Extension/Numbered+Headings

True, my only concern is that the  TOC Macro
   is
maintained by the XWiki Development Team , but the  Numbered Headings
  
is not (it's a contribution by Jeremie Bousquet). So future versions of
XWIki might break the Numbered Headings. Those two extensions should idealy
considered as one. :-)



--
View this message in context: 
http://xwiki.475771.n2.nabble.com/What-would-you-like-to-see-in-the-XWiki-7-x-cycle-tp7593349p7593393.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

[Jeremie BOUSQUET]

Hi,

2014-12-09 9:00 GMT+01:00 Hamster :

> jerem wrote
> > - they usually consider that readability of titles and sub-titles
> > (headings) inside wiki pages is not very good, difficult to differentiate
> > them
>
> Why don't you use a "Style Sheet Extension" and completely define how each
> Header should look like?
>

For the same reason you talked about numbered headings, because ideally I'd
propose to have titles better by default :)
BTW there's an extension to get numbered headings:
http://extensions.xwiki.org/xwiki/bin/view/Extension/Numbered+Headings


>
> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Skins
> http://platform.xwiki.org/xwiki/bin/view/DevGuide/SkinExtensionsTutorial
>
>
>
> --
> View this message in context:
> http://xwiki.475771.n2.nabble.com/What-would-you-like-to-see-in-the-XWiki-7-x-cycle-tp7593349p7593388.html
> Sent from the XWiki- Users mailing list archive at Nabble.com.
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

[Pascal BASTIEN]

Yes you are right it is http://ckeditor.com/   (I was confused because I tested 
MoinMoin editor http://moinmo.in/FCKeditor  and FckEditor probably changed his 
name)
 

  De : Hamster 
 À : users@xwiki.org 
 Envoyé le : Mardi 9 décembre 2014 9h06
 Objet : Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?
   
PascalB wrote
> WYSIWYG based on 
*
> FckEditor
*
>  better to work on tables IMO
> +1: "I want the columns to be plainly visible, not just the rows"
> especially when we edit a table

FckEditor? Or do you mean  CKEditor   ?



--
View this message in context: 
http://xwiki.475771.n2.nabble.com/What-would-you-like-to-see-in-the-XWiki-7-x-cycle-tp7593349p7593389.html
Sent from the XWiki- Users mailing list archive at Nabble.com.


___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


  
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

[Pascal BASTIEN]

+1 for numbered header
+0 about TOC (user must be able to choose if he want a TOC on his page)
In someone interested, on (my wiki), I use that to add numbered header and 
TOC:http://extensions.xwiki.org/xwiki/bin/view/Extension/TOC+Macro#HExample4:TOCnumberingcorrespondingatNumberedHeadings
To add this code by default:---{{box 
cssClass="floatinginfobox" title="**Sommaire**"}}
{{toc numbered="true" depth="3"/}}
{{/box}}

{{numberedheadings/}}


//Voici le formatage type d'une page de l'Encyclopédie qu'il est conseillé 
d'appliquer.
Si vous souhaitez conserver cette mise en page avec sommaire vous devez 
remplacer ce texte (et ne pas supprimer les macros ci-dessus).//

= Titre de niveau un =

Texte
--- in all new doc of Encyclopédie space, I modify 
./templates/editwysiwygnew.vm with---
## Affiche un contenu type pour tous les nouveaux documents ouvert avec Wysiwyg
#set($itemModLContenu = 
$xwiki.getDocument($escapetool.xml("Personnalisation.ModeleContenuEncyclopédie")))
#if ($tdoc.content == "" && $tdoc.space == $escapetool.xml("Encyclopédie"))
  $xwiki.getTextArea($itemModLContenu.getContent())
#else
  $xwiki.getTextArea($tdoc.content)
#end
---Anyway, someone (who?) create a whishlist page on 
xwiki.org? Or is it useless?
Thxs
Pascal B

 De : Hamster 
 À : users@xwiki.org 
 Envoyé le : Mardi 9 décembre 2014 8h38
 Objet : Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?
   
What I would like to see in XWiki 7.x:

- A standard way of navigating the Wiki (I know there a several Extensions
available, but this needs to be a basic feature of XWiki). This is my no. 1
complaint ;-).
- Better layout, with numbered headers. This is the no. 1 complaint from our
users. They are used to the way MS Word is able to format their documents.
Numbered lists with blank lines for example.
- A standard "Table of Contents", which displays the headers on a
(large)page. This TOC should be "dockable"/"collapsable", iow always
available to the users.
- Automatic Update/Upgrade to latest XWiki version.




--
View this message in context: 
http://xwiki.475771.n2.nabble.com/What-would-you-like-to-see-in-the-XWiki-7-x-cycle-tp7593349p7593387.html
Sent from the XWiki- Users mailing list archive at Nabble.com.


___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


  
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

[Hamster]

PascalB wrote
> WYSIWYG based on 
*
> FckEditor
*
>  better to work on tables IMO
> +1: "I want the columns to be plainly visible, not just the rows"
> especially when we edit a table

FckEditor? Or do you mean  CKEditor   ?



--
View this message in context: 
http://xwiki.475771.n2.nabble.com/What-would-you-like-to-see-in-the-XWiki-7-x-cycle-tp7593349p7593389.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] What would you like to see in the XWiki 7.x cycle?

[Hamster]

jerem wrote
> - they usually consider that readability of titles and sub-titles
> (headings) inside wiki pages is not very good, difficult to differentiate
> them

Why don't you use a "Style Sheet Extension" and completely define how each
Header should look like?

http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Skins
http://platform.xwiki.org/xwiki/bin/view/DevGuide/SkinExtensionsTutorial



--
View this message in context: 
http://xwiki.475771.n2.nabble.com/What-would-you-like-to-see-in-the-XWiki-7-x-cycle-tp7593349p7593388.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users