External Data Sources

Hello everyone, I'm doing something I know I've done a number of times before, but for some reason, now I'm struggling with it. I am a little rusty with FM, so it's possible I'm doing something silly... I have my development done; it works great. My client is a few hundred miles away, so I'd like to separate data and interface to make changes whenever requested and simply ship him the new front end. I've done this before on much bigger projects; I've never had a problem. Today, as I'm splitting and redirecting tables from the front-end file to the back-end file, all of my calculations are breaking. Before the redirection, I'd have calculations that look l…

The following JSON result is different than I'm used to seeing. I'm trying to access COUNTRY but the term 'Country' exists only below the data itself under a subheading "types." The following statement doesn't get the COUNTRY data for me. Any thoughts? JSONGetElement ( $$placeResult ; "result.address_components.country" ) nor does JSONGetElement ( $$placeResult ; "result.address_components.country.long_name" ) FYI - I can't simply use: JSONGetElement ( $$placeResult ; "result.address_components[3]" ) as the number of elements differ based upon the search. { "html_attributions" : [], "result" : { "address_components" : …

I have a solution that relies on an OBBC (mysql) data source. What's the best way to trap if that data source is down? In my tests, with it down, as soon as I try to open the connected solution or run a script from that solution, it opens the Find In Progress... dialog, and there is a long delay before that stops, and that's what I would like to avoid. I would like to immediately get a message to the user that the ODBC source is down, rather than having to wait for a find and then trapping for an error. Also, it seems that Get(LastError) comes back as zero for "Data Source Missing", which is strange.

I have connected Filemaker to Wordpress phpmyadmin database through OBCE. I am testing this and have 27 test records in mysql. In Filemaker only the first three records are showing. When I refresh window, very briefly 27 records show in Filemaker record count, but then reverts to showing just 3 records. Any ideas as to what I need to do to show all the records? Thanks for your help.

Hi, after switching from one MySQL data base to another all my scripts are screwed up. What is happening here? What I did: • Defined a new ODBC data source with Actual ODBC Pack. Every aspect works perfectly fine. • Created a MySQLDump of the data source and transferred it to the new server. Both data bases are identical. • Left all table occurrences in my relationship graph at their place and switched from the old data source to the new data source -- this is what happens: All layouts work perfectly fine. Not only the layouts that are based on the remote data source but also layouts based on the current file that have related fields on them …

Hi, I have an ESS connection into a MySQL database. I need to delete all of the data in the MySQL database and then add new records via the server (from the same FileMaker file). Im wondering, is there a best/fast way to delete all of the records in the MySQL table from FileMaker? On MySQL/PHPmyAdmin I would simply run a TRUNCATE table_name, but Im not sure if that's possible or recommended. Thanks in advance.

Good night, I think I am trying to reinvent the impossible, but it's worth the ask. If there any way I can pull data into FileMaker using a URL? For example, I need the item description and price, and photo. The main sites i work with are rockauto, amazing, Walmart, and eBay. Please, if I am posting in the wrong group, my apologies. Thanks RudyM

Hi everyone. I have FM Pro I use for data entry. Now we have changed to Postgres SQL. How can I migrate my data from FM to Postgres SQL and also auto mate subsequent data entry from the FM into the Postgres SQL? Thank you

Dynamic Data Source are a really great way to dynamically handle other files. What I still have issues to wrap my head around is why the $$ can only be used once per session. If the $$ should point somewhere else the file has to be closed and re-opened again. Anyone an idea what the technical background here is? I'd like to understand. FYI: https://support.claris.com/s/article/filemaker-16---dynamic-data-source?language=en_US

I have two files that I serve from the same FMServer 16 instance. They both need to access data from each other, so I have them setup as External Data Sources of type FileMaker, with a single path like this: file:FileName I'm having occasional problems, in both files, from FileMaker Pro 16, with delays accessing data from the other. I get occasional "Find in Progress" progress bars that last quite a while. Considering the files live on the same server, I expected it to be pretty quick. Am I not doing this properly? Is there a faster way, short of merging the two files into one? Thanks!

Hi all I have moved a "message object" field from my emails table to a separate FM database called "MessageObjects". The server schedule runs a receive emails script, which now references that new database as an external data source. Is there a simple way for the script to check whether that external data source is accessible? I would like the script to halt if it is offline. I've tried get (layouttablename) from the layout that points to the external table occurrence but this refers to the table occurrence whether the source is available or not. The best I've come up with so far is to get it to perform a script that resides within MessageObjects…

Sorry if it is the wrong thread... I would like to use "show/hide filename extensions" status in a calculation. Can FMPro do it? v18. Thanks, Asu

Hi all We have a PostgreSQL 9.6.17 database that we wish to connect to from FileMaker. I have added the PostgreSQL Unicode(x64) 9.06.01.00 in to ODBC (64bit) on FileMaker Server and succesfully added a DSN. From FileMaker Pro this DSN shows and I'm able to add it as an ESS. However when I go to the relationship graph and try to add one of its tables I get the following message: "The ODBC data source you have selected is not supported." According to this table it is actually PostgreSQL ODBC Driver (Unicode) 9.03.04.00 that is required. However this is not 64 bit (I tried it anyway but it does not show up at all in ESS in FileMaker Pro): https://support.c…

Have a web solution, PHP to MySQL. Just upgraded PHP from 5.x to 7.x. Forcing encoding on PHP solution to UTF-8 via mysqli_set_charset('utf8') (having been doing this all along). And now all double quotes and apostrophes, when they are imported into FM solution, are showing as ’. The value including those characters are written into MySQL using mysqli_real_escape_string($VAR). Any thoughts would be greatly appreciated. Thanks!

Hi! I've some devices for time attendance and I want to use a ready python library to read datas and import them to Filemaker. There is maybe a Filemaker plugin that is able to execute a python script and import some datas? If not.. should I do it with command prompt? About importing data, should it be by writing down a file with Python and read it back in FileMarker? Or there is any simpler way to do it by RAM? (for example and array). Thank you for any idea about that :)

Hi, I'm hoping someone has seen this before. I receive this message as I open the file "WW Layouts.fmp12" I started receiving the message after I changed the file location. It occurs the first time my startup script attempts to access a database field. Thank you for any help you might be able to provide.

I know in the past I've done package tracking, where I can have tracking numbers, and FMP will connect to the USPS website tracking, or FedEx, etc, and show the tracking data. I'm wondering if anyone has done one to track your stocks? I know there's stock tracking apps, and even your brokerage will show your investments. But I'm wanting to do one in FMP of my own, so I can customize it. But I can't find any web links to use to pipe stock data in.

Hi, I'm new to FM, but I've already created a database on FM, where I register my projects. Each project has a number (001, 002, etc.) and a name (market, hospital, housing, etc.) and I intend to create a button on the layout corresponding to each project. What I want is: In the 001-Hospital project, the button opens the respective folder on my external disk (example) // Volumes / Elements / Projects / Projects / 001-Hospital. The variables are: <<NumProj>> (corresponding to 001, 002, ...) <<Name>> (corresponding to Hospital, market, ...) I tried to create an "open URL" in the button with this expression: "file: /// Volumes …

Tried adding an ODBC source using both MySQL 8.0.22 and MariaDB 3.1.10 drivers in Unicode mode and I can connect just fine, however it's impossible to add a table onto the relationships graph. It sees the table's name but when I try to add it, I get This action cannot be performed because the required table is missing. error. It works fine with ANSI version of the MySQL driver, sans the ability to work with Unicode of course. I've tried multiple combinations, including making the database and the table strictly "latin", it still refuses to add the table. The test database itself is very simple, just a single table and a single field, no spaces and no unicode chara…

I need to connect Filemaker Pro with ASP .Net MVC application. I found FMData API as C# clinet for Filemaker https://fmdata.io/ . I have installed package from nuget by using "dotnet add package FMData.Rest" command can be any body please explain the way how to use it for connectivity? or any other solution ?

Good afternoon, I am trying to generate the JSON lines found in the attached file, yet I am experiencing problems and would like some assistance please in generating the JSON data in the attached file. I can create the main "outer" layer such as the first GUID, CompletedDate etc is OK, as well as the Supplier and the 3 entries under there, however, when I "resume" the outer layer again, and then try to create the PurchaseOrderLines and everything below that, it all turns to mush. My attempts to do so by inserting JSONSetElements again give me errors saying something similar to not allowing List items (or similar error) within. How do I nest the SetEleme…

I'm trying to update a field from a JSON object, but can't seem to get it to work in FMP16. My JSON object looks like this: { "Global Quote": { "01. symbol": "LUV", "02. open": "36.1400", "03. high": "39.3200", "04. low": "36.0500", "05. price": "38.7600", "06. volume": "11846803", "07. latest trading day": "2020-10-02", "08. previous close": "37.9300", "09. change": "0.8300", "10. change percent": "2.1882%" } } which I have in a variable ($json), but when trying to update my field, I just get a blank fiel…

How to copy all text in a word document to the clipboard with a DDE command? (FileMaker Pro 18, Windows 10)

Good morning. I am trying to POST data to a system, and am experiencing difficulty in doing so. In the snippet below, I am easily able to upload the name, sale_price etc, but when it comes to "images" I am unsure how to format the line - whether it be a single image or several images. Could somebody please point me in the right direction for the syntax of such a command? curl -X POST https://example.com/site/products -u consumer_key:consumer_secret -H “Content-Type: application/json” -d ‘{ “name”: “Product name”, “sale_price”: “25.50”, “description”: “Body of text”, “images”: [ { “src”: “http://site.com/images/image1.jpg” }, { “src”: “htt…

I am trying to import data from a MySQL database and need to somehow also import fieldnames to be the fieldname in FMP. Is there anyway to do that? I have a CSV of the fieldnames and I also have a MySQL dump of fieldnames and associated data. Thanks for any help.

Using MS Access 2010. Filemaker 13 Pro, Filemaker 13 Server. I have a MS Access database that that I programmed to do a lot of calculations and creates data. Now I want that data saved in a Filemaker database. I was able to create ODBC connection to the Filemaker database. I am able to view the Filemaker tables/data in MS Access. At 8AM daily I want the Access database to do the calculations, and then insert the data to Filemaker . However every time I try this, the Filemaker Login Screen comes up. And I would have to manually enter the username and password. Is there any way to bypass the log on screen? Thanks in advance.

Good evening. I am using the API capabilities of Filemaker & BaseElements to extract, manipulate and collate data from a number of sources - that is all working just fine. What I would like to do is then have Grafana (running on a Raspberry Pi) to display the figures on a large television monitor setup as a dashboard. Grafana uses InfluxDB by default which is a database product as well - not dissimilar to SQL apparently. I am wondering if anybody else has connected Filemaker (push or pull) to Grafana or InfluxDB and what they experienced. I was hoping to have data updated daily. My first attempt had Filemaker exporting data to CSV file, it was t…

Anyone ever figured out how to bring in data from one of the Google Analytics APIs? I'd like to create aggregated reports across all GA accounts I have access to. You can do this in the Google Sheets using the Google Analytics Add-on but it's clunky at best for trying to get aggregated data together as it separates out each account onto a different sheet/table. Analytics Canvas (analyticscanvas.com) is another option but I'd really rather work with the raw data right in FileMaker. I haven't used FileMaker in years so I'm not sure how easy or difficult it is to connect it to external APIs like the ones from Google so any help in understanding whether this is reas…

Greets, everybody: I'm building an FMP (Claris) database that'll be housed on FileMaker's/Claris's web-based server (since we don't have in-house servers here where I work.) One of my supervisors asked is if there's any way for the database to integrate directly with other online databases--specifically, Campus Management's web-based Student Information System (SIS)--instead of my having to manually export data from Campus Management to the FMP database for import. Admittedly, I'm ignorant as to how this would work--through a plug-in? Using "Perform Scripts on Server" to query Campus Management's server for data? What questions should I ask the IT people at Cam…

I have a solution that connects to a SQL Server database. The solution has been in service for several years. I recently had to add a field to one of the SQL tables, but that field is not showing up in Manage Database. The SQL table is connected via ODBC as an external data source, and was added to the relationship graph. Is there some kind of refresh that I'm missing?? Thanks!! RESOLVED ... I'm blind as a bat. Seems there's a button called "sync" in Data Manager. Right in front of my face. Sorry. Will leave this just in case someone else is as blind as me. 🙈

I'm getting "The file "" could not be opened. Either the host is unavailable, or the file is not available on that host." This happens when a script runs. Not a new server, no new files. The file is actually open in the background. The file reference is just "file:". I restarted the server. Didn't fix it. FMS18.03 It's apparently intermittent. I copied all the script steps to a new script, then it worked 3 times, but couldn't find the file for the 4th time. Any ideas?

So, first of all I've done some searching and have seen some of the discussions regarding Fedex Ship Manager integration and I was wondering if anyone has successfully completed this? I know that NRG has a product and we are looking into that too... So, here's where I am... I've got the two systems connected and the fields are all mapped but when i go to do the lookup I get this error message. I was on the phone with Fedex for about an hour and they were no help. Can someone help point me in the right direction? Thanks Mark

Has anyone integrated FileMaker with Google Ad Manager, formerly DoubleClick for Publishers?

I am able to connect to the MySQL database via the ODBC/DNS/ESS on the Apache server and see the tables in the relationship graph. But when I try to use the script step Execute SQL the Data source is not available ?? And I need to create a record in certain table in OFBiz when the user create a new record in FileMaker. The related records do not create as they do within FileMaker related records. From manage external data sources FM; From relationship graph selection FM; From script step Execut SQL FM; I am unable to select the table within the script step for the Execute SQL ? any suggestion ... ?

We have a 12 year old SQL solution that we previously have connected with Filemaker via ODBC. This worked good until a while ago, and now I realize that the SQL database is on a 32 bit system, while all our filemaker clients and server are on 64 bit. The SQL database will be phased out within a year, so I really just want to connect to it, and get all the important data before it's gone. Thoughts I have a lot of Mac and Windows computers available as well as all FM versions back to v10, but before I test what's working or not I think it's smarter to ask you nice fellows, that actually might know this. - Is there any way to connect to a 32 bit ODBC databas…

I have a sales team and we are using FM to track our clients and sales. We have a server version that is hosting our solution. Each sales person has their own data file (ie. separate databases). We went down this path so that we can more easily manage the division of common and sensitive data. I am creating a 'Dashboard' where an admin user can view data from each database. I can do this manually by creating multiple External Data Source entries and adding the relevant tables in the Relationships screen under Manage Databases. Then I can add the fields I need into the various layouts. I am looking for a method to script the process of adding a new database …

I'm currently developing an inhouse application Using Visual Studio 2019 in the C# Language. We have had some great success in pulling data from Filemaker through ODBC. The basic way the application functions is that once a drawing has been opened and is being viewed, the end user would like the ability to click a button and open a filemaker window and have it open to a specific record. I'm not very familiar with Filemaker when it comes to development. I know VB.net and C# and a tad bit of JAVA. My question is what languages does Filemaker Data API support. I have seen some VB code in older documentation, but nothing since our company went to Filemaker Pro Advanced 1…

Hello all, I installed FileMaker Pro ODBC drivers, and was able to access the data with queries from Microsoft Excel. However, when I tried to access the same data with the same driver using Microsoft Visual Studio 2015, it could see the table occurrences, but it couldn't find any of the data columns. It came back with the following error: " Error at Data Flow Task [ODBC Source [1]]: There was an error while trying to get schema information. Table has no columns." I got the same error, no matter which table occurrence I selected. Has anyone else run into this and solved it? I have been google searching without much luck. Although I found…

My employer uses a hub and spoke system for time tracking. Staff use a local file from their workstations to record time entries, and then push that time up to the main hosted FileMaker database. These local files also download client lists and job lists from the main hosted database. When offline, spellchecking the local file hangs for some time as it tries to connect to the hosted file. The local layout has no fields from the central database present on it. All other functions of the local file work without issue when offline. Why won't spellcheck simply check the local record I'm working on? This performance issue is not major or debilitating. It's more like a roc…

Hi all Apologies in advance if this is a vague question, or if it's been extensively documented, but I could do with some basic advice on moving filemaker tables to SQL. In terms of database development, I have only really known FileMaker. We have a 60 table, 25 user FileMaker database which takes care of most if not all of the company's operations. There is now talk of allowing other platforms (such as PowerApps/PowerBI) access to the data. One such reason is other people are interested in making apps/applets that serve specific functions. This would be simple if the data were held on a SQL database. So if all the FileMaker tables were to be moved to…

Filemaker friends: I have been struggling for weeks to get my FM solution to post a CSV to an external service via a POST request to their API. I have successfully created scripts with the "Insert from URL" script step for simple POST and GET requests, but nothing that transfers a file. Here is the doc: https://apidocs.straticsnetworks.com/v1.1/reference#upload-new-phone-list Here is the URL in the script step: httpspost://api.ivr-platform.com/api/phonelistsaccount=xxxxxxxx&file="$file And my headers look like this: " -H \"Accept: application/json\" "& " -H \"Authorization: Jwt "&$token&"\""& "--dump-header $$dump"…

My issue here is this: I use the data separation model. I am opening a starter file and am creating the global variables for all my files here. Works fine. Now I want to pass the other file locations to all my files in a global variable so that in the external file references it reads file:$$locationofthatfile/file. My way of doing this would be to call a script from say datafile a from within my starter file (passing the global variables as a script parameter (in my case with assign). My problem is that calling the script, before it executes will open the file (hidden), all the $$locationofthatfile variables will fail and filemaker will lock in the…

Hi all, I have a full functioning Microsoft access database with front end and back end. the company requires user to have updated live information then out in the field and only want to be able to use IPads. Does anyone know if microsoft access back end can be used as a data source for IPad front end to update an update table in access before updating the master files? I am much more proficientt in access than file maker so for me to rewrite the program in filemaker at this stage would be impossible. The program needs to be able to run on microdoft, mac and IPad. so the front end is fine for the windows users but i need an interface for IPad.

Does anyone have experience and/or success using a 4D database as an external datasource through ODBC. I can add the system DSN and add it to FMP. Once I attempt to view the tables in the 4D database, I receive an error that the "ODBC connection is not compatible". Does anyone have a work around or suggestions? Thanks!

Hello! Our work shifts are (for some historical reasons) made and maintained on Excel. During years the number of employees has expanded a lot and so the number of working slots. It is VERY frustrating to find your own shifts from an Excel sheet. Unfortunately this data in Excel is very unorganized and almost chaotic. Now I have an idea that I could somehow import that data to Filemaker so, that I would not have to manually go thru every cell. The original Excel is a shared document in Google Drive. I can download it locally and modify it freely. So, could it be done combining Filemaker script, maybe Apple script and Excel Visual Basic? I'm not ver…

I have 2 problems, but first I'll give some background info. I have a FileMaker Pro 11 Advanced database hosted on FileMaker Server 11 Advanced (in a Windows environment). My goal is to migrate all the data in FileMaker to Microsoft SQL Server 2005 as a data storage back-end, and use FileMaker as a data entry front-end. I used the "FmPro Migrator 5.57 DE" (3rd) tool to create the tables in SQL Server 2005 and copy all the data from all the tables. I made sure that all tables and all the fields were transferred (same exact table names, field names, etc). I then setup the ODBC connection on the Server's host machine, and added the SQL tables as an external da…

Hi, i am trying to bring multiple Invoices from a database made by SQL as a Excel files. first when i save a invoice as a excel file and try to import it to filemaker , filemaker imported a blank. so i went to excel file and saved it and imported to filemaker , then filemaker imported the data. i feel like i am wasting a time. is this process absolutely necessary ? or is there a way to avoid this ? also for now i have to save every single invoices as a excel file and i am wasting a lot of time by doing this. i like to know whether it is possible that sql db developer can make it able to select multiple invoices and save it as ex…

In previous version of Filemaker I've been able, in the relationship graph, to 'add a Filemaker data source'. The dialogue, as in the image, after clicking 'Remote' showed only the 'principal' Filemaker file but I could replace the name with the file I sought to add manually. Now, with FM17 I no longer have this option. So, how do I add another of the served files as a data source? I suspect I am missing something simple

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 'ins…

I have a solution that has been working well for several months and suddenly broke. This may have been perpetuated by the last round of windows security updates. I have a list of orders displayed in a portal. The source of the portal is SQL Native 11 ODBC data. Consisting of a header table and several related tables. Clicking on a portal row will create a new Filemaker record and populate it with the related ODBC data. This will work for several hours and then un expectantly hang. The find window \ Find in progress \ Processing query window will appear. The copy cup will then appear. When this happens the database cannot be closed from Filemaker server. The ODBC data sou…

Hi all, It's me again.... I've temporarily gotten around my issues with "required value" fields in SQL data by adding a default value to all blank fields, however I have now found another error. I have a table of customers (BP_Details) which is retrieved from SQL server view using a DSN. I then have a local Filemaker table ("BPAddon") which I've linked to the BP_Detials table using a unique customer ID field. I wish to populate the records in the addon table via the Cusomter layout to supplement the data from SQL. As there are no records in the addon table I've selected "allow creation of records in this table via this relationship" on the ad…

Hi guys, I am trying to setup an external connection to Sage 100; From Windows I have configured the "System DSN" and it is able to connect and see 1129 tables. From Filemaker I am able to add the external data source without any issues. But when I go to Manage->Database and try to add table under data source I select the new data source and a popup asks me for a username and password but then it give me the following message "The ODBC data source you have selected is not supported" Can someone guide me on what it is I could be doing wrong.

Just a few questions: my database is now 85 gb and growing every day. What is the best way to back this up, is there a cloud service you would recommend? also, I have a table with a container field and it holds all of our companies pdf copies of documents. I’m considering storing that fields data on an external drive since it makes up the bulk of the 85 gigabytes. Is this a good idea or do you all have any recommendations? thank you!

Good morning. I am trying to use FM16 to extract data through an API. It requires an API key and string to be sent, but don't see where in the "Insert from URL" syntax how it can be applied - I think I have the rest of the syntax working ok though. The PHP syntax (according to the host support team) say it is: $curl = getCurl($id, $key, $signature, $endpoint, $requestUrl, $format); I have all the details (I'm pretty sure) except the signature. I'm trying to use the native FM16 functions if possible - just to minimise third party products (although BaseElements may be OK) Could somebody please give me a clue as to the correct syntax I should be using?…

Trying to connect to an ODBC external data source in Filemaker Pro 16 Advanced We have a windows 10 desktop with user DSN's and System DSN's specified, However the Select ODBC Data Source shows no entries? I have seen older posts saying that a System DSN has to be specified, but we did this and still nothing showing, is this a bug or am I missing a step.

Does anyone have experience using FM11 with SQL2012? I successfully established an ODBC connection between our FileMaker 11 Server database and a SQL 2012 database. I now have a live connection allowing us to exchange data between tables. However since FileMaker does not specify support for SQL 2012 should we be concerned with utilizing this connection? Please advise!

Hi all I'm trying to connect to an Azure SQL database from FileMaker 16. I've added the DSN via ODBC 32bit (see pic). However, when I go to File>Manage>External Data Sources, it doesn't show the DSN. Where am I going wrong? Thanks in advance

(This has been reported to FMI with no response thus far.) Filemaker 16 FMPA & Server Mac client, PC server Scenario: I have a client's "MASTER" file HOSTED on an FMS at a hosting company. I have a copy of that "MASTER" file on a development FMS at my office. After that copy was made I added a script to both MASTER files. (wrote it on one, copy/paste to the other) I have a LOCAL file that calls that script in the MASTER file. In my LOCAL file I set up the External File Reference to the MASTER file on the hosted FMS. I set up the script in the LOCAL file to call the MASTER file script on the hosted FMS. All is well. I then…

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 f…

i made solution master.fmp12 and made child solutions x1.fmp12 , x2.fmp12 and x3.fmp12 - i connected all 3 solutions to master.fmp12 working perfectly fine , x1 , x2 and x3 are locked with admin passwords - when i am opening master.fmp12 i am getting login forms of x1 x2 and x3 is there any solution so that admin credentials are auto entered into these solutions fed up entering username and password everytime hope i am clear plz help

I've just converted a bunch of *fp7 files (Filemaker 11) to *fmp12 files (Filemaker 16). The original files were spread across three folders, but I set the conversion destination to one folder. The issue I have is that every time I open Filemaker I am asked to re-establish the paths (can't find file etc) for all related files. After doing this initially I wasn't expecting to have to do this again. Is there a way to sort this once and for all? Everything seems ok when I look at the external sources. Already made one big mistake by deleting external sources for one file, then adding them again only to find the relationships were broken for good. Re-established th…

I am performing a query, and everything works well until I add a Criteria to my query. After adding the criteria and sending it to Excel, I cannot edit the query as all the menu options are grayed out and all I can see is the data in the table and not my original data. What could be going on here?

Hi, I have searched everywhere and could not find something I could apply to do what I am looking for. I have a Fire Dept database that I manage, they have a table of "Event Reports" for each call. Within our Fire Departments we have 14 towns that are part of a Mutual Aid Group which has a radio desk that manages large, multi resource incidents. I would like to develop a database to help them manage the resources at the incidents since a handful of departments are already using the database solution I host for them on a server. I would like to create a script that copies the values in about 6 fields on an Event Report from a townships database and hav…

Hello, I try to access to filemaker file from VBA in outlook, with ActiveX automation When the file is on my local machine, no problems. Set myOpenFile = FMDocs.Open("c:\myfile.fmp12", "login", "password") but I can't access to a file with IP adress ... Set myOpenFile = FMDocs.Open("xxx.xxx.xxx.xxx\myfile.fmp12", "login", "password") What's wrong ? Thanks

I'm not sure which area I should post this in: Does anyone have experience working with the NACHA file format for processing electronic checks / ACH? The end goal is to electronically process checks from within FileMaker to a bank that only accepts transaction data NACHA file format. Thanks in advance!

Hi. I'm trying to get an ODBC connection going to a wordpress SQL database. I have some chops at this, but I'm getting a full filemaker crash when I enter my user name and pw for the database. I'm running FMP ADvanced 14. And I might not have all the right drivers etc. I'm wondering if anyone can read this crash report to see what on earth is causing this. I have the right port, I have my IP address whitelisted... so I have permission to access dbase... this thing just crashes and is making me a bit nuts. Any help or guidance on what I should have for drivers running FMP AD 14, and Mac 10.9.5. Here is the bucket of code showing the crash. Thanks in ad…

Hi. I am trying to script the getting of some data from a website that has an API. I have BaseElementsPlugin and was given an example bit of code by the website: data = {'domain': domain, 'include_generic': True} headers = {'X-Api-Key': 'xyz123'} resp = requests.post('https://api.anymailfinder.com/v3.0/search/domain.json', data=data, headers=headers) I have never dealt with this kind of programming and am not even sure where this info would go or what script step(s) I would use to call this. Is this CURL? Are you aware of sample FM scripting that I could use as a model to figure this out? Thanks for any help with this!

We have a mysql table in FM 15.0.2.220 that seems as though it could be reacting to a FM bug. I don't think this field has been altered recently, but something changed on Oct the 7th, 2016. The field contains 1 to 7 lines of text. There are no extra returns after each line of text. Not in the mysql data. Not in Filemaker. Suddenly on the 7th, the data has an extra return for each line of text. Field format settings look correct. First part of the day it was like this: Line 1 Line 2 Line 3 Line 4 and then it suddenly changed to Line 1 Line 2 Line 3 Line 4 What could cause such a thing and what can we do about it? For now,…

Hi does anyone know of a tutorial or other instructions for connecting to Xero (cloud finance software)

How to get access db sync to filemaker. Every new records from access should appear or auto push into filemaker. Tq

I have Tableau 10 (64 bit) and FileMaker Pro Advance 15 (32 bit) . I am on a Window 7 platform, system type 64-bit. I want to use my FileMaker database as a data source for Tableau. Q1). Do I need to re-install FileMaker pro advance 64-bit version? Q2). So I'm thinking that I need to install the 64 bit ODBC drivers on my PC, right? Q3). the FileMaker website does not have the version 15 odbc drivers on the download page. Do I used the version 14? Any help will be appreciated.

