Hello everyone and thanks for attending. My name is Ryan Minook. I'm a Solutions Consultant here at FileMaker and I'm really excited to be your host for today's WebDirect webinar. Joining me today is Richard Carlton, the CEO of RC Consulting who's been providing specialized custom database solutions saving time and money over the past 24 years. I'm going to spend the first three to four minutes to cover some brief housekeeping notes and chat about FileMaker as a platform and then I'll hand the presentation over to Richard who will cover best practices and tips of deploying the FileMaker WebDirect. For the best experience, it is strongly recommended that you participate in this web seminar with at least a broadband connection. If you have any problems or require online assistance at any time, please contact Sickter's Technical Support at<PHONE_NUMBER>. Now throughout today's presentation, you will have the opportunity to type in and ask questions and let's talk briefly about how to do that. So go to the control panel, click on the questions section, enter your question and click send. And we'll try to answer as many as time allows at the end of our presentation, but remember you don't need to wait until then to submit a question. We're also giving you the opportunity to submit a question via Twitter. So you can tweet your WebDirect questions using the WebDirect Q hashtag and we're actually extending this Twitter Q&A session to all day today to about 3pm tomorrow. So what is FileMaker?  You create and design your solutions with FileMaker Pro or FileMaker Pro Advance that doubles as the desktop client. FileMaker Server is the hub of your solution. It hosts your files and provides security, backups and reliability. And to access your solutions on iPad and iPhone, use the free FileMaker Go app available from the App Store. And to access your solution via a web browser, use the new FileMaker WebDirect technology that is available as part of FileMaker Server. So we're a complete platform for developing custom solutions for Mac, Windows, iOS or a web browser. And today we're going to go under the hood a bit and focus on the best practices for deploying WebDirect. And with that, it is now my pleasure to hand this presentation over to Richard. Hey, I appreciate it, Ryan. So a little bit about me real quick, everyone. My name is Richard Carlton. I'm the CEO of RC Consulting. We have a staff based out here in California also in Texas. I'm a video trainer for the FileMaker platform. And we also have a new seven hour training course for FileMaker Go 13. And we are in the process of getting that released out to the community. Information about that is at FileMakerVideos.com. We're also working on a training series now. We're starting that getting that in production on WebDirect. And that'll be available as well coming up. Information on that will be out at FileMakerVideos.com. So if you're interested in more training on WebDirect, look to see that in the future. Also today's demonstration is largely revolves around our experience with converting FM starting point for use with WebDirect. And a lot of redesign and efficiency that we went through in bringing this tool up to speed for 13 and specifically WebDirect. And there's a lot of under the hood things that went on to make this possible. So going along with that, we made FM starting point for available. We shipped it last night. We will continue to ship updates for this product, but it's been greatly re-engineered under the hood. And we're going to talk about really what we did today to make that happen. It's a kind of a big deal. So first off, I want to set kind of everyone's expectations. What are you going to get out of this presentation? Well, I don't, you know, for an hour of your time, we want to make you successful with WebDirect. That's the bottom line. And what is this technology? Well, in order to do that, we're going to have to explain to you what WebDirect is and kind of frame the conversation about when to deploy WebDirect and maybe when not to. I need to show you some techniques for optimizing your layouts, especially if you have legacy layouts, how to basically re-engineer them under the hood. And if you do this, you may be able to speed up your layouts in terms of their download across the internet. Your performance may double. Certainly the weight of the layout will be half as much as it was. Now, depending upon your network situation, you may see based on a stopwatch the performance or the time of that load be half as twice as fast. So just keep that in mind. It's a pretty impressive improvement. So who should be watching this Web webinar today, right? The people watching this webinar will be folks who want to look at deploying basic web browser solutions without PHP programming. This is really a major step for FileMaker, and it's all part of the new FileMaker 13 platform. These are people that typically have been using FileMaker Pro, but they historically have come from the Excel world. Maybe they've been using a lot of post-it notes and organizing their lives that way. And while they've been successful with Pro on the platform and maybe go, they want to take the next steps. Intermediate and advanced users are going to learn a lot, too. I was talking to some very senior FileMaker developers the other day, and even they were not aware of some of the things that I was covering in this session. So please be aware that if you pay attention, you're going to learn something most likely that you did not know before. Also, I'm going to assume that for most people in this presentation, you're already familiar with the FileMaker platform. And when we talk about Pro or server, you kind of understand what these products are about. If you're still brand new to the platform, I'm going to recommend that you visit FileMaker.com and visit their FTS training. They have a whole series of basic training that's completely free. And I recommend that you visit this. Ryan's a big fan of this, and we've talked about this. And so it's a good place to start in your training of learning about the FileMaker platform. So what is WebDirect? WebDirect is the automatic rendering, and this is important, automatic rendering of FileMaker layouts and behaviors to a web browser automatically. It's a completely new capability for FileMaker solutions. It's a big deal. It is a complete replacement for instant web publishing. Now, if you don't know what instant web publishing is, that's fine. Don't worry about it.  WebDirect only comes. It's published. It only is hosted by FileMaker Server 13. You must have FileMaker Server 13. You can't get WebDirect without this product. Also, keep in mind that while we're talking about the FileMaker 13 platform, this is really version 1.0 WebDirect. The first time WebDirect has been shipped. So like anything else, version 1.0, there's a whole future here for WebDirect where it will get better, faster with more features. But like I said, this is the 1.0 version. I remember us talking about 1.0 Go back about four years ago and look at where we've come in the last four years with that product. So just keep that in mind as we look at this product today. This is just the beginning. So I want to jump out real quick and give you a quick demonstration of where we're at. Now I'm in FM starting point. I've logged into a FileMaker server here. And this is the main menu screen here. This is actually a server that's about 75 miles from my main across the internet here. And I'm in Santa Clara, California. This is a different office. I'm actually across the internet. It's a wide area network connection. I'm in a browser here and this browser right here is reproducing the FM starting point in a web browser. So this is a WebDirect client that you see right here. I've got kind of limited screen real estate right now just due because I'm in a screen share here doing a webinar for everyone. And so you see the menu right here. We've actually recreated all this in WebDirect for you. There's no PHP programming. I can actually come over here and click contacts. And I can do the same thing over here. And so as you can see, I'm going to flip actually that's on record two, but I can go back to record one. We're on the same person here in real time. So it's shared data. Now of course, normally you wouldn't have the same person logging on to two clients at the same time. But for the point of demonstration, you can see that the information is being shared in real time. And so just to prove that this is all real, I could say, for example, make an edit to this person's record right here and no big deal. The information changes in real time back over here. So we're showing that we've reproduced the FileMaker Pro layout into a web browser without any programming. It's really, really cool. And Ryan's bobbing his head up and down there. He's very excited to see this technology, right, Ryan? Yeah, WebDirect is very exciting. It's truly a big deal for FileMaker. And it replaces the instant web publishing. So that just kind of gives you an idea, just a basic kind of concept of what it is at the outset. Keep in mind here at the top, though, that FileMaker made the effort of keeping us in our comfort zone with the status area here at the top. You notice that we have the new buttons and the delete and the record scroll control so we can scroll through the records. All these things are preserved over here in WebDirect. So we have the ability to flip through records and do this type of thing here. All of this is preserved. At the top of FileMaker, we have some of the menus that operate and make FileMaker special, what it is. As many of these things as possible have been preserved in WebDirect as well. And so you start to see these over here. So the whole idea is when people get exposed to WebDirect and they've used Pro previously, it's not like they landed on Mars and they're a different planet, right? They should feel comfortable with what they're seeing because it really is the FileMaker platform just on a different piece of software in a browser environment. But there are differences and there are limitations and that's what we need to talk about here in this presentation. So first thing to keep in mind is that WebDirect is not as powerful as FileMaker Pro because it runs in a browser.  And so what we're getting into this positioning, this conversation, because it's important as a consultant or as a developer, or as someone who's responsible to people who are developing solutions, your customers, you want to give them the best experience, okay? The goal is not to, oh, we got WebDirect. Let's make everything in WebDirect. No, that's not the right answer. The goal is if you have 20 people in the organization, you might have 10 on Pro and 5 on Go and might be 2 or 3 or 4 on WebDirect.  And the goal for you as a good developer is to find that correct mix and deploy it appropriately. And so first off, for me to educate you here is to give you the positioning. WebDirect is not as powerful as Pro. Why? FileMaker Pro has a database engine in it. Server has a database engine. These two have been married together and working together for 20 years. The engineers here at FileMaker have been working hard for 20 years to make these work as well as possible together, interacting, giving great experience to the users, making the performance as quick as possible. If you think about how the performance has improved since FileMaker 9 all the way to 13, the product has been radically improved. So that's what the server to Pro product is, right?  Now, of course, we go to WebDirect. Well, there's no real product like WebDirect. That's a browser over there, right? And so there's no engine. So that means all the thinking, all the calculations, any sort of decision making that goes on like, oh, should this be a calculation? I got to calculate the sales tax in California for some reason, right? Or we got to do the value added tax in the UK, right? That has, if we're doing that in the WebDirect, the browser has to send a communication back to the server. The server has to make the thought, do the calculation, then send the results back for display back to the browser. Whereas in Pro, Pro would actually have helped us do that without even talking to FileMaker server for the most part. So now the engineering team has been smart. They've tried to cash on this information on the browser, but at the end of the day, there's only one engine helping us. And that actually limits the power of WebDirect, just in terms of the overall speed and snappiness of the client. So just keep that in mind. So major points, because it's not as fast as FileMaker Pro, you're going to want to use WebDirect for the occasional users or users who are outside the organization or maybe they want to deploy deployment issues with Pro. You can't get Pro into those users for some reason. Also, you need to be considering, think about the situations where people think about, oh, well, I have an Android device. I immediately want to go to Android. Well, the first release of WebDirect has not been optimized for mobile browsers. It's just the way this is. This is the 1.0 release of WebDirect. FileMaker is acutely aware that the world is going towards mobile. They understand that everyone expects this. And so this is high on their priority list. That being said, the 1.0 product, because the limitation of the processors on these mobile devices and the fact that they haven't had time yet to optimize WebDirect for these devices, WebDirect has not been optimized for mobile browsers. But pay attention, stay tuned, because in the future, things may change. Third point, keep in mind, once again, we talked about having the right mix of clients, right? Not just, it becomes the WebDirect show. WebDirect is not free. You think browser is free, therefore it's free, therefore it's all free, free, free, right? No. Using FileMaker Go or WebDirect requires a connection license to be purchased for your FileMaker server. This is where FileMaker is getting into the business of monetizing their product line kind of universally across the board. You need to pick the right client for the right job. Don't pick the clients because you think you can get a better deal on one end of it. You want to pick the right client for the right job. Pick WebDirect because it makes sense to deploy into a web browser. Pick Pro because you need the horsepower because you need more complex reports or persistent connections, things like that. But WebDirect, when it first came out, people, I got a number of emails, oh, hey, we don't have to pay for Pro anymore. It's going to be free because it's a browser and then, you know, basically we don't have to pay for FileMaker. We just have to buy a server once and we're done. It's not the way it works. You really are not going to be happy just trying to go down that road. Additionally, once again, you do have to pay for these connection licenses. And there is additional information on FileMaker's website about that. So just keep that in mind. So positioning, once again, this is not a downer, but just understand positioning because people's nature is what they are. If they think they can get something for free, then they go that way.  So if you have administrative users who are in the office working in FileMaker all day every day, they're running reports, they're doing a lot of crunching day in and day out.  WebDirect is for those limited sorts of situations where you have lightweight users who are out on the road with a laptop, maybe like a sales force that's out there connecting to the database. They need access to maybe client information. They want to put in a contact report. They have a new sales opportunity, something like that. They need to log in. They have a little bit of information they're going to put in and they're going to disconnect.  They're going to be doing a lot of work all the time. They don't need to be using WebDirect. Those people need to be using a serious connection like FileMaker Pro to be getting their work done. Another good area for use with WebDirect, remote users who are not part of your core company, trusted outside vendors, or other outside third parties, maybe people that you really can't for whatever reason say, hey, you must go by FileMaker Pro so you can be part of our team. Maybe these are suppliers that are going to be part of your supply chain. They're sending you inventory. You need visibility into the inventory situation with the supply chain, that kind of situation. They need to log on, see the situation within the database. WebDirect is a good answer for something like that. Also, we see this as if you've been around the FileMaker community for some time, you get into IT organizations some places where they will fight with you about getting FileMaker deployed. This is a guerrilla warfare kind of situation where you can use WebDirect to circumvent IT as necessary, right? That could be unpopular with where you're at or popular, depends who you are. But FileMaker Pro is a dedicated app and if you don't have administrative access to install it, you can't get it installed. WebDirect runs on a browser. As long as you have access to a browser, you're in, right? So you've just bypassed someone who was maybe standing in the way. So with all these kind of positioning things in mind, we've got that taken care of. I want to get into the optimization and the conversation about tuning your database. And it's going to get kind of a little technical here. And I want to keep track of our time. We're doing good on time. So first off, I want to say that simpler solutions are going to work just fine for the most part with WebDirect. But you want to keep some things in mind upfront. And first off is that solutions that are going to break are generally going to break fundamentally because you're operating in a browser as opposed to robust client like FileMaker. And what do I mean by that? Classic example. If you're a FileMaker developer, you know that you can pop a window open and then you can pop another window open. In fact, if you have a multi-file solution, you can have, every file actually has its own dedicated window, right? And so you get into a situation where you have a window open like this and then you have, well, maybe another support window open and maybe another support window open. That is not supported in WebDirect. It's actually not supported in FileMaker Go either. Both of these technologies are really single document interfaces. They allow you to have a single window open at one time. So this is all you get to see at one time. Now, you can have multiple windows that are open, but they're actually stacked on top of each other. You can't actually see them simultaneously. So if you want to see them like the person that has a giant monitor or you have two or three monitors and the windows are side by side, that's not supported technology of WebDirect.  Now, keep in mind in 13, that's also why FileMaker helped create popovers to help kind of alleviate this. So if you're familiar with popovers in 13, this helps us get around this to some degree. But just keep that in mind, this one window interface at a time sort of situation. Solutions need to be optimized so they run quickly. And that's really the focus of the rest of this presentation, right? So back in 2010, we had a similar sort of a realization and that is, and there's a lot of lessons we can learn if we just go back just a little bit in history here and I'm not boring. Trust me, there's a reason for this.  If you just take desktop layouts and FileMaker Go, you're not going to be fully successful. If you're still getting into FileMaker Go and making mobile solutions, you're going to figure this out. If you've already done this, then you know this. WebDirect is the same way. WebDirect really benefits from purpose-built, dedicated layouts. Even FileMaker in their starter solutions, if you dig into them and you actually look at them, the starter solutions that are provided in FileMaker 13 have their own dedicated layouts. Why is that? Well, there's just enough of a little bit of a difference in variation between the clients and how they operate that they benefit from having their own layouts. So how do we go about making really optimized layouts even for Pro or Go or WebDirect? How do we do this? Because everything that we do here is going to benefit the entire product. Well, first off, we need to review our deployment plans. And deployment plans, we're going to start off kind of at a very high level here. We're going to work our way down to very technical. It gets into user workflow. And I know that one of our esteemed FileMaker solution consultants, Andy Locates, is here staring at watching me across the country at this. And he knows what we're talking about here. This is what we call a directed workflow or workflow. The idea of what are your users doing?  We're going to give them the idea. We're going to talk to them about what is your user doing specifically to A to B to C? If they log in, what are they specifically doing? If they log in, we're going to give them a custom layout of a workflow that's going to meet their specific needs. And with WebDirect, that's really a perfect situation to tune your layout to meet the customer's needs. FileMaker developers conference back in 2013. There was also on TechNet now, the videos are there. There's a lot of sessions where people talking about user-centered design. And user-centered design is this idea where as a user is going through their workflow, the developer builds a solution around their needs. And so that's not really the focus of our conversation here, but TechNet is a community that FileMaker has. If you're not familiar with it, it's completely free. You sign up. Once you sign up, you can log on and get these additional free videos. And some of these are the DevCon sessions from 2013. If you miss DevCon, you can go back and watch some of these sessions. It's great. And some of these deal with user-centered design. So I highly recommend that you go ahead and take a look at TechNet and look at user-centered design. But that's kind of what we're talking about here. And so we want to look at building layouts that are specifically optimized for workflow and FileMaker WebDirect. And how do we do that? Well, the tips that we're going to dig into here are mostly new and specific to 13, but a couple are older, but most of it's brand new. So the first item that we want to talk about is this idea of why we want to lighten the layout. We want to lighten the layout. And what does that mean? Well, up above here, and we're going to get, and this is where it starts to get a little deeper. And you'll understand why this is as we get towards the end of the presentation. Here's a field. There's a label. There's a field. Why is this important? Well, under the hood in FileMaker is a block of XML. What is XML?  Just take my word for it.  This stuff is under the hood. It's what makes FileMaker work. Every time that an object is sent down through the network, it has to shoot this stuff through the network out to the client. So up here at the server, it shoots it down to the cloud out to the client. So if you have two objects, it only has to send two blocks. But otherwise, if you have 28 or 30 or 50 or 100 objects, all that XML has to be sent down. So we want to minimize the number of objects that we have with these blocks of XML. Right? Does that make sense? So that's the idea. We want to minimize the number of objects that we have that are going down the network. So if you minimize the number of objects, now check this layout out. This would maybe not be an ideal layout. Now, this is an old legacy database that we have at my company. It will never see the light of day for WebDirect, right? As is. It's just not going to work very well. There's this way too many objects. We kept tacking on and kept tacking on and kept tacking on. It's just so many things in here. It just would never work very well. And every little item in here has a block of XML. Now, if you look at this starter solution layout from file makers, part of 13. Now, this is very limited in terms of the number of items and the number of blocks of XML that are under the hood. But the reality is this is much cleaner in terms of sending down to the network. Now, is this a good solution for your organization? It might be way too simple. It's too simple for me. But just to give you an idea of, if you understand that shooting all these little blocks of information down, this is way too much. This might be too simple. So you need to be thinking about minimizing the objects on the layout. Well, then giving all these things, what's our first hot tip? Well, here we go. You want to break the objects into functional workflows. We're back to this conversation about workflow. Break them across multiple layouts if possible. Some WebDirect users may not need all the layouts. They don't need all the pieces of that complex layout. So why put all those pieces on the layout for them to load in the first place, right? So here is a contact data entry screen from starting point. Let's just say, for example, this is information in the office that we all need. But the people out in the road only need some of it. Remember, we talked about that sales team that was out there. They only need some of this information. And so we identify the different sections that are kind of functional. And this is fairly arbitrary. It's just for the point of conversation, but we identify these sections here. And we say that we only need like section upper left, maybe up here and maybe this section here. Or maybe we do need these two sections, but we don't need all these other sub tabs. They only need this, this, and then the notes. They don't need estimates and projects and all this other stuff. And they definitely don't need the photo because they know what the person looked like. They just met them. So then the idea is that we build separate layouts here. And it only draws one layout at a time. So when you're in WebDirect, you see this one here. And then you say, yeah, that's great. I finished this one, go next. And then you draw, then you get this screen here. And it's very simple. By you drawing a very simple layout, the performance is very, very, very fast.  And so that's the idea here. This is kind of this idea of optimized workflow, or as we used to talk about directed workflow, you're directing them through a specific process. So something to consider as you're building the system. And the reason for this, once again, just to summarize, WebDirect is sensitive to a lot of those blocks of data being sent to it, all that XML being sent to it down through the network. More specifically, it's not so much WebDirect, the browser is sensitive to the amount of data being sent to it, right?  And well, why would websites be so slow? Well, there was so much stuff on it, right? And so to make the website go faster or make WebDirect go faster, put less stuff on it. I know it seems really basic, but Ryan's giggling here, but yeah, I mean, it's kind of the way it is, right? You can't put everything on it. So overview of where our plan is. So we're getting, we started basic, high altitude, reviewing workflow, we're limiting our objects. Now we get into custom themes and shared styles, custom themes and shared styles. And this is really where the rubber meets the road, as we say. Hardcore optimization. If you're a legacy developer or someone new to the platform, the classic theme is not your friend, okay? And this is where I want to get into things. If you have come forward from FileMaker, you know, and I've been in this for now 24 years, if you've come forward, it doesn't really matter. This conversation is useful even if you're brand new to FileMaker 13 and then 13 is your first version. It doesn't matter. What we're going to show you here matters either way. But if you're bringing a database forward, especially if it came forward from 11 or earlier, what you're going to get as a database that, as the layouts are converted, they come forward in classic and the classic theme. And what you're going to see up here is, I'm going to highlight this up here. And instead of looking at all the red lines, this focus from my point is that right here, you know, this is the classic theme. The classic theme has a couple unhealthy things for you as it comes forward. The classic theme was designed to be compatible, bring forward compatibility with FileMaker 11 as you converted from 11 to 12. And so in doing that though, it was very inefficient with some of the under the hood XML and CSS. And so let me explain this and let me tell you how to optimize it. Okay. First off, there's no coding that you have to do here, but what I'm doing is I'm showing you what happens. First off, if you just converted for your FileMaker 11 file to 12, and now you're using 13, every object that you have has, you have a big block of XML. Well, part of that is a block of CSS. CSS is this descriptive language that tells the browser or FileMaker how to draw it on screen, how to draw that object. It tells how big it is, what the font size is, what the weight of it is, all these sorts of attributes to tell you how big an object is. A field has it, a label has it, a slide control has it. Every object on FileMaker layout has CSS. Well, with the classic theme, every one of these little objects has its own block, its own separate block, none of it's shared. And so as it sends all this information down, it shoots this all down separately. And so you go, well, of course, this is kind of every items unique, right? Well, in FileMaker 13, you don't have to go this way. In FileMaker 13, we can have them all share one block. And imagine if you shared one block of information, FileMaker sent that down through the network once, once, right?  The network performance would be vastly improved. Well, how do we do this? Well, first off, we take your layout, and I'm gonna walk us through this again in a second, but I'm staying in PowerPoint because it's got this animation here, so you can see this visually. You switch your layout to one of the built-in styles. We did a vibrant style, and then we customized what we called it RCC, but this is in starting point once again that you can download for free. And then we decided that we would customize a field style here, and we called it Field Primary Blue Text, right? And then we would select each of these fields, and we would say, hey, let's use this shared style. So as we start to take objects and we share them, we call it a shared style. So we have a theme, a custom theme, and then we start to share the styles. We're sharing this block of CSS. And so you never see the CSS. I'm showing this stuff to you right now. Unless you're a tech person and you dig under the hood, you'll never see this stuff again, but I'm showing this to you because it matters. And at the end of this, in just a minute, I'm gonna show you. I'm gonna actually get a stopwatch out. I'm gonna show you more or less what we did to show you what we saved. Now, we can do this with shared styles with fields. We do shared styles with buttons. Every group of similar objects in FileMaker 13 can have a similar shared style. A style is not specific to a field. How about labels? So all these labels are a specific font. They're a specific gray. They're this kind of thing. And so they have this label main, and we use Tahoma. So we labeled that, right? And so we created this whole experience like this. And so that was the whole idea here. And so I want to do a quick demo here and show you this of what we did. And so I'm just gonna minimize this just for a moment. So I'm gonna drop out of a web direct here because it's not so critical at the moment. But if we go into FileMaker 3, or correction FileMaker 3, starting point three, this is the version that we had before it was optimized. And if I fire this up, I can go into like accounts here and I go into layout mode. And I can look at the inspector up here under styles, right? And I can see this is a classic theme. I can see this is a classic theme. And so we know by digging under the hood and by timing things that each one of these has a highly inefficient block of CSS that we need to optimize. Well, what was the procedure that my team went to clean all this up? Now over here is starting point four that we did all the work on. We've done a ton of work on this. The number of hours is like a lot. And we're giving it away, which is crazy. I'll never quite figure that out. But anyway, so this is what we came up with. Now the fonts of colors are a little bit different just because we wanted to change things a little bit, but we could make them identical if we wanted to. As you can see, how do we go from here, which is classic, to a custom theme over here, which is RCC Vibrant. How do we do this? Well, what we did is first off is that we went to themes and we actually picked Vibrant and we switched. Okay. And it kind of, from the standpoint of the boss, that's me, it destroyed it. I'm like, oh my gosh, this is horrible. And then what I did is I sat down with one of my engineers and he went through and he slowly but surely rebuilt the layout to make it look like it does over here. Put the blues in, put the proper bordering, the rounding in, all that kind of thing. And then the idea was to select these items and they're already set up this way. But if you click these fields here, the idea was to select these fields and to give them a shared style. Now, if you look over here, they're already set to default. They're already using a shared style. But if you came up with a new shared style, like you came up with a new style, you could say this could be a blue text box, that kind of thing. You could come up with a new style. And that's what we've done over here. We came up with a, we have all sorts of additional styles in here, right? If you click over here, all these styles in here are ones that my team created and they're arbitrary. You could create your own style. So the idea is that you create your own shared style. So as I click over here, you see they're all shared, right? Now, every time you click on an object, this is the huge takeaway. You don't want to style these objects individually. You want to style one of them once to make it the way you want it. Then you want to select all of them together.  And then you want to select it over here. If that makes sense. And that way they all take on that attribute. That makes sense. Now they all shifted here a little bit, which is fine. But you get the idea that you are going to make it once. You're going to create a style for it. And then you're going to click all these and share it. You're not going to style each field individually, because every time you style each one individually, you're giving its own little block of CSS. Remember the red where each one had its own shared set. It was crazy. It was all over the place. You don't want to get into that. You want to have it shared. And then they're shared. They're all together with one block. So if you do this, you're like, oh, this is a lot of work. This is a lot of work. This is a lot of work. I can hear the people groaning on the other side of the webinar. Well, what is the upside to doing this? Can we talk upside briefly? Let's do that. Let's talk upside. What is the upside? Well, I wanted to run a test. The test is, I figured the most common thing that people do with starting point is they start on the home screen here, and they navigate from the contact button there you see there, and they navigate to the contact entry screen here. And so basically it has to load this contact data entry screen. And so how are we going to measure it? We need some sort of a very technical way of measuring it. So we download a product from a third-party company. It has nothing to do with file makers called Wireshark. It allows you to measure the bandwidth that goes across the network. And so we got that going. And then what we did is we measured file maker starting point three with the classic. And we got everything installed. And so then, yeah, so right here you can see this. This is the model, how we measure it from file maker server down to WebDirect. And so this is classic. So this is a classic theme with starting point three. One press of the button resulted in 850K downhill. And that's with this WebDirect 1.0. This first version of WebDirect is a 150K data push. That's a lot of data. It's almost a megabyte. That's a lot. You're like, oh, that's a lot. Yes, it is. It's also a very old, I mean, in terms of design technique, it's an inefficient legacy kind of design. It looks beautiful. It's free. You can download it, but it's not very efficient. Well, what if we use our new and improved technique? What are we going to get for that? All this effort, what do we get? Anyone want to bet? Bets, Ryan, bets. Place your bets. A third. A third. Do we get a third? I can do better than that. How about double, double, double the speed or half the weight? It's like going on a diet and losing half your weight. I like that. I'm a big guy. I always like losing half my weight. That's great. So anyway, so we, the weight of the same layout and starting point four is half and went to 425 kilobytes. And so that's huge. So you go, well, then suddenly how does that affect other clients? Well, here's the deal. The technology that we're using at the CSS is shared styles. If you do this for your layouts, your remote users that are using pro and the remote users that are using go, they will benefit hugely too. It's not just web direct clients. Filemaker technology, this platform, the CSS technology is being used everywhere. So if you have a remote user on a white area network, if you have an iPad user on a 3G connection, oh my goodness, they're going to have a huge benefit to seeing this, especially if you optimize these layouts like this. So just for giggles, we decided that we would say, well, what if we just remember, we just did that layout and it kind of went black and white. What if we just left it like that? What kind of performance would we get? Well, when we did that, it went down to 225. And so the difference between 425 and 225 was us adding our customization to make it kind of look our blue and gray and a starting point-ish kind of look. And so we did add some weight to it, but it was still much lighter, right, than our original. So that's, this is it. So if you want to know how to make things work better, that's the key. It's you've got to use shared styles in your custom themes. And this is new in Filemaker 13. Filemaker does not really, you know, in terms of their sales literature and things like that, they won't tell you that if you do this, you can make your product go twice as fast and strictly speaking, it's not always twice as fast. It pins upon your network.  But if you're out on the end of a 3G connection on an iPad, you're going to notice the difference. It's going to be huge.  It's a really big deal. And so I just thought I'd share this with everyone. That's a big piece of this. Now, as we move along, I have some additional, and I have a typo there, of course. We'll need to fix that somewhere along the way. When making changes and tweaking and layouts and things like that, the Format Painter Tool. I don't necessarily recommend using the Format Painter Tool to paint from one object to the next because it doesn't really use, it doesn't preserve the shared style, right? So as the idea, if you're familiar with the Format Painter Tool, I've got to kind of highlight it up here. It basically, for the lack of a technical term, it makes a local override and it makes a unique local settings to each object. And so it makes each object totally with its own unique set of CSS. The official method for making shared objects is to select them. And I've talked to engineering about this explicitly, is to select the object and to select the style over here. That's it. If you try to go up here and use Format Painter Tool, you're going to make inefficient objects underneath the hood. The engineering teams will wear this. Maybe at some point they will optimize that one tool. It's kind of a legacy tool, so it works. But if you're trying to make something very fast and efficient, I wouldn't recommend using that specific tool right there. As we move along here. Yes, backwards compatibility. This is as common sense. FileMaker 13 features don't necessarily work in FileMaker 12, right? If you make a custom theme and shared styles in 12, generally they render most of the time pretty well, but every once in a while there'll be little variations in things. We ran into a situation where it would be little minor things where you'll notice that there's a little funky redraw issues here, little things like that with 12. Certainly, if you have a custom theme and shared styles in 13, you don't want to go into layout mode in 12 and monkey with it because 12 will not be able to identify the fact that you have a custom theme. It just doesn't understand it. And so you're asking for trouble, so I recommend you stay away from that. I would assume that's common sense, but I'll just state that for the record. Got it. Obvious statements here for those of you.  Also, big tip here. Use the built-in tools at the top of FileMaker to do your buttons in your artwork. Stay away from using creating buttons in artwork in Photoshop, right? The buttons, basically FileMaker's buttons are basically vector-based artwork. If you don't know what that is, it doesn't matter, but the point is it's highly mathematically efficient in here, and this is not so much. So recommend that you use FileMaker's built-in tools and, if at all possible, leave Photoshop alone. Slide controls and tabs and popovers for that reason. You can use them, but keep in mind that the XML to describe these objects is a little deeper, and so if you want to use a lot of slide controls and tabs and popovers, you need to try them out after you put them in. Always test your work as you use it. Objects that are not exposed by tabs and slide controls and popovers, there's no penalty for non-exposed content, but as soon as you actually view the content, it's going to go back to the server, it's going to ping the server to bring back the content. So if you understand what I'm saying, so if you have a popover, it's just the object, the little button there, you're going to get some XML for that button, but as soon as you press it, it's going to go back to the server. Remember, we only have one engine on one side. It's going to go to the server, get the information, bring it back. Now, this is one of those really rare moments where I was very stoked about WebDirect because WebDirect generally is slower than Pro, except in one area, and then it's like just devastates FileMaker Pro being so much faster. The way FileMaker server works is that whenever you do a sort, it sends the sort information downhill to Pro, or to go and Pro and go do all the sorting down the network, which is an interesting conversation. You can have some time with FileMaker Engineering. I'm not sure entirely why that happens the way it does, but it's just the way it is. But with WebDirect, they can't do that. There's no engine to send it to, so it stays on the server, right? Well, the side benefit of that is that the actual sorting actually occurs on the server. And so we did this test with like 300,000 records or whatever it was. And it was 57 seconds with WebDirect to sort this huge block of data versus 227 seconds with FileMaker Pro. So WebDirect actually, when you're doing sorts in a database, actually is way, way, way, way, way faster. So that's kind of a cool thing. So it's kind of an interesting byproduct of the way WebDirect is engineered. So just keep that in mind. It's just one of those little things, and we thought we'd get the stopwatch out and test it. Of course, your mileage will vary, and we put the server specifications here if anyone's interested, but it was an interesting test. So that kind of, we get kind of into a Q&A section here a little bit. We've got kind of the overview of what we had. We had a review of the workflow. We limited the objects. Why? Because there's XML under each one, and then you do custom themes and shared styles, and that is the huge part of efficiency. Right, Mr. Ryan? Yes, sir. So what do we got for questions coming in from people? Well, first off, thanks for that presentation, Richard. A lot of great information there, and thanks everyone for submitting your questions during the webinar. We had a lot of great participation there. If you haven't already, please submit your questions now. And again, we also have the Twitter account with the hashtag WebDirectQ, if you want to submit them after today's session. All right, so let's go ahead and start, and we'll start with this question right here. To view a website containing tracking info, is there a way to make a URL link that will take the WebDirect user to a web browser? Yeah, that's the open URL commands one way of doing that. In fact, there's actually a little demo of that in FM Starting Point. If you download FM Starting Point and you click the video training, at the top there's an ad for our training, of course, which would be nice, our seven-hour training series. If you press that, it pops open a window and allows you to visit another browser. So yeah, that's built right in there. So yeah, that's an easy one. And kind of going off of that, the next question, will web viewers work with WebDirect and web viewers are supported in WebDirect? Okay, the next question, can you use WebDirect for a solution built in FileMaker 12 and hosted on FileMaker Server 13? Yeah, I mean, 12 and 13 have the same file format, but the reality is you're going to have to basically use, you can't use Server 12. You have to use Server 13, and at that point you just might as well upgrade yourself to the 13 platform, right? So I mean, the short version is, I mean, there's no conversion process, but you're going to need to move up to 13 to do that. Right. Okay, the next question, can you hide menus or layouts from users with WebDirect? Menu restriction, yeah, you can restrict the status area across the top and you can't, can you do, and the menu bar in the status you can hide and lock? Hide and lock both of those, which is nice. I normally, with starting point, we normally leave the status area visible across the top because I don't want to reproduce the navigation, and I'm big on people learning to use the basics of FileMaker, but you can restrict that. So that's a good one as well. Okay, and the next question, are plugins supported with FileMaker WebDirect? Okay, this is a good question, and this gets into probably one where you'd want to go to, you know, download of training or something like that. Plugins, normally plugins, people assume you install it on the client. Of course, you're not going to install a plugin on the web browser. You can install some plugins. You need to check the vendor for compatibility. You can install some plugins on the FileMaker 13 server. Then you can call a script from WebDirect. That will run the script on the server, which will activate the plugin. So indirectly, the answer is yes. But the plugin has to be licensed and installed on the server. So if it seems normally you would install it on the client level, you'd install it at the server, and then all the WebDirect people share it, if that makes sense. Okay, how about, can you tell me just the main differences between Instant Web Publishing and FileMaker WebDirect? Yeah, that's a funny one. Instant Web Publishing always wanted to be what WebDirect was. It never could quite get there. WebDirect actually does render what the layout pretty much looks like. Instant Web Publishing had a lot of limitations in terms of the number of records it would show, the kinds of the way the layout would render things like that. It was kind of a train wreck from my perspective. But I'm not a FileMaker employee, so I can say things like that. But I can also be objective, and when I tell you that something's a train wreck, when I tell you it's also something else is great, you can believe me. WebDirect is finally, finally, finally what Instant Web Publishing should have been, and it is now. I'm very, very, very excited to see that. It actually does render the layouts really, really close, almost identically the way they should be, which is exciting. That's the whole point. Instant Web Publishing just had a lot of limitations. It just did. There's a long, long list, and a lot of people when they get into it were disappointed with it. Now, there's some people who made a living using Instant Web Publishing, but it doesn't matter at this point, it's going and it works so much better. Just the way it is. I'm pretty passionate about that one. Okay, so for the final question, is conditional formatting supported in WebDirect, and if so, is it advisable? Conditional formatting is, most of all the technology is supported. Conditional formatting is supported. A lot of the technology is supported. What happens is that every time that you do something like script triggers, most of the script triggers are supported in WebDirect. The rub is that every time you twitch or do something in WebDirect, if there is any sort of like mental thought, like you have to have a thought, WebDirect has to go back to FileMaker Server to have the thought. You can't have it on your own, right? You don't have a brain, right? The brain is at FileMaker Server. And so every time, if you start loading up your screen with all these little additional calculations, every time you trip one or you step over something and it fires, the browser goes back to talk to server, which causes this little bit of a delay. So you can put conditional formatting in there, but every time you add one of those, or every time you add a script trigger, you may actually cause a little bit of a performance delay. You need to test and decide at what point you're adding too much overhead to it. If the conditional formatting is a nice to have, oh, that's pretty. Oh, that's nice. Oh, it's blue now instead of green. You might want to just toss that over the fence and give up on it, because you're adding overhead to this, you're hurting your performance, right? If it's really mission, like you have a script trigger, it's really important if it hits the certain inventory level, it's going to put a big message up saying you can't sell anymore because you're out of this. That's an important thing, right? That's not a nice to have, that's important. So you got to decide what's really important and what's a nice to have, because it really needs to be treated that way. Well said. Okay, so let's talk about some next steps. I know Richard, you're talking about the FM starting point. Where can they get that? FM starting point is available at literally at wwwfmstartingpoint.com It's all one word. And if you have questions or comments or you find a bug of all things, feel free to email us back about that. We are working on it continuously all the time. But everything here in terms of all this efficiency stuff going through all these layouts, we did that to every layout and there's hundreds of layouts in there. So it was quite the workload. And so we've done that, so all the efficiency has been built in there. So that's a big part of it. Great. So this web seminar will be recorded and posted to the web seminar page on FileMaker's web seminar page on the websites. You can find it underneath the training section. And if you haven't already feel free to download the FileMaker and start exploring WebDirect today. As you can see on your screen right now, if you're ready to consider licensing and you want to purchase more than five seats, you want to contact your volume licensing sales rep and either the URL posted at the top of your screen or call 1-800-725-2747. As you can see FileMaker monthly prices start at $9 that's little for FileMaker Pro and $29 monthly for FileMaker server. Again, if you want to learn more about the pricing for the concurrent connections or the WebDirect connections, feel free to go to the FileMaker store and take a look at FileMaker server and plug in the amount of connections that you'll require.


