External Data Sources

I'm accessing Oracle Database Server via ODBC. Then I added three tables to FileMaker from Oracle DB. These tables are related such as below 1. Customer (customer_id) 2. Receipt (customer_id, receipt_id) 3. Item (receipt_id, item_id, item_name) note: Items belong to Recept, and Receipts belong to Customer. I built a portal in order to show the detail about when, and what a customer bought by reffering purchase history. Then here's a question. I'm on Customer Layout(showing all Customer records) In spite of the fact that the customer has purchased something before, nothing appears in portal It should show the date of purchase, and the name of…

All, I am building a solution which requires ESS connection to Oracle 11g from FM12. Got the ActualTech Oracle ODBC Oracle Driver. Setup went fine. Managed to do imports from Oracle using the Import Script Step. Can display ESS Shadow tables from Oracle in the FM Relationship graphs. However: * when doing so, FM tells me that the External Table "does not provide a pre-defined unique key" and asks me to choose a field or field combination to identify the same * All relationships i perform involving an ESS table display the 'T' cardinality symbol implying that the match field has no index information. The subsequent problem is obvious : performance as we…

I'm calling Oracle's Database through ODBC. It's working fine except speed. One table has over 100 million records. When I'm seeing this table in FileMaker, it takes forever to load its layout. How does everyone handle this kind of problem? note: Oracle Database Server is located at different location(500 miles away from this client)

I have a solution which has been running for years on filemaker 8 advanced server where I send HL7 messages to an from filemaker server using 'Mirth Connect' connecting to the filemaker server using the ODBC and running a very simple SQL and sending the result out using a LLP connection SELECT x FROM y This is all fine.. But, now I'm setting up FM 12 advanced server, and have all the up-to-date ODBC drivers which all connect fine, and have been tested using excel. The connections are being made to the fm server as I can see the connections in the logs (so I guess the ODBC connection is okay), but it will not run the simple SQL query above. Has somethin…

Hello all I am currently invoived in a large project to link up a database sitting on a windows server with a filemaker database sitting on our own office server we are using. Filemaker server 9 Advanced running on Mac Leopard Server. The windows server has Windows Server 2003 and is using the filemaker ODBC driver. DataDirect 32-BIT SequeLink 5.5 The webmaster is using a standard connection string Driver=DataDirect 32-BIT SequeLink 5.5;Host=IPadress;Port=2399;LogonID=Logon;PWD=password;ServerDataSource=database file name Where the ip address is the external static Ip address of the router, the logon and password are the login and password for the databas…

I want to create FileMaker app with GSX (Global Service Exchange) Apple. I am the part of Apple Service Provider. This is the Apple GSX API link https://gsxwsut.apple.com/apidocs/it/html/WSReference.html?user=asp

I have set up a System DSN to a SQL Server database and ODBC connection is fine when I do the Connectivity Test and I can go into excel and pull records. When I'm in Filemaker, however, I don't see all the tables -- All I'm seeing are system tables and I have all 3 boxes checked in the Filter tables area of the "Edit Data Source" screen in filemaker. At this point I think it's something in Filemaker since I can pull the record set in Excel. I'm just fishing for some ideas or things to check that I may have overlooked. In the ODBC setup I'm dynamically checking the port number and I'm even selecting the "Change the default database to" the database I want …

From our observation it matters if odbc user uses local or external server authentification. LDAP user connection(login) is MUCH faster than via local account. Can anyone confirm this behavior? Thank you AD

I cannot seem to be able to import a windows txt file into FMP without converting it to a mac txt file. Is there any way to import it directly?

Hello! I'm use FileMaker 12 PRO Ad for access to filemaker base throughout ODBC. When i use query Select * from Invoices WHERE Date>'2013-03-15' I get error message (Microsoft OLE DB Provider for ODBC Drivers): [FileMaker][FileMaker] FQL0001/(1:30): There is an error in the syntax of the query. How use "Date" in query? Thanks!

When I try Importing a file that is CRLF UTF-8 in OSX, the file is not recognized. I've tried various settings, but none seem to work. If I change the file to CR or LF, then it works just fine. Am I missing something? Thanks, Fed

Hi, I'm running a solution which has three parts. Main Application - on FM Server 12 SyncArea - on FM Server 12 Mobile App - on FM Go 12 Functionality: 1) Main App is exporting data into SyncArea 2) mobile App is importing data from Sync Area --> offline modification --> export back to SyncArea 3) Main App is importing from Sync Area Everything very straight forward and works well as far as mobile app is within the office LAN and has access to Server. If there is no LAN connection it seems FM Go is crashing sometimes when iPad is hibernating, even there is no explicit access to SyncArea triggered? Do I get something wrong, in general? I…

Hi, Any one tried to upload, edit and delete a record from Filemaker to Google Fusion table? Please let me know if any one has a clue. Regards, Tusif

Hi, Just a quick question. Does Filemaker has removed OLE object linking in Filemaker ? I have in Edit object > Show objects (which is not active). I want to link another program. Does this will work in container field, if yes, please let me know how I will do this. Thaks Regards, Tusif

Has anyone had ANY experience connecting to an Archibus database? Supports native Microsoft SQL Server, Oracle, and Sybase

