MET Configuration

Contents

MET Configuration
Updating Aspect Data

Updating Aspect Data

Use a tab separated file for the classification aspects and values as described in header of app/etc/genAspectData.pl. See
```
cfg/met/site/data/1-0-000-EH-METS-0018_Management_Aspects-Rev-C.xls - last sheet
cfg/met/site/data/1-0-000-EH-METS-0018_Management_Aspects-Rev-C.csv
```
It is VERY IMPORTANT, that the code values for existing aspect values remain unchanged, otherwise then classification information will be destroyed with this procedure.

Create the SQL file which creates the data

cd cfg/met/site/data
../../../../app/etc/genAspectData.pl 1-0-000-EH-METS-0018_Management_Aspects-Rev-C.csv > genAspectData.sql
mysql -uroot -psqladmin met120prod
  set names utf8;
  truncate table AspectRef;
  truncate table AspectValues;
  source genAspectData.sql;
  -- Set the AspectRef colors
  update AspectRef set displayColor='#6d7b8d' where aspectId=1;  -- code=00, Black  #000000
  update AspectRef set displayColor='#ccffcc' where aspectId=2;  -- code=01, Green  #00ff00
  update AspectRef set displayColor='#50ebec' where aspectId=3;  -- code=02, Blue   #00ffff
  update AspectRef set displayColor='#f778a1' where aspectId=4;  -- code=03, Red    #ff0000
  update AspectRef set displayColor='#f9966b' where aspectId=5;  -- code=04, Orange #ff9900
  update AspectRef set displayColor='#e6a9ec' where aspectId=6;  -- code=05, Purple #cc99ff
  update AspectRef set displayColor='#ffffaa' where aspectId=7;  -- code=06, Yellow #ffff00
  update AspectRef set displayColor='#c0c0c0' where aspectId=8;  -- code=07, Gray   #c0c0c0
  update AspectRef set displayColor='#f4f4f4' where aspectId=9;  -- code=08, White  #ffffff
  update AspectRef set displayColor='#ffddbb' where aspectId=10; -- code=09, Beige  #ffcc99
  -- Refresh Classification fields

cd ../../../../app/etc
./genMeta