Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About NateJames

  • Rank

FileMaker Experience

  • Skill Level

FileMaker Partner

  • Certification
    Not Certified
  1. Cool Beans, Thanks Jesse for fixing my issue with the filtering. Works like a charm now.
  2. Ok so how about an answer on this at least Where do we set the user token? Line 11 contradicts the check that happens within the customization that is set at line 174 (as per the comments on the lines of the script). Now using something like say FMStarting point I would like to set the user token at startup, I would think that checking my connection state would be the correct solution. But it would also appear that if you just follow the direction on line 11 and consider how many times that the script loops back and forth I will essential overwrite the value of the global if I set it there. the other point though is line 11 script steps are new this must correlate with using the filmmakers data api as this did not appear in version 5 in this way. So they must be important right? It's not like the rest of the sync script looks exactly like version 5 in the customization section. I mean filtering must still exist right? 🤷‍♂️ “if only we had up to date documentation"
  3. http://docs.360works.com/index.php/MirrorSync_6_advanced_topics Ok I am calling you out on this. Any progress on updating this page? In particular the customization section? What about $$MIRRORSYNC_USERTOKEN. There is some confusion regarding the comments. Don't set on server it would be bad, and yet one script step ignores the validation that was used to set it. How is customization really implemented. I have struggled with that and already have a case started and that’s a separate issue from this topic. Nate
  4. lo siento si esto sale mal, usando el traductor de google. Personalmente, creo que la mejor manera es tener una mesa separada para sus contenedores. esto hará que la sincronización sea más rápida si porque si un campo se actualiza en su registro, y si todos sus usuarios sin conexión sincronizan los mismos campos, también tienen que descargar todos los datos del contenedor. cree una nueva tabla y clave para hacer referencia a la relación. Al mantener una tabla separada, los usuarios solo descargan los datos del contenedor si se modifican los datos del contenedor. Dependiendo de su situación, esta estrategia también se puede utilizar para reutilizar la imagen en múltiples registros si es posible (estoy pensando como una tabla de productos donde una serie de partes se ven todas iguales) Esto podría ser diferente con mirrorsync 6, pero es la estrategia que se recomienda para la versión 5 y menos.
  5. Developer tab in preferences should do the trick for you. Theres a couple options for things to do
  6. Sorry Mark, just sharing a tidbit that I found when reading about the new version that would answer your question. I am just an enthusiast of MirrorSync and have been using it for about 4 years. Really excited about setting up version 6 in the office and playing with it
  7. * Multiple spoke servers are not currently supported; will be added in a minor release
  8. Thanks for the response, it was for my own curiosity as I currently do not use a server to server and was shooting from the hip so to speak. Cheers amigo PS waiting patiently for version 6
  9. Hey Sean, Does a server to server sync using XML have the customization script I mentioned?
  10. in my experience that would be a failure for you. It would halt and die miserably. I am not doing server to server syncs so not sure if what I am about to share help, but might point you in the right direction. I can’t imagine it being to different between the 2 types I would suggest creating a separate sync configuration that does not include the layouts that you do not need. However this approach would mean you need to manage 2 sync configurations and rollouts. OR Alternatively if you are using XML to sync, you can use the customization script to filter your results before sending to the spoke FILTER WHICH RECORDS WILL BE SYNCED -- about line 92 in the script is where you would start to read about it. If possible maybe preclude the filter of your layouts with an If [Get (SystemIPAddress)=“xxx.xxx.xxx.xxx”] I would then continue to setup a filter that returns zero results for that layout. Repeat for each server IP address you wish to exclude. Again apologizes if there is not a customization script with server to server sync’s but wanted to share something with you. Nate
  11. Hello 360Works, I am looking to refresh my current database into a new cleaner version. During this process I am looking to modify the primary keys so that I am not using user friendly serial numbers (example invoice ID's). To do this requires some work on my end, and I have consulted the advanced topic section regarding Mirror Sync Managed vs Developer managed. I imagine that developer managed keys are faster than MirrorSync managed. Is there any data to support my assumptions? It would also seem that there maybe other reasons that you would want to use developer managed over MirrorSync managed, for instance I am thinking that using multiple sync configurations might benefit on this setup. Can you elaborate more on this as I have not had much success with multiple sync configurations and have not adapted to using this in my solution. OR Is there a possibility that there is going to be a new version of MirrorSync that will use internal ID's (field and record's) and I shouldn't invest to much time into doing this (I am transitioning a file from FMSP 4.5 to FMSP 7)
  12. Caveat to that method that is not talked about very well... if you are using SQL filtering using say the MIRRORSYNC_USERTOKEN. The server file does not know what the MIRRORSYNC_USERTOKEN is example is I am filtering timesheets to only give the user there timesheets and no other. than my sql statement is where (id_staff = '{MIRRORSYNC_USERTOKEN}' ) but the initial sync on server will never know the token and well it doesn't work than. Fishtech, I have struggled half the morning with coming back to trying and setup multiple configurations for one file. I tried 3 configurations in my file and did not have the same tables in any of the configurations my 3rd sync was a one way with 2 tables (products and product images). I was able to do one initial 2 way sync, and than tried the one way product sync (initial). It failed miserably. I would suggest staying away from multiple configurations until MS tells us otherwise.
  13. I can answer the second part. During setup you provide a name for the second sync configuration, so mirror sync will append that sync name to the new sync scripts. So you will have to paste the additional scripts into your file as normal. In my testing it doesn't seem to matter which one you distribute for your download link, because your triggering 2 different sets of scripts. For your first question I have struggled and have had some good discussions and have multiple trial and errors to setup exactly what your looking to do. MirrorSync imho really needs to clarify having multiple sync configurations on one application. One technician says you can't have the same tables in each sync configuration, but in the advanced setup it says you can. I too want to set up exactly what your saying and my lack of understanding and having to infer what is going on has been painful. I can tell you that I tried to be clever and have my one way sync run at startup. And this is BAD (unless you create a skip on first run step to bypass this first initial one way sync). My one way sync was filtering the user data, and once completed the 2 way sync was no longer functional and would fail. (If you run the 2 way first which also has the same filters because its a "full" sync, than I have had no issues with running a one way sync (spoke --> host) later on). 😀One thing to share with you also, that I recently caught and makes sense. If you have large attachments and containers and those records get modified. Your users end up having to redownload the container. That might help your field guys if your solution uses a lot of containers, and for example you have a photo gallery full of cat photos and user manuals...Then you may be downloading them all the time
  14. Joshua, At one time I thought there was a caveat to the full sync configuration and partial sync configurations setup that's referenced below. They way I understood it was that this would work, but its false to call it a 'full sync'. That your full sync could not contain the tables that your partial sync was using. Or is the trick that the full sync has to be both directions and the partial sync has to be one way only. I have wanted to implement this feature but during initial setups it didn't work well for me so just left it alone and stayed with a full sync. Thanks Nate
  15. I have considered it, and tested that option. It takes 10 minutes do to the products and image files associated with the database. But because MirrorSync is so awesome, i have been testing the setup with a pre - populated and different mobile file. By different file I mean a clone of the original, and than i deleted all the tables i do not want the user to have (i.e. invoices). I left everything else within the database, and than setup a synch relationship using the separate mobile file option (Please see the other topic, and problems I had setting that up). But i can report that it does work nicely and I do not get any gaps in the serial numbers on the office version anymore quite simply because we dont sync it. The other tables can elevate the serial numbers as it is not critical for an accounting auditing purpose. In the future I will definitely follow Tim and your advice and solution
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.