Jump to content

Search the Community

Showing results for tags 'external data source'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 10 results

  1. The first challenge in finding the answer to a Filemaker question is trying to figure out how to ask the question! Here goes… I have two data files, one is a host on FM11 being accessed remotely by the client file residing on other machines including FMGo. I have records in the host file that contain fields that contain auto-enter lookup values from a related field in the client file. (The purpose of this is to create duplicate records that have been created by clients). I must say, it all works great. With one problem. The FIRST time the client creates a new record in the host file and inserts a value into the related field, the host database can't find the client to lookup the value. After selecting the location of the client, it finds it and works great. Any new records created after that will work just fine as the host now knows the location of the client apparently. So my question is this, is there some way to tell a remotely accessed host database the location of the client that it has the relationship with in a script so that the user doesn't have to manually tell the host where the client is the first time? I understand how to manage external data sources with known locations, but you never really know where the client will be therefore I need a way to tell the host without the user being interrupted with the dialog box, "The file <filenamehere> could not be opened. (not found)" the first time its accessed. I hope thats clear! :-) Thanks.
  2. This is my first post, so please forgive me if it's in the wrong place. I'm developing a database for my schools that keeps track of a ton of different information. Currently, it's all in one large database. My issue is that in the future, when I have teachers, office workers, and management all accessing it, I want to limit access to some information to only certain people. For example, I don't want my teachers seeing money information. It's not relevant to their job. I do want them to have access to the student information though so that they can keep track of absences, etc. Now, I understand that I can pop all of that information into different tables, and build layouts that are limited by password, and only show the relevant information. That way would work fine I think, but it would mean that most employees are working on a database that's a LOT larger than necessarily needed. I have two locations, and the database will eventually be shared to everyone over a VPN network. Because of that, I'm worried about it taking a long time to access and make changes. So, my question: Is it better to break the database up into several "mini-databases" with separate information (such as student information, textbook information, class information, event information (such as problems, or good things happening), etc), set up 3 specific databases (one for teachers, one for management, and one for office workers), and add the mini-databases as external data sources... OR Is it better to have one large database that everyone has access to, but the individual layouts are set and password protected based on the user group each person is a member of? Thanks so much for any help! Daniel
  3. I am creating a run-time from two linked solution files but cannot get a working solution which references the linked file correctly. When I create the run-time if I attempt to add the linked file to the Solution Files list I get an error message that the file is either open or already linked to the primary solution file. Of course if I leave it out and create the runtime anyway, when I open the generated run-time I get an error that the linked file cannot be found. How do I get around this circular issue and why on earth won't FM let me include linked files in the Solutions list when generating the runtime? Thanks
  4. Turning to the forum for assistance on this as neither the built-in documentation and external sources seem to provide a working solution to this problem. Can anyone point me to a clear process for re-linking an external file source (data file) where the solution has previously been saved with the external data source reference removed? I am making a cut-down copy of a production database from copies of a two-file linked solution. Despite repeated attempts to specify the files as linked to each other under Manage> External Data Sources the external data source is not found. Advice I Googled suggested going into Manage>Database>Tables and looking for italicised tables with "Data Source Missing" messages and that they could be re-linked from there. This is not the case, the interface file does not list external tables in the tables tab (and doesn't on the original working solution either). The Relationship Graph does show tables from the linked solution and has marked them as "Data Source Missing". Surely there is a straightforward way to re-link a file with foreign TO references with the external file that defines them? I've tried re-linking to the file multiple times under Manage > External Data Sources but it has no effect. Thanks in advance for any help.
  5. Hi, I'm trying to use Filemaker to manage a mysql database on Amazon RDS. I'm trying to set up an import layout that will allow users to load data into into the RDS database. Mostly, Filemaker and mysql are playing well together. But I'm getting a problem when I try import data using LOAD DATA LOCAL INFILE . I've run the query successfully with a different client on the same database (Sequel Pro) but when I run it using the Execute SQL script step in Filemaker I get an error, with the message "Load data local infile forbidden". I've looked around online, and it seems like I need the server and client to both enable 'local_infile'. I know it's enabled on the server (because I can check manually, and the query works on a different client). Does anyone know how to check or change this within Filemaker? Otherwise, does anyone have any ideas as to how I might work around this? Unfortunately I can't call a stored procedure on the server because the query relies on variables. My understanding is that you can't use variables in a LOAD DATA INFILE statement on the server, and you can't use LOAD DATA INFILE in a prepared statement. Does anyone know how to change the local_infile variable within the Filemaker mysql client, or failing that, does anyone have a good workaround for the restriction on variables with the LOAD DATA INFILE statement if I run it on the server? In case it's not already blatantly obvious, I don't really know what I'm doing, so any help (especially help that is dumbed down) would be hugely appreciated. Thanks, John
  6. Hi all I'm trying to export my filemaker records to my external sql database via the execute sql script step but am getting a number of errors. I can see my external ODBC source and can generally write to it (I can go to the respective layout and click 'new record'). My query basically as follows: "INSERT INTO dbo.Log ( dbo.Log.log_id, dbo.Log.log_case_idf, dbo.Log.Labour_TOTALS_Labour_Cost, dbo.Log.Labour_TOTALS_Item_Sale) SELECT Log_Log.log_id, Log_Log.log_case_idf, Log_Log.Labour_TOTALS_Labour_Cost, Log_Log.Labour_TOTALS_Item_Sale, FROM Log WHERE Log_Log.Log_Type = '2'" My first question is: is it even possible to export to an odbc source with a 'insert INTO SELECT' query? Many thanks
  7. Good morning, I am having a bit of a problem with External Data Sources and pulling in information correctly. We have a hosted file A, that has about 30 table occurrences from hosted file B on it's relational diagram. When we are connected to both of the solutions remotely, all of the table occurrences show up correctly. However, when we are only connected to hosted file A, not all of the table occurrences show up. Only 3 of them show up on the relational diagram, instead of the 30 that were on there before. It seems like its just three arbitrary tables too, it's a Globals table, a Preferences_System table, and a Preferences_User table. Why would this be happening? Where does the problem here lie, is there some sort of permissions that I have to set up to allow all tables to show up even if both solutions aren't open? Is this a problem which lies in how I set up the External Data Sources?
  8. Hello all. I'm fairly new to FM, so please forgive me if my question seems stupid. I have a really huge database in FM 12 (let's call it FM1). I also have a FM file, which needs to see some fields from FM1 (let's call it FM2). It's all taken care of in relationship graph (FM1 as External Data Source). What I need is for the user of FM2 to be able to view data from FM1, without being able to alter it in any way. So far I came up with preventing the user from entering these fields in Browse mode, but that seems to me a bit unprofessional (and makes impossible to copy the field). And if it's a way to go, is it 100% foolproof? The user will have to be able to edit, create and delete other records in FM2. tldr: Is there a way of preventing making changes in External Data Source FM file?
  9. We have one Microsoft SQL Server with two different databases (Test and Production) on it. We connect to these databases with FileMaker Pro 14 with an external data source (ODBC). We have copied the Production FileMaker database to the Test database and changed the DSN settings (which has different credentials for Production and the Test environment!). The new Test environment is still pointing to the SQL Server Production database. How can we achieve that the FileMaker Test database points to the SQL Server Test database and the FileMaker Production database to the SQL Server Production database? The FileMaker Test and Production databases are installed on the same server.
  10. Hi all Users are more frequently than ever requesting that custom reports be made. Up till now this has involved me creating layouts and scripts that can produce the data/reports in the form they want. I'm wondering if now it might be possible to let them take control of reporting in a way that is separate from the current database (which is heavy on GUI and disabling of features for ordinary users). I'm thinking of creating a totally new database which users would be able to completely edit from a design perspective, which would point to the main database as an external data source. However I would like it so that they would NOT be able to edit/create/delete those external records. I've had a play with it and can't seem to get it to work (we're using external authentication via windows server active directory). Is such a thing possible? Many thanks
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.