Hello. Hi. Hi, everybody. Let's start it. So, I'm talking to you about this long customization for parliaments, okay? Well, I am a software developer since 1991. I have a master's degree

in software engineering. I am a developer at camera, it's the town council. I founded the Python Parana local user group. I founded the coding dojo, also local user group. I

organized the Python Brazil number 6 in 2010. I organized it this year, the SciPy Latin America on Curitiba also. And I am a member of Python Brazil Association. Just a little

off topic here. My name is was I was named after a warrior from a book my father was reading. And I discovered that it was a samurai. Okay. Let's go. Spoiler alert. I will cry. I'm sure.

And about the talk. I will talk about this customization, but I will show how I contribute to the portal integrating data visualization from the EA using portal model and ombudsman

office system. I work in town council, but I was designated to work at the ombudsman office of Curitiba. So, that's why I used this system and have to customize it for my

day by day use. Okay. This is the town council. It's the front of the town council are the city councilors discuss laws and stuff like that. Well, the portal model was developed

by Interleges. Interleges, you know, was the host of the conference in Brazil. And

the Brazilian institute, the name in Portuguese is. They give free training and free software

also. And they also give infrastructure for the town councils around the country. And these are the pages and they have an organization on GitHub. The portal model

is made for city halls. It's a free software. And they host around 1,773 portals on Interleges.

Okay. They also give free training. So, they support with knowledge also. And it's following the Brazilian rule of law of transparence for the government. So, it's giving information

from what's happening and where the money is being spent on the town council and the cities. I work mostly with this system, the ombudsman office. It's made for the

citizens to complain about things like, oh, my street has a role that fits a car inside.

I already asked for the mayor to fix it, but it's still not fixed. So, please do something for me. And they accept several types of claims by default. Okay. I use it, the data visualization of the European environment agents.

It's a semantic web data visualization tool for zoopian clone. It's still supporting only clone four. They generate attractive and interactive charts. There are two visualizations supported, smile exhibit and Google charts. And the architecture allows for new plugins,

data visualization plugins. There's also a variation of the portal model that is called portal padron. That's for the power of Brazil. Okay. Used by Brazilian government

clone sites. But now you want to take a picture? I can't wait a little. Be quick.

And let's do some demonstration here. So, let's see. Well, portal model is made major a bunch of other add-ons like intranet model and API searchers. The ombudsman

add-on that I will show you. And some more stuffs. Okay. Now I give you another spoiler.

It was not supposed to be here now. Let's see. So, I have here, they have a Docker image

to those that who want to use it. But this Docker image is not working like the ombudsman

is not working this image. So, I will use a checkout I did on GitHub. Let me see just to

show you. So, this Docker image is running on part 800, 1200. But I will use another one.

Work on. A little bit nervous. I didn't slept well also. Let me show you.

This is our website. It is still using PHP. We intend to move to clone as soon as possible.

Okay. Just starting. So, when it's open, the web page, and I am using the full template,

but they have a lot of themes. Every theme is based on something that is called

IDG. Government Digital Identity. It was made by a lot of friends, and I don't know, Simplis

worked on the IDG also. Yeah. It was a project of Simplis when it was there. Oh, it's local host. Why you don't open? Okay. It's open. So, this is the interface,

the first interface. I am logged in. So, it's showing the actions here. So, this is the full installation just out of the box. And it comes off a lot of things here. The thing I told you about transparency, it's this oh, you are not seen. So, there's this

navigation. So, the finances, the contracts, the human resource data, and everything out of the

box. There is access to information, open data, everything out of the box. Some town councils have received like mention, honorable mention, because they are very transparent and very

open data driven. But I will talk about the ombudsman. It's in Portuguese, I'm sorry. But I don't think there's a translation, full translation ready. This is the list of the

complaints that I as a citizen did. Then there's a workflow. When someone complains about something, it's pending. And after some movement, some response, it goes to it can

maybe like oh, this is not our problem. It's not a city problem. It's a state problem. So, we

will reject. Or we can go to concluded or I believe it is that these are the states, okay? So, this complaint here, I made yesterday. When there's some response, the admin can say

okay, I will provide some information as soon as I can. Some informations have like

I can choose for the state here, but I move to moving. There are some complaints that have like deadline to be legally responded, okay?

The state is have changed here. Now, what I did for the to contribute to this, I went to the

just a minute. I have we at the ombudsman office, we needed to do something like

regular reports for the citizens. So, to do this report, I tried to extract some data from the

ombudsman office system, and there was already a JSON API. So, here, the browser, JSON API.

I am I was not like working with Plone and developing Plone add-ons, so I didn't knew

the best practices to use. So, I just followed this sample code here that exports, that gives a view for JSON data. So, anyone that needs to get the data of the complaints and do something

