Welcome to our presentation. Today we'll be talking about the project that Evolvenwaub has been working on more than others. It's kind of a big project for the summer and it's almost done. We're quite proud of it and so we'd like to share with you what we learned in how the client here is the Princeton University Press. Don't be confused, it's sort of a nonprofit publishing house that's associated closely with Princeton University but it's not the same entity. It's on campus though and it's got a very famous tradition. If you have any academic books on your bookshelf, some of them might be from there. So about us, my name is Alex Durgachev. I co-founded Evolvenwaub 10 years ago and I'm Durgachev on Twitter and GitHub and I do lots of community stuff as well. I'd love to go all these camps. I know a lot of places here. My name is Matt Corks. I've been with Evolvenwaub for almost exactly a year now. I've been using Drupal since, as I usually say, since Pluto was a planet. My username on IRC and various other places is MVC. Our company Evolvenwaub has been it's 10 years old and we've been doing Drupal for about nine of those years. We've done projects big and small. We've got a great training program. We're based out of Old Montreal in Quebec and as usual we're always looking for good people to work with so if this is the kind of project that you like please you know reach out to us and start the conversation. Over the last years you know we've done we've done work for for some cool companies. Some ones we'd like to feature our for Linux Foundation, the press for Quebec originale which is the tourism Quebec website and lots of lots of others. So in terms of in terms of our approach you know we often we're a small team so we often work when we work with a larger company. We're very collaborative. We use their resources as much as possible and we try to teach them Drupal best practices. We have some hybrid estimation and agile approach so we're not just you know PHP developers but you know we most of us are very comfortable with Linux and lower level stuff and also with JavaScript so it's we try to have good expertise throughout the whole stack and you know we're open source guys so we actually we use JIRA when our clients demanded and use Redmine internally for pretty much everything and base camp for client communication slack and so on. In terms of what kind of stuff we do of course great design teaming but also infrastructure, multilingual, search, lots of migrations and lots of custom dev. So that's that's our company and our client is depressed. It's like I mentioned it's an independent publisher and you know they've been around for over a hundred years. They have published many tens of thousands of books and you know like 10,000 books in print and they're one of those prestigious academic publishing houses so you probably heard of also Oxford University Press and so on. So the current site as befitting a very prestigious institution with a strong legacy is a legacy site that's like 20 years old. It's believe it or not it's static HTML it's I think it was made sometime in the 90s or you know 15 years ago and and then been refreshed where they changed the header and the photo to insert the new logo but aside from that it's been a site that's been evolving so it has a lot of content on it it's got 9,000 published works it's got lots of Einstein related papers it has a lot of like sample chapters, table of contents, ancillary files, some blogs. So this is the site it's kind of like a static site with a lot of stuff on it. It does have some moving parts so it has some mini sites that we realized after the fact it exists. It's got a WordPress blog bolted on it's got a PHP list newsletter which they probably should move away from eventually. It has a like a little legacy Perl's TGI search application and it uses Google search quite a bit. They have the ability to buy books and believe it or not they have not have one but two built-in shopping carts one for the US and North American market that kind of the Americas and then one basically out of the UK from Wiley their partner and distributor and now one kind of handles Europe and Asia and Africa and so they have as you see two shopping carts that you can add stuff to. All of this stuff all of these books get generated a static HTML and thrown in an FTP server. In addition to this they generate an Onyx format XFL feed if you're in the publishing world you'll be familiar with Onyx as the metadata format for the public publishing companies use and that also gets thrown to other FTP servers that their distributors have that Amazon.com has and that's how Amazon has all the updated data and all the images. And yeah they have lots of audios and videos scattered and embedded throughout the content and their planning to move and standardize on Bimeo going forward. For this project what we did is we did a big analysis of what what they had which was a SQL server database and a lot of VB scripts that read this database and from this metadata that they extract all the relevant bits and pieces from the site and they throw it onto the static HTML which gets manually copied to an FTP server. We also did a content audit. We kind of are taking it back to find out how much other static content they had beyond what we were initially thought you know came from this VB script because they had 20 years worth of static HTML so stuff really crafts up. So we did that. We had then moved everything to Drupal. The mandate was initially described to us as a lift and shift and then we initially described to the client that there's no such thing as lift and shift but nonetheless the idea is to move to Drupal their existing site without changing too much. In part there's a secondary mandate that the organization is expecting to go forward with the big redesign where they're going to say what is their brand identity on the web in the 21st century and how should that be reflected on the site. So the idea was to take what you guys saw and move it onto Drupal. However they did recognize that in 2017 you need to be responsive.  So that gave us an in to make some design changes you know just basically fix things and make it responsive was the instruction we got. The other thing is these DB scripts were quite heavy and not robust put it lightly. So we were asked to write that synchronization process that would get all their data from this from the central system and get it magically inside of Drupal synchronized every night. And after some consideration you know the team that they have there they don't have unlike other like other clients we've had or unlike even Princeton University when you have your own system in team the publishing house doesn't have a huge IT department web hosting is not really their specialty. So we cancel the conclusion pretty fast that they should be put on a host like Pantheon or Acrea or something like that that gives you managed Drupal hosting which has the benefit that they don't have to worry too much about it and at the same time evolving web doesn't really have a good lock in on this. This is as a small company our goal is to get clients locked in. So we were happy to put them in a good place. So this was the mandate. We had a couple of months to do it. So first things you know it sounds pretty simple right it's a static HTML website. How hard could it be? It's got no features just click around and look at books. The shopping carts by the way are all external like they're basically just like JavaScript integration. So we start the project. We had an idea what it's going to take but then we start. So we start looking at the database of this SQL server database and we were trying to figure out how we're going to integrate that with Drupal. And first of all we figured out that there's like 30 tables in there. Some a couple of the tables such as the works like the books table have like I don't know 50 fields of which maybe a third of them are being used in the website and the rest are used in other parts of their organization. So we have to do a big audit of all the tables of all the fields. What are they having them? We had some sample sample content from them so we know how to display it. We if they're bold you can't quite see it in the slides but if they're bold then they're used in Drupal. If they're not we can just ignore them. If they're bold you're being used currently in the existing website. Yeah. And the other fields are just used for other internal purposes but it's not the website. So we assume it wasn't used for the old website. We don't need it on anyone. The next thing so that started with the database and what's there. That's that's our source data. The next thing is they sent us an MSS access database that connected to the remote SQL server database and this access file contained a bunch of VB scripts embedded in it and it sounds not so bad right but it turns out there was like 30 to 50 scripts many were duplicate copied and pasted versions of each other because that was basically their whole code base. It's a static site generator embedded in these VB scripts embedded inside of this accessing with no version control or anything like that. So over over 15 years and of course the person who initially wrote it was retired. So over 15 years lots of versions of these started being around and we just have to go through everything and figure out what was there. It was really nice that the webmaster and the web director of the client were quite helpful in that regard. They rescued our butt because I don't think we could have figured it all out. We're not we do know VB script a little bit from our back back in the days but we're not the experts and it's pretty legacy stuff. Another little kink with this VB workflow that they had is that about right now it's only about 50 books but before it used to be more we're marked as special. So the HTML that was generated for those wasn't put with the same folder as the rest of the HTML generated. It was put into the specials folder and then a webmaster had to go in and manually merge whatever fixes or changes that had been done on production. So they were using dream reverend stuff for that. So a lot of it was because they didn't know how to fix the VB script to do what they wanted because it was just too complex. So we're happy to say that we're involved with a special workflow. Yeah, the MS SQL DB was called Ants Bibliot not to be confused with and was the web director not to be confused with the new system that we'll be moving to next year also called VirtuaSales Bibliot. They have this web drive. Let's see was an amount of drive that was accessible to all the other workstations inside as W. That's the web drive. And so that's what they're using as FTP. And like I mentioned the scripts were each individual script was between, you know, 50, 500, 1000 lines of code, but there was there was 30 to 50. So there's a lot of lines of code in total. We estimate that that was five to 10 real lines of code and the rest were all duplicates. So we did this audit thanks with the help from the folks at the press.  We knew that there was way too many scripts for anyone. There's literally nobody around who knew what these things are doing. So what we focused on instead is for every script that we could find, what files did they generate? And so at least we had a had an index of all the files and how they mapped. And basically, we had our list of templates, you know, the things that Drupal would be responsible for showing. And then we just open those things up like the HTML, and we said, where are these fields? What do they come from the database? Is it obvious? If it's obvious, we can have to look at the script. But if something if several fields were concatenated, or if there's conditional logic in this book show this field, not book show that field, we would have to go in into the vb script and check what the heck it was doing. To be honest, even now a few months later, I'm sure we only got like 80 90% of the complexity of those scripts. I'm sure as the site gets audited and tested some more, we will find little corner cases that somebody five years ago put in. Maybe they don't care about them. Maybe they do. We don't know. Nobody knew. We did it. And a lot of very custom databases that people used to get this drop. They were very responsible for reducing complexity, things that they didn't really need and would have taken us three days to extra work. It might have been a pet feature from seven years ago that nobody even remembered, but it was there for us to discover and figure out how to do it. So the existing workflow before we came along, was that we have the SQL Server database, and they have these vb scripts generating dynamic HTML pages. There's a bunch of file assets that's on the right. And there's also a bunch of static HTML, not just the special pages like we talked about, but there's just a bunch of other HTML because you have an FTP drive, you have a webmaster or three, you have 15 years, you're going to have a lot of HTML. So we try to change it up a bit so that we have Biblio, this database server, a SQL server, we export using just a very simple PowerShell script. We export all of the tables into CSVs. And we have that on an FTP that we can access. Then we have a group of migration that actually runs on Cron every night that goes in, checks to see if there's new versions of those CSVs, pulls that in, checks to see which rows in those CSVs have changed. And for any new rows, it makes records for any updated rows, it updates the records. And for any rows that were deleted, it removes the records. So we did quite a bit of work to write these migrations. We kind of scratched our head quite a bit about what to do with a giant collection of accumulated static files, images, PDFs, videos, source code. Don't ask me why some book had a source code, but it had source code. Did we decide to move it all into Drupal? No. We said that's just a recipe for madness. So we decided that the only thing we are going to move into Drupal are cover images because we have to have resizing and all this beautiful thing and meta tags with images. The rest, we told them your existing web thing can be its own FTP server. It's going to be on a different domain like assets.press.princeton.edu. And we're going to just update the links. So we shouldn't have any broken links. But we're not going to take all this craft and move it all into Drupal wholesale. And it's up to their existing web team to clean that up if they want or not, or they can manually bring it into Drupal. Yeah. Well, we also are aware that with Drupal, there's a lot more capacity to build dynamic pages because we have the power of views. So some of the things that were dynamic because a VB script generated them, like a listing of recent books, if they bothered to make a VB script for it, then we made a view for it. That was about half of the listings of books. If that listing of books was manually edited, we realized that we just didn't have the time to go back and forth and say, look, let's make it dynamically generated. Even if it's really easy, it won't be the same as their listing that was manually generated. And then you'd have to go to them and say, is the new one better or worse? Are you happy? Do we need to make exceptions? We didn't do it in this case, but let's follow up. This is what we wrote. For every single table, we wrote a query that just pulled out only the fields that are being used and generated these CSVs. So it's a very simple export feature. We did this because we knew that in the future, they're going to shift away from the SQL server database. They already said they're going to use virtue sales video. And we know that virtue sales video can make reports out of the data that's stored in there. As XML as CSV doesn't matter. So we didn't want to do anything complex also because this part is running by their assistant in a cron job on a server we don't control. So if there's any bugs or errors, there's kind of if you always play broken telephone trying to figure out what's causing it. So we had to make these export scripts as minimal and simple as possible. That's why we don't do any cleanup, any joining, anything. His job is to take your source data and generate these CSVs straightforward. Now we've got to move that into Drupal. I don't expect you to digest this table.  Turns out, no, there's a little bit of complexity after all. So the complexity here is that the work content type has a lot of field collections in Drupal 7 terms, or in this case we use paragraphs, but however you want to think about it. These are entities that don't have their own URL, but they are aggregations of fields that belong in groups to each work. So we have the works, we have the author, which have many, one to many, or many to many relationship to works, and then we have a bunch of paragraphs related to reviews, links, illustrations, and so on, and then a bunch of fields related to these paragraphs. And of course, taxonomy So we then had to, we got access to their FTP server, and we realized that there's 77,000 HTML pages there. We're not talking about PDFs here, we're talking about just HTML pages. And we kind of had a small heart attack. This was after we already gave an estimate and then scheduled and all that for static site, you know, how hard could it be. But after we started digging, we realized that 20,000 from that audit, right, from the VBScript audit, we realized 20,000 are being generated by the VBScripts and are going to be handled by Drupal templates and views, fine. 54,000 are actually old versions of generated pages because they wanted to make a backup and threw like that back or something and they left it in place, because you don't just accumulate, it's not a dynamic, it's a static website. For all those people who love static site generators, keep this in mind. And then turns out that the actual number of HTML pages that had to be manually audited and considered was really only 2,500. Still quite a lot, but a human achievable task, since it's not something you can't do with, you know, a couple of weeks of work. In order to triage all these crazy folders, which of them were garbage, which of them were ancillary files, which contain HTML, which didn't, we made a big listing of every folder that has at least one HTML file, because if not Drupal won't touch it, it just goes on the asset server. So everything that does a HTML file, we collaboratively went through, did our passives trying to figure out what's there, then their web team confirmed, denied, gave us comments, input, and based on this we were able to cut it down to a much, much smaller list of essential pages, static pages to bring it. I also did a, what I think is a clever thing, where I have my own little FTP like static server with the backup of the site that enables directory listings after you password protect, and so I have a link to that. So if you want to see what HTML files are any folder, you can click right from the from the Google spreadsheet. So this was the audit. It was a lot of work. It scared us a lot, but fortunately, you know, we're good at this kind of stuff, so we fly on into the implementation. And we built the site. We got a, we got our designer to, we gave an instruction, make the site look as similar as possible while recognizing the fact that you're going to make it bootstrap based. You're not going to try to copy a design from, from the nineties, right? You're just going to, you're going to make it a modern design that works easily, but pretty much has the same elements. We got very limited mandate to change things or to make decisions because the creative team was not part of this. This is supposed to just be a modern version of the same design. So we still have the same slideshow. We still have just the feature publications on the home page. And yeah, the one thing that we did is the two search boxes that they had, we made collapsible, because we know javascript, so we need to click that little search box then, then the two things pop up. It's because it's Drupal, because it's bootstrap, because it's clean, it's got much better user experience, it's got much better SEO. This is not this spaghetti code vb system anymore, but now it's, it's a very clean minimalistic Drupal site with admittedly a very complex migration bolted on. But yeah, so they can, their web team can now just go in and update the content with WYSIWYG. Images are auto resized, users are much, much happier. So for the home page specifically, like I said, we stuck to the existing look and feel whenever there's any doubt we're not trying to change anything, we're just trying to take the cheapest possible way and make it look that broken and make it responsive. We did ask them for permission to change the menu. If you guys remember they had a 15 or 20 item left sidebar on every page and that actually would once in a while change, because when you get to a different section they would manually edit it, but for the most part it was just a static left sidebar and we asked them to make it into a drop-down menu. I'll just mention that that left sidebar was a usability nightmare and it wasn't consistent on other pages. It was way too long. We should have been in multiple levels. So there was like, and we'll show you the site soon enough, but there were pages you could only discover by following a trail of three to get some interior pages. That was what you see on the landing page and then certain sections of those would randomly change the menu of the left in a very unpredictable way. It took us a while to figure out the initial structure in order to be able to present a structure that made a lot more sense. Yeah, so we asked them to come up with a more limited set of items and we asked them to categorize it according to this drop-down categories which they were happy to do. It seemed to be uncontroversial, easier than we thought. And so that was a small step but I think a huge usability way. Yeah, we made a list of everything that was in the left follow menu on at least one page, put it in order by rank by according to Google Analytics data so you knew what was the most important. The things in the categories from there decided that they should be the first level and second level and there's only a few third level things. But the menu is actually the same on every page which is a pretty basic idea but not something on their legacy side. Great, so for the book templates themselves, like I said, there's about 10,000 of those so that was our main beast of a template. We moved things out of the, we have Yogan though, sorry, but we moved things out of the header. They just crammed pretty much every single piece of metadata that was in the description into that top header part which made it look really confusing. So we made it more consistent with things that you'd see in Amazon or something and yeah, we definitely are aware that different books have different fields and so we made a design that works whether or not they're there. We still have the same integration with the carts and Google Booksearch and videos and so on. Yeah, has anyone ever been in a design meeting where you attend a different department and you said one says my little thing has to be above the fold because if that means something on the website. So yeah, 10 years of that. Yeah. There's like 10 years of those decisions and we just shoved everything in. So everything became above the fold. So yeah, everything was with the priority which means nothing at the priority. Right, so then the actual migration of the book data, so like I mentioned, there was, you know, something north of 8,000 books, there was 4,000 covers. I think there was more than that, but there's a star. We, yeah, we made sure that all our migrations are incremental because it's a huge, huge migration and we wanted to be fast and only a few things change like they do, because obviously for years we made 20, 50, 100 books a new one. Yeah, we make sure that the migrations are running nightly and can be run quickly if they have urgent change and we handle removal out of print books. To give you a sense, I don't know if you can see the output of Drush Migrate status, but we have like 20 migrations there for these different entities, these paragraphs, these taxonomies, these images, and as you see some of these have like, the reviews table has 42,000 records. The eBooks edition table has a couple of thousand, the author's table has 10,000. Yeah, and these are migrating to different entities, so that includes redirects, which are entities, that includes paragraphs and then the very vast number of runs is the node which actually represents one book. So before that runs all of the different paragraphs and one of those is the editions, so that can be like the hardcover, paperback, DVD version, all of that's been migrated first and then the work node comes and puts it all together referencing the, giving the node ID from the previously run, sorry, paragraph I mean from the previously run migrations. Yeah, so you guys wrap your head around this migrating, you guys know Drupal Migrate, yeah everybody uses that framework, it's, it's came out as the canonical way to import data into Drupal and it served us really well. However we did have to write custom code for several things related to the migration, such as source deletion, that doesn't quite work out of the box. We also had the notion that a lot of Drupal entities, which would correspond to one of these migrations, need not one, but several CSVs that have the fields in it, because you have multibalue data associated to it, so our developers actually created like a plugin for multi CSV joining, as if the CSV data source is an almost SQL like where you can specify. Open these several CSVs and join them on this criteria, so obviously if you wanted to keep it more simple you could have just pulled them into a SQL database and, and just did that. In fact I don't know why we didn't. We have, we have now an impressive thing to contribute back. There would have been more custom codes right that way. Yeah, it definitely would have added moving parts for sure, because once you change those CSVs there have been more things to maintain. This, this pros and cons. The more moving parts the more points you get. Another thing that Migrate out of the box doesn't do is support for getting these source files of the source CSVs from FTP or SFTP. Kind of wackled back and forth what they wanted to provide it, so we were able to easily provide support both of them and this also manages to, for SFTP it actually connects using SFTP and does an md5 and sees if the file changed except timestamped. So try to be smart about detecting changes. Another gotcha was running all of this in cron, so Migrate out of the box did not run on cron, so we took a few iterations of getting it right and we thought we had it right. It was fine, we just ran it from our cron job and then we moved to Pantheon where the cron timed out quite aggressively and all of a sudden what we did wasn't fine, so we had to rewrite it to use Q workers. And then we think it's fine, but that was just this week, so it'll let you know. So stay tuned. There was of course encoding issues as you would expect from any Microsoft SQL server original data that we worked through and there's just a lot of fields, a lot of interrelations and a lot of legacy complexity that nobody could quite explain, but we muddled through it eventually. One thing that I'm kind of proud of is how few contribute modules we have. Remember this is mostly a static HTML website, no one's expecting bells and whistles. So what you guys see here are mostly migrate stuff and API helper modules, some basic site building stuff like context and active trail, a little bit of the empty browser for images and I thought so. Really this is not a site where we enabled a bunch of contribute modules and called it done. On the other hand, up until the last you know last two weeks I think we only had one custom module, the PEP migrate. So we also had to write no custom code except the migration. Eventually I think Jigar in the back had to had to write a views argument handler for some some advanced stuff. So we didn't change any URLs on the site. That was an auto scope. That was a scope that would require approval from too many people. So in order to have a view, to keep the views arguments looking the same, we had to write some fancy views argument handler. That was a bit of work, but I think there's one other custom module that didn't migrate. So we have a bunch of these lovely fields and then I'll just play correctly. We cleaned up a bunch of stuff of course. We had lots of PDFs linked all over the place and we had to make sure that they're being linked to that new assets sub-domain. We also in the source data, we had an ebooks table and a books table and they had like 90% of the same 50 fields so we kind of didn't we normalized it in Drupal. We had supported ebook they have apps and now we support that and we dealt with stuff. So that was that. We also took a couple hundred of the top pages according to Google Analytics the ones, everything that was linked in the menu anything that you really miss for being a soft launch and we imported it ourselves and we cleaned it up as much as time allowed. So we did that first pass the site doesn't look terrible so we moved off to their web content team to go through the long tail of everything else and fix it up. We did the search in Drupal views, we did all the listings all the taxonomy listings inside of views and some things like human print which was manually a list of books they can move into a view later. So the next section is going live I'll be glad to know. Sure. Yeah this is just our checklist of things that had to happen before the segment live. Right now it's existing on a beta domain we're expecting the actual hard launch to be in a couple of weeks. We already mentioned that we deployed on Pantheon which means we've been testing in that environment for two months now maybe month or two to work out any specific issues there. We created a second domain name that points to assets.press.princent.edu that resolves to exactly the same place as their current live domain that way so then we rewrote links to PDFs like their massive pile of legacy PDFs to use that domain name so it goes to the same place but after the launch that domain will keep working and point to the existing server so all of their links to photos and the zip files which are the source code for some computer science and whatever can still live on their old web server and they can migrate that over later. As Alex mentioned we had to spend a lot of time working on CRON timeouts as we were running migration nightly because we needed to do a nightly sync of their bibliographic data we ended up doing that by making a queue worker so that was interesting but that was the major difference between our dev environments where of course we all set the PHP timeout to be negative 1 and the memory limit to be negative 1 then you go to your production environment and hey, why doesn't the system want to do that? Oh, at least they were using Docker Yeah, yeah so we did have that control Yeah, we, I mean other things like these are just small like go live checklists that would be common to any site you made sure that Google Analytics was there we made sure to turn off DevL, we had to make sure that the live site's domain was whitelisted because through the latest of course as a concept of trusted domains we had to in and since the live site will be accessible by many domains like with and without the www by over port 80 or port 443 so with or without SSL we had to pick one canal called domain to make sure that everything redirects there for SEO purposes so that's something you need to do right when you go live we did a final performance audit so front end there are a variety of tools for that so the page loading time in the browser as well as backend that was with a tool called Blackfire which my colleagues Jigar and Alex gave a presentation on earlier today so I'll just assume you all saw that yeah I mean you turn on CSS aggregation at the end I mean the standard things Pantheon has their own launch checklist which is very helpful some of which is specific to that environment some of which is not and their own backup system so you just have to make sure that you click the button to say make me a daily backup we are doing monitoring with the service Pingdom so that'll hit the site once a minute and send us an email if it's down I mean you should do this for any live site with that or some equivalent service post launch so these are things that are yet to come so once the site goes live we will need to have a supporting agreement in place so the details of that are still being negotiated with this particular client but that's something that just like when you've got a car you always need the full number of a mechanic so we're the mechanics and just as you folks are future features will be fixing the right now the book URLs are literally title slash random five digit number dot html so which is amazing for SEO maybe that'll change there's other things like php lists for running their mailing lists they know they need to move off of that they could have better meta tags for discoverability on Facebook etc two really big things more automated views so the list of books that came out in the last week is written by hand currently in Dreamweaver and now it's going to be just here's a static page here's a basic page type in Drupal and I'm going to click at it and type in all the books that came out this week so maybe we can automate that since we have a database of all the books and their data publication I'll probably save somebody some time Virtue sales yeah Virtue sales is a very large software package that like this is a year minimum one year migration that they're in the process of doing that will manage all of their book inventory their sales will push data to Amazon and all their other distributors that will handle I think it'll even handle online sales I'm not sure about that but that'll be a massive change on their end and so we'll need to change the migration source to pull from that data source eventually but we did as much as possible to prepare for it so we did what we could when they are ready to launch that changes will be needed to the website and at some point they want to do a major design overhaul but they're not even planning to start that until like 2018 so we're going to have to be involved the website will need to be updated for that but they weren't ready so we did that with the current design as Alex was saying project management so here's the team there are a couple other people who did like a smaller number of hours but for the most part we had two people doing back-end development G-guards in the back of the room in the bright shirt and David was in here today we had one person doing front-end development so all of that so the parts of the views all the CSS we had an intern doing some QA so my boss Alex doing the business lead like negotiation contracts my other boss Suzanne was the lead on training for the content editors and the designer and then myself I was doing project management as well as code review because I come from a development background so we had several days of meetings on site seven calendar days, that's more person days than that several demos some in person, some over video calls we asked the client for a single point of contact and then I was the single point of contact on our end so if you don't have that, it's impossible I've had clients where there's like five different people you're supposed to talk to and you end up just playing referee that doesn't get you anywhere I'm sure you all have a horror story about that we had a backlog of tasks so we would sign contracts with them that included a long list of actually had our red mine ticket numbers we would provide them a list of things we needed to do that we thought needed to be done estimates in terms of hours and they would tell us, okay, do these in this scope these ones, these are nice guys I should jump into that that was for the last 40% of the time the first 60% of the time was us doing this out of figuring out what the hell is over there and then just saying, oh my god and then just saying, okay, let's see what we needed to do so the part I was looking at was not negotiable there's still a lot of different sites on the control list I've migrated that into Google I've told the data that we have that we kind of just did but once we got to the final point the little nice to have features such as deleted offerings they didn't need to have through the line they just happened to have through five years ago if you still need it, do you want a date for it or do you want to send your money somewhere else that's where we moved to this model yeah, and the client one thing the client was very good at was that also in the discovery phase we found the site was a little more complex than we thought and by the way, pulling in a very complex data set means that we had to use a very strange data structure inside of Drupal I mean, we would have come up with something that made a lot more sense and would be easier to build views around in Drupal if we had had the choice of the data model but since we had to retain their data model we had to do things in an awkward way in Drupal so it's doable, but it takes longer but other than that I would say there was no major scope creep from the client we had our list of nice to have and as we found complexity that we had to fix somewhere a bunch of those got crossed off and we were to have the time to deal with those other issues on the right is just a screenshot from a base camp which is what we were using to communicate with the client and we were using red mine internally this is a rough timeline maybe I'll think the next slide might be more interesting this is a rough division so the work happened over 5 months so here's roughly the percentage of who was doing which team was doing what work at what point coordination and code review is together one item because it was me doing it I'm not sure the exact rate down but otherwise it was about a third front end and back end the management reviews portion yeah do you want to do the summary? yeah sure so and then we'll show you the site yeah so basically you guys you guys saw we discovered things in scoping that were a little bit more complex than we initially thought we were kind of had our hands tied for the design but that helped because the design usually is the part where things go off the rails so that that didn't happen we just told our designer we've got 10 hours to make it look like the current site but modern responsive clean and whenever in doubt just make it look like the current site and he came back with something everybody liked we did a very complex migration with lots of fields and lots of records and a substantial amount of custom code to support the things that we talked about for the 9B sync there's a content clean up phase going on right now so while we're hanging out here at a fun little conference people are working hard and so we did the deployment we went with Pantheon just because it was quite economical they previously have been doing static hosting so they weren't quite ready to spend tens of thousands of dollars a year on an enterprise hosting account so Pantheon was a nice compromise between good level of service but not so much they have 500 or 600,000 paid views a month it's a really huge amount of traffic so we're going to see how that goes so we're doing a soft launch with that and for we'll be entering this sort of maintenance and I'm going building mode where in parallel maybe in advance of their big redesign and their migration to virtual sales we'll be adding these little nice to have features deep paradise during this phase or other things up there their stakeholders now that the site goes live now that the site has changed substantially for the first time in 10 years I'm absolutely sure there's going to be ton of stakeholders who come out of the woodwork and tell us what everything is wrong that weren't even part of the conversation so that's where the maintenance agreement is hopefully going to be comprehensive enough for we kind of caught off guard on this last minute checking migrations and caught on Pantheon with the client provided the credentials so we had to work on that quite last minute we were surprised by the complexity of their legacy codebase but I guess we shouldn't have been also the same thing with the content cleanup but fortunately the client's content team stepped up to handle the book of that and also we probably should have done the training for the editor experience a little bit sooner so we'd have more time to do that sorry that it was at the end we just did the bare minimum in terms of the usability for the actual content editors there's still a lot for them to fix manually or to update manually and the user interface is usable but Drupal can do better and we didn't put effort into that because we needed our time elsewhere and that's Drupal 8, it's not Drupal 7 so out of the box it's already 10 times as good so that's great and they're happy but we know that we could do better so we've given her a better experience than that so the timeline it did shift a little bit especially with having the self-launch especially with this content cleanup that's not what we quite expected but everyone's reasonably happy in terms of the vast majority of the development happened in May and June which for an organization like this happened 8 times as fast as anyone expected this has been in discussion for years before we came along so we kind of came in most of our team, we have a very small team we kind of came in and sliced and diced with machetes and got through all their complexity and really built a minimum viable product we gave them just enough input to say what's more important but not to add new crazy things and they were really good at not doing that so thanks to this really good collaboration we were able to achieve a lot at the same time we weren't able to achieve everything involving what we only do time and materials contracts so the client is perhaps justifiably a little bit miffed with us coming back and saying you have to choose between things guys this is complex stuff our schedule is what it is we can't add more weeks to the schedule without adding more budget we did a bit of a compromise we gave some more hours the client gave them some features and everyone is reasonably happy with the result this is kind of the project and just to give you the demo so let's show them the legacy site first so here is the site you guys saw a screenshot of it here's the lovely search two searches one is just the google books like full tech search the other you get to choose the title or the author or the ispn everyone works there uses the one on the left anyone else uses the one on the right two shopping carts us dollars and uk pounds and here is the site here's a book pretty simple one so the new site is on the page and so it just looks a little bit more modern it's like re-advertised there's a kind of shit in the show more you scroll it some of these are really long but it's not that long sometimes a book could have a hundred reviews or sometimes an author would be a list of all the awards that an author or a book have won and if somebody won a Nobel Prize he really wants that on that website I probably would do if it gave me a Nobel Prize but it gets lengthy and then you can't quickly scan the page and see the important contents I mean that's important information but it's also often pretty long so that's always collapsed by default for example great so with that I don't want to go into too much of the site it's pretty lift and shift and spare and it's supposed to be a great clean code base and a great clean platform for them to do their design overhaul so that's really what we achieved do you guys have any questions for us on this? Hi Why do you have so far two shopping cards? That's a business decision for them which this is just the way the publishing industry works often the rights to sell a book will be specific to geographical regions so for example Harry Potter the company that sells that I think it's Scholastic in the US Raimtree in Canada and I can't remember who in the UK that's just how the rights to the book were split up and a much better user experience would be to have a single shopping cart and then the order being fulfilled by the different things so that's on the backlog of nice tabs and subject to budgets and schedules but those two shopping carts there's literally a line of JavaScript each and the shopping cart is not managed by the site even though you see a number that's all external platforms and one of them is going to switch but the fact that there are two is not changing and that's just the nature of the book distribution business they don't have a separate website for different countries like Amazon they just have one so they need to have that listed there any other questions? I don't think we have time to do that and in fact I think Jigger in the back is the guy to pick his brain but I can tell you Chris that we get I know you know this we get that the Drupal module model is open source contributing back to the community so other people can fix your bugs for you in our issue tracker we've got a list of blog posts and core patches and things like that to give back some of this complexity to the Drupal community some are a little debugging modules that we think will be useful for people writing migrations another the doing a join between multiple CSVs that was our developer Dave who thought of that one that was a real good brainwave that saved us a lot of time so yeah this stuff will be showing up on drupal.org near you but it isn't all there yet but in the meantime Jigger at the back would be probably I'm going to speak for you Jigger would be happy to answer more specific questions about that if you have any after the talk any other questions? going once, going twice alright and before you go the most important slide and a slide that pays for us to come here and give this talk is my wife Suzanne is doing lots of upcoming trainings probably you have met her and went to her three talks and training yesterday so the most relevant one is going to be the Ottawa one September 11th 15th she's doing a whole week of training so if you have any interest in learning drupal 8th or if you have colleagues whether it's site building or virtual development she's got a week of training scheduled in Ottawa please send people our way and her training is pretty good better than our presentation she's practiced more so thanks very much


