[Csvtosql-cvs] csvtosql_jdk50/examples/test.simple.quoted descriptor.xml,NONE,1.1 users.txt,NONE,1.1

[consonni d. <dav...@us...>]

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>