Stack Overflow
Stack Overflow

Questions tagged [csvreader]

A CsvReader represents a reader that provides forward-only access to a CSV text data source. A CsvReader may also support other delimited-separator formats.

172 questions
1
vote
1 answer

jOOQ - Seeking suggestion regarding fast insertion from CSV

I am using below code to insert records from a large csv (100,000 records) in Oracle using jOOQ. Here's the snippet: CSVReader csvReader = null; String csvError; try { csvReader = new CSVReader(new FileReader(tempFile)); } catch…
Anmol Deora
  • 41
  • 6
1
vote
1 answer

How to read CSV and parse JSON using java code

I am using the following code to read the CSV file and parse its data to JSON. File inputFile = new File("in.csv"); File outputFile = new File("out.json"); CsvSchema csvSchema =…
Lily
  • 605
  • 3
  • 15
  • 31
1
vote
1 answer

How to append and item to the last appended item in a list with a for loop

I have a for loop that goes over each row in a CSV and I create a dictionary that has a list in it, but the list gets overridden because the dictionary key is repeated several times. How do I sum up or append to the list in the second(1) position…
Heijs7
  • 27
  • 6
1
vote
0 answers

_csv.Error: field larger than field limit (131072) but my table has only 2 columns

My CSV file has only two columns, but it reports when it uses csv_reader to load the data: _csv.Error: field larger than field limit (131072) Each row only has two columns, delimited by tab key. Does the 'fields' mean the same as 'columns' of the…
ling
  • 1,555
  • 3
  • 18
  • 24
0
votes
1 answer

Read two columns by header from csv file using java 8

I want to read two columns (col5 and col7) from csv file by header. With below code I can read only one column header (col5). Is there any way to read two columns in the same map itself. Why I choose map is I need to process data later. public…
Selenium New bie
  • 35
  • 5
0
votes
2 answers

How to specify a custom DateOnly format with CsvReader?

I need to read a CSV file using CsvReader, however I have a custom date format (yyyyMMdd) which by default can't be converted to DateOnly. How can I specify this custom date format? Is that may possible using some annotation? This is the code I…
stefan.at.kotlin
  • 15,347
  • 38
  • 147
  • 270
0
votes
1 answer

CSV Reader is throwing exception "Unable to read data from the transport connection. An existing connection was forcibly closed by the remote host"

I am trying to read a very large csv file from s3 bucket of row size 100000 each. I am using yield return to return the object when the specific row count is achieved. Then, I'm processing the data and fetching again, then it throws the exception. I…
Indranil Saha
  • 1
0
votes
0 answers

The Chatbot I created is not displaying user input prompts and results on it. It shows in the cmd though

I created a retrieval Chatbot which works fine with a json file.. The challenge I'm having is retrieving values from a csv file. For example a user wants to retrieve rows/columns with a particular heading. They are supposed to enter a numerical…
Qoshawa
  • 1
  • 1
0
votes
0 answers

Sylvan.Data.Csv - Trouble using SQL Server table Schema

I am attempting to use Sylvan.Data.Csv.dll in PowerShell to load multi-GB CSV files into SQL Server and have run into an issue around using the SQL Server destination table for the column schema source. Hoping someone can see what I'm missing and…
MrAC
  • 13
  • 4
0
votes
1 answer

Extracting Strings from CSV file using Java CSVReader messes up German Umlaute (ö,ä,ü,...)

I'm extracting German addresses from a CSV file using Java CsvReader. Some of the street names have special German characters, also called "Umlaute", like ö,ä,ü,... (Example: Sonnige Höhe). Here is the code I use: try { String…
Robert Bethge
  • 145
  • 1
  • 7
0
votes
1 answer

TypeError - read csv functionality

I am getting a Type error when reading a csv file with a bell character as a separator. I don't want to use the pandas and need to utilize the csv libraries for this issue. Sample header: ["header1", "header2", "header3"] Data types [integer,…
Harish
  • 565
  • 1
  • 12
  • 34
0
votes
0 answers

Error Read CSV file java.io.FileNotFoundException

in my spring boot application I have created a REST API POST method that read a file csv in a folder and than save on db in this way: @Override public ResponseList updateDataFromCSV(CsvDataInputBean csvDataInputBean) throws…
guidop21
  • 177
  • 3
  • 15
0
votes
1 answer

Reactive way to process a zipped CSV file with CSVReader

This is a follow-up question to this: How to convert a Flux to a Mono with multiple counters I found out that the problem lies with the CSVReader in this context. For some reason it does not properly create a Flux from it to be processed. This…
Thomas
  • 6,325
  • 4
  • 30
  • 65
0
votes
0 answers

How to insert value into specific column in csv file using java

I want write multiple xml file data into one csv file, For first time writing data from first xml into csv file 8 columns created and for second xml file data writing into from 9th column of same csv file, How can we insert the data into specific…
Mahi Mokhashi
  • 5
  • 3
0
votes
0 answers

ClassNotFoundException while importing library in eclipse

I am trying to use the opencsv library in Eclipse for a Java project. I downloaded opencsv-5.7.1.jar from here and added it under "referenced libraries" in my project folder. When I run the program, I'm getting a NoClassDefFoundError for CSVReader.…
harrisonoly
  • 1
  • 1
1 2 3
…
11 12