John P | 30 Oct 19:43 2014

Re: Standalone CWP PHP instance on Mavericks

Interesting in that when I’ve tried installing the FileMaker folder and FileMaker.php file from the file inside the root directory, and at several levels above (changing
the include reference each time) and I keep getting these errors in apache's error log:

[Thu Oct 30 11:08:15 2014] [error] [client] File does not exist: /Library/Server/Web/Data/Sites/
[Thu Oct 30 11:08:15 2014] [error] [client] PHP Strict Standards:  Non-static method
FileMaker::isError() should not be called statically, assuming $this from incompatible context in
on line 39
[Thu Oct 30 11:08:15 2014] [error] [client] PHP Fatal error:  Call to undefined method
FileMaker_Error::getRecords() in
/Library/Server/Web/Data/Sites/ on line 178

Again, if anyone has specific details about making this work (php pages on ordinary Mac OS web server, no FMS
install, pulling data from another Mac OS box running FMS13) or can refer me to recommendations with
details on other lists I’d be grateful.

John P
jplist <at>

> On Oct 30, 2014, at 12:20 PM, fmpexperts-request <at> wrote:
> Mike, is the "latency" because the FMS and webserver are hosted in different locations? I can see that
being a potential problem.
> John, specifying a host is specifying a host. Where is that done now when you use FX.php? The same would be
similar for "calling" the FMS/API.
> Beverly
(Continue reading)

dealTek | 30 Oct 19:03 2014

Trying to Speed Up a Looping Script

Hi all,

Currently this is a local file with FileMaker 11 and a multi file solution.

I have a medium complex looping script, and I am trying to speed it up

Midway in the script it opens a new window and performs a search on 3 million records

I put a speak command at several points throughout the script, So I know this is the slow section

For the first 10 or 20 times through this looping script section, it goes pretty fast (1 sec), then it slows
down (3 to 4 sec.).

All fields are indexed

I tried speeding up the search by doing a multi tiered search

1 - search -  thedate (date = 2014)
2 - constrain found set - somefield1 = "xxxx"
3 - further constrained sound set - somefield2 = "xxxx"

- this helps speed up the search

but problem still happens after 10 or so iterations.

Since it is looking through 3 million records to search, that might have something to do with it?

My Guess: since it goes fast at first and then start slowing down – I am guessing that it might have
something to do with the cashe/clearing?

(Continue reading)

John P | 30 Oct 16:09 2014

Re: FMPexperts Digest, Vol 80, Issue 67

Malcolm, understood, and that’s the very issue I am dodging; the computer running Mavericks and Mac OS
Server does NOT have any version of FM Server installed since I want to avoid that apache takeover
conundrum.  I have mySQL running on the web server which I want to continue using, and FM specifically
recommends that mySQL and FMS NOT be running on the same machine.  Also installed SSL certs which I’d like
to keep using.

Beverly offers a tantalizing solution, but I’m not expert at web server configuration; do these lines:

> HOST: <<ip/domain-to-FMS>>
> 	then: include 'HOST/<<path-to-fm_api_php>>

go into the /etc/php.ini file?  If not, exactly where should it go?  If in that php.ini file, does it matter
where in the file?
Does the ip/domain illustration mean that I can use either a domain name OR an IP address? I’d prefer IP
since I may end up having to change the domain name, but not the IP.
Should the HOST line be bracketed, e.g. [HOST=]
and the next line, for a typical install, be:
Is it include, or include_path?
Is the path to fm api the one used in the FMS generated php.ini file, e.g.:
include “HOST/Library/FileMaker Server/Web Publishing/publishing-engine/php/mavericks/lib/php"

For relative dummies like me, the file and location in which the text should go and a working real world
example of the text to be inserted (with IP or host name substituted of course)  would be helpful.

John P
jplist <at>

> On Oct 30, 2014, at 8:42 AM, fmpexperts-request <at> wrote:
(Continue reading)

Patrick Neame | 30 Oct 10:45 2014

Chart scales

Dear all,

I'm making my first foray into charting with FM13 Advanced but having a bit of a struggle with one aspect of
the magic.

My people are displayed in a portal, I click on a portal row and all that person's data is displayed. So as I
work between people some will have earned 15 points while others will have earned 3. The trouble is the
scale adjusts itself each time so that the bars are roughly the same length and you have to engage in some
visual gymnastics to make sense of what you're seeing or compare two people. If it helps with the answers,
anything more than 20 points is so goody goody as to be irrelevant so a 20+ point bar can just fill up the
entire X axis.

Many thanks,

Patrick Neame
FMPexperts mailing list

John P | 30 Oct 04:02 2014

Standalone CWP PHP instance on Mavericks

Seems like this ought to be simple, but…

I’m trying to set up a box running OS X 10.9.5 using Server 3.2.2 in order to serve CWP PHP pages getting data
from a separate machine running FMS13.0.3.300.
I’d prefer not to use the FMS installer 2-machine “worker” method if possible.

On the machine I’m trying to set up, FX.PHP works just fine to access the remote FMS13 server.
I can’t get the FM API to load properly, however (tried using the FM_API_for_PHP_Standalone files in
several different locations to no avail).
The machine I am trying to set up is running PHP 5.4.30 with the loaded configuration file pointing to /etc/php.ini
The configuration file (php.ini) is the default /etc

EXACTLY how can I get the PHP loaded configuration file to point somewhere else instead, e.g.
/Library/FileMaker Server/Web Publishing/publishing-engine/php/mavericks/lib/php.ini ?

