ADF Desktop Integration (ADFdi)

How to update a record in table component of ADF Desktop Integration (ADFDI) Excel workbook ?

Update – the easiest of CRUD operations to configure in ADF Desktop Integration (ADFDI) table component. Here is what needs to be assured to have it working:

  1. Commit action binding available in page definition file.
  2. Upload ribbon command is set up in excel worksheet. It must have at least to actions – upload and commit.
  3. Updating of row enabled in table component properties

In this post I’m going to extend previously created demo application – How to pass a parameter to ADF Desktop Integration (ADFDI) excel workbook?.

Lets shortly elaborate each of points mentioned above:

  1. In page definition for excel workbook of demo application there is only Commit action binding missing. Add it:

2. In demo application there is autogenerated (on add of table component) ribbon command for upload data. But there is still missing commit in action set. Add it by modifying Worksheet Properties:

3. Open properties of table component and under RowActions verify whether UpdateRowEnabled is True:

4. All is set now, can go for testing. Note, that before running test, application needs to be redeployed (because new commit action binding needs to be accessible for ADFDI plugin).

  • Run excel workbook, change some data, i.e. salary of employee
  • Triangle icon appears in Changed service column. Which indicates that there are pending changes in particular row which are ready to be processed on upload command.
  • Click Upload ribbon command and check for Row updated successfully message in status column
 

Demo application can be downloaded here.

You might be also interested in:

For more information, you can check Oracle documentation – Working with ADF Desktop Integration Table-Type Components.

ADF Version 12.2.1.0.0

About Danas Tarnauskas

2 thoughts on “How to update a record in table component of ADF Desktop Integration (ADFDI) Excel workbook ?

  1. Hi Danas,

    Even after setting all the properties correctly, i am unable to see the triangle in changed column when the data in a cell is changed.

    Thanks
    AJ

    1. Hi Anil,
      is demo application, provided in the post, working for you? If not, maybe there are some restrictions configured to access/execute VBA code in the excel. Or sometimes, due to excel crashes, ADFDI plugin gets disabled, thus it does not do the job and excel file is not recognised as an ADFDI enabled. Or it can also be a case, that ADFDI plugin version differs from an application, but clear message would be displayed informing about that. Hard to help without seeing real implementation and environment, but I believe it should not be related to properties you have set following this post.
      Best wishes!
      -Danas

Comments are closed.