The first question is that amendment 165.4, in the name of Liz Smith, which seeks to amend motion 165, in the name of Kate Forbes, on economic recovery, be agreed. Members should cast their votes now. The result of the vote on amendment 165.4, in the name of Liz Smith, is yes, 109, no, 6. The amendment is therefore agreed. The next question is that amendment 165.2, in the name of Daniel Johnson, which seeks to amend motion 165, in the name of Kate Forbes, on economic recovery, be agreed. Are we all agreed? Parliament is not agreed, therefore we will move to a vote and members should cast their votes now. The next question is that amendment 165.4, in the name of Kate Forbes, on economic recovery, be agreed. The vote is now closed. I call Brian Whittle for a point of order. I will ensure that the clerks record your vote. I call Alex Cole-Hamilton for a point of order. I was not able to log in correctly and I would have voted yes. I will ensure that that is recorded. I call Natalie Dawn for a point of order. I am having some technical issues but I would have voted no if that could be logged. That will be done. The result of the vote on amendment 165.2, in the name of Daniel Johnson, is yes, 51. No, 65. There were no abstentions and the amendment is therefore not agreed. The next question is that amendment 165.3, in the name of Lorna Slater, which seeks to amend motion 165, in the name of Kate Forbes, on economic recovery, be agreed. Are we all agreed? The next question is that motion 165, in the name of Kate Forbes, as amended, on economic recovery, be agreed. Are we all agreed? We are not agreed, therefore we will move to a vote and members should cast their votes now. The vote is now closed and I call Pam Duncan-Glancy for a point of order. Thank you, Presiding Officer. My app did not work and I would like to register I voted yes. We will ensure that it is recorded. I call Brian Whittle for a point of order. My app is frozen and I would have voted yes. We will ensure that it is recorded. I call Cocacab piano for a point of order. I call Cokab. Is there a point of order? Yes, my app didn't work and I would not vote yes. Thank you, we'll ensure that's recorded. I call Sharon Dowie for a point of order. Hi, my app didn't work either, I would have voted yes. Thank you, we'll ensure that's recorded. The result of the vote on motion 165 in the name of Kate Forbes as amended is yes, 111. No 7, there were no abstentions, the motion as amended is therefore agreed. Is that motion 208 in the name of Michael Matheson on approval of an SSI be agreed? Are we all agreed? The motion is therefore agreed. The next question is from John Swinney in the name of John Swinney on approval of an SSI be agreed. Are we all agreed? Yes. The final question is that motion 207 in the name of John Swinney on approval of an SSI be agreed. That concludes decision time and I close this meeting.