I am using Excel 365 on desktop and FileMaker Pro Advanced 15 with FileMaker Server. I am able to connect to FileMaker from Excel using ODBC to read all records in a table or matching it to a hard coded name. Sample: Select work FROM "Student Time Import" WHERE badgename="Patrick Dollar" What I'd like to do is add a where clause where it selects hours worked based on the date in the Excel spreadsheet. The cell's date is B12 and so on. I know my syntax is wrong, but after several attempts, I haven't been able to solve it. Here is my syntax: Select work FROM "Student Time Import" WHERE badgename="Patrick Dollar" and date = TimeSHeet(Select * FROM[SHRA …

Hello I have a FileMaker customer who currently uses ACT for their CRM on Windows. They have a plugin for Outlook on Windows that automatically detects any emails that are sent to or from any of their ACT contacts and makes an entry in ACT to record that email. The customer would like something similar for the new CRM we are creating for them in FileMaker so that emails they send or receive are automatically recorded in FileMaker without them having to manually record it. Does anyone know of any Outlook plugin or other technique that could be used to trigger a script in FileMaker to record the email there if an email address used in Outlook matches one stor…

Hey Guys... suddenly, after several months, I can't add transactions to my mysql database. Periodically, I will offload transactions from my filemaker table to a mysql table (once the filemaker table has > 500,000 transactions). The import to the mysql table takes place in a script. I started getting a 729 import error on the mysql table import. (729 = Errors occurred during import...) So... I manually tried to import and -0- records imported. The "Import Summary" reads: --------------------------------------------------------------------------- Total records added / updated: 1500 Total records skipped due to errors: 1500 Total …

