My job would be easier, or at least less tedious if I could come up with an automated way (preferably in a Python script) to extract useful information from a FileMaker Pro database. I am working on Linux machine and the FileMaker database is on the same LAN running on an OS X machine. I can log into the webby interface from my machine. ...
Hi everyone. We have a huge web application running on lasso, mainly because it first was a huge internal filemaker database, that was to be opened to the public as a web app. The web application doesn't use filemaker though, it runs on a MySQL database, recreated every day. The only reason I know of for using lasso is it's easy integ...
A potential customer has asked me to look at some promotional flyers for a couple of apps which fall into the contact management / scheduler category. Both use Filemaker as their backend. It looks like these two apps are sold as web apps. At any rate I had not heard of Filemaker in about ten years, so it was surprising to see it pop u...
There is a service running which monitors files in a folder on a server. Whenever files are copied to this folder, the files are moved and a record is written to a filemaker pro database through an ODBC connection. In that same process I need the ID of the newly created row to create a related record in another table (with a foreign ke...
FileMaker Pro has a feature that allows client applications to auto-locate their server's IP address and connect to it. What is the best way to do this using a general purpose language like Java or .NET? ...
I have an application that stores its user database to an XML file and I need to export selected fields to Filemaker so my client and mine the data on Filemaker. I managed to make XSLT file to import XML elements, but cannot seem to find a way to import any elements. Pointers in solving this problem are greatly anticipated. Example of t...
Hi All, I have a client that wants to use Filemaker for a few things in their office, and may have me building a web app. The last time I used, or thought about, or even heard of, Filemaker was about 10 years ago, and I seem to remember that I don't want to use it as the back end of a sophisticated web app, so I am thinking to try to s...
I'm using Filemaker Pro's Instant Web Publishing feature. I've added a simple text field and button to a layout, set up tab ordering and the option that makes the field move to the next stop in the tab order when the user presses the "Enter" or "Return" keys. This works fine in Client mode, but when I try it through the web interface I h...
Has anyone got a ODBC data source setup for FileMaker Pro 10 on Windows? The documentation that ships with FileMaker Pro 10 does not make sense as it is saying to click on a set-up file that does not exist. None of the forums are providing an answer either. ...
Hi I'm project managing a development that's pulling data from all kinds of data sources (SQL MySQL, Filemaker, excel) before installing into a new database structure with a record base through 10 years. Obviously I need to clean all this before exporting, and am wondering if there are any apps that can simplify this process for me, or ...
I have been asked to look into FileMaker for creating a pretty simple database app. The application will handle contact information, some information about events hosted by the organization and - and this is where I'm currently struggling - RSVP information that link the contacts and events, as well as stores some data about payment. Wh...
I've got a possible client who has mocked up an application in FileMakerPro, shown it to me, and said "can you do this, but I want it to run on both Linux and Windows XP?" He wants this application to sell with hardware that he currently sells. The main page of the app basically has a normal form at the top with the result of one query...
I need to extract and see the data in FileMaker Pro 5.5. Is there an easy method to hooking up a SQL client? At a minimum, if I cannot easily extract the data, I'd like to see the data. ...
I have a table like this: Application,Program,UsedObject It can have data like this: A,P1,ZZ A,P1,BB A,P2,CC B,F1,KK I'd like to create a layout to show: Application,# of Programs A,2 B,1 The point is to count the distinct programs. For the life of me I can't make this work in FileMaker. I've created a summary field to count prog...
I have a filemaker script that inserts a new entry on several imported mySQL tables. I need to get the unique id of these entries as they are created (before or after, either way) so I can refer to them later in the script. This is easy to do in SQL with LAST_INSERT_ID(), but I can't seem to find how in filemaker. What I have tried that...
I hope I don't lose anyone by mentioning Filemaker. I am trying to turn it's XML export into something usable by SSIS. FM's native XML export has field names and data in separate sections of the same XML file. This lists what I need it to do, what I currently did, and the original FM export at the bottom for reference. I have not see...
i have CONTACT table and ZIPCODE tabel they are related.i want a script when a user type the post code if isn't in zipcode table then get stored there.if not then get stored in CONTACT table.i'm not familiar with isempty(field) how to achieve this?please somebody help me ...
I'm using FileMaker Pro 9 and I want to take a database with repeating records (e.g. one field is "Lines" and it can have up to 9 strings) and import data into it from an XML file. Right now, with the following XML file, I only get the first entry imported ("Room"): <?xml version="1.0" encoding="UTF-8"?> <FMPXMLRESULT xmlns="http://www...
I'm about to start a fairly large project for a mid-sized business with a lot of integration with other systems (POS, accounting, website, inventory, purchasing, etc.) The purpose of the system is to try to reduce current data siloing and give employees role-based access to the specific data entry and reports they need, as well as to rep...
Im trying to get the contents of a webpage put into a field in Filemaker pro 10. Does anybody know the code to do this in the scripmaker? I have a field called URL that has the url I want and a filed called content, this is where the source html will go once FMP has grabbed the web page. Thanks for reading. ...