Write query result from twitter4j into csv using opencsv

Question

I'm using twitter4j to extract tweets from twitter. After i use this line i get a json result:

QueryResult result = twitter.search(query);

I want to know how to use opencsv to write this into csv. writeAll() is only for List or result set, I want to know what i can do with my query result. Many thanks!

Jean Logeart · Answer 1 · 2013-06-28T08:18:44.050

0

You need to first create a List<String> from the tweets and then only you can write it using CSVWriter:

List<String[]> lines = new ArrayList<>(result.getTweets().size());
for(Status status : result.getTweets()) {
    lines.add(new String[] { status.getText() });
}
// write the lines using CSVWriter

edited Jun 28 '13 at 08:18

answered Jun 28 '13 at 08:11

Jean Logeart

52,687
11
83
118

Jonathan · Accepted Answer · 2013-06-28T09:11:36.047

0

I don't think you can use writeAll() directly, as you'll need to build a List<String[]> beforehand.

Alternatively you could use CSVWriter#writeNext(String[]) to write individual Tweets whilst iterating through QueryResult#getTweets(), for example:

for (final Status status : result.getTweets())
{
    final String[] line = new String[] { Long.toString(status.getId()), status.getText(), ... };
    writer.writeLine(line);
}

edited Jun 28 '13 at 09:11

answered Jun 28 '13 at 08:14

Jonathan

20,053
6
63
70

Thanks, but status.getId() is Long, how can I change to String? – user2481451 Jun 28 '13 at 08:54
Cannot invoke toString() on the primitive type long – user2481451 Jun 28 '13 at 09:07
@user2481451 Sorry thought you said `Long` and not `long`, see updated answer. – Jonathan Jun 28 '13 at 09:11

Write query result from twitter4j into csv using opencsv

2 Answers2