Skip to content

Spring Boot application for import/export data in csv format using OpenCSV

License

Notifications You must be signed in to change notification settings

yildizmy/import-export-data-using-open-csv

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

64 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Export Data as CSV using OpenCSV

Project used for exporting data as csv file using OpenCSV.

Description

Employee list can be populated by using employees_request.json file and corresponding endpoint.

Spring Boot provides some properties with which we can add the exception message, exception class, or even a stack trace as part of the response payload:

server.error.include-message=always
server.error.include-binding-errors=always
server.error.include-stacktrace=on_param
server.error.include-exception=false

Using these Spring Boot server properties in our application.properties we can alter the error response to some extent.

Note that we’ve set the property include-stacktracee to on_trace_param which means that only if we include the trace param in the URL (?trace=true), we’ll get a stack trace in the response payload:

We might want to keep the value of include-stacktrace flag to never, at least in production, as it might reveal the internal workings of our application.

Getting Started

Dependencies

  • Spring Web
  • Spring Boot
  • Spring Data JPA
  • OpenCSV
  • H2 Database

Installing

  • Database connection url for DBeaver, etc.
jdbc:h2:tcp://localhost:9092/mem:employee-db

API Endpoints

All URIs are relative to http://localhost:8080/api/v1

Class Method HTTP request Description
EmployeeController create POST /employees Create an employee
EmployeeController createFromFile POST /employees/{fileName:.+} Create employees from given JSON file
EmployeeController importFromCsv POST /employees/import/{fileName:.+} Import employees from given CSV file
EmployeeController exportToCsv GET /employees/export/{fileName:.+} Export employees to CSV file
EmployeeController findByEmail GET /employees/{email} Get employee by email
EmployeeController findAll GET /employees Get all employees
EmployeeController deleteById DELETE /employees/{id} Delete employee by id
EmployeeController deleteAll DELETE /employees Delete all employees

Documentation

Access a File from the Classpath in a Spring Application

Authors

Murat Yıldız

Version History

License

...

Acknowledgements

...

About

Spring Boot application for import/export data in csv format using OpenCSV

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages