Importing a single record at a time.

[Chris C]

I have been lookin around but haven't found an answer to this: Can you import ust a single record at a time?

I am importing records from an old database (with 1 table) into a new database (with 15+ tables) and need to seperate out the fields as they are being imported so I can place them in the correct tables and relate them correctly... In other words I would create a loop starting at the first record of the old database that would go something like this:

1-import next record

2-sort fields and relate records.

Any ideas on how to do this?

Thanks in advance,

~Chris

[bcooney]

I would probably import the records into a temp table and then use a looping script to process them. Probably make much use of the Set Field script step.

[Chris C]

but there are 1700 fields :)

[comment]

More details would be useful here. You should probably import each set of fields into the appropriate target table (using unique validation, if necessary, to control the number of records imported into each table). Then do whatever is required to clean up the data and make it related as required. Regardless of the process, I don't see how importing one record at a time would help.