External Data Sources

Hi everyone. I'm new here and not an advanced user of FileMaker, so please excuse me if I accidentally post something stupid or not quite within the board guidelines. I've been using FM pro to manage my ODBC databases - they link into my website data. In the last couple of days whenever I open any of them, only the first few lines of data show, and the rest is just questionmarks. I can't access any of the FM menus - or if I can, it takes ages to respond. It intermittently says "find in progress" and shows a number, which is going down. In the top information bar, where it shows the total the number there is also occassionally dropping. On the screenshot attach…

Last week we installed Filemaker Server 11 Advanced on a new MacMini running on Lion. We also installed the latest version of ODBC manager and the Actual ODBC drivers and bought the licence from Actual. Now when we open a database which connects to a extern sql datasource it takes a very long time to open this database. We do get all the files back but when we do a search command or sorting command, records will completely disappear! The database empties out! When we use the same setup with the same datasources on a MacMini using SnowLeopard there are no such problems. Is there anyone having the same odd problems? Rob

I am using OSX on a mac. I generate a file named something like 'filename.123' outside filemaker. This gets imported into filemaker for further processing. My solution currently imports 'filename.123' just fine. I recently changed the way these files are generated outside filemaker. They are still saved as 'filename.123', but are somehow not identified as text files by OSX or filemaker. I can no longer import them. Do you have any ideas how I can import them? Thank you in advance, Fed

I run queries on a FileMaker instance running on a mac from a .Net application using ODBC. The FM administrator has just upgraded to FM 11. After the upgrade, one record was causing this error: System.Data.Odbc.OdbcException at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcDataReader.GetData(Int32 i, SQL_C sqlctype, Int32 cb, Int32& cbActualOut) at System.Data.Odbc.OdbcDataReader.internalGetString(Int32 i) at System.Data.Odbc.OdbcDataReader.GetValue(Int32 i, TypeMap typemap) at System.Data.Odbc.OdbcDataReader.GetValue(Int32 i) at System.Data.Odbc.DbCache.AccessIndex(Int32 i) at System…

I am looking to hook up a live (or close to it) connection to some dental management software: Dentrix, Eaglesoft. I want to be able to pull data and ideally push as well. I was thinking ODBC, but this software doesn't support it. This may be over my head (I'm no hard-core developer), but I'm at least hoping to understand if it can be done and the basic concept of how it would be. Dentrix is reputed to try and "lock up" their data, but I know there are several other companies that have found a way to integrate with it successfully (SmileReminder, DemandForce). Any direction would be appreciated. Thanks.

I recently attended DevCon2011, and am now trying to implement some of the knowledge gained from some of the panels there. In particular, I am working on integrating FM and MySQL. I am looking at doing a bi-directional synchronization strategy, or at least semi-so. Synching creation of new records should be bidirectional; record modifications should only flow FM -> MySQL. But anyway, that is secondary to my current question, which is about field naming conventions. In one of the panel presentations (Introduction to FileMaker Pro and SQL Integration), on a slide entitled Readying your FileMaker Solution, there is some advice about field naming conventions. It…

I am working on a "Quality Control" solution for FMGo on the ipad, using our company's SQL Tables (from SAP Business One). I have live connections with four SQL tables (Products, Purchase Orders, Manufacturers, and PO Line items). All of the relationships are good, and this works great as a closed solution for viewing information. However, I need to add a local FM table (or several fields, and container fields) that will house some qualilty control information for each record in the PO Line Items table, and will be directly related to the SQL table "PO Line items). The problem I can't figure out is how to create these fields, because I can't/don't want to make these n…

