Scribd
Upload
185 views16 pages

RAP: Excel Upload/Download Guide

The document outlines the steps for uploading and downloading Excel files using RAP, including database setup, interface views, and service definitions. It describes the process of creating records, downloading templates, and uploading filled Excel files while ensuring data integrity through user ID matching. The final steps involve implementing methods for file handling and dynamic button creation for user interactions.

Uploaded by

Dinesh Kolla
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
185 views16 pages

RAP: Excel Upload/Download Guide

The document outlines the steps for uploading and downloading Excel files using RAP, including database setup, interface views, and service definitions. It describes the process of creating records, downloading templates, and uploading filled Excel files while ensuring data integrity through user ID matching. The final steps involve implementing methods for file handling and dynamic button creation for user interactions.

Uploaded by

Dinesh Kolla
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Rap: Excel Upload and Download Excel using Rap only

Step 1. Database tables

Step [Link] views(parent and child)


Step 3. Consumption views
Step 4. Metadata Extension.
Step 5. Service definition.

Step 6. Service Binding.


Note : After the output is displayed, no data appears.

since we don't have any records for now , so No data found is being displayed
here.

Step [Link] definition on Parent Interface view.


Step 8 . Implementation class.
Global behavior class.

Local handler class.

Method Implementation.
Method download excel.
METHOD Upload Excel Data.
METHOD Fill file status and fill selected status.
Global Feature Instance

to enable upload / download and create buttons dynamically

now our app is ready . Lets create one record and see

we can see initially that Template is absent and no file is selected.


Lets Download Template . We can see [Link] now exists in attachment and
template status changes to Present and download excel button disappears as
template exist . Remove the the template and you can see download button again .
Also file not selected as this is empty file . If you remove and upload it again , status
will change to File selected.

Download Template with predefined header.

Fill the excel . Make sure user id and development id should match with the record
where you will upload data. Other wise it will throw error.
Choose the filled file and you can see upload excel button appears.

Press upload and data will be reflected.

You might also like