Iterating export/import

[comment]

This one point is not clear:

In your source file, do you not want to export the found set?

[spiritquest]

Ok to clarify:

NO - I do not want to export the found set from my source file.

1) I find a set of records that match my criteria and sort.

2) I run a script which writes data into global fields within the source database, this script will stop at a certain record within the found set when it has gathered enough data

3) At this point I want the global fields of the source database written into a single record of the target database.

4) The script continues and repeats its process, writing relevant data into the global fields, until it is ready to write the data to the target again. The loop ends when the found set is exhausted.

[spiritquest]

Ok to clarify:

NO - I do not want to export the found set from my source file.

1) I find a set of records that match my criteria and sort.

2) I run a script which writes data into global fields within the source database, this script will stop at a certain record within the found set when it has gathered enough data

3) At this point I want the global fields of the source database written into a single record of the target database.

4) The script continues and repeats its process, writing relevant data into the global fields, until it is ready to write the data to the target again. The loop ends when the found set is exhausted.

[comment]

OK. It is not entirely clear why you have to concatenate the data into the global fields.

If this is data from the found set - or part of the found set - it might be easier:

1. Find a set of records that match your criteria and sort.

2. Mark the found set, if needed.

3. Go to record n + 1 (n = number of records with "enough data").

4. Omit multiple (the rest of the found set).

5. "Export" the reduced found set - i.e. call Import script in the target file.

If this is not acceptable, and you absolutely need to export many-to-one (concatenate n records in source to 1 record in target), then:

1. In target file, create a number field Registered.

2. In source file, create a calc field cCreator = 0.5

3. Create a relationship NewTarget from source to target:

cCreator = Registered (enable creation of records).

When you have your global fields ready, call a script:

Set Field [NewTarget::field1 , globalfield1]

Set Field [NewTarget::field2 , globalfield2]

...

Set Field [NewTarget::Registered , 1]

Exit Record/Request

[comment]

OK. It is not entirely clear why you have to concatenate the data into the global fields.

If this is data from the found set - or part of the found set - it might be easier:

1. Find a set of records that match your criteria and sort.

2. Mark the found set, if needed.

3. Go to record n + 1 (n = number of records with "enough data").

4. Omit multiple (the rest of the found set).

5. "Export" the reduced found set - i.e. call Import script in the target file.

If this is not acceptable, and you absolutely need to export many-to-one (concatenate n records in source to 1 record in target), then:

1. In target file, create a number field Registered.

2. In source file, create a calc field cCreator = 0.5

3. Create a relationship NewTarget from source to target:

cCreator = Registered (enable creation of records).

When you have your global fields ready, call a script:

Set Field [NewTarget::field1 , globalfield1]

Set Field [NewTarget::field2 , globalfield2]

...

Set Field [NewTarget::Registered , 1]

Exit Record/Request

[bikergeek]

Seems like the approach I'd take, if I'm understanding correctly, is this:

Assuming you have a table with prescription variable items, and a table for the students:

1. Create an indexed calc field in the items table, recNumAsTxt = getAsText(Get(RecordNumber))

2. Create a relationship items2::recNumAsTxt = students::scripItems (using a duplicate occurrence of the items table). If you want 30 randomly selected prescription items per student record for one time use, then the scripItems field will be an indexed calculation [text] =

GetAsText ( Round ( Random * [number of items minus one] ; 0 ) ) &