2 Replies Latest reply on Jun 10, 2015 10:03 AM by realgrouchy

    Importing match existing records math...

    realgrouchy

      Title

      Importing match existing records math...

      Post

      I had a database open with 563 records found out of 60,000.

      I imported a spreadsheet with 28,000 or so rows and told it to update matching records in found set based on certain criteria.

      In the "updating records..." progress dialog that appeared, the number was in the 50,000-60,000 range for much of the progress.

      When the import was complete, it said 1087 records were updated.

      How does this happen if I only had 563 records open? I've verified that there are no two entries in the imported dataset that have the same value for the three matching fields. I worry that I might have overwritten more entries than I had intended.

      Am I misinterpreting the "records updated" message?

        • 1. Re: Importing match existing records math...
          philmodjunk

          IF you are really sure that you don't have records with duplicate matches in your import source... (I'd double and triple check that one)...

          Another thing to look out for:  When you select "tables" for your import, you are really selecting table occurrences (boxes in Manage | Database | relatioships) If there is more than one table occurrence for your target table, it's possible to have a different found set for one Table Occurrence than found in another even though both refer to the same base (Data source) table. So it's possible in some situations to pull up a found set on a layout based on Table occurrence A, but then match to a completely different found set during the import if you either used a script to do the import and referred to table occurrence B or manually imported from a layout based on Table Occurrence B.

          • 2. Re: Importing match existing records math...
            realgrouchy

            Oh wow! I would never have thought of that, but it sounds very plausible. Thank you so much!

             

            - RG>