Where are they ?  Why missing?
I have no answer right now, will give that some thought.

How to find them?  Here are two methods that come to mind....

1.  Sort records by unique ID in both Sesame and Q&A.  Move to Table View for both. Now check every few hundred records in order to find matches.  Record 300 should be the same value for both.  Record 600 should be the same, etc.  When not the same, go backwards by half the difference to determine where the  change happens.  Continue this as needed.

OR

2.  Export from Sesame to Ascii.  Import into empty copy of Q&A file.  Do XLU from original good Q&A for unique value in imported Q&A file.  Check XLU for value that does not exist in the imported file.  If done as a report, you can have a list of those records.  Or can do a Mass Update, selecting the records that XLU does not exist, and mark a field with "MISSING".  Now can retrieve records with "MISSING" and work on what happened, or how to export to Sesame again.

Well, I powered through this.  I opened the exported file in Excel; it had 10317 lines.

Then, in Sesame, I sorted my imported records by code (it's my customer file), and got the code number to match up to the line number.  Then I just had to keep moving down the screen, watching for mismatches, and recording the missing numbers (essentially exactly as Bob suggested, though I hadn't seen his suggestion yet).  Each time, I checked the Q&A file to see if the missing records had any sort of weirdness to them, but nothing jumped out at me.  Eventually I got through all 10302 Sesame records and had a list of missing Q&A records.

Then, back to Q&A.  I exported those records, and imported them into Sesame.  Sesame accepted them all.  I now have a matching count in both programs.

But no idea why they were missed in the first pass.  I hope it doesn't happen when I export/import my invoices and workorders, because there's far more than 10,000 or each of those (approximately 3 times as many in each database, and I already know that there are missing numbers in each of them.  I've been scrupulous about keeping Customer clean, with no skipped codes, but it hasn't been a concern with Invoice or Workorder.)

Perhaps it's related to the record loss issue that Spencer brought to light?  I have not yet upgraded everything to 2.0.2, but I will before importing my Invoices and Workorders.

In any case, Customer.db is happy and full.  Time for a coffee break.  Thanks for the advice, Bob and Erika.

Scott,

Were the missed records together, or were they scattered throughout the export file?

One thing that I have seen cause this is special characters like carriage returns or quotation marks in the data itself.

If you want to send the text file and the list of ones that got skipped into us, we'll see if we can spot any quirky data.

Infinity wrote on Aug 31^st, 2007 at 4:16pm:

Yep.

Ray, you are amazing.  Thank you so much.

You mentioned a cascade.  Is it possible that data from one record got mixed into another because of the escape character?

Are there any other characters I should test for?

Is it just at the end of the field where the character causes a problem, or anywhere within it?

Quote:


The backslash will only be a problem at the end of a field. The Quote will be a problem anywhere in the field. What you can do is replace the " character with two single ' characters.

-Ray