Help needed in Indexing and Search on xml content

["sangeetha.subramanian@gtnexus.com" <sa...@gtnexus.com>]

Hi Team,

I am a newbie to SOLR. I have got search fields stored in a xml file which is stored in MSSQL. I want to index on the content of the xml file in SOLR. We need to provide search based on the fields present in the XML file.

The reason why we are storing the input details as XML file is , the users will be able to add custom input fields on their own with values. Storing these custom fields as columns in MSSQL seems to be not an optimal solution. So we thought of putting it in XML file and store that file in RDBMS.
But I am not sure on how we can index the content of the file to make search better. I believe this can be done by ExtractingRequestHandler.

Could someone help me on how we can implement this/ direct me to some pages which could be of help to me ?

Thanks
Sangeetha

Re: Help needed in Indexing and Search on xml content

[Aman Tandon <am...@gmail.com>]

Hi,

You can retrieve the data in xml format aswell in JSON.

You need to learn about schema.xml, in this you define your fields which is
present in your xml, on which fields you want to search,etc

So it would be better to take a look at schema.xml, solr sample schema
could clear.most of doubts.
On Sep 25, 2014 5:12 PM, "PeriS" <pe...@htcinc.com> wrote:

> Hi Sangeetha,
>
> If you can tell me a little bit more about your setup, I can try and help.
> If you are on skype, that would be the easiest.
>
> Thanks
> -Peri
>
> On Sep 25, 2014, at 3:50 AM, sangeetha.subramanian@gtnexus.com wrote:
>
> > Hi Team,
> >
> > I am a newbie to SOLR. I have got search fields stored in a xml file
> which is stored in MSSQL. I want to index on the content of the xml file in
> SOLR. We need to provide search based on the fields present in the XML file.
> >
> > The reason why we are storing the input details as XML file is , the
> users will be able to add custom input fields on their own with values.
> Storing these custom fields as columns in MSSQL seems to be not an optimal
> solution. So we thought of putting it in XML file and store that file in
> RDBMS.
> > But I am not sure on how we can index the content of the file to make
> search better. I believe this can be done by ExtractingRequestHandler.
> >
> > Could someone help me on how we can implement this/ direct me to some
> pages which could be of help to me ?
> >
> > Thanks
> > Sangeetha
> >
> >
> > ---
> > This message has been scanned for viruses and dangerous content by HTC
> E-Mail Virus Protection Service.
> >
>
>
>
>
> *** DISCLAIMER *** This is a PRIVATE message. If you are not the intended
> recipient, please delete without copying and kindly advise us by e-mail of
> the mistake in delivery.
> NOTE: Regardless of content, this e-mail shall not operate to bind HTC
> Global Services to any order or other contract unless pursuant to explicit
> written agreement or government initiative expressly permitting the use of
> e-mail for such purpose.
>
>
>

Re: Help needed in Indexing and Search on xml content

[PeriS <pe...@htcinc.com>]

Hi Sangeetha,

If you can tell me a little bit more about your setup, I can try and help. If you are on skype, that would be the easiest. 

Thanks
-Peri

On Sep 25, 2014, at 3:50 AM, sangeetha.subramanian@gtnexus.com wrote:

> Hi Team,
> 
> I am a newbie to SOLR. I have got search fields stored in a xml file which is stored in MSSQL. I want to index on the content of the xml file in SOLR. We need to provide search based on the fields present in the XML file.
> 
> The reason why we are storing the input details as XML file is , the users will be able to add custom input fields on their own with values. Storing these custom fields as columns in MSSQL seems to be not an optimal solution. So we thought of putting it in XML file and store that file in RDBMS.
> But I am not sure on how we can index the content of the file to make search better. I believe this can be done by ExtractingRequestHandler.
> 
> Could someone help me on how we can implement this/ direct me to some pages which could be of help to me ?
> 
> Thanks
> Sangeetha
> 
> 
> --- 
> This message has been scanned for viruses and dangerous content by HTC E-Mail Virus Protection Service. 
> 




*** DISCLAIMER *** This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery.
NOTE: Regardless of content, this e-mail shall not operate to bind HTC Global Services to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.

Re: Help needed in Indexing and Search on xml content

[Alexandre Rafalovitch <ar...@gmail.com>]

Have a look at data import handler and you'll need to use nested entities.
That should get you at least a demo. Then you can decide whether that's
good enough.

Regards,
     Alex
On 25/09/2014 3:51 am, "sangeetha.subramanian@gtnexus.com" <
sangeetha.subramanian@gtnexus.com> wrote:

> Hi Team,
>
> I am a newbie to SOLR. I have got search fields stored in a xml file which
> is stored in MSSQL. I want to index on the content of the xml file in SOLR.
> We need to provide search based on the fields present in the XML file.
>
> The reason why we are storing the input details as XML file is , the users
> will be able to add custom input fields on their own with values. Storing
> these custom fields as columns in MSSQL seems to be not an optimal
> solution. So we thought of putting it in XML file and store that file in
> RDBMS.
> But I am not sure on how we can index the content of the file to make
> search better. I believe this can be done by ExtractingRequestHandler.
>
> Could someone help me on how we can implement this/ direct me to some
> pages which could be of help to me ?
>
> Thanks
> Sangeetha
>
>