Hi Guys - can anyone suggest how to achieve this? I have understood how to insert json documents. So one alternative that comes to my mind is that I can convert the rows in my excel to json format with the header of my excel file becoming the json keys (corresponding to the fields I have defined in my managed-schema.xml). And then each cell in the excel file will become the value of this field.
However, I am sure there must be a better way and directly ingesting the excel file to achieve the same. I was trying to reach about DIH and Apache Tika, but I am not very sure of how the configuration works. My sample excel file has 4 columns namely - 1. First Name 2. Last Name 3. Phone 4. Website Link I want to index these fields into SOLR in a way that all these columns become my solr schema fields and later I can search based on these fields. Any suggestions please. thanks !