We have a database solution that is basically an accounting solution. We have a transaction table that stores all the transactions. This table contains millions of records. We have been dealing with speed issues for a few years where when we run reports, since it is such a large set of records, the reports take hours to complete. the Transaction table contains no unstored fields, but just the sheer size of the table makes the reporting a bear. We have tried storing the calculated values overnight so that the users don't have to wait for the reports to run, but sadly the stored values occasionally become inaccurate and cause obvious issues. the transaction ta…

Good morning, Having absolutely no knowledge on ODBC integration with Filemaker I am seeking help for the community gurus. I put together a database to keep track of printing jobs and so far its working fine for us. The issue I have now is that some of the data we enter in FM comes from out ERP (sage 200 4.3) and I would like to create a lookup that would retrieve this data via ODBC. We use filemaker server and FM 2013 for the end-users. I have the following questions. 1 - do I have to installed the Sage client on the server or do I have to have on each user? 2 - when I configure the ODBC do I configure it on each client or only on the server t…

Hello, I have a couple of questions around trying to get a stored procedure to work using the Execute SQL script step. 1. With that script step you need to specify a DSN and it looks like it's limited to a local user DSN. Is there a way to use the System DSN set up on the server so it doesn't have to be set up on every user computer? 2. Is anybody able to execute a stored procedure just passing parameters with the script step? We haven't had any luck with that or writing data to a SQL table with a stored procedure kicking off once the record is committed. I get an ODBC error with the trigger assigned. Once the trigger is removed, the data can be written to …

