com.edgeti.VisibilityServer.Excel

Class ExcelIngestor

java.lang.Object

com.edgeti.VisibilityServer.Excel.ExcelIngestorBase

com.edgeti.VisibilityServer.Excel.ExcelIngestor

public class ExcelIngestor
extends ExcelIngestorBase

Author:

mike.kluever This remote object is responsible for reading and ingesting Excel 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.

Field Summary

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

illegalChars, logger

Constructor Summary

Constructors

Constructor and Description
ExcelIngestor() The constructor loads in variables from the properties file.

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

Constructor Detail

ExcelIngestor

public ExcelIngestor()

The constructor loads in variables from the properties file.

Method Detail

listColumns

public 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.

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)

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