I am Dr. R. V. R. Githi from CAC department of W. A. D. Shalapur. The today's video topic is on online analytical processing that is OLAP. It is a very important topic of a data warehouse and mining. The learning outcome of this video at the end of this session, student will be able to acquaint with OLAP operations that is online analytical processing. They will be able to utilize OLAP for data mining and knowledge discovery activities. Basically, we are doing the mining of data to infer some knowledge. Now content of the video introduction to online analytical processing, then OLAP operations, different operations, advantages, disadvantages of OLAP operations. Now, first of all, OLAP, let us see the definition of OLAP. Online analytical processing is a computing method that enables users to easily and selectively extract and query the data in order to analyze it from different point of view. Means extracting the data, then extracting the data by making the query and doing the analysis to get some inference that is OLAP. OLAP databases are divided into one or more cubes. The cubes are designed in a such a way that creating and viewing reports become easy. The OLAP cube is a data structure optimized for very quick data analysis. It consists of numeric facts called measures which are categorized by dimensions, OLAP cube is also the hyper cube. Now look at this figure one that is cuboid. This is a cube where the product, date and the country, these are the three fields are shown. Here it is country, it is data and here it is a product. The products are VCR, computer, TV and the countries are that is sale that has happened in the country USA, Canada, Mexico and summation of all those. And in the third, in the third axis that is that sale has happened in the quarter, in the second quarter, in the third quarter or in the fourth quarter of the year. So this is an example of sales of VCR, PC, TV in which quarter or in which duration and in which country the sale has taken place. Now OLAP operations, there are four type of operations in OLAP. The first one is called as a roll-up operation, second one is called as a drill-down operation, third one is called as a slice and dice and a pivot. Let us see one by one, first roll-up. Now if you look at this figure, if you look at this figure, it shows that the PC book show clothes, okay on the left hand side quarter one, quarter two, quarter three and quarter four that is the first three months, second three months, third three months and fourth three months of the year and on this side, on this side the name of the country that is Sydney, Perth, Los Angeles or name of the cities are displayed of various countries. Now these are rolled up on a location, on a location means I want to see, I want to see the sale which has happened in the quarter one from USA. Now in USA there are two cities are there, so roll up those two cities roll up those two cities and give me the one data adding those two data of Los Angeles and New Jersey into USA. Here roll-up is also known as a consolidation or aggregation, the roll-up operation can be performed in two ways. It is reducing dimensions means Los Angeles and New Jersey are rolled up into one that is USA, reducing dimensions, then combining up concept hierarchy. Then similarly in this example cities New Jersey and Los Angeles are rolled up into country USA, then the sales figure of New Jersey and Los Angeles are 440 and 1560 respectively, they now become 2000 after rolling up. This is what the effect of roll-up operation. In this aggregation process data in location hierarchy moves up from city to country. In the roll-up process at least one or more dimensions needed to be removed. In this example quarter dimension is removed. Now let us see the drill down operation. Now this is exactly opposite of that roll-up operation. On the top of the cube quarter 1, quarter 2, quarter 3, quarter 4 that is three months data is shown over here. Now that can be drilled down to January, February and March, then quarter 2, April, May, June and July and so on. And here instead of name of the country, well let us look at the time and dimension. In drill down data it is fragmented into smaller parts, it is the opposite of roll-up process. It can be done via moving down the concept hierarchy, increasing the dimension from one to three or four to four into three that is twelve. Then one quarter is drilled down to months that is January, February, March corresponding cells are shown or displayed can be viewed. In this example dimension months are added. This is what the drill down operation. Let us go for the third operation that is slice and dice. Now in the slice and dice operation, the quarters are displayed on the left hand side over here. Those quarters can be further divided or fragmented into months that is January, February, March to December and drill down is taking place on the attribute time. And in the second part of this figure, this is an example of a slice, only the quarters and the first part of the cube, this part will be displayed as a slice, means we are taking the slice of bread. Similarly, only that much part will be displayed or that data is required. Whenever that data is required, the slice operation is used. So this is how slice and dice operations are taking place. Now this slice operation is for quarter one. Now all of operations pivot. In the pivot, we can rotate the data access to provide a substitute presentation of data. The same data can be shown in different manner. Now in the first figure over here, the item on the left hand side, it was the name of the cities and on the X axis, they were product. Now the same thing, if you rotate this, so what will happen on the Y axis, the product will be displayed and on the X axis, the name of the city will be displayed. Well, take this question, compare roll up and drill down operations in OLAP, take a pause over here and think and give answer of this particular question. Now roll up operation, the difference between these two.  It is performed by climbing up a concept hierarchy for dimension and here it is stepping down that is opposite to that of roll up, climbing up and stepping down a concept hierarchy for dimension. Now here reduction will take place and here introducing new dimensions. On rolling up, the data is aggregated by ascending the location hierarchy from the level of city to the level of country. On drilling down, the time dimension is descended from the level of quarter to the level of month. Now, let us see what are the advantages of OLAP operations. In OLAP operation, OLAP is a platform for all type of business, included planning, budgeting, reporting, analysis, information, calculations are considered in an OLAP cube Quickly create and analyze, easily search OLAP database for broad and specific terms. OLAP provides the building blocks for business modeling tools, allows users to slice and dice of the cube for the various dimensions, measures and filters. It provides faster response time. It is good for analyzing time series, finding some clusters and countries easily. The disadvantages of OLAP operations are it requires organizing data into a star or in a snowflake. These schemas are complicated to implement and administrate. You cannot have large number of dimensions in a single OLAP cube, that is one disadvantage. Transactional data cannot be accessed with OLAP system. Any modification in OLAP cube needs to be pulled, updated of the cube. This is time consuming. These are the references, I hope you understood. Thank you.