I am using an externally sourced table ("email") to fill a field in a local table ("person") using a secondary id. I have copied that external table and imported it as a local table. Same data, just on my local drive. I want to re-target the data in the person table to point to this new local version. I not quite clear on how to do it so that the data in each person record stays the same. Any help would be appreciated!

I've got a strange case on my hands. Here's some background: I've got an ODBC connection to JD Edwards Enterprise 1 (Oracle DB). I have a layout that shows fields from the RMA Line Items table. There's a field at the top that lets you find by RMA number, then the matching records (found via self-join relationship) are displayed in a portal. This has been working well for years, and then one of our users stumbled across a record that couldn't be found by FileMaker, though it definitely exists. The problem seems to be limited to one specific RMA number. If you go into Find mode and enter the number, FileMaker says there are no matching records. However, if …

Hi Board! We've just installed Sage 200; from Sage 50. So, now we have an SQL platform database to run our company on, moving up! We use FM and FMS to add function and output. Sage 200 will take over some of this; but we have Shipping and Inspection systems we've built that need to read data from Sage. The DSN has been setup and is working. The usr and pwd work. I can add a table to my FM database schema, go and select the data source and place/add a table. But there is no data inside any of the tables; and there should be. Anybody got any tips for me? Thank you!

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 happe…

Hi, I'm using Active directory to differentiate between my user accounts and their privileges. I was just wondering if there was a way that filemaker can identify a person (User Table) based on their account name so I can pull their details (name, Department etc) into a layout when they log in without having to store the username in a field in the user table which then links to a global table storing the login accountname. TIA Ann

