- added ABCD import test for subspecies

diff --git a/.gitattributes b/.gitattributes
index 3e306a44c8cb062979809e88b2624636101d00da..cc7728755a9d9b51439d07e4fbdd2bbd2297eab0 100644 (file)
--- a/.gitattributes
+++ b/.gitattributes
@@ -647,6 +647,7 @@ cdmlib-io/src/test/resources/eu/etaxonomy/cdm/io/specimen/abcd206/in/Campanula_A
 cdmlib-io/src/test/resources/eu/etaxonomy/cdm/io/specimen/abcd206/in/SpecimenImportConfiguratorTest-input.xml -text
 cdmlib-io/src/test/resources/eu/etaxonomy/cdm/io/specimen/abcd206/in/SpecimenImportConfiguratorTest.doInvoke2.xml -text
 cdmlib-io/src/test/resources/eu/etaxonomy/cdm/io/specimen/abcd206/in/SpecimenImportConfiguratorTest.xml -text
+cdmlib-io/src/test/resources/eu/etaxonomy/cdm/io/specimen/abcd206/in/camapanula_abietina_subspecies.xml -text
 cdmlib-io/src/test/resources/eu/etaxonomy/cdm/io/specimen/excel/in/ExcelImportConfiguratorTest-input.xls -text
 cdmlib-io/src/test/resources/eu/etaxonomy/cdm/io/specimen/excel/in/ExcelSpecimenImportExampleTest-input.xls -text
 cdmlib-io/src/test/resources/eu/etaxonomy/cdm/io/specimen/excel/in/ExcelSpecimenImportExampleTest-input.xlsx -text

diff --git a/cdmlib-io/src/test/java/eu/etaxonomy/cdm/io/specimen/abcd206/in/SpecimenImportConfiguratorTest.java b/cdmlib-io/src/test/java/eu/etaxonomy/cdm/io/specimen/abcd206/in/SpecimenImportConfiguratorTest.java
index 71127461d46e84acb4dc898b9a1e96f68a74b369..631e2fcccc00ac10bf31a01cf0a8d53d118ac68c 100644 (file)
--- a/cdmlib-io/src/test/java/eu/etaxonomy/cdm/io/specimen/abcd206/in/SpecimenImportConfiguratorTest.java
+++ b/cdmlib-io/src/test/java/eu/etaxonomy/cdm/io/specimen/abcd206/in/SpecimenImportConfiguratorTest.java
@@ -161,12 +161,40 @@ public class SpecimenImportConfiguratorTest extends CdmTransactionalIntegrationT
                assertEquals("Number of references is incorrect", 1, referenceService.count(Reference.class));\r
        }\r
 \r
+       @Test\r
+    @DataSet( value="../../../BlankDataSet.xml", loadStrategy=CleanSweepInsertLoadStrategy.class)\r
+    public void testImportSubspecies() {\r
+        String inputFile = "/eu/etaxonomy/cdm/io/specimen/abcd206/in/camapanula_abietina_subspecies.xml";\r
+        URL url = this.getClass().getResource(inputFile);\r
+        assertNotNull("URL for the test file '" + inputFile + "' does not exist", url);\r
+\r
+        Abcd206ImportConfigurator importConfigurator = null;\r
+        try {\r
+            importConfigurator = Abcd206ImportConfigurator.NewInstance(url.toURI(), null,false);\r
+        } catch (URISyntaxException e) {\r
+            e.printStackTrace();\r
+            Assert.fail();\r
+        }\r
+        assertNotNull("Configurator could not be created", importConfigurator);\r
+\r
+        boolean result = defaultImport.invoke(importConfigurator);\r
+        assertTrue("Return value for import.invoke should be true", result);\r
+        assertEquals("Number of TaxonNames is incorrect", 3, nameService.count(TaxonNameBase.class));\r
+        /*\r
+         * Classification\r
+         * - Campanula\r
+         *   - Campanula patula\r
+         *      - Campanula patula subsp. abietina\r
+         */\r
+        assertEquals("Number of TaxonNodes is incorrect", 4, taxonNodeService.count(TaxonNode.class));\r
+       }\r
+\r
     /* (non-Javadoc)\r
      * @see eu.etaxonomy.cdm.test.integration.CdmIntegrationTest#createTestData()\r
      */\r
     @Override\r
     public void createTestDataSet() throws FileNotFoundException {\r
         // TODO Auto-generated method stub\r
-        \r
+\r
     }\r
 }\r

