Jump to content

NateJames

Members
  • Content Count

    27
  • Joined

  • Last visited

Community Reputation

0 Neutral

About NateJames

  • Rank
    member

FileMaker Experience

  • Skill Level
    Novice

FileMaker Partner

  • Certification
    Not Certified
  1. 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.
  2. Developer tab in preferences should do the trick for you. Theres a couple options for things to do
  3. 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
  4. * Multiple spoke servers are not currently supported; will be added in a minor release
  5. 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
  6. Hey Sean, Does a server to server sync using XML have the customization script I mentioned?
  7. 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
  8. 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)
  9. 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.
  10. 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
  11. 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
  12. 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
  13. again, I haven't pasted anything yet, What tables are we talking about, is this the crazy ones that i mentioned earlier on ?
  14. so to finish the sync setup you need to not select "sync with a separate mobile file" but instead go through like a normal setup So than I click edit on the config engine and proceed to walk through to make the change to a separate mobile file when you hit next your are presented with this screen once you get past that and setup your relationships etc ( i left that alone but added my sql filter i was presented with this option to past the script steps into a file. but what file as i am given misleading information -- i am going to assume the iPad copy and i haven't pasted anything yet so why is it checked Green? when you hit next again this is the new screen
  15. ok so this is what i was saying happens on a clean configuration, same file duplicated, invoice and invoice line items removed including layouts all tables, scripts, and layouts of mirror sync have been removed before uploading to the server. After selecting "sync with different mobile file" this is the window i get. Interesting enough is that none of those items exist on my iPad configuration. I purposely deleted them earlier on and if you hit next to skip past that
×
×
  • Create New...

Important Information

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