Please help, We had upgraded SQL 2008 R2 to SQL 2014. Our FM 13 application use to connect to SQL 2008 r3 with an ODBC connection without any problems. Now I found it very difficult to connect to SQL 2014 as it could not see the DSN at all. I did try the same with FM14 and this seems to work fine. Is there a way of connecting FM13 to SQL 2014 before we upgrade to FM 14? Thankk you very much in advance.

Hi, I have downloaded every drivers and created an ODBC FileMaker but I would like to know if someone had a code example of a connection between a java program and Filemaker (I'm ok FM pro 12). I mean, I would get some information from my FileMaker DB but I don't really know how to connect :/ Thanks !

Good day, just wanna ask how to connect to MySQL Server not using ODBC with BaseElements plugin from a script in Filemaker where i can put on a "OnFirstWindowOpen" script trigger or any plugins available?.

Good day, Can I use a Pervasive.SQL as back-end database in Filemaker? We have an accounting software called Pastel which uses Pervasive.SQL, now I want to share the existing database between Pastel and Filemaker. The purpose of doing that is to add new orders, invoices, quotations etc in Pastel, then allocate approved orders to different working bays in factory using Filemaker. Is that possible at all? The Pervasive.SQL is on a server machine and users would open it in their Filemaker pro on their PCs. Regards,

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

I'm trying to build a script that will find certain records and FileMaker is crashing as soon as it tries to execute the script, i.e., before it even gets to the first script step. First of all, Jobs is a shadow table that exists in an MSSQL database that's being accessed using Actual Tech's ODBC plugin. CachedJobs is a local FileMaker table. There's a relationship from Jobs to CachedJobs using an unstirred calculated `hash` field in Jobs matched to an indexed `original_hash` field in CachedJobs. I want to find Jobs records that have no related CachedJobs records (indicating either that the job is new or that it's changed and needs to be updated). Here's the scr…

Hello, I've created a DSN from the server hosting FileMaker Server 12, and using the 64 bit ODBC driver that comes with our accounting package, MAS 90. The connection tests successfully and all seems well with the DSN. It is seen by the solution and added successfully as an external data source. But when I attempt to actually add a table from that data source to the table occurrence graph, I get an error that states "The ODBC Data Source you have selected is not supported." Is this just a case of FileMaker and MAS 90 being incompatible, or is there something else I'm missing? Any suggestions? Thanks

Hi guys, Is there a way to connect an Advantage Database Server (ADS) with FM as an ESS? Anyway that can do the job done such as a ODBC wrapper, a plugin, JDBC. Thanks in advance!

My layout is connected to a MySql table and when a time it '00:00:00' it wont display. I have tried different data formatting options. Not sure what the issue is.

I've got a file that contains several external data source tables from a JD Edwards EnterpriseOne (Oracle 11g) database. If I understand correctly, FileMaker doesn't just execute a query via the ODBC connection, but rather downloads each connected table in its entirety when the file is opened. Is that correct? The problem with this is that the JDE tables are very, very large! Each one can have a large number of fields/columns, and thousands of records! This means that a ton of superfluous data must be transferred over the LAN. (I only need a couple fields, and only from records that would match a WHERE clause.) This makes the FileMaker file very slow to load, and v…

HI all, I am a novice with ODBC. I am trying to set up an ODBC access and am having a bit of trouble. Perhaps someone can steer me in the right direction. My set up is FMS 13 on one dedicated machine. And FMPA 14 on several other machines. On the server the ODBC Manager succeeds in establishing a "system DNS" with access to a given file. However on the other computers I get this message I have given read and write permissions to the file odic.ini and its enclosing folder and yet I keep on getting this error message. I have installed the latest ODBC drivers, opened port 2399, installed the latest FM updates for xDBC in their various versions. I'…

I'm at a loss, or maybe I overt-thinked this or missed the obvious answer. I have a Filemaker 13 Database on a Filemaker Server. I also have some additional data in MS Access. A user has requested to show some MS access data on to the FM database. So I created a ODBC connection. and connected it to my test access db. Attempt #1: I created a test FM file. I started with "Import Records"-> "ODBC Data Source". I selected my Data Source. It asks for Username / PW. I get to "SQL Query Builder". BUT: when I select the table, the Columns' box does not fill in. I checked the Access DB and gave "Users" Administrator Access. but still this box does not fi…

I have a FileMaker database that contains text with special characters such as accent marks and bullets (Example: • Chicken Liver Paté). Whenever I try to create a record in the MySQL database via an ODBC connection I get an error if it has one of the special characters. I am pretty sure that this is an encoding issue. I have tried changing the encoding settings but so far I have not been able to resolve the error. >>> Here is the exact error: ODBC communication/link error. Please check your network connection and/or database server. I am a novice with MySQL. Can someone please tell me how to fix this?

Can I create web hooks with Filemaker to communicate with a service like Zapier? https://zapier.com/blog/how-use-zapier-webhooks/ If I create a web hook, does my application need to live on a server, or can it remain local?

Hello all, Happy New Year and all that! I'm back at it already and have hit my first hurdle with using ESS (now the DSN is working that is!) I have several SQL views on a read only DSN which I'm pulling through to FM. The first view has data relating to our customers and this is pulled from our ERP, which is the system of record, hence the data is read only. The problem I have is that there are four fields that are showing as "required values". The first 3 are indeed required and will always be populated, the fourth (ID of parent account) however is only likely to be populated about 10% of the time in the ERP data. Of course when I edit any local fie…

Hi all, This is my first post in the forum - one of no doubt many to come! I'm working on my first solution and as part of that I'm pulling in data from a SQL Server 2008 database which will be augmented by file maker tables. I have been able to locate the DSN and setup the External Data Source, however when I try to add the table in the relationships screen I can only see the system tables in the SQL database - not the views and tables that I have setup. Does anyone have an idea of a possible solution for this? Running FileMaker Pro Advanced 14 on Windows 7. Many thanks, Tim

We have a client that maintains a fairly large data warehouse on Amazon's Redshift service. We're now being asked to build a FileMaker solution that will access that data. We have the FileMaker solution built (hosted on our own FileMaker Server 14 server) and we now need to access the data on Redshift. Does anyone have experience connecting via ODBC to Redshift? Is there any documentation on that yet? We feel like we're close, but the Amazon documentation doesn't know about FileMaker, and the FileMaker ODBC documentation doesn't specifically mention Redshift so we think we're just missing something. Advice on how to set up FileMaker to access Amazon Redsh…

Thanks for taking a look at this. I use an Excel spreadsheet as a safe data import device for the database I use to help my wife run her bakery. Basically, non-tech folks can fill in the spreadsheet with costs and other data. Then FM12 runs a script to delete its current data and pull in the accurate new data from Excel. A different script then turns that data into formatted reports that can be used to re-order items and calculate prices. It works! Go figure. Now, we want to switch to having the spreadsheet live in Google Docs. I see that OBDC can handle that. It seems like I might need to buy something like this: http://www.rssbus.com/kb/art…