I have a script which copies sets of records from reference tables into temporary tables where they can be worked on.

So let's say I'm working with the "Priorities" table. I've got 3 records in there. "High", "Med" and "Low"

I use the import records script step (pointing it at our server fmnet:/192.168.2.250/Master.fp7) and I've set up the proper import order...

The only problem is, the script doesn't work. First it would only import one record. Now it won't import any records, and indeed, when I hit the "Specify.." import order button, normally I can page through the records with the right and left arrow buttons but here I cannot, it's as if there are no records. (But if I go to the layout in my solution, I see that there ARE records)

I have eliminated the possibility that I'm pointing at the wrong table and all potential pitfalls regarding script, layout, or record permissions.

I came to the conclusion that it must be a file corruption issue, so I tried exporting all the records in the reference table, deleting them, and then re-importing them. This made no difference. The same script step written the same way is successfully copying other tables so... what can I do? If it comes to it, I'll manually code the copying of the records, but I'd prefer to use the one script step if I can.

Anyone have any insight?

Edited August 18, 200817 yr by Guest

What happens if you try to import from a local copy of Masters?

The same result. Import reliability is sporadic. Sometimes you get one record, sometimes you get them all, sometimes you get none.

I figured out another way to accomplish what I was doing, but I'm still interested in why this might happen.

Are you making sure that you are showing all the records that need to be imported first? The import step will import the found set.