SeedCode Support Forum

I have an Filemaker 12 import script that performs as follows:
The user browses to where the Source file is located and selects it.
The script assigns the variable $Filename to the selected file. (ie, LM144.fmpur)
I then delete each table in the Target file and then import each table in LM144.fmpur.

This works.... unless....
... I have added a table in the Target file and the same table is 'missing' in the Source file.

Question: "Can I use SQLExplorer to construct a query that would look at the Source file and see if a specified table is present?" If so, what would it look like? I am really stuck.

Thank you

Ron

Hi Ron,

You can't do this with SQL, but you can possibly use the FileMaker Design functions. Providing the file is open, then TableNames ( filename ) should give you a list of the existing table occurences.

FMSQL needs to have a table occurrence reference in the target file for it to be visible to a query.

hth,
Jason

JasonYoung wrote:Hi Ron,

You can't do this with SQL, but you can possibly use the FileMaker Design functions. Providing the file is open, then TableNames ( filename ) should give you a list of the existing table occurences.

FMSQL needs to have a table occurrence reference in the target file for it to be visible to a query.

hth,
Jason

OK. How do I 'Open' the user selected file? (I have the selected file name and path in $$Path)

Hi,

Right, you'd have to have a file reference to the source file to open it. If you have that, then you can do it with the open file script step. However, that may not be practical if the file name and location can change.

Other than that, there's no easy way to open a FileMaker file from another FileMaker file.

The possible "trick" you could try would be to write a script that:

1) inserts the FileMaker file into a container field and then exports it somewhere else (like the temp path).
2) When you export the file from a container you have the option of opening the file.
3) Now that the file is open the design functions can do their check, and then proceed with the import if the table's there.
4) You'll have the path you exported and opened the file to, so you could just point the import there as it will be exactly the same as your original source file. That way they just need to pick the file once, only they'll be inserting the file rather that importing its records.

Untested and only a theory, but I think it might work

Let us know if that helps,
-Jason

JasonYoung wrote:Hi,

Right, you'd have to have a file reference to the source file to open it. If you have that, then you can do it with the open file script step. However, that may not be practical if the file name and location can change.

Other than that, there's no easy way to open a FileMaker file from another FileMaker file.

The possible "trick" you could try would be to write a script that:

1) inserts the FileMaker file into a container field and then exports it somewhere else (like the temp path).
2) When you export the file from a container you have the option of opening the file.
3) Now that the file is open the design functions can do their check, and then proceed with the import if the table's there.
4) You'll have the path you exported and opened the file to, so you could just point the import there as it will be exactly the same as your original source file. That way they just need to pick the file once, only they'll be inserting the file rather that importing its records.

Untested and only a theory, but I think it might work

Let us know if that helps,
-Jason

Hi Jason,
Your idea sounds workable. I will give it a try and let you know. (Isn't this an incredible hassle? Shouldn't it be easier than jumping through all these hoops? And last, 'Isn't this a business opportunity for a company like SeedCode to 'fill the gap' that Filemaker created and make this process easy? (If so, put me down as a beta tester!

Cool, please do.

Cheers and have a great Weekend!