FileMaker Pro 19 Training Live

FileMaker ODBC and ESS with WordPress - 2 Days Training with Jonathan Ray

FMTraining.TV

(805) 946-6552

Contact us at: support@rcconsulting.com

https://fmtraining.tv/

FileMaker ODBC and ESS with WordPress - Day 1 with Jonathan Ray

Hey hey everyone richard carlton here welcome to another exciting day at fmtrain. tv we create great filemaker training only to move this little dialogue out of the way right there uh welcome to an awesome day because today is a topic we've not covered before in our live training it's really kind of a topic you know i would say it's more mid-level seniors so if you guys see bunny or any of the brand new people there feel free to give them some therapy it's useful to understand kind of what's possible but the technical mechanics of it are a little bit on the deep side i think today is very very exciting so what we have going today i want to introduce jonathan ray jonathan are you there i'm here can you i don't know if you can show your screen or not or where you're at or show your face uh we have a nice little picture of you here if you can't show your face because you're you

know at the walmart parking lot or something shopping at walmart we understand it's uh for those of you not understanding walmart it's kind of like the wild place there's jay jay is one of our senior engineers been around for a very very long time i hired jay initially when he was like 15. i was paying him quite a bit of money per hour his dad got really mad at me because i paid him too much per hour and i thought it might corrupt him into an evil capitalist or something it was really kind of a funny conversation i remember that with your dad he was mad at me so um but it was a afternoon project i wanted jay to work really hard so i paid him like 20 or 25 bucks an hour this is like 15 years ago and uh and jay kicked but it was awesome so jay is here as a senior engineer he's certified and all sorts of filemaker stuff today we're going

to be it's a two-part broadcast today um and i if you have questions about anything along the way please ask questions i want to welcome david sent me a whisper a little bit ago uh people are chatting with me and starting the conversation it's great please ask your question it's really important um so we are broadcast before we get too far into jay's thing we are broadcasting in high definition to discord we fix that youtube and uh twitch and so you can watch whatever on whatever platform you like right um it's a lot of moving pieces to make all this work um so let's before i dive into jay too much let's just cover the uh obligatory stuff so uh live broadcasting schedule right here so i'm gonna press the button it goes over the top of jay's head and what we see right here is our upcoming broadcast schedule today and tomorrow are all about connecting a data source other than filemaker to filemaker or

oracle sql things like that and we're going to cover kind of the basics of it today it's not something you really learn in an hour it takes a little bit more work than that now that's the upcoming broadcast schedule and some information like that this broadcast is brought to you by fmtraining. tv bringing you the greatest i have to say that really good greatest filemaker training available on the filemaker platform visit fmtrain. tv and when you come down here of course you can see the tabs across the top live training is where we saw our upcoming schedule the next six broadcasts we do have individual courses we outline them for you however we basically sell bundles anymore we really don't sell the individual courses because we have so many courses some of you were complaining um but you're not the one who has to skew and create five or six new courses and five six new products every year and so once you realize how much

work it was then that's why we have the bundle so buy the purchase the bundle support the channel support nick support myself we had to collect some money we finally got nick his new laptop he got him a new 16-inch laptop and so he's very happy about that i've been told that he might sell it to get some spinner wheels for his hot rod so he might be selling his laptop and getting a fancy shiny wheels for his hot rod but anyway uh so anyway but yeah so feel free to help support the channel so we can keep nick gainfully employed and entertained along with everyone else visit fm trainer tv check out the bundle uh buttons there really good training so with that in mind let's pivot back to jay so broadcasting about so so odbc ess what is odbc what is essj do we want to jump to your slideshow now where are we at with this conversation sure yeah let's go ahead and

jump to this uh slideshow i put together and we'll go um we'll go over a couple couple things here i want to talk about what we're going to be discussing over the next two days and then we're going to focus specifically on odbc and ess during this during today we'll focus more on the dynamics of wordpress and syncing between it and a filemaker database tomorrow but just to give you an idea so we're going to dive into again wordpress and the the syncing between it and filemaker before we do though i want to say a word about wordpress because this isn't going to matter too much if you're not acquainted with wordpress or understand why this is uh so neat so wordpress here's a couple a little facts about it uh let's see do i have to click yep so wordpress believe it or not is powering 35 of all websites right now uh wordpress is free so it gives you um it

allows for like filemaker rapid development on the web and you don't have to be a total well web building ninja in order to use wordpress that's why people like it they don't have to pay for it and they can set up a site in a relatively little amount of time okay uh there are more than 1. 1 million new registered wordpress domains every six months which is pretty remarkable there are currently 54 000 free plug-ins and what a plugin is in wordpress it's a little add-on that you add onto the base installation of wordpress one of them is called woocommerce which allows you to do e-commerce systems by really just installing a free plug-in with a click of a button and what would have taken us richard i don't know how much we would have charged to build an e-commerce system from the ground up but it would be north of a hundred thousand dollars it previously yeah yeah and so and so here we

go with wordpress just one of the free plug-ins is a free e-commerce system that a bunch of websites uh use now and makes things pretty easy wordpress is not just for small and medium-sized businesses either they account for almost a third of the top 1000 websites out there so that's that's one reason here are a couple of reasons why wordpress is is pretty important and the marriage between wordpress and filemaker here with a sync is pretty cool so maybe some of our listeners out there already have a wordpress website and even the thought of connecting with the filemaker you know maybe you haven't even thought about this so this this will be a neat two day thing here okay what i'm going to do here i'm going to uh get into a demo first and then show you exactly um what's what's running the demo uh in the background we'll get we'll get back to this slide in a second here okay so i

have a copy of fm starting point here and i've made a couple of modifications to it mainly a sync a wordpress um sync it's a it's a script that i wrote that retrieves uh all the orders on a particular site i'm gonna show you that in a second here so this is a copy of our fm starting point seven with a couple modifications to it and also i have a quick wordpress website that i set up um called my dummy company dot rcc. com in a couple days i'm sure we'll remove this site altogether this is just a um just a test website for our purposes here okay so this is one of those moments we got to be careful i had an engineer who put test data in a database one time and was making fun of the ceo of of at the time it was uh peoplesoft and he got hauled into the ceo because he said that peoplesoft ceo was a douchebag and

some other unsavory things and it was just making up data because you're having fun but then it inadvertently got published so just so you know the fast way to get a lot of attention is to accidentally post some random sample data that's not real so anyway this is a hot tip for everyone so yeah and and to be very clear if you try to order something on this site we're not going to ship anything to you uh and we're not collecting money either so no we won't take the money do we want that yeah we'll take your money but we won't ship anything to you right okay so i'm going to and just so you know um this entire site this whole shopping system probably took me i don't know 15 hours to set up from start to finish that's how quick wordpress allows you to do things uh the template that you're seeing here was free i downloaded a template i you know made some plug-in

integrations and then hooking it up with filemaker took an additional 15 hours i'm sorry an additional five hours so about 20 altogether to create a website connect it with filemaker and make the sync back and forth pretty neat so we're going to go ahead and do a sample order here and let's go ahead and order this this watch apparently it's a very expensive watch for two hundred dollars and uh we're going to check out okay and here's uh it's going to ask for some building details and we're gonna not put in a credit card we're gonna say uh it's we'll pay by check so this again is just a it's a sample so you can see the sync work okay where i'm gonna hit place order and we're done so that order has now been uh processed and in the background if you're familiar with wordpress we're not going to get into a lot of details here but this is what wordpress looks like in

the background and i can come here to my woocommerce plugin and look at all my orders okay and this one i see right now this is the newest one and the status by default is on hold so if i click on it you can see this expensive watch i just bought and it has all my details here okay the issue is getting the the goal is to get all of this order data into filemaker and then if i do a change in filemaker with that order data in my invoices right here i want it to reflect back in wordpress back and forth you can do a lot more complicated things like managing inventory levels and a whole bunch of other things and it's not just limited to this woocommerce plug-in like i said there's 54 000 free plug-ins out there and this is just one instance of being able to to work with it but as you see here this is a record so where

is this record living right now this record this order record is living in a sql database that wordpress comes with so when you when you fire up a wordpress website you install wordpress in the background it's holding all of this data in a sql database okay so the goal is for filemaker to connect to that sql source in order to pull all of the data and not just pull it but be able to write changes to it okay so i'm going to come here to my database i'm going to open up invoices and you can see i have seven test records right now okay i'm gonna come to home and i'm gonna hit sync wordpress okay so it took all of you know a second and a half and it pulled my new order here you can see for 200 and pulled my info and all that sort of thing and you can see that the status is on hold i'm going to change that status to

completed for instance okay that field has a script trigger that does a script that pushes the um the change back up to wordpress so now if i refresh the page let's uh let's just see where yeah so you see the status keep your eye on the status when i refresh you can see it changed to completed so now we have a two-way sync it pulled the data and it pushed changes back okay so that's a a basic demo again you can do all sorts of complicated things we're going to get into how exactly that push and pull works tomorrow but right now we're gonna talk about how to establish the link between filemaker and a sql source so we're gonna have to divide this up into two days here that's the little demo with the website and from here on today we're going to be working with how to do the the sql connection these terms we we just have to cover them because it

does get confusing and i don't want to lose people by using all these acronyms on you without explaining it first ess is not the same thing as odbc so they're two separate things one ess is a feature that filemaker introduced in filemaker nine okay ess stands for external sql sources okay uh so ess is a feature that allows filemaker to talk to a sql source odbc is the the mechanism through which filemaker can talk to an sql source okay it's the middle man that allows the two uh connections it's like this so you can imagine filemaker database here uh sql or a mysql source over here it doesn't have to be wordpress we're just using it as an example so filemaker odbc sql okay and then um so odbc allows for very fast data transfer okay um ess does not use odbc to its fullest potential as far as speed goes believe it or not okay so it's like having a computer that um

you know it's like having an internet connection that's only 500 kilobytes per second whereas your computer could handle much faster speeds okay so it it is used or should be used as a data source not necessarily as a replacement tool for all of your filemaker tables and it's because of a speed issue we'll get into that a little bit more but just know these these are not the same thing ess odbc an odbc driver okay is a piece of software that supports odbc communication to a particular data source i'll show you what a what that is in a second here okay to in order for filemaker to talk to a sql source it uses odbc but you have to have a driver installed to talk to it just like you have to have a printer driver to talk to a particular printer you have to have an odbc driver to talk to to talk through odbc to a um a sequel source an oracle system

