[FX.php List] Parsing FP7 XML data

[Chris Hansen]

Paul,

Yes IIS has port 80.  And so should FileMaker.  You see, the way that  
FileMaker works is that server installs a customized version of a java  
application server (Tomcat, I believe) which is integrated with IIS on  
Windows or Apache on the Mac (this is what the Web Publishing Engine  
-- WPE -- is.)  ALL requests, go through the active web server (IIS in  
your case), and requests for FileMaker data (distinguishable by that "/ 
fmi/xml/" in the path get redirected to that application server BY the  
web server.

Okay, so that URL that comes up should work when you click on it.  If  
you've configured everything correctly, that URL will connect to the  
web server, which will note that it's a request for FileMaker data,  
and pass on the request to the WPE.  At that point, the WPE will grab  
the data from FileMaker, and IIS will return the resulting XML to the  
browser.  So, what happens if you click on that URL?  (Yes, that URL  
works just fine with PCs -- most clients that I've worked with use  
PCs.)  Let's start with that, and go from there.

--Chris

On Jul 8, 2009, at 5:11 AM, Paul wrote:

> Hi
>
> I have spent a good few hours trying to get FX to work, but cannot  
> get the find queries working.
>
> I have FPServer 9 Advanced on a PC.
>
> PHP is working fine.
>
> IIS is also installed; although I can stop it – with no beneficial  
> effect.
>
> IIS is 127.0.0.1 – localhost
>
> FMS is set to 192.168.29.252  and port 16000 – as IIS has copped 80.
>
> I try FX_tester.php – getting the IP and port and FP7 correct etc.  
> It does connect to the server – if I change the username or password  
> to something false it tells me that it does not connect to the  
> server. So it is connecting with    Admin and no password
>
> However I get this message – which many others get until they get FX  
> sussed and working OK.
>
> Using FileMaker URL: http://Admin:@192.168.29.252:16000/fmi/xml/FMPXMLRESULT.xml?-db=Contacts.fp7&-lay=web_list&-max=all&-findall
>
>
> Now I understand some of the code but not all. But this line tells  
> me that we are trying to create an XML file
>              192.168.29.252:16000/fmi/xml/FMPXMLRESULT.xml
>
> and then parse it.
>
> Now for a PC this is not a valid address.
>
> Maybe my thinking is wrong and this file is never supposed to be  
> created – like virtual –
>
> After the lines
> Ob_start();
>
> Curl_exec      etc
> $data = trim (ob_get_contents() );
>
> ob_end_clean();
>
>
>
> $data is not empty – it has 1108 bytes – but only fHTML formatting  
> code – no data from the database – Contacts.fp7.
>
> Same with other databases I have tried
>
> Any ideas? Guess a lot of people are using Macs – where it may be  
> straight forward and perhaps that URL is valid.
>
> Should I completely re-install without IIS???? – or do you guys have  
> IIS installed – if you are using PC. I suppose you use Apache on Mac.
>
> I would really like to use FX – but have come to a dead stop.
>
> Cheers
>
> Paul
>
> paul at mancomp.co.nz
>
>
>
>
>
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list