Excellencies, distinguished participants, ladies and gentlemen, I would like to start by thanking the President of the General Assembly, His Excellency, Mr. Miroslav Lychik, for the invitation to moderate the panel on contribution of the water decade to the implementation of water-related SDGs, addressing challenges and saving opportunities through strengthening cooperation and partnerships. I now invite our fifth speaker, Mr. Satguru, a yogi, mystic and visionary to deliver his remarks. Mr. Satguru is one of India's 50 most influential people established Isha Foundation, a non-profit volunteer-run organization operating worldwide. Mr. Satguru has initiated several projects for social revitalization, education and environment through which millions of people have been given the means to overcome poverty, improve their quality of life and achieve community-based sustainable development. In the fall of 2017, Mr. Satguru initiated Rally for Rivers, a nationwide campaign aiming to implement sustainable and long-term policy changes to revitalize India's severely depleted rivers which found great support among India's leadership and the people. You have the floor, Mr. Satguru, please. Good afternoon, everybody. The first and foremost is to make everybody on this planet to understand that water is not a commodity, it's the life-making material. The stuff we are made of, over two-thirds of the planet is water, two-thirds of our body is water. But where is the water gone? Actually, water is not gone anywhere. Earlier water we had on this planet a million years ago, we still have the same amount, it's not gone out of the atmospheric space, but it's just not where we need it. We are not able to service the people with the needed water and water the reasons, why is it happening to us like this? I would limit myself to the situation in India and in many ways this situation is relevant to all tropical regions of this planet. India has been always referred to as land of seven rivers, but we have over 700 rivers. It's a very richly waned land in terms of rivers, but in the last fifty years the depletion of rivers on an average has been nearly sixty percent of depletion of water has happened in the rivers. Why is this so? What are the causes? There are many things to do, but fundamentally we must understand there are two types of rivers, glacier fed rivers and forest fed rivers. In India only four percent of the river water is glacier fed, rest fortunately is forest fed. In the rest of the world seventy-two percent of the rivers are forest fed. So that is also fortune. Why I'm saying it's fortunate is because we can put back the forest, we can put back the vegetation, but we cannot just bring down snow whenever we feel like it. It's important that we need to understand like a country like India, we have an average of forty-five to fifty days of rain or precipitation. What comes down in forty-five days, we are required to hold it in the land for three hundred sixty-five days. If this has to happen, it doesn't matter who says what and thousand different opinions, but fundamentally you can hold the water in the land only if the soil has the necessary organic content and there is vegetation. Today it is understood that to call soil as soil a minimum of two percent organic content should be there, but today nearly twenty-five percent of India. The organic content is point zero-five percent. That means we are converting rich soil into sands. That means desertification is happening at a rapid pace. I am not an environmentalist, I am not a scientist nor am I a policy maker. But my engagement with life around me has been from a very early childhood. My involvement with forests, mountains and rivers has been very active right through my life. And with great concern I have been watching particularly in the last twenty-five years how the rivers that I have known since my childhood, how they have depleted. Particularly in the last seven years, the depletion is so sharp and alarming that we invested a certain amount of time and effort and energies to study these things and see how to revive this and made a policy document, a recommendation, policy recommendation, seven hundred and sixty-eight recommendation to the federal government in India. It is heartening to see that there is a broad understanding about this in state governments and in the central government. When we presented the policy document to the prime minister at six-fifteen in the evening last October second, next day morning, eleven-thirty, we got a call from the prime minister's office saying that they want a soft copy because prime minister has formed a special group to look into the policy. So obviously the enormity and the urgency of what needs to be done is definitely gotten into the minds of policy makers in, at least in India, I'm sure it is on with the concern with which everybody is speaking from various nations. This urgency and enormity of the situation has sunk into all of us. So we know what is the problem. We generally know what is the solution. It may be little more specific to each nation and each geographical location but generally we know what is the solution. Now the problem is implementation. The problem is getting everybody's cooperation. The problem is the size of the solution. How do we put it on the ground? This is a big problem. So one thing is definitely every nation in collaboration should form because ecology is not something that respects national or political boundaries. Rivers don't have boundaries, whether of states or nations. So to be able to form an international policy may be region-wise, tropical region and subtropical regions and temperate climates like this we could make but a comprehensive policy that everybody will agree to and start implementing because a time has come that in the next it's it's really a fantastic day today that we are talking about a decade of action. Not decade of talk, talking, a decade of action which is a very good terminology and very good intention. Now we have to get into action, obviously United Nations does not have geographical presence, it is the nations on the ground which need to act. So whatever the advisory is, whatever the decisions made must become policies in every nation. There are a variety of situations in this which are culturally linked and we have to be sensitive to this otherwise it won't work on the ground. So one thing we are doing in India is one simple solution we offered is in the river and land in India, twenty-five to twenty-seven percent is still owned by the government. So we are talking about all the government owned lands except for allocations for next fifty years of development except for that everything else must be converted into forests. The remaining nearly seventy percent of the land is farmland. You cannot ask a poor farmer who is fighting for his survival to save the river or ecology or the world. So we have an economic plan with significant ecological impact that is a minimum of one kilometer on either side of the river should become tree based agriculture. We have in small models proven that by moving from crop based agriculture to tree based agriculture the farmers income can go up anywhere between three to eight times. This is an economic plan but significant ecological impact will happen. There are encroachments, there are sand mining and there are various other things. For all these things we have a policy recommendation. These recommendations are very implementable and practical which is relevant to every tropical nation as I said earlier but the important thing is we need to understand these are two types of rivers. We have forest fed and glacier fed. Glacier fed rivers we just have to look up and pray that something right happens. But forest fed rivers we can revive. Fortunately it's more than seventy percent of the world's rivers and over ninety percent of Indian rivers are forest fed. So getting them back is not such a big challenge if there is a committed approach to this. Maybe we will not be able to put back forests but we can definitely put back tree cover in the farm of tree based agriculture. For example India is right now importing nearly seven billion dollars worth of timber. So we are trying to get a policy across that there was a colonial policy that if you cut a tree on your land you can't transport it you need permission to do it. We are trying to take away these old rules so that people will be encouraged to plant forest trees on their land because it will be an economic proposition. Without making ecology without marrying ecology and economy there is really no solution because if there is no economic benefit getting the masses involved is not going to happen. A dynamic policy is needed but very important thing is a mass involvement of people without people's participation is not going to happen and people's participation will not come unless there is economic benefit attached to it. So talking about saving the world we can give any number of lectures it won't work. The reason why India responded the way it responded to rally for rivers because it was an economic plan hundred and sixty two million people participated in a one month long rally across the country. This is the largest ever for any ecological moment because ecology means it is a concern of a handful of people who are worried about the future we are worried about the present that is a attitude. If you want to describe these two dimensions people understand economy as today's issue ecology as next generation's issue. Now ecology is this generation's issue this has to be made an urgent possibility and whatever we do unless we make ecology into a lucrative process for the large number of people involved in it large masses of people will never involve themselves in making this happen. When we look at the water depletion that's happened just to I mean we live in southern India and the kind of depletion happened today it's in news that Bangalore city which is known as Bangalore in the rest of the world when I was a child there were over thousand and twenty ponds and lakes in Bangalore city and three perennial rivers. I'm talking about perennial water bodies today there is no trace of these rivers we don't even know where they are anymore. Everything is built upon and only eighty-two lakes and ponds existing out of this forty-four of them or just sewage water only about thirty-six to thirty-seven perennial water bodies have actual water rest is all sewage. This has happened in forty years time this is what we are doing this is the pressure of population. Human footprint has become so broad that there is no room for anything else to happen on this planet. We have to understand when we say life we are not talking about just us but every other life because if insects, worms, birds, animals and trees disappear this planet cannot exist there will be no life on this planet but if you and me disappear the planet will flourish wonderfully well. So we need to understand that in the scale of significance their significance on this planet is far more than us though we may be a dominant force right now we are a recent happening we may also have a very near ending if we don't handle ourselves right. This is not that planet is in peril planet is not in peril it is only human life which is in peril. That will recover if we disappear if all of us go to sleep for twenty-five years everything will be back and everything will be wonderful. So we are also wonderful but we are just little too many we need to understand this. In two thousand at the beginning of twentieth century we were just one point four billion people today we are seven point three billion people in twenty-fifty United Nations is projecting we could be nine point six billion people why are we making predictions like astrologers why don't we have a plan by two thousand fifty what population we want to have because this planet can only sustain that many but we don't have a plan we are going on making predictions it's time this a decade of action must seriously consider population because that is the big elephant in the room we don't have an ecological crisis we have a population crisis we're just too many people if we don't plan for a sensible population in the future if we do not consciously bring it to some kind of solution nature will do it in a very cruel way that's all you're seeing what you're seeing is what a crisis is nature's way of controlling our population and this could become very severe and from what I see India and some of the African nations will take the first beating on the way they will get the first beating in fact the most severe impact will be on India and African nations so this is a very deep concern this is not like I'm trying to paint a doomsday picture but if we go on business as usual we are getting there there's no question about it and as we have seen in India many villages are completely empty now people have moved away from the village because there's no water anyway whole villages are gone so this essentially means as water crisis progresses more and more people will try to migrate to the city if too many people migrate to the city where there is necessary infrastructure is missing we will we are looking at a very severe civil strife we really fear what kind of civil strife can happen in the next 20 to 25 years in a country like India unless we take corrective action today and I'm glad today we are starting a decade of action as I said fortunately our rivers and water bodies are largely forest-fed that means we can put back the vegetation and revive these water bodies quite effortlessly we have seen and demonstrated this happening but now we are looking at large-scale demonstrations in some of the states in collaboration with the state governments many states are going into a huge plantation drives like never thought of before they're talking about tens of millions of trees being put on the riverbanks and in the catchment areas this is the only way you can take care of river fed I mean forest fed rivers ice fed rivers glacier fed rivers are a different matter that is not going to change just like that that has to go through a whole lot of process above all today I would like to appeal to every one of you as I said if not an entire globe at least region-wise cooperation and common policies are a must for the future well-being of generations to come thank you very much I thank mr. Sadguru for his very interesting remarks there is no doubt that your great experience and initiatives will raise awareness across the world regarding deteriorating conditions of rivers and encourage people to take actions your remarks have certainly enriched our discussions excellencies their participants I now open the floor for comments and questions first one of on my list is mr. Peter ng chief executive of public utilities board head of the Singapore National Water Agency please the floor is yours excellencies do you agree with me that portable reuse should be made a priority for the world if we are serious about achieving SDG 6 and if you do then surely the UN has to play a leading role in this it has to become an advocate for the endless reuse of water and it has to deploy its influence to encourage and to persuade member countries to adopt the portable reuse of water as Singapore is considerable experience and expertise in this area we stand ready to advise and to help thank you I thank mr. Peter ng the distinguished participants the floor for comments and the questions is open please if you want to make any comments please press your microphones recycling and reusing water is no more an optional thing it's something that we have to do because of concentrated populations in cities but one most important thing which generally not been addressed in most nations is as we know over 70% of water consumption is agriculture in India it is 84% is agriculture shifting from flood irrigation to micro irrigation would make a huge difference but micro irrigation has its problems when land holdings are very small so aggregating the irrigation process is an important part of this only if we do that water consumption could come down in a way that it's significant and noticeable reuse of city water whatever domestic water we use is definitely has to be done there's no question about that but micro irrigation moving into micro irrigation aggregating irrigation process is a very important step that nations need to take and mr. Sadguru please the floor is yours it's a truly commendable that we have heard that the prime minister of Singapore consumes recycled water to make the point how safe it is that's wonderful but that level of purification there are economic issues for countries like India and many other nations so what we are looking at is our daily sewage volume in the top 200 cities and towns in India amounts to 36 billion litres per day this can easily irrigate anywhere between three to nine million hectares of land with micro irrigation and we've always found when we bring micro irrigation naturally women get into the act because micro irrigation needs a certain level of patience and generally we find men want to rip it off because it doesn't work is the woman who have the patience to go to every point and fix it so naturally their role in agriculture and food production would be greatly greatly enhanced if we move into micro irrigation and we can bring down the water consumption a agricultural sector by at least 40% this we have demonstrated in many places at least by 40% and that would be the level of recycling we need we don't have to necessarily recycle it to a point for human consumption but for agriculture it's much easier to do it and economically it's more relevant to us