Russia's F-16 threats could start a war with NATO, Swedish military official warns. Russian President Vladimir Putin's statements that F-16 fighter jets are legitimate targets for Moscow, even on third-country airfields, is an escalation of Russian rhetoric that could potentially lead to a war according to Swedish Lieutenant Colonel Joachim Pasikivi. A group of 14 countries has pledged to deliver the F-16s and help Ukraine with training. Dmitro Kuleba, Ukrainian Foreign Minister, said that the planes should be arriving While visiting the 344th Army Aviation Centre for Combat Employment and retraining of Army aviation pilots, Putin was asked about F-16s and if Russia would be allowed to hit these targets at NATO airfields. First, if they supply F-16s, this will not change the situation on the battlefield. We will destroy their aircraft just like we are now destroying their tanks, armored vehicles and other equipment, including multiple launch rocket systems, he said. Of course, we would see them as legitimate targets if they operate from the airfields of third countries no matter where they are located. F-16 aircraft can also carry nuclear weapons and we will also have to heed this while organising our combat operations. If Putin wants a war with NATO, that's how you start it, then it will be a third world war. Pasikivi told Swedish press agency TT, according to him the fact that the F-16 can be equipped with nuclear weapons fits in well with the Russian narrative which revolves around the image of the West as the great aggressor. For Putin it is important to constantly present the West as the major threat to the domestic audience. The West's so-called nuclear threat is at the centre of the entire Russian narrative. Pasikivi said, Elbridge Colby, former Deputy Assistant Secretary of Defence for Strategy and Force Development under ex-President Donald Trump's administration, took to ex, saying we shouldn't take Putin at his word, far from it. I believe Russia is a serious threat to Eastern NATO. Japan prepares for war with China and Russia and transforms civilian airports into military assets. Japan is set to upgrade five airports and eleven seaports, repurposing them for use by its Defence Forces and Coast Guard during military emergencies, Kyodo News reported. Officials plan to green light the modernisation effort soon, with projects kicking off in April. The initial budget is pegged at about 35 billion yen or 230 million dollars. These upgrades include lengthening runways and expanding aprons at airports to accommodate fighter jets and transport planes, while ports will be modified to dock destroyers and sizeable military vessels. The five airports earmarked for modernisation are located in the prefectures of Fukuoka, Nagasaki, Miyazaki and Okinawa, the latter being a central hub for US military bases in Japan. Of the designated ports, five are in Hokkaido, which houses numerous self-defence forces units. Many are spread across Kagawa and Kochi in Shikoku and one each in Fukuoka and Okinawa. This initiative is part of Japan's broader strategy to bolster the defence of its southwestern islands, especially given the ongoing tensions surrounding the Senkaku Islands. These uninhabited islets, controlled by Tokyo, but claimed by China, have been a focal point of regional discord. Tokyo is seriously concerned about closer military cooperation between China and Russia in terms of security, both for Japan and the entire region. Japan's Chief Cabinet Secretary Yoshimasa Hayashi stated earlier in March. He said that Tokyo was gravely concerned about closer military cooperation between China and Russia in light of security for Japan as well as for the region. Our country intends to keep a close eye on development in Sino-Russian relations, Chief Cabinet Secretary Yoshimasa Hayashi told.


