<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1528" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN
class=592532504-29032006>Greetings!</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=592532504-29032006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006>I'm a newbie to
OpenCMS and find the lack of documentation, books or tutorials a little
daunting.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=592532504-29032006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006></SPAN></FONT><FONT
face=Arial size=2><SPAN class=592532504-29032006>I would greatly appreciate your
thoughts on the following please:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=592532504-29032006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006>I need to customize
the Modules (Events) demo that ships with OpenCMS 6.0.3</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=592532504-29032006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006>I was thinking of a
designing on these lines.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006>Need your feedback
on whether this is an appropriate way to proceed:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=592532504-29032006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006>1) Will provide web
users with a custom jsp page to Add an Event to the site.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006>Need to do this as
webusers cannot access the OpenCMS workplace.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=592532504-29032006></SPAN></FONT> </DIV></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006>(Will save the event
details </SPAN></FONT><FONT face=Arial size=2><SPAN class=592532504-29032006>in
a new non-OpenCMS database table -- </SPAN></FONT><FONT face=Arial size=2><SPAN
class=592532504-29032006>couldn't figure out how [in which table] OpenCMS stores
the demo events data internally).</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=592532504-29032006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=592532504-29032006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006>2) Now the problem
is: How do I transfer the new event data from the custom table above to
OpenCms's internal tables?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=592532504-29032006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006> That is, I
could either:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006><FONT face=Arial
size=2><SPAN class=592532504-29032006></SPAN></FONT></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006><FONT face=Arial
size=2><SPAN class=592532504-29032006> a) provide the site
admin with a page similar to step 1, where the admin can approve or reject the
new event.</SPAN></FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006><FONT face=Arial
size=2><SPAN class=592532504-29032006>If approved, the event should be published
(but it is not yet in the OpenCms VFS)!</SPAN></FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006><FONT face=Arial
size=2><SPAN class=592532504-29032006></SPAN></FONT></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006><FONT face=Arial
size=2><SPAN class=592532504-29032006> b)
</SPAN></FONT></SPAN></FONT><FONT face=Arial size=2><SPAN
class=592532504-29032006>customise the OpenCMS admin's workplace screen
(displayed when editing a listing in the event modulesdemo)</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006>to inlcude an
approve / reject field among other things.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=592532504-29032006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006> I
understand I can do this by tinkering with the xmlcontent schema defined in
/system/modules/org.opencms.frontend.templateone.modules/schemas/</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=592532504-29032006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006>
But the problem still remains of pulling data from the custom table to the
OpenCms workplace view for editing an event.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=592532504-29032006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006>
And I'm also making the assumption that (if I somehow manage to pull data from
the custom table into the workplace view,) pressing the save and close button in
the workplace will automatically move the event details into the OpenCms
VFS.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=592532504-29032006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=592532504-29032006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006>In both cases (a
& b) I'm fairly clueless on how to proceed, and would appreciate a few
pointers.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=592532504-29032006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=592532504-29032006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=592532504-29032006>I hope I have
provided enough (relevant) detail. </SPAN></FONT><FONT face=Arial size=2><SPAN
class=592532504-29032006>Thank you for your time.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<P style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: gray; FONT-FAMILY: Tahoma; mso-ansi-language: EN-GB">Thanks
& Regards,</SPAN><SPAN style="COLOR: navy"><?XML:NAMESPACE PREFIX = O
/><O:P> </O:P></SPAN></P>
<P style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: gray; FONT-FAMILY: Tahoma; mso-ansi-language: EN-GB">Nikhil
Silveira</SPAN></P>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>