Re: Reading CSV or Excel files in java and mapping values to database columns
On Jun 20, 10:42 am, "delcas2...@gmail.com" <delcas2...@gmail.com>
wrote:
Dear colleagues,
I am looking for a free and simple mechanism for reading data from
files (could be CSV or XLS ) and inserting values that are read into a
database. I know that I could import a csv/xls file directly from a
database, but this is different. There is a Document Management
System in the mix. The use case is like this:
1) User creates csv/xls file with certain information ( i.e:
"male,usa,hispanic,married")
2) Java program reads file and maps string values to attribute
properties in the DMS
I've seen the Apache POI and a few other (Oster utils, etc) but I
haven't found something simple and flexible enough to allow me to
incorporate business logic as well as basic file i/o and string
manipulation.
If you have any information, tips or advice, I would greatly
appreciate it.
Kind regards,
Fer
Fer,
You can also try my company's Data Pipeline product: http://northconcepts.com/
Here's an example from our cookbook:
-- code snippet ---------------------------------------------
package com.northconcepts.datapipeline.examples.cookbook;
import java.io.File;
import java.sql.Connection;
import java.sql.Driver;
import java.util.Properties;
import com.northconcepts.datapipeline.core.DataReader;
import com.northconcepts.datapipeline.core.DataWriter;
import com.northconcepts.datapipeline.core.Job;
import com.northconcepts.datapipeline.csv.CSVReader;
import com.northconcepts.datapipeline.jdbc.JdbcWriter;
public class WriteACsvFileToDatabase1 {
public static void main(String[] args) throws Throwable {
// connect to the database
Driver driver = (Driver)
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Properties properties = new Properties();
properties.put("user", "scott");
properties.put("password", "tiger");
Connection connection = driver.connect("jdbc:odbc:dp-
cookbook", properties);
DataReader reader = new CSVReader(new File("credit-
balance.csv"))
.setFieldNamesInFirstRow(true);
DataWriter writer = new JdbcWriter(connection,
"dp_credit_balance")
.setCloseConnectionOnClose(true);
Job.runNow(reader, writer);
}
}
-- code snippet ---------------------------------------------
You can download the cookbook & software from
http://northconcepts.com/products/data-pipeline/downloads.html
If you have any questions, feel free to post it here or in our fourms.
Good luck,
Dele