Monday, June 19, 2017

How to export data to excel in OutSystem

Step 1:- Create a link and add Destination as a new action to the it

Image1

Step 2:- Double click on Action and have your work flow as shown below

Image2

Step 3:- click on Excel icon in work Flow and fill the parameter as shown below

Image3

Step 4:- Click on download icon in Work flow and fill the parameter as shown below


Image4


Step 5:- Run the appication and click on the link and excel will be downloaded to your system

Image5Image6

How to Create Graph in Outsystem

Step 1:- To create a graph we need to create a list i.e. collection of record on which we want to plot the graph
Step 2:- Lets assum we want to crate a graph on our Employees List Screen.
- Create a Container component
- Create local Varable and name it as saaryGraph
- Make sure to give the Data Type as Employee List
Image1Image2
Step 3:- Create a graph i.e. we are creating bar chart select Column Chart

Image3
Step 4:- click on the bar cart window and fill parameter as shown below
Image4
Step 5:- Run the application and see the graph displayed on the screenImage5

Thursday, June 15, 2017

Calling SOAP Web Service API Example using Outsystem Application

Step 1:- Create One text field and button as shown in the above screen
Step 2:- Create Destination as shown in the below figure
Image6
Step 3:- Go to logic and create a new SOAP Service as shown in the below figure.
Image1Image2Image3
Step 4:- Double click on the button and keep your button Flow diagram as shown below i.e. drag drop our SOAP Method to flow and assign the output to variable we had assigned to Text field.
Image4
Step 5:- Compile and run the application
Image5

Calling REST API Example using Outsystem

Step 1:- Create One text field and button as shown in the above screen
Image1
Step 2:- Create Destination as shown in the below figure
Image2
Step 3:- Go to logic and create a new REST Service as shown in the below figure.


Image3Image4Image5Image6
Step 4:- Double click on the button and keep your button Flow diagram as shown below i.e. drag drop our REST Method to flow and assign the output to variable we had assinged to Text field.

Image7
Step 5:- Compile and run the application

Image8

OutSystems CRUD Operation Example

Step 1:- Please refer to the below given link before starting the application

http://siddharathadhumale.blogspot.in/2017/06/addition-of-two-value-in-outsystems.html

Step 2:- We are going to add a button that will move us to a screen that will perform CRUD operation
Step 3:- Goto Data Tab and right click and create a table ie Employee
Image1
Step 4:- Create necessary Field in that table, Note:- By default we will have ID as a PK in the table ready.
Image2
Step 5: - Click on Main flow and Drag and drop List and Detail Screen and select Employee option as shown in below figure.

Image3Image4
Step 6:- Lets add back button on the Screen that will navigate us to Home page

Image5
Step 7:- Click on Back Button and add this to it

Image6

Wednesday, June 14, 2017

Addition of two value in outsystems application

Step1:- Create your login in outsystems
Step 2:- Download Environment IDE from the site. i.e. https://www.outsystems.com/home
Step 3:- Install the new exe DevelopmentEnvironment-10.0.502.0.exe to your system
Step 4:- Login to IDE and input your Environment name i.e. abc-xyz.outsystemscloud.com and use your login credential to get access your Development Environment on cloud.
Step 5:- Click on Home screen icon shown in below image.
Image1Image2
Step 6:- Create your Addition of two value programe using inbuild component like Label, Textfield, Button as shown in below image

Image3
Step 7:- Make sure to assign local variable to your Textfield. This Local variable is used to identify out component by applications.

Image4Image5Image6Image7
Step 8:- Double click on Add button and used Assign component in flow, and see the right hand side below component to apply logic


Image8
Note:- Dont Forget to make your Var1,Var2 and Var3 Interger else value be concatinated.


Image10Image9

Thursday, June 08, 2017

Integrating Paypal Payment gateway in our Web Application using JAVA

