jp.ac.tokushima_u.db.t73.action

Class ExcelIntegration

java.lang.Object

jp.ac.tokushima_u.db.t73.T73RDBSet.DSet<T73Action>

jp.ac.tokushima_u.db.t73.T73Action

jp.ac.tokushima_u.db.t73.action.ExcelIntegration

All Implemented Interfaces:

Serializable, T73.T73StatusListener

public class ExcelIntegration
extends T73Action
implements Serializable, T73.T73StatusListener

See Also:

Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
(package private) static class	ExcelIntegration.ProcessLog
(package private) static class	ExcelIntegration.USSLoaderMgr

Nested classes/interfaces inherited from class jp.ac.tokushima_u.db.t73.T73Action

T73Action.NameMatcher, T73Action.ParamDef, T73Action.Parameter

Field Summary

Fields

Modifier and Type	Field and Description
(package private) String	aggregateColumn
(package private) Set<String>	collectColumns
(package private) ArrayList<String>	columnNames
(package private) static String	Config_AggregateColumn
(package private) static String	Config_CollectColumn
(package private) static String	Config_Destination
(package private) static String	Config_ExcludeFile
(package private) static String	Config_ExcludeSheet
(package private) static String	Config_IgonoreValue
(package private) static String	Config_MergeColumn
(package private) static String	Config_Primarykey
(package private) static String	Config_ProcessName
(package private) static String	Config_Secondarykey
(package private) static String	Config_TargetFile
(package private) static String	Config_TargetSheet
(package private) Map<String,UDict>	dataMap
(package private) HashSet<T73File>	excludeFiles
(package private) HashSet<String>	ignoreValues
(package private) List<T73File>	infiles
(package private) static Map<String,T73Action.ParamDef>	m_paramDefs
(package private) Set<String>	mergeColumns
(package private) T73Action.NameMatcher	nm_excludeFile
(package private) T73Action.NameMatcher	nm_excludeSheet
(package private) T73Action.NameMatcher	nm_targetFile
(package private) T73Action.NameMatcher	nm_targetSheet
(package private) T73File	outfile
(package private) String	primaryKey
(package private) List<ExcelIntegration.ProcessLog>	process_logs
(package private) T73File	processDir
(package private) Set<String>	secondaries
(package private) Set<String>	secondariesWithPrimary
(package private) String	secondaryKey
(package private) static String	SN_ConfigurationInformation
(package private) static String	SN_Data
(package private) static String	SN_ProcessingInformation
(package private) static String	SN_Warning
static String	TYPE
(package private) List<CharSequence>	warnings

Fields inherited from class jp.ac.tokushima_u.db.t73.T73Action

actionDict, cause, CN_Description, CN_Option, CN_Parameter, CN_Status, CN_Value, CN_Value2, Config_SubFolder, CV_ActionType, error, m_baseParamDefs, name, parameters, processSubFolder, status, uid, XLS_MAX_COLUMNs, XLS_MAX_ROWs, XLSX_MAX_COLUMNs, XLSX_MAX_ROWs

Constructor Summary

Constructors

Constructor and Description
ExcelIntegration(String n, UDict dict, T73File c)

Method Summary

Modifier and Type	Method and Description
protected int	configMaxNArgsOfParameter()
void	doAction(T73Realm realm)
String	getActionDescription()
String	getActionDocumentURL()
String	getActionType()
protected T73Action.ParamDef	getParamDef(String name)
(package private) void	outputConfiguration(T73Workbook book)
(package private) void	outputProcessingInformation(T73Workbook book)
(package private) void	parseConfigure(List<T73Action.Parameter> params)

Methods inherited from class jp.ac.tokushima_u.db.t73.T73Action

addError, addStatus, createParametersInHTML, createWorker, getCause, getFolder, getName, getParameters, hasError, isIgnoreFileForAction, lockRealm, printEnding, printOpening, sweepDepends, unlockRealm

Methods inherited from class java.lang.Object

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

Methods inherited from interface jp.ac.tokushima_u.db.t73.T73.T73StatusListener

addError, addStatus, hasError

Field Detail

TYPE

public static final String TYPE

See Also:

Constant Field Values

mergeColumns

Set<String> mergeColumns

collectColumns

Set<String> collectColumns

infiles

List<T73File> infiles

primaryKey

String primaryKey

secondaryKey

String secondaryKey

ignoreValues

HashSet<String> ignoreValues

excludeFiles

HashSet<T73File> excludeFiles

nm_targetFile

T73Action.NameMatcher nm_targetFile

nm_excludeFile

T73Action.NameMatcher nm_excludeFile

nm_targetSheet

T73Action.NameMatcher nm_targetSheet

nm_excludeSheet

T73Action.NameMatcher nm_excludeSheet

outfile

T73File outfile

processDir

T73File processDir

aggregateColumn

String aggregateColumn

process_logs

List<ExcelIntegration.ProcessLog> process_logs

warnings

List<CharSequence> warnings

Config_ProcessName

static final String Config_ProcessName

See Also:

Constant Field Values

Config_Primarykey

static final String Config_Primarykey

See Also:

Constant Field Values

Config_Secondarykey

static final String Config_Secondarykey

See Also:

Constant Field Values

Config_IgonoreValue

static final String Config_IgonoreValue

See Also:

Constant Field Values

Config_TargetFile

static final String Config_TargetFile

See Also:

Constant Field Values

Config_ExcludeFile

static final String Config_ExcludeFile

See Also:

Constant Field Values

Config_TargetSheet

static final String Config_TargetSheet

See Also:

Constant Field Values

Config_ExcludeSheet

static final String Config_ExcludeSheet

See Also:

Constant Field Values

Config_MergeColumn

static final String Config_MergeColumn

See Also:

Constant Field Values

Config_CollectColumn

static final String Config_CollectColumn

See Also:

Constant Field Values

Config_AggregateColumn

static final String Config_AggregateColumn

See Also:

Constant Field Values

Config_Destination

static final String Config_Destination

See Also:

Constant Field Values

m_paramDefs

static Map<String,T73Action.ParamDef> m_paramDefs

columnNames

ArrayList<String> columnNames

dataMap

Map<String,UDict> dataMap

secondariesWithPrimary

Set<String> secondariesWithPrimary

secondaries

Set<String> secondaries

SN_ConfigurationInformation

static final String SN_ConfigurationInformation

See Also:

Constant Field Values

SN_ProcessingInformation

static final String SN_ProcessingInformation

See Also:

Constant Field Values

SN_Warning

static final String SN_Warning

See Also:

Constant Field Values

SN_Data

static final String SN_Data

See Also:

Constant Field Values

Constructor Detail

ExcelIntegration

public ExcelIntegration(String n,
                        UDict dict,
                        T73File c)

Method Detail

getActionType

public String getActionType()

Specified by:

getActionType in class T73Action

getActionDescription

public String getActionDescription()

Specified by:

getActionDescription in class T73Action

getActionDocumentURL

public String getActionDocumentURL()

Specified by:

getActionDocumentURL in class T73Action

doAction

public void doAction(T73Realm realm)

Specified by:

doAction in class T73Action

configMaxNArgsOfParameter

protected int configMaxNArgsOfParameter()

Overrides:

configMaxNArgsOfParameter in class T73Action

getParamDef

protected T73Action.ParamDef getParamDef(String name)

Overrides:

getParamDef in class T73Action

parseConfigure

void parseConfigure(List<T73Action.Parameter> params)

outputConfiguration

void outputConfiguration(T73Workbook book)

outputProcessingInformation

void outputProcessingInformation(T73Workbook book)