Hi to everyone. On MySQL server I created database and called it (for example) TestDB with table Contact, wich has fields ID, f_name and l_name. Then, I created DSN called MyDB with ODBC Administrator on my Windows 7 client computer and configured it to point to TestDB database. In FM (v11 Adv) I created new External Data Source called MyDB, wich uses MyDB DSN as ODBC link. I created simple application and... trouble here begins. With ODBC Administrator I reconfigured DSN called MyDB so now it points to RealDB database on MySQL server. But when I run my FM frontend it shows data from TestDB database. When looking for solution (by chang…

Hi using gps real time tracking tool in google earth/QGISv1.7.0 , how can i store the real time updating values of longitude and latitude in excel sush that the data also get updated in excel in real time?

I have a microsoft word form that has data fields. I want to link a filemaker database to the Microsoft Form and populate fields in the form.

Hi guys, For working with FileMaker lower vesion i have required following: FileMaker Pro 5 setup for mac os x . pls anyone can help me about this. Have a nice day to all........... Regards: Coolbdy

We sync data between MySQL and FileMaker. I need a good automated way to verify that the SQL and FileMaker data match. The ideal solution for me would be something that runs once a week and emails me any difference between the two data sets, for example: field 'a' in FileMaker is '12345', but field 'a' in MySQL is '123'. Or if that doesn't exist another good solution would be something that could tell me if there are any empty fields in MySQL that are not empty in FileMaker. Are there currently any tools that do this or something close to this?

I am sure this has been asked in many other topics, but i have a few questions. 1. Can I create MSSQL table/field from Filemaker environment? My OBDC Configuration is working, but I have to create all the fields again in MSSQL 2. Is there a way to create a MSSQL Field as a calculation? or do I always have to create a support field in Filemaker? 3. Should I maybe use MYSQL instead? Is There a diffrence in MSSQL and MYSQL from the point of view for Filemaker? Thanks for your time. David

Hello, This seems to be the best area for this topic, if not my apologies in advance. After installing the FileMaker ODBC Drivers for FileMaker 11 Advanced on Windows 7 the driver does not show up in the windows ODBC data source administrator list. The installation appears successful without any error messages and a reference to the install shows up in the add/remove programs list. Has anyone else had this problem and found a work around? Thank you, mmyett

Please help me to know how to export data from filemaker to oracle database....pls don't confuse ...i m asking to export data to oracle. Can any1 suggest me ..how to perform this...this is urgent. Will be glad for ur replies..!!

Hi guys, I was able to connect to my FileMaker application hosted on FileMaker server over JDBC fine a couple of weeks ago but now I'm getting this error: [DataDirect][sequeLink JDBC Driver]TCP/IP error, connection refused. Session aborted due to network problems. Socket error, connection refused [sOCKET]java.net.ConnectException: Connection refused I have ODBC/JDBC enabled on the server and I've verified everything is set up as this document indicates. http://help.filemake...server-advanced Diagnostics: From client, I can ping the server. But telnet to port 2399 doesn't work: $ telnet 10.11.31.74 2399 Trying 10.11.31.74... te…

Hello people, New to this and would like some guidance before getting my feet sunk in mud! My goal is to have my users sign up, then be able to log-in which wold bring them to their own inbox (for starters)Please, please all the suggestions and guidance is appreciated. Thanks, Tom Lagace President Princess Tiana, Inc.

I am hoping that by some chance someone can recognize this behavior pattern as I have run out of troubleshooting ideas. I apologize in advance if its too vague. I am running FM 11v3 on OS X 10.6.7. I use Actualtechnologies ActualSQLserver to interface with my organization's microsoft SQL server. I just updated it to the latest version as part of my troubleshooting (3.0.12 I think). Microsoft SQL server version 09.00.4035 I have a rather complicated data collection script that runs nightly between 2am and 5am. Most of the data is collected from other sources, but some is collected from the SQL server. I have found that the fields that get their data from the SQL ser…

Hello, I just wanted to ask, if anybody has experience in UPS Worldship its Migration. At my company, we have two standalone installations and want to migrate them into one client server installation. I know, that this forum is about the FileMaker, but I didn´t find any other forums to post my request. I´ve had about 10 support calls, but still a long way to go. Would appreciate any help. Thanks!

Hi Guys..........Hello to all I still have problem with FileMaker Pro 11 with Relationship and forms.(on Windows and mac) 1) i want to create relationship programmatically in filemaker pro 11 database. is there any manually method using scripts to create relationship and then i do this programatically(create and fire scripts for relationship). Is this possible or not whiich i m thinking. 2) and second is i want to create forms programmatically. i have no idea about this how this will possible for FM database. if any have idea for both then plz reply. Have a nice day to all.............

Hi there, i m working with FileMaker pro 5 on mac. For automation of database, i want to create connection with FM pro 5 database file. is there ODBC provide for FileMaker pro 5? how would this will possible on mac. pls help me about this. Regards: Coolbdy

Hi everybody, I want to copy my records to MS Sql( LKS GO - it is an ... program) from filemaker. There is a relation between filemaker and Ms Sql with ODBC. As a usually, i create and update records in sql table. I create records but i couldn't save some special table for Ms Sql(LKS Go program). There is an exception as like in attachment. Attach1 = As you see , These tables have some triggers.(insert - update - delete ). I think i must run an insert Trigger. When i run sql query(insert trigger), there is also an exception. Attach2 =

I was just in a meeting with our UPS reps and they were promoting the use of ODBC to pull information from filemaker into the worldship software. I am a complete nube when it comes to ODBC so I really don't know what I'm doing. After I installed the ODBC drivers from the fmp7 disc, I wasn't able to get anywhere. I would try to setup a datasource, but none of it made any sense to me. I'm starting to think that the ODBC drivers for FMP were for IMPORTING rather than EXPORTING data. Anyone here able to integrate the two? Help is appreciated. Thanks Curt

Hi Guys! I have facing some problem with FilwMaker pro 11, and i m using FM ODBC 11.0.81.00 driver. 1) First one i want to Clarify that relationship in FileMaker pro is same as Apply "Foregin Key" Concepts on database? 2) Second is i want to apply Relationship in Filemaker database. for this i m doing following: i create connection with existing FM database table & create a table Customer in this database using query Eg: CREATE TABLE Customers (P_Id int Not Null primary key, Order_Name varchar) This is going fine a table Customer is created. Now i m Fire the following query to create Relationship then this is …

I have a Filemaker solution that is pushing website content via an ODBC connection to a MySQL database. I have a bunch of special characters that are not showing up correctly on the website. I am trying to use the substitute function but it’s a mess. I am also have trouble parsing quote marks. What is the best way to parse something like this? Here are some example of what I am trying to parse: > bullet: • > apostrophe: ’ > open quote: “ > close quote: ” > accent marks: é parse to > bullet: • > apostrophe: ’ > open quote: “ > close quote: ” > accent Marks: ???

