You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Phil Scadden <P....@gns.cri.nz> on 2017/06/15 02:13:28 UTC

CSV output

If I try
/getsolr? fl=id,title,datasource,score&hl=true&hl.maxAnalyzedChars=90000000&hl.method=unified&q=Wainui-1&q.op=AND&wt=csv

The response I get is:
id,title,datasource,scoreW:\PR_Reports\OCR\PR869.pdf,,Petroleum Reports,8.233313W:\PR_Reports\OCR\PR3440.pdf,,Petroleum Reports,8.217836W:\PR_Reports\OCR\PR4313.pdf,,Petroleum Reports,8.206703W:\PR_Reports\OCR\PR3906.pdf,,Petroleum Reports,8.185147W:\PR_Reports\OCR\PR1592.pdf,,Petroleum Reports,8.167614W:\PR_Reports\OCR\PR998.pdf,,Petroleum Reports,8.161142W:\PR_Reports\OCR\PR2457.pdf,,Petroleum Reports,8.155497W:\PR_Reports\OCR\PR2433.pdf,,Petroleum Reports,8.152924W:\PR_Reports\OCR\PR1184.pdf,,Petroleum Reports,8.124402W:\PR_Reports\OCR\PR3551.pdf,,Petroleum Reports,8.124402

ie no newline separators at all (Solr 6.5.1) (/getsolr is api that proxy to the solr server).
Changing it to
/getsolr?csv.newline=%0A&fl=id,title,datasource,score&hl=true&hl.maxAnalyzedChars=90000000&hl.method=unified&q=Wainui-1&q.op=AND&wt=csv

Makes no difference. What I am doing wrong here? Is there another way to specify csv parameters? It says default is \n but I am not seeing that.

Notice: This email and any attachments are confidential and may not be used, published or redistributed without the prior written consent of the Institute of Geological and Nuclear Sciences Limited (GNS Science). If received in error please destroy and immediately notify GNS Science. Do not copy or disclose the contents.

RE: CSV output

Posted by Phil Scadden <P....@gns.cri.nz>.
Embarassing. Yes, it was the proxy. Very old code that has now had a considerable refresh.

-----Original Message-----
From: Erik Hatcher [mailto:erik.hatcher@gmail.com]
Sent: Thursday, 15 June 2017 7:13 p.m.
To: solr-user@lucene.apache.org
Subject: Re: CSV output

Is it the proxy affecting the output?    What do you get going directly to Solr's endpoint?

   Erik

> On Jun 14, 2017, at 22:13, Phil Scadden <P....@gns.cri.nz> wrote:
>
> If I try
> /getsolr? fl=id,title,datasource,score&hl=true&hl.maxAnalyzedChars=90000000&hl.method=unified&q=Wainui-1&q.op=AND&wt=csv
>
> The response I get is:
> id,title,datasource,scoreW:\PR_Reports\OCR\PR869.pdf,,Petroleum Reports,8.233313W:\PR_Reports\OCR\PR3440.pdf,,Petroleum Reports,8.217836W:\PR_Reports\OCR\PR4313.pdf,,Petroleum Reports,8.206703W:\PR_Reports\OCR\PR3906.pdf,,Petroleum Reports,8.185147W:\PR_Reports\OCR\PR1592.pdf,,Petroleum Reports,8.167614W:\PR_Reports\OCR\PR998.pdf,,Petroleum Reports,8.161142W:\PR_Reports\OCR\PR2457.pdf,,Petroleum Reports,8.155497W:\PR_Reports\OCR\PR2433.pdf,,Petroleum Reports,8.152924W:\PR_Reports\OCR\PR1184.pdf,,Petroleum Reports,8.124402W:\PR_Reports\OCR\PR3551.pdf,,Petroleum Reports,8.124402
>
> ie no newline separators at all (Solr 6.5.1) (/getsolr is api that proxy to the solr server).
> Changing it to
> /getsolr?csv.newline=%0A&fl=id,title,datasource,score&hl=true&hl.maxAnalyzedChars=90000000&hl.method=unified&q=Wainui-1&q.op=AND&wt=csv
>
> Makes no difference. What I am doing wrong here? Is there another way to specify csv parameters? It says default is \n but I am not seeing that.
>
> Notice: This email and any attachments are confidential and may not be used, published or redistributed without the prior written consent of the Institute of Geological and Nuclear Sciences Limited (GNS Science). If received in error please destroy and immediately notify GNS Science. Do not copy or disclose the contents.
Notice: This email and any attachments are confidential and may not be used, published or redistributed without the prior written consent of the Institute of Geological and Nuclear Sciences Limited (GNS Science). If received in error please destroy and immediately notify GNS Science. Do not copy or disclose the contents.

Re: CSV output

Posted by Erik Hatcher <er...@gmail.com>.
Is it the proxy affecting the output?    What do you get going directly to Solr's endpoint?

   Erik

> On Jun 14, 2017, at 22:13, Phil Scadden <P....@gns.cri.nz> wrote:
> 
> If I try
> /getsolr? fl=id,title,datasource,score&hl=true&hl.maxAnalyzedChars=90000000&hl.method=unified&q=Wainui-1&q.op=AND&wt=csv
> 
> The response I get is:
> id,title,datasource,scoreW:\PR_Reports\OCR\PR869.pdf,,Petroleum Reports,8.233313W:\PR_Reports\OCR\PR3440.pdf,,Petroleum Reports,8.217836W:\PR_Reports\OCR\PR4313.pdf,,Petroleum Reports,8.206703W:\PR_Reports\OCR\PR3906.pdf,,Petroleum Reports,8.185147W:\PR_Reports\OCR\PR1592.pdf,,Petroleum Reports,8.167614W:\PR_Reports\OCR\PR998.pdf,,Petroleum Reports,8.161142W:\PR_Reports\OCR\PR2457.pdf,,Petroleum Reports,8.155497W:\PR_Reports\OCR\PR2433.pdf,,Petroleum Reports,8.152924W:\PR_Reports\OCR\PR1184.pdf,,Petroleum Reports,8.124402W:\PR_Reports\OCR\PR3551.pdf,,Petroleum Reports,8.124402
> 
> ie no newline separators at all (Solr 6.5.1) (/getsolr is api that proxy to the solr server).
> Changing it to
> /getsolr?csv.newline=%0A&fl=id,title,datasource,score&hl=true&hl.maxAnalyzedChars=90000000&hl.method=unified&q=Wainui-1&q.op=AND&wt=csv
> 
> Makes no difference. What I am doing wrong here? Is there another way to specify csv parameters? It says default is \n but I am not seeing that.
> 
> Notice: This email and any attachments are confidential and may not be used, published or redistributed without the prior written consent of the Institute of Geological and Nuclear Sciences Limited (GNS Science). If received in error please destroy and immediately notify GNS Science. Do not copy or disclose the contents.