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 the 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
  source correct_classif.sql;
cd ../../../../app/etc
./genMeta.pl

Delete cache in your browser if the aspect data appears strange in Document/New.