Explore Posterous

Open-Source clinic management software in Hong Kong #opensource #healthcare

[From: http://www.isia.org.hk/]
Aug 2009, After two years of development, the TaoYuan Project team formed by ISIA and HKMA are pleased to announce that CMS 3.0 is born! The CMS 3.0 is the first Open-Source clinic management software in Hong Kong. The latest version 3.1 is available now for all registered doctors and clinics to download together with online e-learning and user manual. ISIA members provide various customized CMS service packages bundling hardware, broadband, data migration, training & hotline support.
For details, _http://cms3.isia.org.hk
_

Display RSS Feed in OpenCms Template

Since this is a very common feature for many websites, here's a useful snippet I usually use when displaying RSS feeds in an OpenCms template. For example you want to display an Atom RSS feed from a WordPress blog on your OpenCms based website.

My approach is usually:
The OpenCms schema has a OpenCmsString input field (named BlogRssUrl in my case), which is mapped to the property BlogRssUrl as well.

<xsd:complexType name="OpenCmsMySchema">
  ...
  <xsd:element name="BlogRssUrl" type="OpenCmsString" minOccurs="0" maxOccurs="1" />
  ...
</xsd:complexType>

<mappings>
    <mapping element="BlogRssUrl" mapto="property:BlogRssUrl" />
</mappings>

For fetching the RSS feed, I recommend the ROME Fetcher subproject library at https://rome.dev.java.net/, which only depends on the JDOM parser (jdom.jar). So you will end up deploying three additional jars:

• jdom.jar
• rome-1.0RC2.jar (or newer version)
• rome-fetcher-0.9.jar (or newer version)

Below is the scriplet then for the OpenCms jsp template:

<%@ taglib prefix="cms" uri="http://www.opencms.org/taglib/cms" %>
<%@ page session="false" import="org.opencms.jsp.*,java.util.*,org.opencms.file.*,java.net.URL,com.sun.syndication.feed.synd.*,com.sun.syndication.fetcher.*,com.sun.syndication.fetcher.impl.*" %>
<%  
    CmsJspActionElement cms = new CmsJspActionElement(pageContext, request, response);
    String filename = cms.getRequestContext().getUri();

           // === RSS Feed Fetching ===
    FeedFetcherCache feedInfoCache = HashMapFeedInfoCache.getInstance();
    FeedFetcher feedFetcher = new HttpURLFeedFetcher(feedInfoCache);
    CmsObject cmso = cms.getCmsObject();
    String blogRssUrl = cmso.readProperty(filename, "BlogRssUrl");
    SyndFeed feed = null;
    if (blogRssUrl!=null && !"".equals(blogRssUrl)) feed = feedFetcher.retrieveFeed(new URL(blogRssUrl));
%>

and then display the output on the page:

<% if (feed!=null) { %>
<ul>
<%
// === RSS feed output ===
for (Iterator<SyndEntry> iter= feed.getEntries().iterator(); iter.hasNext();) {
    SyndEntry entry = iter.next();
    %>               
    <li>[a href="<%=entry.getUri()%>"]<%=entry.getTitle()%>[/a]</li>                               
    <%               
}
%>
</ul>
<% } %>

OpenCms Introduction Video

I recorded an OpenCms introduction video last weekend using Movie Maker and CamStudio (both free and easy-to-use tools), but still trying to improve the quality. 

This is my very first video recording and cutting, so please be considerate ;) 
Planning to add more videos step by step later. Hope to encourage others to do the same (on complementary topics).

Photo album (SmoothGallery) add-on for OpenCms

OpenCms-Spring Integration

In recent projects we have used the Spring MVC integrated into OpenCms. This topic is not new to the OpenCms community, as it has already been covered a
little in the OpenCms wiki and also Bearingpoint provides an open source submodule in their Commons-Project at Sourceforge.
 
Nevertheless, we make our small 'getting-started' project available now - it's aimed for developers who want to integrate Spring & Hibernate into
OpenCms for the first time and would like to have a ready-to-go starting point/project setup.
The project includes Eclipse and NetBeans project files as well as the ant build file. We used it for OpenCms7.0.5 and OpenCms7.5. With these OpenCms versions, the versions of the depending lib files used by Spring and OpenCms should not
conflict. (We didn't use it with OpenCms6 yet).
 
SVN:
http://svn.sysvision.net:9027/svn/com.sysvision.opencms.spring/
User: anon, Password: anon
 
or download as zip from:
http://www.sysvision.de/en/expertise/cms/solutions/opencms_spring_integration.html
 
The project contains a Readme.pdf how to use it. We hope it's useful to someone and are open for any comments, suggestions and improvements.
 
(A note regarding Hibernate: we don't use the OpenSessionInViewPattern (OSIV), so you won't find it in the project. If you want/need it, you will
find infos about it in the opencms-wiki.org)

OpenCms: Fix for Alkacon OAMP Formgenerator, CSV Export

When exporting the Formgenerator data to CSV, there might be some problems with exporting numbers and trailing zeros when opening the file in Excel. I.e. if you have a column with zip codes and some values start with 0, they will get lost in Excel. Also, when exporting large numbers, Excel usually displays them withe the +E syntax.
 
To avoid it, the csv should escape such numbers with a = in front of it, i.e.the CSV should read:
,="07635",
 
We modified the class com.alkacon.opencms.formgenerator.database.export.CmsCvsExportBean.java, method escapeExcelCsv: checking if the value can be parsed as Double or Long, if so, put an = in front of the escaped value.
(The = cannot be put in front of all types of fields; if put in front of an escaped string value that contains commas, it will break the format; so we
really need to check if it's a number value).

    /** 
     * Escapes CSV values for excel.<p> 
     * 
     * @param value the value to escape 
     * 
     * @return the escaped excel value. 
     */
    private String escapeExcelCsv(final String value) {
        // Begin: SYSVISION modification
        boolean isNumber=false;
        try {Long.valueOf(value);isNumber=true;} catch (Exception e) {};
        try {Double.valueOf(value);isNumber=true;} catch (Exception e) {};
        // End: SYSVISION modification

        String result = value;
        StringBuffer buffer = new StringBuffer();
        buffer.append("\"");
        char[] chars = value.toCharArray();
        for (int i = 0; i < chars.length; i++) {
            // escape double quote escape delimiter within value: 
            if ('"' == chars[i]) {
                buffer.append("\"");
            }
            buffer.append(chars[i]);
        }
        buffer.append("\"");
        result = buffer.toString();
        return (isNumber?"=":"") + result;  // SYSVISION modification
    }