Scroll to top

CSV Export Functionality in Oracle VBCS


Karan Tulsani - July 5, 2022 - 0 comments - 381 Views

Reading Time: 3 minutes

Visual Builder Cloud Service (VBCS) makes it extremely easy to create custom objects for data storage. Some of the most common requests that we get is to load and export data from these business objects.

At Conneqtion Group, we are always happy to share the tips and tricks that we implement on our projects. Here, we will try to explain the problem that we faced along with the Solution and our approach devised by the Conneqtion technical team. So, let’s get started.

The Problem

What if  a user wants to Extract the data from the UI table in VBCS? What’s the easiest way to fulfil the requirement?

The Solution

There is one component available to achieve this requirement which is oj-sample-export. Here in this tutorial we will explain you how to achieve this requirement.

Conneqtion Approach

Step 1:  Open VBCS Application in Development Mode

Step 2: Go to custom components tab as displayed in the screenshot and search for Export Data and install it.

custom components tab

Step 3:  Once installed successfully it will appear in Installed component tab as shown in the screenshot.

installed component tab

Step 4: Drag & Drop the component from component palette and configure the Data Provider in data attribute of the component (Data Provider can be ADP or SDP).

configure the data provider

Step 5: Configure the additional properties as per the requirements

  • provide the export file name (default file name will be export.csv)
  • CSV compatibility, styling and additional properties can be configured as per the need.

Note: One can limit the number of records to be exported using the Max Row Count property, However if the dataset is large then all the records might not get exported.

configure-additional-properties

Step 6: Configure the columns to be exported

One can select the columns from the dataset to be exported as shown in the screenshot below

Here one needs to select Header Text of the column and attribute name of the column where Type can be of String, Boolean, Number which is an optional field.

configure the columns to be exported

Result

excel export in VBCS

excel export in vbcs

 

Limitations of this approach

  1. It is not suitable if the dataset is large
  2. We cannot highlight the any data cell
  3. Data formatting is not supported (However one can format the data at the source level)
  4. Only CSV compatible data can be exported

What if Dataset volume is large? How do we export the data?

That is the question for another What If.

Let us know in the comments or write to us at [email protected] if you would like us to write on the scenario where the dataset volume is large.

karan-tulsani-conneqtion-group

Karan works as the Delivery Head at Conneqtion Group, a Oracle iPaaS and Process Automation company. He has an extensive experience with various Banking and financial services, FMCG, Supply chain management & public sector clients. He has also led/been part of teams in multitude of consulting engagements. He was part of Evosys and Oracle’s consulting team previously and worked for clients in NA, EMEA & APAC region.

Author avatar

Karan Tulsani

Karan works as the Delivery Head at Conneqtion Group, a Oracle iPaaS and Process Automation company. He has an extensive experience with various Banking and financial services, FMCG, Supply chain management & public sector clients. He has also led/been part of teams in multitude of consulting engagements. He was part of Evosys and Oracle's consulting team previously and worked for clients in NA, EMEA & APAC region.

Post a Comment

Your email address will not be published. Required fields are marked *