Jump to content

Scotty Nordlund

Members
  • Content Count

    8
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Scotty Nordlund

  • Rank
    member
  1. What is the best practice for retrieving the last sync timestamp? I want GO users to be aware of how much time has elapsed since their last sync as a reminder to sync often. I know the timestamp lives on the MirrorSync table, but I would have to make a new occurrence of the MirrorSync table and relate it to all the tables that have layouts that contain the timestamp which seems awkward. If I can get a timestamp of the last sync in a global field, I can run it through a custom function that outputs the time ago in words (e.g. 3 hours ago, or 5 minutes ago, etc.), and put it on my interfaces.
  2. The hub database is FileMaker. I'll try this build in the morning. Thanks!
  3. After upgrading to MirrorSync 3 from 2, I can no longer sync container fields. During the reconfiguration process, I get the tooltip in the uploaded image below. The tooltip says "Neither field is writable. This could be because they are calculation or summary fields. It could also be caused by field-level validation or custom access privileges.". These container fields are not calc or summary fields. There is no field level validation or custom access privileges that I know if. They are full access, and the fields have not changed since my last MirrorSync 2 configuration. Please help!
  4. I think i'm figuring it out. I'm chaining "INNER JOIN" statements and I got 2 tables working so far using the advanced doc's. INNER JOIN Premise ON ( Device.PremiseID=Premise.PremiseID ) INNER JOIN Customer ON ( Premise.CustomerID=Customer.CustomerID ) WHERE ( Customer.SYNC_Assigned='{MIRRORSYNC_USERNAME}' )
  5. Hi Jesse, first of all, thank you very much for your help on this. I tried to write a sql statement for this but I gave up kind of quickly. I didn't know how to select a record in the parent table from the child table's context. I tried the following SELECT in my "Location" table (customers have many locations). WHERE ( Customer::SYNC_Assigned = '{MIRRORSYNC_USERNAME}' ) But of course, Customer::SYNC_Assigned is filemaker syntax, not SQL syntax, so that didn't work. I will check the advanced documentation and see if I can find something.
  6. I upgraded to version 3 for the performance increase. Will I see any performance increase switching back to XML? Thanks for the clarification though. That makes sense. I was driving myself crazy trying to figure this out.
  7. I'm upgrading from MirrorSync 2 to 3 in a development environment. I created new sync configurations and got everything up and running. The only thing that is not working is my MirrorSync customization script where you filter which records to be synced. I am using the same exact IF/ELSE IF statements i used in MirrorSync 2 and it's not working anymore. All records are being synced to the offline clients. My IF statement looks like the following. If [ Get ( LayoutName ) = "SYNC_Customer" ] Enter Find Mode [ Pause: Off] Set Field [ Customer::Sync_Assigned ; Get ( AccountName ) ] Constrain Found Set [] Else If [ Get ( LayoutName ) = "SYNC_Premise" ] Enter Find Mode [ Pause: Off] Set Field [ Customer::Sync_Assigned ; Get ( AccountName ) ] Constrain Found Set [] Else If [ Get ( LayoutName ) = "SYNC_Device" ] Enter Find Mode [ Pause: Off] Set Field [ Customer::Sync_Assigned ; Get ( AccountName ) ] Constrain Found Set [] Else If [ Get ( LayoutName ) = "SYNC_DeviceImages" ] Enter Find Mode [ Pause: Off] Set Field [ Customer::Sync_Assigned ; Get ( AccountName ) ] Constrain Found Set [] End If My IF statement matches up almost exactly with MirrorSync's customization script example and it no longer works in MirrorSync 3. Is anyone else having issues with selective syncing in version 3?
×
×
  • Create New...

Important Information

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