[FX.php List] Parsing FP7 XML data

[Chris Hansen]

Paul,

Tricky things those time zones and permissions :-p  In order for  
FX.php to work, XML access needs to be enabled.  PHP access is  
something that FileMaker set up for their API (since they don't want  
it tied to the XML API.)  Try turning that extended privilege on, and  
see if that doesn't help.  And thanks for the kudos!  Best,

--Chris

On Jul 8, 2009, at 2:03 PM, Paul wrote:

> Hi Chris
>
> Thanks for the quick reply. I was sleeping when it arrived - we are  
> out
> of kilter with you guys, us being in new Zealand.
>
> I changed the port to 80.
>
> Clicking on the link I get a Page cannot be found error from the  
> Browser
> Internet Explorer. Both with port = 80 and port = 16000.
>
> Just wondering:
>   The Home IP for the browser is 127.0.0.1
>   Filemaker Server is 192.168.29.252 - the IP address of the computer.
>
> I think that is the correct thing to do isn't it? I set it up to do  
> the
> Filemaker test pages which work OK.
>
>
>
> But there is something else strange. I used Filemaker Site Assistant
> which works OK with the Filemaker example file.
>
> But if I try to make a site with Book_List.fp7 or Contacts.fp7 using
> Admin and no password I tells me I have the wrong Username and/or
> password. I did add PHP priv to Book_List.
>
> I do not understand that - the Account Admin does have full access and
> no password.
>
> Is it OK to have everything on one computer? I do have a network so I
> can spread it around - but tried that and it made no diff.
>
> Cheers- and thanks for you time - the DEBUG and DEBUG FUZZY look  
> great;
> well so does the whole thing.
>
> Paul
>
>
>
>
>
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Chris  
> Hansen
> Sent: Thursday, 9 July 2009 3:47 a.m.
> To: FX.php Discussion List
> Subject: Re: [FX.php List] Parsing FP7 XML data
>
> 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
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>