Importing a found set?

[laker_42]

I have two files, WTLB & MediaOffers. WTLB contains scripts from a program that we produce and contains programs for the past 3 years. MediaOffers is supposed to contain only 1 years worth of WTLB programs. When I run my import script it is importing all the WTLB records into MediaOffers. Here is my script:

Enter Find

Insert Text (MediaOffers:Program;WTLB)

Perform Find

Delete All Records --I am wiping all WTLB records and reloading the entire year

Perform Script ("FindRecordsForImport from File:WTLB")

Enter Browse Mode

Import Records (No Dialog;"WTLB")

Do I need to add an open file script step to open the WTLB DB before I do the first perform script. Then it would have the file open and the found set that I want to import? This is worked in FMP 5 but is not working the same now that I have converted to FMP 7. Any help would be appreciated.

Thanks!

John

[Fitch]

This may be a bug that was fixed in 7.0.3 update:

http://www.filemaker.com/ti/109271.html

... or a problem with file references:

http://www.filemaker.com/ti/109350.html

... but most likely it's that your file has no open window*:

http://www.filemaker.com/ti/108763.html

...in which case the answer is yes, add an open file step and you should be ok.

*"In prior versions of FileMaker Pro, any attempt to import from another FileMaker file would only import those records that were currently in the file's found set. In FileMaker Pro 7 this same behavior holds true only when the file already has a window open at the time of import. So, when importing records from a table in a FileMaker Pro 7 file, the application will get the set of records to import from the file's front most window, if any. The application will use the table's corresponding found set in that window, if any. If no window or no found set is available, then the entire set of records for that table will be used for the import source."

[laker_42]

Thanks for the answer Tom! Is there a better way for me to do this in FMP 7? I added the WTLB database as an instance in the MediaOffers database and created a relationship. I then tried importing from the instance but it appears that there is no way to import from another table in the same database? Is that correct?

Thanks for the help!

John

[Fitch]

I infer that by "instance" you mean Table Occurrence (TO). Or perhaps you mean table, or maybe both. Doesn't really matter. Whether or not you have a relationship doesn't matter either. You can indeed import from one table to another. Above the list of fields you will see a popup menu of tables.

[laker_42]

Hi Tom,

Yes, I did mean TO. I had tried to set the import from the same file but then change to the different TO but originally I hadn't installed the v3 updater. So it was kicking me out of the application when I tried to reference the same file to import from. That was what was causing the confusion for me. After installing the v3 updater, I am good to go.

Thanks for the help Tom!

John