yeah yeah it's the same thing i do for nick so i'm a nick hunter driver so when he says like crazy crap i can translate it for you and so you understand there you go yeah there you go exactly uh there's a question david says is ess made by filemaker uh okay so odbc is not filemaker odbc is generic filemaker can tap odbc that's on a computer okay so let me just answer some questions here before i know jay did this but i'm just going to before we get into the dsm odbc drivers on the mac side are generally seen that filemaker has a company that they uh kind of work with called uh actual technologies the guy guy's name is jonathan monroe i've known him for years he goes to dev kind of stuff i'm not sure filemaker pays him or he's just bored and does it but he has this agreement where he kind of snuggles up next to clarison filemaker they give him some

inside stuff he actually makes the drivers he sells them for the mac on windows the drivers i think are largely available and free but the drivers are not really filemaker drivers they are um they're drivers that filemaker will tap into on the computer and then through those drivers filemaker can actually talk to an odbc source odbc drivers typically will vary like you'll have an odbc driver that can go out and talk to oracle or different one that'll talk to mysql certain versions or microsoft sql certain versions et cetera probably even probably wordpress depending on what they're doing so um so that's kind of how that works right so uh so the other the driver is a piece that you have to install filemaker definitely will make use of that uh ess is made by so david asked the question ess ess is basically a capability that you're going to see here in a second um it's not really a specific product it's kind of this

built-in capability and filemaker we'll show it to you is um is a standard uh pretty much everything that filemaker does is not a standard so whenever david you ask the question like is does filemaker do something that's a standard filemaker might use standards some at some places that are out there on the internet like they use java they will incorporate javascript or something like that into the product and use it in a web viewer but filemaker doesn't output things that become standards they do everything proprietary and then they charge money for it so as a general rule that's what you're going to see uh so odbc is standard ess ess is internal to filemaker and it is proprietary totally correct ess is not this loose thing that floats it's yeah we'll show it to you in a second um and then of course jonathan if you want to get into the dsn here you know that's the next step okay um dsn all you need to

know for right now is it stands for data source name um that will be useful in a second i don't need to explain that at this point a shadow table and a shadow field okay so when you add a when you connect to a sql source filemaker tries to mimic uh filemaker wants you to uh what's the word the the purpose here is to interact with external data as if they were filemaker data yeah so so i have a couple questions here people are still confused so let me jump in here jay i and the reason i know this because i presented this at devcon years ago once or twice right so i've actually presented on this material um i really kind of detest this i i presented on it because claire's came to me and said um would you present on this for us and i'm like okay at the time i guess wim to court and all the other people that would normally do this were

not available and so i kind of drilled it down for basic users right so here's the way this works so i'm drawing and i've got my everyone to see my hands here right so i'm waving my hands ready so you have the computer system and your operating system um and above that is a communication layer we'll call that where the operating system communicates with tcp and some things like that right next to that you can install a driver that works with the communication layer that can that allows you that communication layer to talk to other database systems okay it's called typically an odbc driver okay a specific configuration of that odbc like if you write a configuration file for it that odbc driver to connect a certain way to a certain file with a certain username password that's a dsn so that's a configuration that you set up where odbc talks to a specific data source so it will talk to wordpress on this ip

with this username and password that's a dsn okay now filemaker rides above that if that makes sense so filemaker rides above it it makes calls into the odbc it can import the odbc um it can do all sorts of stuff through odbc what's interesting about this is that filemaker the ess is what filemaker and jonathan is probably going to oh there's the diagram right there but filemaker is going to display kind of fake display in the relational diagram the oracle data sources normally when you in the old days the reason why there's ess and like is really when you deal with odbc you can do two things with it you can actually import data through odbc um which was the old way of doing stuff and then i presented early on on ess which is where filemaker under kind of looks to the the odbc and sees kind of what's structured there like a table there or whatever view it's called a view and sql right

for those of you understand sql what can it see and then it graphically displays that for you in your table so it looks like an uh it's a it's a uh occurrence group a table look well it's a table occurrence is what it is and then you can cross connect it so you can see the data right that's what ess is its ability to uh put a it's almost like a phantom table on the relationship graph right because it's there and you can relationally connect to it and see stuff you can actually even go in there and define a summary field or a calculation field but you can't make schema changes to it right makes sense it's kind of a big conversation but the point is is that it through basically um it's a it's a that's why they're called shadow tables and terminology you saw a second i go shadow tables uh jay if you want to go back that real quick shadow table shadow field

it's a it's a it's a phantom it's not real but it's a representation on your table occurrence graph of this other odbc sql data that's out there and then you can relationally connect to it the thing is is it's not necessarily super fast if you're trying to process a million billion records and you try to download them through sql or odbc or whatever you know you're probably using the wrong tool if you're trying to chew through and do data warehousing and do analytics on uh you know terabytes of of data that's in a sql system you should be using another tool besides filemaker that's not filemaker's hallmark it's not it's strength people learn filemaker they want to use filemaker everything and i'm the first one to tell you there are those handful of cases if you have 100 things in the world you want to solve i want a self-driving car i want filemaker to do i want data warehousing of data you've come up with 100

different things you want to do technology wise filemaker is going to do 85 of them pretty damn good and five of them it can do as a hack and the other 10 you just shouldn't even go anywhere near it so mass processing of odbc data through sql is not a great use of filemaker if you're processing a hundred orders a day or a thousand orders a day through filemaker to odbc and ess that's fine but people go they you know because you're that's a manageable quantifiable number a thousand 582 or whatever it is and how many orders does macy's get online every day assuming they're still in business right pick someone else now is it a good fit like if amazon right amazon gets orders a day and if you were taking them into a sql system and then processing them or somehow triaging and managing them in filemaker is that a good fit no because amazon probably gets a thousand orders every two minutes okay it

would overwhelm filemaker just not a good fit of technology so there's places where this fits well there's places where it doesn't fit well and once again jay is going to get to a point i'm going to quit interrupting but that will answer a lot of questions is odbc is faster than yeah but the problem is i'm not sure david understand the reason i answered the question that lobster the way it did is i don't know people yeah so why don't why instead of me talking about why don't we show and look at it so jay as soon as you can get to a real uh demo it'll be better right i'm not trying to circumvent your thing but there's this conversation going over here okay youtube is pretty quiet and uh twitch is pretty quiet discord is pretty busy okay real quick uh this is what you'll need to actually establish the connection obviously a copy of filemaker pro you have to have a supported version sql

we're not going to get into some of these things the these things will be obvious as we do the demo okay so in filemaker here um let's let's go to my here we go okay so we're on a mac and on a mac it's a little bit different than a pc as richard alluded to where did this come where does dialog come from right here so odbc manager is an application on the mac itself this is not in filemaker this is an application that um comes with a mac um if it doesn't then it's free to download but a mac does have a built-in odbc manager application just like you have a printer driver manager application somewhere in your utilities folder so you you have a piece of software that allows you to manage your odbc drivers that's what we're looking at right here okay so i have set up um this is uh for our example here my dummy okay um you can see that

we're setting up a system dsm this is local on my computer right now and this that's important and we'll see for a second here okay the first thing that you'll need to do is install the actual driver on a mac that this is the extra step okay on a pc it already comes with these drivers you don't have to go buy them from actual technology okay uh where is it here is this website that we're talking about so on a mac you have to actually buy the driver itself for uh forty dollars okay on a pc it's built in you just connect to it we're not going to show you that example uh because we're we don't have enough time to do both operating systems yeah but it's pretty it's pretty it's pretty similar right it's almost identical yeah so so the first step here would be to go to this website if you're on a mac um buy buy the driver okay the second step

is to come here to the odbc manager and install the driver or actually when you download it you double click on it and it'll install it for you so you'll come here and you'll see actual open source databases will be in your list after you install it without that it's not going to work at all okay the second step here is to establish a connection uh between the odbc manager and your have to say you you have to have the ip address of where your sql database is living and basically the username what amounts to the username and password so on this one if i double click it'll walk you through kind of the wizard and you give it a name you can name it whatever you want and you would specify here mysql for wordpress it also supports sq sqlite and postgres on the windows i think there's also options to support db2 and other oracle systems that's a little beyond the conversation right now

but just know you select my sequel for wordpress you continue this is the server right now sometimes you could put in an ip address or using a a domain name either one works the port will default to 3306 you don't have to remember that off the top of your head okay and then the final step you have to where is it i'm just i'm just calling this wordpress or actually um it'll give you a drop-down of available databases for this uh this user i believe yeah you didn't specify the user so yeah i didn't specify the user in here but but basically i mean without us breaking our demo this is kind of the way it works you're going to specify the location of the file username password it's going to give you the database essentially that you're going to get and then from there you just continue and you finish the setup so this is the part that always kind of drives me nuts

getting this just right i mean i guess it's a little bit more reliable these days i was doing this 25 years ago and i wanted to scream literally i hate this the one part that is um that's the most difficult because it requires you to install something um at the system level on the operating system this is it's like installing a plug-in that's the hard thing about using a plug-in is this extra step so once the system dsn is established it's working there's a little test button you can press to make sure that it's working the hard part is kind of done at that point we can close this down here okay and then in filemaker this is my source file you go up to file manage external data sources all right and now you have to tell filemaker that you want to connect to the sql database using that system dsn that you just created right so we already did the hard part all we're

doing now and this one's already created and so i'll just hit edit all we're doing now is saying we want to establish a connection using odbc and then you specify what dsn you're talking about this one is the my dummy one and then you click uh you put in your username and password that's from the sql database right so wherever you're getting your data from whether it's from wordpress or some other sql source you will need a username and password and then uh and then you should be good to go your privileges for that database like what you're allowed to view what you're allowed to do is determined on the sql server that's a whole another discussion that we're really not getting into today we just want to show you how to make the connection so i already have a username and password set up that i did beforehand okay i put my username and password in and if it accepts it it'll do a

check right there if it accepts it then then you're good if not it'll say something like you know couldn't couldn't establish the connection because your password or username is not correct etc after this okay now we're going to go into manage database and you can see what we can do here we'll go into relationships and where is it here let me zoom out just a tad because it's just huge on my end that didn't help okay you can see that a a local table that's local to this file is um in regular plain text the dead giveaway that this relationship or this table occurrence is from an external file is it's in italics and so i know right away that this is coming from a file that's external to this file that i'm working on wordpress integration demo right if i double click on one of these you can see that the data source where it's coming from is not the current file the

