- xwiki-users@xwiki.org - lists.xwiki.org

AW: [xwiki-users] SQL hair-pulling
by Frank Häfemeier 23 Mar '06

23 Mar '06

>As mentioned in an earlier message, I got into the $xwiki.search() world >yesterday, and am thoroughly confused. > >The main problem seems to be that the XWiki database schema and the >schema used in all of the $xwiki.search() queries I have found are >completely disjoint. > >Instead of the documented tables and columns, what seems to be used is a >schema which reflects the object model within XWiki. This would really >be convenient if true; is it? This is right. Bye Frank

1 0

Backport of Import Export Script
by Mark Robinson 23 Mar '06

23 Mar '06

Hi All. This is probably most appropriate to Jeremi, but I would appreciate anyones thoughts on the subject. XWiki is a phenomenal piece of software that I am thinking of new uses every day. I am currently running 0.9.840 on one of my servers and am a little bit paranoid about upgrading until later in the year, as our application is growing at a furious rate and I would like it to stabilise a little before we go through an upgrade. However, some of the new features are very tempting (I am using the standalone for testing). Ideally I would like to use your XWiki/ImportExport script to create user configurable exports on the existing data and was wondering how involved the underlying adjustments would be to the code to make it work with the stable version. The script looks for $export. Is this a java class that is put into a xwiki context in the later release? If so, is it self sufficient enough to compile and add to an existing installation, or is it too dependent on other code in the later version? With custom java classes, is there a straight forward description somewhere on putting them in an XWiki context so they can be used by Velocity? In a mildly related point: I have deployed DWR (https:// dwr.dev.java.net/) side by xwiki in another testing installation for some AJAX experimentation and it seems to be co-habiting without too much trouble. Apologies for the basic questions, but I am currently on a steep learning curve with this and appreciate any help offerred. Have a great day. Mark.

2 1

How to get only future events?
by Gaël Blondelle - EBM WebSourcing 23 Mar '06

23 Mar '06

Hi all, I try to print future events in the left menus, but it looks that the test of the event start date is always evaluated to false. #foreach($event in $xwiki.getDocument("Main.EventCalendar").getObjects("XWiki.CalendarEvent")) #if ($event.getStartDate().getTime().after($xwiki.getDate())) $event.startDate $event.endDate $event.description #end #end Any idea or suggestion? Regards, Gaël Blondelle EBM WebSourcing

2 1

RE: [xwiki-users] Date value compare (and update on date arithmetic)
by THOMAS, BRIAN M (SBCSI) 23 Mar '06

23 Mar '06

Jérémi: You make it look easy, but it took me a good long bit of searching and trial-and-error investigation to figure out how to get a real Date object out of an XWiki object field. And you perform a little leger-de-main which I have not found explained anywhere: the expression $obj.XWikiObject.date.value is equivalent to $obj.XWikiObject.getDateValue("date"). Unfortunately, this is not suitable for use as an lvalue, but it makes a nice shorthand. Is this documented anywhere (other than in the source)? I noted the same thing when I found, in some sample code, a call to a (seemingly) nonexistent method $xwiki.getCalendar(). Happily, simply writing $xwiki.calendar in a document yielded an object identifier containing the classname com.xpn.xwiki.plugin.calendar.CalendarAPI, so it seems that XWiki was fiddling my call into $xwiki.get("calendar"), which is documented to return a plugin API, which before this had meant nothing to me (either that, or the plugin augmented com.xpn.xwiki.api.XWiki with a getCalendar() method, which is what I thought before I saw the above). Velocity, of course, turns any rvalue reference to $obj.foo into a call to $obj.getFoo() or $obj.getfoo(), and likewise any lvalue reference in a #set into a call to $obj.set[Ff]oo() with the RHS as its argument. But this trick is different, because at least in the first case it has to know the navigation of a particular XWiki-specific class hierarchy. Nice shorthand; would be nicer if it were explained somewhere... Okay, I'll do it... By the way, that $xwiki.calendar property finally got me to an answer to my date arithmetic problem, thanks to Java reflection. The task was in a project status reporting page, where I wanted to ignore records more than a week old. The problem was that I could find no way at all to do date arithmetic in a Velocity script, because the time value returned from java.util.Date.getTime() is a long integer, which (until the next release of Velocity, at least) can't be used in an arithmetic expression. I could have used the Date functions to format a date, manipulate the string version, and then parse it, but that would be far too difficult, inflexible, and error-prone even ignoring the fact that those methods were deprecated. It works like this, for those who are interested: First, $xwiki.calendar has a method getCalendar() which, in the version without arguments, returns a java.util.Calendar initialized with the current date. Because it inherits from java.lang.Object, it is Cloneable, so I clone()d it to get a copy that I could set back seven days, without disturbing the original object (I learned this the hard way: the returned object was a reference, and changes via the copied reference changed the original). Turning back the clock in a java.util.Calendar by seven days is quite simple in Java - formally speaking, it's java.util.Calendar.add(java.util.Calendar.DAY_OF_YEAR, -7). However, this isn't Java exactly; we can call the add() method easily enough, because we have a Calendar object, but that DAY_OF_YEAR symbolic constant isn't accessible that way, because apparently Velocity doesn't translate field references, only method calls. The final expression was $xwiki.calendar.calendar.class.getField("DAY_OF_YEAR").int #set($wcal = $xwiki.calendar.calendar.clone()) ## copy of java.util.Calendar with current time $wcal.add($wcal.class.getField("DAY_OF_YEAR").int, -7) ## set the calendar back one week. #set($weekago = $wcal.time) ## get the resulting date as a java.util.Date object After this, when I wanted to see whether date "donedate" from an object was more than a week old, I wrote something like this: #set($weekold = $obj.xWikiObject.donedate.value.before($weekago)) which worked just fine. Of course, since I also wanted to sort those records on other than the default field, I needed to do an $xwiki.search() call with a custom query, and SQL can easily do date arithmetic. That brings up another topic, because I was foolish enough to try it... brain[sic] -----Original Message----- From: jeremi joslin [mailto:[email protected]] Sent: Wednesday, March 22, 2006 8:25 AM To: xwiki-users(a)objectweb.org Subject: Re: [xwiki-users] Date value compare On 3/22/06, jjanssen(a)nl.swets.com <jjanssen(a)nl.swets.com> wrote: > Hello, > > I've got several classes in which I use date attributes. Is there a > way to list objects of such a class, but only those in which the value > of the date attribute is before current date? I do it a while ago using the before function: #if ($obj.XWikiObject.date.value.before($xwiki.getCurrentDate())) Jérémi -- Blog: http://www.jeremi.info LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724 Project Manager XWiki: http://www.xwiki.org skype: jeremi23 -- msn et gtalk : jeremi23(a)gmail.com

2 1

[Lost Data]
by Scott Venter 23 Mar '06

23 Mar '06

hello everybody, I spent the morning creating an xWiki page called MyTutorials. The link name was Main.MyTutorials I finished up by adding a new News Item to my blog, the Page Name unfortunately was also MyTutorials. Now when I try to link to the work I did this morning I just get the Blog news item. Please can someone assist. I cant even find the pages I created that link from my MyTutorials page. Thanks Scott. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.

2 1

Date value compare
by jjanssen＠nl.swets.com 22 Mar '06

22 Mar '06

Hello, I've got several classes in which I use date attributes. Is there a way to list objects of such a class, but only those in which the value of the date attribute is before current date? Thanks again, Joep Janssen

2 1

problem with skin for a space
by Lars Schmidt-Thieme 20 Mar '06

20 Mar '06

Dear xwiki developers, first of all, thanks for XWiki, which is really an awesome tool and one of the most advanced Wikis I know of. I have a problem attaching a skin to a space via the webpreferences of the space. What I did: 1. I created an empty page XWiki.WebpageSkin and attached a new objekt also called "XWiki.WebpageSkin" of class XWiki.XWikiSkins. I removed all contents from the "style" box and entered "THIS IS THE HEADER" into the header box, just to see, if the skin is used or not. 2. I testet the skin by appending ?skin=XWiki.WebpageSkin and to a page and this worked fine. 3. I edited the Main webpreferences (via More Actions/Space Preferences on Main.WebHome) and entered "XWiki.WebpageSkin" in the "skin" box. But this did not take effect. When I did the same for the XWiki preferences (instead of the space preferences), it did work properly, but for all spaces, of course. What did I do wrong? How can I configure different skins for different spaces? Any help would be highly appreciated & thanks a lot in advance & best Lars

2 2

< and > operator
by jjanssen＠nl.swets.com 20 Mar '06

20 Mar '06

Hello, In my wiki I've got several classes which objects I want to list, only when an Integer attribute is > or < then a certain value. However something like: #if($duration < 10), doesn't work. Anybody any ideas? Thanks again, Joep Janssen

2 1

Problem to display Google RSS feeds
by Xavier MOGHRABI 17 Mar '06

17 Mar '06

Hi folks, I try to display RSS coming from Google about ObjectWeb on my nice XWiki wiki. The URL is : http://news.google.com/news?q=objectweb&output=RSS&ned=us&lang=en So I've added in my XWiki: {rss:feed=http://news.google.com/news?q=objectweb&output=RSS&ned=us&lang=en} unfortunately I obtain the following errounous message : rss: Error processing http://news.google.com/news?q=objectweb&output=RSS&ned=us〈=en: Server returned HTTP response code: 403 for URL: http://news.google.com/news?q=objectweb&output=RSS&ned=us〈=en it seems the parameters are bringing issues. I've tried to escape the = character with '\' but it didn't work. Does anyone know how can I do that ? Thanks -- Xavier MOGHRABI - Consortium ObjectWeb

2 1

Linking attachments
by emil＠mythicscape.com 17 Mar '06

17 Mar '06

Is it possible to put an attached file at one page, and from another page link to that file? Example, we attach the file File.xml to the page Main.Files And then on the page Main.List we want to include a link to the File.xml file?

3 2