<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-7">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hello</p>
<p>I feed our euro-ix export
(<a class="moz-txt-link-freetext" href="https://portal.gr-ix.gr/api/v4/member-export/ixf/0.7">https://portal.gr-ix.gr/api/v4/member-export/ixf/0.7</a>) to IXPDB
and I get the following errors:</p>
<p><dt style="box-sizing: border-box; line-height: 1.42857;
font-weight: 700; float: left; width: 160px; overflow: hidden;
clear: left; text-align: right; text-overflow: ellipsis;
white-space: nowrap; color: rgb(102, 102, 102); font-family:
"Open Sans", sans-serif; font-size: 14px; font-style:
normal; font-variant-ligatures: normal; font-variant-caps:
normal; letter-spacing: normal; orphans: 2; text-indent: 0px;
text-transform: none; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255); text-decoration-style: initial; text-decoration-color:
initial;">Type</dt>
<dd style="box-sizing: border-box; line-height: 1.42857;
margin-left: 180px; color: rgb(102, 102, 102); font-family:
"Open Sans", sans-serif; font-size: 14px; font-style:
normal; font-variant-ligatures: normal; font-variant-caps:
normal; font-weight: 400; letter-spacing: normal; orphans: 2;
text-align: start; text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255); text-decoration-style: initial; text-decoration-color:
initial;">Member Export</dd>
<dt style="box-sizing: border-box; line-height: 1.42857;
font-weight: 700; float: left; width: 160px; overflow: hidden;
clear: left; text-align: right; text-overflow: ellipsis;
white-space: nowrap; color: rgb(102, 102, 102); font-family:
"Open Sans", sans-serif; font-size: 14px; font-style:
normal; font-variant-ligatures: normal; font-variant-caps:
normal; letter-spacing: normal; orphans: 2; text-indent: 0px;
text-transform: none; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255); text-decoration-style: initial; text-decoration-color:
initial;">URL</dt>
<dd style="box-sizing: border-box; line-height: 1.42857;
margin-left: 180px; color: rgb(102, 102, 102); font-family:
"Open Sans", sans-serif; font-size: 14px; font-style:
normal; font-variant-ligatures: normal; font-variant-caps:
normal; font-weight: 400; letter-spacing: normal; orphans: 2;
text-align: start; text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255); text-decoration-style: initial; text-decoration-color:
initial;"><a
href="https://portal.gr-ix.gr/api/v4/member-export/ixf/0.7"
style="box-sizing: border-box; background-color: transparent;
color: rgb(51, 51, 51); text-decoration: none; transition: all
200ms ease-in 0s;">https://portal.gr-ix.gr/api/v4/member-export/ixf/0.7</a></dd>
<dt style="box-sizing: border-box; line-height: 1.42857;
font-weight: 700; float: left; width: 160px; overflow: hidden;
clear: left; text-align: right; text-overflow: ellipsis;
white-space: nowrap; color: rgb(102, 102, 102); font-family:
"Open Sans", sans-serif; font-size: 14px; font-style:
normal; font-variant-ligatures: normal; font-variant-caps:
normal; letter-spacing: normal; orphans: 2; text-indent: 0px;
text-transform: none; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255); text-decoration-style: initial; text-decoration-color:
initial;">Is imported</dt>
<dd style="box-sizing: border-box; line-height: 1.42857;
margin-left: 180px; color: rgb(102, 102, 102); font-family:
"Open Sans", sans-serif; font-size: 14px; font-style:
normal; font-variant-ligatures: normal; font-variant-caps:
normal; font-weight: 400; letter-spacing: normal; orphans: 2;
text-align: start; text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255); text-decoration-style: initial; text-decoration-color:
initial;"><span class="glyphicon glyphicon-ok"
style="box-sizing: border-box; position: relative; top: 1px;
display: inline-block; font-family: "Glyphicons
Halflings"; font-style: normal; font-weight: 400;
line-height: 1; -webkit-font-smoothing: antialiased;"></span><br>
</dd>
<dt style="box-sizing: border-box; line-height: 1.42857;
font-weight: 700; float: left; width: 160px; overflow: hidden;
clear: left; text-align: right; text-overflow: ellipsis;
white-space: nowrap; color: rgb(102, 102, 102); font-family:
"Open Sans", sans-serif; font-size: 14px; font-style:
normal; font-variant-ligatures: normal; font-variant-caps:
normal; letter-spacing: normal; orphans: 2; text-indent: 0px;
text-transform: none; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255); text-decoration-style: initial; text-decoration-color:
initial;">Status</dt>
<dd style="box-sizing: border-box; line-height: 1.42857;
margin-left: 180px; color: rgb(102, 102, 102); font-family:
"Open Sans", sans-serif; font-size: 14px; font-style:
normal; font-variant-ligatures: normal; font-variant-caps:
normal; font-weight: 400; letter-spacing: normal; orphans: 2;
text-align: start; text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255); text-decoration-style: initial; text-decoration-color:
initial;"><span class="glyphicon glyphicon-remove"
style="box-sizing: border-box; position: relative; top: 1px;
display: inline-block; font-family: "Glyphicons
Halflings"; font-style: normal; font-weight: 400;
line-height: 1; -webkit-font-smoothing: antialiased;"></span><span> </span><br
style="box-sizing: border-box;">
6 errors occurred:<br style="box-sizing: border-box;">
<br style="box-sizing: border-box;">
* country code is invalid: 'Greece'<br style="box-sizing:
border-box;">
* country code is invalid: 'Greece'<br style="box-sizing:
border-box;">
* country code is invalid: 'Greece'<br style="box-sizing:
border-box;">
* country code is invalid: 'Greece'<br style="box-sizing:
border-box;">
* country code is invalid: 'Greece'<br style="box-sizing:
border-box;">
* country code is invalid: 'Greece'</dd>
<dt style="box-sizing: border-box; line-height: 1.42857;
font-weight: 700; float: left; width: 160px; overflow: hidden;
clear: left; text-align: right; text-overflow: ellipsis;
white-space: nowrap; color: rgb(102, 102, 102); font-family:
"Open Sans", sans-serif; font-size: 14px; font-style:
normal; font-variant-ligatures: normal; font-variant-caps:
normal; letter-spacing: normal; orphans: 2; text-indent: 0px;
text-transform: none; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255); text-decoration-style: initial; text-decoration-color:
initial;">Last process</dt>
<dd style="box-sizing: border-box; line-height: 1.42857;
margin-left: 180px; color: rgb(102, 102, 102); font-family:
"Open Sans", sans-serif; font-size: 14px; font-style:
normal; font-variant-ligatures: normal; font-variant-caps:
normal; font-weight: 400; letter-spacing: normal; orphans: 2;
text-align: start; text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255); text-decoration-style: initial; text-decoration-color:
initial;">Nov. 13, 2018, 9:01 a.m.</dd>
</p>
<p>IXPDB waits for country code, while our export contains the
country name.</p>
<p>Indeed,<br>
</p>
<pre class="data">{
...
"ixp_list": [
{
"shortname": "GR-IX::Athens",
"name": "Greek Internet Exchange",
"country": "Greece",
...
"switch": [
{
...
"name": "eie-sw.gr-ix.gr",
...
"city": "Athens",
"country": "Greece",
...
</pre>
<p><br>
</p>
<p>However, I cannot find the place where "Greece" is set as a
country, neither for the IXP nor for the switch.<br>
For the IXP, I checked the ixp table and it is set correct to
"GR". <br>
</p>
<p>mysql> select * from ixp;<br>
+----+-------------------------+-----------+------------+----------+----------+----------+---------+<br>
| id | name | shortname | address1 | address2
| address3 | address4 | country |<br>
+----+-------------------------+-----------+------------+----------+----------+----------+---------+<br>
| 1 | Greek Internet Exchange | GRIX | Kifisias 7 | NULL
| Athens | 11523 | GR |<br>
+----+-------------------------+-----------+------------+----------+----------+----------+---------+<br>
</p>
<p>I cannot locate any country-related setting for the switch or for
the corresponding facility.</p>
<p>Where is this information stored?</p>
<p>I see that there is the file /library/OSS/Countries.php, is there
a chance that you automatically replace "GR" with "Greece" while
exporting? <br>
</p>
<p>Thank you in advance,</p>
<p>Andreas<br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<pre class="moz-signature" cols="72">--
Andreas Polyrakis
GR-IX Manager // GRNET NOC Technical Manager
GRNET - Networking Research and Education
7, Kifisias Av., 115 23, Athens
t: +30 210 7474249 | c: +30 697 2832 445 | f: +30 210 7474490
Follow us: <a class="moz-txt-link-abbreviated" href="http://www.grnet.gr">www.grnet.gr</a>
Twitter: @grnet_gr | Facebook: @grnet.gr
LinkedIn: grnet | YouTube: GRNET EDET
</pre>
</body>
</html>