Author Topic: How to Add Gantt Charts (JSGantt) to Feng Office  (Read 248282 times)

allenlook

  • Volunteer Moderator
  • Sr. Member
  • ****
  • Posts: 312
    • MSN Messenger - sii_lookal@hotmail.com
    • View Profile
    • SI Group, Inc.
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #330 on: September 20, 2011, 09:22:34 am »
Did you try the mysql_upgrade command as indicated?
I am a volunteer moderator.  Any statements, opinions or observations I contribute are solely mine and are not necessarily shared by the makers of Feng Office.

alexandz

  • Newbie
  • *
  • Posts: 1
    • View Profile
    • Email
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #331 on: December 15, 2011, 04:42:49 pm »
how I can create for jsgantt index.php?

stephan33

  • Newbie
  • *
  • Posts: 2
    • View Profile
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #332 on: December 24, 2011, 12:51:25 am »
Resolved, had to change the delimiter to // for the version of MySQL I am using.

First thank you for all the good post on here, I am just getting started with Fengoffice 1.7 and got everything running just fine.

I was intrigued with the Gantt cart "patch" and downloaded v 13.1 which is attached to this thread.

The SQL script appears to bum at the (everything before was executed fine)
CREATE PROCEDURE getwebit_office17.`get_my_workspaces`()

The error I am getting in the client is:

/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS `pParent`,  (CASE `og_projects`.`p2` WHEN 0 THEN  `og_projects`.`p1` ELSE' at line 1 */
 END;
/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 1 */
/* 0 rows affected, 0 rows found. Duration for 1 of 5 queries: 0.062 sec. */

I am not seeing anything obvious but not a SQL guru either.

Any help welcome!
Thanks,
Stephan
« Last Edit: December 24, 2011, 11:46:41 am by stephan33 »

stephan33

  • Newbie
  • *
  • Posts: 2
    • View Profile
Gantt Charts Permissions
« Reply #333 on: December 24, 2011, 03:20:29 pm »
Thanks to all the tips on this thread I have the Gantt Chart & Tab working.  My question is around permissions, a user x who has access to workspace x is able to view gantt charts for all workspaces.  Is there a way to limit user x to view only his own workspace tasks this user is assigned to?

Also interestingly, one personal workspace is included in the options while the "main" workspace" for that user is not? I had the project workspace assigned to the user instead of the his personal one.

Thanks,
Stephan
« Last Edit: December 25, 2011, 12:52:34 pm by stephan33 »

proffnet

  • Newbie
  • *
  • Posts: 1
    • View Profile
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #334 on: January 04, 2012, 05:26:29 pm »
I get a slightly different error within MySQLadmin:

CREATE FUNCTION fengoffice.`my_getworkspace` (
s CHAR( 20 )
) RETURNS char( 128 ) CHARSET latin1 RETURN (
SELECT pID
FROM my_workspaces
WHERE pID = s
);

MySQL said: Documentation
#1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

Any ideas, got me stumped.... using V13.1 installed in a tab. But this is the SQL code to create the tables/functions etc... where it is failing.

Add

 SET GLOBAL log_bin_trust_function_creators = 1;

It should help. You have to have administrator rights to do this.

memnon

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #335 on: January 10, 2012, 06:14:40 am »
Hi there...

i use FengOffice 1.7.5 and have 2 problems with the installation:

if i switch to the "tab" i get following errors:

Warning: include(../chartglobal.php) [function.include]: failed to open stream: No such file or directory in C:\xampp\htdocs\og\application\views\lab\index.php on line 203

Warning: include() [function.include]: Failed opening '../chartglobal.php' for inclusion (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\og\application\views\lab\index.php on line 203



i searched the folder xampp, i dont have a chartglobal.php file - where do i get this ?


2nd Problem

if i try to use your php script with phpMyAdmin i get errors even on the 1st command:

ROP TABLE IF EXISTS my_tblmilestones$$
CREATE TABLE `my_tblmilestones` (
  `rowcount` varchar(20) DEFAULT NULL,
  `pID` int(32) DEFAULT NULL,
  `pName` varchar(128) DEFAULT NULL,
  `pStart` date DEFAULT NULL,
  `pEnd` date DEFAULT NULL,
  `pColor` decimal(10,0) DEFAULT NULL,
  `pMile` int(11) DEFAULT NULL,
  `pRes` varchar(32) DEFAULT NULL,
  `pEmail` varchar(32) DEFAULT NULL,
  `pComp` decimal(10,0) DEFAULT NULL,
  `pGroup` int(11) DEFAULT NULL,
  `pParent` varchar(64) DEFAULT NULL,
  `pWBS` varchar(64) DEFAULT NULL,
  `pOrderBy` varchar(256) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1$$



#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `my_tblmilestones` ( `rowcount` varchar(20) DEFAULT NULL, `pID`' at line 2


i am really new to all this but any help would be great...

i made all the steps before (i use the solution with TAB integrated view)

memnon

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #336 on: January 10, 2012, 09:28:18 am »
1st problem solved

i included the chartglobal.php whilst i didnt need that file

2nd problem , still no clue :(

memnon

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #337 on: January 10, 2012, 09:55:46 am »
well i dont have to replace ";" with "$$" as noted in the discription

so 2nd prob itself is solfed, but leads me into next problem...


BTW: my Version: Server Version: 5.5.16
Protokoll-Version: 10

SQL-Befehl:

CREATE PROCEDURE fengoffice.`get_my_workspaces` (
) BEGIN DELETE FROM my_tblworkspaces;

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
« Last Edit: January 10, 2012, 09:57:51 am by memnon »

luci

  • Newbie
  • *
  • Posts: 1
    • View Profile
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #338 on: January 20, 2012, 09:07:02 am »
yea,
 the same with me :(

sql file: feng_gantt_13.1.sql, importing it with PhpMyAdmin..

Code: [Select]
SQL query:
CREATE PROCEDURE track.`get_my_workspaces` (
)$$ BEGIN DELETE FROM my_tblworkspaces;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BEGIN

DELETE FROM my_tblworkspaces' at line 2

asdfghj

  • Freshman
  • *
  • Posts: 16
    • View Profile
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #339 on: January 21, 2012, 02:09:16 pm »
@luci
i had similar issues when i was tring to install this on feng office 2 beta 3.  once i downgraded to 1.7.5  the script completed without error and i am able to pull up the page.  

i am however getting some errors about undefined variables and indexes when its listing the workspaces and a few other things.  It can pull the resources fine, just errors with a few others.

--errors--

(top of page)
Notice: Undefined index: hidSubmitted in C:\wamp\www\manager\application\views\gantt\index.php on line 215


(these are workspaces)
Notice: Undefined variable: sel in C:\wamp\www\manager\application\views\gantt\index.php on line 368

Notice: Undefined index: pID in C:\wamp\www\manager\application\views\gantt\index.php on line 371

Notice: Undefined index: pID in C:\wamp\www\manager\application\views\gantt\index.php on line 371

Notice: Undefined index: pID in C:\wamp\www\manager\application\views\gantt\index.php on line 371

Notice: Undefined index: pID in C:\wamp\www\manager\application\views\gantt\index.php on line 371

Notice: Undefined index: pID in C:\wamp\www\manager\application\views\gantt\index.php on line 371

(colors checkbox)
Notice: Undefined index: chkColor in C:\wamp\www\manager\application\views\gantt\index.php on line 454

(duration checkbox
Notice: Undefined index: chkDuration in C:\wamp\www\manager\application\views\gantt\index.php on line 468

(dates checkbox)
Notice: Undefined index: chkDates in C:\wamp\www\manager\application\views\gantt\index.php on line 470

(bottom of page)
Notice: Undefined variable: SQL_Start in C:\wamp\www\manager\application\views\gantt\index.php on line

Notice: Undefined variable: SQL_End in C:\wamp\www\manager\application\views\gantt\index.php on line
« Last Edit: January 21, 2012, 02:30:38 pm by asdfghj »

jolivaresd

  • Freshman
  • *
  • Posts: 18
    • View Profile
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #340 on: February 19, 2012, 02:01:46 am »
Friends,

I need export to a pdf file or print the gantt, but when i ty to print, the color bars don't appears...
Somebody can help me or can solve this issue?

Thanks,
J
Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las mismas cosas.

VER

  • Freshman
  • *
  • Posts: 14
    • View Profile
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #341 on: March 14, 2012, 01:51:52 pm »
Friends,

I need export to a pdf file or print the gantt, but when i ty to print, the color bars don't appears...
Somebody can help me or can solve this issue?

Thanks,
J

In my case this has been solved by modifying all instances of opacity:0.9 to opacity:1 in both jsgantt.js and jsgantt.compressed.js

Thx for the great work!

The only problem I'm having is that it shows all workspaces and all resources. I've put all my tasks in one Workspace and limited the query to that workspace. This worked fine in this particular case.
I did not manage to get the tab working though (but stopped  investigating it for the time being).
« Last Edit: March 14, 2012, 01:54:52 pm by VER »

beto

  • Newbie
  • *
  • Posts: 7
    • View Profile
Show Gantt Tab only to certain users
« Reply #342 on: May 23, 2012, 03:04:32 pm »
Hi Allen,

Could you help a little bit, I want to show the Gantt Tab only to certain users and hide the tab for everyone else, for this maybe I could use the username.

Thanks, Roberto.

jeob

  • Newbie
  • *
  • Posts: 2
    • View Profile
    • Email
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #343 on: June 11, 2012, 12:54:18 pm »
Hi,

First thank you for trying to help us to add gantt chart in fengoffice.

I would like to know if your jsgantt code work in fengoffice 2.0 ?

I tried to install it but it seems that some tables doesn't exit in the new version (fo_projects, fo_workspaces_object)

Thank you for help

Have a nice day

stmitchell

  • Newbie
  • *
  • Posts: 1
    • View Profile
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #344 on: August 29, 2012, 09:20:19 pm »

I would like to know if your jsgantt code work in fengoffice 2.1?

I am having exact same issues as above post