filemaker

Best way to extract data from a FileMaker Pro database in a script?

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. ...

Filemaker & lasso: viable web application ?

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...

What Are the Pros and Cons of Filemaker ??

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...

Retreiving ID of a newly inserted row in Filemaker Pro

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...

Auto-locating a client's server

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? ...

How to import attributes and elements from XML to Filemaker?

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...

MySQL AND Filemaker Pro?

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...

In Filemaker Pro IWP, how do you force a text field to disallow carriage returns?

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...

FileMaker Pro 10 and xDBC ODBC Plugin

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. ...

cleaning datasources

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 ...

Creating "complex forms" in FileMaker - is it even possible?

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...

FileMakerPro equivalent for Linux?

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...

FileMaker Pro 5.5

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. ...

FileMaker Layout

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...

Filemaker Pro 10: How to get the unique ID of last insert on mySQL tables (ODBC)

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...

XSLT question. How to pair field tags with data when original XML has them in separate sections?

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...

how to script with isempty in filemaker?

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 ...

How does one import XML files with repeating fields into a FileMaker database?

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...

technology recommendation for LAN Dashboard

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...

Filemaker 10 get url put contents into field

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. ...