Tools for schema.xml generation and to import from a database

[Andre Lopes <lo...@gmail.com>]

Hi,

I'm new to Solr. I've installed 3.6.1 but I'm a little bit confused
about what and how to do next. I will use the Jetty version for now.

Two poinst I need to know:

1 - I've 2 views that I would like to import to Solr. I think I must
do a schema.xml and then import data to that schema. I'm correct with
this one?

2 - About tools to autogenerate the schema.xml, there are any? And
about tools to import data to the schema, there are any(I'm using
Python)?


Please give me some clues.

Thanks,

Best Regards,
André.

Re: Tools for schema.xml generation and to import from a database

[Andre Lopes <lo...@gmail.com>]

Thanks for the reply Alexandre,

I will test your clues as soon as possible.

Best Regards,



On Mon, Jul 30, 2012 at 4:15 AM, Alexandre Rafalovitch
<ar...@gmail.com> wrote:
> If you are just starting with SOLR, you might as well jump to 4.0
> Alpha. By the time you finished, it will be the production copy.
>
> If you want to index stuff from the database, your first step is
> probably to use DataImportHandler (DIH). Once you get past the basics,
> you may want to do a custom code, but start from from DIH for faster
> results.
>
> You will want to modify schema.xml. I started by using DIH example and
> just adding an extra core at first. This might be easier than building
> a full directory setup from scratch.
>
> You also don't actually need to configure schema too much at the
> beginning. You can start by using dynamic fields. So, if in DIH, you
> say that your target field is XYZ_i it is automatically picked by as
> an integer field by SOLR (due to "*_i" definition that you do need to
> have). This will not work for fields you want to do aggregation on
> (e.g. multiple text fields copied into one for easier search), for
> multilingual text fields, etc. But it will get you going.
>
> Oh, and welcome to SOLR. You will like it.
>
> Regards,
>    Alex.
>
> Personal blog: http://blog.outerthoughts.com/
> LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch
> - Time is the quality of nature that keeps events from happening all
> at once. Lately, it doesn't seem to be working.  (Anonymous  - via GTD
> book)
>
>
> On Sun, Jul 29, 2012 at 3:45 PM, Andre Lopes <lo...@gmail.com> wrote:
>> Hi,
>>
>> I'm new to Solr. I've installed 3.6.1 but I'm a little bit confused
>> about what and how to do next. I will use the Jetty version for now.
>>
>> Two poinst I need to know:
>>
>> 1 - I've 2 views that I would like to import to Solr. I think I must
>> do a schema.xml and then import data to that schema. I'm correct with
>> this one?
>>
>> 2 - About tools to autogenerate the schema.xml, there are any? And
>> about tools to import data to the schema, there are any(I'm using
>> Python)?
>>
>>
>> Please give me some clues.
>>
>> Thanks,
>>
>> Best Regards,
>> André.

Re: Tools for schema.xml generation and to import from a database

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

If you are just starting with SOLR, you might as well jump to 4.0
Alpha. By the time you finished, it will be the production copy.

If you want to index stuff from the database, your first step is
probably to use DataImportHandler (DIH). Once you get past the basics,
you may want to do a custom code, but start from from DIH for faster
results.

You will want to modify schema.xml. I started by using DIH example and
just adding an extra core at first. This might be easier than building
a full directory setup from scratch.

You also don't actually need to configure schema too much at the
beginning. You can start by using dynamic fields. So, if in DIH, you
say that your target field is XYZ_i it is automatically picked by as
an integer field by SOLR (due to "*_i" definition that you do need to
have). This will not work for fields you want to do aggregation on
(e.g. multiple text fields copied into one for easier search), for
multilingual text fields, etc. But it will get you going.

Oh, and welcome to SOLR. You will like it.

Regards,
   Alex.

Personal blog: http://blog.outerthoughts.com/
LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch
- Time is the quality of nature that keeps events from happening all
at once. Lately, it doesn't seem to be working.  (Anonymous  - via GTD
book)


On Sun, Jul 29, 2012 at 3:45 PM, Andre Lopes <lo...@gmail.com> wrote:
> Hi,
>
> I'm new to Solr. I've installed 3.6.1 but I'm a little bit confused
> about what and how to do next. I will use the Jetty version for now.
>
> Two poinst I need to know:
>
> 1 - I've 2 views that I would like to import to Solr. I think I must
> do a schema.xml and then import data to that schema. I'm correct with
> this one?
>
> 2 - About tools to autogenerate the schema.xml, there are any? And
> about tools to import data to the schema, there are any(I'm using
> Python)?
>
>
> Please give me some clues.
>
> Thanks,
>
> Best Regards,
> André.