<!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"><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@font-face {
font-family: Verdana;
}
@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
}
P.MsoAcetate {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Tahoma","sans-serif"; FONT-SIZE: 8pt; mso-fareast-language: EN-US; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
LI.MsoAcetate {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Tahoma","sans-serif"; FONT-SIZE: 8pt; mso-fareast-language: EN-US; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
DIV.MsoAcetate {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Tahoma","sans-serif"; FONT-SIZE: 8pt; mso-fareast-language: EN-US; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
SPAN.EmailStyle17 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: windowtext; mso-style-type: personal
}
SPAN.BalloonTextChar {
FONT-FAMILY: "Tahoma","sans-serif"; mso-fareast-language: EN-US; mso-style-priority: 99; mso-style-link: "Balloon Text"; mso-style-name: "Balloon Text Char"
}
SPAN.EmailStyle20 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: #1f497d; mso-style-type: personal-reply
}
.MsoChpDefault {
FONT-SIZE: 10pt; 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=657300609-26082010><FONT color=#0000ff
size=2 face=Verdana>Ah, right. Sorry, my fault. I mixed it up with the BioCASe
provider Software, which constructs the statement. If something is
misconfigured, you can tell from the SQL query...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=657300609-26082010><FONT color=#0000ff
size=2 face=Verdana></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=657300609-26082010><FONT color=#0000ff
size=2 face=Verdana>No idea then :/</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=657300609-26082010><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> Jens Rathsman [mailto:Jens.Rathsman@nrm.se]
<BR><B>Gesendet:</B> Donnerstag, 26. August 2010 10:48<BR><B>An:</B> Holetschek,
Jörg<BR><B>Cc:</B> ipt@lists.gbif.org<BR><B>Betreff:</B> RE: Mapping/publishing
problem?<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=WordSection1>
<P class=MsoNormal><SPAN style="COLOR: #1f497d" lang=EN-US>Did you mean “show
full processlist” on the MySql-server?<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"
lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d" lang=EN-US>I tried that and the
only SQL statement I could catch was the query entered in the
DataSource-settings in IPT:<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"
lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d" lang=EN-US>select * from
dwctable<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"
lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d" lang=EN-US>The query can be run
manually.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"
lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"
lang=EN-US>/Jens<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"
lang=EN-US><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"
lang=EN-US><o:p> </o:p></SPAN></P>
<DIV>
<DIV
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt; mso-fareast-language: SV"
lang=EN-US>From:</SPAN></B><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt; mso-fareast-language: SV"
lang=EN-US> ipt-bounces@lists.gbif.org [mailto:ipt-bounces@lists.gbif.org] <B>On
Behalf Of </B>"Holetschek, Jörg"<BR><B>Sent:</B> den 25 augusti 2010
15:50<BR><B>To:</B> Jens Rathsman<BR><B>Cc:</B>
ipt@lists.gbif.org<BR><B>Subject:</B> Re: [IPT] Mapping/publishing
problem?<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: blue; FONT-SIZE: 10pt; mso-fareast-language: SV">Jens,</SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt; mso-fareast-language: SV"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt; mso-fareast-language: SV"> <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: blue; FONT-SIZE: 10pt; mso-fareast-language: SV">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...</SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt; mso-fareast-language: SV"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt; mso-fareast-language: SV"> <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: blue; FONT-SIZE: 10pt; mso-fareast-language: SV">Jörg</SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt; mso-fareast-language: SV"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt; mso-fareast-language: SV"><o:p> </o:p></SPAN></P>
<DIV style="TEXT-ALIGN: center" class=MsoNormal align=center><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt; mso-fareast-language: SV"
lang=DE>
<HR align=center SIZE=2 width="100%">
</SPAN></DIV>
<P style="MARGIN-BOTTOM: 12pt" class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt; mso-fareast-language: SV"
lang=DE>Von:</SPAN></B><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt; mso-fareast-language: SV"
lang=DE> 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?</SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt; mso-fareast-language: SV"
lang=DE><o:p></o:p></SPAN></P>
<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: <A
href="http://gbif.se:8080/ipt/occDetail.html?guid=e4ec28b2-128a-49ee-b299-00ced417edf5&resourceId=79">http://gbif.se:8080/ipt/occDetail.html?guid=e4ec28b2-128a-49ee-b299-00ced417edf5&resourceId=79</A>)
<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 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">mailto:jens.rathsman@nrm.se</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
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>