I am writing a script to periodically update my product catalog in MySQL using data from FileMaker. The MySQL tables have been added to the file. The encoding of the MySQL tables is UTF-8. The method I am using right now is: 1) Find records that I want to be copied to MySQL 2) Go to layout of MySQL table 3) Import records This works well in most cases but problems occur if the product contains a special character like "™". "511™ Slim Fit Jeans" goes into the MySQL text field properly if viewed from Sequel Pro, but in FileMaker, it reads back in as "511 1 1 1 1 1 1 1 1 1 1 1 1". Another example: If I type "Sample™ Product" in a MySQL table in FileMak…

Having an issue with SQL UPDATE and FileMaker. My solution accesses several existing SQL tables via ESS. I have succesfully created scripts that access existing stored procedures in order to pull data or insert new rows. The trouble comes when trying to UPDATE rows. The SQL rowversion value is required in order to execute our stored procedeures that update rows. IOW, in order to update the row, I have get the existing rowversion value, and pass it back with the updates. However I can't seem to access the rowversion column via FileMaker. It exists in all of our SQL tables, yet is not avaialble in any FileMaker ESS shadow table. I have not been able to return a row…

I am having rounding issues with MS SQL Server tables linked as an External Data Source. The decimal(18,4) field in the SQL table contains "118.4897", but in the FileMaker layout, it displays "118.49". I checked the data formatting settings of the field, set the format to Decimal and the set the "Fixed number of decimals" to 4, but it still rounds up and only displays "118.4900". Also, if I enter a new value into the FileMaker layout, say for example "123.4567", it will save "123.4567" into the SQL table and it will display "123.4567" in the FileMaker layout. But if you switch layouts and then go back, or refresh the page, it displays "123.4600". I know one workaround…

I work for a lawfirm and we are contemplating purchase of document assembly software - HotDocs to be specific. We currently have a case management system built in FMPv11. Has anyone had experience working with FMP (database) and HotDocs (doc assembly) together? If so, any pitfalls or incompatibility issues? Below is from HotDocs' website. I'm assuming/hoping it will work. To connect HotDocs with a database, you must have one of the following applications or servers installed: o Microsoft® Office® Access o Microsoft® SQL Server o Oracle® 8i or 9i with the OraOLEDB OLEDB provider o Most other ODBC-compliant databases

I would like to create a database for our school district that would allow teachers to post the "Link" from the iTunes App Store database into a field in FP12, and then the FP12 database would access the other fields from iTunes (Name of App, cost of app, category, etc) into fields in FP12. Then teachers would only need to open iTunes App Store, find their app, copy link and paste into a new record in FP12. Add their School, Grade (or Course) and Teacher Name to post all the apps required for students to download to their iPads. Students would use FP GO, Enter their School / Gr (or Course) / Teacher and a list of Apps (with their links) would be presented for them…

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…

I have a FP12 database where I am using our SIS database (Infinite Campus) tables. In FileMaker relationship, I want to find classroom rosters. The relationship I have setup between FileMaker and a roster table from IC is: Globals <-> dbo.Roster SectionID = sectionID and Null = endDate In Infinite Campus (IC), when a student drops a course, the endDate field has the date they dropped, otherwise the field is empty (null). BUT, it appears that FileMaker will NOT match a "null" field. If the field in IC does not contain anything, it will not match a field in FileMaker that does not contain anything (is null). Is this a bug, or just …

Sooooo close, yet so far... Here's what I have: "SELECT ATTENDANCE.ATT_COMMENT,ATTENDANCE.ATT_DATE, ATTENDANCE.ATTENDANCE_CODEID, ATTENDANCE.ID, ATTENDANCE.PERIODID, ATTENDANCE.SCHOOLID, ATTENDANCE.STUDENTID, ATTENDANCE.TOTAL_MINUTES, ATTENDANCE.YEARID FROM ATTENDANCE JOIN STUDENTS ON STUDENTS.ID=ATTENDANCE.STUDENTID WHERE ATTENDANCE.YEARID=22 AND ATTENDANCE.PERIODID>0 AND (ATTENDANCE.ATT_DATE ≥ MAIN::ReportFromDate__gxd AND ATTENDANCE.ATT_DATE ≤ MAIN::ReportToDate__gxd)" The query works fine up until the blue text--I'm trying to filter records outside the date range from being downloaded. I tried using the BETWEEN SQL command but I didn't have much luck w…

Hi! I wasnt sure where to put this but I hope it will do alright here. I am using the plugin reactor fusion so customers can make bookings, and its working so far.. its just 1 thing that needs to be fixed so they can start using it. when they CREATE a booking the web viewer should automatically be updated. I assume I should use the parameter actiononcreate? but since I dont have any experience with java or something I cant fix that myself. Can anyone help me please? Really appreciate answers.

