CODEWITHSUNDEEP
databaseodbcexportloadingfilemaker
CodeManX
CodeManX

Reputation: 11865

Read FileMaker data without opening files/databases first?

I managed to read data from FileMaker databases via Microsoft Access' ODBC import wizard. The problem is that every file needs to be opened first in FileMaker itself before it is made available via ODBC/JDBC.

This is an issue, because the data will change and I need to export the data of 150 databases every other week. I don't want to the enter the different credentials for every single database every other week, and wait for FileMaker to tell me, that some linked databases are not found (takes approx. 10 hours of supervision, only to hit the Cancel button).

Is there any way to avoid this tedious loading procedure? Does FileMaker Server work differently in this regard? (all databases always available?)

Upvotes: 0

Views: 1633

Answers (2)

user3857864
user3857864

Reputation: 29

If you have 150 Filemaker databases to open you can do this:

  1. Create a Filemaker file
  2. Create two accounts (example: Admin and Admin2)
  3. Create a Script that verifies if Admin or Admin2 is the current user
  4. If the current user is Admin Program your script to work, else,exit the script
  5. The script basically opens the files and does somthing with them
  6. Adjust the Filemaker file to start automaticaly (file options) with the Admin and iths password.
  7. Adjust the Script to run at startup

NOTE: if you need to make changes, open the file with Shift pressed so it will ask for a user and pass. Use Admin2 and the script will exit. WARNING: Very important to have this working. Will be very difficult to debug if such a mechanism is not stablished.

Now, once tested (Admin and Admin2), you can open your files and do someting with them and exit filemaker once done. I usually make two scripts. The first one runs at startup and verifies the user: if is Admin runs the second script, if it is Admin2 exits the script.

The second script contains what ever you need to do.

Upvotes: 0

SoliantMike
SoliantMike

Reputation: 371

FileMaker Server would be able to host the databases so they are available via ODBC, assuming ODBC has been enabled on the server and that the files you are accessing have been set up to allow ODBC sharing in their security settings.

It could also be an option to export the data you need out of FileMaker to a more friendly format that Access can consume. Could that be a possibility?

Upvotes: 2

Related Questions