[rt-users] Problem with JSGantt Extension.

[Julien CAUNAN]

Hi everybody,

Thank you Kevin, in fact I've applied the patch (my RT version is 3.8.8), and Gantt extension work correctly.
Two days ago, I've writen a mail about a function I built on RT :

 I would like to have some informations about the differents possibilities of RT with this extension RT-Authen-ExternalAuth.

In fact, we work with the RT 3.8.8 and I would like to export to an other DB (Linux, Mysql...) some information about tickets.
Some personnes of my company have to clock their works (TimeWorked) everyday, there is an application to load their time worked, I would like to do that with RT from " What I did today" HTML page.

When they click on "Record all updates", they update all their tickets and I would like to load on the other DB these timeworks. I wrote the Perl code that I wanted to insert in the "MyDay.html".

In fact, the begening of the function is :

use warnings;
use strict;
use Time::Local;
use base qw(RT::CustomFieldValues);

use DBI;                    # Charger le module DBI
use vars qw/ $VERSION /;    # Version du script
$VERSION = '1.0';

# Paramètres de connexion à la base de données
my $bd          = 'pointage';
my $serveur     = 'sqlxxxxxxx;
my $identifiant = 'xxx';
my $motdepasse  = 'xxxx';

# Connexion à la base de données MySQL
my $dbh = DBI->connect( "dbi:xxxxx:dbname=$bd;host=$serveur;", $identifiant, $motdepasse )
  or die "Connexion impossible à la base de données $bd !";

# Insertion des données
my $requete_sql_pointage = <<"SQL";
  INSERT INTO pointage (  matricule, sect, type-pointage, ordre, temps_passe, date_pointage, nom )
  VALUES ( $owner, 'S760044', '2', $args{Ordre Byo}, $worked, $day/$mon/$yr $hr:$min:$sec, $user );
SQL

my $sth_pointage = $dbh->prepare($requete_sql_pointage) or die $dbh->errstr;
  $sth_pointage->execute( $owner, 'S760044', '2', $args{Ordre Byo}, $worked, $day/$mon/$yr $hr:$min:$sec, $user )
    or die "Echec Requête $requete_sql_pointage : $DBI::errstr";


# Déconnexion de la base de données
$dbh->disconnect();

Can you tell me how can I do that ? And "extension RT-Authen-ExternalAuth", would be it work in my case ? I 've this extension in my RT for an other function and it works.


Thank you for your help.

Best regards,


Julien CAUNAN
Support Moyens De Tests
Av. Paul Gellos, BP 531 - 64105 - BAYONNE Cedex - FRANCE
julien.caunan at bmscircuits.com
Tél   : +33 (0)5 59 58 41 51
Mob :
Fax : +33 (0)5 59 58 57 01
www.bmscircuits.com

 Please consider your environmental responsibility before printing this e-mail

________________________________________
De : rt-users-bounces at lists.bestpractical.com [rt-users-bounces at lists.bestpractical.com] de la part de Kevin Falcone [falcone at bestpractical.com]
Envoyé : mardi 16 octobre 2012 20:38
À : rt-users at lists.bestpractical.com
Objet : Re: [rt-users] Problem with JSGantt Extension.

On Tue, Oct 16, 2012 at 04:51:46PM +0000, Julien CAUNAN wrote:
>    I've installed "RT-Extension-JSGantt" with (middle) success but it doesn't appear on my RT.
>
>    It seems that it needs to apply a patch, someone can tell me how do you apply this patch (the
>    real procedure).

You didn't list your RT version, the patch directions are in the
README file if you're running 3.8.

-kevin
# " Ce courriel et les documents qui lui sont joints peuvent contenir des informations confidentielles ou ayant un caractère privé. S'ils ne vous sont pas destinés, nous vous signalons qu'il est strictement interdit de les divulguer, de les reproduire ou d'en utiliser de quelque manière que ce soit le contenu. Si ce message vous a été transmis par erreur, merci d'en informer l'expéditeur et de supprimer immédiatement de votre système informatique ce courriel ainsi que tous les documents qui y sont attachés." ****** " This e-mail and any attached documents may contain confidential or proprietary information. If you are not the intended recipient, you are notified that any dissemination, copying of this e-mail and any attachments thereto or use of their contents by any means whatsoever is strictly prohibited. If you have received this e-mail in error, please advise the sender immediately and delete this e-mail and all attached documents from your computer system." #