I'm stuck. Really stuck. I can't wrap my head around this problem. So here's the issue:
I have 4 tables:
A member logs hours worked into a project as line items. Earnings are also logged per project as line items with date and amount.
Now I need a report that would show total earnings per user per month. I know I'm missing something but I don't know what.
Please help! Thank you!
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.
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?
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?
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.