Re: [xwiki-users] TODO list small bug

2009-08-17 Thread Nikos Georgosopoulos
Well, as I was waiting for your reply, I posted it to my blog, is it in good
faith if I make a link from the page of the app to it?
http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplication?


On Mon, Aug 17, 2009 at 4:44 PM, Guillaume Lerouge guilla...@xwiki.comwrote:

 Hi Nikos,

 On Mon, Aug 17, 2009 at 4:30 PM, Nikos Georgosopoulos georg...@gmail.com
 wrote:

  I would be honored to do so, I just don't know if I have the right to
  post/edit other people work in there.


 It's a wiki, feel free to edit and add information to it as long as you do
 so in good faith and bring relevant information :-)


Thanks for clarifying this, it is formed as a wiki but it could have access
rights reserved (XWiki gives the option).




  I am sorry but I not familiar yet with
  the names of people in XWiki and I don't know if you are one of them.


 I'm definitely one of them - as every member of this community is. I
 simply happen to be posting a bit more often than most other people around
 here ;-)

 hmmm, where do you find the time? someone pays you to do that? can they pay
others too?


  I also
  have no idea where to place this, just as a comment in the page you give
 me
  or there is a more specific space/page for TODO list?


 Well, if your code works for all databases the best thing to do would be to
 update the application's XAR on the website. To do so you would need to
 export the application from your wiki and replace the current one with
 yours.

I have not tested all databases, there is the possibility that the two
changes I made have to be like this only for Oracle since not so many
Databases use CLOBS for larg strings (other use text)


 You can use
 http://code.xwiki.org/xwiki/bin/view/Applications/ImportExportApplicationto
 export the updated TODO application from your current wiki. You'll need to
 include all the pages from the original XAR file.

 You can then upload it here:

 http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplicationDownloads#Attachmentsonce
 you've made sure it works fine (by installing it on a local wiki for
 instance).


Well, I am intrigued, I will try to find some time to test around and see
but it will be a slow process. In the meantime, others could try it, isn't
there anyone else using TODO list app?


 Please let me know if you need additional help.

 Looking forward your first contribution,

 Guillaume


  On Mon, Aug 17, 2009 at 2:31 PM, Guillaume Lerouge guilla...@xwiki.com
  wrote:
 
   Hi Nikos,
  
   On Mon, Aug 17, 2009 at 1:58 PM, Nikos Georgosopoulos 
  georg...@gmail.com
   wrote:
  
Hi all,
   
I have been trying for the last day to put the TODO app in my wiki
 and
  it
kept on failing to show the mytodo list in the panel. I use Oracle
 for
backend so I thought it was that the problem. Here is the panel's
 code
corrected to work in my case (XWiki 1.9.3, Tomacat 6, Oracle XE 11):
#panelheader('My Todos')
   
#set ($hql = , BaseObject as obj, StringProperty as prop1,
LargeStringProperty as prop2 where obj.name=doc.fullName and
obj.className='XWiki.TodoClass' and obj.name 
   'XWiki.TodoClassTemplate'
and obj.id=prop1.id.id and prop1.id.name='Status'
and prop1.value  'Finished' and obj.id=prop2.id.id
and prop2.id.name ='Assignee' and prop2.value like '$context.user'
 order by doc.date desc)
   
#foreach ($todo in $xwiki.searchDocuments($hql, 5, 0))
* [$todo]
#end
#panelfooter()
   
The big difference is the LargeStringProperty (Instead of
  StringProperty
used in the XAR) and the like instead of = used to match the value.
   
For the LargeStringProperty it is strange for me that someone chose a
   CLOB
to store user names but... maybe because of the class hierarchy
  involved
   in
the user name. Then again, how can this work even without oracle?
   
For the like, well, oracle atleast will not even bother checking a
  string
against a stream. Yes the words are phonetically close but oracle
doesn't care about phonetics.
   
I hope others out there will enjoy this helpful app.
  
  
   Glad you liked it :-)
  
   It would be cool if you updated the page on code.xwiki.org explaining
  how
   you made the app work under Oracle.
  
   Thanks,
  
   Guillaume
  
  
   
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
   
  
  
  
   --
   Guillaume Lerouge
   Product Manager - XWiki
   Skype: wikibc
   Twitter: glerouge
   http://guillaumelerouge.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
 



 --
 Guillaume Lerouge
 Product Manager - XWiki
 Skype: wikibc
 Twitter: glerouge
 http://guillaumelerouge.com/
 

