Symphony.

I’m making an application for a broker. He puts houses inside a XML document on the net by using a program called “Effector”. To attach a Dynamic XML to symphony I have to made “Data source”.

Inside the “Effector” documentation I found the following piece of code to get the XML on your webpage: You can call the web service through a reference in your application to continue to: http://ws1.vbo.nl/EffectOnTheWeb/Makelaar.asmx

With the following sample of code you can retrieve the database.
Dim ws As wsvbo.Makelaar = New wsvbo.Makelaar( )
Dim ds As DataSet = ws.MijnAanbod(12345, “user”, “password”)  

And may bind to a grid
MijnGrid.DataSource = ds
MijnGrid.DataBind ( )

Can someone help me to get the XML on Symphony?

The URL you’ve provided isn’t a straight XML endpoint - it’s a web service that’s expecting you to send a properly formatted SOAP request, upon which it will return a SOAP response. The easiest way to do this is to have some form of intermediary script call the web service (http://ws1.vbo.nl/EffectOnTheWeb/Makelaar.asmx) and return the XML result to Symphony.

There is an older discussion in the forums that’s still relevant: http://symphony-cms.com/discuss/thread/350/.

Your code sample is ASP.NET (VB.NET) which is able to natively instantiate a connection with your Web Service as a native object (ws), which then binds itself to a DataGrid (an ASP.NET control which produces an HTML table on a web page).

Because your Web Service is created with .NET I imagine the code samples in the documentation are assuming you are using .NET to consume the service also.

As Tony says, take a look at the other thread for more hints. What you will need is a small intermediary PHP script to make the SOAP request for you (e.g. using SoapClient, and return the XML. It would be this script that you use as the URL for your Dynamic XML Data Source.

Alright, thanks. I’ll try to solve the problem with the other thread. I’ll let you know when it works or don’t work.

So this is a bit difficult for me. I’ve placed the .pdf file of the web service as an attachment of this post.
When I’m understanding you both well, I have to made a PHP script where I call the web service http://ws1.vbo.nl/EffectOnTheWeb/Makelaar.asmx

Then I should return the XML into Symphony. But how can I do that, which script should I use?

Attachments:

aanroepen.pdf

You should be able to start with the PHP example on page three of the PDF. Just save this into a .php file on your site and use it as the URL when creating the Dynamic XML Data Source.

I’ve made the PHP file with this code:

<?

class MijnAanbod {
    public $kantoorID;
    public $userName;
    public $passWord;
}

$aanbod = new MijnAanbod();
$aanbod->kantoorID = 5555;
$aanbod->userName = 'xml';
$aanbod->passWord = 'xml';

$client = new
SoapClient("http://ws1.vbo.nl/EffectOnTheWeb/Makelaar.asmx?WSDL",
array('trace' => true));
$result = $client->MijnAanbod($aanbod);


?>

But there is no result when I go to the file on: http://www.reitdiepmakelaardij.nl/workspace/utilities/effector.php

Is this the right use of code?

Try adding this to the top of your code:

ini_set('display_errors, 1);

This should show you a specific error instead of a blank white page. This forum is specifically for Symphony help and not for PHP, but you should make a start by familiarising yourself with PHP’s SOAP class and the examples here.