Hi Niels,
The correct mailing list is the IPT list (http://lists.gbif.org/mailman/listinfo/ipt). I suggest mailing that, providing as much information as possible - IPT version, the core and extensions you are using, the SQL statements you use etc.
The IPT does allows multiple mappings per source file which is a common practice, but you cannot map to an extension until you have mapped the core. There are some workarounds there, such as creating a core with only the minimum fields, and then effectively mapping an extension in a 1:1 manner (rather than multiple rows per core record).
Cheers, Tim
On 01 Sep 2014, at 09:11, Niels Klazenga Niels.Klazenga@rbg.vic.gov.au wrote:
Dear all, Not sure if this is appropriate use of this list, but I don't know where else to go. I was hoping I could prevail on someone to help me find out how to use extensions in the IPT provider for data from an SQL database, without creating duplicate rows in the core file or empty rows (apart from the core ID) in the extension file(s). I think I tried everything, but I must be overlooking something.
I found this, http://lists.gbif.org/pipermail/ipt/2013-October/000545.html, during my googling for an answer, which I think has the solution, but I can't work out how to implement it, as my IPT installation doesn't seem to let me create a mapping to just an extension and only lets me use one data mapping source for any resource.
Niels
Niels Klazenga Programmer Information Technology, Biodiversity Information Officer
National Herbarium of Victoria, Royal Botanic Gardens Birdwood Avenue South Yarra, VIC 3141 Australia Tel: (03) 9252 2346 Fax: (03) 9252 2444
e-mail: niels.klazenga@rbg.vic.gov.au
This email and any attachments may contain information that is personal, confidential, legally privileged and/or copyright. No part of it should be reproduced, adapted or communicated without the prior written consent of the sender and/or copyright owner.
It is the responsibility of the recipient to check for and remove viruses.
If you have received this email in error, please notify the sender by return email, delete it from your system and destroy any copies. You are not authorised to use, communicate or rely on the information contained in this email.
Please consider the environment before printing this email.
This email was Anti Virus checked by Sophos UTM. _______________________________________________ tdwg-content mailing list tdwg-content@lists.tdwg.org http://lists.tdwg.org/mailman/listinfo/tdwg-content