Need help on a script

[saraswati]

Hi !

I have to write a script which does the following.

Transfer all the records who enrolled in 2001 from Main.fp5 to Completed.fp5 I have a field called enrollment date I have to check the year and transfer all the records from the main file to completed file. Does anyone have a clue on how to transfer all records from one database to another ?

Thanks

Sara

[andygaunt]

OK,

To transfer the found set (once you have it) from one database to another.

First, find just one record in your Main.fp5

Now, go to completed.fp5 and do a manual import of that record.

Then, write a script

Import [restore, no dialog, Main.fp5]

OK. Now, in your main.fp5

Write a script that is

Perform Script [External, Completed.fp5 Import Record ]

---The delete step is only required if you do not want the records to remain in the main.fp5---

Delete All Records [No dialog]

So, once you have the found set for the year, you can incorporate this script into it to transfer the found set (and then delete the records if required).

***** WARNING!!! *****

Test this with either a copy of the database or with a couple of records that you just created for testing purposes.

This warning always applies when deleting large quantities of records, or doing replace functions. Heck, whenever you make ANY major change to the database contents or structure

HTH

[Steve T.]

Hi, Sara!

Of course, you can also add qualifiers to only import the records you want (maybe some were not completed and you want to keep them on HOLD). There's also a setting when you do the IMPORT to indicate what you want to do with duplicates... create new records or replace old ones.

The RESTORE feature is somewhat of a mixed blessing as it makes things easy but it's hard to remember what they were should you need to reset them again in the future (such as field to field matching maps).

--st