FM External Data Sources Tables

I have a few questions regarding External Data Sources:
1. Can the list of External Data Sources be viewed via a script or calculation?
2. Once a External Data Source (mainly to another filmmaker file) in the Manage External Data Sources window, is it possible to view the list of tables available on the external source via a script or calculation or any other form?
PachecoPrimoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Lieven EmbrechtsSenior IT ConsultantCommented:
there is no universal answer to your questions as it depends on your external datasource (which can be very different) and it depends on what you want to do, so i'll try to help with some thoughts:
- most of the external datasources functionality in filemaker is limited in what it can and is a manual job (filemaker menus), it's not a universal connector.
- sometimes an external datasource offers a system table with the metadata you want.
- you can copy the metadata (tables & fields) from the external datasource to a local filemaker table (just by  copying and pasting the tables), this can bring you a step closer to what you want.
- have a look at http://www.goya.com.au/baseelements/plugin which goes in the metadata direction, i didn't test it on external metadata though.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Will LovingPresidentCommented:
I don't know of a way to generate a list of external data sources. The "DatabaseNames" function only gives you back a list of files open on the current computer. If the external data source is a FileMaker files and it's open, it might be included in the list (I haven't tried it).

With regard to the list of tables available in an already connected external data source, the "TableNames" function will return a list of all table occurrences in the relationships graph for the specified fileName, separated by carriage returns:

TableNames( fileName )

You could certainly use that in a script or calculation, and the FieldNames function returns a list of all fields on a layout (rather than all fields in a table).

For a complete list of the various "Design" functions, and details on the ones mentioned above see:

http://www.filemaker.com/help/html/func_ref1.31.26.html
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.