CSVImport (Ontopia)

java.lang.Object
- net.ontopia.topicmaps.db2tm.CSVImport

```
public class CSVImport
extends Object
```
INTERNAL: Command line tool for importing comma- or semicolon separated files into a database.

Field Summary

Fields
Modifier and Type	Field and Description
`protected boolean`	`cleartable`
`protected String[]`	`columns`
`protected Connection`	`conn`
`protected boolean`	`ignorecolumns`
`protected int`	`ignorelines`
`protected char`	`quoteCharacter`
`protected char`	`separator`
`protected boolean`	`stripquotes`
`protected String`	`table`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`importCSV(InputStream csvfile)`
`static void`	`main(String[] argv)`
`void`	`setClearTable(boolean cleartable)`
`void`	`setColumns(String[] columns)`
`void`	`setIgnoreColumns(boolean ignorecolumns)`
`void`	`setIgnoreLines(int ignorelines)`
`void`	`setSeparator(char separator)`
`void`	`setStripQuotes(boolean stripquotes)`
`void`	`setTable(String table)`
`protected static void`	`usage()`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

conn
```
protected final Connection conn
```

table
```
protected String table
```

columns
```
protected String[] columns
```

quoteCharacter
```
protected char quoteCharacter
```

separator
```
protected char separator
```

cleartable
```
protected boolean cleartable
```

stripquotes
```
protected boolean stripquotes
```

ignorecolumns
```
protected boolean ignorecolumns
```

ignorelines
```
protected int ignorelines
```

Method Detail

setTable
```
public void setTable(String table)
```

setColumns

public void setColumns(String[] columns)

setSeparator

public void setSeparator(char separator)

setClearTable

public void setClearTable(boolean cleartable)

setStripQuotes

public void setStripQuotes(boolean stripquotes)

setIgnoreColumns

public void setIgnoreColumns(boolean ignorecolumns)

setIgnoreLines

public void setIgnoreLines(int ignorelines)

importCSV

public void importCSV(InputStream csvfile)
               throws Exception

Throws:: Exception

usage
```
protected static void usage()
```

main

public static void main(String[] argv)
                 throws Exception

Throws:: Exception

Class CSVImport

Field Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

conn

table

columns

quoteCharacter

separator

cleartable

stripquotes

ignorecolumns

ignorelines

Method Detail

setTable

setColumns

setSeparator

setClearTable

setStripQuotes

setIgnoreColumns

setIgnoreLines

importCSV

usage

main