data source is this odbc database uh connection that we just set up or we just took a look at and you can see all of these tables uh what filemaker is treating as a table these are what's called views in in mysql in sql these are called views filemaker treats them as tables and fields and so you have to know which view you want to uh you're pulling your data from sometimes that takes a little bit of guesswork you have to find the one until you find what you're looking for in this case i already have it set up i already know what what tables i need okay so if i wanted to create say a new table occurrence and i didn't have any of this here okay i would come here to new and here are all the tables defined in my solution right in the base copy of fm starting point and i say no i don't want the data in my solution i want to

pull from wordpress using this odbc so i click on that and now here is all the tables i can access the ones i'm really interested in are the woocommerce tables that's where all the order info is stored at right and so if i click on say order items for instance and i hit ok now it created a new table occurrence in filemaker and it's treating that table occurrence that that sql view as a filemaker table okay here's what i mean by that if i go into tables and i scroll down everything in plain text up here i know is um is local to this file all right the ones at the very bottom that are in italics those are the table occurrences that are from my sql source they're in italics here so i know they're from outside the file if i double click on one of these you can actually see the fields that are defined in that sql view or cable okay i'm going

to interrupt don't forget where you're at i'm interrupt so important to understand here one is that in order for this data to come here and to look at this you have to be able to uh have a live connection to cert this other sql system so if your internet's down this quits working right the other part of this very very very important is that you see it here doesn't mean you can change it anything that's in here that was pre-built by by the administrators cannot touch it and when i drew that it did a double box here but most of you probably see that one way or the other but you get the idea you now you can add now so so understand that if the data comes through over here it's important to understand that one the data is live two um you know because of that liveness that urgency of of of continuous connectivity if you have an internet issue or internet outage well

if your database is off on the internet somewhere you know then you probably don't have access to filemaker anywhere anyway but you could have an outage with that source that that you know in our case wordpress happens to be up on amazon data center so it'd be highly unlikely we'd have an outage from amazon but you get the idea you can add a field here if it's limited to a summary field or it's a calculation field because what happens is filemaker is not allowed to push schema changes to sql okay it cannot do that it cannot push sql uh schema changes there but if we define a local what appears to be a calculation field or a summary field filemaker locally saves the data and then kind of you know shows that to us um as needed right so because remember if you if you if you define a summary field or a calculation field really you're not changing the schema those those things

are generated on demand by filemaker right pretty interesting right so you you couldn't define you couldn't change any of fields they already have you can't add a number field because that would force the sql system to store new data right so as long as we don't interfere with the storage of data on the sql side we have certain limited rules we can play with this stuff is all over the certification test for those wondering about that stuff so so here you can see a good rule of thumb is that if it's in italics you can't modify it okay you can't you can't push a structural schema change from filemaker to the sql source you can look at it you can view what options are checked on it but you can't modify it if a field is not in italics here's a good example here this is one that i created it's a calculation field that i can make changes to and so here it's um

kind of squashing two fields together for a particular reason you can create calculation fields and summary fields but no just as the rule of thumb if it's in italics you can view it you can't modify it if it's not it means it's local to this file and you can do whatever you'd like with it as long as it's a calculation or summary field okay i'm going to cancel out of here and then here's what you can see let's just create a new layout go into layout mode new layout now that that table occurrence is in my relationship graphs it means i can attach a layout to it okay so all the way down at the bottom you have all these wordpress um uh tables say i want to do the posts that's one that's going to be with every single wordpress installation i call this like posts test okay and i'm just going to make it a table view hit finish and here are all the

um the fields i can put on it and i'll put them all and now you see here it's treating the sql data as if it is a filemaker a filemaker table with a filemaker layout filemaker records filemaker fields so this so this is the ess part the ess part was everything at the at the table occurrence graph level where you saw that in there and you're interacting here this is the ess part it's almost like um this extra effort because most of the time you would not be able to interact with it like this you could do an import a script step where you'd set up the odbc or you come under here and you'd say go to file j and you've actually probably under import yeah there it is and then you'd see this thing here right and then because you have the odbc setup and the dsn setup and you went through those driver installs you could get to it this way so this

is the old school way and according to net lobster she says it's still faster which very well could be because one strategy would be remember this data is all coming it's not really cash locally it's all across the internet on you know that's why it's not super fast i mean can we download a thousand records this way yeah can we download a million records this way yeah maybe if you give it two days to download so one item i thought i always had with ess was to create a local table and move the data or sync it to the data that's locally right that's you know once again again the performance issues things like that not really part of the conversation but so listen nick is here and nick is going to curse me all night if i don't talk about some performance issues and lean design stuff so the issue is that if you're doing lightweight odbc stuff that's one thing if you're doing heavier odbc

stuff you might want to figure out how to sync the data not necessarily interact with it through ess because it's just generally too slow for big data movement but uh download it synchronize it with even mirrorsync synchronize this stuff mirrorsync will synchronize between sql and filemaker right that's you know we didn't cover that we did that enterprise stuff about a month ago but it'll do it it will do it and then you have local data then it's as fast as you can do it with next lean design right so yeah and let's let's just do that right now this isn't part of my notes but i think this is helpful so if we do import records from odbc source and i say i want uh this one that we set up here oh man i gotta specify it one second i have it written down you have it written down okay yeah this is really educational i think for people to understand uh specify your

thing okay and then i choose uh the table i want all right uh the columns all the columns i guess do i have to oh no i don't want different columns you would have to know a little bit of sql in order to import it it's not like a regular filemaker import let's see uh i don't think that's the option i want i think it's import yeah i know i'm having the same i'm having the same moment you are because i haven't done this literally in a long time and i i think there is an option where it'll give you like the default filemaker import dialog there's also that option that we just saw where you'd have to write real sql code which i'm not going to do on the spot yeah there's no way yeah anyways so you can add different um layouts and attach them to this uh the external sources like we just saw and you know you get your you get

your records and you can interact with them just like you would any record so i can make a change here if i wanted to the moment i commit the change that sql source is going to reflect that change you know it's it's talking back and forth so there is no additional scripting that's involved here that's that is an advantage of um of playing with it playing with the data this way it's visual you can do fines just like you would in filemaker on this stuff and uh and that type of thing a thing you have to be a thing you have to watch out for is that because this is an sql source let's just pull it up again you have to watch out for indexing right on a regular filemaker table there's automatic indexing that you can turn on whereas indexing and then you can check it that says automatically create indexing which makes the sorting and the finding a lot lot faster but

in sql you cannot um i can't just double click in here and manage the indexing i don't have any control over it so if you try um sorting on say 10 000 records from ess it's going to churn and churn and churn and be very slow so you have to you have to watch out for that type of thing you have to use ess in a very targeted way right you don't do a lots of fines or sorting on it you're basically trying to get the data that you need and then push the changes that you need back and forth to it and and that's the real um the real advantage of using this to push it beyond that is um it's just not a good idea as far as performance goes yep now there's this button up there jay you want to re refresh my memory what the sync button does for us all right so say um say a year from now say i don't touch

this for a year the the actual schema part and someone on the the sequel end say wordpress updates their their views and they add a couple fields to it or they they rename something and that's never you know a good idea to rename a field but say they add a couple new ones well it's not going to reflect here until you come up here and manually hit sync and then sync will uh give you the uh the new fields it'll update the list of fields from that sql view that's kind of how that works but you have to manually do that and that's fine because not a lot of structural changes happen or at least they shouldn't right mostly it should be locked in because we're dealing with the woocommerce which is a customer-facing product that they're shipping right um yeah in fact in the old days one of the problems you press the sync button would break stuff so the goal was for it

to not you know unnecessarily would break things i mean some things obviously can get broken and it makes sense that they would break but um but you know just like for example if you couldn't reconnect and it would you know trash the table occurrences and stuff like that is this if claris has had to or filemaker or whatever we want to call them these days they've had to work on that quite a bit over the years i think it's in a pretty good position now i think they largely are maintaining it there i don't see them adding a lot to it but they still keep it functional and running it would seem jay so what's next on our list jay so the the deal is once you get to this point and you've established the connection now you have to kind of figure out how the sql tables themselves work right in in regard to wordpress i had to go in and figure out all right how is

the the data structure structured like okay i i have access to this info here and that's all you know that's all well and good but what do i do with it it just looks like a bunch of uh you know a bunch of stuff um where is it i'm trying to find a good view sorry all right let's just go to this one or wp post yeah so this is a just a bunch of fields and you're you have to figure out all right what what field is the you know field in inside the woocommerce orders how do i update the inventory and you have to figure out which field goes with what right that's kind of difficult part sometimes the plug-in manufacturers will actually tell you here's how we set up our our tables and that will help you out but the reason you want to do that is if you're writing scripts back and forth right you need to know what field you

need to set here so what i'm saying is if if you have an order that is on hold or it's pending payment and then you change that in filemaker to say paid or completed you want to come into the correct record change the status to uh paid or completed or whatever and then it'll then the order on the wordpress side will change correctly but you have to know which field that is so it takes some figuring out in order to do that i don't know if i explain that very well so moki's saying for uh he said uh or he or she or whoever this is i'm thinking about today's lessons obviously nice for a personal work based web store with filemaker running locally right and my only comment to that would be is that normally if i was going to roll this off for a customer i would put the driver's odbc on the server so all the clients could access it all your filemaker clients

could access it i also think this is this graphic here yeah i also think it would scale pretty well to most businesses who have a web front end once again if you're chewing through many many many thousands of orders per day then probably you should in this application not be using say filemaker for that mookie says well maybe good for simple databases you want to share with a few people without having to buy a bunch of little filemaker licenses well all right so backup so this is like one of those funny kind of conversations so uh norgan dean i think it's going a little different direction so i'm gonna hold up on his for a moment but moki i bet you know if if listen i don't know what your hourly rate is worth but most people who do serious sequel work are who are good and have a resume et cetera are 200 plus an hour if not more um and so the uh so the rub

