1

I'm running some tests in Jenkins which will produce CSV report files. So, I need to store the CSV results into Mysql database to query them for my future use. Any of you have any idea that how we can save the CSV data into a database from Jenkins. Is there any plugin for that? If it is not possible with Jenkins can we do that through any java program to pick up a CSV file from a particular location and parse the results to a database which can be run or build using Jenkins I searched throughout the internet but couldn't find anything. Please help me with this. Thanks in advance.

krish
  • 349
  • 3
  • 17
  • 2
    you can use this http://stackoverflow.com/questions/3635166/how-to-import-csv-file-to-mysql-table it is not jenkins but will help you – shreyansh jogi Jan 27 '17 at 14:24
  • @shreyanshjogi I saw that yesterday, but I don't need a tool. I just need to automate the stuff so my task is to populate the CSV data into Mysql through a Jenkins job – krish Jan 27 '17 at 14:36
  • 1
    Then you need to write code which can read your file and insert into database. Once that code is written that you can configure that job in jenkins and just run that. – shreyansh jogi Jan 27 '17 at 14:39
  • 1
    Yup. I'm thinking about that as well. But just want to know if there is any other alternative process which can be done through a Jenkins plugin – krish Jan 27 '17 at 14:40
  • Could you post an example of the CSV file? – Stefan Crain Jan 27 '17 at 14:49

0 Answers0