![]() |
Consumption Analytics Documentation |
Collects usage data from an Excel spreadsheet based on a configuration provided by
SpreadSheetFeedConfig
.
<bean class="com.cloudcruiser.batch.collect.SmartExcelCollector">
This example collects data from sample
spreadsheet.xls
. and outputs the data to a CC-Record file.
<bean id="sampleExcelReader" class="com.cloudcruiser.batch.collect.SmartExcelCollector">
<property name="resource" value="${env.usageDir}/samples/spreadsheet.xls"/>
<property name="feedName" value="sampleExcel"/>
<property name="feedConfig">
<bean class="com.cloudcruiser.batch.collect.SpreadSheetFeedConfig">
<property name="sheet" value="Sheet2" />
<property name="outputs">
<list>
<bean class="com.cloudcruiser.batch.collect.OutputField">
<property name="cctype" value="IDENTIFIER" />
<property name="input" value="1" />
<property name="label" value="Host" />
</bean>
<bean class="com.cloudcruiser.batch.collect.OutputField">
<property name="cctype" value="IDENTIFIER" />
<property name="input" value="5" />
<property name="label" value="VMName" />
</bean>
<bean class="com.cloudcruiser.batch.collect.OutputField">
<property name="cctype" value="RESOURCE" />
<property name="input" value="2" />
<property name="label" value="resource_A" />
</bean>
<bean class="com.cloudcruiser.batch.collect.OutputField">
<property name="cctype" value="RESOURCE" />
<property name="input" value="3" />
<property name="label" value="resource_B" />
</bean>
<bean class="com.cloudcruiser.batch.collect.OutputField">
<property name="cctype" value="USAGE_DATE" />
<property name="input" value="6" />
</bean>
</list>
</property>
</bean>
</property>
</bean>
<bean id="sampleExcelReader" class="com.cloudcruiser.batch.collect.SmartExcelCollector">
<property name="resource" value="${env.usageDir}/samples/spreadsheet.xls"/>
<property name="feedName" value="sampleExcel"/>
<property name="feedConfig">
<bean class="com.cloudcruiser.batch.collect.SpreadSheetFeedConfig">
<property name="sheet" value="Sheet2"/>
<property name="header" value="true"/>
<property name="outputs">
<list>
<bean class="com.cloudcruiser.batch.collect.OutputField">
<property name="cctype" value="IDENTIFIER" />
<property name="input" value="Ident_1" />
<property name="label" value="Host" />
</bean>
<bean class="com.cloudcruiser.batch.collect.OutputField">
<property name="cctype" value="IDENTIFIER" />
<property name="input" value="Ident_2" />
<property name="label" value="VMName" />
</bean>
<bean class="com.cloudcruiser.batch.collect.OutputField">
<property name="cctype" value="RESOURCE" />
<property name="input" value="resource_A" />
</bean>
<bean class="com.cloudcruiser.batch.collect.OutputField">
<property name="cctype" value="RESOURCE" />
<property name="input" value="resource_B" />
</bean>
<bean class="com.cloudcruiser.batch.collect.OutputField">
<property name="cctype" value="USAGE_DATE" />
<property name="input" value="Usage" />
</bean>
</list>
</property>
</bean>
</property>
</bean>
<bean id="sampleExcelReader" class="com.cloudcruiser.batch.collect.SmartExcelCollector">
<property name="resource" value="${env.usageDir}/samples/spreadsheet.xls"/>
<property name="feedName" value="sampleExcel"/>
<property name="feedConfig">
<bean class="com.cloudcruiser.batch.collect.SpreadSheetFeedConfig">
<property name="sheet" value="Sheet2"/>
<property name="header" value="true"/>
<property name="inputs">
<list>
<bean class="com.cloudcruiser.batch.collect.InputField">
<property name="pos" value="1" />
<property name="name" value="Host" />
</bean>
<bean class="com.cloudcruiser.batch.collect.InputField">
<property name="pos" value="5" />
<property name="name" value="VMName" />
</bean>
<bean class="com.cloudcruiser.batch.collect.InputField">
<property name="pos" value="2" />
<property name="name" value="resource_A" />
</bean>
<bean class="com.cloudcruiser.batch.collect.InputField">
<property name="pos" value="3" />
<property name="name" value="resource_B" />
</bean>
<bean class="com.cloudcruiser.batch.collect.InputField">
<property name="pos" value="6" />
<property name="name" value="Usage" />
</bean>
</list>
</property>
<property name="outputs">
<list>
<bean class="com.cloudcruiser.batch.collect.OutputField">
<property name="cctype" value="IDENTIFIER" />
<property name="input" value="Host" />
</bean>
<bean class="com.cloudcruiser.batch.collect.OutputField">
<property name="cctype" value="IDENTIFIER" />
<property name="input" value="VMName" />
</bean>
<bean class="com.cloudcruiser.batch.collect.OutputField">
<property name="cctype" value="RESOURCE" />
<property name="input" value="resource_A" />
</bean>
<bean class="com.cloudcruiser.batch.collect.OutputField">
<property name="cctype" value="RESOURCE" />
<property name="input" value="resource_B" />
</bean>
<bean class="com.cloudcruiser.batch.collect.OutputField">
<property name="cctype" value="USAGE_DATE" />
<property name="input" value="Usage" />
</bean>
</list>
</property>
</bean>
</property>
</bean>
(c) Copyright 2017-2020 Hewlett Packard Enterprise Development LP