is with this is that if you're spending you know if you were going to spend you know 200 dollars an hour building stuff and you're working to try to avoid paying you know basically a hundred dollars a year for a user and found if you buy any sort of volume license you can get the cost down to about a hundred dollars per user per per user per year um i don't i mean you're i mean you're pennywise and pound foolish is the old term right i guess i mean i i i my concern is that you're oh we're going to work really hard to save 500 bucks on licensing but then meanwhile we're doing all this other sql stuff and that's going to be you know 5 or 10 or 20 000 of work so that's that's kind of my concern about that because sequel stuff can get expensive really fast so um i i understand people who use filemaker and they're not doing a lot of coding

they don't have programmers they're trying to use it for their personal vcr vhs tape library right was one from years ago or cd library but then filemaker gets expensive and it priced itself out of the market i get all that but with sql if you're already playing with sql and stuff like that um yeah i i don't know i mean i got some people who just hate paying license fees they don't mind paying labor rates but they hate paying license fees oregon i want to pivot to oregon dean real quick so there's a lot of questions flying around here so oregon if you if you have used mysql fields and then change the names of the fields in sql then sync the new fields will show up in the filemaker table but the old abandoned names will too they will not be automatically remapped in filemaker yeah that gets back to organ dean's comment largely is about was one of the things that people would get mad

about sql and oracle and these other data systems about renaming things deleting things things like that a lot of times you cannot necessarily delete things or rename them it's just not a permitted uh thing you can do so obviously there's newer versions of sql and stuff like that maybe they fix those issues but i remember back in the day people hated that because they were amazing going to filemaker rename a field or delete a field and it wouldn't explode and light on light itself on fire um david says before mounting a filemaker database to a server with obc connections you need to create the dsn connection it doesn't matter the order you do it in david i think you can put the file up there and then uh and then do the odbc connection on the server and then log into pro and tell it to connect it should work that way when i demoed it at devcon that's the way we did it we would rent it

on a server and had the server set up and then go into pro and tell it that and pro would be smart enough to talk to server and say oh hey there's an odbc driver on the server let's go through that yes and and to be clear there um if you don't install the dsn on the server but you want all your users to access the data you have to install it on every single user's computer which is which is bizarre if you have if you already have filemaker server why not just do it there yeah the the reason that you would have to do it on every single person's computer is if you're on something like filemaker cloud where you can't log into the server and do system level stuff they just give you a website to go to um you don't have control over the server itself um so yeah and i i we have not tried odbc on cloud two so i'm not gonna

entertain questions on that i know cloud one you could kind of do it we could also ssh into the cloud one server um and there is there is filemaker cloud one and filemaker cloud two cloud two is the product and market some people still have filemaker claude one and uh but it'll be deprecated in january of next year so this coming year yeah so we'll i don't know what deprecated means i don't know if they're just going to shut people off because i just don't know i i think it's 2021 it it might be 2022. i don't yeah i'll have to go back and check on that but if you're on cloud one you should be already actively moving to something else either fight your own filemaker server or move the cloud too a lot of questions are whizzing around here uh organ dean the the dsn ties the table names which talks to my ess uh yes to mysql yep good comments questions

here organdine and omokey back and forth um yeah i i listen so it's so funny because i got an engineer who's who's definitely not here but he's uh he got yeah i had an injury a senior engineer works for me kind of intermittently i've never really talked about him here if he's here he wouldn't know who i'm talking about and he got really pissed off with claris on some licensing stuff not that it's without justification i understand that but he got not he got almost militantly anti-filemaker um about their licensing like you know i mean like there's some guys out in the final community filemaker has busily given wards to practically all sorts of people out there and those people turn around and knife filemaker in the back uh six twelve months later right it's kind of funny i sit here after 30 years of watching that they still watch this happen and then if you someday someday we'll have to have an offline conversation

where we make sure there's no claire's people here and we talk about the you know all the behind the scenes mayhem over the years that's gone on but there were some of these guys uh hal gumbert was one and then tim i can't remember his name uh he got awards for all sorts of stuff and then he promptly turned around because claris was really trying to make money they simplify their product and make they allow you to do things faster but they charge for that right so people i i had this engineer come to me it was really funny it was about a year and a half ago he sat me down says i can build this in postgres and with uh whatever he was using in and i can make this database and it's amazing all those do a basic like asset tracking database so he spends 90 minutes beating himself on the wall i'm watching him go he builds a file that has no licensing

uh cost to it all because it's basically effectively like in mysql open source file the rub with what ends up happening with this guy i guess i should be showing myself when i'm talking here what's happened with this is that i i didn't say this time because i didn't want to get in a fight with this guy um but i'm sitting there watching and going i could build this file in less than 10 minutes in filemaker and he spent 90 minutes building it in sql and and getting it to work and this and then the other thing and and so that's uh i don't know zoho or whatever yeah might be that i can't remember anyway so the rub was is that as long as you're willing to pay him 150 200 an hour to build that crap for you then you just saved yourself 10 minutes you didn't have to spend and you don't have to pay the licensing fees right but if it's if we're talking about

your entire app it takes you 90 minutes to build none of you here are like that i guarantee everyone here watching this has got applications that take weeks if not months to build from if i said throw it away build brand new and take you months maybe more than a year to build it right and so so how much is your time worth right i'm not i'm not trying to tell you one way is right or wrong i'm just saying there's two paths forward one path is cut the corner save yourself the time but pay the licensing for the better tech um or i would say tech that cut makes your time investment less or you can go down the road of uh screw the licensing i don't want to pay licensing i can't say the f word big enough for you ffffff i'm not going to pay licensing but i'm going to spend five or six times the amount of time building it right um in

whatever other system that's open source whatever and so yeah there's always a trade-off right and and and and and uh tim dietrich was the guy's name that was the guy's name who uh got into it with clarisse and then they gave them all these awards they turned around within about six to twelve months really publicly knifed them in the back i mean it was a major deal major major deal so yeah tim dietrich yeah says zojo so yeah benedict knows about this stuff uh bendix they're commenting for the record i have wordpress set up for my company employees and support system um works fine i really but i really should link it back to filemaker so i can store the tickets and stuff in filemaker yeah so so so uh benedict mike um uh bendick definitely good comment i missed it here because there's like all these comments going on here there's a big conversation we can pick this up tomorrow but um yeah so so

yeah tim dietrich uh was zojo was and zojo is this you know whatever uh front end slash back end slash whatever this is i don't i don't remember what it is because i don't use it um but there's engineers that love it and they like oh i can you know do all this great stuff and and that's fine and what i found out was that tim dietrich you know hacked file you know a knife filemaker in the back literally corporate publicly very very publicly and then um and then went off and then and he basically quit promoting it so then he would do projects and he would offer his customers you know various options on how they would do the project and they could be either sql or filemaker and he still does some sql work uh but these guys you know it's it's it's you know i think there has to be a moderating voice in things right and then claire's turns around and does this

thing where they tried to jam me up for i don't know fifteen thousand dollars in licensing for claire's connect and they want to know why i didn't go out there and knife them but i just kind of said hey you know it's not a good fit for my company right um next week we're doing uh in two weeks we're doing claire's connect with calvin we're going to talk about the economics and the models of that so the problem is claris is apple and apple goes by this model goes back to jobs you go back and understand what he does he would buy parts for 30 cents and sell them for nine dollars and and wozniak thought if he bought a part for 30 cents he should sell for two dollars or something like that and and jobs absolutely demanded to extract the maximum amount of money out of people and that's apple that's also clarisse welcome to the world so what clarisse is wrestling with is this whole

concept of of how how far can they turn the screws to the customers to get the money out of them literally it's that simple there's a new management team they're trying to turn the screws more and there's been a huge blow back and hit right from them and that's pret this is actually after t and so whenever that happens you can see the tim and hal tim tim dietrich and how gumbers winding up going see we told you so see we told you so and people like me have to just kind of drive around the conversation because it puts us in a very tough position of trying to defend some behavior that that if we were there we wouldn't decisions we would not have made right so and it's not our company they don't write them me a check so and i'm not trash no i'm just saying there's more than one way forward in life filemaker is not a good fit for everything just not so cool

all right we're going to catch it thanks jay we'll catch you tomorrow and then next week we're going to be diving out on the 19-point filemaker version 19. 1. 2 which is their first rolling release occurred uh yesterday morning i think so we'll talk more about that next week but for for 99 99 of the people out there it's the same product you had before so that's it see ya hi and the guys just stepped up the whole way calm cool collected the quarterback great read good patience more importantly great job up front protecting this quarterback to give you a chance and that's all you can ask for trying to rally down 10 9 25 to go here in the fourth short motion by amendola from the left brady takes the shotgun step stands in throws it left ramadan reaches up and starts a high throw and lands inside the tent with an eye slightly behind him but danny makes the ground you

FileMaker ODBC and ESS with WordPress - Day 2 with Jonathan Ray

Um hello everyone rich carlton here welcome to thursday we've had way too much caffeine today that's a problem sir we're gonna have to ask you to pull over driver registrat driver's license and registration how much caffeine have you had today all right today we have jonathan ray on deck it's going to be an awesome day i'm richard carlton creator of fmtraining. tv where we create really awesome filemaker training we do it every day we also have some recorded content we also have upcoming schedules so let's cover a little bit of housekeeping before we start our conversation about filemaker and wordpress and it's a continuation of yesterday's conversation it's gonna be really awesome today first off if you go to fmtraining. tv you'll see a website that looks a lot like this it's kind of surprising it's suspicious it looks just like dish and so what we do is you can come down here and hit these tabs at the top of fmtrain. tv if i can

just go to fm training tv i'll do that real quick go to fm training click that go away i come down here you'll see fm courses you hit the live training button like that how amazing a little simulator action going on there you come over here and you can see the upcoming schedule for the next six days it's all driven out of filemaker right here we can look in here i can see what's coming up for the next we're booked all the way through the end of october right um we got a notif we got a we got a request from one or more presidential campaigns they wanted to attend and have a debate while we were doing about filemaker but they didn't know anything about filemakers we had to turn them down right because i didn't want to have to talk about other stuff we're just limiting it to filemaker clarisse and anything vaguely related to that so uh we're broadcasting in high definition to youtube