But it makes sense. I thought he would just put pressure on. Ooh, he tried to get Fee. You fancy, huh? Oh! What? Nothing fancy about that. He just said, yeah, okay, enough block straight. How's it going, everybody? Dottonoi here back with some more Dragon Ball FighterZ ranked matches. And today we are playing the usual duo of Krillin and Yamcha, but with Android 17 up on point. And I've said this before, but Android 17 has to be one of my favorite point characters to play in the game. I just got hit by a Super Dash. Hopefully that doesn't spell demise for the rest of the game. He's just so much fun to use. I wish, hold on, drop the elbow. Oh, that doesn't work. I would have had to EX it. That's fine, drop the elbow again. The buffs they gave him to just open up more of his tool kit were so cool to me. That's the kind of buff I would love to see more of in the game. Ooh, that rock bounce back. He was smart enough to hit a button. Back dash, we avoiding stuff out here. Get him back in the corner. Uh-uh. Ooh, hold on, let me dance on him then. Roll back. Uh-uh. Hold on, you gotta make your own sound effects with 17. That's the thing. That's another thing with 17 is that you gotta add your own sound effects. Otherwise, how will you? Oh, come on. The elbow drop almost works. 17 just drops elbow. Finish again. Get him back in the corner. That's how we get reflected. But not for long as we are right back there. I'm gonna do it again. Oh, I really wanted to try to catch him. Oh, whoa, whoa, whoa, whoa, whoa, why did he wake up with a draggy rush? Does it matter? Either way, it's going to work and take outside. Can I get a quick lunch? Okay, we still got the lunch. We live because of it. Hey, Chugs, where are you running? You can't pull something like that and leave. Get out of here. We accidentally leave. He spared us, dude. He was like, okay, yeah. I don't know why I did that, but it worked. Oh, the high speed Yamcha Blitz. A risky maneuver after the nerves. But still, sometimes it just pays off. The 17 have power blitz built yet. I don't think we actually did a power blitz combo. So we're gonna get a launch with Yamcha. That could have been safe to click buttons. Behind the back. All right, nice. Oh, come on. All right, I'm just, oh, I went out and Krillin. Krillin was not the one who was supposed to be out. 17, nice assist. Blows away, baby. Oh, got hit with a 2M. That's gonna be a lot of damage. Maybe not. Baby assist didn't come back. Just a decent bit of damage. Tech that. Not really. We'll just go ahead and fight it. Overhead, where, don't run. Curve it up. He's gonna try to vanish. Oh, I tried a 2H stat. I thought I could for some reason. I was really, if you were to ask me, I would 110% said I got this. Unfortunately, I think Krillin might be gone. Yeah, he's dead. All right, all right, I see you. I see you.  You did blow up Namek, so for whatever that counts. Area assist. Honestly, I don't wanna put 17 at risk. I'm just trying to get Goku blue out here.  Super jump. No, not good enough. All right, set up the barrier. Oh, okay, you wanna do it yourself. All right, if Goku blue is not gonna come out, I'm gonna have to force him out. Do we read sparking? Do we try to read sparking with Yamcha? We can, but I think I'm gonna take the 2M. Read it. Oh, he didn't do it. He's not flinching. He doesn't wanna spark. There it is. Switch. No way he picked us up. We live though. Get hit by the Vanish. Getting hit by Vanish is can be okay. Oh, nice. He's really trying to get us those spark with 17. We're trying to save him. No, Super Dash to bit too late. And that is gonna be all she wrote for 17. In those Super Dash versus Super Dash moments, oftentimes you just wanna be the one to click it for the Key Blast come back. I forgot. Man, we're getting done in by Super Baby. He's just a wall. He knows we want, take that. I'm not gonna hit by that. He knows we want Goku blue, but he's not willing to give it to him. Fine, I'll take him myself. Come here. Come here. That's not gonna work. I don't know why I thought I was in sparking. Oh, okay, he didn't spend three bars. He might commit to three bars now though. Don't, okay, he didn't. Oh my God, he wants the Super Dash so badly. Oh, he hit it a second before it's a smidge. Drop it. No drops. We're gonna go down two. We're gonna go to a one game in the first to two. That's bad. All right, we can clutch it out though. We can clutch it out. 17 had a good performance. We just kind of messed it up for him a bit. That's fine. I can, all right, we got this. Hold on, 17. Let me get you some help.  Boom. Oh, we lost the tie. We clashed and then I couldn't get ready. I couldn't get ready to get him on the second one. I'm an early spark, dude. We want control. Oh no, come on, we need control. Oh, I'll take that. I'll take that for sure. Power Blitz. Oh, let's go. I'll take all that. Give me all of that. That was close to not comboing. Reeds. Oh, I knew what I wanted. Oh, Yamcha, thanks man. Yo, Yamcha actually finished the job. I didn't expect that. That was sick. Oh, baby, be a cyst. It locks you down. Still so good. Still so good. All right, on the ground, what do I do here? Tech. All right, we're looking for that. But he doesn't have any assist. The tech is a behind the back. Oh, can you stop the cross-up though? Can you stop the cross-up is what you need to know if you're gonna be 17. Nice. He's gonna hit Super Dash here pretty soon. Oh! A beauty. I wasn't watching out for that one, but it makes sense. I thought he would just put pressure on. Ooh, he tried to get Fee. You fancy, huh? Oh! Wham! Nothing fancy about that. He just said, yeah, okay, enough block straight. I am throwing you out into space. And again, this man has destroyed Nammock. No love for Planet Nammock, huh? And he does have Spark, so he has that advantage over us. We have to kinda act quick here. If we wanna win this game, we need to be in control 24-7 now. That's exactly what I'm aimed to be. Oh no, I missed my dash. There we go. Okay, making up for the last dash with that one. This should be the end of trunks. Two bars going on three. We're probably only gonna need the two. But I'm gonna keep curling out front now. Oh, one bar. I underestimate destructiveness sometimes. I really do. I gotta stop sleeping on the boy. Mash. Oh, I knew. I just felt like we'd have an advantage there. Let's go. I'm mashing now. And you know what? I gotta put him in the mix with the object. Now he's sweating. He's like, do I spark? Will he read it? Nah, I'm not reading anything. I'm going cross up. Let's go. Kick this man in the back of the head a couple times. And now we read spark. Watch this. Okay, neither works. I'm making my own side effects though. I'm trying to produce the... He did not just steal that sense of being. I don't think he did. But I was very worried. Let's slow down that timer. Hey, I'm gonna use that sparking timer you got there. He didn't tech. He didn't expect us to drop it to be fair. I didn't either. But we did go pretty slow. All right. Now the strat is don't panic. That's really what we need to do is not panic. Yamsha can afford to die here. That's fine. We get reset back to neutral. Thanks to the system mechanics and fighters, this is a much better, the much safer play. Krillin's gonna come in. We're gonna clash. Boom, we're back to neutral. He's probably looking for a Super Dash or something. I'm gonna Super Dash first, like we always say. The first one is Super Dash and that war is gonna win. And we're gonna go one-one now. We gotta tie it up. We tied it up. But can we bring it home? We put a knot around it. We just gotta finish up the wrapping paper. I don't know. These analogies are getting out of control. Ha, ha, ha. We tied it up. That's all we really need to say. Rock assist. Oh, baby, me assist, please. Oh, changed. Oh, nice combo. That was cool. I didn't expect him to be able to convert that bounce. No way. All right, now I'm starting to think I should call the refs. Ha, ha, ha. Now I'm starting to think about it. Drop the elbow, bup, bup. OK. Oh, no way. Nice back dash. I didn't expect the back dash. 17, gonna take a lot of damage here, maybe even die. No drops. No drops at all. But we still live. Oh, I'm just gonna spark then. He was really forcing my hand there. Dash in. 6M, I'll take it. Corner carry, we got that too. Again, we want a power blitz, Yamcha. Too many hits. Drop the elbow. No, power blitz. You were supposed to be my knight in Shining Armor. Don't do H. Can you block the cross up? Can you block the barrier? He didn't even attack the barrier. I got two ahead of myself. Shouldn't have barrier. The barrier was a very risky, read heavy play. But I felt like making it, dude. I'm sorry, 17. We got to apologize. I don't know why I always super dash when baby BSS comes out. It is just a force of habit. Level three, wash him away. We got the knockdown. How do I make it work? Come here. Low? No, low didn't work. Mixups? Mixups are gonna work. After a mid, you can't, I mean, you can reflect it. But it's such a, I didn't do the full combo. Oh! Dude, he's not getting those combos off baby B, though. We are getting very, it's hard to understate how lucky we are that that baby BSS isn't leading into even bigger damage. All right, let's see. OK. We back dashed. All right, now we know. All right, so this time, hold on. If we get another beam, very lucky he didn't 2H there. If we get another beam, keep this in mind. He back dashed off vanish. What does that mean for us? It means he'll do that again most likely. I wasted a lot of bar there, but that's fine. I wanted to keep curling out to try to get this point.  So we're going to try to hit that on the ground so we can get a big 2M punish. Because we're going to sprint up and 2M. That's the read. I'm sticking to it, dude. 2S didn't work. Yamcha will. I mean, I'll take normal damage too.  But if we get in that situation, I just needed to be in my head that that's the read we're going for. OK. His Key Blaster making it hard to fire any beams, though. Baby. Why did they build baby so different? Level 3. Oh, he dragonrushed. I definitely was mashing reflect too. OK. OK. This is going to be tough. Limit break versus limit break. But he has, I don't remember when he sparked. But that is for sure, level 3 spark. Oh, yes. That is beautiful. That's going to give us a chance to level 3. The game's back in our hands now. He might try to raw wake up level 3, but I don't think he's got the guts. Oh, no. Oh, no. He had the guts. He had the guts. Oh, my god. He's playing like he has nothing to lose. Oh, no. Level 3. What's the mix? It all comes down to the mix. Can I block the mix? Garcats a lot. We don't want to block mix. 2H. Let's go. We react to the super dash. That's going to be the defining moment. We take game one.  But now we have to go to game two and see if we can get even better or the same results. I'll take a 2-1 if I have to. But great games. I'm scared. I'm scared. All right. And we are back with the second match. And this one's going to be a battle. There's another Android 17 on the other team. And he's the same rank as me, which I always feel the need to mention means more ranked points are on the line. Come on. Tighten the glove, 17. Let's go. Take better care of the plants around you. That's the best line he has. Take better care of the plants around you or become the fertilizer that feeds them. My man basically just said, I'm going to put you in the ground. He really just said, I'm cursing for, I'm going to put you six feet under. That's all he said right there. That's his whole battle line.  I didn't know it was like that. I mean, it's pretty aggressive. Oh, nice. You got me with the reflect rock assist. Keep him honest. Behind the back. Can you stop it? You can't. Power Blitz, Yamcha assist, a little late. Keep him in the corner. Rollback, barrier. Oh, that was sick. I told you to watch out for seven.  The dash over. He didn't want to stop to get the assist. Does he power Blitz? He does. No combo from it. I'm a spark because I'm a little bit nervous. Rock assist. He didn't stop it. At least not in time. We haven't used our second hit of power Blitz yet. Power Blitz. I'll race you to the ground. He got out of there. He didn't stop it again. Behind the back. Barrier up. If you get charged up the power Blitz, get another vanishing. I'm probably not the most optimal thing. Probably should just let him land. But I felt greedy and I'm paying the price for it. Elbow. The people's elbow from the sky.  Level one. He's aiming for the kill here. He's going to spend the bar to do it. Level one. He might need a level three though. Wait, is he? No, no, level one might kill. Oh, that did damage. I was so, I was so hopeful. I know I said I was dead. I wasn't hopeful. Then I saw how much health we did have. I was a little bit hopeful. I won't lie. No, OK. We're too far from the corner. I exchanged a little bit of damage there for a little bit of hope. All right, level one, level three. Cheapest can be, I think. I don't want to risk. Again, I have very low faith in the destructo that gets scaled after the first one. OK, so we have a lead now. No sparking on either side. And we've got a bit of a lead. Janemba's what scares me though. Janemba, I mean Janemba a lot. OK, I'll admit. Every character on his team scares me. But Janemba's pretty scary too. I need him in the corner. Keyblast, Keyblast. Oh, he didn't feel like getting Keyblast no more. Rock assist. Oh, that's 17 assist. Stonewall me. He said not today. Not today. Don't level three. Whoa, Janemba turned it to 17. Oh, no, he just teleported. It looked funny though. In the corner. Oh, nice vanish. He doesn't want any free stuff. No freebies. No freebies. But I don't need a freebie to get out. I don't need a freebie. The reason we switched to Krillin is because I think four destructoes kill here. Please. Yes. Oh, three. Oh, I could have gone off for a discount.  I thought we needed the four. That's why I didn't just go with the level three. Oh, OK, just stay away.  Oh, my God. Oh, no. He caught me bending my Keyblast. He caught me bending him. Skullcrush, that's fine. Hell's gate. Oh, for block pressure? Janemba's scary. Janemba scares me. I want to go home. Oh, I want to go home. Oh, just mash, just mash. When in doubt, when scared, mash. That's the instructions of all fighting games. When scared, mash. It'll work. You'll be fine. Level three. What's the deal? I'm going to bend it back. Bring it down. Let's go. Come here.  You got to run up there. You got to get over there, dude. You got to get there in time. That's bad. That's not great. That's not great at all. Oh, that's really bad. OK, I know I shouldn't be freaking out, but I've lost game. Something about this amount of health that he has makes me just want to rush to finish it. Instead of play smart, it just makes me want to be in a rush to try to end the game. Ex-Yohua, doing part two. Oh, I just, I get antsy, dude. I get antsy. Level three. So that means he has OK, and he has a command grab. This is a bad situation. Level three. Yep, glass shards in my eyes. And he only needs one hit, dude. He only needs one hit. Command grab also works. Car can't slow. OK, he didn't block. Oh, my god. Now I mix. Now I mix. I'm too quick with it. Now it's my turn to do the mixing. Hold on. How many chefs are in the kitchen again? Because I'm only looking at one, and it's me. Woo. The chefs are cooking now, boys. The chefs are cooking now. Hold on. Let me wave my arm around. I just got my, I don't know why I'm saying this on video, but by the time you're seeing this, it's already, I should be fine, but got my second dose of the vaccine today. So you know I got to shake that arm every now and again. Wait, please. People are like, why? You're playing fighters? When it, look, I'm addicted to fighters. OK, I'll admit it. I should be getting bed rest or just chilling or going outside or something. But I'm playing fighters right now, OK? That's how I heal. Ah, that's how my body heals naturally. Fuck. Just getting Vigito combo. This is not healing, dude. This is not relaxing. Like, what relaxes you most? Fighters. What stresses you out the most? Most characters and fighters. Ha, ha, ha. Oh, he can do it in the air. That was kind of sick, though. I'm kind of, I don't know why I've been so lazy with 17. I really got to switch him out. I almost got punished for it. Oh, no. Can I please get out of the corner? He's not letting me get away with any cheap stuff. But I am only giving him cheap stuff. Get off me. Barrier can't stop that. Finally, for the first time in the game, we have a bit of momentum. Something to hang our hats on. I'm going to go with the rock. Mixups. Ha, ha, ha, ha, ha. It only works if you say mixups like that for some reason. It's the auditory mix. All right, watch this mix. Mixups. I'm fortunate that did take two. But I'll take it. Dude, Krillin is so strong in the game now. It'd be so funny if you went back and watched in my older videos, like, man, Krillin is so like, I used to say Krillin's good, but you have to be really good.  But he's been made so much better. Like, I never once, back in the day, even when I thought, I was like, Krillin couldn't be strong if people played him. Like, really, really good players. But I never once said that about his assist. His assist was garbage at the beginning. Double overhead, you know I had to do it to him. Hold on. Let me flex. Let me flex just a little bit. Uh-uh. Level one. Level one. Oh, I should have done this with the, do I let him live then? No, let's not. Let's not do that. I'll just switch out. I should have gone Yomcha first there. 17's going to have to end it here. I believe it. I'm raw switching. 17, the people's elbow. Power blitz. Vanish. Power blitz. Rock assist. People's elbow. Oh, I almost had him with the barrier. Could have been sick. We might be dead now if he wants to go all out for it. He probably does. Why not, right? Level three, yep. Can't blame him. He's the last character standing. You might as well do everything you can to get that last character. The best chance he can get. And I think doing that does exactly that for him. He could have also been risking going for the Dragon Ball strategy. The rocks. I failed you, Krillin.  Why am I being an idiot? No. Why must I be an idiot? Why must I be an idiot? Why?  Please tell me I could just hold out hope for five seconds to win. Man, he did a really long combo there. I was waiting for him to just level one in the air and get it over with. But he was probably trying to build bar now that I'm thinking about it. Oh, no, no, no. I'm super dashing. Ah, close. Too close. Too close. Too close. No, he's going to level three. Defense, I know me and you don't get along, but I need you now. Defense. Defense. Offense. That was so bad, he almost. I shouldn't even be celebrating. Come back, my opponent was almost impossible to make. But I'll take it. 2-0 victory. Hopefully you enjoyed this one, if you did. Definitely let me know down below in the comment section while you're down there. If you want to support the channel, like I said, you can like and subscribe. That helps out a ton. And you can also check out some more videos on your screen right now. But I have been Datsudoya. Thank you so much, seriously. It's been so much fun. I'm going to keep shaking my arm. But other than that, hope you guys are safe, happy, and healthy. And I'll see you in the next one.


