Jump to content

External Data Source not showing all TOs when not open


KevinArevalo
 Share

This topic is 1848 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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? 

Link to comment
Share on other sites

Probably the latter.  When you open the graph on file A, it will automatically try to open file B to show the TOs that belong to file B.  If it can't find the reference it should prompt you to locate it.  Do you get a prompt?

Can you post a screenshot of the file references in file A?

  • Like 1
Link to comment
Share on other sites

The whole scenario sounds very unlikely.

I don't think you're even opening up the files you think you are opening. I suspect there are two copies of File "A" and they are in fact completely different and have different graphs.

  • Like 1
Link to comment
Share on other sites

Hi Kevin,

12 hours ago, KevinArevalo said:

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. 

When you open a file, not all externally referenced files open automatically.  There must be a field or reference which requires that FM open the other file/s.  Are these three tables the local 'UI' tables and it is the data ( external ) file which doesn't open?  If you place a field from one of those tables onto your opening layout, does it then open?

  • Like 1
Link to comment
Share on other sites

This topic is 1848 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Similar Content

    • By sal88
      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
    • By sal88
      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
    • By DataLackey
      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
       
    • By mattp52
      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
    • By mattp52
      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.
×
×
  • Create New...

Important Information

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