Re: [PyWrapper-devel] Query Result

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hi Markus,

Thanks for your reply. I finally got it working. Since I don't know which
concept is compulsory, I just missed some concepts. It would be good if I add a
schema to the mapping, those must-have concepts will be added by default so that
I don't need to look for them from the long long list.

Sorry the system is in our intranet, so you cannot access it. Thanks anyway.

Cheers,
Shunde.

Quoting Markus Döring <m.d...@bg...>:

> Dear Shunde,
> the problem is found in the diagnostics here:
>
> "The element /DataSets/DataSet..Sequence:-1360356980 was dropped 1
> times because of missing required subelements or attributes:
> [u'TechnicalContacts']"
>
> This means that ABCD defines a mandatory element TechnicalContacts
> that cannot be created. This usually results of missing mappings or
> NULL in the data of that specific record. Is the configuration tool
> externally visible? Then we (su...@bi...) could check your
> mappings directly online.
>
> best wishes
> --
> Markus
>
>
>
> On 10.05.2007, at 04:55, Shunde Zhang wrote:
>
> > Hi all,
> >
> > I just installed pywrapper 3.1.0a, and set up a simple mapping to
> > ABCD 2.06.
> >
> > I now have mapped 8 concepts. and when I did a simple query, I got
> > the correct
> > number of records but not the content as below. I used Query Forms
> > to do this.
> > Could you please tell me if anything wrong with my config? Thanks a
> > lot.
> >
> > Cheers,
> > Shunde.
> >
> >
> > <response xsi:schemaLocation="http://rs.tdwg.org/tapir/1.0
> > http://rs.tdwg.org/tapir/1.0/schema/tapir.xsd">
> > &#8722;
> > 	<header>
> > &#8722;
> > 	<source sendtime="2007-05-10T12:14:09.34"
> > accesspoint="http://ristretto.sapac.edu.au:8088/pywrapper/pywrapper?
> > dsa=avh">
> > <software version="3.1.0alpha" name="PyWrapper"/>
> > </source>
> > &#8722;
> > 	<custom>
> > <pyw:webapps pyw:location="http://ristretto.sapac.edu.au:8088/
> > pywrapper"/>
> > </custom>
> > </header>
> > <!-- CONTENT START -->
> > &#8722;
> > 	<search>
> > <summary start="0" totalMatched="1"/>
> > </search>
> > <!-- CONTENT END -->
> > &#8722;
> > 	<diagnostics>
> > <diagnostic time="2007-05-10T12:18:21.15" level="INFO">Reading
> > request</diagnostic>
> > &#8722;
> > 	<diagnostic time="2007-05-10T12:18:21.21" level="INFO">
> > Read model http://rs.tdwg.org/tapir/cs/abcd/2.06/model/abcd206.xml
> > </diagnostic>
> > &#8722;
> > 	<diagnostic time="2007-05-10T12:18:22.22" level="INFO">
> > Parsed response structure contains 991 leaf concepts with type out
> > of 1663 nodes
> > in total
> > </diagnostic>
> > <diagnostic time="2007-05-10T12:18:22.91" level="INFO">Request fully
> > parsed</diagnostic>
> > <diagnostic time="2007-05-10T12:18:22.91" level="INFO">Init model
> > ACBD 2.06 with
> > datasource preferences</diagnostic>
> > &#8722;
> > 	<diagnostic time="2007-05-10T12:18:23.26" level="INFO">
> > Model init finished. The model contains 1324 mapped concepts for
> > datasource
> > 'avh' out of 1324 model nodes mapped.
> > </diagnostic>
> > <diagnostic time="2007-05-10T12:18:23.26" level="INFO">Update model
> > structure
> > with datasource preferences</diagnostic>
> > &#8722;
> > 	<diagnostic time="2007-05-10T12:18:26.11" level="INFO">
> > Executing SQL: "SELECT COUNT(DISTINCT SpecimenRecord.Id) FROM
> > SpecimenRecord AS
> > SpecimenRecord JOIN TaxonName AS TaxonName ON
> > SpecimenRecord.TaxonNameId =
> > TaxonName.Id WHERE TaxonName.FullScientificName LIKE 'Baccharis
> > pingraea'   "
> > </diagnostic>
> > <diagnostic time="2007-05-10T12:18:41.22" level="INFO">DB query
> > finished</diagnostic>
> > &#8722;
> > 	<diagnostic time="2007-05-10T12:18:41.22" level="INFO">
> > Ordering view by [TaxonName.FullScientificName(text)]
> > </diagnostic>
> > &#8722;
> > 	<diagnostic time="2007-05-10T12:18:41.23" level="INFO">
> > Executing SQL: "SELECT DISTINCT SpecimenRecord.Id FROM
> > SpecimenRecord AS
> > SpecimenRecord JOIN TaxonName AS TaxonName ON
> > SpecimenRecord.TaxonNameId =
> > TaxonName.Id WHERE TaxonName.FullScientificName LIKE 'Baccharis
> > pingraea'  ORDER
> > BY TaxonName.FullScientificName, SpecimenRecord.Id LIMIT 51 OFFSET 0"
> > </diagnostic>
> > <diagnostic time="2007-05-10T12:18:54.29" level="INFO">DB query
> > finished</diagnostic>
> > &#8722;
> > 	<diagnostic time="2007-05-10T12:18:54.29" level="INFO">
> > Executing SQL: "SELECT  TaxonName.FullScientificName,
> > SpecimenRecord.Id,
> > SpecimenRecord.SourceInstitutionID, SpecimenRecord.UnitId,
> > SpecimenRecord.DateLastEdited, TaxonName.Id, TaxonName.Genus,
> > TaxonName.Species,
> > CollectSite.Id, CollectSite.LongitudeDecimal,
> > CollectSite.LatitudeDecimal FROM
> > SpecimenRecord AS SpecimenRecord LEFT JOIN TaxonName AS TaxonName ON
> > SpecimenRecord.TaxonNameId = TaxonName.Id LEFT JOIN CollectSite AS
> > CollectSite
> > ON SpecimenRecord.CollectSiteId = CollectSite.Id WHERE
> > SpecimenRecord.Id IN
> > ('459464')  ORDER BY TaxonName.FullScientificName "
> > </diagnostic>
> > <diagnostic time="2007-05-10T12:18:54.32" level="INFO">DB query
> > finished</diagnostic>
> > <diagnostic time="2007-05-10T12:18:54.32" level="INFO">Create XML
> > content from
> > recordset</diagnostic>
> > <diagnostic time="2007-05-10T12:18:54.32" level="INFO">Use
> > intelligent model
> > interpreter</diagnostic>
> > &#8722;
> > 	<diagnostic time="2007-05-10T12:18:54.32" level="WARNING">
> > No content produced. Probably there were no matches for your query.
> > </diagnostic>
> > <diagnostic time="2007-05-10T12:18:54.32" level="INFO">Finished
> > creating XML
> > content</diagnostic>
> > &#8722;
> > 	<diagnostic time="2007-05-10T12:18:54.32" level="INFO">
> > Total number of elements created=0. Elements dropped=0
> > </diagnostic>
> > &#8722;
> > 	<diagnostic time="2007-05-10T12:18:54.33" level="WARNING">
> > The element /DataSets..Sequence:-1360356532 was dropped 1 times
> > because of
> > missing required subelements or attributes: [u'DataSet']
> > </diagnostic>
> > &#8722;
> > 	<diagnostic time="2007-05-10T12:18:54.33" level="WARNING">
> > The element /DataSets/DataSet..Sequence:-1360356980 was dropped 1
> > times because
> > of missing required subelements or attributes: [u'TechnicalContacts']
> > </diagnostic>
> > </diagnostics>
> > </response>
> >
> > ----------------------------------------------------------------------
> > ---
> > This SF.net email is sponsored by DB2 Express
> > Download DB2 Express C - the FREE version of DB2 express and take
> > control of your XML. No limits. Just data. Click to get it now.
> > http://sourceforge.net/powerbar/db2/
> > _______________________________________________
> > PyWrapper-devel mailing list
> > PyW...@li...
> > https://lists.sourceforge.net/lists/listinfo/pywrapper-devel
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> PyWrapper-devel mailing list
> PyW...@li...
> https://lists.sourceforge.net/lists/listinfo/pywrapper-devel
>