Input CSV file data.csv:
id,priority,summary,status 1,Critical,NullPointerException in Main class,Open 5,Low,"Checkstyle, PMD, Findbugs issues",Reopened 7,Low,Maven integration,Open 10,High,SPI API,Closed
The CSV loading script has the following content:
<!DOCTYPE etl SYSTEM "http://scriptella.javaforge.com/dtd/etl.dtd"> <etl> <connection id="in" driver="csv" url="data.csv"/> <connection id="out" driver="oracle" url="jdbc:oracle:thin:@localhost:1521:ORCL" classpath="ojdbc14.jar" user="scott" password="tiger"/> <!-- Copy all CSV rows to a database table --> <query connection-id="in"> <!-- Empty query means select all columns --> <script connection-id="out"> INSERT INTO Table_Name VALUES (?id,?priority, ?summary, ?status) </script> </query> </etl>
Use RegEx to filter CSV data:
<query connection-id="in"> <!--Select bugs with status open or reopened.--> ,,,open|reopened <!--Inserts imported rows into a database--> <script connection-id="out"> INSERT INTO Table_Name VALUES (?id, ?priority, ?summary, ?status); </script> </query>
Example: