<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16625">
<STYLE>@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@page WordSection1 {size: 612.0pt 792.0pt; margin: 70.85pt 70.85pt 70.85pt 70.85pt; }
P.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt; mso-fareast-language: EN-US
}
LI.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt; mso-fareast-language: EN-US
}
DIV.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt; mso-fareast-language: EN-US
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.EmailStyle17 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: windowtext; mso-style-type: personal-compose
}
.MsoChpDefault {
FONT-FAMILY: "Calibri","sans-serif"; mso-fareast-language: EN-US; mso-style-type: export-only
}
DIV.WordSection1 {
page: WordSection1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=SV link=blue vLink=purple>
<DIV dir=ltr align=left><SPAN class=081404513-25082010><FONT color=#0000ff
size=2 face=Verdana>Jens,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=081404513-25082010><FONT color=#0000ff
size=2 face=Verdana></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=081404513-25082010><FONT color=#0000ff
size=2 face=Verdana>have you tried to run the SQL statements issued by the
IPT manually? Could could use "show full processlist" during the indexing
process to catch one of them...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=081404513-25082010><FONT color=#0000ff
size=2 face=Verdana></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=081404513-25082010><FONT color=#0000ff
size=2 face=Verdana>Jörg</FONT></SPAN></DIV><BR>
<DIV dir=ltr lang=de class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>Von:</B> ipt-bounces@lists.gbif.org
[mailto:ipt-bounces@lists.gbif.org] <B>Im Auftrag von </B>Jens
Rathsman<BR><B>Gesendet:</B> Mittwoch, 25. August 2010 14:09<BR><B>An:</B>
ipt@lists.gbif.org<BR><B>Betreff:</B> [IPT] Mapping/publishing
problem?<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=WordSection1>
<P class=MsoNormal><SPAN lang=EN-US>Dear GBIF helpdesk,<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>I am publishing some datasets on an IPT
server (1.0-RC3-SNAPSHOT) for the Swedish GBIF node. There are some problems
with the mapping or publishing the following fields:<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>VerbatimCollectingDate ---
<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>EarliestDateCollected ---
<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>StartTimeOfDay --- <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>YearSampled --- <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>MonthOfYear --- <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>DayOfMonth --- <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>Collector ---<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>For example catalogNumber 38922 ( puiblished
at:
http://gbif.se:8080/ipt/occDetail.html?guid=e4ec28b2-128a-49ee-b299-00ced417edf5&resourceId=79)
<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>has values for all of the above fields in
the datasource (a MySql database) but none of them are presenteded by IPT. When
I click “Annotations” for the <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>resource there are no problems shown, and I
get no clues from the tomcat log file (catalina.out).<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>This is the data from the data source:
<o:p></o:p></SPAN></P>
<TABLE style="MARGIN-LEFT: -2.25pt" class=MsoNormalTable border=0
cellPadding=0><TBODY>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B>catalogNumber<o:p></o:p></B></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B>collector<o:p></o:p></B></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B>earliestDateCollected<o:p></o:p></B></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B>verbatimCollectingDate<o:p></o:p></B></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B>startDayOfYear<o:p></o:p></B></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B>endDayOfYear<o:p></o:p></B></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B>eventTime<o:p></o:p></B></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B>yearSampled<o:p></o:p></B></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B>monthOfYear<o:p></o:p></B></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B>dayOfYear<o:p></o:p></B></P></TD></TR>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal>38922<o:p></o:p></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal>Åhlander, E et al.<o:p></o:p></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal>1990-04-04<o:p></o:p></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal>4 and 12 Apr 1990<o:p></o:p></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal>94<o:p></o:p></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal>102<o:p></o:p></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal>10:00:00<o:p></o:p></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal>1990<o:p></o:p></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal>4<o:p></o:p></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal>4<o:p></o:p></P></TD></TR></TBODY></TABLE>
<P class=MsoNormal><SPAN lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>What could be causing this
problem?<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>Best regards,<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
lang=EN-US>---------------------------------<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>Jens Rathsman, System
developper<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>GBIF Sweden - </SPAN><A
href="http://www.gbif.se/"><SPAN style="COLOR: blue"
lang=EN-US>http://www.gbif.se</SPAN></A><SPAN lang=EN-US><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US><A href="mailto:jens.rathsman@nrm.se"><SPAN
style="COLOR: blue">mailto:jens.rathsman@nrm.se</SPAN></A><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>tel: +46 8 5195 5116<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>Swedish Museum of Natural History -
</SPAN><A href="http://www.nrm.se/"><SPAN style="COLOR: blue"
lang=EN-US>http://www.nrm.se</SPAN></A><SPAN lang=EN-US> Box
50007<o:p></o:p></SPAN></P>
<P class=MsoNormal>SE-104 05 Stockholm<o:p></o:p></P>
<P class=MsoNormal>Sweden<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P></DIV></BODY></HTML>