Update of /cvsroot/csvtosql/csvtosql_jdk50/examples/test.simple.quoted
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14241/test.simple.quoted
Added Files:
descriptor.xml users.txt
Log Message:
no message
--- NEW FILE: users.txt ---
"1", "John","Doe","120 jefferson st.", "Riverside", "NJ", "08075", "23/8/1980"
"0", "Jack","McGinnis","220 hobo Av.", "Phila", "PA","09119", "14/1/1984"
"1", "John Da Man","Repici","120 Jefferson St.","Riverside", "NJ", "08075" , "19/10/1979"
"0", "Stephen", "Tyler","7452 Terrace At the Plaza road","SomeTown","SD", "91234", "25/11/1999"
--- NEW FILE: descriptor.xml ---
<?xml version="1.0" encoding="UTF-8"?>
<root>
<!-- CONFIGURATOR DATA -->
<descriptor version="3"/>
<!-- DEFINE HERE TABLE STRUCTURE -->
<structure tablename="tab_users">
<field name="ID" type="NUMBER"/>
<field name="name" type="VARCHAR"/>
<field name="surname" type="VARCHAR"/>
<field name="address" type="VARCHAR"/>
<field name="city" type="VARCHAR"/>
<field name="state" type="VARCHAR"/>
<field name="cap" type="VARCHAR"/>
<field name="borndate" type="DATE">
<param name="inputformat" value="dd/MM/yy"/>
<param name="outputformat" value="yyyy-MM-dd"/>
</field>
</structure>
<!-- WHAT GRAMMAR USE -->
<grammar class="net.sf.csv2sql.grammars.oracle.GrammarFactory"/>
<!-- TEMPORARY STORAGE -->
<storage class="net.sf.csv2sql.storage.Memory"/>
<!-- RENDERER CONFIGURATION -->
<render class="net.sf.csv2sql.renders.SqlInsertRenderer">
<param name="inputfile" value="users.txt"/>
<param name="separator" value=","/>
<!--optional-->
<param name="trimdata" value="true"/>
<param name="suppressheader" value="false"/>
<param name="removedoublequotes" value="true"/>
<!-- decomment for add id autogeneated field -->
<!--<param name="idGenerator" value="net.sf.csv2sql.idgenerators.Incremental"/>-->
</render>
<!-- WRITER CONFIGURATION -->
<output>
<writerAppender active="false"
class="net.sf.csv2sql.writers.SqlFileWriter">
<param name="filename" value="users.sql"/>
</writerAppender>
<writerAppender active="true"
class="net.sf.csv2sql.writers.StandardOutputWriter">
</writerAppender>
</output>
</root>
|