with the data, like analysis or something, and they can use this GROC view here. And then I looked at it and I thought, wow, what about some really counted or aggregated informations.

Then I did this, like claims by date. I just counted like for a period or a month or a date,

how many complaints were about that date. So, I create some of these. I have an auxiliary memory here. It's a JDIT notepad. So, there are that kind of URL here. So, we can

see, like, in a CSV or JSON data structure, the kinds accepted or moving or rejected,

and the counting. Okay. Using this data, I was able to integrate that of these graphics.

So, we have some reports. There are some that are out of the box. So, this one I created

are complaints by type. Just inside Plone, we have these complaints by type graphic.

With this, we can, like, embed in other sites or we can export to PNG or export to SVG. Also, we can get the HTML report of this data and we can, like, have JSON,

XML, XML with the schema and, like, it's a bit JSON that's possible to read for humans. Okay. And I will create another one here. Just as an example. So, let me just well, the claim is dexterity type. So, we can add some behaviors to them.

And I want to categorize the complaints. So, I can say, like, oh, this is about

public illumination or it's about the public healthcare system or so I can categorize in the way I want. And I will do create a report here. Data visualization. This report

here, I can put, like, a static file or I can give you an URL. So, I will give the URL for

categorization. That's it. Save it. Okay. After we save it, we can configure the graphic,

how we use it. Edit it. Edit visualizations. That's it. So, it loads the data table from

the URL. Then we can enable charts. So, when we add a new visualization, we can choose the kind

of graphic we want. Loading charts. It's happening again. Live demo is failing. Okay.

So, there's something wrong here. So, I will show you a red one just to not lose too much time.

What I intended to do, it's, like, something like this. Let's edit visualization.

So, here we can choose the kind of graphic we want, we need. So, instead of a pizza chart, we can choose bars, horizontal, vertical, line charts. Okay. And save it.

And now it's done. Save it. So, let's view it. And that's it. So, this gives some information

for the population and gives some open data for those who want to use it in other systems or

integrate elsewhere, embed elsewhere. And the population can follow where the money is being spent or, in this case, what are the most problems that people are complaining or

which category of problems that's happening on the city. Okay. So, this is it. It's mostly a bunch of products, add-ons from Plone, that I had the opportunity to use and contribute a little

to do this. So, now I'm, oops, I compiled something wrong. So, the future of this.

What's the future? I don't know. But what I want to see or would like to see, it's

being supported by Plone 5 and Python 3. Internationalization to using other countries or other places. And integration, like, we have a lot of other products there, like, we use Django

and we have some systems that are written in Java. And maybe we have also some proprietary systems that were bought. So, we want to integrate everything with the Plone site

inside the portal. So, I intend to try to do something in this direction. And if you have an idea or any suggestion, I'd like to hear you. Okay? Those are my contacts. So, everywhere,

it's ramirulus, GitHub, Twitter, elsewhere. And my email, ramirulus.com. And now I'm talking about the people that bring me here. So, the first one is Dornelis. I don't

know if everybody knew or everybody that's in this room knew Dornelis. He supported me to organize the Python Brazil 6 and was his last Python Brazil conference.

Also, there are a lot of people that work at Portomo dello. One of them is Gia. He's also passed away. He's a very good friend of mine. And now she's his wife,

Rafaela. He's working with Portomo dello now. So, her work brought me here. And also helped to create Portomo dello and work with Erco. So, Erco, thank you. He helped me be

here also. And there is Alex. A friend of Erco from the childhood. And he's living

in Tokyo. And we went out to have some coffee together. It's a very good guy. I like it. Thank you. As I said, I was not working with Plone full time and not developing.

And sometimes I just appear in the IRC or the Gitter. And Tim was there. Always he's the first guy to answer. Everybody, not just me. Everybody. So, thank you.

Manabu, he did what I had to do this time. Travel around the road to go to Brazil. And we met there. I think two months ago he invited me to come here. I was not planning

to come. I was not even thinking about Plone Conf. And he sent me a personal message asking me to come. So, thank you, Manabu. And Tanya is a it was one of the organizer of the Plone Conf in Brazil along with Jafa Ella. So, thank you, Tanya, when you see

this video. And that's it. Thank you. Arigato. So, I think we have ten minutes

or less for questions. I will give you a microphone to recording.

So, what are the add-ons you are using on this?

It's a Portomodelo ombudsman office. Let me see if you have a tab here. Here's the interlaced Portomodelo. It's made for Portomodelo. I don't know if it will work with

anything else. This is the add-on. The other one is data visualization. That's it.

There's two add-ons I use it to. Any more questions? I didn't cry in front of you. I'm crying inside me. So, thank you, guys.

Latin America conference 2018. So, I have T-shirts here. I think that maybe we can have one of one for each other. So, you can just choose your size here. And there are some sticker also. Okay? Just came here and grab your T-shirt.