Opened 14 years ago

Closed 13 years ago

#72 closed enhancement (fixed)

internationalisation of strings

Reported by: cedric Owned by: cedric
Priority: major Milestone: Release R 0.4
Component: Programme R Version: 0.4
Keywords: Cc:

Description (last modified by cedric)

Développement d'une table postgres et des relations vers cette table pour avoir un programme R pleinement compatible avec plusieurs langages.

create table ref.ts_messager_msr (
msr_id serial primary key,
msr_element varchar(50),
msr_number integer,
msr_text text,
msr_lang varchar(10),
msr_type varchar(20),
msr_comment text,
CONSTRAINT c_uk_ts_messager_msr unique(msr_element,msr_number,msr_lang),
CONSTRAINT c_ck_ts_messager_msr_msr_lang check (msr_lang='french' or msr_lang='english' or msr_lang='spanish'));

-- mise à jour de la table de maintenance
INSERT INTO iav.ts_maintenance_main( main_ticket,main_description) VALUES (72,'creation d''une tableref.ts_messager_msr  pour l''internationalisation');

Change History (7)

comment:1 Changed 14 years ago by cedric

  • Description modified (diff)

comment:2 Changed 14 years ago by cedric

  • Description modified (diff)

comment:3 Changed 14 years ago by cedric

note : cette table est dans ref donc une modification est commune à l'ensemble des schémas et je ne sais pas trop où la placer

comment:4 Changed 14 years ago by cedric

  • Status changed from new to accepted

comment:5 Changed 14 years ago by cedric

