lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yonik Seeley (JIRA)" <j...@apache.org>
Subject [jira] Commented: (SOLR-1925) CSV Response Writer
Date Thu, 15 Jul 2010 14:50:50 GMT

    [ https://issues.apache.org/jira/browse/SOLR-1925?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12888817#action_12888817
] 

Yonik Seeley commented on SOLR-1925:
------------------------------------

I tried excel 2003 and excel 2007 - both work fine with embedded newlines.  Perhaps you're
not encoding your test file correctly.

> > AFAIK, the CSV spec doesn't recommend always using encapsulators.
> See here: http://en.wikipedia.org/wiki/Comma-separated_values, 1st Paragraph:
> Fields that contain a special character (comma, newline, or double quote), must be enclosed
in double quotes.

I'll repeat: "the CSV spec doesn't recommend always using encapsulators".  Why do you keep
suggesting that it does?

> > If we do things correctly, we should be able to round-trip with http://wiki.apache.org/solr/UpdateCSV
> What's your rationale that this isn't compatible with that? Have you tried it? 

I didn't need to try it... I just looked at this patch, which doesn't do proper CSV encoding/escaping.

> What's the host-independent way to do System.getProperty("line.separator")?

You pick one (like \n)... if there is a need for a different one, you let it be configured
/ specified by the client.

> CSV Response Writer
> -------------------
>
>                 Key: SOLR-1925
>                 URL: https://issues.apache.org/jira/browse/SOLR-1925
>             Project: Solr
>          Issue Type: New Feature
>          Components: Response Writers
>         Environment: indep. of env.
>            Reporter: Chris A. Mattmann
>            Assignee: Erik Hatcher
>             Fix For: Next
>
>         Attachments: SOLR-1925.Chheng.071410.patch.txt, SOLR-1925.Mattmann.053010.patch.2.txt,
SOLR-1925.Mattmann.053010.patch.3.txt, SOLR-1925.Mattmann.053010.patch.txt, SOLR-1925.Mattmann.061110.patch.txt
>
>
> As part of some work I'm doing, I put together a CSV Response Writer. It currently takes
all the docs resultant from a query and then outputs their metadata in simple CSV format.
The use of a delimeter is configurable (by default if there are multiple values for a particular
field they are separated with a | symbol).

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org


Mime
View raw message