I can't remember what document element does, but I am quite sure the entities just need to be side-by-side.
See the example from my book: https://github.com/arafalov/solr-indexing-book/blob/master/published/dihdb/conf/dih-definition.xml Notice that you need preImportDeleteQuery for each definition, otherwise they will do "delete *" and break each other's content. Regards, Alex. Personal: http://www.outerthoughts.com/ and @arafalov Solr resources and newsletter: http://www.solr-start.com/ and @solrstart Solr popularizers community: https://www.linkedin.com/groups?gid=6713853 On 4 November 2014 14:52, Tim Dunphy <bluethu...@gmail.com> wrote: > Hey all, > > I finally got mysql data into Solr 4 with your help. First off, thank you > for that! > > But now I'm hoping to refine the resulting process a bit. > > What I'm trying to do, now that mysql imports are working, is to import 2 > separate tables from the same mysql database. I tried this in my xml and it > doesn't work: > > <dataConfig> > <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" > url="jdbc:mysql://web1.mydomain.com:3306/mydomain" user="admin" > password=“secret” batchSize="1" /> > <document name="mydomain_users"> > <entity name="mydomain_users" query="SELECT * FROM wp_users"> > <field column="ID" name="ID" /> > <field column="user_login" name="user_login" /> > <field column="user_nicename" name="user_nicename" /> > <field column="user_email" name="user_email" /> > <field column="user_url" name="user_url" /> > <field column="user_registered" name="user_registered" /> > <field column="user_activation_key" name="user_activation_key" > /> > <field column="user_status" name="user_status" /> > <field column="display_name" name="display_name" /> > </entity> > </document> > > <document name="mydomain_posts"> > <entity name="mydomain_posts" query="SELECT * FROM wp_posts"> > <field column="ID" name="ID" /> > <field column="post_author" name="post_author" /> > <field column="post_date" name="post_date" /> > <field column="post_content" name="post_content" /> > </entity> > </document> > </dataConfig> > > What happens is that the first table (document name mydomain_users) gets > imported. But the second table (document name mydomain_posts) does not. > > Can anybody tell me what I'm doing wrong? I know that I need to get a > little more used to using XML. > > Thanks > Tim > > -- > GPG me!! > > gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