Re: [xwiki-users] TODO list small bug

2009-08-17 Thread Guillaume Lerouge
Hi Nikos,

On Mon, Aug 17, 2009 at 4:59 PM, Nikos Georgosopoulos georg...@gmail.comwrote:

 Well, as I was waiting for your reply, I posted it to my blog, is it in
 good
 faith if I make a link from the page of the app to it?
 http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplication?


That's a good start :-)

However, as Vincent stated it it's even better if you post it right on
XWiki.org




 On Mon, Aug 17, 2009 at 4:44 PM, Guillaume Lerouge guilla...@xwiki.com
 wrote:

  Hi Nikos,
 
  On Mon, Aug 17, 2009 at 4:30 PM, Nikos Georgosopoulos 
 georg...@gmail.com
  wrote:
 
   I would be honored to do so, I just don't know if I have the right to
   post/edit other people work in there.
 
 
  It's a wiki, feel free to edit and add information to it as long as you
 do
  so in good faith and bring relevant information :-)
 

 Thanks for clarifying this, it is formed as a wiki but it could have access
 rights reserved (XWiki gives the option).


 
 
   I am sorry but I not familiar yet with
   the names of people in XWiki and I don't know if you are one of them.
 
 
  I'm definitely one of them - as every member of this community is. I
  simply happen to be posting a bit more often than most other people
 around
  here ;-)
 
  hmmm, where do you find the time? someone pays you to do that? can they
 pay
 others too?


I'm an employee of XWiki SAS, the company that finances continuing
development of the project (see http://www.xwiki.com/)

In the past we've hired committers on the project to work at the company.
XWiki SAS is currently looking for a system administrator, feel free to
apply: http://www.xwiki.com/xwiki/bin/view/About/SysadminOpenPosition ;-)

However please note that this doesn't give me special status in the
community per se - one can become a committer without being an XWiki SAS
employee and all employees are not committers either - it's a meritocracy.
That's one of the great parts of working on Open-Source software :-)



 
   I also
   have no idea where to place this, just as a comment in the page you
 give
  me
   or there is a more specific space/page for TODO list?
 
 
  Well, if your code works for all databases the best thing to do would be
 to
  update the application's XAR on the website. To do so you would need to
  export the application from your wiki and replace the current one with
  yours.
 
 I have not tested all databases, there is the possibility that the two
 changes I made have to be like this only for Oracle since not so many
 Databases use CLOBS for larg strings (other use text)

 
  You can use
 
 http://code.xwiki.org/xwiki/bin/view/Applications/ImportExportApplicationto
  export the updated TODO application from your current wiki. You'll need
 to
  include all the pages from the original XAR file.
 
  You can then upload it here:
 
 
 http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplicationDownloads#Attachmentsonce
  you've made sure it works fine (by installing it on a local wiki for
  instance).
 

 Well, I am intrigued, I will try to find some time to test around and see
 but it will be a slow process. In the meantime, others could try it, isn't
 there anyone else using TODO list app?


Great, thanks.

Guillaume




 
  Please let me know if you need additional help.
 
  Looking forward your first contribution,
 
  Guillaume
 
 
   On Mon, Aug 17, 2009 at 2:31 PM, Guillaume Lerouge 
 guilla...@xwiki.com
   wrote:
  
Hi Nikos,
   
On Mon, Aug 17, 2009 at 1:58 PM, Nikos Georgosopoulos 
   georg...@gmail.com
wrote:
   
 Hi all,

 I have been trying for the last day to put the TODO app in my wiki
  and
   it
 kept on failing to show the mytodo list in the panel. I use Oracle
  for
 backend so I thought it was that the problem. Here is the panel's
  code
 corrected to work in my case (XWiki 1.9.3, Tomacat 6, Oracle XE
 11):
 #panelheader('My Todos')

 #set ($hql = , BaseObject as obj, StringProperty as prop1,
 LargeStringProperty as prop2 where obj.name=doc.fullName and
 obj.className='XWiki.TodoClass' and obj.name 
'XWiki.TodoClassTemplate'
 and obj.id=prop1.id.id and prop1.id.name='Status'
 and prop1.value  'Finished' and obj.id=prop2.id.id
 and prop2.id.name ='Assignee' and prop2.value like '$context.user'
  order by doc.date desc)

 #foreach ($todo in $xwiki.searchDocuments($hql, 5, 0))
 * [$todo]
 #end
 #panelfooter()

 The big difference is the LargeStringProperty (Instead of
   StringProperty
 used in the XAR) and the like instead of = used to match the value.

 For the LargeStringProperty it is strange for me that someone chose
 a
