FileMaker Video Training Review
Contact us at support@rcconsulting.com
(805) 946-6552
FileMaker Video Training Review
Whoa i'm on the wrong side i have to flip myself over one two three go to the other side and flip right on richard carlton here welcome to fmtraining. tv we where we create and my team creates we create awesome training videos here every day at one o'clock on demand videos that are part of our video courses but once again the one o'clock is live stream so it's a little bit more free-flowing with questions and answers from people like yourself i want to welcome jesse barnum who's gonna be here we'll get to him briefly here in a second he's our guest speaker today um he's been refactoring the demo today so i wanted to make sure that it was going to work good for us and i think we're in great shape i want to welcome tk55678 obviously robert from texas fm bob spector 207 we got carol we got one brother men we got dave one dave two gadi ken bunny nick nick lean nick
super lean nick jacob taylor of course always on hot standby he's awesome guys scott taylor man we got a lot of people here right and uh a couple people from 360 works as well so real quick welcome to day three of filemaker and the enterprise what is filemaker in the enterprise we're going to cover that here just shortly but the enterprise is deploying filemaker in a very large scalable way beyond several hundred people we're talking beyond four or five hundred people we're talking big groups of people filemaker will do it in order to make it work you need a little bit of helping a helping hand from some third parties um in the case of this demo it's rcc our product our crm product which is free as well as jesse barnum's mirror sync product from 360 works so this is our guest speaker here today i'm going to run briefly through our slideshow if i can make it work there we go so the broadcast
today is brought to you by fmtrading. tv where we create great on-demand filemaker training at an affordable low price visit fmtraining. tv for great deals now additionally at fmtrain. tv you can see our live schedule which is what you see right over here if you press the live button you can see the upcoming six days of broadcast we generally generally don't broadcast on saturdays and sundays although that does randomly happen if we if we have a lot to say right um or if we have some really amazing content so uh but generally monday through friday at this time slot uh we have jesse barnum today tomorrow and also surprisingly enough he is i told him that we were going to talk about mir uh basically really an open question answer session on friday and that he didn't have to be here and then when people ask hard questions i would just make it up right about you know mirsynk right because it's really his product and
i'm happy just to you know make lie and tell fairy tales about the product if he's not here so then he decided that maybe it was better if he showed up on friday so that's awesome we're welcoming him back for one extra day um we are streaming live in 1080 so youtube twitch and discord once again we are broadcasting it 1080 resolution and then it is recorded uh and during the day or two that comes after the immediate recording we kind of clean it up a little bit and then those are the videos that you see so if you're looking for the first day it's already on youtube right now if you go to youtube and you type in filemaker training one word you'll find our channel at the bottom of the channel you'll see day one day two is being edited right now um and then we are currently on day three at the moment um i do get emails from people in the middle
of broadcast going where's the recording at and i'm like dude we're still making the recording it's like still happening we haven't released it yet i do get those it's kind of funny um so if you go to fm training tv and you want to help us support this channel because it's not free the just the cost of this week's worth of demos is just in licensing fees with amazon about a thousand bucks because we legitimately set up high performance servers that can handle we could right now deploy this crm pretty easily to about 3 000 people in real time um pretty easily and so we're going to kind of be showing a little bit more of that today and then tomorrow is the uh where we invite everyone in and you can come in and play with the data okay and you can add a record in australia and it will show up in california or in europe or in india it's just awesome
so if you want to come to our website uh and buy one of the bundles this is how you support the channel we have the filemaker training with the uh special version of the crm for uh basically 300 bucks and then you have the if you're looking for the video only version you already have filemaker um you already you don't need the crm you just want our video training our on-demand training you can get it uh for a lower price right there so once again fm training tv and then hit the bundles button uh additionally we're heading towards devcon so it's time for our double double deal right so like you go to in-n-out burger and you say you want an animal style or doggy style or whatever you want to get your hamburger that way you're going to go to our website bitly. bit. ly right and then fm double and i can put that link in there this allows you to get that the two of
those bundles the complete bundles for much cheaper like 349 bucks so instead of one of them being one being 299 you can get two of them for uh 350. so it's pretty good now not to be outdone by anything that's happening here jesse who is the captain of the starship today because we are doing the enterprise uh has a special deal i want to encourage everyone to go to this this is 15 percent off the mir sync software this is the stuff that makes syncing possible if you need to sync offline with filemaker pro right you need to sync offline with on a laptop or on an ipad or on an iphone or instead of syncing between the server and a client you actually sync between servers which is kind of what we're talking about right this is the same product it does both pretty awesome um so i want to encourage everyone to let me know about that um and then uh and then jesse if you
could before i get get to you real quick can you do me a favor and find that uh claire's community idea you had where you were requesting a supported upvote because scott henderson reminded me of this and we should let everyone know what the link is so they can hunt that down and help us out because right now if you want to deploy this product you need to use filemaker server you can't use filemaker cloud 2 because there's kind of a critical bug in it and claris may or may not take that bug seriously claris only fixes bugs that people complain about if you don't complain about it they won't fix it and so you have to complain and literally what they do and i've seen this and it makes perfect sense i do the same thing if you have 50 bugs and you're going to fix half of them then you total up the complaints on each one and you do a little sub-summary report
and the the mo the 25 most complained about bugs get fixed and so we want to make sure that this bug is up on the list pretty high so they will take it seriously because we want to be able to do synchronization even if people are using cloud 2. so that's really a great thing sue hopefully we can find that and go down that road so um the next slide is kind of a new one i'm gonna bring this down right now and i'm gonna click here i want you to folks to watch this this is kind of what we're talking about here so this is the world okay if you can see all this this is where in different geographical regions we have servers that are communicating and running and then if one server drops off the other ones can keep going and the people that were down here accessing that server can connect to the next closest server and still be running right so that's the
idea of this worldwide geograph replication once the server comes back up online it automatically reattaches and is updated with synchronization so that's what we're talking about pretty awesome stuff um there's a question about um we'll save it towards the end there is a question well yeah i'm just going to save it towards the end uh i think this is one of the uh top f i recognize this name j few right he's an ets guy all right uh jesse are you there are you ready to i am you are ready for the url that i sent you uh i will find it and send it out when you start talking to everyone uh okay what i want to do what i want to do up front is you have a question already from people um and the question is i think this is from jfu right uh on ets if i had to guess and the the name here is really close he says sorry this off top
off topic but can you quickly talk more about what mirrorsync needs in order to connect to an sql database for example if i want to connect a microsoft sql database with a filemaker database what privileges and accounts do you need to connect to the sql database is this done by odbc i have found that dbas and the enterprise can be very protective of their databases and don't like things connecting to it okay well i will just verify the last sentence yeah dbas in the world don't want anyone touching their database so sometimes you have to get the cio to put a gun to their head to get them to do it so but if you want to talk about the sql connect component right yeah so you're going to need um access on that port you know through the firewall in the case of microsoft sql server i believe it's 1433 port number not 100 positive about that um so you'll need that port open for your
ip address you will need a database level username and password now how much access you need is entirely dependent on what you want to do so if you want to set up a read-only sync where you're just pulling from that microsoft sql database and pushing to filemaker maybe you have microsoft sql set up as a read-only spoke i'm sorry read only hub filemaker is like a a writable spoke then all you need is read-only access credentials for that database if you want to insert if you want to do a bi-directional sync then obviously you are going to need permissions to insert update and delete records you don't need permissions to do ddl database description language to modify the schema of the database although mirrorsync does have some cool features to create new schema from a filemaker database so if let's and i know this is not actually your question but well if they if they if they weren't gonna over connecting it then them
not caring at all that you're just gonna like start changing your scheme yeah never mind this guy named jesse barnum who you've never heard of before it's got this app which automatically on its own just start changing your schema right there is a really cool feature in mirror sync let's just say actually this might be a valid thing let's just say that you want to just create a separate microsoft sql database like not write to their real production database but sync with some other database that they can talk to mirrorsync has a feature to create all the tables and fields in microsoft sql oracle or mysql from your filemaker tables so if you set filemaker up as the hub mysql oracle or microsoft sql server as the spoke and you have a fresh empty database that the i. t director you know just says we'll just let him play on this one database that's empty microsoft then mirrorsync at the end of the configuration process it'll
generate a long sql statement and you can hit execute sql and it creates all the tables and fields for you to match the filemaker tables and fields now that's obviously not what you would do if you were talking to an existing live production database but it's very handy if you're starting from scratch on the sql side all right so hopefully that answer answers his question and then there's a discussion someone is asking where is new zealand because it's not a real country i don't know i did not say that it's like where is this at what's it doing here and and so new zealand is like down so with this piece or it's around here it's around australia somewhere right so anyway so we're going to put we are going to be showing a server hopefully in australia tomorrow hopefully in sydney is close enough for your speed for that hopefully yeah so oh and lexi folger is back oh my gosh yeah lexi says
i love the drop table feature right bamo right oh yeah nevermind yeah favorite favorite feature okay so uh we're going to transfer command so i'm going to be playing air traffic control everyone and i'm trying to watch for alexi when she says oh by the way i had a question so jesse why don't we transfer command to you you're going to share your screen maybe see if i can bring it up and uh tell us tell us what are we doing today so if you're seeing my screen right now what you'll notice is the list of configurations is blank uh the last two days when i've been showing this i've started with already configured filemaker starting point uh and so what i wanted to do today was just just to show you what it would look like if you were setting this up maybe in your own solution because the enterprise edition of filemaker starting point comes with mirrorsync already set up we've already done all
of the copy and paste operations and added the tables and all that kind of stuff in the layouts uh and so if you're using the enterprise edition of filemaker starting point there's hardly anything to do to make it work with mirrorsync uh one important tip is that if you name your we've assumed uh in when we did our kind of pre-setup for filemaker starting point the name of the configuration would be fmsp so if you name your configuration fmsp then it will save you one step of not having to rename the script in mirrors and in filemaker because the script has the name of the configuration in it so you can name it whatever you want but if you name it fmsp uh it's one less step so i wanted to show today and richard wanted me to show what if it's what if you're dealing with some other solution that that is your own custom solution that isn't already pre-set up for mirroring what does that
process look like what is the configuration you know walk through yeah the question is what if you're unfortunate unfortunate enough not to be having a latest copy of fm starting point and you're stuck with some others get there we want you to be successful even if you choose that you don't want to use starting point which is fine that's fine i won't take offense it's okay so so uh so that that's what i'm doing today i've actually gone into my enterprise edition of from the starting point and i've deleted the tables layouts and scripts that go with nursing so i could show you what it looks like if i was setting this up for the first time um i am cheating a tiny bit there's one thing that i'm not deleting because it's just tedious to create which is a bunch of blank layouts if i go into my manage layouts i have a whole bunch of layouts here and all of these are blank if i show
you what they look like they're very boring and they look like this so this is just a layout what matters in this layout what's important is the table that it's based on t19 tasks so now mirrorsync whenever it needs to do something on the tasks table it will switch to this layout it'll you know insert delete update do set field operations doesn't need to have fields on it it just needs to have a context that it can operate from so that it can uh you know so because filemaker scripts are all based on on layouts so i'm not going to bore you by creating 25 blank layouts so that part's already done right here so with that with that said everything else is pretty much standard you know you've got if i look at my field definitions i'll just pick a random table here let's pick something with some less fields on it um how about terms qbo terms so you can see
we've got a creation timestamp a modification timestamp created by modified by primary key all extremely standard stuff that probably every one of your solutions has these things um then we've got our actual fields term name and term id um richard could probably tell us what these fields mean i don't actually know well that's that's the quickbook integration stuff right if you want to play with the quickbooks integration stuff so yeah okay and then there is one thing that we've done that is not truly sync specific you might want to do this on your on your own anyway but it is helpful for mirrorsync and i'll talk more later in the demo about why it's important but uh but uh jonathan from richard carlton consulting and i work together to add this this field to every table and i'll talk more later about when it's necessary but basically what this field is is it is um the one the one field i happened to pick the one
table uh where that wasn't set correctly so so basically what if you if you wanted this is just a regular filemaker calc formula and i'm sure some of you can read this and immediately figure out what it does but for but for those who are are not as advanced what this is basically doing is saying this modification time stamp field we don't actually use it in the calc at all it's not used we don't care what it is the important thing is that the way a case statement works or actually any filemaker function that references a field is that filemaker function will trigger anytime any one of the fields it references changes so we don't care what the value is on modification timestamp but what we do care about is that any time the modification timestamp changes this calculation updates itself and it will update itself with whatever we put here which is get current host timestamp so what this will do is that so i
am in eastern time for me right now it's 4 21 pm the server is in west coast time so on the server it's 1 21 pm um and so i'll actually demo this right now i can move richard out of the way i'm in the way yeah sorry about that and i am by the way connected remotely to the server from atlanta to san francisco so if it's a little bit laggy that's why um so i'm going to uh what was that was the quickbooks terms table oh we're not even syncing that table i picked a picked one that's not one that we decided we didn't have to sync let me find another one okay let's do categories so we've got our modification timestamp host let's make sure this one is not messed up wow i'll need to make a note to myself because i might have might have missed something on my where is our model yeah that's fine keep going on that
jesse so for those of you who are not super ninja level developers uh we spent an entire session with nick hunter banging on auto inner calculations and all the magic that can happen there so if you're interested in that um we will uh maybe tk or something we can find the link for that but it's a live stream that we did and we tore that all apart so uh yeah so the autoenter calcs are kind of usefully universally useful so are you good now almost this one is good yes so we're gonna do email forms so angle forms has a date modified time stamp which is just your plain old timestamp that everybody's used to saying modification timestamp and then we also have a modification timestamp host and that's this calculated value and if this date modified timestamp changes then we will insert the timestamp on the host on the server so i will demonstrate that i didn't make any changes so i can just cancel
so i'm going to go to the email forms layout there it is and i'm just going to temporarily drag these some fields out just so you can see what i'm doing here so here's my date modified timestamp which is back in may and then here's my modification timestamp host which is blank because no changes have been made and i am just going to do something i'm just going to stick over here so this is the part i want you to notice the modified timestamp is 424 which is my time the 124 is the server time um and uh and and so and it's actually funny the server and i happen to be accurate to the second from each other i was expecting this to be a few seconds off um but i'm actually the exact same second as the server it doesn't matter if these fields are on the layout or not i'm just going to delete them so nobody thinks that they need to be
on there for any reason i just wanted to show you how that works and later when i'm running the initial sync i'll have a minute or so of down time and i'm going to explain more about whether you actually need to do that or not in your solution so uh getting back so let's go ahead and set up so that's before i start let's just recap what has actually been done in this solution so far every table has a primary key which is a uuid in this enterprise edition i've got my sync layouts which are all blank i've got a modification timestamp a creation timestamp and for this particular solution i went ahead and created a host modification timestamp as well other than that this is just a you know probably very similar to everybody on this call kind of solution so let's see what's involved in adding mirrorsync integration to this and create a new configuration and i do want to talk about this for
a second before i skim past it so this first radio button is what you would pick if you wanted to do a client to server sync if you wanted to distribute offline copies to people on ipads phones laptops and have them use filemaker pro or go to sync with filemaker server the setup process is identical between the two the main change is just whatever button you pick here at the beginning so that uh that's how that works the second radio button which i don't often talk about but it's quite fascinating is we actually have the capability of nursing to sync an offline ipad or iphone filemaker go or pro offline file directly to a non-filemaker database so you could sync you know 100 ipads to mysql for instance without filemaker server at all on the mix you do need filemaker server just for configuring it because we need to be able to talk to the data api to get a list of all the tables and
fields and things but for the actual synchronization process filemaker does not need to be running at all and you can actually sync directly from filemaker pro or go to any supported database that mirrorsync works with redshift you know salesforce mysql oracle postgres anything like that i'm going to focus on this one syncing multiple filemaker servers sql databases or web api so this is a these first two are client to server syncs and this third one is the server server sync i can name it anything i want i'm going to call it and i had mentioned earlier that it saves a step if you could name it fmsp in this case it won't because i've already deleted everything in that file so i it wouldn't be any more or less steps no matter what i named it in this case hey jesse i do have a i'm going to interrupt just briefly so yeah i missed this earlier jake uh jake shealy i had to learn how to
pronounce that name uh that asked the question doesn't or don't don't insert script steps require the field to be on the layout uh so the insert field contents does require a field to be on the layout if you're using that script step i prefer to use the set field script step for most cases the set field does not require the field to be present on the layout so it's a good question it's two different ways to accomplish a very similar thing um there are some cases where you might want to use the insert field but frankly i've forgotten them because i've i've never uh never needed it and i used to know what what the cases were that you might use it but i pretty much always use set field because it'll work whether the field is on the layout or not yeah i think i try to stay away from the inserts unless you really really really need to use them because it's uh it's more
sensitive to the context so yeah and i'm going to briefly turn off my screen sharing just so i can grab that password i'll need some music here i'm starting humming hey justfondo figure despondo is in welcome desfondo and then michael from montreal and brotterman from arkansas welcome welcome welcome welcome bunch of people here top cats here scott canes here scott henderson's here wow a whole bunch of people all right so what i've done now is i've told mirrorsync my hub database i picked the type over here and just to reiterate filemaker server any jdbc database microsoft sql mysql or for my valid hub databases i've told it the address of mirrorsync and i've told it the address of the server in this case they happen to be one in the same mirrorsync is running on the database server one thing you'll notice here well okay i'm sorry i'm getting off on a tangent let me finish my first point and then move if mirror sync
was not installed on the hub box then i would pick this radio button and now i can put in a different database server than mirror sync so i think mr scott asked the question yesterday about should you install a mirror sync on the same box a server or in a separate box and uh i think 95 percent of the time for most people same box is fine but if you've got a very high performance uh situation and you want to maximize the speed it is faster to put mirror sync on its own box and in that case mirror sync's address would go here and filemaker server address would go there this choice right here internal external addresses are the same or different you would pick different if you're running behind network address translation so you have a private set of ip addresses and then a public set of ip addresses you would put different and then you could fill in different addresses for internal and external
then you fill in your database username your database password your filemaker server username your filemaker server password we need the phone obviously we need the database username to to talk to the database find out what fields and tables it is we need the filemaker server admin credentials in order to automatically move the files around open them close them transfer them from pub to spoke that kind of stuff then we choose our database uh on this screen by the way this will not work if this if you're trying this yourself and this comes up empty it's probably because you haven't enabled the fm rest extended privilege so if you get to the screen and it's empty click this thing says my database is done in this list and then we tell you here's just a screenshot of what it looks like to go to the fm rest thing and add it to your privilege set once you do that that will probably fix it and then when
you choose this you'll see your database here and i had previously talked about oh no i hadn't talked about the screen i forgot this screen ordinarily mirrorsync doesn't even show us the screen because all of these steps are already done in filemaker starting point enterprise edition i've deleted all the stuff so this screen is popping up once we've done all this the screen will get skipped if we were to edit this configuration but let's go ahead and do the stuff outlined in here step one copy the mirrorsync table from the mirrorsync support database into this database when you download merosync from the store from from 360 works there will be a filemaker database included in it and at the root level of that download will be filed called mirrorsyncsupport. fmp12 uh and that's what it's referring to when it's saying copy and paste that so i have my own copy of that database and i will open that up and work from that so here's
the mirrorsync support database this is included with your download and so copy the mirror sync table from the nursing support database into the database so i'm going to manage databases i'm going to go to my meresec table and copy it now i'm going to come over to starting point or and you would go to your database here and you would paste that so that's step one done oh i remember what i wanted to mention that i kind of got on a tangent before you'll notice that i'm a laptop i am not actually screen sharing to the server um and so this mirror sync admin utility can does not have you do not have to rdp into the server where it's running you can download it uh when after the installation in your browser it'll pop up with a button to download this config client you can download it to your own computer on either windows or mac and then you can run this and you
can do all the configuration on your own computer instead of having to rdp into the server so uh you'll see that a green check mark popped up here because i copied and pasted that so when we're done we'll have green check marks down next to all these steps so step two copy the mirror sync six folder from the support database paste it into your database file and then we'll do this tomorrow probably if you're creating an additional configuration for a database that already has mirror sync 6 configured you don't need to copy and paste it you can just duplicate the mirror sync 6 script inside the folder and then rename it so i'm going to go to my support database go to my script workspace get my folder copy that come back in the starting point paste it okay so that's done and when i jump back to here i should get um oh and then i need to rename the script rename the mirror
sync 6 6 script to mirror 6 fmsp we made that field editable so you can copy and paste it so you don't make a typo when you're renaming it so you go to the mirror 6. 6 script rename paste that and now when i go back to mirror sync i get my green check mark here um the next thing we get this exclamation point you can always anytime you see these you can put your mouse over it and it'll tell you what's wrong sync url does not match the expected value please copy and paste the value exactly so in your database edit the emergency six script near the top of the script find this script step set variable mirror sync url equal to blah blah blah copy that url copy this url and paste it in to that spot so that's line six on the script right here set variable nursing url so i'm just going to change this and save my change so now i got my
green check mark there step four copy the mirror sync layout from the nursing support database go to the existing mirror single app and that's an important part go to the existing miracle app do not create a new layout because when we pasted the mirror sync table filemaker automatically created a layout for us so we want to use that existing light that already exists delete everything on it including the header and the footer and then paste you do not have to repeat this step later if you change the sync configuration so let's go to our mirror sync layout go to layout mode it will select all copy actually out jump over starting point now i will just say something here uh in in flight here uh we've been doing a lot of add-on modules and so at some point i think this process would be a lot simpler when jesse did an add-on module for this but um it's still kind of semi beta issue even though my
engineers are starting to kind of get a handle on it um it just makes things easier but in this case you'd still probably do some hand stroking of the code etc to make sure it really worked yeah i'm excited about that add-on module thing and i have tried it and it's time yeah yeah well it works really great with things that are not nearly as sophisticated as mirror sync i mean mirror sync is literally like the warped reactor on a starship it's like okay yeah there's a lot to it there's a lot to put it mildly yeah yeah yeah the script is is kind of funny if you want to read through 49 pages of filemaker script and the script is actually the tip of the iceberg most of the of the code is living on the the mirror application that you install on the server so we've done that and now we've got our check mark so we've completed the four steps okay so if we
have a we do have a question from david david asked the question i kind of replied to it but i'm gonna i'm gonna just give you this question you can respond to it david says being machines and server same land that's why i guess he's saying there on the same one pointing to the external mirror sync ip impact on performance question mark um so the external ip would be primarily relevant for mean okay so the performance impact that's entirely based on your router the router is what your does your network address translation i don't think you'll notice it um but it's that's just a hardware thing in the router some routers to network address faster than others but i've never used a router that's so slow that i noticed the performance difference when using an internal versus external ip address what you may very well notice is what you will definitely notice is accessing it over a wide area network versus a local area network
you know if you have two servers in the same physical office or the same amazon subnet they will sync a lot faster than our example that we're doing which is from the west coast california to ireland or mumbai or sydney or the east coast yeah um but uh so he is he so he's talking about a network address translation on the same network is what he's talking about i guess okay so that there's a feature that you want to look for in your router and the feature is called hairpin nat um and uh hairpin that uh it's so cold because in a hairpin turn you basically make a quick 180 degree turn yeah um it's funny i'm making these hand gestures while i'm talking and i'm realizing nobody can see my hand yet yeah i'm sorry about oh i can help you with that so i'll make some handshakes do some hand gestures for me richard okay here we go stand by we're getting ready not
the hand gestures you would normally use exactly do a do a hairpin curve in and and gesture uh and uh so the idea there is in in in routers that support hairpin mat they will take an external ip address and instantly convert it back to an internal address so that from inside the network you can use either an internal or an external ip address if your router does not support hairpin nat then external addresses either will not work or they will work but they will be very slow and maybe that is what the question is about is maybe you've noticed that that's very slow if you have noticed that that's very slow then either just use the internal address when you're inside the network and then it's not a problem or look at a different router that supports that hairpin that feature and then that should fix it okay yeah perfect yeah i misunderstood we were talking about network network address translation on the same
network as opposed to because as soon as we start connecting i mean i misunderstood the question if you if you understand if we go back to do this i'm going to move to this original diagram so you're not on the screen at the moment jesse so we go back over this video real quick that i did initially where we were talking about uh the idea of that you have all these i can move this other way but all these servers that are running here right everything is remote everything is remote but you could for the and jesse to cover this day one you could put all these uh servers in the same data center yeah and that they just become this like replication backup kind of action that's going on and you could they could you know and so if one dies so the whole thing is running fast but they're in one data center in our diagram i have fewer people freaking out about oh it's
offline for 30 minutes while we restart it i have bigger problems with people saying this crap is too slow because i'm in hong kong and it's in the databases in washington it just takes too long and so uh that's why we kind of rigged this demo the way it is because this is the more these are the complaints i hear about i don't hear so much about because really filemaker server generally is pretty reliable um if you get it set up and it's running well it won't even crash even once a year um when you start having some sort of bug you run into then you could have a problem you know once a week or something which would be a real bummer but uh yeah so anyway that was understanding where the server lives relative to each other i think is part of this question for those of you who are more basic understanding this this we're talking about servers together loving each other on the same
rack in the same server uh closet or spread across the globe literally so that's kind of the uh conversation so uh gloss through these these optional steps here okay hang on i'm bringing you back you're back on so you've got this mirror sync script now uh which we pasted into starting point and here it is you know mirror sync 6 fmsp for a server to server sync you never need to call that script mirror sync will call it for you but if this was a client to server sync you might want to put a button on a layout somewhere that says sync and you would just attach it to this script mirror sync 6 fmsp and then you tell your users click that button whenever you want to sync they could come to here and click this button but it would probably be more convenient for them if you put it on you know one of their one of their layouts um you know like you might
want to stick a sync button uh on this it's coming yeah yeah so you might want to stick a sync layout on this button or maybe on your dashboard would be a good spot you know maybe stick a sync button here but yeah just make sure that your button calls this script mirror sync 6 and then whatever the name of the configuration is another optional step if you want mirror sync 6 to automatically run a sync the very first time the file is open not every time the file is open but if you just want to make it so that the very first time they open the file it will sync it before they do anything you can have your startup script called the mirror 6 on first open that will check and see if the file's been synced before or not if it hasn't it'll immediately kick in and sync and then uh final thing which we talked about yesterday if you want to limit the records
that so by default mirrorsync is going to sync every record sometimes that's appropriate sometimes it's not if you would like to filter it which i would recommend if you have a large number of users and a large number of records if you want to filter it then take a look at the lower section of that mirror sync 6 script and just to in case people will called yesterday or forgot where it is uh this is the mirror 666 script you scroll down and here's where you get to this customization instructions so just follow these different directions here for limiting which records get synced during the during the script or get synced yes get synced you're good you're good i'm just gonna i'm just zooming in and out here as you kind of motor around because it's kind of hard to read this sometimes on a stream okay so now it's telling you to create the sync layouts this is the part that i was telling we
kind of cheated we already added those that is all of these blank layouts here uh so all of these layouts is this is the part that we would normally do at this part in the process like as like you saw they're very boring layouts they're they're they can be blank they just have to be associated with the right table occurrence the one time you would definitely want to add fields to these layouts is if you wanted to only sync certain fields if you want to sync all the fields which is probably what you want for a server to server replication leave them blank but if you're if you're doing a client to server sync and you want to trim down version of it that only syncs you know 10 out of your 30 fields then put those 10 fields on the sync layout and on a future screen you can select an option to only sync those fields that's a good one all right good so now we get
to the spoke database the spoke database is going to be filemaker server it could be any of these and you'll notice that dynamodb is in this list dynamodb is a really fun cool high performance database that we talked about on a previous day and it it makes a really cool way to create a high volume web-based version of your filemaker database of course mysql my ms sql server oracle are all very good at that as well so in this case we're seeing a filemaker server i'm going to set it up with our ireland server previous days we've been syncing with four servers today just to make the demo go faster because we're already at 45 minutes past the hour i'm only going to sync with two servers um so our database server is 1701 c i think it's ireland and yeah i still have uh i'm gonna i'm gonna get my clipboard again so i'm gonna oh he's gonna go with my screen sharing okay there
you go he's left uh initiate uh random i know joe martin is on this call right now going why doesn't he get a clipboard manager because he's told me so many times you get a clipboard yeah my guys do that too the problem is when you're busy being the boss sometimes all the little niceties go by the wayside i really should have a clipboard manager i'm just lazy i'm too lazy to be efficient too lazy to be efficient that's great right [Laughter] so i've configured all the same options except for my spoke server if i was doing multiple spokes if i wanted to do like the four servers or five servers like we were doing it here this is the screen where i would do that i'm not going to do it now but i would click add another spoke and then i would put the address in of each additional table selection uh i talked about this yesterday so i'm going to skim over pretty
quickly i'm going to pick the option to sync anything that starts with the word sync and now it's checking all those tables to make sure that they're all valid yeah yeah hang on let's ask the question here is a layout needed for each table or each to it's just it's it's a table right not the tv so each it's for each base table base table that's that word that is inconsistently used in the platform and she knows this for the last billion years it's been that way yes base table base table yes so then an email administrator uh an administrator email address is required for any server service syncs we already talked about this we already talked about advanced notifications um i think we've covered everything on this screen um and so i'm going to just get past it well we haven't we haven't just dealt with the conflicts yet like if we both edit alexi at the same time let's let's do that
when we i'm going to leave these changes these settings as they were but when we get to our our live demo let's do a conflict and see how it works yeah i'd love to know how it works so uh we we discussed this so i won't go into more detail i'll just change this to any time so that we can do a server server update whenever we want and that is the entire configuration so with a whole lot of talking and explanation involved i think that took 10 minutes 15 minutes we cheated a tiny bit because we already had our sync layout set up that maybe that would have added another 10 minutes to the process yeah my point is that this is not a laborious you know week-long process to set this up you should be able to add this to your own solution fairly quickly in fact we do a thing at devcon where we tell people we're not going to do it this year because there
is no doubt comes here but in previous devcons we've actually asked people to bring their solution with them like on a flash drive or a network share and we'll actually customize you'll we'll set up nursing for you on your solution like between sessions free of charge at devcon yeah so which is always awesome because then they have to buy it if they want it to work very long there actually is a free version of mirrorsync that does work so mirrorsync for free will support uh one offline uh client device syncing to server so you can everybody in this call who would like to is welcome to download nursing for free install it on your filemaker server run through the process that i just showed you and then at the end of that process you'll be able to download a copy to filemaker pro or go and do a full sync all right so i've got it so you're not on the screen anymore i've now gone
to your website on my screen and we're looking for mirsync for free because i know people love free nothing like the smell of free software in the morning so how do we find this uh so click the buy slash upgrade button on the mirrorsing page buy upgrade there we go i'm going to press that and then new to mirror sync get licensed i got three options here so uh go to the one that's i'm going to do it myself because i don't recall offhand what the buttons choices are okay oh i can switch to your screen then that's fine i don't have to but we just uh there we go all right go ahead you may proceed okay that's okay stop okay stop that is not what i how did you get to that go back okay oh sorry pricing by upgrade okay i think you hit the left one yeah the left one okay because mine did not look like right here i'm like okay and then just if
you want the free version don't do anything on this page it will come with one configuration for free and it'll come with one device for free zero dollars and you just proceed to checkout where this where you would pay any money is if you want more than one device so if you had five devices you would add device and you would say i want four devices total of five because the first one's free and they're eighty dollars each for that quantity and then that's three hundred and twenty dollars for five devices is that is that an annual or is that one time or what does that work that's a one-time fee uh and then we have an optional maintenance plan at the end of the year you can renew that maintenance for 25 of the purchase price each year i highly recommend that everyone i mean i do too because it you know sometimes people report a bug and will say oh that's fixed in the most recent
version and their maintenance plan has last and then they need to go buy the maintenance plan to get that bug fixed okay can i can i make another suggestion or a question here so yeah if i was rolling out like this big servery enterprise thing and i was actually the guy really technical but you're going through this unless i had a written checklist i could botch it and so is there a plan where we can like buy the product and then like buy 10 hours of jesse not your time but your team's like we get joe martin to help us absolutely and it's probably more like in the three to five hour range for most solutions just okay okay so three to five hours and so we could add that to the thing that would be awesome so for those of you who are doing really lightweight and you want to play with this or you're uh you know independently brilliant like alexi and some of the folks
here then you don't need that but someone like me if i'm in front of a customer and i don't want to look like a fool they're like how come it doesn't work yet oh because i've been trying so uh might want to get a couple uh coaching hours uh 360 coaching there you go right on so yeah thank you and and uh thanks for bringing that up i always forget to mention that yeah and uh so what we're doing today is the server server version and the server server version you would add instead of adding devices you would add configurations so you would add a configuration and you would pick filemaker server to filemaker server all of our choices are on here you know you can see here's all the non-filemaker server choices and the pricing is right here so it's 1600 for filemaker server server it would be 1800 for a non-filemaker server to non-filemaker server and that's the same in either direction so that's 1800.
um and and then if you want an additional configuration for a server to go like if you had a second solution that's an additional 200 if you had you know two different solutions you wanted to sync instead of one it would be an extra two hundred dollars for that okay uh so that's where you would do the server to server purchase and we do do 30 day free trials of server servers so if anybody wants to give it a shot and i i actually recommend that you don't buy it up front um i i would recommend doing a 30-day trial for your benefit and ours because refunds are much bigger than just making sure that it works right for free and then you buy it but i mean yeah absolutely and then once again make sure you get the mains alexi just said yeah don't be an idiot buy part two or part two by the by the maintenance right by definitely the maintenance and and and
unless you're just like the super ninja level person um get a little and i'd buy the the assistance with it because then you know it's gonna rock and kick ass and here's a more here's even a more important thing if there's a problem like joe martin is your coach there and he has a problem and there's some sort of bug guess what it'll be pretty much automatically elevated to top level and it'll get fixed right that's yeah we're we we're i would take a lot of pride in how responsive we are to tech support tickets i think i've talked to a lot of people that are on this channel and i think uh most of you have uh have worked with us and so yeah we're we're very responsive to issues that come up yeah i mean if people want to know like why do i like do why do i talk to jesse why do i do jesse and the reason we do jesse is not because
jesse's perfect far from it right uh the but the issue is that when we point out a bug to him right it's like uh and he like goes really and i go and it's like a warp drive and it's like kind of personally yeah it's like oh i gotta get that fixed right away and so it's not that there's not a bug it just means that you know that the the guy who really cares about it is gonna fix it and it's him or his team because it's not just jesse as one guy i mean you got what 15 12 15 people there whatever yeah yeah so yeah all right well there it is so here's what i'm going to do now so i've finished the configuration and i'm ready to sync and uh so i've got the admin console for ireland that's 1701c open here in the background if i if i look at california california's got the database open and hosted ireland does not have that data
but it has mirror sync installed on it and because it has mirror sync installed on it that'll enables us to do a server server transfer of the file so that's what i'm going to do right now i'm going to click the sync now button and before i click it i i want well i'll click it and then i'll talk through it so i'm going to click sync now and we're going to establish a database connection and you'll see it creating database copy for spoke preparing to move database over network from hub to spoke to this spokes1701c so it's pausing the database it's compressing it it's uploading it we can see our progress we can actually see the database pop up in the admin console here before long we're going to see this change to blue as filemaker server hosts it or as mirrorsig hosts it for us and then the sync will actually start to run so now it's blue that file's hosted and then before
long the sync will actually start to kick in and run like a normal sync so here's what it's there there we go settings database we'll kind of do this i mean doesn't this have to be on for the automatic thingy to go or no that's if you want to sync automatically every so often what i did is i just clicked the sync now button okay so it's so it did it up sync is what it did yes okay yes and it won't actually um we recently made a change steve winter actually reported an issue where it kind of creates a problem if you have this auto sync enabled we won't copy the database over in that case because what steve was running into is he was taking his databases down on the spoke for maintenance but he had his auto sync set to run every few seconds so every time he took his database down for maintenance we would push a new version to his server so we'll only
push the version of the server when you manually click the sync now button not when it's just okay that's the that's one of those moments where they say the road to hell is paid with good intentions and you end up in sync hell and it's like why did i take these offline and why is it coming behind me and and loading them and putting them back in that's a that's a fun one that's that's a fun one i like that all right cool that entire time was 60 seconds 62 seconds to copy that file over to ireland host it sync it run it and now everything after this point is just incremental syncs so if i click sync now it should be just a few seconds to see that nothing has changed and so yeah this is fairly typical for transatlantic sync with this many tables is about four seconds um i'll set this to every five seconds i'll turn on the auto sync and within a few
seconds that'll kick in it'll start running every five seconds so now we are where we were yesterday and the day before i just wanted to show everybody the entire process from ground you know from from the ground floor from step one so that you would know how to do it with your own solution and so this is how you would get it running with your own solution cool cool cool questions from people question question questions make sure you ask let's get to you mention richard you brought a conflict resolution let's why don't we do a conflict right now so we can see how that works yeah like conflict how would we do that so why don't you go on your filemaker and i'll go on my filemaker okay so i'll be uh i'm gonna i'm gonna go to ireland yeah because i'm not even really sure how we'd go locally here so let me try that let me uh i'm in this i'm going to disconnect from cloud
you're going to be 1701a i'm going to be 1701c okay stand by all right and then we're going to find alexie can we promote her maybe she could be a vp at apple that would be nice that would be a nice jump for her let's see let's see see if like which department was she not even in here she wasn't here oh you know she's not in this database because you use the wrong database yeah yeah yeah yeah i went back to our kind of uh it's been de-elected all right so what do you want to do just edit you oh you're the record five what do you want sure i'm still opening mine i'm slow because i'm going from georgia to ireland directly from his connections all right well you you call it so if you're looking on my screen right now we see yours in mind both yeah yeah so you can see that this is ireland so i'm going to go to contacts all
right this is why we need this geographic distribution is so important you're seeing how bad it is to connect to a service far away and this is a this is a super fuel efficient database i mean big time right almost no calcs nothing so at least change my title i'm sure you'll come up with something creative and i will change the website address okay so not quite the record yet i've locked it's locked right now okay okay so uh go ahead and commit one two three commit this committed and now i'm gonna jump over here and so an update happened so let's uh jump back uh i didn't pick up uh the title for me did it did it get oh you know what it's because uh i know why and i'll explain in just a minute let's let's make one more change uh why don't you change my department and i will change my email address uh let's see department of uh i guess we
could call it this person no one no don't commit yeah i'm not committed i got rocked although i've misspelled it you know there we go all right widow okay and now go ahead and commit it done the console the reason that the that it didn't work the first time we did it is because miracen can't merge changes on something a sales weasel sorry you need something creative mirrorsync can't merge changes on a record that it's never seen before because we've never changed this record or inserted it since we just set this up with mirrorsync for the first time mirrorsync has never seen this record before so it's not able to merge that change but now let's create a new record okay um richard why don't you go ahead and create a new record and fill in whatever you want and then i'll let you know what pops up from all right hang on here i'm trying to there we go oh craig got joe going here
and the uh there we go so we go got that so i just got his title and this name is that all i need is that good for now yep you know i'm going to turn off the auto sync just so that we don't have to time it perfectly that i can just go and click the sync now button and we don't have to worry about okay so i did the joe martin and it did commit so it should show up yeah he's um and so you've got you've done that i'm going to go now i don't see it yet and the reason is because i'm looking at ireland and we turned off our auto sync okay so i'm going to come back in and i'm going to sync now run manual and that should show up for me manually yes yeah there we go so i can see one insertion here and there's joe's record there and so uh now mirrorsync knows about this record because mirrorsync is what
put it here so now all of our field level merging will work so i'm going to um i'll change uh joe's uh website and you change his title okay title we're going to make him a vp of snacks okay let me know what i'm scarily accurate joe well we hung out at devcon a bunch of my folks were snack people i think he was too okay so i haven't run the sync yet i've changed the website address and you've changed the title correct now i'm going to run the sync and what i'm expecting to happen when i run this is that it won't say this one updated or that one updated it'll say both updated so let's run the sync and see what happens here okay and that's that's what we got so i can see your change and you can you see mine yep looks good beautiful yeah and uh and what this status is showing us right here is that we did an update to
both the hub and the spoke because we we rewrote that changed record to both so what you're seeing now is mirror sync's ability to merge changes to different fields in the same record which is the next question which solves most of the problems out there where we're going to give joe the vp or we both change his phone number on the same day or something right or whatever let's do it so you change now this is going to be in a certain order so you change his phone number first okay five five five one two one two okay and then you'll make commit yes commit all right and then i will now change his phone number oh wait a few seconds because this is where the clock is important because our default conflict resolution strategy is the most recent change wins so i'm going to put that in there i'm going to wait to commit just to make sure that the clocks are off by a few seconds
mine is the one that's made last it doesn't matter which one syncs last it matters which one is actually modified last so i've made that change and now i'm going to run the sync oh it did you just blew my phone number out okay now let's do something else this time i want to change it first and then you change it so let's pick uh let's pick category okay i'm gonna uh i'm gonna pick hot prospect okay and then why don't you wait at least 10 seconds and then change it to something else it goes from the time i commit right not when i start editing right so yeah so i can go in here and edit uh of course it didn't let me put that in there right and commit now okay now i'm gonna sync again and i'm expecting your change to take precedence um and i think that these servers are probably all in utc time yep and that changed for me it went to
engineering yeah i think that these change servers are all in utc time but even if they like if the ireland server was in ireland time and the california server was in california time then it wouldn't matter mirrorsync takes that time zone difference into account when calculating which which record was modified more recently and so let me bring up remember i said i was going to talk about that host modification timestamp way at the beginning of our call yep now's the time to talk about that because i am behind the ireland server the ireland server is four hours ahead of my time zone so if we were just so if we were just using a regular modification timestamp and let's pretend the ireland server was in ireland time like i said i think amazon sets everything to utc time by default but just for the sake of the example let's pretend that it's in ireland time so if i were to make my change right now um
i would see that the mod the modification timestamp for the change that i just made would be 505 pm because filemaker is dumb about time zones filemaker doesn't care or know about time zones it's just like hey the change minute's made at 505. you're like well 505 where and filemaker is like what do you mean where it's 505. so when mirror sync goes mirrorsync is going to say hey ireland server i see that it's nine o'clock your time and i just synced with you 10 minutes ago at 8 50 p. m show me all your changes since 8 50 p. m and then filemaker will say i've got nothing i've got this one from somebody changed it at 555 but uh that was hours ago so then mirrorsync is going to miss that change so you're saying that we we need to use the modification timestamp from the host and um and ideally the hosts are synced together right with the host amazon syncs the all the
hosts all these servers using gmt or zulu time right yeah so um but what if you have servers that you're your own server like uh david uh angle decides he's gonna have his company set up five servers and they hate amazon they're rolling their own boxes so yeah and what what matters is whether or not the user who's making the change is or is not in the same time zone as the filemaker servers timezone so if the filemaker server time zone was in california and you make the change there everything is cool whether it's on amazon or not um but if uh if the server is in atlanta and then you make a change then if you're not using that host modification timestamp that change will get skipped all right uh okay well i do have a question here from alexis so questions are now coming in fast and for you so we just cracked yeah i've pretty much gotten to the end of my demos
well yeah and we got time it's not a crisis yet so uh alexi says how are fields with quote unique quote validation handled if a change to one record on one server makes it non-unique with a record on the other server makes it non-unique i think they would have been but the but the the comparison data um she's saying that the comparison on one side passes the validation but when you push it the other side it doesn't pass anymore that's a really interesting education okay um oh so okay um yeah so mirrorsync is pretty smart about validation failures and record locking failures and things like that if you have a failure due to a validation whether it's like a 504 val unique validation or 507 or 509 validation mirrorsync if it's a 505 if it's a 504 unique validation and it's on the primary key that's a special case where basically it seems like we're trying to create a duplicate record and mirrorsync will change that
from an insert operation to an update operation and update the record instead of creating a duplicate record if the unique validation is not on the primary key uh if it's on some other field like maybe it's a foreign key if you want to enforce a one-to-one join relationship then mirrorsync will catch that error and it will report it back as a warning and if you and the in the remember how in that uh email administrator screen there's a pull down menu to select what kind of emails you get i would recommend getting errors and warnings because it will then email the administrator and let the administrator know that record could not be synced mirrorsync will not retry that again unless the record is changed again because it's not going to like magically somehow work the next time we try it what about a lock sync uh if you say it's you add it but then i go back and edit a second time and you try to
sync and i'm jammed up yeah joe martin's thing is it going to try that again does that come back let's let's try it yeah that's like after that right now i can see that being pretty common so i'm going to go into joe martin's record okay i'm going to change his status to active uh and i'm going to set an address for him okay but i am not going to commit the record now you make a change to joe's record and do a commit and do a commit yes okay and edit and commit all right done done okay so i'm going to sync now and what i'm expecting to see is a warning here that we couldn't write the record because it's locked and in use and here's what we get no changes were synced update operation for primary key blah blah blah could not be written because of an error 301 record is in use by another user this operation will be retried on the next sync
so i can keep clicking sync now as many times and mirrorsync is smart enough to know the difference between a record lock thing which it will eventually get versus a validation thing which it won't eventually get so no matter how many times i sync it's going to keep trying and after this next one what i'll do is i'll go ahead and commit the record and then i'll do it oops i didn't get a button that's fine yeah i must have clicked a it yeah that's fine i'll jump back to joe martin now around the sink and now what should happen is it should be treated as a conflict because we've both modified the same record and it should be resolved and written there we go it's been written to both and it merged those changes from yours in mind yeah you got the uh change right there um so there was a i'm just gonna check here for questions so uh there's two questions here i'm gonna do with
mr scott's first uh any special caveats for auto intercalax or lookups in terms of this conversation so there there we do special handling on them but you shouldn't need to worry about it mirrorsync can detect which fields have auto enters and which ones don't and it orders the sync to make sure that the auto enters happen uh after the other fields so let's say for instance that you had a foreign key field so nursing will always sync foreign keys and then regular fields and then auto enter fields and then calculations and the reason is because when you set a foreign key that could very well trigger some field to a default value we want to make sure that we write that default value after the foreign key has run if we set the default if we set the custom value and then set the foreign key that would re-trigger the lookup and overwrite your custom value um and it's the same thing for auto-entered calculations um
we make sure that uh the the record gets written the the order that we write the fields in we want to write that auto entered calc last so that if like if you have a field a and field b and c is equal to a plus b we want to first write a and let's say it's a one and then we'll write b and that's a two now c will get auto entered to three but if you customize it to five then we make sure that we write that field last so that it ends up with a five in it not a three in it okay and then along these lines alexi goes yes for instance you're using an old school auto inner serial number which is how how you and i argued about this for years before this actually happens so so uh so auto so if you're using serial numbers as so there's two ways to use serial numbers there's using them as a primary key
and then there's using them as a user visible number uh you know work order number invoice number check number purchase order number whatever you have and this could get long so i'm going to try to give the short answer to this as far as a primary key mirror sync just does it you just pick the mirror sync managed option and it just magically works the only thing to be aware of is that the ids will be different on both databases so hopefully you're not using your primary key serial number as double duty as a work order number because that'll be really confusing when the work order numbers don't match the same numbers on the two different devices what i would recommend in that case is having a separate primary key and then a separate work order number and then everything is good and fine yeah and i'm just going to jump in so that's what caused all these problems with starting point because part of the
starting point was designed to be simple and a training solution so we would use the primary as very simple primary key here cancel that um and over and it would be visible and the primary key at the same time right and so so the enterprise version is the one where we've taken the primary key it's a uuid and then we made this user visible field if you if you if you mix and match the primary key and the user visible field and you're doing uh mir sync together um what ends up happening is that you end up having you could have two invoices with the same number that could be very a very likely outcome um and you are being summoned by someone very seriously you're in high demand yeah i'm turning on my do not disturb here okay i actually have my do not disturb on but apparently certain people still ring through so um i the reason i'm going into here i want to change
this to manual setup and i want to show you a screen that we've been skipping over in our configuration um which is where you tell uh mirrorsync about your primary keys your foreign keys your modification time stamps and and importantly right backs right backs are uh i feel like i shouldn't uh i feel like i'll wind up spending 10 minutes and going way over time if i go too deep into right backs but the concept behind writebacks is that if you have like a serial number field that you want to be your work order number or purchase order number set that put that in your right back column and then what that will do is it will it will make it so that once that record is synced to the hub mirrorsync will take the value from the hub for that check number or work order purchase order number and write it back to the spoke so that after that record is synced for the first time
the spoke will then match the value that got created on the hub uh and explaining exactly how that work would probably take a little too long well that's fine we have other questions here um here's here's what i wanted to show you this write back value so all these things notice that jonathan created those all these are like id note display id contact display id document display so these are serial numbers that are then visible so that you can say oh it's contact number one two three four five you pick that as a right back value and then mirror neurosync will allow the hub to assign the next number and it will write that back to the spoke so that once they're synced they'll match um all right so the the next questions are kind of somewhat well joe was kind of jumping in here but i'm going to let you a tee off on both of these so um from fm forums which i think
is dielinsky he says what happens when the schema locking uh with with schema locking and a sync takes place i mean i i think that and then also then the next question from swear swear bar swearing i don't know people i could try to append their names into a call sign i can't pronounce it will security accounts also be synced so i think this gets back to the idea that you make a structural change and it just pushes the whole file up so if you want to recover that again so uh first question on the schema change if you're making a schema change and mirror sync tries to write to that record and it's not able to because it's in you can actually update records while the schema is being modified you cannot insert records while the scheme is being modified so if mirror sync gets a change from the hub and it tries to insert it into the i'm sorry if mercy gets a change from
the spoke and it tries to insert it into the hub and the scheme is being modified mirror sequel treat that just like the record is locked if you're editing it and it'll just keep trying and trying and trying and eventually it'll get through so there's no problem with modifying schema mirrors will catch that and retry on the second question mirrorsync does not cannot sync accounts there is no way there is no facility in filemaker that i'm aware of to programmatically sync accounts without using a separate tool like the data migration tool or something there's no way within filemaker to do that um and so we're not able to sync yet uh things like layout changes script changes account changes value list entries uh you know anything that is modifying the structure of the database however i will try to demo tomorrow if i can find time uh possibly even friday i will try to demo uh a really cool feature that mirrorsync has where rather
than syncing those changes because we can't incrementally sync them because we can't modify the spoke file we do have a very convenient way to just to simply replace the spoke database with a new copy from the hub yeah and so that's how you would accomplish something it's kind of a for a brute force method but it's so simply implemented and i think either should this on monday a little bit or something but um going through it again is really important but it's it's kind of a brute force method but it's implemented so simply that it's like easy um i will ask the question though because claris has got this new serialized xml it's their new beta version of i don't is is a account information in that serialized xml probably not passwords but yeah the password would not be in there yeah but what about the account minus the password i don't yeah i don't know um i've looked at the ddr quite a bit
and i think that the ddr does have i think the ddr has the accounts i'm not positive about that and i have not studied the new xml format well enough to know the image yeah and the thing is it's not documented yes uh dolinsky says uh accounts are but he left the uh so like one of those implied pronouns but i don't know uh which pronoun it is our demand are present in the xml on the well on the new xml as opposed to the old ddr xml because remember there's two xmls here there's the old one that base elements that we've had for a long time that base elements will read for example um and we have by the way we have nikkor coming next week for those of you want to talk about base elements we have him one day on the uh his base product and then one day on his free plug-in so we have two two acts of nikkor but we have 5x of
of jessie so we're very happy with that um so yeah so it's a good question where that's at so so tomorrow i'd love to just quickly demonstrate the kind of schema modification feature um i'd like to show how mirrorsync could automatically detect new layouts and tables and and then we'll just open it up maybe to just everybody start to log in and make their own changes do we want to make a launcher for them i guess we should make a launcher distribute that right yeah we'll need to make sure the firewalls are open and uh well i don't think we need a launcher because you know i mean it's the whole point of this with the dynamic dns is that it should just be a matter of adding a single dns entry to your host and then having it pop up right but i mean some of the people here don't know how to do that so i'm trying to i'm trying to say i'm trying to get
them my launcher to your your that initial location right okay yeah and we need to walk through that a little bit because it's not clear to me how you jury rigged that right because okay yeah because we go to your server we open this file and it does this magical in-flight redirect that i it was like i don't even know what you did it was like amazing so i'm sure it's like magical i'd love to show it off yeah it was a lot of work okay well i mean nothing take a victory lap and i listen i have no way problem with you telling everyone how brilliant you are uh because i'm fine with that i like i said if i'm the smartest guy in the room we are all screwed so i want to be the person in here learning by the way delinsky just says that uh on the new i'm assuming new x yeah new xml he says there's a strength meter of the
password hash indicating how strong the password is so you can't tell what the password is but you can tell based on the length of the hash i guess um how strong it is so it'd be like a kind of indicator that you suck as a password person or you're you provided a really good cryptic password so the hash itself is the hash itself in there i doubt it it's probably he says even the strength meter of the password hash so whatever a strength meter of password hash is so i'm guessing that's some sort of thing in there so yeah uh plenty of time on friday for questions well we have two more days right more questions but we're doing me in flight and probably delinsky is gonna be gone you know he'll give up on us because we're so boring uh cool cool cool cool thank you guys all right well cool so tomorrow is uh and bring you and your best friend's mother's dog's birthday party
to the party we want as many people log on from around the world so anyone from australia you know they love filemaker we're gonna have a launcher file at the beginning of the hour tomorrow and we're going to work on you know getting it out to everyone so you can log in we'll make changes and then as you make changes we'll be watching them flying across it'll be very cool so yeah great and then people are saying thank you jesse thank you thank you thank you a lot of thank you jesse for doing a great job and uh thank you guys for being on thanks for taking the time all right we'll catch you tomorrow one o'clock at fm training tv with jesse barnum and richard carlton all right thanks see you guys you bye 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 try 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 and throws it left ramadan reaches up and starts a high throw and lands inside the tent rolling with an eye slightly behind him but danny makes the ground
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
2122 9th St., Suite 102
Los Osos, CA 93402
(805) 946-6552
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
FileMaker 19 New Release - Top 10 Need To Know Items in FileMaker 19 - FileMaker Top Ten News
https://youtube.com/watch?v=kRDXfpMrjvM
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://www.youtube.com/user/FileMakerVideos
https://www.filemakervideos.com/
https://fmstartingpoint.com/downloadform3.php
Download FM Starting Point
https://filemakerfree.com/signup.html
FileMaker 17 manual For Novises kindle
https://rcconsulting.com/courses.html
https://www.guidetofilemaker.com/
Blogger sites
https://fmtrainingtv.blogspot.com/
WordPress sites