discord and twitch i personally prefer discord for most things unless it malfunctions it's really cool because as i talk there's a there's about a half a second delay so discord people can interact with me pretty much in real time i have to remember that if you're on youtube or twitch is about a 90 second delay so if you see me say something and you comment on it i have to remember what i said 90 seconds ago it's really easy for smart people i am not sh it's a secret a very bright individual as a result i have frequently forget what i said 90 seconds ago so i have people like jonathan here who helped do a great job so that's the upcoming schedule we've got nick hunter coming back next week starting tuesday monday it'll be me and miles debsky having a little bit of fun and then i will let nick pick it up additionally if you want to help support the channel we really appreciate all the

lurkers and everyone else out there purchasing our training we have a complete training bundle here we have a couple different options if you want a coupon or discount feel free to email us at support in fact if you have any questions comments you want a discount for these this training email us we'll send you the discount for that um it's f uh it's a support rc consulting dot com will get you that information so this is a complete training bundle which includes filemaker pro 19 mac and windows this one right here is only the video training so there's a difference in these bundles there's some other differences you can click on them drill down and learn about it but we appreciate each and every one of you supporting the channel we really do cool so let's dive over i'm going to jump over to jonathan ray jonathan ray is a certified filemaker engineer he's been around for a long long long time uh jay you want

to show your screen and unmute yourself be fantastic waved waved everyone say hi hey hey whoop wrong one you got to show your face what your face oh i'm i'm sharing my uh sharing my screen with you you jumped ahead we have to you have to share your face just john thank you fantastic senior engineer really great guy does a lot of awesome work and does a lot of customer projects so if you're some of you are probably here uh jonathan either has or is working on your stuff right now so pretty neat conversation so um what are we doing today jay so we're going to jump right in i want to review a little bit about what we discussed yesterday and so i have my my little slideshow i'm just gonna go through the the first two slides here so we're talking about filemaker and wordpress and the the reason we're even talking about this is wordpress is a very uh popular uh web framework and

there are a lot of advantages of hooking wordpress up with filemaker but the question is how to do this um one one way of doing this is through odbc and it was a good uh training exercise yesterday to go through and discuss what odbc was in the first place and how you can how you can use it not just with wordpress but with other sql sources oracle sources that type of thing in general so we talked almost all of yesterday just about um odbc how to get a table into filemaker how to interact with the data all that sort of thing today we're going to be uh focusing in on the wordpress aspect of this and so what is wordpress wordpress why should we care about it number one let's go here wordpress is powering 35 percent of all the websites uh on the web right now which is you know just an incredible statistic more than 1. 1 million new registered wordpress domains every

six months and if you don't know already wordpress is free to install so if you have a brand new website and you're trying to build a website for your company you can install wordpress for free then go out there and find a template to start out with there's tens and tens of thousands of templates you find one that fits closest to what you're going for modify that and you have kind of a add water and mix type of website really quick and and just before we continue on here i've set up word wordpress sites for friends and family their their businesses one wordpress site i set up was done like beginning to end in two hours in a starbucks right i mean that's how fast you can uh do this type of thing and he's using the site to this day it's a simple one but it's you know five pages has uh all the stuff that he needs and people can get a hold of him through

a contact form so it's uh rapid development uh website work there are currently 54 000 free plug-ins so a plug-in is something that wordpress doesn't do out-of-the-box you add to it one of the plug-ins that we're demoing today is called woocommerce and it is a full-blown uh e-commerce system with the add to cart and inventory levels and checkout and credit card processing the whole nine yards and you don't pay a penny for it it's it's quite quite something but there's 54 000 of them out there wordpress is also behind almost a third of all the top 1000 websites so they're not just for uh simple bloggers or really small businesses it it can handle a lot and it can handle a lot of traffic so i was pretty surprised i mean there's several fortune 500 and 100 companies using wordpress as the backend okay so uh from there i'm going to exit out of here and we're going to take a look at um

how wordpress why don't you show us your shopping cart let's just start with that okay yeah because we need that link anyway because we're going to give everyone the filemaker sample file today and one of the things i want to do is put the link on it and so hopefully my my junior guys are watching i don't know if they're there i don't they're being very stealthy they never say much and so if they're here watching uh we want to put a button at the top of the page so people know how to get to this uh website right here and we're going to want this j strategically we're going to want this to kind of continue to function so we can use this as kind of a point you know we don't want to get rid of this i know it's attached to a server we have to probably have a conversation about that but i think having this up and running kind of like for those of

you wondering i'm going to interrupt just briefly here but when we build some when we do really cool technology and demo it a lot of times we will leave the demos running so for those of you remembering the synchronization the replica server replication synchronization technology we had jesse barm360 works we had five servers around the world we've actually nibbled that down to i think three servers around the world and it cost me on a minimum server kind of setup and replication around the world it's actually cost me about a hundred bucks a month to maintain that so if you need to do a demo or see a demo of server replication email me at support rc consulting because we still have that thing running it's not really necessarily publicly accessible you have to have a password for it i believe but we wanted it was so cool we had to leave it running i think this is one of those that's so cool i want to

leave it uh running because that would be really useful so jay i'm going to try to find you i'm trying to figure out where how do i get you back here i go to there we go there we go jay's back okay good so yeah so this is it so you can jay you want to just kind of go through a quick shopping moment here with us okay you're muted so this website was built uh from a free template and then i just adapted it and all this stuff is just um you know placeholder data of course uh but it demonstrates the e-commerce uh system so the plug-in woocommerce is driving um all the shopping cart features behind this right so we're going to do a quick order we're going to buy this watch like we did yesterday and i'll go to my cart and we're going to just proceed to checkout coupon code it's got all the widgets all the things you would want to have

with it very very cool and then you'd have to you know fill this whole thing out i'm just going to um you know fill fill the whole thing out with um and we're not going to process a credit card but then what am i doing here you got to check out uh required bill did it not take two three four main street there we go uh phone number okay i see is that what is it yeah five five five five by five okay and my email let's just do that and then place order now does it actually did it sorry excuse me did it actually uh send a confirmation email to you i mean it should have right part of the woocommerce thing does it do that yeah um i don't have this set up for the email yet but that that's exactly what uh would happen if i if i said so so the customer would get an email saying hey we're gonna ship it

and then in filemaker we would see this order right right so here's the next step here i'm going to go into filemaker and i'm going to go over to invoices just so you see that there are eight records here right now when i hit sync wordpress so in that split second we got our new record we now have nine and it pulled over our product okay it says it's a web order it's on hold because i checked that it was a check payment um here's my uh here's my info right uh here's my total and so forth now we're going to go back in here and in with wordpress sites you know it's a wordpress site if you go to if you go here after the domain if you put slash wp admin and it brings you to this um this screen you know you have a wordpress site operating in the background uh sometimes you know i'll be on a site and i just

kind of get the impression that it's a wordpress site and i i just check it and i put wp dash admin and sure enough it takes me here okay before you dive in there i'm going to interrupt we did a question here so uh mr bunny from the netherlands uh asked a question and there's a lot of lurkers here if you're lurking you have a question please ask the question um and we'll answer it so the question was does it work with shopify and big commerce so the answer is yeah you can set all this stuff up there's a it's it's filemaker just out of like if you open it up doesn't for starters filemaker just out of the box doesn't have a crm but we provide a free crm for people uh let me just adjust the screen here a little bit we do provide a free crm fm starting point and so that solves a lot of people's problems then they say well i want to connect it

to this or that the other thing and so that's what jonathan look if you look at this file over here this filemaker file that's right over here this is a copy of fm starting point so it's a crm that's already free it's already built all we needed to do was really kind of wire in the synchronization a little bit and that's kind of the we discussed part of this yesterday today we're going to kind of continue and finish the conversation if you have questions along the way feel free to ask but the fact that we're using woocommerce versus shopify versus bigcommerce versus whatever other systems that are out there you can even have it where amazon sells uh your product on amazon and then they through an api you can get the updated order information from amazon it's all doable it's just a matter you have to get it wired up it's not necessarily for a brand new beginner to do i think bunny you would

have a hard time with that but if you have a fairly skilled intermediate developer or a senior level developers you know the developers should absolutely be able to do this if they are a true senior developer just the way that is um so uh clarisse may offer shopify connect yeah they very well may be so the in in two weeks we're going to be doing a clarus connect broadcast so in this case we're not using claire's connect we wired our own setup up and jay to wire this up it took you what 20 hours or something like that they're about to do that it took 20 hours and that includes the um the website creation right so creating the website took about 15 and then doing the sync itself took about five now this sync just brings orders down and allows us to change the status jay was in the process of changing the status here to update and push the status up if you were going to

really wire it up you'd probably also wire up the product so you as you added products in here it would push those up to the e-commerce as well and also product inventory levels like if you have like if you have um items that typically go in and out of availability right um like a gas station most gas stations don't run out of gas for example right most coffee shops don't run out of cups for coffee so you don't really worry about inventory on that but if you're selling big screen 100 inch tvs for example and you have 25 of them in inventory you don't want to sell 35 because there's going to be 10 people are going to be pissed off that they didn't get what they paid for so inventory becomes an issue we do have inventory controls down here um and that's and that's already in the starting in this on our free crm so we've already built a lot of this uh what we're doing

is talking about taking uh your own solution or taking our our free crm and extending it into uh whatever shopping cart so to answer the question so and then two weeks we are going to do claire's connect talk about that and look at some of the things with that that'll be a claire's a calvin moseman conversation in two weeks uh but between here and there we won't be talking about connect too much that'll be a calvin conversation so uh questions you can organ dean's asking a question we'll let him finish that go ahead and continue jay so uh to be clear too we're not just talking about e-commerce systems we're using that as an example but because there are tens of thousands of wordpress plugins you can retrieve all sorts of data from your work wordpress site so if you have an online booking system for events you could pull all of the uh guest information and event information uh to see if your uh

regis registers or regis attendees have paid and so forth you can manage registrants registration registrants registrants there we go yeah and you can manage all of that from filemaker you can bring in all of your email contact us forms into filemaker um all of that sort of thing so we're just looking at e-commerce but this uh what i'm going to show you with how to set up a sync it applies to all that sort of thing too okay we're going to uh come over here and in the background we're going to log into our wordpress and this is what wordpress looks like in the background okay on your left hand side uh are all the pages these are your html pages and you can click on one and start start editing the uh the stuff in there and that type of thing what we want to look at is the woocommerce so this could be shopify you know same same type of concept i'm gonna look at