CLOB
 to store user names but... maybe because of the class hierarchy
   involved
in
 the user name. Then again, how can this work even without oracle?

 For the like, well, oracle atleast will not even bother checking a
   string
 against a stream. Yes the words are phonetically 

Re: [xwiki-users] TODO list small bug

2009-08-17 Thread Sergiu Dumitriu
Guillaume Lerouge wrote:
 Hi Nikos,
 
 On Mon, Aug 17, 2009 at 4:59 PM, Nikos Georgosopoulos 
 georg...@gmail.comwrote:
 

 I am sorry but I not familiar yet with
 the names of people in XWiki and I don't know if you are one of them.

 I'm definitely one of them - as every member of this community is. I
 simply happen to be posting a bit more often than most other people
 around
 here ;-)

 hmmm, where do you find the time? someone pays you to do that? can they
 pay
 others too?

 
 I'm an employee of XWiki SAS, the company that finances continuing
 development of the project (see http://www.xwiki.com/)
 
 In the past we've hired committers on the project to work at the company.
 XWiki SAS is currently looking for a system administrator, feel free to
 apply: http://www.xwiki.com/xwiki/bin/view/About/SysadminOpenPosition ;-)
 
 However please note that this doesn't give me special status in the
 community per se - one can become a committer without being an XWiki SAS
 employee and all employees are not committers either - it's a meritocracy.
 That's one of the great parts of working on Open-Source software :-)

By the way, Guillaume himself is not a committer.

-- 
Sergiu Dumitriu
http://purl.org/net/sergiu/
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] TODO list small bug

2009-08-17 Thread Vincent Massol

On Aug 17, 2009, at 6:31 PM, Sergiu Dumitriu wrote:

 Guillaume Lerouge wrote:
 Hi Nikos,

 On Mon, Aug 17, 2009 at 4:59 PM, Nikos Georgosopoulos georg...@gmail.com 
 wrote:


 I am sorry but I not familiar yet with
 the names of people in XWiki and I don't know if you are one of  
 them.

 I'm definitely one of them - as every member of this community  
 is. I
 simply happen to be posting a bit more often than most other people
 around
 here ;-)

 hmmm, where do you find the time? someone pays you to do that?  
 can they
 pay
 others too?


 I'm an employee of XWiki SAS, the company that finances continuing
 development of the project (see http://www.xwiki.com/)

 In the past we've hired committers on the project to work at the  
 company.
 XWiki SAS is currently looking for a system administrator, feel  
 free to
 apply: http://www.xwiki.com/xwiki/bin/view/About/ 
 SysadminOpenPosition ;-)

 However please note that this doesn't give me special status in the
 community per se - one can become a committer without being an  
 XWiki SAS
 employee and all employees are not committers either - it's a  
 meritocracy.
 That's one of the great parts of working on Open-Source software :-)

 By the way, Guillaume himself is not a committer.

and the XWiki project's governance rules are available here:
http://dev.xwiki.org/

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


Re: [xwiki-users] TODO list small bug

2009-08-17 Thread Nikos Georgosopoulos
I find this absolutely reasonable justification. I will create a page then
and put it there. Then I will link the TODOs page with the new one. How does
that sound?