For some reason I have trouble creating related records in a multi-table mySql from my office machine. It worked just fine from home (Windows XP professional), and I brought a copy of this latest fp7-file with me to work today. But here, something gets wrong (with the same solution!!), and even worse: I get an error message, and cannot do anything with FM, not even close the program. It has to be forced shut down. Here is the error message: My problems are the same as listed in this error report from 2009 http://forums.filemaker.com/posts/c2984cfd1b (I also have Windows Vista Home Premium at work, but FM 11 Advanced and a somewhat…

This is regarding a server (Server A) running Windows Server 2003 Service Pack 2 and FileMaker Server 10 Advanced I have a FM database hosted on Server A that connects to two different SQL Server 2005 databases on Server B, no problems. One of those databases has been migrated to a SQL Server 2008 installation on Server C. Created a new ODBC source on Server A to see the database on Server C. Tested the connection in Control Panel Data Sources, it works. Next, I set up an new External Data Source on my FM database to point to Server C. When I set up a new table instance in FM and point it to the new data source, my credentials fail. However, whe…

Please excuse my ignorance. I am working with a company that wants to create a GIS interface for my FlieMaker solution. Can FileMaker link to GIS? That's all I know. That's what they told me to ask.

Hi All, I m still getting problem with File Maker ODBC 11.0.81. i want to apply fields properties and create Relationship on FileMaker 11 database using queries(Programmatically). But i m not getting right things for this(Is there update for this?) can anyone have idea about this. or is there another method except ODBC for this. pls help me. Have a nice day to all............

Hi i have a sql connected to filemaker . in the table i what to run ש script the will give mק the largest number in a field . the problem is that i can not add a summery file to the table. how can i do it? Thank You Dani

Hello, I'm new to FM as you will soon find out Good to find this place. Situation: Connecting to my SQL Server 2000 works fine and it can display tables, read fields, modify fields,all is good. I'm trying to exec sql queries through the ODBC, after executing, there is a slight delay (obviously working), and then, nothing. Question: How to view the output of the exec query? Thanks Roy

Sorry for post this at wrong place(at managing scrips Forum) Hi there, i m working on FileMaker pro 11. i want to apply Column properties on FileMaker database using ODBC driver 11.03.81.00 But i m not able to do this using this ODBC driver. Is there any another method to create connection with FileMaker database and apply column properties and other features like create forms, apply relationships etc. Is there any API or SDK available for this. Can anyone do me a favour for this. Have a great day ........... Regards: Coolbdy

Hi guys! i m facing very strange problem with filemaker pro 10, when i m connecting FileMaker pro 10 database using odbc driver 11.0.83 on mac then, connection is not establish between them. it's working fine with in case of FileMaker pro 11 and driver version is same(11.0.83) is there any other requirements for create connection with FileMaker pro10 using same driver on mac. plz help me abt this. Have a great day to all.

Hi to all, Now i am working on generate report using odbc sql server 2005 database via import record and set query. sql server 2005 is on different system while creating ODBC dSN i connected it successfully. On my system it is working fine.But now the query is:"is it possible fm file on fm server advanced,enable odbc on.... and generate this kind of report from other fm clients system without creating ODBC Sql server 2005 DSN?" if it is possible then tell me the answer and if not then what is the meaning of this statement in filemaker : "by 1 odbc connection on fm server advanced ....other fm clients…

Hi everybody, I m working with FileMaker pro 11, and i m using FileMaker ODBC API for automation. i m using FileMaker ODBC 11.00.58.00 driver for this. When i inserting the records in the filemaker database, it shows anonymous behaviour, if i using parametrized query for insertion of data then the size of "fmxdbc_listener.exe" is increasing rapidaly and application get crashed. elseif i using simple query for insertion of data then my application exe takes 0.1MB memory for every 1000 records insertion, if there are huge of records then it get crashed. i m using SQLPutData() function for this. i get frustated with this, so what …

In my FMP solution, I link to a table from my secretary's computer. Her FMP solution must be on prior to launching mine in order for mine to connect to hers. Is there a way to disconnect from her table, from my side? Also, if she shuts off her computer while I am still connected to it, my FMP solution freezes. Will this cause data corruption? Thank you, Fed

Although I have a lot of overall DB experience, I'm fairly new to FM. Here's my situation: I've connected to a MySQL db and have written a FM script to get some records from the uc_orders table on that db, loop through them, and act on each record. So here's what I have going on so far (please tell me if there is a better way of doing this): Go to Layout ["uc_orders" (uc_orders)] Perform Find [Restore] #this finds records where uc_orders::order_status ==payment_received Go to Record/Request/Page [First] Loop #...I do some stuff here (not relevant to the problem at hand) Go to Record/Request/Page [Next; Exit after last] End Loop I have confirmed th…

Has anyone any experience with connecting to a Revit or Autocad file. In other words is it possible to get a meaningful interaction with the CAD programs databases? thanks

