<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none"><!-- p { margin-top: 0px; margin-bottom: 0px; }--></style>
</head>
<body dir="ltr" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Helvetica,Sans-Serif;">
<p></p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div class="" style="background-color: rgb(255, 255, 255); color: rgb(46, 52, 54); font-family: monospace; font-size: 14.6667px; width: 71ch;">
Dear pycsw developers,</div>
<div class="" style="background-color: rgb(255, 255, 255); color: rgb(46, 52, 54); font-family: monospace; font-size: 14.6667px; width: 71ch;">
<br>
</div>
<div class="" style="background-color: rgb(255, 255, 255); color: rgb(46, 52, 54); font-family: monospace; font-size: 14.6667px; width: 71ch;">
I am currently setting up a pycsw server for the Earth Observation Data Centre (<a href="https://pycsw.eodc.eu/" target="_blank" style="color: rgb(42, 118, 198);">https://pycsw.eodc.eu/</a>), where we mainly host Copernicus Sentinel data.</div>
<div class="" style="background-color: rgb(255, 255, 255); color: rgb(46, 52, 54); font-family: monospace; font-size: 14.6667px; width: 71ch;">
<br>
</div>
<div class="" style="background-color: rgb(255, 255, 255); color: rgb(46, 52, 54); font-family: monospace; font-size: 14.6667px; width: 71ch;">
So far, I managed to set up the server using the default metadata profiles, however, in the next step, we need to add additional metadata elements (e.g. cloud-coverage), that are not covered by both the standard profiles and the database table columns.</div>
<div class="" style="background-color: rgb(255, 255, 255); color: rgb(46, 52, 54); font-family: monospace; font-size: 14.6667px; width: 71ch;">
<br>
</div>
<div class="" style="background-color: rgb(255, 255, 255); color: rgb(46, 52, 54); font-family: monospace; font-size: 14.6667px; width: 71ch;">
I understand that I have to create a custom profile, however I don't really know what is the best way to extend the database table. I see that it is possible pass 'extra_columns' in setup_db, however, this argument is not used in the admin.setup_db in pycsw-admin.py.
If I run setup_py in admin.py "manually", I lose the comfort of the config file. I know that this is no big deal, however, I would find it very convenient if it would be possible to set 'extra_columns' int the repository section of the config file, so that
these columns are automatically created when pycsw-admin -c setup_db is executed.<br>
</div>
<div class="" style="background-color: rgb(255, 255, 255); color: rgb(46, 52, 54); font-family: monospace; font-size: 14.6667px; width: 71ch;">
<br>
</div>
<div class="" style="background-color: rgb(255, 255, 255); color: rgb(46, 52, 54); font-family: monospace; font-size: 14.6667px; width: 71ch;">
Is there any reason why this is not the case already, or am I missing something completely, and there is a better way to implement additional columns? If not, then I would be happy to work on that :-)<br>
</div>
<div class="" style="background-color: rgb(255, 255, 255); color: rgb(46, 52, 54); font-family: monospace; font-size: 14.6667px; width: 71ch;">
<br>
</div>
<div class="" style="background-color: rgb(255, 255, 255); color: rgb(46, 52, 54); font-family: monospace; font-size: 14.6667px; width: 71ch;">
Thank you for your help and time! :-)<br>
</div>
<div class="" style="background-color: rgb(255, 255, 255); color: rgb(46, 52, 54); font-family: monospace; font-size: 14.6667px; width: 71ch;">
<br>
</div>
<div class="" style="background-color: rgb(255, 255, 255); color: rgb(46, 52, 54); font-family: monospace; font-size: 14.6667px; width: 71ch;">
Best regards,</div>
<div class="" style="background-color: rgb(255, 255, 255); color: rgb(46, 52, 54); font-family: monospace; font-size: 14.6667px; width: 71ch;">
Thomas<br>
</div>
<font color="808080" face="Gautami,Sans-Serif" size="2"><br>
</font></div>
<font color="808080"></font></div>
</div>
</body>
</html>