Importing and Indexing .CSV file in solr

-
1) Download the latest version of Apache Solr from the following location:http://lucene.apache.org/solr/downloads.html

2) Once the Solr zip file is downloaded unzip it into "C:\\Program Files" folder. The extracted folder will contain few subfolders such as bin, Contrib , dust, docs, example, license, server etc.

3) Now open command prompt in administrative mode and goto bin directory of solr to start it.Ex:- C:\Program Files\solr-6.0.0\bin > solr start And to stop solr C:\Program Files\solr-6.0.0\bin > solr stop -all

4) Now its time to create Core-Admin to import, index, and search data. For that we have to use the following commands.
Ex:- C:\Program Files\solr-6.0.0\bin >solr create -c jcg -d basic_configs

5) We can see the following output in the command window.Creating new core 'jcg' using command:
http://localhost:8983/solr/admin/cores?action=CREATE&name=jcg&instanceDir=jcg
{ "responseHeader":{ "status":0, "QTime":663}, "core":"jcg"}

6) Now we navigate to the following URL and we can see CoreAdmin(jcg) core being populated in the core selector. You can also see the statistics of the core.

7) http://localhost:8983/solr

8) We have created CoreAdmin along with this we got two more folders inside the core folder named as "Conf" and "Data". So the "Conf " folder contains some important files like Solrconfig.xml and ManagedSchema.xml.

9) Solrconfig.xml => Contains "Data Import handler" to index .csv file(otherwise we have to add in it).Ex:- <requestHandler name="/update" class="solr.UpdateRequestHandler"/>Or some other handlers(Mandatory)

10) ManagedSchema.xml => we have to add "fields"(Column name) in it to index .csv file.(Mandatory){ Note:- Whatever the fields you are adding it must be match with .csv file column name with its type like int, string etc(compatible type) }

Ex:-  <uniqueKey>id</uniqueKey>
<!-- Fields added for books.csv load-->
 <field name="cat" type="text_general" indexed="true" stored="true"/>
{ Note :- If there is no "id" field in .csv file then delete <uniqueKey>id</uniqueKey> and <field name="id" type="string"........../> from managedschema.xml file}

11) Add .csv file into example/example docs folder

12) Now stop the solr and start again.

13) Execute the following commmand to index .csv file.
Ex:-C:\ProgramFiles\solr-6.0.0\example\exampledocs > java -Dtype=text/csv -Dc=CoreAdminname -jar post.jar filename.csv

14) It will index your .csv file now goto query panel and search

Comments

Post a Comment

Popular posts from this blog

How to Transpose DataTable in C# ?

-
In this article we are going to see, How to transpose DataTable in C#? It means we are going to convert DataRow into DataColumn and DataColumn intoDataRow.Following is the simple and self-explanatory example in the form of code comment. Code Snippet:- using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Text; using System.Threading.Tasks; namespace BlogsProgram { public class TansposeDataTableClass { public void TransposeDataTable() { // Defined Table as "Employee". DataTable dt = new DataTable("Employee"); // Defined "EmpID" column as Integer Datatype. dt.Columns.Add("EmpID", typeof(Int32)); // Defined "EmpName" column as String Datatype. dt.Columns.Add("EmpName", typeof(string)); // Defined "EmpRank" column as String Datatype. dt.Columns.Add(...
Read more

Multiple Inheritance in C#

-
In this article we are going to see, Inheritance in C#. So, What is an Inheritance in C#? An Inheritance is a concept or approach where one type can be derived from other types Just like a son gets his DNA from his parents. In c#, we can derive a type from other types. So the child type can inherit its parent type members such as Methods, Property, etc. Now, we will see Multiple Inheritance where a class can derive from more than one type. But for that, a class has to derive from Interfaces. Because Interfaces supports multiple Inheritance, a normal class derived from only one Class and multiple interfaces. (Type means Classes, Interfaces, and Abstract classes)Following is a simple program to understand it. Code Snippet:- public interface Interface1 { /// <summary> /// Abstract method declaration /// </summary> /// <param name="_input"></param> void WhatUgot(int _input); } public interface Interface2 { /// <summary> /// Abstract...
Read more

Process Template Editor Extension Tool in Visual Studio Integration Tutorial

-
 1) Download and install Process Template Editor Tool Extention from Visual Studio Extention Menu option or we could refer to the below URL... https://marketplace.visualstudio.com/items?itemName=ms-devlabs.msdevlabs-pte 2) Once you installed it please restart the VisualStudio and go to the menu option "Tool". 3) Here we will be able to see the "Process Editor" option (If not then it's not installed correctly). 4) Now Select the "Global List" option which will give again multiple sub-options 5) Select sub-option "Open Global List from Server" (We need to fetch data from connected TFS sever). 6) Connect to the desired server location and ok, You will get all the folders and branches Tree graph. 7) Now expand the desired folder or branch and create a new "Node" or "item", example:- "Release 10.1" 8) Now go to your TFS web dashboard where you manage all the tasks ex:- URL:- http://......(TFS server address.) 9) Now t...
Read more