On Mon, Aug 17, 2009 at 5:14 PM, Vincent Massol vinc...@massol.net wrote:


 On Aug 17, 2009, at 4:59 PM, Nikos Georgosopoulos wrote:

  Well, as I was waiting for your reply, I posted it to my blog, is it
  in good
  faith if I make a link from the page of the app to it?
  http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplication?

 Well it's easier if people can find all the information they need on
 the xwiki.org wiki. Also if your blog disappears for any reason (you
 switch blogs, etc) then the link will be broken.

 Thanks
 -Vincent

  On Mon, Aug 17, 2009 at 4:44 PM, Guillaume Lerouge guilla...@xwiki.com
  wrote:
 
  Hi Nikos,
 
  On Mon, Aug 17, 2009 at 4:30 PM, Nikos Georgosopoulos 
 georg...@gmail.com
  wrote:
 
  I would be honored to do so, I just don't know if I have the right
  to
  post/edit other people work in there.
 
 
  It's a wiki, feel free to edit and add information to it as long as
  you do
  so in good faith and bring relevant information :-)
 
 
  Thanks for clarifying this, it is formed as a wiki but it could have
  access
  rights reserved (XWiki gives the option).
 
 
 
 
  I am sorry but I not familiar yet with
  the names of people in XWiki and I don't know if you are one of
  them.
 
 
  I'm definitely one of them - as every member of this community
  is. I
  simply happen to be posting a bit more often than most other people
  around
  here ;-)
 
  hmmm, where do you find the time? someone pays you to do that? can
  they pay
  others too?
 
 
  I also
  have no idea where to place this, just as a comment in the page
  you give
  me
  or there is a more specific space/page for TODO list?
 
 
  Well, if your code works for all databases the best thing to do
  would be to
  update the application's XAR on the website. To do so you would
  need to
  export the application from your wiki and replace the current one
  with
  yours.
 
  I have not tested all databases, there is the possibility that the two
  changes I made have to be like this only for Oracle since not so many
  Databases use CLOBS for larg strings (other use text)
 
 
  You can use
 
 http://code.xwiki.org/xwiki/bin/view/Applications/ImportExportApplicationto
  export the updated TODO application from your current wiki. You'll
  need to
  include all the pages from the original XAR file.
 
  You can then upload it here:
 
 
 http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplicationDownloads#Attachmentsonce
  you've made sure it works fine (by installing it on a local wiki for
  instance).
 
 
  Well, I am intrigued, I will try to find some time to test around
  and see
  but it will be a slow process. In the meantime, others could try it,
  isn't
  there anyone else using TODO list app?
 
 
  Please let me know if you need additional help.
 
  Looking forward your first contribution,
 
  Guillaume
 
 
  On Mon, Aug 17, 2009 at 2:31 PM, Guillaume Lerouge 
 guilla...@xwiki.com
  wrote:
 
  Hi Nikos,
 
  On Mon, Aug 17, 2009 at 1:58 PM, Nikos Georgosopoulos 
  georg...@gmail.com
  wrote:
 
  Hi all,
 
  I have been trying for the last day to put the TODO app in my wiki
  and
  it
  kept on failing to show the mytodo list in the panel. I use Oracle
  for
  backend so I thought it was that the problem. Here is the panel's
  code
  corrected to work in my case (XWiki 1.9.3, Tomacat 6, Oracle XE
  11):
  #panelheader('My Todos')
 
  #set ($hql = , BaseObject as obj, StringProperty as prop1,
  LargeStringProperty as prop2 where obj.name=doc.fullName and
  obj.className='XWiki.TodoClass' and obj.name 
  'XWiki.TodoClassTemplate'
  and obj.id=prop1.id.id and prop1.id.name='Status'
  and prop1.value  'Finished' and obj.id=prop2.id.id
  and prop2.id.name ='Assignee' and prop2.value like '$context.user'
  order by doc.date desc)
 
  #foreach ($todo in $xwiki.searchDocuments($hql, 5, 0))
  * [$todo]
  #end
  #panelfooter()
 
  The big difference is the LargeStringProperty (Instead of
  StringProperty
  used in the XAR) and the like instead of = used to match the
  value.
 
  For the LargeStringProperty it is strange for me that someone
  chose a
  CLOB
  to store user names but... maybe because of the class hierarchy
  involved
  in
  the user name. Then again, how can this work even without oracle?
 
  For the like, well, oracle atleast will not even bother checking a
  string
  against a stream. Yes the words are phonetically close but
  oracle
  doesn't care about phonetics.
 
  I hope others out there will enjoy this helpful app.
 
 
  Glad you liked it :-)
 
  It would be cool if you updated the page on code.xwiki.org
  explaining
  how
  you made the app work under Oracle.
 
  Thanks,
 
  Guillaume

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


Re: [xwiki-users] TODO list small bug

2009-08-17 Thread Vincent Massol

On Aug 17, 2009, at 6:52 PM, Nikos Georgosopoulos wrote:

 I find this absolutely reasonable justification. I will create a  
 page then
 and put it there. Then I will link the TODOs page with the new one.  
 How does
 that sound?

You could use the existing page at
http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplication

You could mention that the first version was done for a TSS article  
and link it and then add your new version.

BTW you can join us on IRC if you want direct interactions
see http://dev.xwiki.org/xwiki/bin/view/Community/IRC

