Hi Guys,
Just wondering if anyone has any experience displaying XML documents using something similar to the RSS data source tool that uses asset listings to display it's contents.
What we're trying to do is take some data from an 3rd party system in XML and display it as cleanly as possible. There will be quite a lot of nesting within this content and also many fields that could repeat 0 or many times.
I know it's a long shot but I thought I'd just check anyway.
Also could I add to this post that I find the fact that you have to search for words of 4 or more chars quite restrictive especially in this case (searching for XML, RSS etc.). 
[quote]Just wondering if anyone has any experience displaying XML documents using something similar to the RSS data source tool that uses asset listings to display it’s contents.
[right][post=“15376”]<{POST_SNAPBACK}>[/post][/right][/quote]
We are in the process of setting up remote content to get data from another system - but we’ve got the other system to output pre-formatted HTML.
I’m not sure if the RSS data source can take arbitrary XML tags, but if it does this should be possible provided it takes the basic form of a feed.
Sounds as though it is more complex than this, so you could take the output XMLfrom your remote system, and use XSLT to style it on the fly and then read that with a remote content asset.
cheers,
Richard
RSS Data Source asset does not accept arbitrary XML. The transformation you're after (XML->HTML) is not possible with pure matrix tools. You'll probably have to write a connector script that consumes the XML and produces HTML, then you bring the HTML in using Remote content.
XML Source --> Converter (XML to HMTL) --> Matrix (Remote Content)
If XML has lists you might have your converter produce an RSS feed and bring that in through RSS Data Source.
Either way, connector is required.
You are able to customise the minimum word length, together with other search options in System Management Folder > Search Manager > Details Screen > Noise Words Section. (If you set 'Minimum Word Length' to zero, it will disable the option).
As for the XML display, we currently cache most of our report data to xml files, and generate report content using the xml parser. I am sure that something similar can be done for your case. Please contact your account manager if you are interested.
Hi Guys,
Thanks for the replies, I was considering using XSLT but it could be easier to just try to get something developed. We probably will end up contacting Squiz to develop something for our needs when the time comes.
As for the part about the minimum search fields: I was actually talking about searching [i]this[/i] forum, not searching within Matrix. :D
[quote]As for the part about the minimum search fields: I was actually talking about searching this forum, not searching within Matrix.
[right][post=“15383”]<{POST_SNAPBACK}>[/post][/right][/quote]
Yes, this is the MySQL full text index default. I’ll look at modifying it to 3 characters. I know its annoyed me in the past too.
[quote]Yes, this is the MySQL full text index default. I’ll look at modifying it to 3 characters. I know its annoyed me in the past too.
[right][post=“15384”]<{POST_SNAPBACK}>[/post][/right][/quote]
Avi,
I second the idea of modifying the Forums Search tool to limit at 3 chars…that would be great
Thanks,
A
[quote]I second the idea of modifying the Forums Search tool to limit at 3 chars…that would be great
[right][post=“15433”]<{POST_SNAPBACK}>[/post][/right][/quote]
I’ve sent the request to our sysadmins. It requires bringing MySQL down to change server settings and such, so I’m not sure when it’ll happen. I’ll post an announcement once its done though.