Re: Adding docs from MySQL and php
Thanks Aakash! I've looked at it and it looks very interesting, the problem is that my database is a relational model, therefore I don't have a table with all the information, but many tables related to each other by their ids (primary keys and foreign keys). I've been thinking about using DataImportHandler in any of this two ways: - Write a script that creates a table with all the information I need for searching (it is not very efficient because of duplicate data) - Configure DataImportHandler with some JOIN SQL statement I'll let you know how I did, thanks again! Pablo 2009/9/1 Aakash Dharmadhikari > hi Pablo, > > DataImportHandler might be the best option for you. check this link > http://wiki.apache.org/solr/DataImportHandler > > regards, > aakash > > On Tue, Sep 1, 2009 at 9:18 PM, Pablo Ferrari >wrote: > > > Hello all, > > > > I'm new to the list and new to Solr. My name is Pablo, I'm from Spain and > > I'm developing a web site using Solr. > > > > I have Solr with the examples working correctly and now I would like to > > load > > the data from a MySQL database using php. > > Is the best way to do this to write a php script that get the info from > the > > MySQL and then generates an XML document to load into Solr? Is there a > > maximum size for this XML document? My MySQL database is quite big... > > > > Any help, book or internet tutorial you know will be really appreciated. > > > > Thank you! > > > > Pablo > > >
Re: Adding docs from MySQL and php
wow, it looks like DIH already works with relational databases... thanks again! 2009/9/1 Pablo Ferrari > Thanks Aakash! > > I've looked at it and it looks very interesting, the problem is that my > database is a relational model, therefore I don't have a table with all the > information, but many tables related to each other by their ids (primary > keys and foreign keys). > > I've been thinking about using DataImportHandler in any of this two ways: > - Write a script that creates a table with all the information I need for > searching (it is not very efficient because of duplicate data) > - Configure DataImportHandler with some JOIN SQL statement > > I'll let you know how I did, thanks again! > > Pablo > > 2009/9/1 Aakash Dharmadhikari > > hi Pablo, >> >> DataImportHandler might be the best option for you. check this link >> http://wiki.apache.org/solr/DataImportHandler >> >> regards, >> aakash >> >> On Tue, Sep 1, 2009 at 9:18 PM, Pablo Ferrari > >wrote: >> >> > Hello all, >> > >> > I'm new to the list and new to Solr. My name is Pablo, I'm from Spain >> and >> > I'm developing a web site using Solr. >> > >> > I have Solr with the examples working correctly and now I would like to >> > load >> > the data from a MySQL database using php. >> > Is the best way to do this to write a php script that get the info from >> the >> > MySQL and then generates an XML document to load into Solr? Is there a >> > maximum size for this XML document? My MySQL database is quite big... >> > >> > Any help, book or internet tutorial you know will be really appreciated. >> > >> > Thank you! >> > >> > Pablo >> > >> > >
PhP, Solr and Delta Imports
Hello, I have an already working Solr service based un full imports connected via php to a Zend Framework MVC (I connect it directly to the Controller). I use the SolrClient class for php which is great: http://www.php.net/manual/en/class.solrclient.php For now on, every time I want to edit a document I have to do a full import again or I can delete the document by its id and add it again with the updated info... Anyone can guide me a bit in how to do delta imports? If its via php, better! Thanks in advance, Pablo Ferrari Tinkerlabs.net
Control DIH from PHP
Hello! After been working in Solr documents updates using direct php code (using SolrClient class) I want to use the DIH (Data Import Handler) to update my documents. Any one knows how can I send commands to the DIH from php? Any idea or tutorial will be of great help because I'm not finding anything useful so far. Thank you for you time! Pablo Tinkerlabs
Re: Control DIH from PHP
Most specificly, I'm looking to update only one document using it's Unique ID: I dont want the DIH to lookup the whole database because I already know the Unique ID that has changed. Pablo 2009/11/19 Pablo Ferrari > > > Hello! > > After been working in Solr documents updates using direct php code (using > SolrClient class) I want to use the DIH (Data Import Handler) to update my > documents. > > Any one knows how can I send commands to the DIH from php? Any idea or > tutorial will be of great help because I'm not finding anything useful so > far. > > Thank you for you time! > > Pablo > Tinkerlabs >
Re: Control DIH from PHP
Thankyou 2009/11/21 Lance Norskog > Nice! I didn't notice that before. Very useful. > > 2009/11/19 Noble Paul നോബിള് नोब्ळ् : > > you can pass the uniqueId as a param and use it in a sql query > > > http://wiki.apache.org/solr/DataImportHandler#Accessing_request_parameters > . > > --Noble > > > > On Thu, Nov 19, 2009 at 3:53 PM, Pablo Ferrari > wrote: > >> Most specificly, I'm looking to update only one document using it's > Unique > >> ID: I dont want the DIH to lookup the whole database because I already > know > >> the Unique ID that has changed. > >> > >> Pablo > >> > >> 2009/11/19 Pablo Ferrari > >> > >>> > >>> > >>> Hello! > >>> > >>> After been working in Solr documents updates using direct php code > (using > >>> SolrClient class) I want to use the DIH (Data Import Handler) to update > my > >>> documents. > >>> > >>> Any one knows how can I send commands to the DIH from php? Any idea or > >>> tutorial will be of great help because I'm not finding anything useful > so > >>> far. > >>> > >>> Thank you for you time! > >>> > >>> Pablo > >>> Tinkerlabs > >>> > >> > > > > > > > > -- > > - > > Noble Paul | Principal Engineer| AOL | http://aol.com > > > > > > -- > Lance Norskog > goks...@gmail.com >