Thanks
-Vincent

 On Mon, Aug 17, 2009 at 5:14 PM, Vincent Massol vinc...@massol.net  
 wrote:


 On Aug 17, 2009, at 4:59 PM, Nikos Georgosopoulos wrote:

 Well, as I was waiting for your reply, I posted it to my blog, is it
 in good
 faith if I make a link from the page of the app to it?
 http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplication?

 Well it's easier if people can find all the information they need on
 the xwiki.org wiki. Also if your blog disappears for any reason (you
 switch blogs, etc) then the link will be broken.

 Thanks
 -Vincent

 On Mon, Aug 17, 2009 at 4:44 PM, Guillaume Lerouge guilla...@xwiki.com
 wrote:

 Hi Nikos,

 On Mon, Aug 17, 2009 at 4:30 PM, Nikos Georgosopoulos 
 georg...@gmail.com
 wrote:

 I would be honored to do so, I just don't know if I have the right
 to
 post/edit other people work in there.


 It's a wiki, feel free to edit and add information to it as long as
 you do
 so in good faith and bring relevant information :-)


 Thanks for clarifying this, it is formed as a wiki but it could have
 access
 rights reserved (XWiki gives the option).




 I am sorry but I not familiar yet with
 the names of people in XWiki and I don't know if you are one of
 them.


 I'm definitely one of them - as every member of this community
 is. I
 simply happen to be posting a bit more often than most other people
 around
 here ;-)

 hmmm, where do you find the time? someone pays you to do that? can
 they pay
 others too?


 I also
 have no idea where to place this, just as a comment in the page
 you give
 me
 or there is a more specific space/page for TODO list?


 Well, if your code works for all databases the best thing to do
 would be to
 update the application's XAR on the website. To do so you would
 need to
 export the application from your wiki and replace the current one
 with
 yours.

 I have not tested all databases, there is the possibility that the  
 two
 changes I made have to be like this only for Oracle since not so  
 many
 Databases use CLOBS for larg strings (other use text)


 You can use

 http://code.xwiki.org/xwiki/bin/view/Applications/ImportExportApplicationto
 export the updated TODO application from your current wiki. You'll
 need to
 include all the pages from the original XAR file.

 You can then upload it here:


 http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplicationDownloads#Attachmentsonce
 you've made sure it works fine (by installing it on a local wiki  
 for
 instance).


 Well, I am intrigued, I will try to find some time to test around
 and see
 but it will be a slow process. In the meantime, others could try it,
 isn't
 there anyone else using TODO list app?


 Please let me know if you need additional help.

 Looking forward your first contribution,

 Guillaume


 On Mon, Aug 17, 2009 at 2:31 PM, Guillaume Lerouge 
 guilla...@xwiki.com
 wrote:

 Hi Nikos,

 On Mon, Aug 17, 2009 at 1:58 PM, Nikos Georgosopoulos 
 georg...@gmail.com
 wrote:

 Hi all,

 I have been trying for the last day to put the TODO app in my  
 wiki
 and
 it
 kept on failing to show the mytodo list in the panel. I use  
 Oracle
 for
 backend so I thought it was that the problem. Here is the  
 panel's
 code
 corrected to work in my case (XWiki 1.9.3, Tomacat 6, Oracle XE
 11):
 #panelheader('My Todos')

 #set ($hql = , BaseObject as obj, StringProperty as prop1,
 LargeStringProperty as prop2 where obj.name=doc.fullName and
 obj.className='XWiki.TodoClass' and obj.name 
 'XWiki.TodoClassTemplate'
 and obj.id=prop1.id.id and prop1.id.name='Status'
 and prop1.value  'Finished' and obj.id=prop2.id.id
 and prop2.id.name ='Assignee' and prop2.value like  
 '$context.user'
 order by doc.date desc)

 #foreach ($todo in $xwiki.searchDocuments($hql, 5, 0))
 * [$todo]
 #end
 #panelfooter()

 The big difference is the LargeStringProperty (Instead of
 StringProperty
 used in the XAR) and the like instead of = used to match the
 value.

 For the LargeStringProperty it is strange for me that someone
 chose a
 CLOB
 to store user names but... maybe because of the class hierarchy
 involved
 in
 the user name. Then again, how can this work even without  
 oracle?

 For the like, well, oracle atleast will not even bother  
 checking a
 string
 against a stream. Yes the words are phonetically close but
 oracle
 doesn't care about phonetics.

 I hope others out there will enjoy this helpful app.


 Glad you liked