XML output from CMSBuilder

Hi Andrea,

Is the example code the output that you're trying to create on your page?

If so, it should be pretty easy.

Set up a multi-record table (call it my_songs) with at least 3 fields. Text fields for title and creator, and an upload field for location that's limited to one upload and mp3 files.

Create a few records for testing purposes

Then for your viewer (web page) code at the top of the page: (take this from the code generator, the code below has no path to your CMSB files and won't work)
?php header('Content-type: text/html; charset=utf-8'); ?>
<?php


// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/path_to_your_cmsb_files/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

// load records
list($my_songsRecords, $my_songsMetaData) = getRecords(array(
'tableName' => 'my_songs',
));

?>

And in the body to produce the example you showed:

<?PHP echo "<?xml version='1.0' encoding='UTF-8'?>\n"; ?>
<playlist version="1" xmlns="http://xspf.org/ns/0/">
<trackList>
<?php foreach ($my_songsRecords as $record): ?>
<track>
<title><?php echo $record['title'] ?></title>
<creator><?php echo $record['creator'] ?></creator>
<location><?php foreach ($record['location'] as $upload): ?><?php echo $upload['urlPath'] ?><?php endforeach ?></location>
</track>
<?php endforeach ?>
</trackList>
</playlist>

I didn't have time to test it out, but is should work or get you close.

Good luck,

Jerry Kornbluth

Hi Andrea,

Looks like Jerry has you on the right track to set up an xml output. Using a php file to pull the data is a lot easier than setting up an "on-save" action as that requires a plugin.

Hope that helps,
Robin