Importing Not

[WhiteKnight]

Importing Not:

I have a found set in the table1 which I’m trying to import into table2, both in the same file. With no relationship between the two tables. (Manually to begin with then scripted.)

The “Import Field Mapping” shows the records and count is correct on the source side and I can step through the records. To simplify things I have selected one matching field to import.

However this is what I get in the Import Summary.

Total records added / updated: 2

Total records skipped due to errors: 2

Total fields skipped due to errors: 0

Table created

This leaves the found count in table2 the same, no change?

What gives?

Jerry Beck

P.S. Profile could be old.

[IdealData]

Total records skipped due to errors: 2

The IMPORT LOG file will explain.

[WhiteKnight]

Thanks for the heads up. However, always a however , the Import Log file is not updating? I can't say why it's just not working. I have found no way to delete it and regenerate it or any way to track the reasons for it not updating. To date my original problem still exist. I have additionally tried to import between 2 other tables in the same file, same results???

:

[Vaughan]

Do any fields have validation?

[WhiteKnight]

In an effort to reduce any errors i've limited the import to a single field. The single field i'm importing has no validation. Do you think validation carries over to fields not being imported? I have not checked this.

This still leaves the mystery of the "Import Log". I have done extensive search's and found no activity on any of the numerous FM import logs on my system. That is, activity at the point in time of my import attempts.

[Vaughan]

Yes... if any of the other fields have "not empty" validation and data isn't imported into them then the validation will fail, and the record won't be imported.

Are you using FMP 6? If not change your profile info please. If you are, I don't think there is an import log...

[WhiteKnight]

Sorry about the profile, it's been awhile. Interesting that the validation is applicable to none importing fields. I will look into that. As a stop gap I've setup a looping script, setting variables with a new record/request in the second file and set field to the variables, not as good as import (bad coding) but it works.

Now on to viewing/printing imported PDF's.

Thanks