Step 1 - Create gmail Id that we are going to use as a paypal reference i.e. TestingPaypalgateway@gmail.comStep 1 - Create gmail Id that we are going to use as a paypal reference i.e. TestingPaypalgateway@gmail.comStep 2 - Open this url and click on signup and register above created user in paypal i.e. TestingPaypalgateway@gmail.comhttps://developer.paypal.com/
Image1
Step 3 - Login with TestingPaypalgateway@gmail.com in paypal and go to account section of the screen. we will be able to see the below screen.
Image2
Paypal will create two email id for us 1- *-facilitator@gmail.com of Type business 2- *-buyer@gmail.com of type personal or individual
Step 4:- Go to My Apps $Credentials screen and generate Sand box Access Token. This token is needed when we try to make Financial transactions.
Image3
Click on the button and fill select *-facilitator@gmail.com of Type business in combobox.
Image4
Step 5:-click on Generate Credential button and we will see Access token created for us in sandbox for use. On the same screen we can also define the currency in which we are going to use the transaction.
Note: This Access token has an expiry
Image5
Step 6:-After adding the access token to our id we will be able to see this facilitator id on on My Apps & credentials Screen as shown below
Image6
Step 7:- Now lets try to implement PayPal payment services. Choose the solution that bests suits your needs
Refer to this page https://developer.paypal.com/docs/
We will try to use the simple yet effective option of checking out and paying the purchase product on line using Paypal.
https://developer.paypal.com/docs/integration/direct/express-checkout/integration-jsv4/
- Create simple dynamic web project and create an index.jsp in our webcontent
place following code inside it
<!--%@ page language="java" contentType="text/html; charset=ISO-8859-1"<!--%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%><!--!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><!--html><!--head><!--meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"><!--title>Insert title here<!--/title><!--meta http-equiv="X-UA-Compatible" content="IE=edge" /><!--script src="https://www.paypalobjects.com/api/checkout.js"><!--/script><!--/head><!--body>
<!--h2>hello siddhu<!--/h2> <!--div id="paypal-button"><!--/div>
    <!--script>        paypal.Button.render({
            env: 'production', // Or 'sandbox',
            commit: true, // Show a 'Pay Now' button
            payment: function() {                // Set up the payment here            },
            onAuthorize: function(data, actions) {                // Execute the payment here           }
        }, '#paypal-button');    <!--/script><!--/body><!--/html>
When you run above code you will be able to see a paypal button on the screen.

Image7
Now we need to add logic that will work for us to do payment using Paypal. for this we will use Client-side REST integration
For this we need to create a client id and for that we have to follow below given steps.
1- Go to  PayPal developer My apps page, and click the top right button to log in.2- Scroll down to the REST API Apps section. If you do not have any apps listed in this section, create a PayPal app i.e. https://developer.paypal.com/developer/applications/createand and copy paste the cliend id for our app created and then return to the REST API Apps section.
Modify above code with this lines which state that we are going to
<!--%@ page language="java" contentType="text/html; charset=ISO-8859-1"<!--%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%><!--!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><!--html><!--head><!--meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"><!--title>Insert title here<!--/title><!--meta http-equiv="X-UA-Compatible" content="IE=edge" /><!--script src="https://www.paypalobjects.com/api/checkout.js"><!--/script><!--/head><!--body>
<!--h2>hello siddhu<!--/h2> <!--div id="paypal-button"><!--/div>
<!--script> paypal.Button.render({
env : 'sandbox', // Or 'production'
client : { sandbox : 'ASEbOgMkFPF1J2nYV3CbDb8k7JSfWveIHDdsVjJrqEtAQeBJsvavDtuN1ULZABXREGx3UdfEyDGcVNpn', production : 'xxxxxxxxx' },
commit : true, // Show a 'Pay Now' button
payment : function(data, actions) { return actions.payment.create({ transactions : [ { amount : { total : '1.00', currency : 'USD' } } ] }); },
onAuthorize : function(data, actions) { return actions.payment.execute().then(function(payment) {
window.alert("Payment done successfully!!!!!!");
// The payment is complete! // You can now show a confirmation message to the customer }); }
}, '#paypal-button'); <!--/script><!--/body><!--/html>

Image8
As I am acting as a buyer so I had used my buyer emailid and password.

Image9Image10Image11Image12
Refer to the below url for more in details:-https://developer.paypal.com/docs/integration/direct/express-checkout/integration-jsv4/add-paypal-button/https://developer.paypal.com/docs/integration/direct/express-checkout/integration-jsv4/choose-integration-method/