the orders and this is the one i just did it says seven minutes ago and you can see that it has on hold i'll click on this and this is the status on hold so if i come back into filemaker uh say this person came and they picked up their their order and they paid with cash now i want to tell my woocommerce um orders uh that it has been handled okay it's done so i'll put here completed all right and in that split second file just told this order uh sitting in the sql database that's behind wordpress that this was now completed so if i refresh you can see the status changed so right there you have a two-way sync a very basic sync but a two-way sync pulling in the orders pushing up updates uh to the orders from filemaker all right uh again this is an example of one plugin you can do it with many others i'm going to

from here show you how to set up a a sql user uh in the sql database this is a little bit uh this is the most complicated part of the whole discussion so before i do that do we want to pause there boss oh there i've been asking people for questions and uh and so organ dean posted some information about woocommerce and using rest api and what web hooks um we have built this connecting with odbc was part of the conversation yesterday which is different than a rest api and web hooks i think if you were going to build it from scratch today from scratch scratch like brand new you'd probably do that jonathan actually is pretty comfortable using odbc and ess and it's it's got some benefits to it i think you can go either way i think the rest api is a little bit newer technology we talked about that but basically oregon dean posted some documentation that the woocommerce people have on uh

going through the rest api process to interact with it so ken thule says so the data from wordpress uh is a button sync but two-way wordpress is automatic or some trigger yeah it's a script uh ken you have to basically we talked about this yesterday but the data from woocommerce is live in a table right so uh just if you can uh just bring up the table uh they bring up the relational diagram there with uh formula oh okay yeah uh and so this very simple if you go to the relationships here these are tables here that are yeah this all this stuff is basically live um this stuff is all live too uh it's in wordpress live and so as we're interacting with filemaker we've typically interact over here and then we have a script that will talk between this table section here and this over here so there's this data that's kind of coming this way or back this way that has to be a

script it's scripted um you could actually display this data directly and interact with it directly i think there's some negatives to that structurally negative so what we do is we have it here we have it here then we do a sync back and forth between these two has to be scripted so however you activate a script that's a totally separate conversation all of you know that you can do it probably in 50 different ways and even if you thought you knew every way then nick would come and show up and show us three ways that you've never heard of before so um that's how the data is synchronized it's a button push it's a trigger it could be an on first first file open there's a hundred different ways of doing that that's the answer that question michael gravel says has uh has has wordpress to be hosted on the same machine as filemaker server jay you want to handle that one yeah uh so it

doesn't have to be on the same machine it can be i guess uh in in this case it's not um and you know could be doesn't doesn't need to be but that that's a good segue into exactly what i'm going to show next and that is an order for wordpress to even allow its data to be retrieved from filemaker we have to set up a user and allow access to that data so wherever the wordpress installation is whether it's on the same server as your filemaker database or it's hosted by in this case bluehost or what is that that gator host i forget what that is or godaddy or whoever you use they all have a similarity in that they have cpanel okay so when you when you log in to your web hosting interface your portal they allow you to manage the um all sorts of settings okay so i'm going to drop into cpanel a test website here and you have all

sorts of different confusing options okay but the one that you're looking for is my sequel databases remember that when you install uh wordpress it automatically creates um a set of my sequel databases my sequel runs wordpress in the background even though you may not know it every single post that you do every action that triggers something gets stored in a database in wordpress's background so i'm going to click on my sql databases and i need to set up a new user right now by default the template that i chose installed two databases by default okay and i want a user to be created let's see here i'll add a new user let's just call this um odbc okay and then the password i'm going to generate just some random password here just for our purposes okay and then i create the user okay go back i create the user and then this user down here where is it okay and then the last step

after creating the user you have to add the user to the database so i click my user that i just created odbc and i wanted to add it to say this database here that to both of them eventually i'll hit add and then it says what privileges do you want this user to have and this is key if i hit all privileges that's going to allow me to do everything filemaker needs to do you filemaker needs to be able to delete records it needs to be able to uh read them and so forth these are all sql commands so i want to give this user quote-unquote all the privileges this is my odbc user make changes okay now i've done everything i need to do on my website to set up um the odbc connection and where you use that is what we discussed in our video yesterday in the odbc manager on a mac the same type of thing on a windows you this

is where you would set up your user so you i'm just going to click on one that i've set up beforehand and i'll go through this you can name it whatever you'd like you select my sql and then this is the ip that um that your wordpress site is on i'll get back to that in a second but that needs to be there um and then or or you can type in the domain as well that'll work the port is always going to be 3306 okay and then you come here and say this would be your your user so whatever it was and then your password so that's the user that you set up from the cpanel panel you're now putting it right here that's where that goes okay and if i hit continue then if i if i put in my user and password it would then display the list of databases that are available to me i would select the one that is for wordpress

hit continue and that's it so you'd need to look at that video that we did yesterday to detail here but just know that that's where that user user credentials is even coming from you set it up from cpanel you punch it in here and then filemaker can connect to it that's how that works i want to go back one place here this ip is very important so if you have a standard a wordpress installation on something like bluehost or godaddy you're not going to get a static ip by default this ip in a month on on this website here if it's not if i'm not paying for a static ip it could change on me overnight and it just won't work okay so it has to be a static ip in order for this to work all together bluehost charges i think seven dollars a month extra for a static ip same type of thing for for godaddy i'm sure and but that's that's what

needs to happen in order uh to connect to it has to be stable in that way okay that's how you set up that user from from their boss um do we want to review any of the odbc stuff from from yesterday to kind of refresh people's memories or should i go into the sync script now i would do the sync script but i do have so net lobster is asking about she's asking about and tomorrow net lobster i know if you missed this or saw this we're definitely gonna be showing off your file tomorrow so um definitely thank you for sending us a sample cool file um she's saying that 12 years or so ago they were having a problem with odbc obviously i think they fixed that i haven't heard about it um that was about the time i did the devcon broadcast or dead devcon where i presented on on odbc so i see i seem to have missed seeing that so if

it's in the request four times then yeah i think that's been resolved uh one way or the other um so i don't think that's a current issue uh benedict miller says can you use a host name rather than ip yeah yeah yeah yeah so you can use a dns dns entry or whatever i think most places you would use a dns entry we set this up on amazon so we had to pay it's a server that we're paying on the per month basis or whatever we're doing we also have to pay for what they call an elastic ip it's amazon's way of saying it's a static ip um that brings up that brings up an important point i just showed you how to do it on bluehost through cpanel but the way we're doing it right here we didn't set it up through cpanel at all for people that can set up an amazon server you can set up a user in a different way it's just a little

bit more complicated i is that the iam uh uh yeah that's yes that's identity identity access and management i think is what that is yeah so i'm not the i'm not the i went through uh tried to get amazon's uh certified and actually just even the process of trying to become amazon certified um i learned a ton and i ended up uh to be honest with you losing interest because i have a very diverse skill set and even outside the world of filemaker i got skills and all sorts of stuff you guys can probably guess what that's about and uh as a result of that i was like do i really want to beat my head and keep trying to get certified so but just even going through the process of learning the basics of getting amazon certified the other guys here at my company or cert either but they uh moki is asking how much does a static ip cost so once again a static ip but

they can really call it an elastic ip which means it's assigned to you but elastically it goes wherever your server goes on amazon's if you move the server around or they move the server it kind of goes with the server so it elastically moves even though it's static um i don't know how that much that is per month jay do you remember the the bullet point cost so so there's a trade-off here for our little demo i was going to just pay whatever it was for for our bluehost thing because it was seven bucks a month but they charge um at least a year you have to pay all 12 months in advance and so instead of paying 84 bucks or something we we chose to do it on amazon which bills us monthly i believe like five dollars or six dollars or something for that elastic ip yeah and so whenever we close down this site you know we don't have to worry about

wasting money although ideally i would love to leave this running would be useful um so we'll see if we can no guarantees we'll try to work on that so the idea here is that we have uh data from our wordpress sql database there's several different tables when when we book an order the way woocommerce is set up they have several tables let me kind of show you what's going on here if i do a new table occurrence and i go to my odbc source this is wordpress these are all the tables i have to choose from and it's kind of overwhelming you're like man well where is the where's the order data you know i want to just grab my orders where's all that stuff and you see down at the bottom here are all the woocommerce tables right so i were particularly interested in the woocommerce tables but even then there's several different tables that they have the trick is knowing where that order

information is stored and how to retrieve it so the the big ones are order items order item meta and then where's the other one and then wp posts up here nwp post meta all right because of the way the the table structure is set up in the background that we have no control over this is the way woocommerce sets things up it's not really possible to have a one-to-one setup from my filemaker database pulling all the information from woocommerce without a sync because i mean normally you wouldn't have a filemaker database set up with order items and order items meta we just don't set things up like that okay and so we don't we're not accessing in invoices this isn't the live data uh from sql right this is the live data from sql it's all kind of buried in here in in the wordpress sql tables right so you have to figure out how to find the stuff that you're looking for here in

the wp posts table if i do a find on all of the let's just show all records here there's 133 so anytime you do some sort of post in wordpress it creates a new um a new record here well the ones that i'm interested in uh the only ones i'm interested in are the ones called where is it shop order shop underscore order and you can see i've put nine orders in all together and so i have to go and look for the most recent orders the ones that i haven't pulled over yet and then i'm going to several other tables collecting all the necessary information for that order coming back to invoices and then creating them you see so i'm not this this layout is not from the wp orders table i'm not pulling directly from that that sql source this is a local filemaker table and then the sync is going to the ess sql source finding the information we want

storing it coming back to invoices and creating it all right and then when i want to post an update if i want to change the status for instance of the of the order then on a on a script trigger attached to this field this script trigger will look in and say okay um let's get the necessary info from this invoice in order to identify the order we're looking for and then it will go to the orders into the correct table find the status right it'll find this specific record here and then change the status to whatever i put for instance completed all right so i can just do this right now if i uh go to record number nine which is the one that we just had and i put pending or something okay in the background a script trigger triggered a script and we can come back here and you can see it changed it to pending so that script all it did is

it found the correct record and changed a particular field to a particular status and so the trick of working with wordpress is knowing where those fields are and what fields need to change so you have to for every plug-in it's going to be a little bit different so knowing that i'm going to jump in to some of the specifics about this plug-in this woocommerce plug-in and show you how a general sync would work okay first of all in preferences i have set up where is it wordpress i added a little tab here and this is helpful in any sync that you do it doesn't have to be related just to syncing with wordpress but you want to store somewhere the last time that you ran the sync right otherwise you're you would have to um pull all of the data and come in and like you would have to go to invoices delete all the data then come over here and store all the data then