Okay, any any doubts and or questions that you might have or anything that you want anything that you noticed You know that you'd like to share. Maybe you something that you've you know, you did not notice before You know you notice for the first time Kind of it made sense Anything that you'd like to share Can go ahead you can even put it in the chat You know some of the things about the work of the Holy Spirit right about the person of the Holy Spirit the work of the Holy Spirit So you could share that excuse me anything that Yeah, I was just observing how Jesus words was Perfectly fulfilled in acts like everyone is getting baptized and then getting filled with the Holy Spirit Yeah, so that is Yeah Amazing to do amazing details, right? Yeah, the same way At different aspects of the Holy Spirit like he said you will be endured power and you'll be witnesses it happened He said he will be that you know, he'll be the comforter And that you know the paraclete also that we see happening and you know, like you said Everything that the Lord foretold you will teach and he will remind and he will tell you of things to come And we see you see that all that has that's happening. Yeah Okay, anyone else something that you noticed You can put it in the chat as well. Okay, so that's let's keep going and Let's let's look at a few more right that we stopped with accept and nine so let's look at Accepted ten and So accept a ten and verse 19. So here now we're going to look at Peter and the way in which the Holy Spirit Instructed him led him to do to to do the work of ministry. Okay, so Peter He's in you know 10 19 we read about the fact that that Even before that even before The instruction is given to Peter God kind of sets up the whole thing with this person named Cornelius in the space Colesus area.  He did not know You don't have a clear understanding, but he he was a devout man He was a sincere person and who was you know whom we would say a seeker maybe But he prayed to God always he was generous person He was a good good man and now he has an encounter, you know, he has a vision and the angel of the Lord You know communicating to him and saying Your prayers have come up your arms have come up your generosity and prayers have come up before as a memorial before God And an instruction very clear instruction it right send men to Joppa the space called Joppa and ask for Simon whose name surname is Peter and And so Cornelius obeys Okay, so probably this is not the first time he's had that encounter. I'm just guessing But he obeys right here because he's sending his people to Joppa Based on a vision that he had right so So maybe he was in the practice of receiving this this kind of instructions We don't know but but anyway, he obeys he sends people to Joppa in search of a man called Simon Peter and with the instructor, you know and The instructions were given you know that he's in such a place. He's staying with a tanner a man who works with leather he's You know a tanner so his whose house is by the sea and so on so So he's he's lodging with a tanner whose name is also Simon and His house is by the sea so he sends people To contact this Simon Peter. Okay, so Simon and he says, you know, he will tell you what you must do It's a Simon Peter. I get Simon Peter. He will tell you so he sent the sense these men and Peter is there and in the very place and he goes up To pray he's hungry. He wanted to eat and they were the food was getting ready It almost lunchtime and he he has a trance. He fell into a trance and And had this experience had this vision kind of thing and he saw heaven opened and an object like a great sheet bound at the four corners descending to him and let down and And the boys came to him rice Peter kill and eat and this sheet had all kinds of you know animals Wild bees creeping things birds of the air okay Rice Peter kill and eat Peter says no Lord. I Have never eaten anything common or unclean.  I've never eaten anything that is common or unclean. I will not eat. No, Lord Then the again the voice is what God has cleansed. You must not call Common Okay, and this happens three times same thing The sheet let down animals in it all kinds of animals rice Peter kill and eat Peter refusing to do that and so this this Object is sticking back into heaven and and Peter's thinking, you know, what was that? What a strange? What a strange thing? Peter's wondering and as he's wondering The men who had been sent from Cornelius From Caesarea they come to Joppa and they are there at the door and they're inquiring is Simon Peter here and Verse 19 While Peter thought about the vision the spirit to him He's thinking about the vision the Holy Spirit speaks to Peter says spirits said to him Behold three men are seeking you arise therefore go down and Go with them Doubting nothing for I have sent them. Okay, very clear Three men came a number of people coming and and they are what they are doing, right? They are seeking They are searching for you three men have come. They are searching for you. You arise. This is what I want you to do Go don't doubt anything Go with them for I have sent them Okay, so so Peter obeys Peter goes and and we see the outworking of that obedience Obedience to the instruction of the Holy Spirit. Okay, so he goes there and then You know was 24 onwards. We see that Cornelius is you know, he's Anticipated Peter to come he's don't know doubt, you know that Peter suppose Peter does not come what to do He's already made arrangements. He's waiting for them. He's called together his relatives his close friends And I see the faith of this man God has spoken I saw this vision. I've sent these people now I have to make arrangements Because something is you know, he's he has told what I must do That I mean this person was going to come will tell me what I must do. So I let me Let me call everyone. Okay, so he's called his relatives his friends And and as Peter comes in he falls down worships worships Peter Right, he's you know, he has this he doesn't he's not have a he doesn't have a full understanding yet Okay about God and so on.  He's a good man religious man and and then You know, he's Peter says in stand up.  So he says this is what happened to me and Therefore I came okay, I had this I came so I'm here your prayers have been answered, etc You know, he says You know, how unlawful it is for a Jewish person to keep company with a non-Jewish person, but Now his that vision kind of connects and he's he sees the interpretation he gets the understanding Yes, what God is not what God has cleansed. I must not call Common or unclean and therefore, you know, I have come This is what he was referring to in that that heavenly vision that I had so, you know, I have come So it is convinced in these come Okay, so we read about all that and he goes on to share about Jesus He goes on to share about Christ and what he did And so on and the good things that he did healing all who were oppressed, you know, we and and that's when that's when we Encounter that was was 38 I've got anointed Jesus of Nazareth with the Holy Spirit and with power who went about doing good and healing all who were oppressed by the devil for God was with him and then he goes on to You know talks about his death from the death death on the cross and how he arose from the dead and And whoever believes in him was 43 will receive the mission of since we shared the gospel And then while it says was 44 while Peter was still speaking these words the Holy Spirit fell upon them all those who heard the word and Those of the circumcision who believed were astonished those Jewish people who are with Peter and Peter and said we're astonished Because the gift of the Holy Spirit has been for had been poured out on the Gentiles also So as Peter shared the gospel fully share the gospel People have heard and obviously they had received it. You know, they acknowledge it as they heard They were acknowledging this to be the truth And the Holy Spirit has poured about poured on them This is a gift of the Holy Spirit had been poured out on the Gentiles also So they are astonished. Oh, it's not only for the Jews. It's for the non-Jewish people also And how did they know was 46? How did they know that the gift of the Holy Spirit had been poured out on the Gentiles also? Well, they heard them speak with tongues and Magbify God Okay, so they heard them speak with tongues Something supernatural is happening. These were you know, these were non-Jewish people do the Gentiles and they are Glorifying God and they are praying in other tongues Just like how they themselves did, right? So then Peter gives an instruction Can anyone forbid water that these should not be baptized who have received the Holy Spirit just as we have It just as we Received these people have received so let them be baptized in water also, right? So so there you see, you know different Order in the flow of events for people to be baptized in water, right? It could be people who believed baptized filled with the spirit Like we see in some media Right, so it goes there shares the gospel They believed and they were baptized in the name of the Lord Jesus, which means they were baptized in water Then Peter and John go there lay hands. They are filled with the spirit. They baptized in the Holy Spirit Here Peter shares the gospel they receive it The Holy Spirit, you know fills them they baptized they receive the gift of the Holy Spirit And they are you know praying in other tongues and praying praising God and then They are baptized in water. So Peter saying, okay now, let them be baptized in water, right? So so they were baptized in water. So we see this You know this outworking thing so exciting, you know moments there, you know things that are happening for the first time Here's a non-Jewish, you know group of Gentiles non-Jewish who are receiving here's a man who's been who was a religious man who was You know generous man good man and here, you know his faith as he is his life has changed because now he's received remission of sins as Peter shared and he's been filled with the Holy Spirit and in all excitement Okay happening there And so all that we see in Acts chapter 10 and accept 11 What happens is there's a backlash, you know Here Peter the Jew has gone into a non-Jewish household, which is not permitted He's fellowshiped with them. In fact verse 48 Chapter 10 and verse 48 it says that they asked him to stay a few more days, right? The few days So obviously he complied he stayed there and maybe you know shared more about Jesus after all You know Peter walked with Jesus. He saw all those conversations. He must have shared all those experiences how he You know denied him and how the Lord forgave him and restored him and after you know The resurrection how they went to the tomb and saw all that he must have shared to them And also about you know them being filled with the spirit and so all those experiences he must have shared Right. He stayed there now When the Apostles and brethren who were in Judea, okay, so now when they heard the Gentiles They received they contended with him Peter goes back to Jerusalem from from Caesarea He goes back and then they contended with them where they they argued with them saying how can you do this?  He says, you know, this is what happened. This is what I saw and Three times, you know that I was asked instructed to rise and kill I said no because these are not my diet not the Jewish diet and And and how he was taken and what he did now was 18 chapter 11 was 18 says when they heard these things they They were quiet Okay When they heard these things they became silent and they glorified on saying then God has also Granted to the Gentiles repentance to life Okay, so they heard about this work of the Holy Spirit and they they glorified God, okay And I just want to draw your attention to you know verse 12 Paul recount. I mean sorry Peter recounting the Holy Spirit told me to go and the Spirit told me to go doubting nothing in Verse 15 is he again testifies and is as I began to speak The Holy Spirit fell upon them as Upon us at the beginning so he's saying just you know, you know how the Holy Spirit filled us and you know We we experienced this supernatural thing The same way he fell upon them as well and he says in verse 17 If therefore God gave them the same gift that he gave us when we Believed now, that's the qualifier God gave the same gift to them As he gave to us when we believed on the Lord Jesus Christ That was the only common thing These were deeply religious Jews those were you know non Maybe religious to some in a way different non-Jewish people and Here the only qualifier is that they believed on the Lord Jesus Christ and he says who was I that I could withstand God okay, so Peter recounts this whole thing that has happened and and while doing so He again you know reaffirms the Spirit the Holy Spirit Instructing him to go the Holy Spirit filling those people as they believed in the Lord Jesus and saying you know How can I who am I? Right, the Holy Spirit has been given to them And the only thing is that we believed they believed they've received just as we have also Received okay, so again goes on to Again prove that you know Peter actually shared this Peter actually shared this in Acts chapter 4 except of four when he When he testified when he Sorry, I accept it to I'm sorry accepted to was 39 he actually He prophesied he said you know this gift of the Holy Spirit is to you And to your children of course the audience there was primarily Jewish right so you your children and To all who are afar off as many as the Lord our God will call So he actually gives that Instruction there you know and kind of prophesies says this is what you know this gift is not just restricted to us It's for us for you your children and as all those who are afar off and he sees this Happening right before his eyes. Just like he shared that time and probably he thought it was only Jews But now he sees that you know the scope is different It's it's not just Jews anymore It's it's anyone who will call on the Lord Jesus in faith and they will be saved filled with the Spirit, okay Okay, let's let's look at the Few more verses. It's let's move a little quickly. Let's look at chapter 13. Okay chapter 13 talks about Another church, okay This is the church in a place called Antioch in chapter 13 and versus Verses one okay before that maybe I just keep the you know this reference chapter 11 and you look at verse 24 24 talks about Barnabas Chapter 11 and verse 24 for he was a good man full of the Holy Spirit and a faith and a great many people were added to the Lord talks about the work Talks about the character and also about the work and ministry of Barnabas 24 verse 28 There first to a person by name Agabus who was a prophet Agabus a prophet and it says that he stood up assured by the Spirit That there was going to be a famine throughout all the world which also happened in the days of Claudius Caesar. So Well, the Lord Jesus said that there will be as a Holy Spirit will you know share of things to come Yeah, yeah, John. You have a question. Okay. One of the things mentioned Is to abstain from meat of strangled animal? Is that the question? This is one yes Especially mentioned is just oh, I say, okay, especially to abstain. I mean, what should the approach be see now if you if you read carefully, you know That is where we are okay, we are kind of getting ahead of ourselves we are coming to 15 And we look at the Jerusalem Council also looking at 15 18 but I'll just mention that you know, this is of course to the Gentile churches and also he he says In verse 21 if you see verses, you know, 15 and verse 21 For Moses has had throughout many generations those who preach him in every city being read in the suburbs every Sabbath Okay, and and before he says but we write to them but that we write to them Staying from things polluted by idols from sexually morality from things strand strangled and from so it is from a Jewish standpoint If you look at that also is from a Jewish standpoint that He is, you know, they're sharing these things of course things polluted by idols meaning, you know Nothing's offered to idols and ad worship sexually morality, which would be applicable to all and Things strangled and from blood, but so it is from a Jewish standpoint You know if you actually look at it because it says for Moses had throughout generations Those who preach him in every city being read in the synagogues every Sunday You know, this is this is being, you know, the peace are being preached in the synagogues being shared So, you know, these things we will highlight and though and so we see in verse 28 29 the same thing they say, you know, sexually morality Things offered to islands from blood and things strangled you, you know It's came from these things. So it's going to a non-Jewish audience, but it's from a Jewish standpoint actually, you know because this is being preached in the synagogues and people who You are being born again, of course, you know, they will be exposed to that as well And then so he's saying no, let's let's come to an agreement and it's You know, let's give these instructions You know, but later when we come to the the epistles go in things we read Paul is saying, you know Eat whatever is sold in the meat market without asking any questions, right? So Yeah, so They're also, you know, they're it's just kind of makes everything clear for nothing is to be refused He says, you know for for a Jewish man to write that, you know, it's it means that he is really Experienced grace, right?  Yeah, so that's a thing. Thank you. Okay Okay, so there will be chapter Levin, right? Okay, so we finished chapter 11. So let's we finished Agrabus and also about Barnabas. Well, let's move on to accept the 13 Uh, accept the 13 versus one to four. So it's in this place in this place called Antioch. It's a it's a church the believers who were there in Antioch and And they were it says there were prophets there were teachers and Some people are listed there Barnabas Simeon and it says here was to as they minister to the Lord and fasted Okay, so they are ministering to the Lord and they are fasting and they're praying as They did that the Holy Spirit spoke the Holy Spirit said now separate to me Barnabas and Saul for the work to which I have called them Then having faster than prayed and laid hands on them. They sent them away So this is something that we see that as they were seeking the Lord They are fasting they were praying they are seeking the Lord says if they minister to the Lord No, maybe in worship and you know, they were seeking the Lord the Holy Spirit spoke and gave them an instruction and About ministry So saying now these two people now separate them to be and for the work that I've called them and and so they Commissioned them. Okay, so so we see another principle when it comes to missions when it comes to the work of the Lord The Holy Spirit speaking and saying, okay bringing the mind of Christ, you know, bring the heart of the father Saying, okay, these consecrated people love us but and you know, I have called them for a specific purpose so they Had released them for that verse four So being sent out by the Holy Spirit, they went down to Cilicia and from there they sailed to Cyprus So says here the Holy Spirit sending these sending this missionary team like the missions team Paul and and Silas and and they go Sorry, but Barnabas and Saul and Paul and Barnabas they are being sent out and then they go So which is again, you know for us Principle here, you know, the Holy Spirit knows the Holy Spirit has wisdom the Holy Spirit knows the Holy Spirit shares the strategy for ministry for missions and He, you know, yeah We can of course we need to use our mind to explore to see and I'm sure they they would have done that right They planned and say, okay, let's go to the city.  They go on this missionary journey They go on another one another one and Let that bears fruit. Okay, so so we see that happening in Antioch Okay, so after 13 verse 9 So this is the first they go to suppress and There so the to the island of Air Force then they There is a sorcerer there a magician the false prophet. It says whose name was bar and Jesus Okay, and so here The Sorcerer withstands the message of Paul. Okay, so Paul is Ministering and he's actually You know connecting with One of the leaders there it says the proconsul Sergius Paulus So he Invited the steam and he wants to hear but this saucer is resisting now. We're not given any Details how but but Saul knew the Paul knew this man is resisting so Then Saul who who also is all Pilled with the Holy Spirit looked intently at him and said oh full of all deceit and all fraud You son of the devil you enemy of all righteous Righteousness will you not cease perverting the ways of the Lord? So probably he was giving some kind of a You know Refuting with words or maybe asking questions. We don't know But the fact is that it says that he was seeking his objective was that this proconsul this Government man this leader Should not follow Jesus. Okay, so that was his intention. So here As he was doing that Paul filled by the Spirit he He discerned by the Spirit and he's filled by the Spirit and he's looking intently at The sorcerer and he says, you know, this is what you are, you know Will you not cease perverting the ways of the Lord and then that he pronounces a judgment what will happen now? Indeed says the hand of the Lord is upon you and you shall be blind not seeing the sun for Time, you know for a season you are going to lose your eyesight Okay, and immediately a dark mist fell on him and he went around seeking someone to lead him by the hand and when this happened the fact that the power of God the you know, the Fact that God knew beforehand and when he when he saw that this Leader he believed like the proconsul believe and he saw what has been done being astonished at the teaching of the Lord Okay, so he saw he heard and He was astonished Amazed and he believed okay, so this is something that we see the the work of the Holy Spirit the very first place where they Yeah, you know they I'm not the first place actually they're actually going to the second place They first go to Salamis then therefore and this is what happens. Okay, so we see this right then Let's look at verse 52 same chapter 13 and verse 52 talks about the fact that You know in This there's an conflict there in Antioch this persecution there and the Jews where They are filled with envy. They see the many many people coming to Jesus coming to know about Jesus through but so they They kind of stir them up and they raise up persecution against Paul and Barnabas so Verse 51, but they shook off the dust and their feet against them and came to Iconium. Okay, so Paul Paul and Barnabas, you know, they just do that and the disciples were filled with joy and with the Holy Spirit so we again see this happening Disciples being filled with the spirit and with joy. Okay Let's look at 15 and verse 8 okay 15 is So 15 is what like 15 this chapter was what John was referring to John Paul was referring to earlier where it addresses a Problem that they had the challenge that the early church had and one of the I think one of the yeah We probably the second challenge you would say, you know, like What what happened was this that certain men had taught the believers That you need to be circumcised In order to be saved Okay, yes Jesus did all this that's fine, but you need to be circumcised you need to keep the law You need to be circumcised in order to be saved So Paul and Barnabas have a you know meet with them and then you know They it says here in verse 2 that no small dissension and dispute they determined that Paul and Barnabas should go to Jerusalem and and about this question so it was undissolved they go to Jerusalem and The Apostles the Elders everyone comes together They to consider this and and this is what happens. Okay, so verse 8 we We read how Peter shares about his encounter with the with the non-Jewish people and how they received Christ how they received the Holy Spirit so To Peter addresses and then verse 8 he says so God who knows the heart knowledge them by giving them the Holy Spirit just as he did to us Peter, you know shares about shares and testifies this and James the response to that, you know in verse 13 He says men and brethren listen to me You know Simon has declared Peter has declared how what has happened and so on and and therefore, you know We each do something about this so in verse 28 We read this Okay, so they they say okay. They decide that these four things food offer titles Sexual immorality, you know food strangled and no blood. So this we will instruct Okay, but we're not going back to The law or we're not going to tell them that you know, they need to be circumcised now That's all wrong, right? So but with regard to the law, you know, these are some things we'll tell them that they need to Still keep.  You know, these things are necessary in so it's game seem good to us and to the Holy Spirit and And and and you see the thing, you know, it seemed good to us and to the Holy Spirit So there was the witness of the Holy Spirit in their own in their own hearts Okay, so it seemed good to us and to the it's a good good to the Holy Spirit and to us And so we give this instruction. So they they bring this letter and and so Paul and Barnabas they go and they go to all the places and And they deliver the content of the letter, right? They go to Antioch they gather believers and they deliver the content of the letter and when they read it They've rejoiced over the Encry over this encouragement. It says yeah, okay, so this is what they did So so even in that putting together, so it's so what is it? It is really you know the whole Believers the elders leadership coming together and pondering over this challenge. So how do we do this? You know, we don't see You know, we need the wisdom of God in this. Now here are these, you know believers and And yes, it's it's true that you should not burden them further we cannot not tell them to keep the law and be circumcised and that's a wrong teaching But we can share them these things and they come to this conclusion and then they and then they share, right? so in that we see the Holy Spirit witnessing to their heart and and You know giving is approval. So it seemed good to the Holy Spirit and to us Which means that they were sensitive to the Holy Spirit. It was not just You know, not just a debate or a discussion With facts and figures, but they were also at the same time sensitive to the Holy Spirit So that is something that we see with regard to church structure with regard to Not really church structure, but a decision collectively taken by the leaders of the church Being sensitive to the Holy Spirit. They are instructing other believers, right? Okay Okay, so let's look at another let's just move on acts 16 and versus 6 to 10 acts 16 and now here we see again the Holy Spirit doing something In with regard to ministry. Okay acts 16 and verse 6 Now when they had gone through Phrygia and the region of Galatia, they were forbidden by the Holy Spirit to preach the word in Asia After they had come to Mycia, they tried to go into Pythnia But the Spirit did not permit them. So passing by Mycia. They came down to Pro us Okay, so in verses 6 and 7 we see that the Holy Spirit preventing them From going into a particular area Well, the what was the objective? They wanted to share the gospel the objective was scriptural Right there after all they've been commissioned to go and do the work of ministry.  So they went and traveled so but We see here that the Spirit of God Did not permit them Okay Again, it tells us to the degree to which They were dependent on the Spirit. They were obedient to the Holy Spirit Okay Just because it was a good thing and just because it was a noble thing and the right scriptural thing to do, you know, they They were Sensitive to the Spirit of God at the end of it all So they want to do what was best Probably the timing so it is God's will to save It is God's will do that we people should know the gospel that all men might be saved But we see here that the Spirit of God in his wisdom Holding back the steam okay now Why is it happens? verse 6 We're forbidden to use the word in Asia verse 7 They're forbidden. They try to go into with near but then this Holy Spirit again did not permit them then, you know verse 9 talks about how Paul has a vision about a man in Macedonia come over to Macedonia and help us then they go then they go and obviously, you know They had the freedom to go or in other words, they They did not experience or they did not feel that the Spirit was preventing them Holy Spirit was preventing them But they literally had the freedom to go forward and do it. It's something amazing that we see here, right? so This is something that we can apply in our own lives as well, you know a close walk with God An intimate walk with God very here is every whisper and every nudge and every prompting Right, even in the things that seem good Lord, you know, if he is Yeah, principally, you know, we can right if you live by the principle Yeah, we can go ahead and do it by the principle and preset But if for some reason the Holy Spirit is You know forbidding or preventing us Are we sensitive? That's the question Are we sensitive to that to the degree that you know, that we'll be obedient even in those moments, right? So that is something for us to grow in that is something for us to follow and that's something that we see here, okay? Act 18 and verse 5 as 18 verse 5 It says when Silas and Timothy had come from Macedonia Paul was compelled by the Spirit and Testify to the Jews that Jesus is the Christ Paul was compelled by the Spirit. So that's a accept the 18 and and verse 5 Just give me a minute, please Yeah, accept 18 and verse So another the I'm just looking at another version. It says Paul was pressed by the pressed in the spirit, it says which means he was compelled and it was a Something that there was a pressing Okay, and so I just wanted to share that and was just there's a there's a there's a pressing in the sense There's a weight He felt that weight of burden that he had to share in the God share the gospel and this happened You know Like when he was waiting for Timothy and Silas and they came and joined him, right? So So this is something that we see that there's the Holy Spirit compelled The put that you know, it is like pressing. It's like way. I have to do this. I have to do this It's like a weight. It's like a burden and he went ahead and share the gospel Okay Chapter 19. Okay, let's look at chapter 19 chapter 19 verses 1 to 6 is it talks about what happened in Ephesus This is something similar to what happened in Samaria, okay So here if it's let's read and it happened while upper laws But it was at Corin that Paul having passed through the upper regions came to Ephesus and finding some Disciples he said to them, did you receive the Holy Spirit when you believed so that they said to him We have not so much as heard Whether there is a Holy Spirit and he said to them into what then were you baptized? So they said into John's baptism Then Paul said John indeed baptized with a baptism of repentance saying to the people that they should believe on him Who would come after him that is on Christ Jesus? when they heard this they were baptized in the name of the Lord Jesus and When Paul had laid hands on them Please put it came upon them and they spoke with tongues and prophesied now the men were about 12 and also it's talks about these 12 people who are in Ephesus now says there were some they were Disciples okay, so again the understanding was not very clear and they were baptized with the baptism of John Paul finds out when he asked them of the Holy Spirit they they have no idea of the Holy Spirit So then they are baptized in water Okay in the name of the Lord verse 5 and After that Paul lays hands on them and prays and the Holy Spirit comes upon them and they spoke with tongues and they prophesied as well. Okay, they spoke with tongues and prophesied so we see that happening similar to Samaria right Samaria also something supernatural happened when Peter and John went and laid hands and You know they they were filled with the spirit something similar we see in in Saul's case also where Ananias goes and lays hands you he could see his eyes were opened and He was filled with the spirit Cornelius House, of course, it was a sovereign.  Okay, right? Okay, let's look at chapter 20 Chapter 20 verses 22 and 23 So Paul testifying and he's saying now I go bound in the spirit To Jerusalem not knowing the things that will happen to me there except That the Holy Spirit testifies in every city saying that chains and tribulations await me So Paul is saying, you know, I go bound in the spirit. He's he's addressing the efficient Elders, okay, he's meeting them for the first. I mean for the last time Actually, he would not see them again and efficient if this is the place where he he was there for a long time and you know Teaching and so on. So he's meeting them. He calls them Calls for the elders of the church they come and he tells them, you know, he testifies to them encourages them and so in the course of that he says this says that I go bound in my spirit and Holy Spirit testifies he tells me that wherever I go there will be Persecution, right? There will be tribulation. There will be persecution. So So these the Lord Jesus, you know teaching that the Holy Spirit will tell Like he will forth he will give you knowledge of things that are going to happen like for tell What is going to happen? So the same thing here? So Paul is saying the Holy Spirit tells me that there are chains. I there testifies that In every city there will be chains and tribulations. Okay, and it was so in fact The Lord himself said that he will stand before kings stand before leaders to testify He will testify about, you know in chains that he's there About Jesus, right? So we see that. Okay, so let's look at Chapter 20 verse 28 and here In the to the elders against he's saying take heed to yourself and to all the flock among which the Holy Spirit has made you Overseers to shepherd the church of God which he purchased with his own blood.   Okay, God the Holy Spirit has appointed you and he's made you overseers To shepherd the church of God to shepherd to care for to protect to feed To lead, right? That's what the shepherd does. So The whole Holy Spirit has made you overseers To oversee to shepherd the church of God, so so we see another aspect of Right then One last verse as 21 verse 4 Paul It talks about now you're going to this place finish here and then they They say the city city ladder the tire versus two and three talks about that and finding disciples. They stayed there They told Paul to the spirit through the spirit Slips now So Paul knew that they'll be Persecutions now the disciples also knew that there will be persecutions and they were you know, that was revealed to them also and the way both saw The outworking of that was very different, right? So always like saying this is what the Spirit says But I must go and the disciples were saying this is what the Spirit says So, you know, you be careful. Why don't you avoid? Right? So that is what we see. So They told all through the spirit not to go to Jerusalem Okay, let's look at versus ten and level and then we close and Ten and 11 talk about Agrabus Agrabus also comes and he tooks. I mean he sorry takes Paul's belt Ties his own hands and feet and says this is what the Holy Spirit says that the owner Of the man who owns this belt, you know, will be Jews at Jerusalem will Bind him and deliver him into the hand of the Gentiles is what the Holy Spirit says. So the Holy Spirit telling or You know foretelling what is to come? Okay? Whether be persecution or trials or tribulations saying, okay, this will obey now is this helps in many ways Like Paul was already informed, right? He already knew and he was prepared Right. He was prepared to face for the sake of the gospel Because he says in verse 30, you know, I'm Ready not only to be bound but also to die at Jerusalem for the name of the Lord Jesus Okay When he would not be persuaded We ceased and we said the will of the Lord be done. So Paul was Already in he knew The spirit of God has spoken to him about what was awaiting it. Okay, so we looked at Many scriptures you can go through it again and we it's wonderful to see what the Holy Spirit did and Continues to do through his people in the church today. Okay, so we'll stop here and we'll get back next week and we'll continue with Very big talk where we left off right about the restorative moves of God and the work of the Holy Spirit in restoring To the church. Okay Okay, so thank you We'll stop here.