I have my main solution on computer 1. My secretary has hers on computer 2. The tables I need to link to 1 from 2 are on the Relationships Graph of 1. I have no need for a reverse link (ie from 2 1 to 2). This work just fine if 2 is turned on before 1. The problem occurs if 2 is not yet on when 1 starts, as well as when 2 wants to close while 1 is still on. I apologize for the confusing explanation. Is there any way to manage this situation? Any help would be greatly appreciated. Thanks, Fed

Hi, If I add an SQL view to the relationship graph in FM a pop-up comes up with: The table "xyz" does not provide a pre-defined unique key... If however I chose the underlying table instead of the view then filemaker properly identifies the primary key and the pop-up is not shown. The SQL table of course has the PK. Question: is there a way to construct the view so FM will recognize the PK of the underlying table? Perhaps indexed views should be used? If I simply choose the field for the unique-key in FM then I'm afraid filemaker will create its own indexes, performance will suffer and I've read somewhere that there might be issues with refresh, etc.. …

We're running filemaker 11 on Windows Server 2008 x64 and would need to access data on MS SQL 2008 through ESS. All machines are x64 but it seems that Filemaker ODBC drivers are 32-bit only. Does filemaker support x64 ODBC drivers? Are there any 3rd party drivers available? Thanks!

I have made a solution to update a MySQL-database (Zen-Cart) directly with FIlemaker's ODBC-connection. I have made the connection to more than 20 external tables, and have in addition made some local Filemaker ones. This has worked perfectly since I made the solution last week, and everything I updated, would be immediately updated on the internet as well. But somehow, the Products-table (thus one of the main ones, with several fields) has turned into a native Filemaker table. Thus when I make changes to it, this will not directly update the external MySQL-database. Does anyone know how this might have happened? Is there any way to change it back? …

I have Server 11 ADv. working fine via ODBC MySQL 5.1. I need to point to another server with the same tables exactly and once I do that all the tables references are lost. If I redefine them in the relations diagram to their new location weird things happen and I also lose all my additional calculation fields I defined in the Mysql tables (in FM). Has anyone managed to repoint an ODBC without wrecking havoc on Filemaker? Thanks. p.s. I'm using the same ODBC DSN - just changed server/user/pw

I'm using FM10 on a Mac. I have a multi-table database file which I need to rename from children.fp7 to donations.fp7. But when I rename it in the Finder (desktop), my admin login will no longer work. I can change it back to children.fp7, and the login works. What's going on? How do I fix this?

Hi Everyone, First time here so I hope I have posted my query in the right place. If not sorry. The problem: I have filemaker on my pc at home and the head office is in cornwall. i cant load filemaker on the server at the moment, that will change by the end of the year. Requirements: i need my training manager, my training co-ordinator and the other directors to be able to access the datebase at different levels. The directors will be able to see all information such as salaries and personal information. my training co-ordinator needs to be able to up date the database with basic information such training dates and attendance details. My training manager n…