diff --git a/cdmlib-io/src/test/resources/eu/etaxonomy/cdm/io/specimen/abcd206/in/camapanula_abietina_subspecies.xml b/cdmlib-io/src/test/resources/eu/etaxonomy/cdm/io/specimen/abcd206/in/camapanula_abietina_subspecies.xml
new file mode 100644 (file)
index 0000000..bd04374
--- /dev/null
+++ b/cdmlib-io/src/test/resources/eu/etaxonomy/cdm/io/specimen/abcd206/in/camapanula_abietina_subspecies.xml
@@ -0,0 +1,253 @@
+<?xml version='1.0' encoding='UTF-8'?>\r
+<biocase:response xmlns:abcd="http://www.tdwg.org/schemas/abcd/2.06" xmlns:biocase="http://www.biocase.org/schemas/protocol/1.3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.biocase.org/schemas/protocol/1.3 http://www.bgbm.org/biodivinf/schema/protocol_1_31.xsd">\r
+  <!--XML generated by BioCASE PyWrapper software version 3.5.2. Made in Berlin.-->\r
+  <biocase:header>\r
+    <biocase:version software="os">nt</biocase:version>\r
+    <biocase:version software="python">2.7 (r27:82525, Jul  4 2010, 07:43:08) [MSC v.1500 64 bit (AMD64)]</biocase:version>\r
+    <biocase:version software="pywrapper">3.5.2</biocase:version>\r
+    <biocase:version software="dbmod">MS SQL Server module vceODBC 2.0.1</biocase:version>\r
+    <biocase:sendTime>2015-01-15T13:55:13.852000</biocase:sendTime>\r
+    <biocase:source>Herbar@ww3.bgbm.org</biocase:source>\r
+    <biocase:destination>130.133.69.2</biocase:destination>\r
+    <biocase:type>search</biocase:type>\r
+  </biocase:header>\r
+  <biocase:content recordCount="4" recordDropped="0" recordStart="0" totalSearchHits="4">\r
+    <abcd:DataSets>\r
+      <abcd:DataSet>\r
+        <abcd:TechnicalContacts>\r
+          <abcd:TechnicalContact>\r
+            <abcd:Name>Botanic Garden and Botanical Museum Berlin-Dahlem</abcd:Name>\r
+            <abcd:Email>biodiversitydata@bgbm.org</abcd:Email>\r
+            <abcd:Address>Königin-Luise-Str. 6-8, 14195 Berlin, Germany</abcd:Address>\r
+          </abcd:TechnicalContact>\r
+        </abcd:TechnicalContacts>\r
+        <abcd:ContentContacts>\r
+          <abcd:ContentContact>\r
+            <abcd:Name>Botanic Garden and Botanical Museum Berlin-Dahlem</abcd:Name>\r
+            <abcd:Email>biodiversitydata@bgbm.org</abcd:Email>\r
+            <abcd:Address>Königin-Luise-Str. 6-8, 14195 Berlin, Germany</abcd:Address>\r
+          </abcd:ContentContact>\r
+        </abcd:ContentContacts>\r
+        <abcd:Metadata>\r
+          <abcd:Description>\r
+            <abcd:Representation abcd:language="en">\r
+              <abcd:Title>Herbarium Berolinense</abcd:Title>\r
+              <abcd:Details>The herbarium of the Botanic Garden and Botanical Museum Berlin-Dahlem (herbarium acronym: B) is the largest in Germany and holds a collection of more than 3.5 million preserved specimens. All plant groups – flowering plants, ferns, mosses, liverworts, and algae, as well as fungi and lichens – are represented in the collections which are worldwide in scope. Associated with the general herbarium are special collections of dried fruits and seeds, wood samples, and specimens preserved in alcohol. The collections of the herbarium are growing constantly through field research conducted by staff, and through gifts, acquisitions, and exchanges of specimens from other herbaria</abcd:Details>\r
+            </abcd:Representation>\r
+          </abcd:Description>\r
+          <abcd:IconURI>http://www.bgbm.org/BGBM/icons/bgbmlogo.gif</abcd:IconURI>\r
+          <abcd:RevisionData>\r
+            <abcd:Creators>Herbarium Berolinense</abcd:Creators>\r
+            <abcd:DateCreated>2003-06-01T00:00:00</abcd:DateCreated>\r
+            <abcd:DateModified>2008-02-21T11:00:00</abcd:DateModified>\r
+          </abcd:RevisionData>\r
+          <abcd:Owners>\r
+            <abcd:Owner>\r
+              <abcd:Organisation>\r
+                <abcd:Name>\r
+                  <abcd:Representation abcd:language="en">\r
+                    <abcd:Text>Botanic Garden and Botanical Museum Berlin-Dahlem</abcd:Text>\r
+                    <abcd:Abbreviation>BGBM</abcd:Abbreviation>\r
+                  </abcd:Representation>\r
+                </abcd:Name>\r
+              </abcd:Organisation>\r
+              <abcd:Addresses>\r
+                <abcd:Address>Königin-Luise-Str. 6-8, 14195 Berlin, Germany</abcd:Address>\r
+              </abcd:Addresses>\r
+              <abcd:EmailAddresses>\r
+                <abcd:EmailAddress>biodiversitydata@bgbm.org</abcd:EmailAddress>\r
+              </abcd:EmailAddresses>\r
+              <abcd:URIs>\r
+                <abcd:URL>http://www.bgbm.org</abcd:URL>\r
+              </abcd:URIs>\r
+            </abcd:Owner>\r
+          </abcd:Owners>\r
+          <abcd:IPRStatements>\r
+            <abcd:TermsOfUseStatements>\r
+              <abcd:TermsOfUse abcd:language="en">\r
+                <abcd:Text>The use of the data is allowed only for non-profit scientific use and for non-profit nature conservation purpose. The data base or part of it may only be used or copied by the written permission from the legal owner.</abcd:Text>\r
+              </abcd:TermsOfUse>\r
+            </abcd:TermsOfUseStatements>\r
+            <abcd:Citations>\r
+              <abcd:Citation abcd:language="en">\r
+                <abcd:Text>Röpert, D. (Ed.) 2000 - (continuously updated): Digital specimen images at the Herbarium Berolinense (B).</abcd:Text>\r
+              </abcd:Citation>\r
+            </abcd:Citations>\r
+          </abcd:IPRStatements>\r
+        </abcd:Metadata>\r
+        <abcd:Units>\r
+          <abcd:Unit>\r
+            <abcd:UnitGUID>http://herbarium.bgbm.org/object/B100005461</abcd:UnitGUID>\r
+            <abcd:SourceInstitutionID>BGBM</abcd:SourceInstitutionID>\r
+            <abcd:SourceID>Herbarium Berolinense</abcd:SourceID>\r
+            <abcd:UnitID>B 10 0005461</abcd:UnitID>\r
+            <abcd:Identifications>\r
+              <abcd:Identification>\r
+                <abcd:Result>\r
+                  <abcd:TaxonIdentified>\r
+                    <abcd:HigherTaxa>\r
+                      <abcd:HigherTaxon>\r
+                        <abcd:HigherTaxonName>Plantae</abcd:HigherTaxonName>\r
+                        <abcd:HigherTaxonRank>regnum</abcd:HigherTaxonRank>\r
+                      </abcd:HigherTaxon>\r
+                      <abcd:HigherTaxon>\r
+                        <abcd:HigherTaxonName>CAMPANULACEAE</abcd:HigherTaxonName>\r
+                        <abcd:HigherTaxonRank>familia</abcd:HigherTaxonRank>\r
+                      </abcd:HigherTaxon>\r
+                    </abcd:HigherTaxa>\r
+                    <abcd:ScientificName>\r
+                      <abcd:FullScientificNameString>Campanula patula subsp. abietina</abcd:FullScientificNameString>\r
+                      <abcd:NameAtomised>\r
+                        <abcd:Botanical>\r
+                          <abcd:GenusOrMonomial>Campanula</abcd:GenusOrMonomial>\r
+                          <abcd:FirstEpithet>patula</abcd:FirstEpithet>\r
+                          <abcd:InfraspecificEpithet>abietina</abcd:InfraspecificEpithet>\r
+                          <abcd:Rank>subsp.</abcd:Rank>\r
+                        </abcd:Botanical>\r
+                      </abcd:NameAtomised>\r
+                    </abcd:ScientificName>\r
+                  </abcd:TaxonIdentified>\r
+                </abcd:Result>\r
+                <abcd:PreferredFlag>1</abcd:PreferredFlag>\r
+              </abcd:Identification>\r
+            </abcd:Identifications>\r
+            <abcd:RecordBasis>PreservedSpecimen</abcd:RecordBasis>\r
+            <abcd:KindOfUnit>herbarium sheet</abcd:KindOfUnit>\r
+            <abcd:MultiMediaObjects>\r
+              <abcd:MultiMediaObject>\r
+                <abcd:FileURI>http://ww2.bgbm.org/herbarium/images/B/10/00/05/46/B_10_0005461.jpg</abcd:FileURI>\r
+                <abcd:ProductURI>http://ww2.bgbm.org/herbarium/view_biocase.cfm?SpecimenPK=5708</abcd:ProductURI>\r
+                <abcd:Format>image/jpeg</abcd:Format>\r
+                <abcd:IPR>\r
+                  <abcd:Licenses>\r
+                    <abcd:License abcd:language="en">\r
+                      <abcd:Text>Image parts provided by this server with the given resolution have been released under the Creative Commons cc-by-sa 3.0 (generic) licence [http://creativecommons.org/licenses/by-sa/3.0/de/]. Please credit images to BGBM following our citation guidelines [http://ww2.bgbm.org/Herbarium/cite.cfm]. If you would like to use images in a different format or resolution which is not provided by this image server, please contact [BGBM, d.roepert[at]bgbm.org] for additional information.</abcd:Text>\r
+                      <abcd:URI>http://creativecommons.org/licenses/by-sa/3.0/</abcd:URI>\r
+                    </abcd:License>\r
+                  </abcd:Licenses>\r
+                </abcd:IPR>\r
+              </abcd:MultiMediaObject>\r
+            </abcd:MultiMediaObjects>\r
+            <abcd:Gathering>\r
+              <abcd:DateTime>\r
+                <abcd:DateText>17.7.1896</abcd:DateText>\r
+              </abcd:DateTime>\r
+              <abcd:Agents>\r
+                <abcd:GatheringAgentsText>L. Adamovic</abcd:GatheringAgentsText>\r
+              </abcd:Agents>\r
+              <abcd:LocalityText>in pascuis alpinis m. Šuva Planina prope Niš.</abcd:LocalityText>\r
+              <abcd:Country>\r
+                <abcd:Name>Serbia</abcd:Name>\r
+                <abcd:ISO3166Code>RS</abcd:ISO3166Code>\r
+              </abcd:Country>\r
+              <abcd:NamedAreas>\r
+                <abcd:NamedArea>\r
+                  <abcd:AreaClass language="en">Continent</abcd:AreaClass>\r
+                  <abcd:AreaName language="en">Europe</abcd:AreaName>\r
+                </abcd:NamedArea>\r
+              </abcd:NamedAreas>\r
+              <abcd:Altitude>\r
+                <abcd:MeasurementOrFactAtomised>\r
+                  <abcd:LowerValue>1900 m</abcd:LowerValue>\r
+                  <abcd:UnitOfMeasurement>m</abcd:UnitOfMeasurement>\r
+                </abcd:MeasurementOrFactAtomised>\r
+              </abcd:Altitude>\r
+              <abcd:Notes language="en" />\r
+            </abcd:Gathering>\r
+            <abcd:RecordURI>http://herbarium.bgbm.org/object/B100005461</abcd:RecordURI>\r
+          </abcd:Unit>\r
+          <abcd:Unit>\r
+            <abcd:UnitGUID>http://herbarium.bgbm.org/object/B100005464</abcd:UnitGUID>\r
+            <abcd:SourceInstitutionID>BGBM</abcd:SourceInstitutionID>\r
+            <abcd:SourceID>Herbarium Berolinense</abcd:SourceID>\r
+            <abcd:UnitID>B 10 0005464</abcd:UnitID>\r
+            <abcd:Identifications>\r
+              <abcd:Identification>\r
+                <abcd:Result>\r
+                  <abcd:TaxonIdentified>\r
+                    <abcd:HigherTaxa>\r
+                      <abcd:HigherTaxon>\r
+                        <abcd:HigherTaxonName>Plantae</abcd:HigherTaxonName>\r
+                        <abcd:HigherTaxonRank>regnum</abcd:HigherTaxonRank>\r
+                      </abcd:HigherTaxon>\r
+                      <abcd:HigherTaxon>\r
+                        <abcd:HigherTaxonName>CAMPANULACEAE</abcd:HigherTaxonName>\r
+                        <abcd:HigherTaxonRank>familia</abcd:HigherTaxonRank>\r
+                      </abcd:HigherTaxon>\r
+                    </abcd:HigherTaxa>\r
+                    <abcd:ScientificName>\r
+                      <abcd:FullScientificNameString>Campanula patula subsp. abietina</abcd:FullScientificNameString>\r
+                      <abcd:NameAtomised>\r
+                        <abcd:Botanical>\r
+                          <abcd:GenusOrMonomial>Campanula</abcd:GenusOrMonomial>\r
+                          <abcd:FirstEpithet>patula</abcd:FirstEpithet>\r
+                          <abcd:InfraspecificEpithet>abietina</abcd:InfraspecificEpithet>\r
+                          <abcd:Rank>subsp.</abcd:Rank>\r
+                        </abcd:Botanical>\r
+                      </abcd:NameAtomised>\r
+                    </abcd:ScientificName>\r
+                  </abcd:TaxonIdentified>\r
+                </abcd:Result>\r
+                <abcd:PreferredFlag>1</abcd:PreferredFlag>\r
+              </abcd:Identification>\r
+            </abcd:Identifications>\r
+            <abcd:RecordBasis>PreservedSpecimen</abcd:RecordBasis>\r
+            <abcd:KindOfUnit>herbarium sheet</abcd:KindOfUnit>\r
+            <abcd:MultiMediaObjects>\r
+              <abcd:MultiMediaObject>\r
+                <abcd:FileURI>http://ww2.bgbm.org/herbarium/images/B/10/00/05/46/B_10_0005464.jpg</abcd:FileURI>\r
+                <abcd:ProductURI>http://ww2.bgbm.org/herbarium/view_biocase.cfm?SpecimenPK=5711</abcd:ProductURI>\r
+                <abcd:Format>image/jpeg</abcd:Format>\r
+                <abcd:IPR>\r
+                  <abcd:Licenses>\r
+                    <abcd:License abcd:language="en">\r
+                      <abcd:Text>Image parts provided by this server with the given resolution have been released under the Creative Commons cc-by-sa 3.0 (generic) licence [http://creativecommons.org/licenses/by-sa/3.0/de/]. Please credit images to BGBM following our citation guidelines [http://ww2.bgbm.org/Herbarium/cite.cfm]. If you would like to use images in a different format or resolution which is not provided by this image server, please contact [BGBM, d.roepert[at]bgbm.org] for additional information.</abcd:Text>\r
+                      <abcd:URI>http://creativecommons.org/licenses/by-sa/3.0/</abcd:URI>\r
+                    </abcd:License>\r
+                  </abcd:Licenses>\r
+                </abcd:IPR>\r
+              </abcd:MultiMediaObject>\r
+            </abcd:MultiMediaObjects>\r
+            <abcd:Gathering>\r
+              <abcd:DateTime>\r
+                <abcd:DateText>3.7.1895</abcd:DateText>\r
+              </abcd:DateTime>\r
+              <abcd:Agents>\r
+                <abcd:GatheringAgentsText>L. Adamovic</abcd:GatheringAgentsText>\r
+              </abcd:Agents>\r
+              <abcd:LocalityText>in alpnis montis Motina.</abcd:LocalityText>\r
+              <abcd:Country>\r
+                <abcd:Name>Serbia</abcd:Name>\r
+                <abcd:ISO3166Code>RS</abcd:ISO3166Code>\r
+              </abcd:Country>\r
+              <abcd:NamedAreas>\r
+                <abcd:NamedArea>\r
+                  <abcd:AreaClass language="en">Continent</abcd:AreaClass>\r
+                  <abcd:AreaName language="en">Europe</abcd:AreaName>\r
+                </abcd:NamedArea>\r
+              </abcd:NamedAreas>\r
+              <abcd:Notes language="en" />\r
+            </abcd:Gathering>\r
+            <abcd:RecordURI>http://herbarium.bgbm.org/object/B100005464</abcd:RecordURI>\r
+          </abcd:Unit>\r
+        </abcd:Units>\r
+      </abcd:DataSet>\r
+    </abcd:DataSets>\r
+  </biocase:content>\r
+  <biocase:diagnostics>\r
+    <biocase:diagnostic severity="INFO">Datasource wrapper Herbar requested</biocase:diagnostic>\r
+    <biocase:diagnostic severity="INFO">Reading PSF from C:\bps2\config\datasources\Herbar\provider_setup_file.xml</biocase:diagnostic>\r
+    <biocase:diagnostic severity="INFO">BioCASe protocol used.</biocase:diagnostic>\r
+    <biocase:diagnostic severity="INFO">HTTP parameter 'query' used for building the request.</biocase:diagnostic>\r
+    <biocase:diagnostic severity="INFO">Try to get CMF for namespace http://www.tdwg.org/schemas/abcd/2.06</biocase:diagnostic>\r
+    <biocase:diagnostic severity="INFO">Load CMFile 'C:\bps2\config\datasources\Herbar\cmf_ABCD_2.06.xml'</biocase:diagnostic>\r
+    <biocase:diagnostic severity="INFO">Executing SQL: 'SELECT DISTINCT TOP 50 [specimen].[SpecimenIdentifikationID] FROM [wrapper_view_2_table] AS [specimen] LEFT JOIN [view_bestimmung_table] AS [identification] ON ([identification].[SpecimenIdentifikationID] = [specimen].[SpecimenIdentifikationID]) WHERE ([identification].[FullNameCache] LIKE 'Campanula patula subsp. abietina' ) ORDER BY [specimen].[SpecimenIdentifikationID]'</biocase:diagnostic>\r
+    <biocase:diagnostic severity="INFO">Hits: 4</biocase:diagnostic>\r
+    <biocase:diagnostic severity="INFO">Executing SQL: 'SELECT [specimen].[SpecimenIdentifikationID], [meta].[supplier_organisation], [meta].[supplier_email], [meta].[supplier_telephone], [meta].[supplier_adress], [meta].[legal_owner_organisation], [meta].[legal_owner_email], [meta].[legal_owner_telephone], [meta].[legal_owner_adress], [meta].[source_name], [meta].[description], [meta].[logo_url], [meta].[supplier_supplied_when], [meta].[source_update], [meta].[legal_owner_organisation_code], [meta].[legal_owner_person], [meta].[legal_owner_url], [meta].[ipr], [meta].[copyright], [meta].[rights_url], [meta].[terms_of_use], [meta].[disclaimer], [meta].[statement_url], [meta].[acknowledgement], [specimen].[StableURI], [meta].[source_code], [specimen].[UnitID], [higherTaxa].[HigherTaxon], [higherTaxa].[HigherTaxonRank], [identification].[FullNameCache], [identification].[Genus], [identification].[Spepi], [identification].[Inepi], [identification].[Rank], [identification].[BasionymAutor], [identification].[Author], [identification].[StorageNameFlag], [identification].[Identifier], [identification].[IdentifierDate], [specimen].[MaterialCategory], [specimen].[KindOfUnit], [identification].[TypeStatus], [images].[FileURI], [images].[ProductURI], [images].[imageformat], [images].[statement], [images].[statementURI], [specimen].[Sammeldatum], [specimen].[Sammlerteam], [specimen].[TitelEtikett], [specimen].[LokaleAngabe], [specimen].[DefinitionAndExplanation], [specimen].[kIsoCode], [specimen].[kontinent], [specimen].[Longitude], [specimen].[Latitude], [specimen].[hoehenangabe], [specimen].[OekologischeBesonderheiten], [specimen].[Anmerkungen], [specimen].[SammelNr], [specimen].[geschlecht], [meta].[source_code], [specimen].[SpecimenIdentifikationID], [higherTaxa].[pk], [identification].[BestID_PK], [images].[SpecimenIdentifikationID] FROM [metadata] AS [meta], [wrapper_view_2_table] AS [specimen] LEFT JOIN [view_bestimmung_table] AS [identification] ON ([identification].[SpecimenIdentifikationID] = [specimen].[SpecimenIdentifikationID]) LEFT JOIN [view_multimedia_objects] AS [images] ON ([images].[SpecimenIdentifikationID] = [specimen].[SpecimenIdentifikationID]) LEFT JOIN [view_higherTaxa] AS [higherTaxa] ON ([higherTaxa].[BestID_PK] = [identification].[BestID_PK]) WHERE ([specimen].[SpecimenIdentifikationID] IN (9935, 9936, 9937, 9938)) ORDER BY [specimen].[SpecimenIdentifikationID]'</biocase:diagnostic>\r
+    <biocase:diagnostic severity="INFO">Hits: 8</biocase:diagnostic>\r
+    <biocase:diagnostic severity="WARNING">The mandatory child element LowerValue could not be created [0 existing, but 1 required]. The element /DataSets/DataSet/Units/Unit/Gathering/Altitude/MeasurementOrFactAtomised was also dropped.</biocase:diagnostic>\r
+    <biocase:diagnostic severity="WARNING">The mandatory child element LowerValue could not be created [0 existing, but 1 required]. The element /DataSets/DataSet/Units/Unit/Gathering/Altitude/MeasurementOrFactAtomised was also dropped.</biocase:diagnostic>\r
+    <biocase:diagnostic severity="WARNING">The mandatory child element LowerValue could not be created [0 existing, but 1 required]. The element /DataSets/DataSet/Units/Unit/Gathering/Altitude/MeasurementOrFactAtomised was also dropped.</biocase:diagnostic>\r
+    <biocase:diagnostic severity="INFO">time to execute request is 0.281000137329</biocase:diagnostic>\r
+  </biocase:diagnostics>\r
+</biocase:response>
\ No newline at end of file