Sorry I forgot to mention that. http://wiki.apache.org/solr/DataImportHandler#head-a6916b30b5d7605a990fb03c4ff461b3736496a9 --Noble
On Fri, May 30, 2008 at 11:37 AM, Shalin Shekhar Mangar <[EMAIL PROTECTED]> wrote: > You need to enable TemplateTransformer for your entity. For example: > <entity name="owners" pk="id" query="...." transformer="TemplateTransformer"> > > On Fri, May 30, 2008 at 11:31 AM, Julio Castillo > <[EMAIL PROTECTED]> wrote: >> Noble, >> I tried the template setting for the "id" field, but I didn't notice any >> different behavior. I also didn't see where this would be reflected. >> I looked at the fields and the debug output for the dataImporter and >> couldn't see any reference to a modified id name (per the template >> instructions). >> >> The behavior in the end seemed to be the same. Did I miss anything? >> I assume that the <uniqueKey>id</uniqueKey> setting in the schema.xml >> remains the same? >> >> Thanks again >> >> ** julio >> >> -----Original Message----- >> From: Noble Paul ??????? ?????? [mailto:[EMAIL PROTECTED] >> Sent: Thursday, May 29, 2008 9:46 PM >> To: solr-user@lucene.apache.org >> Subject: Re: How to describe 2 entities in dataConfig for the DataImporter? >> >> Consider constructing the id concatenating an extra string for each document >> . You can construct that field using the TeplateTransformer. >> in the entity owners keep the id as >> >> <field column="id" name="id" template="owners-${owners.id}"/> and in vets >> <field column="id" name="id" template="vets-${vets.id}"/> >> >> or anything else which can make it unique >> >> --Noble >> >> On Fri, May 30, 2008 at 10:05 AM, Shalin Shekhar Mangar >> <[EMAIL PROTECTED]> wrote: >>> That will happen only if id is the uniqueKey in Solr and the id coming >>> from both your tables have same values. In that case, they will >>> overwrite each other. You will need a separate uniqueKey (on other >>> than id field). >>> >>> On Fri, May 30, 2008 at 6:34 AM, Julio Castillo <[EMAIL PROTECTED]> >> wrote: >>>> Thanks Shalin, >>>> I tried putting everything under the same document (two different >>>> unrelated entities), and got a bit further. >>>> >>>> My problem now appears to be both of them stepping on each other due to >> "id" >>>> conflicts. Currently my id is defined in my schema as <field >>>> name="id" type="long" indexed="true" stored="true" required="true"/> >>>> >>>> Do I have to create a new "id" field? >>>> >>>> Thanks >>>> >>>> ** julio >>>> >>>> -----Original Message----- >>>> From: Shalin Shekhar Mangar [mailto:[EMAIL PROTECTED] >>>> Sent: Thursday, May 29, 2008 11:40 AM >>>> To: solr-user@lucene.apache.org >>>> Subject: Re: How to describe 2 entities in dataConfig for the >> DataImporter? >>>> >>>> Hi Julio, >>>> >>>> The first data-config is correct. >>>> >>>> You're running DataImportHandler in debug mode which creates only the >>>> first 10 documents by default. You can also add count=N to index only >>>> the first N documents. But this is intended only for debugging >>>> purposes. If you want to do a full-import just use >>>> /dataimport?command=full-import. By default, a full-import automatically >> cleans and commits. >>>> >>>> Hope that helps. >>>> >>>> On Thu, May 29, 2008 at 11:42 PM, Julio Castillo >>>> <[EMAIL PROTECTED]> >>>> wrote: >>>>> I have 2 dB tables unrelated to each other that I want to index. >>>>> >>>>> I have tried 2 approaches for specifying them in my data-config.xml >> file. >>>>> None of them seem to work (it seems I can only get data for the >>>>> first one listed). >>>>> >>>>> CASE 1) >>>>> <dataConfig> >>>>> <document name="test"> >>>>> <entity name="owners" pk="id" query="...."> >>>>> <field column="id" name="id"/> >>>>> <field column=name" name="userName"/> >>>>> </entity> >>>>> <entity name="vets" pk="id" query="...."> >>>>> <field column="id" name="id"/> >>>>> <field column=name" name="userName"/> >>>>> </entity> >>>>> </document> >>>>> </dataConfig> >>>>> >>>>> CASE 2) >>>>> <dataConfig> >>>>> <document name="test-1"> >>>>> <entity name="owners" pk="id" query="...."> >>>>> <field column="id" name="id"/> >>>>> <field column=name" name="userName"/> >>>>> </entity> >>>>> </document> >>>>> <document name="test-2"> >>>>> <entity name="vets" pk="id" query="...."> >>>>> <field column="id" name="id"/> >>>>> <field column=name" name="userName"/> >>>>> </entity> >>>>> </document> >>>>> </dataConfig> >>>>> >>>>> I ran the dataImporter as follows >>>>> http://localhost:2455/solr/dataimport?command=full-import&debug=on&v >>>>> er >>>>> bose=t >>>>> rue&clean=true&commit=true >>>>> >>>>> After running Case 1 the output only shows documents under >> entity:owners. >>>>> And an empty reference to entity:vets (no data). >>>>> >>>>> After running Case 2, the output only shows documents under >> entity:owners. >>>>> No references to entity:vets. >>>>> >>>>> In either case, I have commented out the entity:owners and I do see >>>>> the entity:vets data then. >>>>> >>>>> Thanks for your assistance >>>>> >>>>> Julio Castillo >>>>> >>>>> >>>> >>>> >>>> >>>> -- >>>> Regards, >>>> Shalin Shekhar Mangar. >>>> >>>> >>> >>> >>> >>> -- >>> Regards, >>> Shalin Shekhar Mangar. >>> >> >> >> >> -- >> --Noble Paul >> >> > > > > -- > Regards, > Shalin Shekhar Mangar. > -- --Noble Paul
