Class SpreadsheetImportConfigurationSpec
java.lang.Object
com.orchestranetworks.addon.dex.configuration.FileImportConfigurationSpec<SpreadsheetTable>
com.orchestranetworks.addon.dex.configuration.SpreadsheetImportConfigurationSpec
- All Implemented Interfaces:
ConfigurationSpec<SpreadsheetTable>
,ImportConfigurationSpec<SpreadsheetTable>
public final class SpreadsheetImportConfigurationSpec
extends FileImportConfigurationSpec<SpreadsheetTable>
Defines the configuration used when importing data from an Excel file.
- Since:
- 2.3.0
-
Constructor Summary
ConstructorDescriptionSpreadsheetImportConfigurationSpec
(com.onwbp.adaptation.Adaptation dataset, List<SpreadsheetTable> sourceTables, com.orchestranetworks.service.Session session) Imports data into multiple tables outside of aUIService
.SpreadsheetImportConfigurationSpec
(com.onwbp.adaptation.AdaptationTable currentTable, SpreadsheetTable spreadsheetTable, com.orchestranetworks.service.Session session) Imports data into a table outside of aUIService
. -
Method Summary
Modifier and TypeMethodDescriptioncom.onwbp.adaptation.Adaptation
Returns the current dataset.com.onwbp.adaptation.AdaptationTable
Returns the current table.Returns a map of data positions and Excel sheet names as the key parameter.Returns the service type.com.orchestranetworks.service.Session
Returns the current session.Returns a map of source table filters.Returns the list of source tables.boolean
Returnstrue
if the import data is validated before transformation execution.boolean
Returnstrue
if the displayed value of numbers in each cell will be read and imported.boolean
Returntrue
if a case-insensitive comparison is used when matching the header column.boolean
Returnstrue
if validation errors exist and the user chooses to import only valid records.boolean
Returnstrue
if the Excel sheet data are imported sequentially at simulation import mode.boolean
Returntrue
if redundant characters contained in the header are removed during matching.void
setDataBeforeTransformationValidated
(boolean dataBeforeTransformationValidated) Sets whether the import data is validated before transformation execution.void
setDataPositionInSheets
(Map<String, DataPosition> dataPositionInSheets) Sets a map of data positions and Excel sheet names as the key parameter.void
setForcePrecisionAsDisplayed
(boolean forcePrecisionAsDisplayed) Specifies the accuracy of numbers when importing Excel.void
setHeaderComparedToIgnoreCase
(boolean headerComparedToIgnoreCase) Sets whether a case-insensitive comparison is used when matching the header column.void
setImportOnlyValidRecord
(boolean importOnlyValidRecord) Sets whether only valid records are imported if validation errors exist.void
setImportSequence
(boolean importSequence) Sets whether the Excel sheet data are imported sequentially at simulation import mode.void
setRedundantCharactersInHeaderRemoved
(boolean redundantCharactersInHeaderRemoved) Sets whether redundant characters contained in the header are removed during matching.Methods inherited from class com.orchestranetworks.addon.dex.configuration.FileImportConfigurationSpec
getErrorFilePath, getImportedFile, getImportMode, isEmptyOrNullPrimaryKeyChecked, isEmptyOrNullValueIgnored, isHeaderUsed, isImportForced, isInvalidDataDownloaded, setEmptyOrNullPrimaryKeyChecked, setEmptyOrNullValueIgnored, setErrorFilePath, setHeaderUsed, setImportedFile, setImportForced, setImportMode, setInvalidDataDownloaded
-
Constructor Details
-
SpreadsheetImportConfigurationSpec
public SpreadsheetImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, SpreadsheetTable spreadsheetTable, com.orchestranetworks.service.Session session) throws DataExchangeException Imports data into a table outside of aUIService
.- Throws:
DataExchangeException
-
SpreadsheetImportConfigurationSpec
public SpreadsheetImportConfigurationSpec(com.onwbp.adaptation.Adaptation dataset, List<SpreadsheetTable> sourceTables, com.orchestranetworks.service.Session session) throws DataExchangeException Imports data into multiple tables outside of aUIService
.- Throws:
DataExchangeException
-
-
Method Details
-
getServiceType
Returns the service type. -
isHeaderComparedToIgnoreCase
public boolean isHeaderComparedToIgnoreCase()Returntrue
if a case-insensitive comparison is used when matching the header column. -
setHeaderComparedToIgnoreCase
public void setHeaderComparedToIgnoreCase(boolean headerComparedToIgnoreCase) Sets whether a case-insensitive comparison is used when matching the header column. -
isRedundantCharactersInHeaderRemoved
public boolean isRedundantCharactersInHeaderRemoved()Returntrue
if redundant characters contained in the header are removed during matching. -
setRedundantCharactersInHeaderRemoved
public void setRedundantCharactersInHeaderRemoved(boolean redundantCharactersInHeaderRemoved) Sets whether redundant characters contained in the header are removed during matching. -
getDataPositionInSheets
Returns a map of data positions and Excel sheet names as the key parameter. -
setDataPositionInSheets
Sets a map of data positions and Excel sheet names as the key parameter. -
getCurrentDataset
public com.onwbp.adaptation.Adaptation getCurrentDataset()Returns the current dataset. -
getCurrentTable
public com.onwbp.adaptation.AdaptationTable getCurrentTable()Returns the current table. -
getSession
public com.orchestranetworks.service.Session getSession()Returns the current session. -
getSourceTables
Returns the list of source tables. -
getSourceTableFilters
Returns a map of source table filters. Returnsnull
when importing CSV, Excel and XML. -
isForcePrecisionAsDisplayed
public boolean isForcePrecisionAsDisplayed()Returnstrue
if the displayed value of numbers in each cell will be read and imported. Returnsfalse
if the accuracy value of numbers in each cell will be read and imported. -
setForcePrecisionAsDisplayed
public void setForcePrecisionAsDisplayed(boolean forcePrecisionAsDisplayed) Specifies the accuracy of numbers when importing Excel. If set totrue
: The displayed value of numbers in each cell will be read and imported. If set tofalse
: The accuracy value of numbers in each cell will be read and imported. This feature only applies to Number format cells (Number is used for general display of numbers). For the other cell formats, the accuracy value in each cell will be read and imported. -
isDataBeforeTransformationValidated
public boolean isDataBeforeTransformationValidated()Returnstrue
if the import data is validated before transformation execution. -
setDataBeforeTransformationValidated
public void setDataBeforeTransformationValidated(boolean dataBeforeTransformationValidated) Sets whether the import data is validated before transformation execution. -
isImportSequence
public boolean isImportSequence()Returnstrue
if the Excel sheet data are imported sequentially at simulation import mode. -
setImportSequence
public void setImportSequence(boolean importSequence) Sets whether the Excel sheet data are imported sequentially at simulation import mode. -
setImportOnlyValidRecord
public void setImportOnlyValidRecord(boolean importOnlyValidRecord) Sets whether only valid records are imported if validation errors exist. -
isImportOnlyValidRecord
public boolean isImportOnlyValidRecord()Returnstrue
if validation errors exist and the user chooses to import only valid records.
-