XLSX Response Writer

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

XLSX Response Writer

Lewin Joy (TMNA)
Hi,

How do I use the xlsx response writer to extract my results to an excel file?

I made the changes as per documentation to include the jars and gave wt=xlsx. It did not work.
Would this only work with solrJ? Can't we use this in the query parameter &wt=xlsx?

cp contrib/extraction/lib/*.jar server/solr-webapp/webapp/WEB-INF/lib/
cp dist/solr-cell-6.3.0.jar server/solr-webapp/webapp/WEB-INF/lib/


Thanks,
Lewin
Reply | Threaded
Open this post in threaded view
|

Re: XLSX Response Writer

Jörn Franke
Which Solr version are you using?
The below command suggest you are using 6.3 - is this correct?

Have you restarted the Solr server after copying?

> Am 08.11.2019 um 18:42 schrieb Lewin Joy (TMNA) <[hidden email]>:
>
> Hi,
>
> How do I use the xlsx response writer to extract my results to an excel file?
>
> I made the changes as per documentation to include the jars and gave wt=xlsx. It did not work.
> Would this only work with solrJ? Can't we use this in the query parameter &wt=xlsx?
>
> cp contrib/extraction/lib/*.jar server/solr-webapp/webapp/WEB-INF/lib/
> cp dist/solr-cell-6.3.0.jar server/solr-webapp/webapp/WEB-INF/lib/
>
>
> Thanks,
> Lewin
Reply | Threaded
Open this post in threaded view
|

RE: [EXTERNAL] Re: XLSX Response Writer

Lewin Joy (TMNA)
Hi Jorn,

I am using Solr version 7.1

Correction on the change that I did. I just added the jars in my solrconfig.xml file as below:
       
        <lib dir="${solr.install.dir:../../../..}/contrib/extraction/lib" regex=".*\.jar" />
        <lib dir="${solr.install.dir:../../../..}/dist/" regex="solr-cell-\d.*\.jar" />

The cp command was the steps I saw in the reference guide.
I figured it should be the same thing.

-Lewin

-----Original Message-----
From: Jörn Franke <[hidden email]>
Sent: Friday, November 8, 2019 11:51 AM
To: [hidden email]
Subject: [EXTERNAL] Re: XLSX Response Writer

Which Solr version are you using?
The below command suggest you are using 6.3 - is this correct?

Have you restarted the Solr server after copying?

> Am 08.11.2019 um 18:42 schrieb Lewin Joy (TMNA) <[hidden email]>:
>
> Hi,
>
> How do I use the xlsx response writer to extract my results to an excel file?
>
> I made the changes as per documentation to include the jars and gave wt=xlsx. It did not work.
> Would this only work with solrJ? Can't we use this in the query parameter &wt=xlsx?
>
> cp contrib/extraction/lib/*.jar server/solr-webapp/webapp/WEB-INF/lib/
> cp dist/solr-cell-6.3.0.jar server/solr-webapp/webapp/WEB-INF/lib/
>
>
> Thanks,
> Lewin
Reply | Threaded
Open this post in threaded view
|

Re: [EXTERNAL] Re: XLSX Response Writer

Jan Høydahl / Cominvent
It is not the same thing. Instead of adding those lib lines to solr config you should copy the jars as it says in refguide, then restart solr. I think you can get trouble if you do it both ways.

Jan Høydahl

> 8. nov. 2019 kl. 18:59 skrev Lewin Joy (TMNA) <[hidden email]>:
>
> Hi Jorn,
>
> I am using Solr version 7.1
>
> Correction on the change that I did. I just added the jars in my solrconfig.xml file as below:
>    
>    <lib dir="${solr.install.dir:../../../..}/contrib/extraction/lib" regex=".*\.jar" />
>    <lib dir="${solr.install.dir:../../../..}/dist/" regex="solr-cell-\d.*\.jar" />
>
> The cp command was the steps I saw in the reference guide.
> I figured it should be the same thing.
>
> -Lewin
>
> -----Original Message-----
> From: Jörn Franke <[hidden email]>
> Sent: Friday, November 8, 2019 11:51 AM
> To: [hidden email]
> Subject: [EXTERNAL] Re: XLSX Response Writer
>
> Which Solr version are you using?
> The below command suggest you are using 6.3 - is this correct?
>
> Have you restarted the Solr server after copying?
>
>> Am 08.11.2019 um 18:42 schrieb Lewin Joy (TMNA) <[hidden email]>:
>>
>> Hi,
>>
>> How do I use the xlsx response writer to extract my results to an excel file?
>>
>> I made the changes as per documentation to include the jars and gave wt=xlsx. It did not work.
>> Would this only work with solrJ? Can't we use this in the query parameter &wt=xlsx?
>>
>> cp contrib/extraction/lib/*.jar server/solr-webapp/webapp/WEB-INF/lib/
>> cp dist/solr-cell-6.3.0.jar server/solr-webapp/webapp/WEB-INF/lib/
>>
>>
>> Thanks,
>> Lewin
Reply | Threaded
Open this post in threaded view
|

RE: [EXTERNAL] Re: XLSX Response Writer

Lewin Joy (TMNA)
Wow. This works. Thank you, Jan.

-Lewin

-----Original Message-----
From: Jan Høydahl <[hidden email]>
Sent: Saturday, November 9, 2019 2:21 PM
To: [hidden email]
Subject: Re: [EXTERNAL] Re: XLSX Response Writer

It is not the same thing. Instead of adding those lib lines to solr config you should copy the jars as it says in refguide, then restart solr. I think you can get trouble if you do it both ways.

Jan Høydahl

> 8. nov. 2019 kl. 18:59 skrev Lewin Joy (TMNA) <[hidden email]>:
>
> Hi Jorn,
>
> I am using Solr version 7.1
>
> Correction on the change that I did. I just added the jars in my solrconfig.xml file as below:
>    
>    <lib dir="${solr.install.dir:../../../..}/contrib/extraction/lib" regex=".*\.jar" />
>    <lib dir="${solr.install.dir:../../../..}/dist/" regex="solr-cell-\d.*\.jar" />
>
> The cp command was the steps I saw in the reference guide.
> I figured it should be the same thing.
>
> -Lewin
>
> -----Original Message-----
> From: Jörn Franke <[hidden email]>
> Sent: Friday, November 8, 2019 11:51 AM
> To: [hidden email]
> Subject: [EXTERNAL] Re: XLSX Response Writer
>
> Which Solr version are you using?
> The below command suggest you are using 6.3 - is this correct?
>
> Have you restarted the Solr server after copying?
>
>> Am 08.11.2019 um 18:42 schrieb Lewin Joy (TMNA) <[hidden email]>:
>>
>> Hi,
>>
>> How do I use the xlsx response writer to extract my results to an excel file?
>>
>> I made the changes as per documentation to include the jars and gave wt=xlsx. It did not work.
>> Would this only work with solrJ? Can't we use this in the query parameter &wt=xlsx?
>>
>> cp contrib/extraction/lib/*.jar server/solr-webapp/webapp/WEB-INF/lib/
>> cp dist/solr-cell-6.3.0.jar server/solr-webapp/webapp/WEB-INF/lib/
>>
>>
>> Thanks,
>> Lewin