October 2013 - IPT - lists.gbif.org

use of extensions; how can duplication of rows be avoided?
by "Dröge, Gabriele" 02 Jan '14

02 Jan '14

Dear all, I have a general question on Darwin Core and the use of Darwin Core extensions. E.g. I want to use the Occurrence Core and Simple Images with a mysql database. Problem: Only a few of my occurrences have images. The Darwin Core Archive creates a large images file with all occurrence IDs and only a few have also Image urls. But I did expect a file with the image urls only (so much shorter) and all occurrences (with or without image) in the occurrences file. The same problem appears for the identification extension the other way round (duplication of occurrence rows for multiple identifications) and every other extension I've tested... But I am a bit confused how this can be done with only one big sql query (with some left joins). Do I have to use multiple resources to use multiple sql queries? Or is this a problem/bug of IPT? Best, Gabi

4 7

Conflict "Darwin Core Sample Extension" and "Darwin Core Sample Core"
by "Dröge, Gabriele" 23 Oct '13

23 Oct '13

Dear all, I have another question concerning IPT and the Darwin Core extensions. For my test mapping I am using the Occurrences Core. Using the "Darwin Core Sample Extension" works in principal but unfortunately it is changed to "Darwin Core Sample Core" today (and can therefore not be used). Due to the similar name there seems to be a technical conflict. Could you please check this? Best, Gabi

3 5

IPT bug -> MySQL
by "Dröge, Gabriele" 17 Oct '13

17 Oct '13

Dear all, I've downloaded the latest IPT version 2.0.5-r4398 and tried to map my data. I want to use a MySQL database, but there seems to be a bug in IPT concerning MySQL. IPT is not able to handle the SQL statement even though it is correct (tested on the MySQL server directly) Log file says: 1. Error in SQL (there is definitely no error in the sql statement) 2. IPT expects one more column than the sql statement queries for (unclear why) 3. IPT can't handle datetime (unclear why) A CSV file and a connection to a MS SQL Server did work. Preview looks like this: [cid:image001.jpg@01CECB47.70BB6950] It would be great if someone could fix those bugs. Thanks in advance! Best wishes, Gabi ----------------------------------------------------------------- Gabriele Droege Coordinator - DNA Bank Network Global Genome Biodiversity Network (GGBN) Berlin-Dahlem DNA Bank Deputy Women's Officer ZE BGBM Botanic Garden and Botanical Museum Berlin-Dahlem Freie Universität Berlin Koenigin-Luise-Str. 6-8 14195 Berlin Germany +49 30 838 50 139 www.dnabank-network.org<http://www.dnabank-network.org> www.ggbn.org<http://www.ggbn.org> www.bgbm.org<http://www.bgbm.org>

2 5

mapping to the wrong datatypes
by BROSENS, Dimitri 02 Oct '13

02 Oct '13

* modified is mapped to values with the wrong data type. * eventDate is mapped to values with the wrong data type. * individualCount is mapped to values with the wrong data type. Dear, Here, we have chosen the wrong data type on purpose. For the terms eventDate and modified, the reason is that we sometimes have very vague dates. (ex: Winter 1921) and for individualCount we would like to use "unknown". (As the field is empty in the original data) Would this create any problems during the indexing? Can we just leave it like that? In the standard it is not specified which type the data has to be... only "best practices". Kind regards, Dimi * * * * * * * * * * * * * D I S C L A I M E R * * * * * * * * * * * * * Dit bericht en eventuele bijlagen geven enkel de visie van de schrijver weer en binden het INBO onder geen enkel beding, zolang dit bericht niet bevestigd is door een geldig ondertekend document. The views expressed in this message and any annex are purely those of the writer and may not be regarded as stating an official position of INBO, as long as the message is not confirmed by a duly signed document.

3 2

IPT behind firewall [SEC=UNCLASSIFIED]
by Miles Jordan 02 Oct '13

02 Oct '13

Hello, I've been trying to set up IPT from behind a corporate firewall, however it doesn't let me access the resources from http://gbrdsdev.gbif.org. I've tried putting a valid proxy in the proxy URL parameter (although I don't think that's what it's for) and also tried starting tomcat with standard JVM http.proxy parameters, which should work, but it looks like it's just ignoring them. Other apps on the same tomcat server do pick them up. I'd appreciate some guidance because I'm still using DiGIR and would like to switch but this is holding me back. Cheers, Miles Jordan [P]+61 3 6232 3486 Australian Antarctic Data Centre | Australian Antarctic Division Dept. of Sustainability, Environment, Water, Population and Communities ___________________________________________________________________________ Australian Antarctic Division - Commonwealth of Australia IMPORTANT: This transmission is intended for the addressee only. If you are not the intended recipient, you are notified that use or dissemination of this communication is strictly prohibited by Commonwealth law. If you have received this transmission in error, please notify the sender immediately by e-mail or by telephoning +61 3 6232 3209 and DELETE the message. Visit our web site at http://www.antarctica.gov.au/ ___________________________________________________________________________

2 1