[Csvtosql-cvs] csvtosql/examples/test.extended.features/data sample_loc.xml, NONE, 1.1 effect.xml,
Brought to you by:
davideconsonni
Menu
▾
▴
[Csvtosql-cvs] csvtosql/examples/test.extended.features/data sample_loc.xml, NONE, 1.1 effect.xml, NONE, 1.1 matrix.xml, NONE, 1.1 tables.txt, NONE, 1.1 effect.csv, NONE, 1.1 addr_type.xml, NONE, 1.1 sample_loc.csv, NONE, 1.1 addr_type.csv, NONE, 1.1 matrix.csv, NONE, 1.1
|
From: Vano <jj...@us...> - 2006-10-12 15:43:31
|
Update of /cvsroot/csvtosql/csvtosql/examples/test.extended.features/data In directory sc8-pr-cvs4.sourceforge.net:/tmp/cvs-serv27215/examples/test.extended.features/data Added Files: sample_loc.xml effect.xml matrix.xml tables.txt effect.csv addr_type.xml sample_loc.csv addr_type.csv matrix.csv Log Message: new files for test case for extended features --- NEW FILE: matrix.csv --- ID,DELETED,CR_TS,MOD_TS,NAME,CODE,CREATOR_ID,MODIFIER_ID "1","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Soil","SOIL",NULL,NULL "2","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Air","AIR",NULL,NULL "3","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Water","WATER",NULL,NULL --- NEW FILE: effect.xml --- <?xml version="1.0" encoding="UTF-8"?> <root> <!-- CONFIGURATOR DATA --> <descriptor version="2"/> <!-- DEFINE HERE TABLE STRUCTURE --> <structure tablename="effect"> <field name="ID" type="INT"/> <field name="DELETED" type="BOOL"/> <field name="CR_TS" type="DATE"> <param name="inputformat" value="yyyy-MM-dd hh:mm:ss"/> <param name="outputformat" value="yyyy-MM-dd hh:mm:ss"/> </field> <field name="MOD_TS" type="DATE"> <param name="inputformat" value="yyyy-MM-dd hh:mm:ss"/> <param name="outputformat" value="yyyy-MM-dd hh:mm:ss"/> </field> <field name="NAME" type="VARCHAR"/> <field name="CODE" type="VARCHAR"/> <field name="DESCR" type="VARCHAR"/> <field name="CREATOR_ID" type="INT"/> <field name="MODIFIER_ID" type="INT"/> </structure> <!-- WHAT GRAMMAR USE --> <grammar class="net.sf.csv2sql.grammars.mysql.GrammarFactory"/> <!-- TEMPORARY STORAGE --> <storage class="net.sf.csv2sql.storage.Memory"/> <!-- RENDERER CONFIGURATION --> <render class="net.sf.csv2sql.renders.SqlInsertRenderer"> <param name="inputfile" value="effect.csv"/> <param name="separator" value=","/> <!--optional--> <param name="trimdata" value="true"/> <param name="removedoublequotes" value="true"/> <param name="skiplines" value="1"/> <param name="splitter" value="net.sf.csv2sql.renders.splitters.Standard"/> </render> <!-- WRITER CONFIGURATION --> <output> <writerAppender active="true" class="net.sf.csv2sql.writers.JdbcExtendedBatchWriter"> <param name="batchcount" value="0"/> <param name="commitbatchcount" value="0"/> </writerAppender> <writerAppender active="false" class="net.sf.csv2sql.writers.SqlFileWriter"> <param name="filename" value="effect.sql"/> </writerAppender> </output> </root> --- NEW FILE: addr_type.xml --- <?xml version="1.0" encoding="UTF-8"?> <root> <!-- CONFIGURATOR DATA --> <descriptor version="2"/> <!-- DEFINE HERE TABLE STRUCTURE --> <structure tablename="addr_type"> <field name="ID" type="INT"/> <field name="DELETED" type="BOOL"/> <field name="CR_TS" type="DATE"> <param name="inputformat" value="yyyy-MM-dd hh:mm:ss"/> <param name="outputformat" value="yyyy-MM-dd hh:mm:ss"/> </field> <field name="MOD_TS" type="DATE"> <param name="inputformat" value="yyyy-MM-dd hh:mm:ss"/> <param name="outputformat" value="yyyy-MM-dd hh:mm:ss"/> </field> <field name="NAME" type="VARCHAR"/> <field name="CODE" type="VARCHAR"/> <field name="CREATOR_ID" type="INT"/> <field name="MODIFIER_ID" type="INT"/> <field name="COMPANY_ID" type="INT"/> </structure> <!-- WHAT GRAMMAR USE --> <grammar class="net.sf.csv2sql.grammars.mysql.GrammarFactory"/> <!-- TEMPORARY STORAGE --> <storage class="net.sf.csv2sql.storage.Memory"/> <!-- RENDERER CONFIGURATION --> <render class="net.sf.csv2sql.renders.SqlInsertRenderer"> <param name="inputfile" value="addr_type.csv"/> <param name="separator" value=","/> <!--optional--> <param name="trimdata" value="true"/> <param name="removedoublequotes" value="true"/> <param name="skiplines" value="1"/> <param name="splitter" value="net.sf.csv2sql.renders.splitters.Standard"/> </render> <!-- WRITER CONFIGURATION --> <output> <writerAppender active="true" class="net.sf.csv2sql.writers.JdbcExtendedBatchWriter"> <param name="batchcount" value="0"/> <param name="commitbatchcount" value="0"/> </writerAppender> <writerAppender active="false" class="net.sf.csv2sql.writers.SqlFileWriter"> <param name="filename" value="addr_type.sql"/> </writerAppender> </output> </root> --- NEW FILE: effect.csv --- ID,DELETED,CR_TS,MOD_TS,NAME,CODE,DESCR,CREATOR_ID,MODIFIER_ID "1","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Allergic dermatitis",NULL,"Allergic dermatitis",NULL,NULL "2","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Anemia; decrease in blood platelets; increased risk of cancer",NULL,"Anemia; decrease in blood platelets; increased risk of cancer",NULL,NULL "3","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Anemia; infants & young children: nervous system effects",NULL,"Anemia; infants & young children: nervous system effects",NULL,NULL "4","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Anemia; liver, kidney or spleen damage; changes in blood",NULL,"Anemia; liver, kidney or spleen damage; changes in blood",NULL,NULL "5","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Bone disease (pain and tenderness of the bones); Children may get mottled teeth",NULL,"Bone disease (pain and tenderness of the bones); Children may get mottled teeth",NULL,NULL "6","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Cardiovascular system or reproductive problems",NULL,"Cardiovascular system or reproductive problems",NULL,NULL "7","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Cataracts",NULL,"Cataracts",NULL,NULL "8","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Changes in adrenal glands",NULL,"Changes in adrenal glands",NULL,NULL "9","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Eye, liver, kidney or spleen problems; anemia; increased risk of cancer",NULL,"Eye, liver, kidney or spleen problems; anemia; increased risk of cancer",NULL,NULL "10","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Eye/nose irritation; stomach discomfort",NULL,"Eye/nose irritation; stomach discomfort",NULL,NULL "11","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Eye/nose irritation; stomach discomfort, anemia",NULL,"Eye/nose irritation; stomach discomfort, anemia",NULL,NULL "12","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Gastrointestinal illness (e.g., diarrhea, vomiting, cramps)",NULL,"Gastrointestinal illness (e.g., diarrhea, vomiting, cramps)",NULL,NULL "13","0","2006-10-10 14:29:48","2006-10-10 14:29:48","HPC has no health effects; it is an analytic method used to measure the variety of bacteria that are common in water. The lower the concentration of bacteria in drinking water, the better maintained the water system is.",NULL,"HPC has no health effects; it is an analytic method used to measure the variety of bacteria that are common in water. The lower the concentration of bacteria in drinking water, the better maintained the water system is.",NULL,NULL "14","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Hair loss; changes in blood; kidney, intestine, or liver problems",NULL,"Hair loss; changes in blood; kidney, intestine, or liver problems",NULL,NULL "15","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Hair or fingernail loss; numbness in fingers or toes; circulatory problems",NULL,"Hair or fingernail loss; numbness in fingers or toes; circulatory problems",NULL,NULL "16","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Increase in blood cholesterol; decrease in blood sugar",NULL,"Increase in blood cholesterol; decrease in blood sugar",NULL,NULL "17","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Increase in blood pressure",NULL,"Increase in blood pressure",NULL,NULL "18","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Increased cancer risk, and over a long period of time, stomach problems",NULL,"Increased cancer risk, and over a long period of time, stomach problems",NULL,NULL "19","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Increased risk of cancer",NULL,"Increased risk of cancer",NULL,NULL "20","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Increased risk of cancer, kidney toxicity",NULL,"Increased risk of cancer, kidney toxicity",NULL,NULL "21","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Increased risk of developing benign intestinal polyps",NULL,"Increased risk of developing benign intestinal polyps",NULL,NULL "22","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Infants and children: Delays in physical or mental development; children could show slight deficits in attention span and learning abilities; Adults: Kidney problems; high blood pressure",NULL,"Infants and children: Delays in physical or mental development; children could show slight deficits in attention span and learning abilities; Adults: Kidney problems; high blood pressure",NULL,NULL "23","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Infants below the age of six months who drink water containing nitrate in excess of the MCL could become seriously ill and, if untreated, may die. Symptoms include shortness of breath and blue-baby syndrome.",NULL,"Infants below the age of six months who drink water containing nitrate in excess of the MCL could become seriously ill and, if untreated, may die. Symptoms include shortness of breath and blue-baby syndrome.",NULL,NULL "24","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Infants below the age of six months who drink water containing nitrite in excess of the MCL could become seriously ill and, if untreated, may die. Symptoms include shortness of breath and blue-baby syndrome.",NULL,"Infants below the age of six months who drink water containing nitrite in excess of the MCL could become seriously ill and, if untreated, may die. Symptoms include shortness of breath and blue-baby syndrome.",NULL,NULL "25","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Intestinal lesions",NULL,"Intestinal lesions",NULL,NULL "26","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Kidney damage",NULL,"Kidney damage",NULL,NULL "27","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Kidney or stomach problems",NULL,"Kidney or stomach problems",NULL,NULL "28","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Kidney problems; reproductive difficulties",NULL,"Kidney problems; reproductive difficulties",NULL,NULL "29","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Kidney, liver, or adrenal gland problems",NULL,"Kidney, liver, or adrenal gland problems",NULL,NULL "30","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Kidney, liver, or thyroid problems; increased risk of cancer",NULL,"Kidney, liver, or thyroid problems; increased risk of cancer",NULL,NULL "31","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Legionnaire's Disease, a type of pneumonia",NULL,"Legionnaire's Disease, a type of pneumonia",NULL,NULL "32","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Liver damage; increased risk of cancer",NULL,"Liver damage; increased risk of cancer",NULL,NULL "33","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Liver or kidney problems",NULL,"Liver or kidney problems",NULL,NULL "34","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Liver or kidney problems; increased cancer risk",NULL,"Liver or kidney problems; increased cancer risk",NULL,NULL "35","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Liver or kidney problems; reproductive difficulties; increased risk of cancer",NULL,"Liver or kidney problems; reproductive difficulties; increased risk of cancer",NULL,NULL "36","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Liver or kidneys problems",NULL,"Liver or kidneys problems",NULL,NULL "37","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Liver or nervous system problems; increased risk of cancer",NULL,"Liver or nervous system problems; increased risk of cancer",NULL,NULL "38","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Liver problems",NULL,"Liver problems",NULL,NULL "39","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Liver problems; increased risk of cancer",NULL,"Liver problems; increased risk of cancer",NULL,NULL "40","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Liver, kidney or central nervous system problems; increased risk of cancer",NULL,"Liver, kidney or central nervous system problems; increased risk of cancer",NULL,NULL "41","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Liver, kidney, or circulatory system problems",NULL,"Liver, kidney, or circulatory system problems",NULL,NULL "42","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Liver, kidney, or immune system problems",NULL,"Liver, kidney, or immune system problems",NULL,NULL "43","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Liver, nervous system, or circulatory problems",NULL,"Liver, nervous system, or circulatory problems",NULL,NULL "44","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Minor kidney changes",NULL,"Minor kidney changes",NULL,NULL "45","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Nerve damage or thyroid problems",NULL,"Nerve damage or thyroid problems",NULL,NULL "46","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Nervous system damage",NULL,"Nervous system damage",NULL,NULL "47","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Nervous system or blood problems; increased risk of cancer",NULL,"Nervous system or blood problems; increased risk of cancer",NULL,NULL "48","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Nervous system, kidney, or liver problems",NULL,"Nervous system, kidney, or liver problems",NULL,NULL "49","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Not a health threat in itself; it is used to indicate whether other potentially harmful bacteria may be present",NULL,"Not a health threat in itself; it is used to indicate whether other potentially harmful bacteria may be present",NULL,NULL "50","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Problems with blood",NULL,"Problems with blood",NULL,NULL "51","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Problems with blood, nervous system, or reproductive system",NULL,"Problems with blood, nervous system, or reproductive system",NULL,NULL "52","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Problems with liver, stomach, reproductive system, or kidneys; increased risk of cancer",NULL,"Problems with liver, stomach, reproductive system, or kidneys; increased risk of cancer",NULL,NULL "53","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Reproductive difficulties",NULL,"Reproductive difficulties",NULL,NULL "54","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Reproductive difficulties; increased risk of cancer",NULL,"Reproductive difficulties; increased risk of cancer",NULL,NULL "55","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Reproductive difficulties; liver problems; increased risk of cancer",NULL,"Reproductive difficulties; liver problems; increased risk of cancer",NULL,NULL "56","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Short term exposure: Gastrointestinal distress; Long term exposure: Liver or kidney damage; People with Wilson's Disease should consult their personal doctor if the amount of copper in their water exceeds the action level",NULL,"Short term exposure: Gastrointestinal distress; Long term exposure: Liver or kidney damage; People with Wilson's Disease should consult their personal doctor if the amount of copper in their water exceeds the action level",NULL,NULL "57","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Skin changes; thymus gland problems; immune deficiencies; reproductive or nervous system difficulties; increased risk of cancer",NULL,"Skin changes; thymus gland problems; immune deficiencies; reproductive or nervous system difficulties; increased risk of cancer",NULL,NULL "58","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Skin damage or problems with circulatory systems, and may have increased risk of getting cancer",NULL,"Skin damage or problems with circulatory systems, and may have increased risk of getting cancer",NULL,NULL "59","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Slight nervous system effects",NULL,"Slight nervous system effects",NULL,NULL "60","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Stomach and intestinal problems",NULL,"Stomach and intestinal problems",NULL,NULL "61","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Tooth discoloration",NULL,"Tooth discoloration",NULL,NULL "62","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Turbidity is a measure of the cloudiness of water. It is used to indicate water quality and filtration effectiveness (e.g., whether disease-causing organisms are present). Higher turbidity levels are often associated with higher levels of disease-causing",NULL,"Turbidity is a measure of the cloudiness of water. It is used to indicate water quality and filtration effectiveness (e.g., whether disease-causing organisms are present). Higher turbidity levels are often associated with higher levels of disease-causing ",NULL,NULL "63","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Weight loss, liver problems, or possible reproductive difficulties.",NULL,"Weight loss, liver problems, or possible reproductive difficulties.",NULL,NULL "64","0","2006-10-10 14:29:48","2006-10-10 14:29:48","black to brown color; black staining; bitter metallic taste",NULL,"black to brown color; black staining; bitter metallic taste",NULL,NULL "65","0","2006-10-10 14:29:48","2006-10-10 14:29:48","colored water",NULL,"colored water",NULL,NULL "66","0","2006-10-10 14:29:48","2006-10-10 14:29:48","frothy, cloudy; bitter taste; odor",NULL,"frothy, cloudy; bitter taste; odor",NULL,NULL "67","0","2006-10-10 14:29:48","2006-10-10 14:29:48","hardness; deposits; colored water; staining; salty taste",NULL,"hardness; deposits; colored water; staining; salty taste",NULL,NULL "68","0","2006-10-10 14:29:48","2006-10-10 14:29:48","high pH: slippery feel; soda taste; deposits",NULL,"high pH: slippery feel; soda taste; deposits",NULL,NULL "69","0","2006-10-10 14:29:48","2006-10-10 14:29:48","low pH: bitter metallic taste; corrosion ",NULL,"low pH: bitter metallic taste; corrosion ",NULL,NULL "70","0","2006-10-10 14:29:48","2006-10-10 14:29:48","metallic taste",NULL,"metallic taste",NULL,NULL "71","0","2006-10-10 14:29:48","2006-10-10 14:29:48","metallic taste; blue-green staining",NULL,"metallic taste; blue-green staining",NULL,NULL "72","0","2006-10-10 14:29:48","2006-10-10 14:29:48","metallic taste; corroded pipes/ fixtures staining",NULL,"metallic taste; corroded pipes/ fixtures staining",NULL,NULL "73","0","2006-10-10 14:29:48","2006-10-10 14:29:48","rotten-egg, musty or chemical smell",NULL,"rotten-egg, musty or chemical smell",NULL,NULL "74","0","2006-10-10 14:29:48","2006-10-10 14:29:48","rusty color; sediment; metallic taste; reddish or orange staining",NULL,"rusty color; sediment; metallic taste; reddish or orange staining",NULL,NULL "75","0","2006-10-10 14:29:48","2006-10-10 14:29:48","salty taste",NULL,"salty taste",NULL,NULL "76","0","2006-10-10 14:29:48","2006-10-10 14:29:48","skin discoloration; graying of the white part of the eye",NULL,"skin discoloration; graying of the white part of the eye",NULL,NULL "77","0","2006-10-10 14:29:48","2006-10-10 14:29:48","visible tint",NULL,"visible tint",NULL,NULL --- NEW FILE: matrix.xml --- <?xml version="1.0" encoding="UTF-8"?> <root> <!-- CONFIGURATOR DATA --> <descriptor version="2"/> <!-- DEFINE HERE TABLE STRUCTURE --> <structure tablename="matrix"> <field name="ID" type="INT"/> <field name="DELETED" type="BOOL"/> <field name="CR_TS" type="DATE"> <param name="inputformat" value="yyyy-MM-dd hh:mm:ss"/> <param name="outputformat" value="yyyy-MM-dd hh:mm:ss"/> </field> <field name="MOD_TS" type="DATE"> <param name="inputformat" value="yyyy-MM-dd hh:mm:ss"/> <param name="outputformat" value="yyyy-MM-dd hh:mm:ss"/> </field> <field name="NAME" type="VARCHAR"/> <field name="CODE" type="VARCHAR"/> <field name="CREATOR_ID" type="INT"/> <field name="MODIFIER_ID" type="INT"/> </structure> <!-- WHAT GRAMMAR USE --> <grammar class="net.sf.csv2sql.grammars.mysql.GrammarFactory"/> <!-- TEMPORARY STORAGE --> <storage class="net.sf.csv2sql.storage.Memory"/> <!-- RENDERER CONFIGURATION --> <render class="net.sf.csv2sql.renders.SqlInsertRenderer"> <param name="inputfile" value="matrix.csv"/> <param name="separator" value=","/> <!--optional--> <param name="trimdata" value="true"/> <param name="removedoublequotes" value="true"/> <param name="skiplines" value="1"/> <param name="splitter" value="net.sf.csv2sql.renders.splitters.Standard"/> </render> <!-- WRITER CONFIGURATION --> <output> <writerAppender active="true" class="net.sf.csv2sql.writers.JdbcExtendedBatchWriter"> <param name="batchcount" value="0"/> <param name="commitbatchcount" value="0"/> </writerAppender> <writerAppender active="false" class="net.sf.csv2sql.writers.SqlFileWriter"> <param name="filename" value="matrix.sql"/> </writerAppender> </output> </root> --- NEW FILE: sample_loc.xml --- <?xml version="1.0" encoding="UTF-8"?> <root> <!-- CONFIGURATOR DATA --> <descriptor version="2"/> <!-- DEFINE HERE TABLE STRUCTURE --> <structure tablename="sample_loc"> <field name="ID" type="INT"/> <field name="DELETED" type="BOOL"/> <field name="CR_TS" type="DATE"> <param name="inputformat" value="yyyy-MM-dd hh:mm:ss"/> <param name="outputformat" value="yyyy-MM-dd hh:mm:ss"/> </field> <field name="MOD_TS" type="DATE"> <param name="inputformat" value="yyyy-MM-dd hh:mm:ss"/> <param name="outputformat" value="yyyy-MM-dd hh:mm:ss"/> </field> <field name="NAME" type="VARCHAR"/> <field name="CODE" type="VARCHAR"/> <field name="CREATOR_ID" type="INT"/> <field name="MODIFIER_ID" type="INT"/> <field name="COMPANY_ID" type="INT"/> </structure> <!-- WHAT GRAMMAR USE --> <grammar class="net.sf.csv2sql.grammars.mysql.GrammarFactory"/> <!-- TEMPORARY STORAGE --> <storage class="net.sf.csv2sql.storage.Memory"/> <!-- RENDERER CONFIGURATION --> <render class="net.sf.csv2sql.renders.SqlInsertRenderer"> <param name="inputfile" value="sample_loc.csv"/> <param name="separator" value=","/> <!--optional--> <param name="trimdata" value="true"/> <param name="removedoublequotes" value="true"/> <param name="skiplines" value="1"/> <param name="splitter" value="net.sf.csv2sql.renders.splitters.Standard"/> </render> <!-- WRITER CONFIGURATION --> <output> <writerAppender active="true" class="net.sf.csv2sql.writers.JdbcExtendedBatchWriter"> <param name="batchcount" value="0"/> <param name="commitbatchcount" value="0"/> </writerAppender> <writerAppender active="false" class="net.sf.csv2sql.writers.SqlFileWriter"> <param name="filename" value="sample_loc.sql"/> </writerAppender> </output> </root> --- NEW FILE: tables.txt --- # this is list of descriptors for csv2sql utility # all descriptors have path relative to this file effect.xml addr_type.xml matrix.xml sample_loc.xml --- NEW FILE: sample_loc.csv --- ID,DELETED,CR_TS,MOD_TS,NAME,CODE,CREATOR_ID,MODIFIER_ID,COMPANY_ID "1","0","2006-10-10 15:36:36","2006-10-10 15:36:36","AFTER FILTERS","AF",NULL,NULL,NULL "2","0","2006-10-10 15:36:36","2006-10-10 15:36:36","BEFORE FILTERS","BE",NULL,NULL,NULL "3","0","2006-10-10 15:36:36","2006-10-10 15:36:36","BETWEEN FILTERS","BT",NULL,NULL,NULL "4","0","2006-10-10 15:36:36","2006-10-10 15:36:36","TREATMENT SYSTEM - EFFLUENT","EF",NULL,NULL,NULL "5","0","2006-10-10 15:36:36","2006-10-10 15:36:36","TREATMENT SYSTEM - INFLUENT","IN",NULL,NULL,NULL "6","0","2006-10-10 15:36:36","2006-10-10 15:36:36","NOT APPLICABLE","NA",NULL,NULL,NULL "7","0","2006-10-10 15:36:36","2006-10-10 15:36:36","OTHER","O",NULL,NULL,NULL "8","0","2006-10-10 15:36:36","2006-10-10 15:36:36","OUTSIDE TAP","OT",NULL,NULL,NULL "9","0","2006-10-10 15:36:36","2006-10-10 15:36:36","PRESSURE TANK","PT",NULL,NULL,NULL "10","0","2006-10-10 15:36:36","2006-10-10 15:36:36","WELLHEAD","PU",NULL,NULL,NULL "11","0","2006-10-10 15:36:36","2006-10-10 15:36:36","INSIDE TAP","T",NULL,NULL,NULL "12","0","2006-10-10 15:36:36","2006-10-10 15:36:36","UNKNOWN","U",NULL,NULL,NULL "13","0","2006-10-10 15:36:36","2006-10-10 15:36:36","NONE","NONE",NULL,NULL,NULL --- NEW FILE: addr_type.csv --- ID,DELETED,CR_TS,MOD_TS,NAME,CODE,CREATOR_ID,MODIFIER_ID,COMPANY_ID "1","0","2006-10-10 14:30:18","2006-10-10 14:30:18","Simple Address",NULL,NULL,NULL,NULL "2","0","2006-10-10 14:30:18","2006-10-10 14:30:18","Secondary address","SADR",NULL,NULL,NULL "3","0","2006-10-10 14:30:18","2006-10-10 14:30:18","Security service address","sec123123",NULL,NULL,NULL "4","0","2006-10-10 14:30:18","2006-10-10 14:30:18","Main address","MADR",NULL,NULL,NULL "10","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Billing","Billing",NULL,NULL,NULL "11","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Facility","Facility",NULL,NULL,NULL "12","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Mailing","Mailing",NULL,NULL,NULL "13","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Office","Office",NULL,NULL,NULL "14","0","2006-10-10 14:29:48","2006-10-10 14:29:48","Shipping","Shipping",NULL,NULL,NULL |
