To get full access to the Kademi Hub existing customers can login here, or new customers can register here.
Summary of implementations of DatabaseTableProvider
| Name | Comments |
|---|---|
| OrganisationTableProvider | Updates child organisations of the current account
Example:
<next class="DatabaseUpdateStep" providerId="organisation" mode="updateOrInsert" setIntoAttribute="dealership">
<!-- use star guild code as orgid, with leading zeros - 0000133433 -->
<column field="orgId" column="1" >
<expr>
if(formatter.isNull(value) || value == "N/A"){
return formatter.padWith("0", row[2], 10);
}else{
return formatter.padWith("0", value, 10);
}
</expr>
</column>
<column field="title" column="0" />
<column field="orgType" >
<value class="string">dealership</value>
</column>
<column field="StarClExDealerCode" column="2" /> <!-- custom field for dealership -->
<column field="StarGuildCode" column="1" /> <!-- custom field for dealership -->
<column field="address" column="0" />
<column field="addressLine2" column="9" />
<column field="suburb" column="10" /> <!-- custom field -->
<column field="state" column="11" />
<column field="postcode" column="12" />
<column field="phone" column="13" />
<column field="country">
<value class="string">AU</value>
</column>
<skipIfBlankColumns>
<int>0</int>
<int>2</int>
<int>3</int>
</skipIfBlankColumns>
</next>
|
| ProfileTableProvider | Updates profile and membership info |
| ProductsTable | This is a database table provider for Products
Note that products can be associated with categories, and product options,
and can also be added to reward stores.
Use the CategoryTableProvider to setup categories, the ProductOptionsTable to
setup variants, parameters and options for each product, and
ProductInRewardTableProvider to associate products with reward stores
This handles specific fields:
|
| FastPointsRowProvider | |
| GroupMembershipTableProvider | |
| SurveyRowProvider | Updates not supported yet Allows criteria parameters of startDate, finishDate and rewardNames |
| ProductOptionsTable | The ProductOptionsTable handles inserting and updating product parameters and
options, often called product variants
A ProductParameter is something about a product which can have options, for
example "size" and "color" are 2 common parameters.
Each ProductParameter can have associated options. For example the "color"
parameter could have options of "red" and "blue"
The fields supported by this provider are:
|
| CategoryTableProvider | |
| ProductInRewardTableProvider | This table provider takes care of inserting and updating the product in
rewards table.
This adds a product to a reward store.
|
| PointsRowProvider | Updates - NOTE DONE YET!!! |
| DataSeriesProvider | NOTE - use the SalesDataInserter instead!!!! |
| FastPointsDebitRowProvider | |
| ProductInCategoryTableProvider | This table provider takes care of inserting and updating the product in
categories table,which links a product to a category
|
© 2025 Kademi Ltd