<div dir="ltr"><div><div><div><div>Hi again,<br><br></div>I think the problem target both. DwC because is a solution to a problem creating another problem to researchers less "skilled" in table manipulation. Ecological data with occurrence is resulting in three tables and manipulation of these are getting harder with the number of core or extensions used.<br></div>Two possible solutions comes in mind: create a new term describing the original layout of the columns (so we can use csvjoin like Menashe suggest) or ipt with option to store the original table associated with resource.<br></div>We can always use external links in eml and save the file somewhere but this means creating another service and managing more login (aka resource cost and new problems).<br><br></div>I think any solution will need ipt changes.<br></div><div class="gmail_extra"><br><div class="gmail_quote">2015-10-27 9:08 GMT-02:00 Menashe' Eliezer <span dir="ltr"><<a href="mailto:menashe.eliezer@gmail.com" target="_blank">menashe.eliezer@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Tim,<div>I believe that the IPT feature I've requested long ago could be helpful for David: <a href="https://github.com/gbif/ipt/issues/1165" target="_blank">https://github.com/gbif/ipt/issues/1165</a></div><div>Consumers and also the data providers don't have a DwC-A viewer, and they need to join the separate csv files for having one table in a worksheet.</div><div>Web applications like the one at OBIS website do let end users download one big table.</div><div class="gmail_extra"><br></div><div class="gmail_extra">Best regards,<br clear="all"><div><div><div dir="ltr">Menashè<br><div><br></div></div></div></div>
<br><div class="gmail_quote"><div><div class="h5">2015-10-27 9:53 GMT+01:00 Tim Robertson <span dir="ltr"><<a href="mailto:trobertson@gbif.org" target="_blank">trobertson@gbif.org</a>></span>:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div style="word-wrap:break-word"><div>Hi David</div><div>(CC’ing the IPT list as this might be an IPT specific thread - <a href="http://lists.gbif.org/mailman/listinfo/ipt" target="_blank">http://lists.gbif.org/mailman/listinfo/ipt</a>)</div><div><br></div><div>For clarification - is your question specific to the DwC-A standard which is possible as Alex says or is it specific to the IPT tool please?</div><div><br></div><div>Do you imagine a scenario where you’d effectively map the same extension 2 times - once to interpreted and once to verbatim - or do you envisage a different data schema for each?</div><div><br></div><div>Thanks,</div><div>Tim</div><div><br><div><br></div><div><br><div><blockquote type="cite"><div>On 23 Oct 2015, at 16:00, Alex Thompson <<a href="mailto:godfoder@acis.ufl.edu" target="_blank">godfoder@acis.ufl.edu</a>> wrote:</div><br><div>
<div bgcolor="#FFFFFF" text="#000000">
David,<br>
<br>
It's certainly possible, within the context of a Darwin Core
Archive, to include other files within the ZIP file that lie outside
the schema of the archive. Both GBIF and iDigBio do this when
generating downloads for various reasons (RIGHTS & LICENSE
files, additional EML metadata, etc). However, I do not believe it
is possible to do this within IPT. You might submit an issue on the
IPT issue tracker (<a href="https://github.com/gbif/ipt/issues" target="_blank">https://github.com/gbif/ipt/issues</a>) for potential
inclusion of this feature in a future version of IPT.<br>
<br>
There are workarounds you can use to include additional data in
Darwin Core archives, but none of them will exactly match your old
format. For instance, including an additional Occurrence file with
the values as JSON in dynamicProperties or in some other verbatim
format in the occurrenceRemarks field. Both of those would at least
give some method of single-row access (vs joining multiple
measurementOrFacts to a single event id) if that is the primary
concern, even if they would require additional parsing steps to be
useful.<br>
<br>
Alex Thompson<br>
iDigBio Infrastructure<div><div><br>
<br>
<div>On 10/23/2015 09:40 AM, David Valentim
Dias wrote:<br>
</div>
</div></div><blockquote type="cite"><div><div>
<div dir="ltr">
<div>
<div>
<div>Dear colleagues,<br>
<br>
</div>
Here on SiBBr we're using the new eventCore and
measurementOrFacts and after the process of standardization
to DwC and publishing we think some users/researchers will
want the "original" table format because of multiple
reasons.<br>
<br>
</div>
Is possible to have a vertabimTable or some place where we can
store the original table/column format?<br>
<br>
</div>
Regards<br clear="all">
<div>
<div>
<div>
<div>
<div><br>
-- <br>
<div>
<div dir="ltr">
<div><div> <br></div><div><span style="font-size:10.0pt"> </span><br></div>
<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="width:133.0pt;border:none;border-right:solid #4f6228 1.5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="177"><p><span style="font-size:10pt"><img src="http://www.sibbr.gov.br/images/sig-sibbr.png" alt="ass_sibbr" height="109" width="176"></span><span style="font-size:10pt">
</span></p>
</td>
<td style="width:299.2pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="399"><p><b><span style="font-size:10.0pt;color:#365f91">David
Valentim Dias</span></b></p><p><b><span style="font-size:10.0pt;color:#365f91">Biodiversity
Data Management</span></b></p><p><span style="font-size:10.0pt;color:#365f91">SiBBr
| MCTI | PNUMA (UNEP) </span></p><p><span style="font-size:10.0pt;color:#365f91">Phone:
<a href="tel:%2B55%2061%203329%206045" value="+556133296045" target="_blank">+55 61 3329 6045</a><br>
Phone: <a href="tel:%2B55%2061%209359%206151" value="+556193596151" target="_blank">+55 61 9359 6151</a><br>
Skype: ctenidae</span></p><p><span style="font-size:10.0pt;color:#365f91"><a href="mailto:dvdias@sibbr.gov.br" target="_blank">dvdias@sibbr.gov.br</a>
</span></p><p><span style="font-size:10.0pt;color:#365f91"><a href="http://www.sibbr.gov.br/" target="_blank"><span style="color:#365f91">www.sibbr.gov.br</span></a></span><span style="font-size:10.0pt;color:#1f497d"> </span></p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_______________________________________________
tdwg-content mailing list
<a href="mailto:tdwg-content@lists.tdwg.org" target="_blank">tdwg-content@lists.tdwg.org</a>
<a href="http://lists.tdwg.org/mailman/listinfo/tdwg-content" target="_blank">http://lists.tdwg.org/mailman/listinfo/tdwg-content</a>
</pre>
</blockquote>
<br>
</div>
_______________________________________________<br>tdwg-content mailing list<br><a href="mailto:tdwg-content@lists.tdwg.org" target="_blank">tdwg-content@lists.tdwg.org</a><br><a href="http://lists.tdwg.org/mailman/listinfo/tdwg-content" target="_blank">http://lists.tdwg.org/mailman/listinfo/tdwg-content</a><br></div></blockquote></div><br></div></div></div><br></div></div>_______________________________________________<br>
IPT mailing list<br>
<a href="mailto:IPT@lists.gbif.org" target="_blank">IPT@lists.gbif.org</a><br>
<a href="http://lists.gbif.org/mailman/listinfo/ipt" rel="noreferrer" target="_blank">http://lists.gbif.org/mailman/listinfo/ipt</a><br>
<br></blockquote></div><br></div></div>
<br>_______________________________________________<br>
IPT mailing list<br>
<a href="mailto:IPT@lists.gbif.org">IPT@lists.gbif.org</a><br>
<a href="http://lists.gbif.org/mailman/listinfo/ipt" rel="noreferrer" target="_blank">http://lists.gbif.org/mailman/listinfo/ipt</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature"><div dir="ltr">
<div>
<p>
</p>
<p><span style="font-size:10.0pt">
</span></p>
<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
<td style="width:133.0pt;border:none;border-right:solid #4f6228 1.5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="177"><p><span style="font-size:10.0pt;color:black"><img src="http://www.sibbr.gov.br/images/sig-sibbr.png" alt="ass_sibbr" height="109" width="176"></span><span style="font-size:10.0pt;color:black">
</span></p></td>
<td style="width:299.2pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="399"><p><b><span style="font-size:10.0pt;color:#365f91">David Valentim Dias</span></b></p>
<p><b><span style="font-size:10.0pt;color:#365f91">Biodiversity Data Management</span></b></p>
<p><span style="font-size:10.0pt;color:#365f91">SiBBr | MCTI
| PNUMA (UNEP)
</span></p>
<p><span style="font-size:10.0pt;color:#365f91">Phone: +55 61
3329 6045<br>
Phone: +55 61 9359 6151<br>
Skype: ctenidae</span></p>
<p><span style="font-size:10.0pt;color:#365f91"><a href="mailto:dvdias@sibbr.gov.br" target="_blank">dvdias@sibbr.gov.br</a>
</span></p>
<p><span style="font-size:10.0pt;color:#365f91"><a href="http://www.sibbr.gov.br/" target="_blank"><span style="color:#365f91">www.sibbr.gov.br</span></a></span><span style="font-size:10.0pt;color:#1f497d">
</span></p></td>
</tr>
</tbody></table>
</div>
</div></div>
</div>