com.edgeti.VisibilityServer.Excel

Class AsciiIngestor

java.lang.Object

com.edgeti.VisibilityServer.Excel.ExcelIngestorBase

com.edgeti.VisibilityServer.Excel.AsciiIngestor

Direct Known Subclasses:

CsvIngestor, TsvIngestor

public class AsciiIngestor
extends ExcelIngestorBase

The Class AsciiIngestor. This remote object is responsible for reading and ingesting ASCII files which already exists on the server in the 'fileuploader.uploadDirectory'. Several methods exist to help examine the worksheet and one final method, ingestFile, is used to ingest the designate columns in to the database.

See Also:

ExcelIngestorBase

Field Summary

Fields

Modifier and Type	Field and Description
private java.lang.String	seperator The seperator.

Fields inherited from class com.edgeti.VisibilityServer.Excel.ExcelIngestorBase

illegalChars, logger

Constructor Summary

Constructors

Constructor and Description
AsciiIngestor(java.lang.String seperator, java.lang.String[] illegalChars) Instantiates a new ascii ingestor.

Method Summary

Methods

Modifier and Type	Method and Description
java.util.ArrayList<java.lang.String>	getColumnHeaders(java.lang.String fileName) When given the name of an existing file, returns the columns which exist in the top sheet of that excel file.
IngestResult	ingestFile(java.lang.String tableName, java.lang.String fileName, boolean merge) Ingests the requested columns in to tableName from the provided file.
java.util.ArrayList<Column>	listColumns(java.lang.String fileName) When given the name of an existing file, returns the columns which exist in the top sheet of that excel file.
static void	main(java.lang.String[] args) The main method.

Methods inherited from class com.edgeti.VisibilityServer.Excel.ExcelIngestorBase

checkForDups, echo, fixString, trace

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

seperator

private java.lang.String seperator

The seperator.

Constructor Detail

AsciiIngestor

public AsciiIngestor(java.lang.String seperator,
             java.lang.String[] illegalChars)

Instantiates a new ascii ingestor.

Parameters:

seperator - the character separating values (i.e. '\t', ',', etc)

illegalChars - the illegal chars (i.e. {" ", ",", "-", ";", "\'", "\t", "\\."})

Method Detail

listColumns

public java.util.ArrayList<Column> listColumns(java.lang.String fileName)

Description copied from class: ExcelIngestorBase

When given the name of an existing file, returns the columns which exist in the top sheet of that excel file.

Specified by:

listColumns in class ExcelIngestorBase

Parameters:

fileName - the file name

Returns:

the array list

getColumnHeaders

public java.util.ArrayList<java.lang.String> getColumnHeaders(java.lang.String fileName)

Description copied from class: ExcelIngestorBase

When given the name of an existing file, returns the columns which exist in the top sheet of that excel file. Same as above, but returning as ArrayList

Specified by:

getColumnHeaders in class ExcelIngestorBase

Parameters:

fileName - the file name

Returns:

the column headers as ArrayList

ingestFile

public IngestResult ingestFile(java.lang.String tableName,
                      java.lang.String fileName,
                      boolean merge)

Description copied from class: ExcelIngestorBase

Ingests the requested columns in to tableName from the provided file. If tableName exists, it will be dropped and recreated.

Specified by:

ingestFile in class ExcelIngestorBase

Parameters:

tableName - the table name

fileName - the file name

merge - flag to merge with existing data in the table (true = merge, false = replace)

Returns:

the ingest result

main

public static void main(java.lang.String[] args)

The main method. For debugging only

Parameters:

args - the arguments