Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - William

Pages: [1]
1
Education / Re: Is anyone using Feng in a Primary school?
« on: October 14, 2011, 01:27:11 pm »
Hello Simon,

I work at a state university and we used it for project/task management as well as document and web resources management.

It takes a bit of playing around but I've found that the folders we are used to are called workspaces in Feng Office and it works as a hierarchy in much the same way.  Tasks and other items created in a sub-workspace can be seen in the parent workspace. The great thing about the Tag feature is you can give any item a tag, such as "Budget Fiscal Year 2012" and you can click on that tag and it will pull up each item with that tag.  Additionally, selected a particular sub-workspace only shows the items in that workspace so you can drill down or drill up as needed.

I am currently using Feng Office to support non-profits in Texas.  I've given each of the non-profits a workspace to which they can create projects and tasks.  By putting all of these workspaces under me, I go to one spot, my workspace, to check all of my incoming tasks and email.

Overall, I've been very pleased with Feng Office in the education and non-profit sectors.  My main instance of Feng Office is version 1.7.5 which seems pretty stable.  The 2.0+ versions are completely different in look and menu options so if you are testing I'd check that one out.  It has more configuration options but it is a beta version and shouldn't be relied on for primary use yet.

2
How To's / Re: Copying one installation to another
« on: April 13, 2010, 01:15:42 pm »
I am currently looking at methods of merging two installations of FengOffice, which will include the entire database of installation #2 into installation #1.  I was thinking of writing some PHP code which would extract the SQL from db#2, convert ids, and then insert into db#1. 

Is there a best practice for this or a method in place?  Has anyone done this and have advice, what worked and what didn't?

Thanks in advance!

3
Older versions / Re: FengOffice 1.6.1 Error 500: Internal Server Error
« on: January 25, 2010, 08:04:08 pm »
Sorry for the late reply.  I appreciate the response.  Once I deleted all existing repeating tasks, I was able to re-enter the repeating tasks with no error.  At that point I was able to re-enable the Calendar module.  I can't re-create the error at this point.  I can add that code after hours to see if tasks still show and then remove it afterwards if that will help you.

There are numerous other errors, so I'm thinking when time permits I'll have to compare how the DB is intended to be structured compared to what state our DB is in now.  If you have DB documentation already that would save me time.  There have been numerous DB migration errors from release to release so I'm willing to bet the DB is the central cause.

4
Older versions / Re: FengOffice 1.6.1 Error 500: Internal Server Error
« on: January 13, 2010, 07:28:42 pm »
Went through task list and made all repetitive tasks single occurrence tasks and then re-enabled calendar module.  Calendar and overview tabs now work properly, as long as users don't enter a task which repeats.  Seems the problem is most likely in the database or with the generate task repetition code.  Since I haven't seen others with these symptoms, I'm going to concentrate on the database side of troubleshooting.  I haven't had a chance to compare tables between the corrupt updated version and a fresh install of FengOffice 1.6.1 yet but hopefully this weekend will yield the time I need.

5
Older versions / Re: FengOffice 1.6.1 Error 500: Internal Server Error
« on: January 13, 2010, 02:47:13 pm »
Quick update.  The calendar tab is fine on work spaces which do not have any repetitive tasks.  I am going to install a clean copy of FengOffice 1.6.1 on a development server to define the intended database table structure and compare that to the database table structure of the installation which has the issue.  I haven't seen any other posts in the forums with these error reports so I am going to proceed as if this is a separate issue.  Stop me if this has already been solved.

6
Older versions / Re: FengOffice 1.6.1 Error 500: Internal Server Error
« on: January 11, 2010, 10:24:08 pm »
Replaced all files (except config) with download from today.  Error persists.

On a clean install, Feng 1.6.1 seems to run with no errors.  This only seems to occur on an upgrade.  Seems to be a possible DB migration issue.

7
Older versions / FengOffice 1.6.1 Error 500: Internal Server Error
« on: January 07, 2010, 12:58:02 am »
After helping a user upgrade to FengOffice 1.6.1 from OpenGoo 1.5.3 the following error message was received after debugging was turned on in the config file:

Fatal error: Call to a member function getTimestamp() on a non-object in /usr/local/apache2/htdocs/pm/opengoo/application/helpers/calendar.php on line 105

This prevents the Overview tab from being displayed.

When clicking on the Calendar tab the following pop-up error is shown:

Error: og.eventSelected is not a function

Everything appears to be in good working order except the Calendar functions.  We can disable the calendar module and the Overview tab will display properly.

The function this error refers to is:

function forwardRepDate(ProjectTask $task, $min_date) {
   if ($task->isRepetitive()) {
      if (($task->getRepeatBy() == 'start_date' && !$task->getStartDate() instanceof DateTimeValue) ||
         ($task->getRepeatBy() == 'due_date' && !$task->getDueDate() instanceof DateTimeValue)) {
            return array('date' => $min_date, 'count' => 0); //This should not happen...
      }
      
      $date = new DateTimeValue($task->getRepeatBy() == 'start_date' ? $task->getStartDate()->getTimestamp() : $task->getDueDate()->getTimestamp());
      $count = 0;
      if($date->getTimestamp() >= $min_date->getTimestamp()) {
         return array('date' => $date, 'count' => $count);
      }
      
      while ($date->getTimestamp() < $min_date->getTimestamp()) {
         if ($task->getRepeatD() > 0) {
            $date = $date->add('d', $task->getRepeatD());
         } else if ($task->getRepeatM() > 0) {
            $date = $date->add('M', $task->getRepeatM());
         } else if ($task->getRepeatY() > 0) {
            $date = $date->add('y', $task->getRepeatY());
         }
         $count++;
      }
      return array('date' => $date, 'count' => $count);
   } else return array('date' => $min_date, 'count' => 0);
}

Hope that helps troubleshoot the issue.

8
Installation problems / Re: Unable to upgrade
« on: January 06, 2010, 10:50:59 pm »
Agree.  1.4.2 is the last working version for me as well.  Seems the focus has been releasing new email features and not bug fixes.  This type of release cycle will just backlog an unmanageable amount of bugs.  Hope this changes.

9
Older versions / Table 'og_template_parameters' already exists
« on: October 05, 2009, 08:53:11 pm »
Currently stuck at OpenGoo version 1.4.2.

Tried upgrading to 1.5, 1.5.1, 1.5.2, 1.5.3, each failing, was hoping 1.5.3 would break the trend.

Kept mysqldump and backup files (learned from previous OpenGoo updates) and was able to delete the database and recreate it, re-insert data, and re-upload older files.

Database script fails on each attempt to upgrade.  Searched forums but could not find solution.  Seems to be a common issue with no solution.  Attempted to go through the 1_5_figazza.php file and manually fix lines creating error.  Too many errors to debug and be cost-effective.

Messages seen on opengoo/public/upgrade/ page:
    * Config file found and loaded.
    * File '/config/config.php' exists and is writable
    * Folder '/config' exists and is writable
    * Folder '/cache' exists and is writable
    * Folder '/tmp' exists and is writable
    * Folder '/upload' exists and is writable
    * Extension 'mysql' is loaded
    * Extension 'gd' is loaded
    * Extension 'simplexml' is loaded
    * Upgrade script has connected to the database.
    * Test query has been executed. Its safe to proceed with database migration.
    * Upgrade script has connected to the database.
    * Test query has been executed. Its safe to proceed with database migration.
    *
    * Failed to execute DB schema transformations. MySQL said: Table 'og_template_parameters' already exists
    * Error upgrading to version 1.5.3

Would like to keep using OpenGoo but in-house bug-fixes are becoming too costly to maintain, or recommend, as a solution.

Solution would be great.  Thanks.

10
Older versions / Re: 1.5 rc - tasks / milestones in wrong workspaces
« on: August 04, 2009, 01:06:32 pm »
Well done! :D

11
1.4 final / After 1.4.2: IE7 / Tasks Glitch When Scrolling
« on: June 17, 2009, 12:18:21 pm »
I upgraded to 1.4.2 yesterday morning and I hadn't noticed this issue until this morning. 

On the Tasks tab when you scroll down to see more tasks, the Milestones above the tasks scroll but the corresponding tasks remain stationary.  The problem somewhat is alleviated, though still a sluggish response, by switching to IE8 but can be recreated by putting IE8 in compatibility mode.  The users who brought this to my attention use IE7 (have not upgraded to IE8).

I am going to try and downgrade to 1.4.1 since this issue was not present then.  Has anyone else seen this issue or know of a resolution, other than upgrading to IE8?

Thanks!

12
How To's / Re: iCal URL For Calendar Giving .php File Download?
« on: June 16, 2009, 11:20:33 am »
I had this problem while using Firefox.  I copied the link into IE7 and it worked.  You could also try changing http: to webcal:  If that doesn't work for you let me know and I'll work with you to get it resolved.

13
Components / Re: iCal server
« on: June 01, 2009, 12:34:10 pm »
I'm new at streaming calendar info from web to Outlook so I don't know if this is something everyone already knew or even if it is the intended method or not, but to get it to work with Outlook 2007, I had to change my feed link from http:// to webcal://.  From there, it imports the event into the correct day, just not the right time.  Still working on that.

Pages: [1]