I'm in a FM Server Environment, running Version 8, about to move to Server version 11. Recently I noticed a bunch of odd File References (aka Data Sources) in my databases. So I started researching this. I had a few files that had paths, which were wrong so I deleted. But I couldn't figure out which was correct: File:DatabaseName fmnet:/*/DatabaseName fmnet://DatabaseName Can Someone confirm my theory? - the "*" makes the file search the entire network for the file. - Using the IP address is better than the * because it won't have to search the entire network Is Using "File" be better than using the IP Address? It looks in the databa…

Hi, I am trying to insert the result of an SQL query into a field in FMP 11. my SQL statement produces the correct result but i have not any way to show that result of query in filemaker I can run the SQL query in a script using "Execute SQL", but I can't figure out how to send the results to a field in FMP.Also by import records sing ODBC and sql query builder it is mapping right into field but problem is this every time we have different queries and we don't know what will be the total columns in result for mapping with filemaker fields. I don't want to hard code the value of the field to equal the SQL statement (a…

I have a server1 (O/S is Windows 2008) that runs Filemaker server advanced and the client machines (O/S is windows7) are running Filemaker pro advanced. I have another server2 (O/S is Windows 2008)is running mysql IIS7 and PHP. I am trying to make a live bi-directional connection between Mysql and filemaker (Filemaker will be hosting the data). I have remote clients that will be adding data through a browser window connecting to mysql. I need the information they add to be put into the filemaker database live. I have local users that will be using Filemaker Pro advanced to also enter data and the remote users need to be able to see the changes. What I have do…

Hi, Is there any way by which I can pass a filemaker variable to an applescript which is running as part of the filemaker script? Thanks folks, yknot

Just converted a parts inventory set of 9 related files from FM7 to FM11. Imac. Everything went fine, except now my "open all" script doesn't open all the files. All but 3 wont open automatically. As a each file opens, it asks for the same related file, which I select from the file menu. As other files open, with a relationship, they too cannot find those certain files. I've looked at the file names, they are just like the others. I've check the relationships, there the same. Checked passwords, network settings for each. Once I get through manually opening those 3 or 4 files over and over again, everything works as it should. Filemanes are "Service.fp7" "Vendors.fp7" "Par…

Hi All. I was wondering if anyone would be able to recomend any hardware or software besides iphone or ipad (because I know about them) that there may be out there that could be used to tie into our filemaker database. We have people who visit our customers to collect checks and such and it would be wonderful if they could maybe do things like mark the invoice paid from the remote location and perhaps even capture a signature. I've searched the net a bit but it's a long and winding trail with no place to start. Any suggestions would be greatly appreciated. Thanks Ron

FMP 9 on OSX We have a situation where a FreeBSD-based MySQL 5 system generates data; we would like to then import that data into a FMP system. Now, we've read of the ODBC route, but for security reasons, the MySQL host will not accept queries from outside; we would need to tunnel over SSH or similar. We do cron a nightly mysql dump. We could easily scp that file to the FHP host system. Is there any tool to read the data in such a mysql dump, and import it into the FHP system? Or another {unix-based, as the MySQL is..} tool that reads the MySQL and creates a file that FMP can then read?

Hello all, i am working with FileMaker pro 11 and i want to insert following, 1) File 2) objects in the FileMaker pro database file using "insert" query. for thus i m using parametrized query. and i m using FM ODBC 11.0.58. or there is a another way to insert them. or This feature is supported by ODBC or not,i don't know exactly. can anyone help me for this. Have a nice day to all.

I'm on a mac. I can connect to a mysql database via odbc using navicat so i know the login credentials are correct. But when i try to connect via odbc in FM using the 5.1 mysql connector, i get... "The account and password you entered cannot be used to access this file. Please try again." Any suggestions?

We have a small solution where we have several people in the field (without internet access) and they transmit their reports when they return back home. I am trying to update their information at night (changes in scope of work, etc) from a central source. We have a website hosted with our ISP and have ample space, but I do not think we could install FM Server there (it would also probably be an overkill for now). So if i have a .fp7 file sitting on that webserver, can I connect to it via 'manage external data sources' or is my only option to FTP the entire file down and then run an import routine locally? I know i could probably achieve this with an ODBC connection …

Current Setup: FMP Client --> FMP Server -- > ODBC --> MySql NEED For each value list, I would like to have a single field, in a prefs table in the mySql db. SO FAR: Although this concept works well within FMP, I am having trouble with the above arrangement. I believe it is the character returns. In FMP I setup a field with a control style of Checkbox Set., but on the layout it shows a single checkbox, that when clicked, it populates the field with all items from the MySql field. Any suggestions?

Hi - I want to use Excel's external data>>database query to drag info from my filemaker file. I have downloaded the Actual technologies pack and in the OBDC manager I selected the DSN option but am not sure which driver option to use as none seem quite right (Access, open source database, oracle, SQL server). at this stage I want to run filemaker and excel on the same local machine. ( i tried the access option but that seems to be for FM to be the client not the source) Any help to move forward would be good thanks.

I would like to import data and image for supplier catalog, and I need to scanned the supplier page. Is possible to preview and scan the page directly into FM? thx

We have a registration database for a non profit, it's basically a community sports database. There is an online registration & an off line Filemaker database. I wrote a script that imports the files from the web that we need. Now we want to automate it so the person doing the data entry can press a button & the files download to her local directory then of course it imports into all the correct tables. Originally the web designer was going to write a script to export. That isn't working out so I wanted to use FTP to grab the files and then do the import. I can manually do this of course but I need to automate. My question is can I do this without utilizing a plug…

I have a piece of software written on .Net Platform with an embedded Firebird database Engine. I need a way to get into the Firebird database and make it either manually or automatically export files into FileMaker or talk to FileMaker in some way that allows me access to the records via ODBC or some type of middleware. I do not have access to the programmer or his code. Any suggestions?

I am passing a parameter to a script, which in turn calls a script in another file. The initial parameter determines which file gets opened. Is there any way to call an external script when you are using a variable filename? I think I know that the answer is no in FMP9.0v3 but perhaps I'm missing something. Would fmp 10 allow this? I'm considering the upgrade... thank you!

Hello all, I'm getting into an encoding problem updating MySQL from FM using Execute SQL script step. The mysql table has a field which charset is utf8 (utf8_uncode_ci). The field in filemaker contains a lot of characters (arabian, greek, danish..) that once written in MySQL returns only question marks (!). I tried to use 'SET NAMES utf8' SQL statement before update record and I tried to configure ODBC driver to work with UTF8 charset by default. Exporting the SQL statement generated from FMpro instead of Execute the query, then copying and pasting the same code into SQLyog (a GUI for MySQL) the characters are correct.. how can I set filemaker to export the …

there seems to be some major bugs in the new 11.x odbc driver that comes with filemaker any suggestions would be appreciated. We are trying to pull data out of filemaker and into sql server via the odbc driver using ssis/dts or linked servers do not work becuase the driver is not returning any metadata (ie column names/types) and any attempt fails becuase both methods need this to map input columns to output columns. So then i tried a solution that should not require meta data.. using vb script (you run the following with the cscript command) this should work on anyones install and pulls data from the sample database and generates a file: but in th…

Hi all, I am not sure where to post this as the Filemaker GO forum doesnt seem to be too active. I have a pretty simple problem (I hope) that I need help with. At work we have a central FM Pro database on a shared drive that contains research data. We just purchased iPads and Filemaker GO so we can take data remotely (and not always record the data directly on our PC's). My question is, how can we have multiple copies of our database out there on multiple iPads, that would sync (or add) the data directly to the central database? I briefly played around with it, and all I saw upon syncing was a "save to" location. I am guessing that just saves the database…

Hello, I am using filemaker pro 9 to enter marks for students, and the mark sheets are supplied as excel spread sheets. Right now I am copying the student number from the spread sheet, and pasting it into the search box, then clicking new, and keep doing that until I have entered all the student numbers, and then I click search. This works fine, but I am sure there is a way to highlight all of the student numbers from excel, and then search them all at once? As in highlighting the whole batch of student ID numbers and searching in filemaker as opposed to individually copying and pasting into the search function... Also, once I have done this I have to type in th…

Hi, Has anybody any experience of linking to Apple Address Book using Filemaker? Is it possible to have 2 way updating? Best regards, Simon

The issues with UI/data separation just keep popping up as I go along! In my integrated file I had privileges set for record access (deletion in particular) that referred to the layout the user was in (layout that is now in the UI file). With separated UI/data, the privileges calling on layout names or layout tables are no longer protecting my records. For example: --> I do not want to prevent deletion entirely in that layout, and I do not want to permit it entirely either. --> I want to permit deletion when child_table::field <>"√" --> I want to allow deletion of records (including child records that are √) when the parent related record …

Well, I have tested ODBC & FileMaker 11. Did this back in the summer. Just now getting to put it in production. Was able to view & edit SQL Server Data in a Version 11 Client, mounting the SQL Server Tables as FileMaker Tables. I installed the ODBC Driver on the Client Machine. Server 11 Advanced has an option for enabling ODBC. What I don't know is "the details". Nothing obvious & haven't seen any posts. Does the Server option allow us to install the ODBC Driver on the Server, and have Clients use it? (Or do we still need to install drivers on the Clients?) Will be testing this weekend. Just curious if anybody knew anything abou…

We've recently set up ODBC drivers (latest Actual drivers) on our FM Server machine (FM Server 10 Advanced, OS = OS X Server 10.5.8). We are currently trying to use it in a simple implementation, wherein we can import new records from our MySQL webserver directly into our FM production database. We're not using any relationships to any MySQL table occurrences, I just created the table occurrences for the external source to allow us access to the data in FM. In my current method, I run a script that finds the highest id in our production database, then performs a find in the MySQL table for all ids greater than the highest that's been imported. It then runs an im…

I need to be held by hand I guess. I try Filemaker Pro Advanced. I got the part that you must share it. Done. How do you install a Filemaker ODBC driver that you can use in a DSN? I will connect to it with MS Access 2010. In the ODBC Data Source administrator (W7), the only thing close is to use File DSN, then advanced and define driver-specific keywords and values (what ones exactly if so)? Am I on the right track? Thanks for any detailed answer.

About every one out of 10 times my database can't find the external file (which has not been renamed or moved in any way) and displays <file missing> in fields. The startup script relies on finding the external file so I wonder if that might be the issue. However, 9/10 times it all works beautifully and the interface opens with all the fields populating from external file. It seems to have to do also with whether the exernal file is already opened or not. I am testing this on my computer (not hosted) and the end files will all be hosted. I am not familiar enough with external file behavior to know what is going on... Any thoughts?

I have split my fmp file into two: one is the interface with no records and the other is the extensive data with no interface. I did this so that I can have interface maintenance without long data imports. Both files have the identical arrangement of multiple accounts and passwords. I have a "log-in" script in the interface file (and also same log-in scipt in data file). When user logs in, the interface logs in but the data file does not login. This is a problem. When I manually log into the data file (with same account), all privileges align again. My Qs are following: 1) What causes accounts/passwords to be passed from interface file to the data s…

Right this is a biggy! Need some serious help here... or at least some pointers on where to go next. We're a company based in the UK that specialise in developing neat slick Filemaker apps that are upgradeable. As many of you will know, that brings with it a whole bag of issues in the world of Filemaker! We're currently employing techniques that involve registering all data set tables in a table of its own and recording info like primary table layout, key field, current/next serial number etc and using that info to export/import all data from an old copy and import into a new upgraded version. It is actually very slick but the development overheads are, as you imagin…

Hi, I want to work on oracle database using File maker. I imported table data from oracle into filemaker successfully. Now try to add some new records in FM database, it added successfully but by this transaction oracle table is not updated. I am missing some steps. Can any one help me in this regard. Thanks. --Shyam

We have filemaker server 9.0v3 advanced, ODBC sharing is turned on. We want to connect to our V2 database to get parts & other information into filemaker. I installed on the ODBC driver on the server: DataDirect 4.10 32 Bit, Progress SQL 92 v.9.1E, the driver is also installed on workstations Some clients have Fielmaker 9 and some Filemaker 11. What we'd like to do is have a live ODBC connection to our parts in our V2 database. Prior to this this driver was not supported for a live ODBC connection so we had a script that imported the records periodically, that solution didn't work all the time. I'm hoping there might be a better solution with the newer …

Hi All, With FM9 & ODBC (DataDirect 32-BIT SequeLink 5.5) driver, the following SQL statement worked (using MS Access): SELECT Employees.Name, LCase([state]) AS Expr1 FROM Employees WHERE LCase([state])="ca" Since FM is case sensitive, I have to force searches using lower case (same would work for upper case). All was working fine. Now the client has upgraded to FM 11 with the new ODBC drivers (Filemaker's own ODBC 11.2.70.0) and the same statement no longer works from Access and I get the message that LCase is an invalid function (#8309). Has anyone else received this error or similar with another function especially after upgrading past v9? What …

I am running Filemaker Server 10. I have written a script that runs every hour to update the MySQL tables based on a found set that determines which records are new or in need of an update. The script then uses the MySQL ODBC connection to push the field contents onto the MySQL table record by record and field by field. There are roughly a dozen of these tables, and the total execution time is around 40 minutes. Intermittently, we are getting ODBC errors, usually "[MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '[server name]' (10048)." Various tests have led us to believe that our approach is working too fast and is not opening and closing the MySQL connect…

Does anyone know of a possibility to change the path of one specific external FileMaker data source without giving the user access to the Manage External Datasources dialogue and with that exposing all other data sources to viewing and modification?

My graph (SQL tables to Router table to FM tables) SQL table::Key = Router::Key then Router::RouterID = FMtable::RouterID (RouterID is auto-enter serial) Router is used as interface between incoming ESS data and FM (80% of FM data arrives from outside sources). I import the SQL Keys only (according to varying criteria) then use the relationships to add/update/delete my FM data. Because I handle everything from the Router (using Set Field[] and Allow Creation), SQL data is never displayed and the process of 'synchronizing' is very fast. Concerns: After import, I have a found set which I need to loop through to do the work. Script checks the SQL …

Good afternoon! I'm working on getting our FMP database talking to our MySQL database using ODBC. We've got the connection working just fine, but the data is in the wrong shape - MySQL has everything we need stored in a table with three columns (uid, fid, value). We can get that to populate our FMP table, but what we'd really like is to be able to have FMP parse that data into a more horizontal/useful shape, i.e. with the user IDs as rows, the field IDs as columns and the values filled in accordingly. We talked to our web guy, and he put together a mySQL query that he thinks should do the job. Can anyone here take a look and tell me if there's a way to get FMP…

I am having a problem with instant web publishing. I have a field that uses values from another field in another file. While using file maker to all goes ok but when in the instant web publishing the values simply does not apears when clicking in the pop up field.... This is critical pls need help!

Just wondering if any has anyone has gotten a contacts table to sync with google/gmail contacts successfully.

Hi, We have a database that's built in FileMaker 11. it is hosted on FileMaker Server 11 Adlvanced. Our client has a software that runs some queries through Sql Server and ODBC on to our database to extract information from our database. The table that he is trying to query has 258 fields of which 93 are indexed. When he tries to connect to this table, it tells him that there are too many fields being indexed. How do we get around this issue? Is there a best practices for setting up a FileMaker database that will allow easy querying through ODBC/Sql Server? Or is there a different way he could connect to our database rather than ODBC that would solve this…

We're investigating redevelopment of a system that has a PHP front-end. Currently, PHP talks to our FM tables. However, response is slow and often users are shut out (20 users seems to be the max). We've read many threads that the WPE is the bottleneck. So, we're thinking of moving the tables to MySQL (at least those that interact with the website). The big question is: Is it worth it? Will we see the response speed improvements that we hope for? Anyone live thru this and have pointers to share?

I'm reposting this here because I have no answer in FM TechNet. This is a reply to someone else's problem in TechNet. No one has answered either one. Gary --------- This is exactly my situation, with the following variations: -SQL Server 2008 on Windows 2008 Server (not under my control) -Filemaker Server 10 on Windows 2003 Server -Microsoft SQL Native Client 2007.100.2531.00 -FilemakerPro 11 running on machine hosting Filemaker Server can easily Import files from the source SQL Server. But it cannot get the ESS connection set up to the same source. My error is the same as his. Gary ---------- I'm trying to access MS SQL …

I'm a bit lost here... I'm working on connecting with a MySQL database, just testing at the moment, to see if we could use it for something larger and more robust. This is my problem: Connected fine with the Actual ODBC drivers to MySQL, I can see the table, fields, etc... in a FM file when I set it up, however, if the MySQL table is edited outside of Filemaker, it adjusts the number of records that display in Filemaker (can't find the rhyme or reason as to which ones). It doesn't adjust the found set, but the records actually appear to 'disappear'. I put that in quotes, since if I go to list view, and refresh window, they momentarily appear (with "?" in the fields),…

I need a few data from an Oracle data bank which can be traced by ODBC. Not only the date, but also the time should be imported from the field “date”. But if I try to import the field “date” into filemaker, the new table only contains the date. In Access the import works without any problems. Do you have any idea how to get rid of this problem?

Hello guys, I have a question, i am connected remotely to my database. The server is installed on a computer with FM 11 server advanced. When i want to import from MySQL i got this error ( i can read and see the information in MySQL) The file “?” could not be opened. (Not Found) The previous script step, “Import Records”, could not be completed because of an error. Do you wish to continue with this script? Privilege for the Admin user is FULL ACCESS And the script has also the function FULL ACCESS ODBC is enabled in the server. Does some one know how to let it work? Greetings, Serhat Dalgara

Hi, Anyone able to explain why there is a difference in appearance of some of my portals when serving them from FM Server 11 and running them directly in the client? When served from FM Server nothing is shown in the portals though relation fields are valid, but running the same solution in the FMP 11 client shows all the data? (The relations are unstored calculations with more values to multiple different fixed values). ?

Hello everyone, my name is Valerio and i'm at the very first experience with FMP. I have a database with FMP to export to Microsoft SQL Server 2005 via ODBC. There are no problems until i need to export images from a "container" field from FMP to SQL Server. Opened external datasource in FMP via odbc doesn't show me the right column to export. In SQL server i used either varbinary or image as field datatype but no luck. Any help?

Hi All, I am trying to write a null or blank field value but I get an ODBC - update on a linked table failed. SequeLink Out of Memory error. This is either via a SQL statement or in table view. I'm using Access 2003, SequeLink 5.5, and FM 9 Pro Advanced. I have no problems writing the initial record as I am not populating those empty fields. But for an update (updating an address that no longer has Line 2 for example), I can't set Line 2 to Null or "". There are no validation requirements in FM. It is a Text field, no Auto-Enter options either. Any suggestions? I can't delete the record and re-insert it as that will throw off the primary index in…

Hi everyone, This issue has been frustrating me all day, any help is appreciated: Installed the ODBC driver provided by FileMaker 11 in the xDBC folder on Windows 7. The installation finished with a success message. But the ODBC Driver simply does not show up in the list of drivers and I am unable to access any FileMaker files using ODBC. See the ODBC Drivers list result and the registry values of the ODBC drivers. I have tried the following already: - Restarting - Uninstalling the ODBC driver and reinstalling and restarting again. - Deleting the Default string entry in the registry. None have helped at all.

Hello Everyone! I got a problem, thing is i just started using filemaker, and the first thing i want to do so is, to setup a Database on MySQL, so i can access it over Filemaker Pro 10 Advanced. I want it that way so i have the DB central on a other server plus i can edit it over Web (Frontend Filemaker and a Website for the customer) However, now i setup the mysql/odbc driver in win7 64bit, anything is ok, test sucessful and i can see the dbtable etc. The mysql is running and works just fine: Now when i switch to FM10, it simply can't find my local connection while i try to add a external source.... I made sure that its System DSN entry, i also booted…

I have a successful,ODBC connection from FMSA 10.0 to MySQL 5 server. I am not very experienced with MySQL, and I am trying to figure out how to preform the following call "call rpt_priv_dnswalerts_ids('entid asc')" using the execute sql script function. Do I need to have a connection to all affected tables?

Very strange and bothering behavior appears randomly in our company FileMaker (FM) system since we have linked it to another DB (MySQL). Occasionally when we access a FM layout with a table which is connected to an external MySQL DB a dialog "Find in progress" accompanied by cup of coffee appears. That process is not possible to interrupt - there is Cancel button which disappears after click on it but the process continues for 1-3 minutes and whole FileMaker is being blocked. Our system consists of: - FileMaker Server Advanced 11 (it happened at version 10 as well) and 25 FileMaker clients (versions 9-11, some of them Advanced) all running under Windows O…

Hello! I am trying to use a bar code scanner to read and import data into a datasbase. I have no idea where to start. Can someone please give me an idea where/how to start to get data imported into a feild? Thanks Kris

I am developing a system which will be available for different clients to use. My only differences from one client to another is a hand full layouts each customised for outputting quotes etc...... to simplify further development I have decided that I will use a separate file on the users machine to contain these layouts. my question then is how best to do this. I figure in my layout file i need to add the main file as a data source in order to display data. the layout file will be in a known location (I'll do it) but i cant be so sure of the main file. ideas?

My client has a database that has slowly built up over the last 20 years. Right now they are using FileMaker Pro 10. We are going to port this to MySql. I'm trying to figure out where I go to find the schema for this database. I do understand that FileMaker is much more based on its GUI than SQL databases, but I assume there is someway to see a list of tables, and their fields? I do not have FileMaker Pro Advanced.

In looking through the forum, I cannot find the exact answer for my question. My client has a FileMaker database on an internal server in their office. This database is part of their main FileMaker system that they use to run most of their operations. This database is connected to an external MySQL database that resides on an external server, namely their website server. The connection between the two was easy to set up. But, I am experiencing an issue that I need to resolve. I've added a layout to show the data from one of the MySQL tables in the FileMaker database. Fields from the external MySQL data source is the only thing being shown on the layout…

Hi, I currently use ODBC for communicating with FileMaker. I was wondering if FileMaker is case-sensitive as it appears to be with my queries. Can I change the field type to another storage type which is not case-sensitive(unicode) and does anyone know what this is? For example with MySQL you can set a field to unicode to be case-sensitive, but FileMaker appears to be case-sensitive what ever field storage type I select. Anyone with any experience on this topic? Thanks, Jim.