Home > Cloud Cruiser 4 > Collecting, transforming, and publishing > Excel > Mapping data to Cloud Cruiser

Mapping data to Cloud Cruiser

The SmartExcelCollector works in conjunction with the SpreadSheetFeedConfig bean that is used to describe how the rows and columns of data are to be interpreted.

Data is generally processed column by column. For example, one column might be defined as containing identifiers, another column might be defined as containing resource quantities, and a third column might be defined as containing the usage date.

In summary, columns can contain the following data types:

  • Usage date and time
  • Identifier values
  • Identifier labels
  • Resource values
  • Resource labels

Feed configuration

The feed configuration is responsible for describing the input of the XLS file. In general, rows from the file are transferred to CC Record files.

An Excel spreadsheet feed can be any data contained in a spreadsheet document. You can map a set of columns from a single worksheet to an output CC Record file for processing. Within the feed configuration area, you describe what columns and time and date, identifiers, and resources.

If the Excel file contains a header row, the OutputField can reference a value from the header row as .input . Otherwise, InputField objects can be used to name the input columns for mapping to output. Another option to name identifiers and resources when no header exists is to set the input property of OutputField to a column number, and set the label property to a name or labelInput property to a column number.

Column numbers begin at 1 and the first column is not always equivalent to column 'A'. Empty columns before or after data in the spreadsheet are ignored. Empty rows before or after data in the sheet are also ignored. This should be taken into account when specifying input column numbers or setting a value for the SpreadSheetFeedConfig ’s linesToSkip property. Blank rows in the middle of the data set can cause processing errors.

Date and time

Columns in the Excel file can contain time and date data types. The following shows an example of the types of usage that can be output and mapped.

Excel date and time columns

Identifiers and resources

Columns in the Excel file contain identifier and resource data types. The following shows an example of the types of data can be output and mapped.

Excel data
Last modified

Tags

This page has no custom tags.

Classifications

This page has no classifications.
© Copyright 2018 Hewlett Packard Enterprise Development LP