= Metro Ligne B Rennes Configuration =

<<TableOfContents>>

= Project Overview =

The project is to build a new metro line in the city of Rennes in Normandy, France. The DrawMGT
system will be used for managing '''bid documentation''' for the bid to be presented by a
consortium which includes Coyne et Bellier, one of the largest French construction consultants.

The project is scheduled from 2010 to 2018.

The estimated cost us approximately 620 million Euro.

The project is to build a new subway line:

 * 11 stations
 * 8.5 km of tunnel
 * 4 km of above ground track
 * 1 depot

= Contact Information =

== Contact Addresses ==

=== Office Address ===

  * TRACTEBEL ENGINEERING FRANCE (COYNE ET BELLIER)
  * 9, allée des Barbanniers 
  * 92 632 Gennevilliers CEDEX
  * France

== Contract Names ==

 ||<rowbgcolor="#cddeee"> '''Name''' || '''Description''' || '''Email''' || '''Phone''' ||
 || '''Andrew Bourget'''  || Main contact for system configuration || andrew.bourget@coyne-et-bellier.fr || Tel : +33 (0)1 41 85 02 90 ||

= Discussions and Input Data =

== Phone call AH/AB 2009-11-25 ==

 1. Agreement to setup pilot system ''almost'' ready. Definite decision expected Thu, 2009-11-26.
 1. Delivery of bid documentation to Coyne et Bellier delayed, now expected to arrive end of first week of December.
 1. Agreed that we send a generic configuration spreadsheet to Andrew ASAP.
 1. Andrew is willing to translate our message catalogs into French.

== Email from AB on 2009-11-26 ==

 1. Sent an updated copy of the Messages.txt file in Excel format. This include addition of many new French
    texts, and should be merged with the existing Messages.txt in the V11.3 branch.
    * [[attachment:Messages-1-84-2-17-abt.xls]]
    * See: [[MigrationTools#DrawMGTDataMigrationandConfigurationTools|Migration Tools]]

= Project to DrawMGT Configuration Mapping =

 1. None defined so far.
 1. Andrew will probably not need a very complex classification system, for he bid project phase.
 1. The classification system may be expanded later base don their needs.

= MRE Document Coding System =

 1. Initially we will use '''GENERIC''' (drawingCodeId=10) drawing codes for all documents.
   * The revision numbering is 1, 2, ...
   * Currently the revision file naming is coded to '''code''' (name) and '''system''' (file)
   * May need to create a clone of the GENERIC with '''free''' (name) and '''system''' (file)

= System Deployment =

== Server ==

 1. System URL: [[http://mre.softxs.ch|mre.softxs.ch]]
 1. Site '''mre'''
 1. Instances:
    * '''lu.softxs.ch-prod'''
    * '''lu.softxs.ch-test'''
 1. Deployed on honir.softxs.ch
   * Virtual hosting used to map lu.softxs.ch --> mre.softxs.ch
 1. A test and production system will be deployed.

== Software Installation ==

 1. Install test and production systems.

 1. CVS checkout. Use '''app/etc/checkout.sh''' (from V11.3 CVS). As user root on lu.softxs.ch:

   {{{
     cd /home/met/www/html/test/app/etc
     ./checkout.sh -r 113 -v -q -u mre -d /home/mre/www/html -s test mre lu.softxs.ch-test
     cd /home/mre/www/html/test
     chown -R mre:mre *
     cd app/install
     ./setup.sh mre lu.softxs.ch-test www mre
     su - mre
     cd www/html/test/app/etc
     ** LOAD A DATABASE *** '''to do'''
     ./genMeta.pl http://mre.softxs.ch/test/lib/meta 
   }}}

 1. Database (initial setup for testing):

    {{{
      cd /home/mre/www/html/test/app/schema
      mysql -uroot -psqladmin 
        create database mre113test;
        use mre113test;
        source drawmgt-schema.sql;
        source id-table-schema.sql;
        source data/refdata.sql
        source ../../cfg/mre/site/data/Users.sql; '''to do'''
        source ../../cfg/mre/site/data/UserRoles.sql; '''to do'''
        source id-table-setup.sql;
        quit;
     }}}