XAF DevExpress Dashboards, 15 Mar 2023

Previous Meeting

⏯

youtube image

►

From YouTube: DevExpress Dashboards - Introduction (AI generated Voiceover)

Description

Click Here to Subscribe: http://xaf.life/35

Websites:
https://xafmarin.com/
https://xari.io
https://www.xafers.training/
http://xafersweekly.com/

Facebook Group
http://xaf.life/4g

Free XAF Support Hour
https://calendly.com/xari/free-xaf-support-hour

A

Greetings, let us talk about dashboard.

A

The devexpress dashboard tool allows you to create an immensity of combinations of data presentation.

A

We are going to make a series of videos, starting with how to connect to the data, how to do quick actions.

A

Today we are going to know each of your objects.

A

Today we are going to start with the first video.

A

Showing basically, what is the environment of this tool.

A

I also want to tell you that there is a web version.

A

We will also look at the web designer so that you have an idea of how navigate in both tool.

A

Well, the first thing that you are going to find in this tool is basically all the controls that has to display data.

A

We also have the interface in Spanish, but in a previous video I will show you how to present it in English. You will be able to see them here in the home page tab.

A

Okay, so the first thing I want to show you after watching, is that this tool has a home page and that here it has all these controls.

A

The following tab is the data source. What is the data source.

A

Well, it is the source from where you are going to get the information.

A

That you are going to present in the dashboard- and here are several options to deal with the data source. The last visible tab when you Don t have a dashboard created, is the view here. You can change the appearance of presentation. For example, there are people who likes the dark mode right.

A

They like to see the tool in one way where they can focus on the information and not on the screen. Many people also say that dark mode it is good to work at night so that the brightness does not hurt. Well, that is a matter of each person, so we are going to stay with the normal mode.

A

And here you could change a lot of choices: colors presentations, right, okay, so today, after this part, we are going to talk about the data source.

A

Without data source, without information, we don t have a dashboard, so this is the first part we need to work on that. We do not have a dashboard I'm going to show you here how to connect to different data sources.

A

The first thing I am going to show you is how we connect and then in the next video we will go through different data sources, SQL Server database, postgresql MySQL.

A

Then we will also see how to connect to an Excel, an XML file, a Json file and an immensity of data sources.

A

Now, basically, I am going to show you how this works and the first thing that tells us to put a name to the data source, and you could put here, for example, employees or the data source that you are going to connect so that when it appears on the screen, you know where they come from.

A

So another interesting thing about this is the immensity of data sources that we will treat each of them little by little. But we are going to start with the database so that you can see the diversity and then we return so that you can see each one of the following.

A

So, if I click next here, it asks me if I want to use a local connection or I would like to make one myself in this case. I want to make one.

A

Look here at the huge amount of databases starting from SQL server and going through access and Oracle in Google bigquery, MySQL, IBM db2 sat sqlite.

A

Sqlite XML files and what we call a custom connection string. That would be a connection to a very, very particular and very specific database.

A

Notice that here to connect to a database, basically, you would have to have where that database is located or the IP or the name or the address, and what authentication model you are going to use. If you are going to use the user authentication or if you are going to use Windows Authentication.

A

Well, then, I am going to do a test. Here we are going to connect to the local server. I am going to put in user.

A

And here I am going to notice that since I already put in user.

A

Then automatically it connects to the database engine and appears all the databases I have available here.

A

Okay, so I'm going to select a database, this one, the NBA and says if I want to save the password that is debated topic.

A

What does this mean that, in the design, we are even going to see how these files are generated, which are some XML files that have the design of dashboard? Because the password is saved? There is a security issue. That is not good, but it depends of the use that you are going to give it because, for example, it could be that you want these dashboards to be Standalone. That is that themselves could be opened in a viewer and they do not have to request a password or username Etc.

A

It is a part that should be discussed, and here after it does this, so we build our connection string or make a query.

A

Notice that devexpress has a query Builder tool that we are going to spend some time on.

A

But today, basically, what we are going to do is Select something so that you can finally see which is the result of this notice that, from that connection, I made to the NVA database, all the tables that the database has appear if I had views here, tables everything that is inside it well I have it here. I can also tell it to allow me to make in SQL.

A

That is, I write the commands, so the data comes the way I write it or simply, if I drag the team here, for example, now and I tell it this team well I want to drag the players.

A

Notice that if there are relationships they are already connected, I can select some Fields here. Some Fields there.

A

And basically, I can do a preview of the data. How are they looking right and here in this preview? I can also filter. Do a series of things that, little by little, we will see in the videos.

A

And basically after we have already selected our database with our theme.

A

We press accept- and we press finished here- notice that here I already have the information.

A

I can now start making a dashboard. That is why we would do immediately, but of course we must go step by step, but if I suddenly set foot here and say, oh I want the teams here.

A

And sorry I want the team name in the argument, for example, and suddenly I want the same team name here to make a count and basically I already have here a count of how many times the team appears in the data that I have.

A

Until the next video.