I was helping another Sesame user to normalize her data that was exported from Q&A. In Q&A she had multiple records with the same record ID. I suggested creating a sesame application that had 2 databases. The first database had an element named record_ID and one Record_Bal.

The record_Id was to be used for the the parent record matching key and the Record_bal would be used later to calculate the subform record amount.

The second database that was to be used as a subform for above had elements that matched her export file named:

Recordid1
Recordid1again
Billedamt
payedAmt
chknum
adjustAmt
BilledDate
PayedDate

All dates are date fields, All Amounts are money fields.

When she (or I) does an Import into sesame using steps on page 175 of the 1.1 user guide the records import correctly (no errors) as parent & children, the chknum data and recordid data import perfectly but the dates and amounts are blank.

When I view the .txt we use to import from the data is present. Am I missing something obvious?

I had her check the Q&A file prior to export and the money fields and date fields are money and dates.

Any Thoughts? All help greatly appreciated!

Thanks

Quote:


Ray, Thanks for the input it was one of the first things I checked (I rember following another post recently who had that problem)

However,

Now I am really confused…. I had her e-mail me another export file and when I import with this (using the exact same steps I used 80 times previous) it imports perfect! Unfortunately like a dummy I overwrote the first .txt file she sent because she sent it with the same name and I was not thinking clearly, so I can not see what the difference between the two files was.

Another mystery to boggle my mind. I guess all that counts is that it works for her now.

It never fails, when I think something will be quick and easy (and tell another user its easy) it humbles me by kicking my tail.

Thanks for the help,

Robert