directly convert CSV file to JSON file using the Jackson library

by

I think, you should use MappingIterator to solve your problem. See below example:

import java.io.File;
import java.io.IOException;
import java.util.List;
import java.util.Map;

import com.fasterxml.jackson.databind.MappingIterator;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.fasterxml.jackson.dataformat.csv.CsvMapper;
import com.fasterxml.jackson.dataformat.csv.CsvSchema;

public class JacksonProgram {

    public static void main(String[] args) throws Exception {
        File input = new File("/x/data.csv");
        File output = new File("/x/data.json");

        List<Map<?, ?>> data = readObjectsFromCsv(input);
        writeAsJson(data, output);
    }

    public static List<Map<?, ?>> readObjectsFromCsv(File file) throws IOException {
        CsvSchema bootstrap = CsvSchema.emptySchema().withHeader();
        CsvMapper csvMapper = new CsvMapper();
        try (MappingIterator<Map<?, ?>> mappingIterator = csvMapper.readerFor(Map.class).with(bootstrap).readValues(file)) {
            return mappingIterator.readAll();
        }
    }

    public static void writeAsJson(List<Map<?, ?>> data, File file) throws IOException {
        ObjectMapper mapper = new ObjectMapper();
        mapper.writeValue(file, data);
    }
}

See this page: jackson-dataformat-csv for more information and examples.

More Related Contents:

  1. Ignoring new fields on JSON objects using Jackson [duplicate]
  2. Only using @JsonIgnore during serialization, but not deserialization
  3. How can I include raw JSON in an object using Jackson?
  4. Jackson Vs. Gson [closed]
  5. Jackson and generic type reference
  6. Serializing with Jackson (JSON) – getting “No serializer found”?
  7. Convert JSON String to Pretty Print JSON output using Jackson
  8. Converting JSON to XLS/CSV in Java [closed]
  9. Why when a constructor is annotated with @JsonCreator, its arguments must be annotated with @JsonProperty?
  10. How can I tell jackson to ignore a property for which I don’t have control over the source code?
  11. Why I’m not able to unwrap and serialize a Java map using the Jackson Java library?
  12. Java: Jackson polymorphic JSON deserialization of an object with an interface property?
  13. Jackson dynamic property names
  14. JSON consumer of polymorphic objects
  15. How to serialize only the ID of a child with Jackson
  16. Jackson custom serialization and deserialization
  17. Issue with parsing the content from JSON file with Jackson & message- JsonMappingException -Cannot deserialize as out of START_ARRAY token
  18. Jackson JSON library: how to instantiate a class that contains abstract fields
  19. How to produce JSON output with Jersey 1.6 using JAXB
  20. Jackson deserialization with unknown dynamic properties
  21. Jackson – deserialize inner list of objects to list of one higher level
  22. Merging Two JSON Documents Using Jackson
  23. Use class name as root key for JSON Jackson serialization
  24. How to deserialize a blank JSON string value to null for java.lang.String?
  25. Jackson parse json with unwraping root, but without ability to set @JsonRootName
  26. Jackson list deserialization. nested Lists
  27. Custom Jackson Serializer for a specific type in a particular class
  28. JSON Jackson parse different keys into same field
  29. Jackson JSON Deserialization: array elements in each line
  30. How to prevent null values inside a Map and null fields inside a bean from getting serialized through Jackson

Leave a Comment