Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


fishtech last won the day on May 27 2016

fishtech had the most liked content!

Community Reputation

1 Neutral

About fishtech

  • Rank
  1. Unexpected deletions

    Hi, Sorry to bug you but just wondering if I can restart sync safely? Thanks, ft.
  2. Unexpected deletions

    Thanks - I submitted the log file earlier today. Do you think I am OK to restart MirrorSync (with the recovered database) at this point? Thanks, ft.
  3. Unexpected deletions

    Hi, One of my users synced this morning and the sync for some reason removed 20,000 records that should not have been deleted. I'm sure is a HUMAN PROBLEM - NOT MIRRORSYNC. This is a very remote user who uses the system rarely. I am trying to stop the bleeding before looking for the cause, but I am going to guess he did something like sync an archived, very old version of our solution. I've been able to recover the database from backup. I have disabled syncing for now. The 'problem user' will not sync again. Is there something I should now do to repair the data to bring the recovered/restored database in line with MirrorSync? Is now the time to use either 'Repair SyncData' or 'Reset Sync Data'? Many thanks, ft.
  4. great, thanks... that's what i needed to know. ft.
  5. Lee, Please stop nagging me. It's not my fault that there was a loss of information at the site. Am I breaking terms of service or any other forum rules by not updating the info that was lost? ft..
  6. Hi, Using Mirrorsync 3. A new field is needed. It will be created on the server and added to the appropriate sync layout, new Mirrorsync script will be created, etc. There will be a lag time - a couple weeks - while existing users continue to use - and sync - their un-modified remote databases before they can download a new copy from the server. It's been a while since I made such a change... please remind me... how does this change manifest for those users who have not yet got the updated version while they continue to sync with older databases? Do they see an error on each sync saying the new field is unavailable? Just trying to manage user expectations :) Thanks, ft.
  7. Allocation of RAM

    I noticed that the server you used to do benchmarking had 60GB of RAM. Did you need to do anything to FileMaker or MirrorSync to optimize the performance with that much RAM? Thanks, ft.
  8. Allocation of RAM

    Hi, I have 16GB RAM on my OSX FileMaker server which also runs MirrorSync. I have noticed in Activity Monitor that the RAM usage is rarely over 10 GB. If I allocate the additional 5-or-6 GB to MirrorSync by modifying the modify the setenv file will it make my syncs faster? Thanks, ft.
  9. Hi, I have MirrorSync 3 and would liek to upgrade to 4. My clients are mostly remote and it would be difficult to get all changes synced to the server cleanly before upgrading to 4. So, I plan to rn 3 and 4 concurrently during the crossover period. It sounds like my process will be: 1. Export MirrorSync3 settings. 2. Install MirrorSync 4, choosing the 'Hosting Provider' option during install. 3. Import MIrrorSync3 settings to MirrorSync4 and rename the occurrence from the default 'Mirrorsync' to something other than the MirrorSync3 occurrence. 4. Configure the MirrorSync4 settings in the FileMaker File (I assume there are different MirrorSync Scripts/script folders required for version 3 and v4). 5. Allow everyone to continue syncing as normal. As each user downloads a new solution they will switch from MirrorSync3 to MirrorSync 4. 6. Eventually remove MirrorSync 3. Can someone who has been down this road please confirm the above strategy. Is there anything to be aware of in terms of performance when running 3 and 4 on the same box? Thanks, ft.
  10. Best Filtering Strategy

    Sounds good, thanks for the info. The test speeds seem pretty zippy to me in early testing but I need to do need to build queries across several tables. ft
  11. Best Filtering Strategy

    Many thanks for your reply. Is the speed of response of the custom SQL qualifiers 'test' function related to potential sync-speed impact when filtering with SQL? Thanks, ft.
  12. Hi, I need to start filtering syncs to prevent some users (not all) from seeing commercially sensitive data. Currently all my remote (MirrorSync) users log in to the solution with the same 'sales' account, and all users get all data. I need to define what to use for $$MIRRORSYNC_USERTOKEN for filtering. Would best practice be to create FM accounts in the solution for each user in the system (I have 3 files and 18 remote users so that would be almost 60 passwords to maintain, and growing), then use the get(accountname) as the $$MIRRORSYNC_USERTOKEN? Or should I build some kind of 'Accounts' table for them to authenticate against after they login, and use a username field from that table? Or is there a better way? Thanks, ft.
  13. Hi, I need to configure filtered syncs to some (not all) remote users. This is to prevent some users from seeing commercially sensitive data available to other users. I am hoping someone can advise the appropriate strategy for me between 'Custom SQL Qualifier' and 'Mirrorsync Customization Script'. I'm using JDBC right now. I could cut over to XML, but I think JDBC is probably right for me. Can someone please confirm? I'm syncing a solution withe the following characteristics: • 3 files, 3.5Gb total • 12 tables • 18 remote users sync to Hub • Hub has 20 local users • Remote (mirrorsync) users authenticate same local FileMaker 'sales' account to access the solution • Local users authenticate to directory services (Open Directory). Many thanks, ft.
  14. Hi, I have a server and 15 mobile clients in different countries. Some clients have very slow network connections. Sometimes significant data changes need to be made on the server. This can include importing records and deleting records. A number of tables have over 50-100,000 records and one table have 1,500,000 records. Records are never deleted on clients. If significant additions/deletions are made to data on the server is it worthwhile to have a local machine on the same LAN as the server to do the first sync following the changes (to work out which records were deleted on the server, etc)? Thanks, ft.

Important Information

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