Jump to content

Duplicate entries...a lot of them

Recommended Posts

Hey guys,

How does Mirrorsync actually work? Does it use the creation timestamp to find and sync the same records? I have a problem where after a sync last night, I'm left with about 146 duplicates of each record. Quite a few of my records don't have creation field data as this field was only created after I already had many records in the database. Needing to rectify this quite urgently, so any help or input will be greatly appreciated.


Thanks in advance!

Share this post

Link to post
Share on other sites

Please use the 'Send problem report and log files' hyperlink on the MirrorSync launch page. This will send use your log file. Please be sure to include at least one example primary key of a record that was duplicated.

Share this post

Link to post
Share on other sites

Hi Jesse. We have the same problem. Sending the log files using the MirrorSync link also resulted to an error "The bug report could not be sent: java.lang.RuntimeException: Invalid XML response received from AWS".


Share this post

Link to post
Share on other sites

Try submitting the bug report one more time. If it still doesn't work, please grab the latest MirrorSync log file manually from C:\Program Files\360Works\Applications\Logs (on Windows) or /Library/360Works/Applications/Logs (on Mac), zip it, and upload to http://360works.com/upload

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Similar Content

    • By philipcaplan
      I have a table with about 100,000 records. One of the fields in the table is called "DecimalNumber" (type is "Number").
      There are many records (perhaps 10 to 20%) which have the same value in that field as another. Sometimes only 2 records have common values, sometimes more.
      What I want to do is to delete all records except one of each of those which share a value, thereby removing 'duplicates'.
      How do I achieve this? I assume a script will be needed, if so please can you give me the whole of that script.
      Many thanks in anticipation.
    • By interrobang
      I have only been working with FileMaker for a couple of months now, and it seems pretty daunting.
      The most pressing issue that I need help with is finding the duplicates in my contacts database.
      I've followed the instructions found here: http://help.filemaker.com/app/answers/detail/a_id/3441
      And here is my script:

      My "UniqueID" field uses the contact's last name and email address to calculate a unique id.
      I followed the instructions exactly... slowly figuring out how to accomplish each step. I am fairly confident that every step is correct except for "If [$id = Scratch::UniqueID]" because I didn't know how to enter the variable into the calculation. I just typed it in... which I don't think is correct. Also, on my computer (in the picture) the $ sign looks more like an S, but on another computer it looks as it should.
      Thank you for any time and advice you're able to give!
    • By Willy Koch
      This one is a bit tricky:

      I have a database with people where the email is the primary key. These people can have one or more values from a value list. The value list are different check box categories that the person belongs to, like what type of movie they prefer: Action, Comedy, Cartoon etc.

      Is there a script or function that will check for duplicates on import and retain the existing values, and just append the new category? Or in other words:

      Jack@example.com already exists in the database and he likes "Drama" and "Detective movies"

      In an external text file, with several people, there's also an entry for
      jack@example.com "Romantic comedy"

      When this duplicate record is found, I'd like the import process to append "Romantic Comedy" to Jack's record, so it reads:
      jack@example.com "Detective movies", "Drama", "Romantic comedy"

      It's given that I've created the new value list entry before importing.

      Thanks for any pointers.


      Willy T. Koch
  • Create New...

Important Information

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