The e-book ee ee ee how do you spell ee some of the time you spell it with an ee me he she we ee ee how easy can it be ee ee how do you spell ee Some of the time you spell it ee ee be free keep green Double the ee and look what you see ee ee. How do you spell ee? Some of the time you spell it ee a team leap East clean It's easy peasy. See what I mean ee ee. How do you spell ee? Once in a while you spell it with a y happy Billy pony Silly a Why for an ee sounds crazy to me ee ee. How do you spell ee? Once in a while you spell it with an I sing pink pizza Chili and I for an ee. I think I can see ee ee. How do you spell ee? Occasionally you use a silent ee Pete these seen theme At the end of the word it can be found but silent ee doesn't make a sound ee ee How do you spell ee? Occasionally you spell it ie any Robbie peace Chief and I with an ee.  That's so funny in a few places you spell it ee. I receive ceiling What a strange feeling in a few places you spell it ee. Oh people People all kinds of people people with an o people with an ee see it spell it people you and me How do you spell ee? well Some of the time you spell it with an e Some of the time you spell it ee Some of the time you spell it ea Once in a while you spell it with a y Once in a while you spell it with an i Occasionally you use a silent e Occasionally you spell it ie in a few places you spell it e y In a few places you spell it ie in a few places you spell it e o Just follow these and you will see the many things you do with ee E is easy ee is free.