drop table if exists ref.ts_messager_msr CASCADE;
        create table ref.ts_messager_msr (
        msr_id serial primary key,
        msr_element varchar(50),
        msr_number varchar(5),
        msr_type varchar(20),
        msr_endofline boolean,
        msr_comment text,
CONSTRAINT c_uk_ts_messager_msr unique(msr_element,msr_number)
);
comment on table ref.ts_messager_msr is 'this table contains the name and descriptions the string msr_element.msr_number which is used in t_messagelang_mrl 
to put strings for each langage, it is separated as the comment and the place in the program applies only once';
comment on column ref.ts_messager_msr.msr_endofline is 'will the string be terminated by antislash+n';
-- below done in C:\Documents and Settings\cedric\Mes documents\Migrateur\programmes\workspace3.5\STACOMIR0.3\requètes\base_nationale\ts_messager_msr2.xls
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (1,'ref',1,'referential',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (2,'ref',2,'referential',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (3,'ref',3,'referential',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (4,'ref',4,'referential',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (5,'ref',5,'referential',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (6,'ref',6,'referential',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (7,'ref',7,'referential',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (8,'ref',8,'referential',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (9,'ref',9,'referential',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (10,'ref',10,'referential',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (11,'ref',11,'referential',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (12,'ref',12,'referential',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (13,'Bilan_lot',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (14,'Bilan_lot',2,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (15,'Bilan_lot',3,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (16,'Bilan_lot',4,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (17,'Bilan_poids_moyen',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (18,'Bilan_poids_moyen',2,'class',TRUE,' context nrows found for conversion coefficients');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (19,'Bilan_poids_moyen',3,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (20,'Bilan_poids_moyen',4,'class',FALSE,' at the start of a warning');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (21,'Bilan_poids_moyen',5,'class',FALSE,' context weight of undrained glass eels');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (22,'Bilan_poids_moyen',6,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (23,'Bilan_poids_moyen',7,'class',FALSE,' all weights both cases selected');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (24,'Bilan_poids_moyen',8,'class',FALSE,'graphs');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (25,'Bilan_poids_moyen',9,'class',FALSE,'graphs');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (26,'Bilan_poids_moyen',10,'class',FALSE,'graphs, within a paste');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (27,'Bilan_poids_moyen',11,'class',FALSE,'graphs');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (28,'Bilan_poids_moyen',12,'class',FALSE,'graphs');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (29,'Bilan_poids_moyen',13,'class',FALSE,'graphs');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (30,'Bilan_poids_moyen',14,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (31,'Bilan_poids_moyen',15,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (32,'Bilan_poids_moyen',16,'class',FALSE,'frame question');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (33,'Bilan_poids_moyen',17,'class',FALSE,'frame title');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (34,'Bilan_poids_moyen',18,'class',FALSE,'button message for graphes');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (35,'Bilan_poids_moyen',19,'class',FALSE,'button message for coefficients');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (36,'Bilan_poids_moyen',20,'class',FALSE,'button message for size (bubbles of different size according to the numbers');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (37,'Bilan_poids_moyen',21,'class',FALSE,'button message for regression');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (38,'Bilan_poids_moyen',22,'class',FALSE,'button message to export the data');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (39,'Bilan_poids_moyen',23,'class',FALSE,'button message button to quit');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (40,'Bilan_stades_pigm',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (41,'Bilan_stades_pigm',2,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (42,'Bilan_stades_pigm',3,'class',FALSE,' glablel');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (43,'Bilan_stades_pigm',4,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (44,'Bilan_stades_pigm',5,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (45,'Bilan_stades_pigm',6,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (46,'Bilan_taille',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (47,'Bilan_taille',2,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (48,'Bilan_taille',3,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (49,'Bilan_taille',4,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (50,'Bilan_taille',5,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (51,'Bilan_taille',6,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (52,'Bilan_taille',7,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (53,'Bilan_taille',8,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (54,'BilanCondtionEnv',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (55,'BilanCondtionEnv',2,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (56,'BilanCondtionEnv',3,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (57,'BilanCondtionEnv',4,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (58,'BilanCondtionEnv',5,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (59,'BilanEspeces',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (60,'BilanEspeces',2,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (61,'BilanEspeces',3,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (62,'BilanEspeces',4,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (63,'BilanEspeces',5,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (64,'BilanEspeces',6,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (65,'BilanEspeces',7,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (66,'BilanFonctionnementDC',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (67,'BilanFonctionnementDC',2,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (68,'BilanFonctionnementDC',3,'class',FALSE,'graph xlabel');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (69,'BilanFonctionnementDC',4,'class',FALSE,'graph ylabel');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (70,'BilanFonctionnementDC',5,'class',FALSE,'graph title');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (71,'BilanFonctionnementDC',6,'class',FALSE,'graph legend');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (72,'BilanFonctionnementDC',7,'class',FALSE,'graph legend');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (73,'BilanFonctionnementDC',8,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (74,'BilanFonctionnementDC',9,'class',FALSE,'graph boxes ylab');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (75,'BilanFonctionnementDC',10,'class',FALSE,'graph boxes legend');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (76,'BilanFonctionnementDC',11,'class',FALSE,'graph boxes legend');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (77,'BilanFonctionnementDC',12,'class',FALSE,'graph boxes upper box title');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (78,'BilanFonctionnementDC',13,'class',FALSE,'graph boxes lower box title');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (79,'BilanFonctionnementDC',14,'class',FALSE,'… path …');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (80,'BilanFonctionnementDC',15,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (81,'BilanFonctionnementDF',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (82,'BilanFonctionnementDF',2,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (83,'BilanFonctionnementDF',3,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (84,'BilanFonctionnementDF',4,'class',FALSE,' progressbar');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (85,'BilanFonctionnementDF',5,'class',FALSE,' progressbar');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (86,'BilanFonctionnementDF',6,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (87,'BilanFonctionnementDF',7,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (88,'BilanFonctionnementDF',8,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (89,'BilanFonctionnementDF',9,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (90,'BilanFonctionnementDF',10,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (91,'BilanMigration',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (92,'BilanMigration',2,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (93,'BilanMigration',3,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (94,'BilanMigration',4,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (95,'BilanMigration',5,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (96,'BilanMigration',6,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (97,'BilanMigration',7,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (98,'BilanMigration',8,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (99,'BilanMigration',9,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (100,'BilanMigrationConditionEnv',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (101,'BilanMigrationConditionEnv',2,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (102,'BilanMigrationConditionEnv',3,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (103,'BilanMigrationConditionEnv',4,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (104,'BilanMigrationConditionEnv',5,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (105,'BilanMigrationConditionEnv',6,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (106,'BilanMigrationConditionEnv',7,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (107,'BilanMigrationConditionEnv',8,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (108,'BilanMigrationConditionEnv',9,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (109,'BilanMigrationInterannuelle',1,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (110,'BilanMigrationInterannuelle',2,'class',FALSE,' part of a message');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (111,'BilanMigrationInterannuelle',3,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (112,'BilanMigrationInterannuelle',4,'class',FALSE,'graph : pasted within the title');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (113,'BilanMigrationInterannuelle',5,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (114,'BilanMigrationInterannuelle',6,'class',FALSE,'graph cum group');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (115,'BilanMigrationInterannuelle',7,'class',FALSE,'graph cum X');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (116,'BilanMigrationInterannuelle',8,'class',FALSE,'graph cum Y');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (117,'BilanMigrationInterannuelle',9,'class',FALSE,'graph cum within title');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (118,'BilanMigrationInterannuelle',10,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (119,'BilanMigrationPar',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (120,'BilanMigrationPar',2,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (121,'BilanMigrationPar',3,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (122,'BilanMigrationPar',4,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (123,'BilanMigrationPar',5,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (124,'BilanMigrationPar',6,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (125,'BilanMigrationPar',7,'class',FALSE,' path');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (126,'ConnexionODBC',1,'class',TRUE,'note messages here are not printed in the console, sono use for this, kept for record');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (127,'ConnexionODBC',2,'class',TRUE,'note messages here are not printed in the console, sono use for this, kept for record');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (128,'ConnexionODBC',3,'class',TRUE,'note messages here are not printed in the console, sono use for this, kept for record');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (129,'ConnexionODBC',4,'class',TRUE,'note messages here are not printed in the console, sono use for this, kept for record');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (130,'ConnexionODBC',5,'class',FALSE,'note messages here are not printed in the console, sono use for this, kept for record');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (131,'ConnexionODBC',6,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (132,'PasdeTemps',1,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (133,'PasdeTemps',2,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (134,'PasdeTemps',3,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (135,'PasdeTemps',4,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (136,'PasdeTempsJournalier',1,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (137,'PasdeTempsJournalier',2,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (138,'PasdeTempsJournalier',3,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (139,'PasdeTempsJournalier',4,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (140,'PasdeTempsJournalier',5,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (141,'PasdeTempsJournalier',6,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (142,'PasdeTempsJournalier',7,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (143,'PasdeTempsJournalier',8,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (144,'RefAnnee',1,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (145,'RefAnnee',2,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (146,'RefAnnee',3,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (147,'RefDC',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (148,'RefDC',2,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (149,'RefDC',3,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (150,'RefDC',4,'class',FALSE,' button');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (151,'RefDC',5,'class',FALSE,' title');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (152,'RefDC',6,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (153,'RefDC',7,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (154,'RefDF',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (155,'RefDF',2,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (156,'RefDF',3,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (157,'RefDF',4,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (158,'Refpar',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (159,'Refpar',2,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (160,'Refpar',3,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (161,'Refpar',4,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (162,'Refparqual',1,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (163,'Refparquan',1,'class',FALSE,'TODO check this class');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (164,'Refperiode',1,'class',FALSE,'TODO check this class');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (165,'RefpoidsMoyenPeche',1,'class',FALSE,'TODO check this class');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (166,'RefStades',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (167,'RefStades',2,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (168,'RefStades',3,'class',FALSE,' this is a frame label');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (169,'RefStades',4,'class',FALSE,' this is a frame label');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (170,'RefStades',5,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (171,'RefStades',6,'class',FALSE,' this is a frame label');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (172,'RefStationMesure',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (173,'RefStationMesure',2,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (174,'RefStationMesure',3,'class',FALSE,' frame label');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (175,'RefStationMesure',4,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (176,'RefTaxon',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (177,'RefTaxon',2,'class',FALSE,' frame label');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (178,'RefTaxon',3,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (179,'RequeteODBC',1,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (180,'RequeteODBC',2,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (181,'RequeteODBC',3,'class',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (182,'RequeteODBC',4,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (183,'RequeteODBC',5,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (184,'RequeteODBC',6,'class',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (185,'fn_EcritBilanJournalier',1,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (186,'fn_EcritBilanJournalier',2,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (187,'fn_EcritBilanJournalier',3,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (188,'fn_EcritBilanJournalier',4,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (189,'fn_EcritBilanJournalier',5,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (190,'fn_EcritBilanMensuel',1,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (191,'fungraph_civelle',1,'function',FALSE,' followed by dis_commentaire');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (192,'fungraph_civelle',2,'function',FALSE,' title');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (193,'fungraph_civelle',3,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (194,'fungraph_civelle',4,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (195,'fungraph_civelle',5,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (196,'fungraph_civelle',6,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (197,'fungraph_civelle',7,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (198,'fungraph_civelle',8,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (199,'fungraph_civelle',9,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (200,'fungraph_civelle',10,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (201,'fungraph_civelle',11,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (202,'fungraph_civelle',12,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (203,'fungraph_civelle',13,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (204,'fungraph_civelle',14,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (205,'fungraph_civelle',15,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (206,'fungraph_civelle',16,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (207,'fungraph_env',1,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (208,'fungraph_env',2,'function',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (209,'fungraph',1,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (210,'fungraph',2,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (211,'fungraph',3,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (212,'fungraph',4,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (213,'fungraph',5,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (214,'fungraph',6,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (215,'fungraph',7,'function',FALSE,' column names');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (216,'funstat',1,'function',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (217,'funstat',2,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (218,'funtable',1,'function',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (219,'funtraitement_poids',1,'function',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (220,'funtraitement_poids',2,'function',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (221,'interface_Bilan_lot',1,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (222,'interface_Bilan_lot',2,'interface',FALSE,' glablel');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (223,'interface_Bilan_lot',3,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (224,'interface_Bilan_lot',4,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (225,'interface_Bilan_lot',5,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (226,'interface_Bilan_lot',6,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (227,'interface_Bilan_lot',7,'interface',FALSE,' tooltip');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (228,'interface_Bilan_lot',8,'interface',FALSE,' tooltip');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (229,'interface_Bilan_lot',9,'interface',FALSE,' tootip and name');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (230,'interface_Bilan_poids_moyen',1,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (231,'interface_Bilan_poids_moyen',2,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (232,'interface_Bilan_poids_moyen',3,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (233,'interface_Bilan_poids_moyen',4,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (234,'interface_Bilan_poids_moyen',5,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (235,'interface_Bilan_poids_moyen',6,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (236,'interface_Bilan_taille',1,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (237,'interface_Bilan_taille',2,'interface',FALSE,' tooltip');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (238,'interface_BilanConditionEnv',1,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (239,'interface_BilanConditionEnv',2,'interface',FALSE,' tootip');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (240,'interface_BilanConditionEnv',3,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (241,'interface_BilanConditionEnv',4,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (242,'interface_BilanEspeces',1,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (243,'interface_BilanEspeces',2,'interface',FALSE,' glabel title');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (244,'interface_BilanEspeces',3,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (245,'interface_BilanEspeces',4,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (246,'interface_Bilanespeces',5,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (247,'interface_BilanEspeces',6,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (248,'interface_BilanEspeces',7,'interface',FALSE,' label de la boite liste');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (249,'interface_BilanMigration',1,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (250,'interface_BilanMigration',2,'interface',FALSE,' tooltip');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (251,'interface_BilanMigration',3,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (252,'interface_BilanMigration',4,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (253,'interface_BilanMigration',5,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (254,'interface_BilanMigrationConditionEnv',1,'interface',FALSE,' ');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (255,'interface_BilanMigrationConditionEnv',2,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (256,'interface_BilanMigrationInterannuelle',1,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (257,'interface_BilanMigrationInterannuelle',2,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (258,'interface_BilanMigrationInterannuelle',3,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (259,'interface_BilanMigrationInterannuelle',4,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (260,'interface_BilanMigrationInterannuelle',5,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (261,'interface_BilanMigrationInterannuelle',6,'interface',FALSE,' tooltip');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (262,'interface_BilanMigrationInterannuelle',7,'interface',FALSE,' tooltip');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (263,'interface_BilanMigrationInterannuelle',8,'interface',FALSE,' tooltip');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (264,'interface_BilanMigrationInterannuelle',9,'interface',FALSE,' tooltip');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (265,'interface_BilanMigrationInterannuelle',10,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (266,'interface_BilanMigrationInterannuelle',11,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (267,'interface_BilanMigrationInterannuelle',12,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (268,'interface_BilanMigrationInterannuelle',13,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (269,'interface_BilanMigrationInterannuelle',14,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (270,'interface_BilanMigrationInterannuelle',15,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (271,'interface_BilanMigrationInterannuelle',16,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (272,'interface_BilanMigrationInterannuelle',17,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (273,'interface_BilanMigrationPar',1,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (274,'interface_BilanMigrationPar',2,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (275,'interface_BilanMigrationPar',3,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (276,'interface_BilanMigrationPar',4,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (277,'interface_BilanMigrationPar',5,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (278,'interface_BilanMigrationPar',6,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (279,'interface_BilanMigrationPar',7,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (280,'interface_BilanFonctionnementDC',1,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (281,'interface_BilanFonctionnementDC',2,'interface',FALSE,' tootip');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (282,'interface_BilanFonctionnementDC',3,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (283,'interface_BilanFonctionnementDC',4,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (284,'interface_BilanFonctionnementDC',5,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (285,'interface_graphique',1,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (286,'interface_graphique',2,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (287,'interface_graphique',3,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (288,'interface_graphique',4,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (289,'interface_graphique',5,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (290,'interface_graphique',6,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (291,'interface_graphique',7,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (292,'interface_graphique',8,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (293,'interface_graphique',9,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (294,'interface_graphique',10,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (295,'interface_graphique',11,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (296,'interface_graphique',12,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (297,'interface_graphique',13,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (298,'interface_graphique',14,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (299,'interface_graphique',15,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (300,'interface_graphique',16,'interface',FALSE,' TITRE PRINCIPAL !!!');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (301,'interface_graphique',17,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (302,'interface_graphique',18,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (303,'interface_graphique',19,'interface',TRUE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (304,'interface_graphique_menu',1,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (305,'interface_graphique_menu',1.1,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (306,'interface_graphique_menu',1.2,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (307,'interface_graphique_menu',1.3,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (308,'interface_graphique_menu',1.4,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (309,'interface_graphique_menu',2,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (310,'interface_graphique_menu',2.1,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (311,'interface_graphique_menu',2.2,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (312,'interface_graphique_menu',2.3,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (313,'interface_graphique_menu',2.4,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (314,'interface_graphique_menu',2.5,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (315,'interface_graphique_menu',2.6,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (316,'interface_graphique_menu',2.7,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (317,'interface_graphique_menu',2.8,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (318,'interface_graphique_menu',2.9,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (319,'interface_graphique_menu',2.10,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (320,'interface_graphique_menu',2.11,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (321,'interface_graphique_menu',2.12,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (322,'interface_graphique_menu',2.13,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (323,'interface_graphique_menu',3,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (324,'interface_graphique_log',1,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (325,'interface_graphique_log',2,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (326,'interface_graphique_log',3,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (327,'interface_graphique_log',4,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (328,'interface_graphique_log',5,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (329,'interface_graphique_log',6,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (330,'interface_graphique_log',7,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (331,'interface_graphique_log',8,'interface',FALSE,'');
insert into ref.ts_messager_msr(msr_id,msr_element,msr_number,msr_type,msr_endofline,msr_comment) values (332,'interface_graphique_log',9,'interface',FALSE,'');

update ref.ts_messager_msr set msr_comment=NULL where msr_comment='';

drop table if exists ref.ts_messagerlang_mrl;
create table ref.ts_messagerlang_mrl (
        mrl_id serial primary key,
        mrl_msr_id integer,
        mrl_text text,
        mrl_lang varchar(10),
CONSTRAINT c_ck_mrl_lang check (mrl_lang='French' or mrl_lang='English' or mrl_lang='Spanish'),
CONSTRAINT c_fk_mrl_msr_id FOREIGN KEY (mrl_msr_id) references ref.ts_messager_msr(msr_id),     
CONSTRAINT c_uk_ts_messagerlang_mrl unique(mrl_id,mrl_lang)
);
comment on table ref.ts_messagerlang_mrl is 'this table contains the string of code to appear in the graphical R interface, one for each langage';

insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('1','"Il faut choisir un dispositif de comptage,cliquez sur valider "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('2','"Il faut choisir un taxon,cliquez sur valider "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('3','"Il faut choisir un stade,cliquez sur valider "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('4','"Il faut choisir un parametre,cliquez sur valider "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('5','"Il faut choisir la date de debut"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('6','"Il faut choisir la date de fin"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('7','"Il faut choisir un paramètre quantitatif"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('8','"Il faut choisir un parametre qualitatif"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('9','"Il faut choisir une categorie d''effectif"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('10','"Il faut choisir l''annee de debut"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('11','"Il faut choisir l''annee de fin"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('12','"il faut choisir un dispositif de franchissement,cliquez sur valider "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('13','"La requete est effectuee pour charger les caracteristiques de lot "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('14','"Aucune donnee pour ces lots dans la periode selectionnee"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('15','"Pour recuperer le tableau, tapper : bilan_lot=get("bilan_lot",envir_stacomi), requete=bilan_lot@requete@sql"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('16','"Pour recuperer l''objet graphique, tapper : p, c''est l''objet ggplot cree par l''interface, dans cette interface, la caracteristique choisie s''appelle val_quant"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('17','"La requete est effectuee pour charger les coefficients de conversion "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('18','"lignes trouvees pour les coefficients de conversion"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('19','"Pour recuperer le tableau, tapper : bilan_poids_moyen=get("bilan_poids_moyen",envir_stacomi)@data"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('20','"effectif non renseigne, lots" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('21','"humides" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('22','"secs"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('23','"humides et secs" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('24','"date"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('25','"poids moyens"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('26','"Tendance saisonniere des poids" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('27','", anneedebut="','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('28','", anneefin="','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('29','"modele sinusoidal,a.cos.2pi.(jour-T)/365)+b "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('30','"Pour recuperer le tableau, tapper : import_coe=get("import_coe",envir_stacomi)"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('31','"Repertoire d''ecriture des donnees :"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('32','"Voulez vous ecrire les donnees dans la base ?"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('33','"attention"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('34','"Gra" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('35','"Coe" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('36','"Tail" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('37','"Reg" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('38','"export" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('39','"quitter" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('40','"La requete a été effectuée pour charger les stades pigmentaires"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('41','"Bilan des stades pigmentaires"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('42','"BILAN STADES PIGMENTAIRES" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('43','"Stades pigmentaires"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('44','"et dates d''arrivees en estuaire"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('45','"Choix du titre"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('46','"Il faut choisir au moins une caracteristique quantitative ou qualitative"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('47','"Attention cette requete (croisement de deux vues) peut prendre plusieurs minutes, soyez patient(e)..."','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('48','"Pour recuperer le tableau, tapper : bilan_taille=get("bilan_taille",envir_stacomi)"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('49','"La requete : requete=get("bilan_taille",envir_stacomi)@requete@sql "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('50','"Les donnees : donnees_taille=get("bilan_taille",envir_stacomi)@data"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('51','"Donnees directement issues de la requete : don=get("bilan_taille",envir_stacomi)@requete@query"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('52','"Il faut d''abord faire le calcul, appuyez sur calcul"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('53','"Requete effectuee"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('54','"La requete est effectuee pour charger les conditions environnementales "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('55','"Il faut choisir une station de mesure puis cliquer sur valider "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('56','"Certaines stations de mesure n''ont pas de valeurs associees"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('57','"Aucune valeur de conditions environnementales pour les stations de mesure selectionnees (BilanConditionEnv.r)"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('58','"Statistiques :"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('59','"L''objet Bilan est stocke dans l''environnement envir_stacomi, ecrire  ecrire bilanEspeces=get("bilanEspeces",envir_stacomi), "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('60','"Il faut faire tourner les calculs avant, cliquer sur calc "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('61','"Echec de la requete vers la vue vue_ope_lot_car "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('62','"Il faut lancer les calculs avant cliquez sur calcul"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('63','"Il n''y a aucun poisson dans la base sur cette periode"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('64','"Attention certains effectifs négatifs sont transformés en positifs"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('65','"Verifications des objets et lancement de la requete"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('66','"La requete est effectuee pour charger les pas de temps du DC "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('67','"Il n''y a pas de donnees sur ce DC "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('68','"mois" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('69','"temps en heures" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('70','"Fonctionnement du dispositif de comptage" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('71','"suivi video" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('72','"arret video" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('73','"Ecriture de tableau dans l''environnement envir_stacomi : ecrire periodeDC=get("periodeDC",envir_stacomi) "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('74','"DC" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('75','c("Fonc","Arr","Fonc normal")','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('76','c("Fonc","Arr")','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('77','"Fonctionnement DC" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('78','"Types d''arrets du DC" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('79','"Ecriture de" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('80','"peut prendre un peu de temps, soyez patient...."','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('81','"La requete est effectuee pour charger les pas de temps du DF "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('82','"Il n''y a pas de donnees sur ce DF "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('83','"Construction du graphe, patientez "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('84','"calcul..." ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('85','"progression %" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('86','c("duree","type_fonct.","fonctionnement")','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('87','"Fonctionnement DF"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('88','"ecriture de tableau dans l''environnement envir_stacomi : ecrire periodeDF=get("periodeDF",envir_stacomi) "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('89','"DF"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('90','"Types d''arrets du DF"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('91','"Attention le choix du pas de temps n''a pas ete effectue, calcul avec la valeur par defaut "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('92','"Debut du bilan migration... patientez "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('93','"L''objet Bilan est stocke dans l''environnement envir_stacomi, ecrire  ecrire bilanMigration=get("bilanMigration",envir_stacomi)"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('94','"Ecriture du tableau de bilan des migrations dans l''environnement envir_stacomi : ecrire tableau=get("tableau",envir_stacomi)"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('95','"Il faut faire tourner les calculs avant, cliquer sur calc "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('96','"Migration cumulee"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('97','"Effectif cumule, "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('98','"Attention cette fonction est pour les bilans annuels "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('99','"Statistiques concernant la migration : "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('100','"L''objet Bilan est stocke dans l''environnement envir_stacomi"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('101','"Il faut faire tourner les calculs avant, cliquer sur calc"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('102','"Vous n''avez pas de conditions environnementales sur la periode de temps"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('103','"pas station selectionnee => graphe simple"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('104','"le nombre de lignes du tableau des conditions environnentales ("','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('105','") ne correspond pas a la duree du bilan Migration ("','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('106','"Attention : sur une des stations :"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('107','"il y a plusieurs enregistrements pour la même journée : "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('108','"seule la première valeur sera intégrée dans le bilan "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('109','"Attention il n''existe pas de bilan migration pour l''annee "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('110','", ce taxon et ce stade (BilanMigrationInterAnnuelle.r)" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('111','"La requete est effectuee pour charger les migrations sur les annees"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('112','"Effectifs" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('113','"ATTENTION : Veuillez effectuer un Bilan Migration pour au moins une des annees selectionnees avant de lancer un bilan inter-annuel"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('114','"annee" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('115','"date" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('116','"Pourcentage de la migration annuelle" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('117','", EPACS"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('118','"Ecriture de l''objet graphique dans l''environnement envir_stacomi : ecrire g=get("gi",envir_stacomi) avec "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('119','"Debut du bilan migration avec parametres... patientez "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('120','"Il faut choisir au moins une caracteristique quantitative ou qualitative"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('121','"Attention, ce traitement ne s''effectue pas sur les quantites de lots "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('122','"Ecriture de data dans l''environnement envir_stacomi : ecrire data=get("data",envir_stacomi) "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('123','"Il faut faire tourner les calculs avant"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('124','"Ecriture de l''objet graphique dans l''environnement envir_stacomi : ecrire g=get("g",envir_stacomi) "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('125','"Ecriture de"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('126','"Il faut definir un vecteur baseODBC avec le lien ODBC, l''utilistateur et le mot de passe"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('127','"La librairie RODBC est necessaire, chargez le package ! "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('128','"Essai de connexion, attention cette classe ne doit être utilisée que pour les tests : "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('129','"Connexion impossible :"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('130','"Connexion établie"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('131','"Connexion en cours"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('132','"Choix des Pas de Temps"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('133','"Choix du nombre de pas de temps"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('134','"Erreur interne : le tableau des pas de temps ne contient aucune ligne"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('135','"Date de fin"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('136','"la duree du pas devrait etre journaliere"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('137','"le pas de temps ne doit pas etre a cheval sur plusieurs annnees"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('138','"Choix des Pas de Temps (duree 1 an)"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('139','"Date de debut"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('140','"Pas de temps"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('141','"Nb jour"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('142','"Date de fin"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('143','"Les pas de temps ont ete charges"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('144','"Choix de l''annee"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('145','"Annee selectionnee"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('146','"probleme lors du chargement des donnees ou pas de donnees dans la base (lien ODBC ?)"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('147','"Le DC a ete selectionne "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('148','"selection des taxons du DC (pour l''instant sur toutes les periodes) "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('149','"Donnees sur les Dispositifs de Comptage"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('150','"fermer" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('151','"Choix du Dispositif de Comptage"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('152','"Tableau"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('153','"Erreur : Aucun DC n''est rentre dans la base (aucune ligne de retour de la requete)"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('154','"Le DF a ete selectionne "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('155','"Donnees sur les Dispositifs de Franchissement"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('156','"Choix du Dispositif de Franchissement"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('157','"Aucun DF n''est rentre dans la base (aucune ligne de retour de la requete)"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('158','"La requete est effectuee pour charger les parametres "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('159','"Pas de donnees pour ce DC, ce taxon et ce stade "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('160','"La caracteristique a ete selectionnee "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('161','"erreur interne, aucune caracteristique n''a pu être chargée pour faire le choix "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('162','"Erreur interne : il devrait y avoir une ligne dans Refparqual@data, or nbligne="','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('163','0','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('164','0','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('165','0','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('166','"Pas de donnees pour ce DC, et ce taxon "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('167','"Le stade a ete selectionne "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('168','"Caracteristique qualitative" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('169','"Caracteristique quantitative" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('170','"Stop erreur interne : charger les donnees pour faire le choix "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('171','"Choix du Stade" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('172','"selectionnez au moins une valeur"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('173','"Les stations de mesure ont ete selectionnees "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('174','"Choix des stations de mesure" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('175','"Stop il n''y  a aucune donnee de station de mesure (pb lien ODBC ?) "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('176','"Le taxon a ete selectionne "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('177','"Choix du Taxon" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('178','"Stop il n''y  a aucune ligne dans la table des taxons (pb lien ODBC ?) "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('179','"Erreur ODBC =>Il faut definir un vecteur baseODBC avec le lien ODBC, l''utilistateur et le mot de passe "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('180','"Essai de connexion :"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('181','"Connexion impossible :"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('182','"Connexion reussie "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('183','"Essai de la requete "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('184','"Requete reussie "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('185','"Un Bilan a deja ete ecrit dans la base le :"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('186','"voulez vous le remplacer ?"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('187','"ecriture du bilan journalier dans la base"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('188','"progression %"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('189','"ecriture du bilan journalier dans la base"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('190','"ecriture du bilan mensuel dans la base"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('191','"graph civelle :" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('192','"Effectif de civelles (x1000)" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('193','"Effectif estimes,"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('194','c("eff. journ. poids","eff. journ. compt.")','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('195','"nombre d''operations="','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('196','"duree moyenne du piegeage="','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('197','"duree max="','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('198','"duree min="','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('199','c("Fonc","Arr","Fonc normal")','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('200','c("Fonc","Arr")','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('201','"DF"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('202','"DC"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('203','"OP"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('204','"Mois"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('205','"Effectif (x1000)"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('206','c("eff. mens. poids","eff. mens. compt.")','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('207','"Effectif"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('208','"Ecriture de l''objet graphique dans l''environnement envir_stacomi : ecrire g=get("g",envir_stacomi) "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('209','"ATTENTION, il y a des quantite de lots rentrees pour un taxon autre que civelles, verifier"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('210','"effectif"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('211','"Date"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('212','"Effectif estime, "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('213','c("Ponctuel","expert","calcule","mesure")','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('214','"somme effectifs ="','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('215','c("Effectifs","type","duree","mois","quinzaine","semaine","jour_365") ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('216','"calcul des bilans mensuels"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('217','','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('218','"ecriture de"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('219','"Conversion poids effectif "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('220','"Attention somme =0,vous n''avez pas encore rentre les coef de conversion"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('221','"chargement de la vue (vue_ope_lot) et choix du dc et des pas de temps"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('222','"BILAN LOTS" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('223','"horodate de debut"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('224','"horodate de fin"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('225','"La date de debut a ete choisie"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('226','"La date de fin a ete choisie"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('227','"Graphe interactif" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('228','"tableau" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('229','"Quitter" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('230','','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('231','','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('232','','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('233','','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('234','','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('235','','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('236','','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('237','"requete croisee taille/ caract qualitative"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('238','"Chargement des stations de mesure "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('239','"graphe bilan" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('240','"tables bilan en .csv"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('241','"Quitter"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('242','"Bilan des especes presentes sur le DC"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('243','"Bilan Especes" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('244','"Chargement"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('245','"Graphe PieChart"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('246','"Histogramme"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('247','"Tables bilan en .csv et XML"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('248','"Choix du decoupage" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('249','"Chargement des listes taxons et stades et dc"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('250','"Calcul des effectifs par pas de temps" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('251','"Graphe bilan"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('252','"Graphe cumul"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('253','"Tables bilan en .csv"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('254','"calcul des condition environnementales par pas de temps" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('255','"Chargement des listes taxons et stades et dc et stations de mesure "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('256','"Chargement des bilanJournaliers existants"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('257','"L''annee de debut a ete choisie"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('258','"Annee de debut"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('259','"L''annee de fin a ete choisie"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('260','"Annee de fin"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('261','"Migration de toutes les annees dans le meme graphique" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('262','"cumul migratoires en %" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('263','"Tableau" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('264','"Quitter" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('265','"jour"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('266','"Migration journalière"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('267','"sem"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('268','"Migration hebdomadaire"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('269','"quin"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('270','"Migration par quinzaine"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('271','"mois"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('272','"Migration mensuelle"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('273','"Chargement des listes taxons,stades,dc, parametres qualitatifs et quantitatifs  "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('274','"Choix du type de lot, inclusion des echantillons ?"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('275','"Calcul des effectifs par pas de temps"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('276','"graphe mensuel"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('277','"graphe journalier"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('278','"tables bilan en .csv"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('279','"quitter"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('280','"Chargement des listes dc et choix pas de temps"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('281','"Graphe mensuel"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('282','"Diagramme en boites"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('283','"tableau"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('284','"Quitte"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('285','"Calculs du fonctionnement du df"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('286','"Calculs du fonctionnement du dc"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('287','"Bilan des operations d''un dispositif ...a developper"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('288','"Bilan croises du fonctionnement du DF et du DC,a developper "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('289','"Bilan migration (pour une espèce et un stade)"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('290','"Bilan migration inter-annuel"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('291','"Bilan migration conditions environnementales"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('292','"Bilan migration avec parametres"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('293','"Bilan des conditions environnementales"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('294','"Bilan lots par appel de la vue vue lot ope"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('295','"Bilan tailles "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('296','paste("Bilan des poids moyens en vue du calcul des relations poids effectif."','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('297','"Calcul des stades pigmentaires "','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('298','paste("Pour de l''aide cedric Briand - 02 99 90 88 44 - cedric.briand@lavilaine.com"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('299','"Lancement de Rcmdr ( menu donnees, jeu de donnees actif, selectionner le jeu de donnees actif"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('300','"Traitement migrateur" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('301','"TODO à développer" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('302','"sorties du programme"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('303','"Bilan des espèces du DC"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('304','"Station"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('305','"DF"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('306','"DC"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('307','"Operation (TODO)"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('308','"DF sans DC (TODO)"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('309','"Bilan"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('310','"Migration"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('311','"Cond. Env."','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('312','"Migr.~Cond. Env."','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('313','"Migr./ parm. quant / parm. qual"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('314','"Migr. interannuel"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('315','"Parm. de lot"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('316','"Poids Moyen civelle"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('317','"Tailles"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('318','"Stades pigmentaires"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('319','"Migr. juvéniles (TODO)"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('320','"Migr. inter DC (TODO)"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('321','"parm qual (proportions) (TODO)"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('322','"Especes"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('323','"Aide"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('324','"Connexion"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('325','"Utilisateur"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('326','"Mot de passe"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('327','"Login"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('328','"Erreur"  title of the frame','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('329','"Probleme lors du test de la connexion ODBC" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('330','"Erreur dans l''utilisation de la methode connect de la classe ConnexionODBC" ','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('331','"Probleme lors du test, le lien ODBC fonctionne mais ne pointe pas vers la base version 0.3, verifiez le lien ODBC"','French');
insert into ref.ts_messagerlang_mrl(mrl_msr_id,mrl_text,mrl_lang) values ('332','"Lien ODBC"','French');



-- mise à jour de la table de maintenance
INSERT INTO iav.ts_maintenance_main( main_ticket,main_description) VALUES (72,'creation d''une tableref.ts_messager_msr  pour l''internationalisation');
INSERT INTO iav.ts_maintenance_main( main_ticket,main_description) VALUES (72,'creation d''une ref.ts_messagerlang_mrl  pour l''internationalisation');

comment:6 Changed 14 years ago by cedric

TODO développer un referentiel pour les messages...
Modifier interface_chooselang
Penser à ajouter lang dans le fichier xml
Voir ticket sur Rforge...

comment:7 Changed 13 years ago by cedric

  • Resolution set to fixed
  • Status changed from accepted to closed
Note: See TracTickets for help on using tickets.