Linking Project Plugin to Activities.

djjassen · 2008-03-10 00:43:16

We are currently using the Activities plugin to produce detail timesheets for our department through Crystal Reports. I know there is probably cheaper ways to do it, but we already have crystal licences and we have a Crystal resource on board. We also use the project plugin.

I have been asked to create a link through from activities to the Activity plugin. On the add activity entry screen, we would like to see a list of the current project list so that we can report against the projects as well in our timesheets.

I need some help getting the foreign key for the projects plugin into the plugin_activity.form.php?new=1 form.

Many thanks

Jassen

tsmr · 2008-03-10 01:04:32

You can at this time use activity to see in report 'General report of activities of a technician' and see planned tasks of projects for this technicien.

djjassen · 2008-03-10 01:51:10

I do see that thanks but that is not what we are looking for.

When in activities and adding an activity for the last hour, if that activity was working on a project, which project was it. We would like to select this from a list out of the project plugin of the current projects. With this foreign key in the activity table, we would be able to report on how much time we spent on each project.

Jassen

tsmr · 2008-03-10 01:58:45

Humm

you must use a table for this i think...

DROP TABLE IF EXISTS `glpi_plugin_activity_device`;
CREATE TABLE `glpi_plugin_activity_device` (
    `ID` int(11) NOT NULL auto_increment,
    `FK_activity` int(11) NOT NULL default '0',
    `FK_device` int(11) NOT NULL default '0',
    `device_type` int(11) NOT NULL default '0',
    PRIMARY KEY  (`ID`),
    UNIQUE KEY `FK_activity` (`FK_activity`,`FK_device`,`device_type`),
    KEY `FK_activity_2` (`FK_activity`),
    KEY `FK_device` (`FK_device`,`device_type`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

and use the type of the plugin projet for device_type : 2300

And add forms for this.

djjassen · 2008-03-10 02:02:38

Actually, I have just been testing what you said above and this does not work for me. I go into a project, create a task against my name and it does not appear on that report. when I go into the installations plugin and do the same test, the item does appear.

Jassen

tsmr · 2008-03-10 02:03:24

the task is planned ?

which version of projet ?

djjassen · 2008-03-10 02:06:59

Yes I tried all the combinations, planned, unplanned, processing, finished. I have the latest version of the project plugin ,but not the latest version of GLPI. I am using version 7 though.

tsmr · 2008-03-10 02:13:02

oups..i must publicate a new version af activity (compatible with 0.8.1 version of project)

djjassen · 2008-03-10 02:20:22

Ok thanks, i will wait for that release and test it again.

Regards

Jassen

tsmr · 2008-03-10 02:21:42

http://www.glpi-project.org/spip.php?article176

Forum GLPI-Project

Announcement

#1 2008-03-10 00:43:16

Linking Project Plugin to Activities.

#2 2008-03-10 01:04:32

Re: Linking Project Plugin to Activities.

#3 2008-03-10 01:51:10

Re: Linking Project Plugin to Activities.

#4 2008-03-10 01:58:45

Re: Linking Project Plugin to Activities.

#5 2008-03-10 02:02:38

Re: Linking Project Plugin to Activities.

#6 2008-03-10 02:03:24

Re: Linking Project Plugin to Activities.

#7 2008-03-10 02:06:59

Re: Linking Project Plugin to Activities.

#8 2008-03-10 02:13:02

Re: Linking Project Plugin to Activities.

#9 2008-03-10 02:20:22

Re: Linking Project Plugin to Activities.

#10 2008-03-10 02:21:42

Re: Linking Project Plugin to Activities.

Board footer