Creating an XML file on the server

Posts: 98 · Posted: Fri Feb 02, 2007 1:09 am

Is it possible to create an XML file with the information the user gives me, and save on the server?

Posts: 548 · Posted: Fri Feb 02, 2007 1:19 am

Sure Can..

It can be a query, form content, or anything at all..

Code:

<cfsavecontent variable="XML_Content">
<?xml version="1.0" encoding="UTF-8" ?>
<userid>#User.UserID#</userid>
<username>#User.UserName#</username>
.......
</cfsavecontent>


<cffile file="D:\Websites\www\Dir\UserXML.xml" output="#XML_Content#">

If you are unfamiliar with cffile, here's the quickdocs
http://www.cfquickdocs.com/?getDoc=cffile

Posts: 98 · Posted: Fri Feb 02, 2007 2:02 am

Jason that worked... thanks

one more question... now if I need to open the xml and make some updates

here is the structure of my xml file..

Code:

- <playlist>
- <item>
<filename>example1.mp3</filename>
<artist>Ennio</artist>
<album />
<title>Test XML</title>
</item>
</playlist>

I need to add now another item inside the playlist.

Posts: 548 · Posted: Fri Feb 02, 2007 2:07 am

Just do the same thing, except add append to cffile...

Code:

This will open the file, and add to it.

Posts: 98 · Posted: Fri Feb 02, 2007 2:13 am

I got an error saying I can only have one top level.

Code:

<cfsavecontent variable="XML_Content">
<item>
<filename><cfoutput>#File.ServerFile#</cfoutput></filename>
<artist><cfoutput>#Session.bandname#</cfoutput></artist>
<album></album>
<title><cfoutput>#Form.txtTitle#</cfoutput></title>
<track></track>
<comments></comments>
<genre></genre>
<seconds></seconds>
<filesize></filesize>
<bitrate></bitrate>
<visual></visual>
<url></url>
</item>
</cfsavecontent>

<cffile action="append" file="C:\websites\108817ut4artist\#Session.bandname#\music\playlist.xml" output="#XML_Content#">

I removed the <playlist> this is my top level and still get the error

Posts: 548 · Posted: Fri Feb 02, 2007 1:21 pm

Hmm.. You shouldn't get that kind of error unless you are specifically parsing the XML file. For all Coldfusion is concerned, you are just writing to a file. It doesn't care what you put in there.

Do you have a page where I can see the error? If not, can you post a screenshot and we'll go from there.

Posts: 178 · Posted: Fri Feb 02, 2007 2:28 pm

Ennio - Is this file meant to be parsed by anything other than your script? If not, I'd highly recommend using a database to store data rather than XML - it would likely save you a lot of headaches

Posts: 548 · Posted: Fri Feb 02, 2007 2:31 pm

pmeserve wrote:

Ennio - Is this file meant to be parsed by anything other than your script? If not, I'd highly recommend using a database to store data rather than XML - it would likely save you a lot of headaches

I would agree with that. If you have an app that needs to read an xml file, you can just pull the data from the database and create on one the fly like you're doing above.

Posts: 98 · Posted: Sun Feb 04, 2007 5:38 am

Hi guys,...thanks for the advice... I did change to a DB

I was developing a flash mp3 player using xml, but I'm going to use a db.