This session is going to be a little different because Mansukh Bhai wants to speak in Hindi So we're going to have a little conversation and I will do the best to translate it but the point is we want all of you to hear a different language and Understand what he's saying from the way he's saying a quick background about Mansukh Bhai is that his family comes from working with clay they used to make clay pants his entire family used to work together and about 100 clay pants Per month they used to make But he didn't want to be in that business. So his father let him be a tea stall owner But then when he decided to get married his father-in-law was not that happy about Up tea stall run. He didn't want his daughter to marry somebody who was in a tea stall So he decided to become an entrepreneur and started a factory in clay. So And my Hindi is really bad. So So Mansukh Bhai, please tell me what you used to do with clay. My father used to make clay utensils but What we wanted to do was to do something new innovation Because our ancestors who worked in clay used to make 100 clay pots in a day And I made a machine with my mind that started making more than 600 clay pots in a day So our ancestors He started leaving work because clay pots didn't get anything We worked hard but didn't get so much money In return, the machine I made our ancestors, our ancestors, our ancestors They started leaving work and came back to our business And apart from this we used to make clay pots I designed something new in clay pots So he made this machine instead of making 100 in a month The machine started making about 600 pans a day So most of the people were interested in buying the machine So he invented that but he also there is a tradition in India of keeping water etc. cool in a clay pot But it's just a regular brown clay pot But he actually put some designs and created new pots, new designs So tell us about it We used to make clay pots but we could fill normal water in it So I thought there are big people and rich people They can drink the water filter But there are poor people How can the filter filter be? So I made 0.9 microns of clay from clay And the water filter started coming out of it The bacteria that we need for our health We get as much of it as we need And we don't need it Big bacteria, bigger bacteria come out of one micron So he said rich people always have water filters So he created a water filter out of clay And he said about 0.9 micron technology is used So enough bacteria that's necessary for us comes in So that we don't get too healthy But it's good enough for them And that keeps them really healthy Because the necessary bacteria is coming And he's created this filter that's affordable for everybody So tell us about it The clay pots we used to make When we came to Gujarat in 2001 All the clay pots were broken because of the earthquake So the local newspaper around us wrote That the freezing of the poor So I thought that the freezing of the clay pots Even the poor have some dreams That there is a freezing in our house So it's good But the money is not available to take the freezing Even if you take the freezing money The money is not available to fill the electricity bill So to fulfill this poor dream I decided to make this mud a freezing To make it a freezing So I slept So in 2001 when there was an earthquake in Gujarat All the clay pots were broken And everybody started saying the poor man's fridge is broken So he thought we should really create a fridge for the poor man And make this fridge out of clay That keeps things fresh for the poor people Even if the person buys the fridge To pay for electricity costs a lot of money So he thought it's better to do it out of clay That keeps things fresh And you don't need to pay any money for electricity So there is water in the upper part To drink 10 litres And inside there are no vegetables and fruits And there is no electricity There is no maintenance The vegetables and fruits inside As much as we need When we cut it and put it in the cooker It takes a little time because of the more cooling But when we take it out of the fridge And make the vegetables To eat anything The fruits we eat The taste is original So the fridge keeps things cool enough That it doesn't lose the taste Because a lot of times you put things in the fridge And they lose the taste And on the top there is a water thing So you can get cold water And at the same time it keeps the fruits and vegetables Enough cool that it lasts about 4-5 days So what did you do after this? After this we used to make normal tawa We put non-stick coating on it And it needs small people That this is a non-stick tawa When it started in 2005 It only started at Rs. 25 We put a handle on it And did some new investment So we have been selling it from Rs. 50 to Rs. 100 So he actually told me yesterday When we were chatting that his wife asked him To go get a non-stick pan for her And so he went to the store to buy it And it was Rs. 450 And he said this is too expensive And he went and learned how they do the non-stick coating So he took the pan he had That was made with clay And put the non-stick coating on it And instead of Rs. 450 He started selling for Rs. 25 Now with new innovation, etc He put a handle on everything He sells for Rs. 100 The health was very good Like he didn't have a number in his eyes He had a long hair He wasn't white So his main example Is that he used to have an original tawa Which we are eating in the cooker And the original tawa is gone Because of this, we get a number in our eyes And our hair becomes white That's why I have done this For our ancestors It was the job of clay And I did some innovation in that And cooked the clay So in olden days The taste of the food stayed good Because they cooked in clay pots And now because we get into stainless steel Pressure cooker, etc A, the food loses its taste And B, it's not healthy enough That's why we need glasses sooner Our hair goes grey sooner So he said by cooking in this cooker It keeps the taste of the food And it's healthy for us also So you did so much innovation What else do you want to do? Right now In clay, I will tell you That what I have done innovation The memory of it It came in my memory The memory of our fridge And the tawa, cooker, filter And we also got the nationality award So we have come up with an idea To do something new in clay In 2012 We are going to make a clay cool home In the house There will be a light without electricity And we won't use a fan inside it Inside We will do AC without fan When we come out In our fridge The temperature becomes 20 degrees So we will make a home We will make a 20 degree Cool home This is our new thought So for all his innovations so far He's been written up in Forbes He's gotten a lot of awards from the president But his dream is by 2012 He wants to make a home made of clay So he's going to do it in such a way That you don't need any electricity Any fan Nothing in the house And it will be completely made of It will be called methi cool home Thank you