Search the Community
Showing results for tags 'mysql'.
-
Hi all, I'm current running a script on FileMaker Server 2024 every 15 minutes. It starts by going to a layout where the primary table is an ODBC connection to the MySQL server of a website (left side of image). On the layout is also a portal (right side of image) which is the relational data i...
-
I would like to know if anyone has done this and what steps they advise to convert a Filemaker Database to Mysql. Right now I have a Filemaker host that publishes my database and I have created CWP webpages for my clients to access and interact with. I would like to eliminate Filemaker and have all...
-
2-16-2022 - Fremont, California - .com Solutions Inc. announces the availability of FmPro Migrator Server App Builder. This next generation of the FmPro Migrator product line builds single-user and multi-user runtimes from FileMaker Pro 19 databases. With this new SaaS option, we will move your...
-
How to Build FileMaker Web Apps for High Traffic using MySQL Backend and 360Works MirrorSync Why Sync FileMaker and MySQL? FileMaker is the best tool for rapid application development, but it is not the most reliable or scalable option for high traffic web sites. MySQL provides that re... -
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 r...
-
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.
-
We have a complex MySQL and PHP; multi-tenanted application which we are now looking at syncing to an offline portable FileMaker model. I have essentially solved every problem thus far and have MirrorSync running properly. My challenge is this: Our main MySQL database works in tandem wi...
-
We have a complex MySQL and PHP; multi-tenanted application which we are now looking at syncing to an offline portable FileMaker model. I have essentially solved every problem thus far and have MirrorSync running properly. My challenge is this: Our main MySQL database works in tandem wi...
-
I am running a server side script that attempts to update records in a MySQL table that is set up as an external data source. It runs without issue for hours to weeks at a time then gets hung on error 512 (Record was already modified by another user). The problem is that I can't figure out how to ca...
-
Hi, accessing external SQL resources from within FileMaker is quite common. But how do I go about the exact opposite? I have an import_nwde:: table in a fmp12 file hosted on FMS 15. I have switched on ODBC in FMS. I can access the tables with Windows and Mac (using the Filemaker...
-
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...
-
Hi, I have FileMaker 11 and I created a interface to pull data from my website's sql. I am able to change the name of a product, but I cannot change the price of the mysql table through the FM 11 interface. Is there something I miss doing? I am using odbc to connect. Thanks.
-
This is about a Filemaker Server <--> MySQL sync setup. I have two fields, serialNumber and writeBackNumber, and an altogether separate primaryKey that isn't used for this part. If I create a new record on Filemaker, everything is fine. the serialNumber is auto-incremented on record creati...
-
I'm in the middle of upgrading from FM11 to FM13/14 and found sets of data will not import to mySQL correctly. Instead of the found set importing, the whole table gets imported. I get the same result on FMPA 13 and FMPA 14 32 bit. FMPA 14 64 bit won't even import at all. This process has been workin...
-
Hi. Some years ago I used FM7 to control a large 'one table' database, but now having acquired FM13, would like to do far more. However considering what I would like to do, videos on Youtube appear suggest that knowing the language behind FM would be very advantageous. What language lends itsel...
-
Hello, I have a FM13 Database hosted on a FM13 Server which has an ODBC connection to a MySQL Database. I could connect my FM13 Pro client to the Database and use my MySQL Tables. My problem is I need to modify/link the Project starter solution's database tables to the MySQL tables but I can... -
Hi everybody, I have trying to combine data from a MySQL source with my local FM database using a shadow table with ESS connector. Basically I have done a Point Of Sale (POS) that gets the data from a MySQL database (it contains the information about the products, prices, stock, etc). I have two...
-
I have been using Filemaker for many years, but just recently connected Filemaker Pro 12 to a Wordpress database with ODBC and am confronted with trying to extract data from a meta_value field. I don;t have a clue!!! Do I use EsecuteSQL? Here is the example: I have a meta_key of custom_f...
-
I'm trying to connect to MySQL server via ODBC. MySQL views are only open to analyzer such like us. However, it seems most of those views don't contain primary unique key. So it keeps showing the error below. "The selected columns contains some non-unique value.... " Is there any anothe... -
Hi All, Here it is my (wannabe) solution: A) One FM server 11A (Win Machine, unspecified so far), on the local Intranet, few clients (6) online One FM Server 11B (Windows Server 2008 Machine), on remote server C) One MySQL server on the remote server D) 2 distinct Databases (filemaker 11 and... -
Hi, I am a Filemaker developer,and I work through Fiverr, so it is a safe place to order something you would like done. Here is my link: http://www.fiverr.com/christoalberts And here is my website. http://filemakerecom.com
-
Filemaker docs say to call for a Refresh Window from a script to refresh the data. IT DOESN'T WORK!!! It only works when the script ends, but I need to alert the user ONLY when new data has arrived. AFTER the script runs, then the new data arrives!! My best solution so far is to have the first... -
Does anyone have any tips for renaming fields that are connected through ESS? According to the ESS tech brief, it seems like this should be possible without an issue: So if I'm just renaming the field, the unique key should remain the same, right? When I tried it and synced the tables agai...
-
Database Application Lead: FileMaker Technology Team Location: Devon/Philadelphia Area, United States Relocation assistance is provided Is this you? You love staying current with latest technology, mobility and social media trends. You love mastering skills, whether it’s playing drums on the... -
I want to know if FM Server 12 can update a external MySQL db in the same manner as the client can using ODBC connection (ESS). It works great when running the scripts on the client, but seem like it won't work in the same manner via server and server scripting. I am using all relevant drivers and...