go to invoices and create all the data all over again you certainly don't want to do that all we want to do is grab all of the um all of the orders that have been changed or created since the last time we synced right so anytime that we run the sync process we click the button to run it after it successfully completes it'll put that timestamp right there this is the last time we ran it you have to be a little bit careful about the the time zone thing and in this case it's taking into account the time offset it depends on where your website is hosted what kind of time zone they're using okay so over here uh you can see that this is the order we just did at the beginning of the broadcast and it put in today's date and a little after 12 and so i know that's uh pacific time okay but say i have a user that ran this on

the east coast and they're three hours ahead you don't want to use their time stamp to check for it because they'd be three hours off and so here in the sync i'm using um universal standard time or um greenwich something time i forget what that's called but um but it helps get everyone on the same page so no matter where you're at you're always operating with the same same type of timestamp and finding the records you need finding the records you need to alright so that takes care of talking about setting a time stamp before you do a a wordpress sync and then i'm going to pull up the script that runs this button here um in the in the file that we're going to give you of course the file is not going to it's not going to work right because you don't have the uh the external data source set up on your computer right but everything else will be here like

this script and if you hooked it up to your own woocommerce website and you installed the odbc driver came over here and changed uh this entry to your own thing then it would technically work okay but what i did here in this file that you can take a look at later i've created two different versions of the sync script this first one is easier to understand but it's longer i mean it's 227 lines of code the second one over here is shorter it's 133 lines of code but it's a little bit more complicated and how it gets the data i'm going to show you just the first one because i think we can digest that a little bit more and understand what it's doing okay so first of all it goes it opens up a new window that it's almost like a dialog window that says sync right it goes to uh the preferences layout which is uh right here okay and then it shows all records

and it grabs here's here's the part that we just discussed about the timestamp it finds when the last time the script was run and that's very important because we're going to find all the orders that are greater than that time so anything after this time we're going to find and update our invoices okay and then here this is a very important thing too this is what i call the session id okay so any uh any changes that we make we're going to set with a session id any changes that we make in invoices we're going to set with a session id and then at the very end of this whole script it goes to the invoices and finds all of the records that we just modified okay and so at the end here you remember when we did the sync script at the beginning we synced and then it showed you only that one record that we retrieved instead of all the records we want to leave

the person that ran this script with a found set of just the records that they modified and that's why we're doing the session id thing here so we're setting it at the very beginning and then finding all of the records that have that session id at the very end using a uuid so so from here at the very beginning of the script we set the last wordpress sync with the current time all right so we know when the last time we ran the sync was so every time we run the sync it'll update that field and say this is the last time we ran the sync and again this little plus time thing here allows us to be on the same page with all our users okay we commit the record then we go to wp posts that is um the table that comes with all wordpress installations every single wordpress installation will have this table called wp underscore posts if you bring it over

and every action that you do say you create a new page on your wordpress site it'll create a a record that indicates you created a new page on such and such date this is the last time it was modified and it will have different um bits of information for you okay the one the only ones that we're interested in as far as this sync goes see you see here like page so there's an update to this particular page on this date etc but the only ones we're interested in are the shop orders down here and so we're going to this going to this layout in this script and then this is very very important this refresh window here okay just by going to the layout doesn't actually retrieve all of the um new data right so you i have 133 records right now if someone went on and did an order online on our on our dummy site it won't show 134 and i can

i can leave it here for two days it still won't show any more than 133 until i refresh the window so that's that's what you have to do in order to retrieve the last batch of changes and these two options should be uh should be checked here and i believe it's the second one that is the most important the first one might be able to be unchecked but i just did it to be safe but this is very important you will retrieve no changes unless the refresh window happens there then from there once we're in our wp posts table then it does a find or it does a find on all of the um on the modified timestamp field which is right here okay and it does a find like this we'll just do it manually it's greater than and then let's insert current time it's greater than whatever time stamp we collected at the beginning of the script that was the

last sync so we want to find all records that happened um after the last sync so let's just to find some records let's go 9 30 and i'll hit enter and it shows you four records have been modified uh or created since the last time we ran the sync so we're limiting our current found set if there's none if get last arrow error equals zero then it goes all the way down here and it doesn't do any sync at all basically just kind of returns you to the invoice layout uh pretty pretty straightforward there so it finds all of the records that have changed since the last time we ran the sync and it limits it further to the post type that is shop that is shop order that's what woocommerce puts in their their post record okay that's what we're looking for there so anytime i do an order with woocommerce it'll put this this post type in the new record so we found

that and then if we found you know any records at all then it starts the loop and this loop you can kind of reverse engineer on your own again this one is the easy way of doing the sync this other one rev 2 here condenses it more but it might be a little bit more difficult to to understand how we're doing it so maybe just take apart this one first it goes to it goes to the hosts table and it starts collecting some information or it starts creating necessary um invoice records if they aren't already created so i have a a relationship set up here between my posts here wp posts and my invoices table and the relationship is set up where i have a wp underscore post id in invoices and the id of the post that's the matching criterium and because this is checked here allow creation of records in the script what this does is it allows me to create

and or update the invoice records through a relationship without going to that invoice layout so i can stay in my posts layout and create or modify the invoice records one by one and it will create invoice records if they aren't already created with that post id so it sets the status it sets the the date it was due the date invoice is the date that the post was made the order time stamp is the time stamp the order was made and so this whole loop right here what this would do if it found all four records it would either update or create my master uh parent invoice records right and it would set the basic uh data like the date it was created the status and that type of thing this is not creating the actual line items just the parent invoice from here and using that relationship with the allow creation checkbox checked i don't have to go here and do a

go to layout go to invoices i can create or modify them from my current context in the ess table and that's a good little trick just to know all right real quick so mookie asked the question hey can i use sql in order to avoid doing this other stuff so it's important to understand the answer to all of mookie's questions are is that there's more than one way to code most anything in filemaker and so uh basically the short version of it is that you can use uh execute sql to remember sqsql is a as a data finding and retrieving function um and filemaker has to convert it's not necessarily a faster function uh as opposed to going the layout and getting the data you'd have to time it to see which one is faster and so once again i want to discourage the thought process that sequel using sql and in f using sql statements in filemaker somehow makes things faster generally pound for pound it is slower

because it has to translate in and out of that where the sql execute sql is useful i'm going to go in and split screens here a little bit more that where it's useful um you know one second i mean the service we have this uh where it can be useful is a situation where you can create arbitrarily create a relationship that doesn't really exist relate the data create the data filter the data massage the data bring it over and then and then abstract that out into filemaker somehow without having to actually create the relationships if you're doing something like that it can be faster right but i don't know that's necessarily what we're doing here the other question is is could we use some alternate import strategies and things like that uh to um to speed this process okay once again um that's it's kind of a lean design question um i'm nick i'm just gonna ask you to scroll down here to your loop right here

so jay if i i was busy getting the demo file ready which the demo file is now available this file is now available i'll post the link as soon as i get done dealing with the mookie questions right so we've got this loop that's running right here uh you already do a find set in here of the items that need to be moved are they did you like somehow they're new or something like that did you a fine set to narrow the found set down are you processing so that's the part we discussed just a moment ago you find everything that's been changed since the last okay so so the reason you wouldn't want to run a loop is because the loop pound for pound is going to be slower except that we discussed this yesterday if your business is taking thousands of orders a day you shouldn't be running that thousands of orders a day through woocommerce you should not be running that through an odbc

and ess connection you could do it through a data api you could scale that way but um but doing thousands of orders right so the question is if you're doing 20 50 100 200 300 orders a day how long does it take you to have a loop like this run and if it runs five times a day or ten times a day and it does five records or ten records each time it does the loop um are you going to save anything by using lean design yeah it'll save you maybe a second and a half a couple seconds the function that the reason that we build it this way is because it's easier to mentally articulate and to train people on how to do it so once again if i was trying to confuse out everyone i could do this i could put lean design in it i could throw in some todd guy selector connector their pants and then run away so the goal is not to

make everyone lose their minds in the broadcast very very very good so we we limit the complexity to what we're focused on so we so we dumb it i'm dumbing this down as low as possible that's why i created two separate versions of this script this is the one that you can look at it and understand right away what's going on i'm going to a table i'm finding stuff i need and i'm setting fields yeah this other one rev2 is more complex but it's less lines in the script and if you're um not for the thing of heart you can yeah reverse engineer that and then if we wanted to go in beyond that we could do nick and have nicoline design this one down and then yeah but you know i you know whatever so what's the payoff is the question yeah well if you only stayed in a couple seconds then if if if people watch our training and then they immediately feel like they

need to call the suicide hotline um then that's the bad training scenario and we don't like that so that's mookie gets that that's good uh conversation organ dean this scripted approach is near real time not real time best case is running the script every minute right i wouldn't run every minute i mean unless your operation listen there is a thing where you can run a script so often in filemaker you run into the potential running into memory leaks with filemaker um for example let me give you a practical example here so rcc when we bill about half the customers we build they pay with paypal with a credit card or whatever they pay with okay and so we we create invoices at rcc once an hour we have a robot that runs and it does a loop because we try to keep it simple i'm not worried about the robot doing it as fast as possible i'm more interested in that people who look at it who maintain

it can understand it right and so the robot runs once an hour once an hour so if someone pays me and the worst case scenario is that 40 min 49 minutes elapses and then i find out about the order that's not the end of the world if you're amazon and you're trying to ship stuff right up to the last second maybe you run it every five minutes or every 60 seconds or something like that but if you run it too often you're running the risk of actually you can we've actually had customers who would run like sassy or psal scripts and they would start the next script running before the previous one had finished so you got to watch out for that so that's the oregon dean kind of conversation with that yeah and the the amazon uh thing i just set up an amazon api retrieval process for a guy who does an amazon online store and so far in the last five or six months he's retrieved

