Re: correct XPATH syntax

[Twomey, David]

Ludovic,

Thanks for your help.  I tried your suggestion but it didn't work for
Authors.  Below are 3 snippets from data-config.xml, the XML file and the
XML response from the DB

Data-config:
             <entity name="medlineFiles" processor="XPathEntityProcessor"
                url="${medlineFileList.fileAbsolutePath}"
                forEach="/MedlineCitationSet/MedlineCitation"
                
transformer="DateFormatTransformer,TemplateTransformer,RegexTransformer,Log
Transformer"
                logTemplate="   processing
${medlineFileList.fileAbsolutePath}"
                logLevel="info"
                flatten="true"
                stream="true">

                <field column="pmid"
xpath="/MedlineCitationSet/MedlineCitation/PMID"   commonField="true" />
                <field column="journal_name"
xpath="/MedlineCitationSet/MedlineCitation/Article/Journal/Title"
commonField="true" />
                <field column="title"
xpath="/MedlineCitationSet/MedlineCitation/Article/ArticleTitle"
commonField="true" />
                <field column="abstract"
xpath="/MedlineCitationSet/MedlineCitation/Article/Abstract/AbstractText"
 commonField="true" />
                <field column="author"
xpath="/MedlineCitationSet/MedlineCitation/Article/AuthorList/Author"
commonField="false" />
                <field column="year"
xpath="/MedlineCitationSet/MedlineCitation/Article/Journal/JournalIssue/Pub
Date/Year"   commonField="true" />

              </entity>



XML Snippet for Author:
<AuthorList CompleteYN="Y">
 <Author ValidYN="Y">
  <LastName>Malathi</LastName>
  <ForeName>K</ForeName>
  <Initials>K</Initials>
 </Author>
 <Author ValidYN="Y">
  <LastName>Xiao</LastName>
  <ForeName>Y</ForeName>
  <Initials>Y</Initials>
 </Author>
 <Author ValidYN="Y">
  <LastName>Mitchell</LastName>
  <ForeName>A P</ForeName>
  <Initials>AP</Initials>
 </Author>
</AuthorList>


Response from SOLR:

<arr name="author">
<str></str>
<str></str>
<str></str>
<str></str>
<str></str>
<str></str>
<str></str>
<str></str>
<str></str>
<str></str>
<str></str>
<str></str>
<str></str>
<str></str>
</arr>
<str name="journal_name">Journal of cancer research and clinical
oncology</str>




Thanks
David

On 5/1/12 8:05 AM, "lboutros" <boutr...@gmail.com> wrote:

>Hi David,
>
>I think you should add this option : flatten=true
>
>and the could you try to use this XPath :
>
>/MedlineCitationSet/MedlineCitation/AuthorList/Author
>
>see here for the description :
>
>http://wiki.apache.org/solr/DataImportHandler#Configuration_in_data-config
>.xml-1
>
>I don't think the that the commonField option is needed here, I think you
>should suppress it.
>
>Ludovic. 
>
>-----
>Jouve
>France.
>--
>View this message in context:
>http://lucene.472066.n3.nabble.com/correct-XPATH-syntax-tp3951804p3952812.
>html
>Sent from the Solr - User mailing list archive at Nabble.com.