Tried various edits of httpd.config, php.ini to no avail.
Anyone had success doing this?

John P.
jplist <at>

FMPexperts mailing list
FMPexperts <at>
Jesse Barnum | 29 Oct 18:34 2014

Uninstall FileMaker Server 12 on Yosemite

I’ve recently updated to Yosemite. When I try to run the FMS 12 installer application so that I can
uninstall FMS 12, it hangs on the installing screen. Has anybody else run into this problem?

--Jesse Barnum, President, 360Works <>
Product updates and news on <>
(770) 234-9293
== Don't lose your data! <> for
FileMaker Server ==
FMPexperts mailing list
FMPexperts <at>
Reimer Gary | 28 Oct 17:53 2014

reporting qualified orders over the past two years.

Hello experts;

I am truely stuck trying to provide a report that has been requested of me. I apologize in advance for this
long submission. Please note that I'm using FileMaker 12 and FileMaker 12 server on a Mac

It started with a request to compare sales totals and sales count between this year and last year for a
specific list of customers. So I wrote a script that stepped through the list of customer ID's and using a
couple of executeSQL statements and some global repeating fields to hold the results for each customer,
displayed those results on a layout and voila, the request was satisfied. 

Then the next day another request came in. Instead of the particular list of customers, could this report be
prepared for all customers who in either this year or last year had more than a user specified number of
orders and who were of a user specified customerType? I've been going around in circles with this for few
hours. I've been thinking that this would probably involve building a temporary order table that just
contains the orders from qualifying customers. Then I could use my previously created SQL statements to
do the same analysis as in the original request. But how to find the customers and their orders? 

I have the usual customer table related to the order table by customerID. Each customer has a customerType
which is also in the order table. My client wants to be able to specify a minimum order count (minCount) and a
customerType. So what I want is:
1. to find all the orders in the past two years for customers who placed more than the minCount number of
orders either last year or this year and who are of the requested customerType. 
2. Then looking at their orders over the two year period I want to count the number of orders and the total
value of orders for each customer, this year and last year and present that data as well as percentage
change between this year and last. 

If I can isolate the orders from step 1 in a temporary table, I already have the code to do step 2.

I can create a relationship between customers and orders using a start date, end date and
customerType—this gives me all orders placed over the past two years for a particular customerType.
(Continue reading)

Hans Gunnarsson | 27 Oct 11:55 2014

Sending SOAP calls from Filemaker

I’m using FM 13 server and clients.
The server is on a Windows box and the clients are running on Macs


As far as I know communicating with a SOAP service goes something like this (Please correct me if I’m
wrong) :

In a variable I create the XML code required by the service I want to look data up from.
In addition to what I might consider “normal" XML code I place the code in a "SOAP wrapper”
So it looks something like the code that is at the bottom of this message.

I then need some mechanism to send the code to the service.
And I need to be able to receive the reply returned.


I have a few questions regarding this...

How do I send the message?
Is it done using some of the built in FM script steps or do I need a plugin?

Sending the request then probably returns another SOAP wrapped set of data which I then have to parse /
import, similar to when reading “normal” XML data.

What would be the most direct way of reading it?


Sorry for the “beginners” questions but I just realized that I’m pretty adept at creating and
(Continue reading)

dealTek | 27 Oct 01:20 2014

Curious if there are any issues with the new java 8 and fmserver 13?


Curious if there are any issues with the new java 8 and fmserver 13? 
I know v13 isn't supposed to have any problems with java but I just thought I'd check...

Stephen Wonfor | 26 Oct 00:29 2014

Conditional Value Lists - Again


I have no idea why this is always such a struggle.

I have a PRODUCTS table that has id_vendor for each product.
I have a PO table where id_vendor is captured.
I have a PO_Details table as a portal on the PO layout.
The PO_Detail table has an id_sku_vendor field on it.
I would like to have a menu on id_sku_vendor using a value list that shows only those products that vendor supplies.

I have, in the past, sometimes got things like this to work.   Yet I never really grasp how I did it.
I struggle endlessly when I get here..."Use Values from a Field" and "Include Only Related Values Starting From..."

Is there an understandable explanation of what to do next?  I have read help files, I have looked at examples
that work...I just don't get it.



"Working in the theater has a lot in common with unemployment." -- Arthur Gingold

FMPexperts mailing list

RE: Creating an Excel file with a chart from FileMaker data [typo]


Thank you John, Mikhail, Doug, Ben Wim (did I forget someone??).
These are all great ideas. Here is what I am going to try:

1. This is on Windows 7 only, not Mac. (However the process below should
work on both platforms.)
2. Since I have done a lot of file/data exports in FileMaker, I am
comfortable with that.
3. I will create the charting template in an Excel ("Main") file, with
references to a data file.
4. I will create an Excel ("Data") file for data with which to model the
chart in the "Main" file.
5. I will store the "Main" file in a FileMaker container field.
6. I will create a routine in FileMaker to perform the following steps:
	--a. Export the "Main" file to a specified path
	--b. Export the FileMaker data as the "Data" file to a specified
	--c. Open the "Main" file from FileMaker (really export/auto-open)

Comments anyone?

(Sorry about thread subject name change, but I could no longer deal with
reading my own dyslexia "Cretaing".)


Jonn Howell
DataExperience, Inc.
Certified FileMaker Developer
(Continue reading)