filemaker

filemaker.php next/previous buttons on record detail page

I'm using filemaker server 10 and the filemaker.php API. on the record detail page, I'd like a "next" and "previous" button to allow browsing the next/previous buttons easily (without having to go back to the list view). is this possible and how? thanks ...

Help with replacing Mac factory install of apache with MAMP PRO so FileMaker will work with my other websites?

I am running Mac 10.4 and have been using MAMP PRO to host several websites I manage. Now that I have installed FileMaker Pro Server, it forces me to turn Web Sharing on in System Preference. So is it possible to either replace Apache with MAMP PRO's version? Or is it possible to get FileMaker Pro to use MAMP instead of Web Sharing? I...

Transform data in FMPXMLRESULT grammar into a "Content Standard for Digital Geospatial Metadata (CSDGM)" compliant XML

I have a problem in FileMaker; I wish to link the METADATA element/FIELD element “NAME” attribute to its corresponding data in the RESULTSET element/COL element. However, I also wish to map the METADATA element/FIELD element “NAME” to "Content Standard for Digital Geospatial Metadata (CSDGM)" metadata elements Sample XML Metadata Reco...

FileMaker Pro vs CiviCRM

Hello, I would like some input about these two softwares since we are trying to change our current Access database, which has brought many problems and is completely outdated (it was built 10 years ago). These are the 2 options we have in mind and being a non-profit organization (20 employees), it's quite a big decision in particular i...

Filemaker - Getting field values from related table

I have the following setup in Filemaker Pro 10. Table1 with: id_table1, related_names Table2 with: id_table2, name, include and a joint-table with: id_table1, id_table2 Now I want either make related_names a calculated field or write a script that sets related_names to a comma separated list of all names which are connected through t...

Filemaker Pro 9 (Mac) : How do I get it to deal with absolute paths?

I have an installation where FM Pro 9 clients open a solution from an FM Server 9. This solution then needs to access files on a network share from the clients. So far, the network share was mounted with AFP, but an infrastructure change required it to be switched to static NFS mounts. Their boot Volumes may have different names, but t...

Simple conditional script for Filemaker

I'm trying to create a script in filemaker that returns true if table::field = 1 for a certain dataentry, and false in all other cases. How do I do this? ...

Filemaker XSL Select Column By Name

I am looking to export from Filemaker using column names (instead of positions). Currently I export the following XSL stylesheet that exports by position with: <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fm="http://www.filemaker.com/fmpxmlresult" exclude-...

How does Alpha Five Version 10 Rate for Web App Development

I came across this RDMS via the advert on stackoverflow. Seems to be in the vein of MS Access / Filemaker / Apex database development tools but focused on web based applications. It quotes rave reviews from EWeek and a favourable mention from Dr Dobbs regarding its ability to create AJAX web applications without coding. The Eweek rev...

Most efficient way to query joined tables in Filemaker Pro 10

I am tasked with extracting data from 2 tables: Master and Charges. The common key is two alpha fields. I need to filter the results by fields in each of the two tables-- Year and Office in the Master, and another alpha field in the Charges. There are over a million master records, and about 4 charges for each on average. The tables ...

Filemaker: making queries of large data more efficient.

OK I have a Master Table of shipments, and a separate Charges table. There are millions of records in each, and it's come into Filemaker from a legacy system, so all the fields are defined as Text even though they may be Date, Number, etc. There's a date field in the charges table. I want to create a number field to represent just the y...

Sending and retrieving a constant field

Hello, I'm using Filemaker 11 to manage content over Custom Web publishing, with a json xslt sheet to convert the XML to a json format is there any way to add a parameter to the url, and have it come back down without modifying it? I thought about globals, but from what I can tell if two requests were sent within a short enough amount o...

Issues with Filemaker IWP working with hyperlinks on images

I have a filemaker database that I need to be able to link records and all associated data (including container field data) to various points placed on a large PDF image, and then make that data appear via instant web publishing when someone clicks on the marker for that area on the PDF. For example the PDF may be an image of a car, and...

how can I restrict user access on specific pages? (Drupal, php, FileMaker Pro 10)

I am working on a website which already has user access set up so that only members who are logged in can see certain pages. Now i need to go in and make the access for logged in users more specific. So, anyone who logs in can see the site, but there are 2 pages (called PDQ and Comm Plus) that should only be accessed by users that have P...

Filemaker CWP safety

In developing a CWP, is there a way to use the record id and mod id to enusure the record has not been modified since to provide a fallback instead of a race condition if 2 updates are sent? ...

How are people copy protecting FMP runtimes?

I have a slew of choices for Real Basic and Revolution but the only folks who seem to have offered scripts for time trials and registration of FMP runtimes have disappeared. I can essentially port over the code from other projects but I'm wondering what others are doing. Is there a good library of code for this or is everyone home brew...

Importing text into SQL Server from FileMaker via ODBC

Our client is trying to export their data from their FileMaker 10 database into a MS SQL system via ODBC. We have the DSNs set up, and can import date and number fields, but text fields fail with: “requested conversion is not supported” Cannot get the current row value of column “[TQG6]...[Referral].ReferralAccountName” from OLE DB pro...

Best-Practice: How to set a certain field in each related FileMaker record to a certain value

I have a FileMaker script which calculates a value. I have one record from table A from which a relation points to n records of table B. How to best set the same value for the same field on all those n B-records? Just doing Set Field [B::Field; $Value] will only set the value of the first of all related records. What works however is th...

Filemaker Loose Query

hi everyone, In SQL based db's, I'm able to perform a "loose" query by appending e.g. %taxi% and consiquently get an entry containing taxi in it (e.g. w10taxi or taxiAirport or parcelTaxi). How do I do this in FMP? (I've tried ~taxi but this appears not to work) I'd appreciate any help. thanks in advance Giles ...

filemaker pro export and import to mysql via php

could anyone advise me direct me to a site that explains the best way to go about this I'm sure I could figure it out with allot of time invested but just looking for a jump start. I don't want to use the migration tool either as I just want to put fmp xml files on the server and it create new MySql databases based on the fmpxml results ...