csvtosql-cvs

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

Update of /cvsroot/csvtosql/csvtosql_jdk50/examples/test.excel.skip
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14241/test.excel.skip

Added Files:
	descriptor.xml users.xls 
Log Message:
no message

--- 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="name"     type="VARCHAR"/>
    <field name="surname"  type="VARCHAR">
	<param name="notnullvalue"  value="'mystring'"/>
    </field>
    <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="MM/dd/yyyy"/>
        <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.SqlInsertRendererFromExcel">
    <param name="inputfile"     value="users.xls"/>
    <!--optional-->        
    <param name="trimdata"           value="true"/>    
    <param name="suppressheader" value="false"/>
    <param name="removedoublequotes" value="false"/>
    <!--name of fields to skip separated by blank -->
    <param name="skipfields" value="name address"/>
    <!-- decomment to add id autogeneated field -->
    <!--<param name="idGenerator"   value="net.sf.csv2sql.idgenerators.Incremental"/>-->  
    <!--<param name="startrow" value="2"/>-->
    <!--<param name="stoprow" value="4"/>-->
    <!--<param name="presql" value="BEGIN TRANSACTION;"/>-->
    <!--<param name="postsql" value="COMMIT;"/>-->    
  </render>
  
  <!-- WRITER CONFIGURATION -->
  <output>
  
    <writerAppender active="true"
        class="net.sf.csv2sql.writers.SqlFileWriter">
        <param name="filename" value="users.sql"/>
    </writerAppender>
        
    <writerAppender active="true"
        class="net.sf.csv2sql.writers.StandardOutputWriter">
    </writerAppender>
            
    <!-- change parameters and activate it --> 
    <writerAppender active="false"
        class="net.sf.csv2sql.writers.JdbcWriter">
        <param name="driver"    value="com.mysql.jdbc.Driver"/>
        <param name="url"       value="jdbc:mysql://localhost/test"/>
        <param name="username"  value="root"/>
                
        <!--optional-->
        <!--<param name="password"  value="secret"/>-->        
        <!--<param name="commit"    value="false"/>-->        
        <!--<param name="jdbcjar"   value="/root/myJdbcDriver.jar"/>-->        
    </writerAppender>        

    <!-- change parameters and activate it -->
    <writerAppender active="false"     
        class="net.sf.csv2sql.writers.JdbcBatchWriter">
        <param name="driver"        value="com.mysql.jdbc.Driver"/>
        <param name="url"           value="jdbc:mysql://localhost/test"/>
        <param name="username"      value="root"/>        
        <param name="batchcount"    value="10"/>
        
        <!--optional-->              
        <!--<param name="password"          value="secret"/>-->        
        <!--<param name="commitbatchcount"  value="0"/>-->        
        <!--<param name="jdbcjar"           value="/root/myJdbcDriver.jar"/>-->        
    </writerAppender> 
        
  </output>
  

</root>


--- NEW FILE: users.xls ---
(This appears to be a binary file; contents omitted.)