Hi, I had a filemaker application that used to scan a batch of csv files as imported data into tables that further analyses the data. Since the filenames change everytime, and since there are quite a few, I don't want to manually enter every filepath that needs to be imported. The application still works well, but to get the input (that is generated by another program, not filemaker), I had to first create a "list.bat" file that would generate a filepaths list in the other program's output directory, simply to create a list of the csv files that filemaker must analyse, among other files. (one single command line was used: dir > list.txt or something like that.…

I have 2 tables, One ESS SQL table and one Filemaker table related by "shop_product_item" ID. Table A is set to "allow creation of records...." in Table B (related throughout table occurrence shop_product_item15....) Table A. name = "shop_product_item" (SQL Ess connection) Field A1 - "is_published" (Auto enter calc - "Case (shop_product_item::in_stock = 0 and shop_product_item15_ShopProductItem_ID::z_unpublishAtZero = 1;0;1)" Field A2 - "in_stock" Table B. name = "ShopProductItem" (Filemaker table) Field B1 - "z_unpublishAtZero Problem - when SQL Table A > Field 2 "in_stock", changes to zero, Field A1 -"is_publishe…

Hi, I'm using 64-bit ODBC to read/write data from/to filemaker. I have some problems with timestamp data type. Writing is working correctly: INSERT INTO ScriptChangelog (SaveTime, Message) VALUES(time, msg) The SaveTime value (timestamp) is corretly stored in db. Reading of SaveTime is not working: SELECT SaveTime, Message FROM ScriptChangelog The Message is OK, SaveTime is empty. Note that date or time types are not working too... The client is a program written using Qt5 library for ODBC access. So don't know if there is a bug in FM12 or the client part... Has anyone expirienced this problem? Thanks for help

I am attempting to setup a connection to a remote mySQL 5.1 database. We are running FM Server 11 on a Windows 2003 server. I have set the DSN up successfully. When I attempt to add a table occurance of the remote database within FM, I can see the database tables of the remote database. However, when I choose the table to add to the graph, not only does the database I am working in crash, but it crashes the entire Database Server. I have attempted to connect to different tables in the MySQL database. Same result. I have rebooted the server. Same Result. Is there a log file that I could pull that might hint at the issue? Does anyone know …

Hello! I am Using Filemaker Server 12 on Windows 2008 R2, Filemaker Pro on Windows 7 and a MSSQL Server 2008 on Windows 2008 R2. My goal is to configure Filemaker to use Single Sign on to the MSSQL Database. On the Filemakerserver machine i created a System DSN with Windows Authentication enabled. I enabled External Authentication in the Filemaker Server and in my Filemaker Database (hosted on the server) i added a Group with type "External Server" and "Full Access" rights and added the privilege "fmapp". At this time i can access the Filemaker database without authenticating. Everything until now seams to work correct for me. Now i run "Manage External Data Sou…

Hi, I'm getting some output from a vendor called Fillz and it's coming to me in text form as follows. I'm running a pricing script on their server. (Note: I have put a return between record sets though there isn't one in the real output. There are 7 "records". The first number is the SKU (Stock Keeping Unit) I want to see the info as follows (in FMPRO) I just don't know how to separate it out. SKU: Base Price: Condition: Floor: Sales Rank: Total Offers: Lowest Six Offers ( If I can separate out each of the lowest six offers into separate fields ie: (Lowest Six Offers P1, Lowest Six Offers P2, etc.) Price: New Price: Change at Amazon: 07…

Hello , i want to know if its possible to update a Filemaker database records with a plain text file every day . i need this solution automatic updates . please let me know thank you very much

I had developed an external data source for all my data. Worked fine. Took application over to a MacBook and tried all sorts of things, something finally worked and application ran fine. Closed, re-opened...files missing (all). Could not re-connect EDS. Cam home and tried the same thing...could not reconnect once I had erased the EDS and then re-eatablished it. (Trying to replicate problem. Now I can't connect via EDS nor can I import tables into my file containing Layouts. Any tips appreciated! Ron

We've got a Filemaker 'robot' applications which is used to transfer staff holiday information from a mySQL database into a Filemaker database, where the information is used for scheduling and planning. The robot users a Filemaker Client 11.0.3 (running on Windows XP Professional) which is triggered by a Doscript plug-in (legacy reasons) to run every morning at 2:00am. The database is hosted on an FMP11 Server Advanced on Windows Server 2008. The robot uses an ODBC connection to the mySQL server, and a number of the mySQL tables are exposed via ESS in the Filemaker database. Every night, the robot makes local copies of these tables in the Filemaker application by runn…

hi, I installed FMODBC_Installer_Win32FMODBC_Installer_Win32 and when I was trying to connect mysql through filemaker it was crashing filemaker. Than, I thought it would be good if I use Ver. 12 odbc driver. I tried to Uninstall ver 11, but I was not finding any way to uninstall this. I am trying to find in windows add/remove programms but its not there. I removed through regedit commands of filemaker odbc but still I can not install version 12 odbc. Whenever I am trying to install, Its saying, you have already old version, remove the old and install verion 12 odbc. Can any one tell me what is the easiest way to Uninstall Verion 11 ODBC so that I could be a…

I have searched the problem and found quite a few posts, but they all the seem to be related to the 32/64 bit issue. However, I am having this issue on two different 32 bit machines. It is MySQL v5.1 and the System DSN works perfectly, but when trying to setup the ESS it simply does not show. What could I be missing? Both the OS and FM client are 32 bit Also, the source database is hosted with Server, but I am defining this on a client. The odd thing is that there is one DSN showing that is a SQL Anywhere souce, but the odd thing is the name is all lower case, but in the ODBC Administrator it is proper. Also, the one source showing does not match a source on t…

Hello, we're experiencing a problem that has up stumped: When attempting to make a relationship to table on a MySQL database interactively via the relationships graph, Filemaker crashes. :-( Some details: The latest MySQL ODBC driver is properly installed (mysql-connector-odbc-5.1.11-win32.msi) The MySQL edition is MySQL Community Server 5.1.66 The DSN connection has been established, and the tables can be seen and selected, but when a relationship is attempted Filemaker simply crashes and it has us really stumped. Any advice, questions, guidance?

Hello, I would like to interact with SQLite databases to/from Filemaker Pro 11 for Mac using ODBC. Actual Technologies has told me that their drivers work for MySQL, Oracle, Microsoft SQL Server, but not for SQLite, and that the solution from their viewpoint is for Filemaker users to lobby Filemaker to allow this functionality. Does anyone have thoughts about this? Thanks,

First off, here is my server setup: Server 2008 R2 x64 FMSA v12.02.232 Now, onto the problem. I have a script step in my solution that connects to our sql server to import a record. I have FileMaker Pro Advanced installed on the server for testing purposes. I installed and setup the ODBC to connect and it works just fine in Pro Advanced. When I try to run the script as a schedule in Server Advanced, I get errors 401 and 802. Any ideas?

Hello , can i sync my filemaker database with a ms-dos database? i usually have to see the MS-dos reports and retype in Filemaker ,, i would like to know if there is any solution that constanly sync the ms-dos records to my filemaker solution. thank you , mauricio

Hello , im new i have a question why can i read the data of my sql server tables? I create a fmp12 file and add the external data source, when i click the acept button, it loads all the records, but if i add another record direcly to the database using navicat , mi fmp12 doesnt sync, do you know what can i do?? at my fmp12 file i added two fields called id_usr and user (the same as i have it in the sql server database). If i add a record on fmp12 the sql server database didnt update to the new record. Sorry for my english! Thanks in advance!

I had added shadow tables from mysql tables on filemaker 12 but I realize some fields will be missing. Datatype like bits and mediumblob, is that normal? Ok I realize those 2 are not supported but I changed bit to tinyint, the field still do not appear.

I'm trying to prefix a unique serial number (generated in x1 MySQL table) with a text string (in another MySQL table) and zerofill the integer so that the VARCHAR is 13 characters in length - via the use of the ExecuteSQL script step. In MySQL I can create the serial number (ID in serial table), get the LAST_INSERT_ID() in that table and then pass the value across to the second table serial table; serialID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY (serialID) products table; serialID INT(9) UNSIGNED ZEROFILL NOT NULL productID VARCHAR(13) PRIMARY KEY (serialID) Query example; INSERT INTO serial (serialID) VALUES (NUL…

As a newbie to MySQL and EDS techniques, I have set up MySQL locally on my PC and am able to see the x4 tables and the x1 view that I have created via an ODBC data source in FP12. My problem is that I can bring in the tables into the relationship graph, but when I try to bring in the view (which includes 38,000 rows) FP12 crashes. The view appears to perform normally in the Command Line Interface. Am I doing something wrong? A quick relply would be very much appreciated.

We have imports set up via ODBC from an AS400/iSeries database into Filemaker. After upgrading and converting to 12 from 11, the tables no longer show in the query builder. The 64/32 bit solution did not result in the tables showing up again. SQL queries can be written by hand, but you need to know the names of the tables and fields, which we don't always know. Has anyone else seen this and found a solution?

I am trying to use Mirth as a hL7 interface for placing data in a filemaker medical database. I am using FMP 11 with mirth on the same computer. This is done via the JDBC driver. When I use the same computer, I can get the test data to enter the filemaker database. When I send an hL7 message from an outside computer, I am having difficulty getting the message into the FM database. I use "HL7 Inspector" send the test messages. Do I need to use FM Pro Server Advanced or can I just route the message to Mirth and depend on Mirth to place the message into FM locally. I am trying to avoid the expense of FM Server advanced. Thanks, JR

After much Googling, I got a FileMaker 12 system to connect to a MySQL database and created a shadow table in FileMaker for one of the MySQL tables, but when I try to serve the file, after being prompted for data source credentials, I'm greeted with the following message: "ODBC Error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application" This when logging onto the served file from the same machine or a remote machine on both Windows and Mac OS X. Details: The server is running Windows 7 Ultimate and is 64-bit. I installed the 32-bit MySQL ODBC Connector 5.1.11. I added a System DSN C:\W…

I have a FileMaker database that mirrors an SQL one on our website, and I've integrated the SQL database into the FileMaker one via ESS. All is working pretty well, but when I try to import a subset of records from the ESS table into the internal FileMaker table, it ingores the found set and imports all records! I was certain that I'd done this successfully before, but I'm a bit stumped now, and think that perhaps I was dreaming. Is this normal behaviour, or should I be able to import a found set with no issues? If so, what could I possibly be doing wrong? Thanks in advance, Kev

I have a problem with a date find in a MS SQL related table. The user types in a begin and end date into two global fields, where I have a script put the dates into global variables. My script enters find mode and puts the two variables in the SQL date field for the search. Here is that part of the script. Set Field [TimeEntry::TEDate; $$BeginDate & “…” & $$EndDate] The script seems to work find bring up all found set records including the TEDate (s) for the range. The problem is that I get more records in my FileMaker layout then if I do the search using a SQL query directly in MS SQL Server Express 2005. Is the problem because of SQL’s date f…

We currently are using : MS SQL Server 2000 SP4 (8.00.760 ) and the driver I currently have is : Microsoft SQL Server version 6.01.7601.17514 The Filemaker site says for FM Pro 11 and Pro 11 Advanced : MS SQL Server 2000 SP4 (8.0.2039) on Windows use : Microsoft SQL Server Version 2000.85.1132.00 driver My question is do the SQL Server versions have to match exactly. I know I have the wrong driver but do I need to upgrade my version of SQL Server. Dom

Hello and thanks in advance for any help. I use the google earth stand alone to edit and view plot maps. I have created my database in FM 11 Adv and have it working correctly but I would like to include my plot maps within my database according to individual tract numbers. Is it even possible to do this? Any suggestions? Thanks

I have a hosted database that I'm trying to connect some SQL Server tables with. If I launch a local copy of the database I can see the data and work with it BUT if I launch filemaker client and connect to the database on Filemaker Server, I can't see the data and get an error "The account and password cannot be used to access this file" BUT I'm using the SAME System DSN. Anyone have ideas why the local copy would work and using Filemaker client would not? Dom

I would Like the opinior off you for this solution I Have developed a solution in Filemaker pro advanced and its working with filemaker server advanced in IWP. The solution has some querie imports in sql to other CRM until here everything is working well. And now the Big Boss wants a second monitor for some off us (15 users maybe) The idea is to logon to the database when the computer starts and shows the result off the day. and along off the day - First problem i have done it iwp but and i cant manage to refresh the page with out some going to the second monitor and do F5 - Second problem i cant manage to make at startup: a way off moving the…

Hi ALl, I have some experience with SQL syntax and our DBA allows us to import records and not write to the SQL data source. I have a local FMP 12 identical to the SQL source. I can import all records in the first instance easily. However, there is no option when field mapping to only update related records then add new. Is there an SQL where statement or and indexing issue on the SQL side? Thanks Mike

I use FMPA 11 to connect to Oracle and display portal data and shadow tables from Oracle in the FM table alongside about 250 FM fields. I use a staging table in Oracle to run detailed SQL queries then import some of that ODBC source staging table into FMPA. The Oracle data displays correctly in my shadow tables, but since yesterday, when trying to import via ODBC source, FM freezes requiring force quit. I did a file recovery with no errors and get the same result. My ODBC driver connects correctly to Oracle.

Hi all- I'm evaluating FileMaker Pro 11 as a replacement to MS Access due to the limitations Access puts on rows and frankly looking for something more sophisticated. The data source that I am working with is an old legacy COBOL database (specifically Deltek's GCS Premier database). The connectivity to the old flat file non-relational database is provided by Transoft U/SQL ODBC Driver. The problem I am having is I can import all the data tables using the Transoft driver into FileMaker which is great but if I want to work with LIVE data I get the error "The ODBC data source you have selected is not supported" when I go to the Relationships tab and try t…

I am intending to transfer data from my FP database to MySQL to be picked up by a third party, but I still need to be able to view it via FP12 where I will use FP12 to create and make amendments to the data. Basically, I guess, it will be a data separation exercise using FP as a UI. I need to include 'non-text' characters such as tabs, bullet points, etc. in my 'Description' field. I can create them in FP and import the data into the MySQL database as a TAB file, but when viewing the MySQL data within FP - as a related field from the external data soure [MySQL] - I get, presumably, MySQL's version of the text data which is shown with what I think are symbols fo…

I am doing the FileMaker Training series and am stuck at ODBC sharing with FileMaker. Upon testing the FileMaker DSN in ODBC Administrator and entering the correct login info it gives me this error: [FileMaker][FileMaker ODBC] (802): Unable to open file Test failed. In addition, the DSN doesn't connect to localhost, 127.0.0.1, or the IP address of my computer to obtain names of available databases. Here are my DSN settings: FileMaker ODBC Driver 11.0.58 Data Source Name: bonsai Description: bonsai Host: localhost Database: 11b_Bonsai.fp7 Auto-detect Language Settings: Yes Log Long Running Queries: No

Has anyone done any Filemaker to Goldmine integration. I'd like to be able to pull data from Goldmine into Filemaker and was wondering if there is a plugin out there or someone can give me a high level view of the difficulty involved. Thanks. Dom

Dear All, Please help me in integrating FileMaker with SalesForce. Also please confirm me that whether it is possible or not. If possible, please suggest me the right way so that I can start my work on it. Any needful suggestion will be highly appreciable.

I noticed something while trying out the Invoice Starter Solution. It goes like this: In the DB the ContactID for the invoice table is auto calculate variable $$contactid which is set by a script prior to opening the layout to which the table is referenced. When the DB and the Interface is in the same file... i dont see a problem as in the example. However when i split up the db and the interface, i.e. the db is its own FM file, and the interface its own... then i think it does not work. I cannot pass the variable over to the db file. Is this true? That you cannot pass variables to the DB if the db is on a different file? What i did was explicitly…

I work in an an industrial envirnoment where PLC is used to control all the machinery. From the PLC output we get all the production delay times and so on in order to make sure that this information is correct (bonuses paid are based on minimising production delays). Now we were discussing if we should use FM to store production data and generate daily performance reports automatically and we were stuck at "can FM recieve data from a PLC program directly?". If anybody has a similar experience It would be much appreciated if they share Many Thanks.

Hello Everyone, I am trying to set up a ODBC connection to some FMP databases my company has. We have FileMaker Pro (not Server) installed on our company server and that's where the databases are housed. We also have FileMaker Pro installed on our individual computers and we remote access the databases on the server. I am setting up the connection according to the ODBC/JDBC connection instructions. When I got to do the test connection, I get this error message: SequeLink Error: 3601 - [datadirect][odbcsequellinkdriver][sequellinkserver] authorisation failure. Here are the settings: The LDAP box is clear. SequeLink Server Host: my server's IP addre…

First, let me say YES! we are set up with the 32 bit drivers. That aside, Our FM app works great as a stand alone app from a Win2003 box with ESS to SQL2008. But when we moved it to be hosted on our FM11ServerAdv, the application can import records from SQL2008 but its ESS connections fail upon managing the external database. While we had both the 64bit and 32bit ODBC set up with the same name, the issue did not resolve upon deleting the 64bit odbc dsn. Not even after a reboot. Any tips on how else to troubleshoot?

I've set up ESS with a SQL server 2008 database, and viewing/editing records seems to be working fine. The problem I've encountered is that when I try to delete a record via ESS, it appears to delete, but when I search for the record again it is still there (and it's there if I look for it in SQL server management studio) I get no error messages when deleting, and if I run a delete query in the SQL server management studio, the record really does delete in that case. Has anyone encountered an issue like this where ESS does not allow deletion?

Howdy, I have a portal that contains two fields from a MySQL database via ODBC. What I would like to achieve is that these fields "auto-update" when the underlying data changes in the ODBC datasource. As it is now, I have to manually call the "Refresh Window" function, and do so via a button/script ("Update") that uses the Refresh Window script step with both "flush" options selected. I have tried using this in a script trigger for the OnModify for the portal and also for the fields themselves. No luck; still have to click the "Update" button to have the new values display. Is this possible to do "auto-magically" :-) Cheers! Lyle

Does anyone know if it's possible to pull data from Quick Books via ODBC connection instead of using one of the plugins that are out there? I only need READ ONLY access and thought maybe I could go the ODBC route.

Hi Everyone, I am not sure if this is the right forum for this question. If not sorry and can you tell me which one it should be in. I am using Filemaker v11 on my Mac laptop with the database on the Filemaker server v11 on a windows machine. I was wondering is there a way of accessing the database over VPN? Any help would be appreciated. Thanks Neil45156

Hi - i am using Mysql and contect live to it in filemaker. When a cleint enters details onto our online form, i use the myqsl_real_escape_string for security to avoid injection. When the data is then displayed on the web, this is okay as html reconises the charaters that have been escaped, however in Filemaker, the "&" shows as "&amp;" etc etc. Is there a way to view the correct symbols in the Filemaker fields and not the code please? Thak you very much :)

I would like to run a script whenever FM recognizes that a new record has been added to my external MySQL table (orders). Since I don't believe FM offers any native script triggering capability for this, my thought was to set a global field with the total number of records in the orders table and then run a scheduled server script which would compare the count in that global with the current count, post the orders, then set the global with the new count. I think that would work but I'm concerned what would happen if one or more records get added to the orders table while the script is running. I guess I could add a field to the orders table that FM could write t…

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

Hi, Really new to filmmaker and databases in general. I want to set up a database link from my website on 1&1 to filmmaker so i can edit products,ect in filemaker and send them back to the website database. My web hoster is 1&1 and they say they dont allow odbc connection direct to mysql as it is behind a firewall, etc. How can i make a connection to the mysql data and edit it, etc using filemaker?? Any help would be greatly appreciated.

Our office has a Filemaker Pro 11 database that is already in use (has been for years). What I want to do is replace the central "Users" table in the FMP database with our "Users" table on our mysql database server. No problems setting up the external data source, using Actual Open Source ODBC connector. I can add the table, but when I change the relationships to use the new external table, it ruins all of the layouts. Same table name, same field names, but it still knows it is a new table so the layouts don't display the data anymore (lots of Table Missing). Is there a way to replace the local table with the external one without messing up all of the layo…

Hi Everyone, I've run into somewhat of a roadblock using ESS with FM Server 11 Advanced (clients using FM 10 or FM 11). The issue concerns a server schedule that executes a script from one of the hosted files. The solution is a back-office application that handles data for servicing of equipment by field-based engineers, who access data on their PDA's. The PDA's write to a MySQL db which is accessed from FM via ESS. All reading/writing is done from the FM side i.e. one script pulls information, the other pushes info to the MySQL db. The solution has been running for a couple of years, though over the last few months the speed of running the 'pulling' scr…

I have a 45 file solution currently running on FM Server 11 Advanced that was originally built in FMPro 5-6 (by someone else). All of the External Data Source paths are set to use relative (file:filename) paths only, but the Source File listed in the TO's is using the "fmnet:/IPAddress/filename" path - in the case of one table its even "fmnet:/*/filename". Logically it seems this would be a performance problem if the db files, which are all in a single folder on the server, are having to resolve the fmnet path rather than just using the relative path. I know the * in the path is a major no-no. If I go to External Data Sources and add a source by navigating to th…

Hello All, Ok here is my problem, My boss wants from me to make a program for some invoices stuff that i dont undestand but it's ok. The problem is that she needs to run in iPads and Desktop or Laptop. From my search i came up with "FileMaker Pro Invoice Starter Solution" and she seems quite satisfied and i thought ok. But then she asked one more thing, to make a button that when the iPad and the Desktop connecting to update the new records from the iPad to the Desktop. To me that seems that she needs one way (iPad->Desktop) database sync. After hours looking FileMaker Pro and trying to undestand how can i work with this i find that there is a way to do this onBut…

This must have been answered before, but.. In a spreadsheet, eg Excel, it is possible to populate a table using data from a table in a web page. Can this be done in Filemaker Pro?

Hi All, Well, I have found myself in a bit of trouble. I need to be able to import from a postgres database and then write back to it when data in Filemaker changes. We are using Filemaker 11 and postgres can be 8.3x or 9.0.3; whichever will work. Has anyone gotten this to work successfully? If so, how. [i have been working with the 360works people, but all queries fail with a cryptic error message.] I have attached the error message, and can post any other information that could help someone help me. Thank you for your time. *susan* susan mcm tucker pretty cool solutions somerville, ma 617.694.1709

Dear all, I have an ESS/ODBC error that I cannot fix. When I try access a MySQL table via ESS, I get the following error: ODBC Error: {MySQL][ODBC 3.51 Driver][mysqld-5.0.92-community-log]You have an erro in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'customers_id IN (24,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,' at line 1 I think I did the ESS config right because other tables display with no issues. Any help would be greatly appreciated. (Translation: HELP!) Regards, Salman

I need my FM users to "EXECUTE SQL" script step on the FM server with out having each client to have the SSH and Driver to a PosgreDB. That is to have only one centralize connection (on the server). I installed the Actualtech server driver on my server, the server loads and connects to the posgresql server thinking that hosted fm files would use that dsn. but NO :S the clients try to connect via their own odbc resources not the server.. is the execute sql for client execution only? is ther a way someone can think as a better way so I dont have to set up each client? some of my users are FM Go where there is no driver for external dbs :S any advice is apre…

Does anyone have any experience in pulling data from Bloomberg into FileMaker? We currently download data into a spreadsheet. This data is then copied into our Bloomberg spreadsheets with the bloomberg formulas, which call the data through the DDE link. What would be nice is if there is a way to get the data directly from Bloomberg into FileMaker. Alternatively, if we could AT LEAST produce the bloomberg spreadsheets from FileMaker, where FileMaker can just export them directly and they then just need to be opened, this would be acceptable. I have not been able to implement solution 2 because Excel seems to interpret data from FileMaker as text rather than a for…

Howdy, I know that I have seen this somewhere, but I'll be darned if I can find it again! I am needing to convert a MySQL numeric timestamp to a FM timestamp. Example: MySQL = to_timestamp: 1325936079 FM = date: whatever the above number represents (should be about 07 JAN 2012 04:15:00) Thanks in advance! Lyle

I'm having issues connection filemaker to mysql on the same machine. Here is my setup. I'm running MAMP on my mac os x 10.6. I'm using the the Actual ODBC driver to connect mysql to filemaker pro advanced. I am able to successfully connect a remote mysql database with filemaker on my machine. However connecting the MAMP mysql to filemaker on the same machine (locally) isn't working. Any ideas of what I'm doing wrong? Any help is appreciated. Thanks!

I'm hoping to be able to have a two way connection to Revit - (3D architectural CAD software). Apparently it can write and read to; Microsoft® Access Microsoft® Excel Microsoft® SQL Server Does anyone have any opinion on which might ODBC Driver would offer the best conduit between the FM and Revit. We run FMServer advanced. I don't believe updates need to be live but would need to push and pull as required. A couple of other considerations; FMServer will be on Mac and CAD soft ware on PC. Its possible that container fields might need connectivity but am not sure at this stage. cheers John

Dear All, I am working with a client. He needs that his all the data should be in a pendrive. And when he insert the pendrive in his machine. It should be detected and all the data should be visible in FileMaker. And After removing the pendrive, it should show no records, means the number of records should be zero(0). After insertion of pendrive, again the records should be visible. I just want that, is there any way to achieve this task. or is there any way to detect the pendrive with its physical name. For example: I want a field in my layout as a (Name or something that will be the unque) Calculation field of that particular pendrive. Looking forwar…

Does anyone have an idea how the long delay when opening a file with missing external (filemaker) data sources can be bypassed? I would like to pull data from a filemaker file on a remote server, but only if a network connection is present. Currently, the user gets a pretty nasty delay (20 seconds?) and a dialogue which asks him/her to locate the file. Very confusing. Even worse, this happens for EVERY file reference. Can a FM file be accessed without storing the reference in the external data sources dialogue? Can the check and message be suppressed? Any "thinking outside of the box" most welcome! I just don't get anywhere myself... Thanks!

Recently the server I use for mySQL was moved to another address. I changed that address id in ODBC Manager for the Mac and reconnected to my mySQL data. However, now when I click my mouse over a FileMaker shadow field to edit it, I get the following error. Does anyone have any suggestions on how to fix this?

I'm pretty new to FileMaker. I have flooring software that uses Sybase which I need to integrate with FileMaker. I can import data just fine with an ODBC driver, but I can't establish ESS that will allow me to import my Sybase tables into the relationships graph. A little searching on FileMaker's website led me to a page that said ESS is only supported with flavors of Oracle, MS SQL, and MySQL servers. Does anyone know how to establish a live connection with other servers, particularly Sybase. Thanks in advance.

In the "Under the Hood" session at Devcon this year, we learned some great info on exactly what is happening behind the scenes as your FM clients navigate through the layouts & records you've prepared for them. It was a very useful session EXCEPT that up front they said that almost none of this applies if you are using ESS. It only pertained to the payloads moving between server and client for native FM tables. Does anybody know where you can learn some in-depth specifics about the speed/performance of displaying or manipulating ESS tables? I'm using ESS extensively in one of our applications. I know the white papers caution using FM as a front-end, but…

Upon installing FMP 11 Advanced on a new computer and copying all database files, each time I open the main database, Filemaker has makes me supply the location for the other 5 related databases. There has to be some way to correct this, right?

Hi, I have a database that is storing people, object, and measurement information. The people's information are actually extracted from a non-FM file via a Perl code. The information is temporarily stored in a .csv file and then imported into the database. I was wondering if it is possible to integrate this Perl code with my FM database. I would like to have the user select the non-FM file and the file path will be send to my Perl code, which will then go ahead and run its course. It seems like you can only select FM file through the database. Any suggestions or help will be greatly appreciated. Thank you.

Greetings FM Colleagues, I have recently been working on grabbing data from our Outlet's system (Quickbooks POS) for reporting purposes within FMP. It appears that QODBC now supports POS.. so I got my hands on the demo, and have had very successful results. I noticed the driver does not seem to support the typical ESS connection... but, you can script an ODBC Import via SQL Command. I have basically written two scripts. One pulls daily inventory numbers and updates a table. The other script pulls order line items for the previous day, and imports them into another table. These two scripts work perfectly if done from a client machine that has th…

Does anyone know how I can link Filemaker 11 using ESS (External SQL Source) to MySQL 5.1 (GIS geometric tables)? My goal is to link a FM table via ESS to the (long/Lat) fields in my GIS table that reside on the MYSQL 5.1 server. I am able to link FM via ESS to some non-geometric tables (Only the ones that look normal when previewing in my MYSQL5.1 Workbench program.) Have Actual Technologies installed driver. I no nothing about MYSQL 5.1. My MYSQL data looks weird when I view in MYSQL Workbench, I guess because the DBMS decides how it wants to manage it's own data. Any tips would be very helpful. Cheers - Earlyrider

Hi, we are testing a situation where the external SQL data source is hosted externally and we must connect to it over the internet. The connection is set up and works ok. sorts and finds are quick for 100's of records, but for 10000+ records finds and sorts are unusable. There is no filmaker server in the mix.. im just connecting with filemaker pro 10 I am wondering if a way to speed i up may be to A) have filemaker server running at the end point and then a filemaker pro client accessing it frmo server.. or Have filemaker server running on the server at the external data center and access filmaker server over the web that way are either of these 2 opti…

We have a FMS v11 in our main office with a fixed IP. Our remote sales office has its own FMS server v11. I have a FM script in the sales office. It basically does a very simple find all sales enter today and then update a table in the main office FMS server. This is done using the External Data Source. The script run perfectly from a sales office PC with FM Pro. However, when I run the same script as Server Schedule Script in the sales office, nothing gets update in the main table. No error is reported and the status is OK. Could it be the scheduled script does not support external data source ? I hope this is not the case.

Just moved a project that has a Filemaker Interface, and a MySql backend, which are connected with Actual Technology's ODBC drive. After the move of the MySql DB (export from one machine, import into another), all table connections were lost. In the relationship window, I reconnected the tables to the TOC's but all field mapping was lost. So now I am faces with reconnecting all fields on layouts, scripts, relationships and calculation. Does, anyone have any tips. FYI: FMP file, MySql DB, ODBC connection are all named the same as the original setup.

I have created an external data source to SQL server and created a TO of that table in FM and related it to my FM contacts table: Contacts::sl_accounts_code (FM) = SL_ACCOUNTS::cucode (SQL Server ESS) I am now able to see Sales ledger accounts info relating to my FM contact on my FM layout So far so good If i change a piece of data in the SQL Server from a FM layout - it updates beautifully into SQL server - excellent But if I then update a piece of info in SQL server it does not update the FM layout (even after changing layouts and reperforming a find on the customer concerned) In a nutshell : As a test i put the sales ledger account na…

I'm exploring the idea of using Crystal Reports (v14) using data pulled directly from a FileMaker source (hosted on FMSA 11). I'm been able to successfully setup an ODBC connection and create a few simple reports so far, so everything is looking OK. Except for the speed of extracting data, which is a known "problem" with ODBC. Is there any other options to directly pull data from FileMaker into C.R.? I didn't see and XML or ESS options when setting up a data source inside of C.R. But it's very possible that I didn't see them as such, as I'm a newb with C.R. I'm using FMServer Advanced 11 and can set it up however I need to if needed.

I have a parent FM record with a multikey text field of child IDs. I would like to use gtrr from this parent to the children. The children are MySQL records in an ESS table and the primary key is a number field. The gtrr fails. On p.15 of the ESS FM11 Tech Brief, it states that multikeys can be used to match to ESS child records. Why is this failing?

Hello Is there any solution to get real time (at a pre determined sample time) data continuously from a excel file fild data in to filemaker field with out using import functions. Regards, Raja

I have a bit of a problem. We just upgraded from Server 5.5 and Client 6.0 to 11 and Server 11. Here is my question. I am trying to import some data into a 3rd party program via ODBC. I realize now that Server 11 does not support ODBC, but can the client act as an OBDC data source for this application even though the client is connected to the server? The reason I ask is that this application worked perfectly in the previous versions and it seemed to me that the client was acting as the data source, not the server. Could be wrong, fairly new to Filemaker. I just have a hard time believing that I have to buy Server Advanced to solve this problem. Als…