166 000 orders um and using that api we set the schedule to run every 15 minutes and for him it's totally fine you know he didn't need it to be less than that um yeah it'd be hard to imagine a a place where you'd have to get you know well amazon amazon but if you're but if you're in amazon you should we're not doing once again i mean i mean it's a good it's a it's an interesting intellectual conversation like how far can you stretch filemaker right remember what i said yesterday if you too if you found a hundred things if you could if you found a hund a fixed number of things in the world that you needed to solve in a business process you had 100 items to solve filemaker would solve 85 of them it will you can hack it to solve another five or six and there's about seven eight or nine of those hundred items that you should not do with file use

filemaker for because it's not the right tool it's not if filemaker is the only tool in your arsenal then you'll try to solve every problem with it but there are times where a legit sql database with a legit expensive sql developers is an appropriate use of the technology and it's not good for filemaker so i'm not here to tell people you know i get people on the phone say hey you know we're going to have you know 100 000 records a day and this and that the other thing and and uh and it's going to combine and it'll be exponential growth and i'll have 5000 people using it simultaneously i look at it objectively saying hey you need you know if you're calling me because you're trying to save money because the oracle guys are too expensive you probably don't have a business model that can if you're doing those kinds of orders you should have the money to pay for a robust system right not trying to

buy a five pack of filemaker with the smallest amazon server to solve the problem so uh yeah there's a conversation with organ we're talking about back office process we're not talking about email confirmation of the customer the customer gets it automatically from sql we're talking about back office fulfillment and oregon denailed that perfectly so it's a question about back office fulfillment right absolutely um and then m johnson who's been historically pretty quiet lately he's decided to surface he's typing uh whoa okay yeah i use execute sql filemaker maybe the employee id but uh that's all i'm getting so i need so no need to correlation relationship for that i do have a script that about 15 or so variables that are using separate sql statements for each variable that runs pretty fast with the script is ran manually by the user when that person needs to get different counts for work orders to do in the relationships i'd have to do a ton

of relationships and calc fields and would cause performance for that's right yeah so so once again uh m johnson's making the point that the real benefit to the execute sql statement is that in the execute sql statement you can temporarily create a bridge or create a relationship you construct it in that statement and then while that statement is executing that relationship exists kind of like a to exist in that in the system or the to's exist you've created a relationship between them and then as soon as that sql statement is done it disassembles the bridge so it builds a bridge does the stuff then disassembles the bridge filemaker natively doesn't have that so that's where that becomes really super useful so that's a good point on that net lobster the more new orders the longer it takes so you can't predict how long it will take until you run again tracking time and track the timing and adjust your schedule for worst case yeah well i

mean yeah once again um i i think that unless you're processing if you had more than 500 orders in an hour i would start to look at this more objectively in terms of performance anything below 500 orders an hour i'm not worried a filemaker will do it so yeah i mean even so if you have 500 orders in in the last hour you might be talking instead of a second and a half all of six seconds five seconds yeah but listen if you have what we're back to the conversation if you have 500 orders an hour you need to be using the appropriate technology you wouldn't even have it tied to the user's machine it would be tied to a robot or some other process psos process or something like that it should not be even running on the user machine because if you've got that many orders you have a whole team of people that are running around fulfilling this stuff and it's it's quite a large operation

with big money moving around right i mean unless you're selling one dollar orders every hour right so but most orders are going to be whatever size whatever margin that's a lot of uh boxes to packages to ship out so going more into this i don't think would be uh overly beneficial all we're all all we're trying to say on the broad level is that we are retrieving all the orders and order items that were changed or created from the last time we ran the sink and then after it's done finding all the stuff that it needs to find in the various tables and from wordpress then it creates them it updates the uh the invoices and the invoice line items as needed and then closes the window for you leaving you with your found set of invoice records that have been changed and that that's as easy as i can put it okay so moki just said something here import wp table to local table

uh oh you asked a question well yeah okay yeah but okay well i thought i addressed that right so uh yeah yes more complicated though um when when it comes to wordpress their their records are of different types right so you have like this post type shop order there's only you're here there's there's only nine of those records that i even care about so if i did an import it would pull all 133 over to my new table and then i would have to delete the ones i don't need and so forth so even an import has some drawbacks could you do a found set and limit it that way i mean you could do it i guess i don't play with ess that much mostly because i hate it uh but that's just me um you're obviously much more comfortable with it than i am so um but yeah i mean once again this gets back into uh i i'll say this again i mean i was

answering mookie but he only heard half of what i said or she hit or what i said so the issue is is that there's more than one way to do this and so we're doing it in a way that allows us to communicate the easiest to you we're not saying this is the best method for deploying a fortune 500 company right okay so uh mostly i'm trying to transfer the knowledge from here to there so yeah it's a lot of people here so my job is to transfer the knowledge to you i'm not telling you um that the the objective today wasn't to deploy e-commerce for a fortune 500 to process a thousand thousand orders an hour and that goes as fast as possible because if that was the goal then we can't do it in an hour okay it's a we'd have to take we'd have to have jay in here for three or four days and i'd have to have nick in here for four or five days

to tune in some more and then all you folks would have to write a big hack to cover the cost so anyway i would say uh click the up vote on the video but i don't know where you'd upvote us here just click the upvote tell people about us let us let everyone know if you're a lurker here and you're lurking i'm looking at you lurker people in there i see you on the internet don't forget to buy the training and support the channel we really appreciate it all right cool everyone see you tomorrow all right thanks everyone goodbye so and the guys just stepped up the whole way calm cool collected the quarterback great read good patience more importantly great job up front protecting this quarterback to give you a chance and that's all you can ask for trying to rally down 10. 9 25 to go here in the fourth short motion by amendola from the left brady takes the shot they'll step stands and throws it left ramadan reaches up and snacks a high throw and lands inside the tent with an eye slightly behind him again he makes the ground

LiveStream - 10.06.20 - FileMaker Anchor Buoy - For Beginner to intermediate users - With Nick Hunter - Day 1

Why We use Anchor Bouy, and why it is important to keep it clean and organized. If it is not clean you can get into some sticky Spider Web situations which can be hard to navigate and clean up.

LiveStream - 10.07.20 - FileMaker Anchor Buoy - For Beginner to intermediate users - With Nick Hunter - Day 2

Why We use Anchor Buoy, and why it is important to keep it clean and organized. If it is not clean you can get into some sticky Spider Web situations which can be hard to navigate and clean up.

LiveStream - 10.08.20 - FileMaker Anchor Buoy - For Beginner to intermediate users - With Nick Hunter - Day 3

Why We use Anchor Buoy, and why it is important to keep it clean and organized. If it is not clean you can get into some sticky Spider Web situations which can be hard to navigate and clean up.

Daily Open Q&A with FileMaker Experts. Questions about Installation, Upgrading, Purchasing or How to make FileMaker work for you in your company to increase ROI.

Daily Open Q&A with FileMaker Experts. Questions about Installation, Upgrading, Purchasing or How to make FileMaker work for you in your company to increase ROI.

Get up to speed with the FileMaker Video Training Course!

Top Rated Course by FileMaker Expert, Richard Carlton.

http://fmtraining.tv/fmpro19.php

Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 30 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference, Richard will teach you all the ins and outs of building FileMaker Solutions.

The course is 60 hours of video content! Transform your business with the FileMaker Platform

Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide.

Richard works closely with RCC's staff: a team of 30 FileMaker developers and supporting web designers. He has offices in California, Nevada, and Texas.

Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client-server integration.

Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution.

Looking for FM Starting Point free software download: http://www.fmstartingpoint.com

FMTraining.TV

2122 9th St., Suite 102

Los Osos, CA 93402

(805) 946-6552

https://fmtraining.tv/

FileMaker Pro is a simply powerful software used to create custom apps that work seamlessly across iPad, iPhone, Windows, Mac, and the web

Free FileMaker Training Videos Channel https://www.youtube.com/user/FileMakerVideos

FileMaker 19 Video Training Course Introduction-FileMaker 19 News-Learn FileMaker From The Experts

https://youtu.be/oszJcgSjxJE

https://www.youtube.com/watch?v=oszJcgSjxJEu0026list=PLjTvUZtwtgBTCbN3Sr7yn6weIyIofDoMLu0026index=2u0026t=1s

FileMaker 19 New Release - Top 10 Need To Know Items in FileMaker 19 - FileMaker Top Ten News

https://youtube.com/watch?v=kRDXfpMrjvM

https://www.youtube.com/watch?v=kRDXfpMrjvMu0026list=PLjTvUZtwtgBQ_rHl8G-LP4gSVl7mvO-Zqu0026index=2u0026t=0s

FileMaker Purchasing Options-FileMaker Training-Best Way To Purchase FileMaker 19-FileMaker 19 Video

https://www.youtube.com/watch?v=LlZqf_8N1Ho

https://www.youtube.com/watch?v=LlZqf_8N1Hou0026list=PLjTvUZtwtgBTCbN3Sr7yn6weIyIofDoMLu0026index=3

A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data

Video introduction to iOS App Training https://www.youtube.com/watch?v=cVxQe_yAshw

Free FileMaker videos check out ...http://www.filemakervideos.com

Download the FileMaker Pro and FileMaker GO for mobile devices training videos at http://www.fmtraining.tv

Download FileMaker Go video training at https://fmtraining.tv/fmgo19.php

Download FileMaker Full Video Training Bundle at https://fmtraining.tv/subscription.php

Learn how to use FileMaker to create an app with the FileMaker Training Series

Comment, Like and Share All of Our Videos.

Feel Free to Embed any of Our Videos on Your Blog or Website.

Follow Us on Your Favorite Social Media

https://www.facebook.com/FileMakerVideos

https://twitter.com/filemakervideos

Join us for live training on Twitch daily at 1pm Pacific

https://www.twitch.tv/fmtraining

https://fmcoachescorner.com/

https://www.youtube.com/user/FileMakerVideos

https://www.filemakervideos.com/

https://fmstartingpoint.com/

https://fmstartingpoint.com/downloadform3.php

Download FM Starting Point

https://filemakerfree.com/

https://filemakerfree.com/signup.html

FileMaker 17 manual For Novices kindle

https://www.amazon.com/FileMaker-17-Manual-Novices-ebook/dp/B07D952V1W/ref=sr_1_1?dchild=1&keywords=FileMaker+Book+for+Novices&qid=1604344406&sr=8-1

https://rcconsulting.com/courses.html

https://www.guidetofilemaker.com/

Blogger sites

https://fmtrainingtv.blogspot.com/

WordPress sites

https://fmtrainingtv.wordpress.com/