Sorry if this comes through twice, but my first got rejected (this one is plain text, should come through better).
Part of this is solved by the Data Import Handler (DIH) see: http://wiki.apache.org/solr/DataImportHandler And think about a "database" data source. This can be combined with the "TikaEntityParser", and maybe some transformers to assemble the file name and send it through parsing. Don't overlook the possibility of parameters (the ${ reference pattern). If you need some custom code, you can also implement a custom Transformer that gets into the transformation chain in DIH, but you should only approach that after you exhaust the above approach. Hope this helps Erick On Fri, Apr 15, 2011 at 10:24 AM, vrpar...@gmail.com <vrpar...@gmail.com> wrote: > > Hello, > > I am new to solr, > > my requirements are, > > 1. at regular interval need solr to fetch data from sql server database and > do indexing on it. > 2. fetch only those records which is not yet indexed > 3. for each record there is one file associated, so with database table > fields also want to index content of that particular file > > e.g. there is one table "Customer" in database and customerid is primary key > for each customerid there is associated file of that customerprofile > named with customerid, > > 4. as i metioned above that when solr fetch data from sql server database > table , should fetch only data which is not yet indexed, (we have one older > lucene code, in which there is one field in table that isindexed so when > fetching data in select clause there is one condition that isindexed=false, > and when indexing is done update particular record of database with > isindexed=true) is there any mechanism in solr for that? > > how to achieve same ? > do i need to write custom code for that or it can be done with configuration > provided by solr? > > Thanks, > > Vishal Parekh > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/how-to-import-data-from-database-combine-with-file-content-in-solr-tp2824749p2824749.html > Sent from the Solr - User mailing list archive at Nabble.com.
