Generating XML using CMS

Re: [meg] Generating XML using CMS

Sat, 27 Dec 2008 18:22:46 -0800

Hi Meg,

It might be quickest if I could just take a look at the code directly. If that works for you just email CMS and FTP login details to dave@interactivetools.com (email, don't post login details to the forum). And also include the url to the plain text xml file that is working, the php version that isn't, and the flash page that displays them.

I'll post back here or via email with the solution. Hope that helps!

Re: [Dave] Generating XML using CMS

Tue, 23 Dec 2008 18:09:19 -0800

Hi Dave,

The plain text .xml file is working fine. Here is a sample of it:

/images/
2
3
_top
true
true
true
true
2

2647082839_49ce52e3af_b_002.jpg
boat

2593699391_5d6e065f8b_b.jpg
boat

Even when I changed the file to a xml.php with the heading
'); ?>
and using the same code as above, the gallery works.

When I change the caption to:
"
This error occurs:
undefined variable:upload in data/home/etc... (the directory path to the config.xml.php file)

How can I have it display the caption text?

Regarding the image url in the xml, whenever it switch the code to this (see below) I just get a black screen within the swf.

'); ?>

require_once "/data/home/url name/docs/cms/lib/viewer_functions.php)";

list($artistRecords, $artistMetaData) = getRecords(array(
'tableName' => 'artist',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$artistRecord = @$artistRecords[0];

?>

/images/
2
3
_top
true
true
true
true
2

"

Instead of referencing a URL, is referencing the directory path and the XML can't reference the directory path. Again, I'm uploading the images in the CMS to the original folder that the regular .xml was using. In regards to the caption, it states undefined variable. I'm not as clear how to handle this.

What are your thoughts?
I attached a sample of the swf file as well. The folder tree goes as such:

swf
config.xml.php
images (folder)

Please help! javascript:%20addTag(':/')

Re: [meg] Generating XML using CMS

Tue, 23 Dec 2008 16:56:04 -0800

Hi meg,

Can you give an example of the lines that it's outputting now (just the ones you want to change), and what you want it to output instead? Once I have that I can give you some code to generate that.

Also, while debugging the xml, it's a good practice to get it working with a plain text .xml file first, then once you know it's working, have CMS Builder generate an xml file that looks the same. It makes it easier to track down problems.

Hope that helps, let me know about the output.

Re: [Dave] Generating XML using CMS

Tue, 23 Dec 2008 10:03:50 -0800

Hi Dave.

I seem to be having a problem with my XML gallery with the CMS and I believe I narrowed it down. My XML is looking for a URL, while the CMS referencing the file path in the file system. How do I correct for this?

I changed the upload field directory to the folder where I originally put my photos to test the gallery. (If I switch my XML to read just the file name, I can view the gallery just fine.) Is it possible to modify the php so it just reads the file name? And in regards to the caption, what should I do? I'm experiencing the same problem with the caption URL vs. file path.

Here's a sample of my xml code:

'); ?>

require_once "/data/home/riverschoolboats/websites/riverschoolboats.com/docs/cms/lib/viewer_functions.php";

list($artistRecords, $artistMetaData) = getRecords(array(
'tableName' => 'artist',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$artistRecord = @$artistRecords[0];

?>

/images/
2
3
_top
true
true
true
true
2

"

Also, if I plan on uploading multiple images to this gallery, do I need to repeat this code to match the desired number of photos per gallery, or will it generate multiple images with this code appearing once?

"

Re: [Dave] Generating XML using CMS

Mon, 15 Dec 2008 17:24:56 -0800

Halleleujah!!! It works now - God Bless You!

Re: [benedict] Generating XML using CMS

Mon, 15 Dec 2008 16:03:28 -0800

Hi Benedict,

The way that viewer is coded it will load the record number from the end of the url. So if the server is adding "noCache=1229302787177" on the end it will try to load record 1229302787177 which won't exist.

Make sure when you load the XML file you pass the record number you want to load with something like:

.../slideshow.php?

Or if there is only one record in the section you can _remove_ this line so it just loads the first record:

'where' => whereRecordNumberInUrl(1),

Hope that helps, let me know what happens.

Re: [Dave] Generating XML using CMS

Sun, 14 Dec 2008 20:07:55 -0800

Interstingly if I change the links to be absolute (by adding the http:// + url in the section editor that creates the XML) then in Flash, when I publish the file, it works locally. But again, when I upload it, it does not work. That tells me that the actual XML is correct, but its delivery is not.

I then found one thing which may be an issue in the logs in Safari when it loads the page -

http://esvc000159.wic032u.server-web.com/slideshow.php?noCache=1229302787177

Not sure why it is adding this code to the end of slideshow.php, but when I follow that URL, it states:

Warning: Invalid argument supplied for foreach() in e:\inetpub\esvc000159\slideshow.php on line 15.

Here is my code again in slideshow.php:

require_once "e:/inetpub/esvc000159/cmsAdmin/lib/viewer_functions.php";

list($home_pageRecords, $home_pageMetaData) = getRecords(array(
'tableName' => 'home_page',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$home_pageRecord = @$home_pageRecords[0]; // get first record

?>

' link='' inEffect='Fade in' outEffect='Fade out'>
No caption

Does this shed any light on the matter?

Re: [benedict] Generating XML using CMS

Thu, 11 Dec 2008 18:20:03 -0800

Hi benedict,

It looks like valid XML to me. I ran it through a few validators as well. What do the flash components do when you tell them to use it? Does it work when you save the output from slideshow.php as slideshow.php.xml and direct them to that?

Let me know what happens.

Re: [Dave] Generating XML using CMS

Wed, 10 Dec 2008 01:49:40 -0800

Still not working in 2 different projects I am working on (one an XML flash calendar, the other using Autofeeder Pro from Flashloaded.com). This is in spite of the fact that if you visit the xml page I am generating with my PHP (http://esvc000159.wic032u.server-web.com/slideshow.php) it is appearing perfectly.

I have sent 'Loaded a note and will keep you posted.

FYI, here is the viewer code I am using to create the above:

 

  list($home_pageRecords, $home_pageMetaData) = getRecords(array(
    'tableName'   => 'home_page',
    'where'       => whereRecordNumberInUrl(1),
    'limit'       => '1',
  ));
  $home_pageRecord = @$home_pageRecords[0]; // get first record

?>


	
	' link='' inEffect='Fade in' outEffect='Fade out'>
		No caption

Re: [benedict] Generating XML using CMS

Tue, 09 Dec 2008 16:08:48 -0800

Hi Benedict,

Some php installs think anything in tags is PHP code, including

There's a few tricks to show it including yours:
'); ?>

Or this one:
<?xml version="1.0" encoding="utf-8"?>

And yes, you should have your flash file call events.php (or name it events.xml.php to make it even more clear). It won't care about the file extension, just the content header that is sent. You can send an xml header like this. Just put this code at the top:

Hope that helps, let me know if you have any more questions. If you're still getting an error let me know what it is or post a link.

Re: [Dave] Generating XML using CMS

Tue, 09 Dec 2008 14:58:05 -0800

Hi Dave,

I am doing the same thing here. I have made my viewer identical to the xml file. 2 Things I'm struggling with:

1. In the viewer ("events.php"), I get an error when using the declaration:

I presume this is because of punctuation in there? I have tried:

'); ?>

But still no luck. Any idea what that should be?

2. In my flash file, I presume I should change all reference to "events.xml" to "events.php" correct? Or should my viewer have its name changed to a .xml file? Is that allowed?

Thanks.

Re: [meg] Generating XML using CMS

Fri, 05 Dec 2008 19:19:28 -0800

Hi Meg,

Yes, there is. Here's the steps:

- Create a static xml file with some sample images and get it working with your flash gallery.

- Create a php viewer with CMS Builder that outputs XML like your xml file.

- View source on the static (hard coded) and dynamic (cms driven) versions and make changes until the dynamic one looks almost exactly like the static one.

- Switch your flash gallery to use the dynamic CMS xml instead and see if it works.

Give it a try and let me know how far you get.

Hope that helps!

Re: [Dave] Generating XML using CMS

Fri, 05 Dec 2008 15:58:56 -0800

Thanks Dave. I'm looking to connect the CMS to an XML file which connects to a Flash Gallery. Is there a way to use your photo gallery portion of the CMS to connect to this XML file?

The functions I need for this gallery CMS section:
-Upload control panel
-Information for the XML file: URL of the image, Caption (text box)
-Ideally, I would love to set parameters on file size and pixel width (as your CMS gallery offers)

XML sample:

image_file_name.jpg
Photo Caption Goes Here

What's the best way to achieve this? Is there a fairly simple solution?
Thanks so much!

Meg

Re: [meg] Generating XML using CMS

Thu, 20 Nov 2008 14:44:26 -0800

Hi Meg,

There is ways to make .xml files run as PHP and still output XML content. But for most part applications don't care what the file extension is, they care what the "Content-type" header you send is.

It doesn't show in your browser, but anytime you request a file or image from the server it sends a line that says what kind of content it's sending.

For XML files, add this to the top of your script:

And you can name your script with .xml.php so it runs as a php app but the .xml. makes it easy to remember that it actually outputs xml.

For an example see our doc page on creating an XML RSS feed with CMS Builder:
http://www.interactivetools.com/docs/cmsbuilder/rss_feeds.html

Hope that helps!

Generating XML using CMS

Thu, 20 Nov 2008 03:41:48 -0800

I have a website that contains flash XML components (a text box and image gallery). I did some brief reading through your forum and is it true that you have to convert the XML to a PHP document or is there a way to add a script to the XML document so I don't have to change the file extension?

Either way, is there a different type of code that I should use to accomplish this?
Please advise.
Thanks!