]project-open[ : @This Wiki
Portrait

Welcome, Unregistered Visitor

 ·  ·  ·  Contact ·  Index · Login · Register

Contents

Remote Training
Support
SaaS Service

6 registered users
 in last 24 hours

Funambol Integration

]project-open[ provides an interface with the Funambol  PIM syncronization software. The integration allows ]project-open[ to exchange Contact, Task and Calendar information with MS-Outlook , Apple iPhone  and Google Android  devices.

This interface allows organizations to synchronize contact and task information between multiple client devices and ]project-open[.

Details

]project-open[ -> Funambol:

  • ]po[ user accounts are automatically created in Funambol if the user is member of the profile "Employee".
  • ]po[ tickets and tasks are converted into Funambol tasks, if the Funambol user has the right permissions and is assigned to the task.
  • ]po[ contacts are converted into Funambol contacts.

Funambol -> ]project-open[:

  • Funambol updates to ]po[ contacts are imported into ]po[ if the user has write permissions on the contact. "Private contacts" (i.e. contacts created by a Funambol device) are not imported into ]po[.
  • Funambol updates to the fields "percent completed" and "task status" are written back to ]po[ if the user has write permissions on the task. Changes on other fields of the task are ignored and overwritten by ]po[.

Status and Maturity

Today (2010-09-18) the Funambol integration is under development.

  • Integration of users -> Funambol accounts is working.
  • Integration of tickets <-> Funambol tasks is working, Funambol status changes are written back to ]po[.
  • Integration of timesheet tasks -> Funambol tasks is not implemented yet. 

Setup and Installation

To setup the ]po[ <-> Funambol integration, please go through the following steps:

  1. Download the intranet-funambol package from CVS using the command "cd ~/packages/; cvs checkout intranet-funambol".
    Please see the CVS Updates & Versions and [Upgrade Tutorial] pages for examples on how to use CVS.

  2. Install Funambol on your server. Funambol by default uses port 8080, which is not used by a default ]po[ installation.

  3. Follow the Funambol tutorial on how to configure Funambol to work with a PostgreSQL database.
    Modify the /opt/Funambol/ds-server/install.properties to use the ]project-open[ database also for Funambol.
    (Yes, this is correct, please install Funambol in the same database/user as ]project-open[. Funambol tables include a "fnbl_" prefix, so that they don't conflict with the OpenACS/]po[ tables.)
    dbms=postgresql
    jdbc.classpath=/opt/Funambol/tools/jdbc/postgresql-8.2-506.jdbc4.jar # (or wherever you have copied your PG JDBC driver)
    jdbc.driver=org.postgresql.Driver
    jdbc.url=jdbc:postgresql://localhost/projop
    jdbc.user=projop
    jdbc.password=secret            # you probably don't need to specify a password if you have setup correctly your pg_hba.conf­)­
    
  4. Execute "bash /opt/Funambol/bin/install" to re-install the Funambol database.

As a result you will find the Funambol fnbl_* tables in your "projop" PostgreSQL database.

The intranet-funambol package will synchronize ]po[ with Funambol every 30 seconds by default. You can change the freqquency in the Admin -> Parameters or manually run a synchronization by executing the SQL command: "select fnbl_sync();"


Please take a moment to complete this form to help us improve our service.

Note:
Please only provide feedback in regards to content this page shows. For support inquiries please refer either to the Community Support forum at Sourceforge or check out our 'Professional Support'

Did this page help you to achieve your goal?

 Yes  No  Don't know

Please provide us with comments to improve this page:

How useful is the information?

 1  2  3  4  5
Not
useful
      Extremely
useful
 
  

Explore

Installers
Demo Server
Modules & Functionality
Packages
Business Processes supported
FAQ's

Help

Getting started
User Manuals
Configuration Manuals
Community Support
Professional Support

News

News
Twitter
RSS Community / Sourceforge
Register for Newsletter

Get in touch

Contact
Register



Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.0 Generic License - Privacy Policy