Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Carsten

  • Rank

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
  1. Thx a lot, it worked. What confuses me right now a bit, is that the SQL sync now uses the data api and I don't know if the usage will be a higher than our limit is there ...
  2. Hi, when upgrading vom Mirrorsync 5.x to 6.03 the installation failed. This was on a Windows Server 2016 Datacenter, FMS 17 When I try to start the 360Works Admin Console on the server the Error as in Image 2 occurs. (I think this is just because the installation did not work.) Does anybody have a tipp for me ? Kind regards Carsten
  3. Hi Joshua, I am using sometimes the script step „Set Field by name“ to use one script for all tables, so just renaming the fields is possible but not a „nobrainer“. In all other scripts with sql queries the leading underline is not a problem so I will just stop using SQL in Mirrorsync. Carsten
  4. Hi Joshua, do you have any good news for me about the leading underline "_" in a sql query ?
  5. Hi Joshua, just as an additional information from me ... In Filemaker with executeSQL I know it works like this "SELECT a.\"_kp_field-a\" FROM \"Table\" a WHERE a.\"_field-b\" = ? AND a.\"field-c\" = ? ....
  6. Hi everybody, I started to use sql in mirrorsync but I have problems with one field name that starts with "_" Example Where '_user_created' = '{MIRRORSYNC_USERNAME}' There are no more error message when using a apostrophe ' but I get no values then ... I think this is a very basic problem and hope somebody has a tip Kind regards Carsten
  7. I think this is a "normal" cross table so it shouldn't be a problem ... . Just two short questions .. ? Do all necessary tables have sync layouts and they are included in the sync ? Do you use a customization script ?
  8. I think I had a very basic misunderstanding problem here ... I thought that mirrorsync does somehow do it's own filtering based on the relationships which are set ... . ("only filter modification records that are connected to an information record") All other tables in my database are filtered in the customization script based on the username, that is why that never was a problem before. I added a non stored and non synced formula field to filter the "modification" table now and it works ! (A sync with no changes at all takes now 6 seconds) Is there a faster / better solution for this perhaps ?
  9. Hi everyone, I am filtering the tables "projects" and "information" user based with XML in the customization script and this works fine. The table "modifikation" is not filtered in the customization script at all. (Please see attached relationship from the mirrorsync 4 client) My problem is that all records from "modifikation" are synced now, even if the related record from "information" is not on the device ... Because of my settings in the mirrorsync client I expected that only records are synced that are related to the found set of "information" . I am thankful for any idea :-) Kind regards Carsten
  10. Hi Junior With the very fast help of the support at 360Works this problem was easily solved - THX to this ! It was my, as we say in german, "tomatoes on the eyes" problem. The old script steps were inserted in the wrong section of the new customization script :-( ("Willsync" instead of "Findchanges") Just to let you know that the problem was solved and if anyone else also has "tomatoes on his eyes" in future ;-) Thanks a lot Carsten
  11. Our problem: Mirrorsync 4.0 is not filtering any records with the script steps in the customization script. All data is synced ... . We used the xml setting in the configuration utility and "Constrain found set" in the mirrorsync customization script. The same filter worked fine in Mirrorsync 3.17 We installed the sync completely new in the database when we moved to Version 4 and copied the script steps into the new customization script.
  12. Yes ... in addition to this very complex answer :-) ... : I appreciate the new feature to distribute new versions in that way to the Users, but it would have been a "killer feature" if the existing data is imported in the new Version automatically! Has anyone an idea how to accomplish this ?
  13. Hi everyone, we use FMGo 16, a FM Server 14 and FMPA 15 Syncing works fine except that in new records the two auto enter mod fields (created by, changed by) are set to the "local" user of the iPad Means USER1 creates on IPAD1 a record and after USER2 syncs the new records to IPAD2 the value for all MOD Fields show that USER2 created the record and changed it. I have not included the "modified by" field in the sync layout. (Thought I read somewhere I shouldn't do this ...) The mod fields have the settings "Do not change Value when entered", "Check Values only when entered", "User is allowed to disable check of data when entered" (Please excuse if the settings are named a little bit different, I use a german Version and translated them ...) My first idea was now to change the settings of the fields, but before I start testing around I thought to ask here .. Kind regards from Germany Carsten
  14. Thanks Tsiry then I will reduce the amount of relationships in the MirrorSync config client to get a parent child logic which is necessary for syncing. A few relationships there are not really necessary for this case (value lists, more or less) Kind regards Carsten
  15. Hi, in which order are the tables synced when MirrorSync starts? Is this done in the order how they occur in the "sync" Layout folder? We are syncing quite a few tables and use filters in the customization script to reduce the amount of records to be synced. We want to start syncing the relevant projects, then only the relevant phases of these projects and then only the relevant tasks of these phases ... That is why we need to synchronize in this order ... project-phase-task If we start the customization script (MirrorSync Customization) from the different sync Layouts in the "right" order of the tables all filters work fine. My question from the beginning is one of my first steps to look for my mistake :-) Kind regards from Germany Carsten
  • Create New...

Important Information

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