Re: Using Coldfusion with XML
Th isn't part of the error itself, only an escaped coming from CF's built in error handler, it does that sometimes. The most important bit is the < ("<") which CF has conveniently escaped for you. Neil On Wed, 2 Feb 2005 10:37:04 -, Ian Vaughan <[EMAIL PROTECTED]> wrote: > I am receiving the following error when parsing an XML doc, > > any ideas why it is looking for etc from the code below ? > > Ian > -- > > Error Occurred While Processing Request > Invalid CFML construct found on line 22 at column 1. > ColdFusion was looking at the following text:< -- Neil http://www.theservicefactory.com Get Firefox - http://www.getfirefox.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192738 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using Coldfusion with XML
Oh yes, thanks -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 02 February 2005 10:58 To: CF-Talk Subject: RE: Using Coldfusion with XML You need a closing > on line 20? -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Wednesday, 2 February 2005 6:37 PM To: CF-Talk Subject: RE: Using Coldfusion with XML I am receiving the following error when parsing an XML doc, any ideas why it is looking for etc from the code below ? Ian -- Error Occurred While Processing Request Invalid CFML construct found on line 22 at column 1. ColdFusion was looking at the following text:<The CFML compiler was processing:< marks the beginning of a ColdFusion tag.Did you mean LT or LTE?a cfset tag beginning on line 20, column 2. The error occurred in \testpages\parse2.cfm: line 22 20 : 23 : 24 : ---CODE TEST XML Name = #mydoc.buildingrecordset.buildingrecord.XMLAttributes.PersonRegistration Number# Record = #scheme# ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192733 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using Coldfusion with XML
You need a closing > on line 20? -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Wednesday, 2 February 2005 6:37 PM To: CF-Talk Subject: RE: Using Coldfusion with XML I am receiving the following error when parsing an XML doc, any ideas why it is looking for etc from the code below ? Ian -- Error Occurred While Processing Request Invalid CFML construct found on line 22 at column 1. ColdFusion was looking at the following text:<The CFML compiler was processing:< marks the beginning of a ColdFusion tag.Did you mean LT or LTE?a cfset tag beginning on line 20, column 2. The error occurred in \testpages\parse2.cfm: line 22 20 : 23 : 24 : ---CODE TEST XML Name = #mydoc.buildingrecordset.buildingrecord.XMLAttributes.PersonRegistration Number# Record = #scheme# ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192731 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using Coldfusion with XML
I am receiving the following error when parsing an XML doc, any ideas why it is looking for etc from the code below ? Ian -- Error Occurred While Processing Request Invalid CFML construct found on line 22 at column 1. ColdFusion was looking at the following text:
Re: Using Coldfusion with XML
Ian Vaughan wrote: >Getting the following error from my ocde below, any ideas folks? > > [snip] >Document root element is missing. >Document root element is missing. > > [snip] Ian, You need to read up on the usage of CFFILE and its actions. The action "upload" does not load the file into a variable, it moves the file from a temporary file created by the web server during the form submission to a real file some where on the harddisk of the server. You still need to read the file in once you have uploaded it somewhere appropriate. You have been told this previously by other response to your email. Please make sure you carefully read the responses you get and read the manual for the various CF tags and function you are using. Below is some code to help you out. Regards Stephen = The Number is #variables.xnSchemeUniqueRecordIdentifier# ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191913 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using Coldfusion with XML
> Getting the following error from my ocde below, any ideas folks? What does your XML look like? Nick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191911 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using Coldfusion with XML
Getting the following error from my ocde below, any ideas folks? --START SNIPPET--- The Number is #xnSchemeUniqueRecordIdentifier# -END-- Document root element is missing. Document root element is missing. The error occurred in testpages\parse.cfm: line 12 10 : 11 : 12 : 13 : 14 : ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191910 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using Coldfusion with XML
You need to add a DESTINATION attribute to your CFFile tag: -joe -- For Tabs, Trees, and more, use the jComponents: http://clearsoftware.net/client/jComponents.cfm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191838 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using ColdFusion with XML
I don't think you can upload directly into a variable into memory. I believe the process will need to be: Upload file from client to server Read file on server into memory variable Process variable into xml -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning ...-Original Message- ...From: Ian Vaughan [mailto:[EMAIL PROTECTED] ...Sent: Wednesday, January 26, 2005 7:50 AM ...To: CF-Talk ...Subject: RE: Using Coldfusion with XML ... ...Using the following code I am getting an error complaining of no ...destination specified for the UPLOAD, but in this case what would this ...be as I am not uploading the XML file to a location but to a variable to ...process ... ... ... ... ... ... ... ... ...And my action page of ... ... ... ... ... ... ... ... ... ... ... ... ...The Number is #xnSchemeUniqueRecordIdentifier# ... ... ... ... ... ...-Original Message- ...From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] ...Sent: 26 January 2005 15:31 ...To: CF-Talk ...Subject: Re: Using Coldfusion with XML ... ...Ian Vaughan wrote: ... ...>Yes taking the XML doc and parsing the information stored within into a ... ...>database table. ...> ...> ...ok - in which case - I refer you to point 3 of my previous email ... ...>If you actually need to do something with the XML data in CF, but only ...>need the CSV as a means of getting the data into CF, then xml2query ...>will cut out the CSV middle-man giving you something easier to work ...with in CF. ...> ...You can then use the query thats been created from the xml to insert the ...data into your database. ... ...Regards ... ...Stephen ... ... ... ... ... ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191823 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using Coldfusion with XML
Using the following code I am getting an error complaining of no destination specified for the UPLOAD, but in this case what would this be as I am not uploading the XML file to a location but to a variable to process And my action page of The Number is #xnSchemeUniqueRecordIdentifier# -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 15:31 To: CF-Talk Subject: Re: Using Coldfusion with XML Ian Vaughan wrote: >Yes taking the XML doc and parsing the information stored within into a >database table. > > ok - in which case - I refer you to point 3 of my previous email >If you actually need to do something with the XML data in CF, but only >need the CSV as a means of getting the data into CF, then xml2query >will cut out the CSV middle-man giving you something easier to work with in CF. > You can then use the query thats been created from the xml to insert the data into your database. Regards Stephen ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191820 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using Coldfusion with XML
Ian Vaughan wrote: >Yes taking the XML doc and parsing the information stored within into a >database table. > > ok - in which case - I refer you to point 3 of my previous email >If you actually need to do something with the XML data in CF, but only >need the CSV as a means of getting the data into CF, then xml2query will >cut out the CSV middle-man giving you something easier to work with in CF. > You can then use the query thats been created from the xml to insert the data into your database. Regards Stephen ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191817 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using Coldfusion with XML
Yes taking the XML doc and parsing the information stored within into a database table. -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 15:00 To: CF-Talk Subject: Re: Using Coldfusion with XML Ian Vaughan wrote: >Dave > >There is no real requirement, would it be easier (coding wise) to >transform the XML files straight into the database via CFFILE ? Rather >than producing a CSV file? > > Ian, Are you trying to just dump the CSV into a column in a table in your database? Or are you looking at taking the XML root as being a table that exists in your database, the children in that xml packet being rows and columns in your table and putting each child under the root into a row in the database? Stephen ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191812 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using Coldfusion with XML
Ian Vaughan wrote: >Dave > >There is no real requirement, would it be easier (coding wise) to >transform the XML files straight into the database via CFFILE ? Rather >than producing a CSV file? > > Ian, Are you trying to just dump the CSV into a column in a table in your database? Or are you looking at taking the XML root as being a table that exists in your database, the children in that xml packet being rows and columns in your table and putting each child under the root into a row in the database? Stephen ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191810 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using Coldfusion with XML
Dave There is no real requirement, would it be easier (coding wise) to transform the XML files straight into the database via CFFILE ? Rather than producing a CSV file? -Original Message- From: Dave Merrill [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 14:12 To: CF-Talk Subject: RE: Using Coldfusion with XML Is there really a requirement to go through csv? Why? If the point is to get the data into a db, what's the reason to pump it through a csv file on the way? (Assuming that cf has access to the db.) Am I missing part of your stated needs? Dave Merrill > The end point is with the fixed with CSV file being generated and > saved so that can be input into the relevant database tables. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191808 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using Coldfusion with XML
Thanks for the links guys Much appreciated -Original Message- From: COLLIE David [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 12:17 To: CF-Talk Subject: RE: Using Coldfusion with XML > > Are there any CF tutorials on the www for this as it will be a > > different process to just simply uploading a doc to a file server ? > > http://www.macromedia.com/devnet/mx/coldfusion/xml_xslt.html > > I would suggest to start from here: > http://www.macromedia.com/devnet/mx/coldfusion/articles/xmlxslt.pdf In case you go that way for XML/XSL reference I always find http://zvon.org helpful More specifically http://zvon.org/xxl/XSLTutorial/Output/index.html -- dc ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191801 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using Coldfusion with XML
Is there really a requirement to go through csv? Why? If the point is to get the data into a db, what's the reason to pump it through a csv file on the way? (Assuming that cf has access to the db.) Am I missing part of your stated needs? Dave Merrill > The end point is with the fixed with CSV file being generated and saved > so that can be input into the relevant database tables. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191794 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using Coldfusion with XML
> > Are there any CF tutorials on the www for this as it will be a > > different process to just simply uploading a doc to a file server ? > > http://www.macromedia.com/devnet/mx/coldfusion/xml_xslt.html > > I would suggest to start from here: > http://www.macromedia.com/devnet/mx/coldfusion/articles/xmlxslt.pdf In case you go that way for XML/XSL reference I always find http://zvon.org helpful More specifically http://zvon.org/xxl/XSLTutorial/Output/index.html -- dc ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191779 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using Coldfusion with XML
> Are there any CF tutorials on the www for this as it will be a different > process to just simply uploading a doc to a file server ? http://www.macromedia.com/devnet/mx/coldfusion/xml_xslt.html I would suggest to start from here: http://www.macromedia.com/devnet/mx/coldfusion/articles/xmlxslt.pdf Massimo Foti DW tools: http://www.massimocorner.com CF tools: http://www.olimpo.ch/tmt/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191778 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using Coldfusion with XML
The end point is with the fixed with CSV file being generated and saved so that can be input into the relevant database tables. So below would be the code to select the xml doc. Then in the xml.cfm page what code would be needed to perform the transformation. Are there any CF tutorials on the www for this as it will be a different process to just simply uploading a doc to a file server ? i.e. -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 10:54 To: CF-Talk Subject: Re: Using Coldfusion with XML > So basically, you need to think about what is next the > application/data flow and process the XML accordingly. These are indeed wise suggestions. I would add that you also need to evaluate your expertise, since complex XSLT programming can be tricky and require specific knowledge Massimo Foti DW tools: http://www.massimocorner.com CF tools: http://www.olimpo.ch/tmt/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191777 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using Coldfusion with XML
> So basically, you need to think about what is next the application/data > flow and process the XML accordingly. These are indeed wise suggestions. I would add that you also need to evaluate your expertise, since complex XSLT programming can be tricky and require specific knowledge Massimo Foti DW tools: http://www.massimocorner.com CF tools: http://www.olimpo.ch/tmt/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191775 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using Coldfusion with XML
Ian Vaughan wrote: >I have an XML document that needs to be converted to a fixed width Comma >Seperated File so it can be inserted into the relevant databases. > >XSLT would perform this transformation but how can Coldfusion fit in to >make this an easy to use web application. > >For example... > >The user would upload the XML file using CFFILE through a web interface. >In the action page it would process the XML doc and produce the relevant >CSV file. > >Any ideas on the best way forward on this ... > > What exactly is the end point? The creation of the CSV? Or does something happen with the CSV afterwards? If something is happening with the CSV afterwards, then you need to look at what you need in order to perform the next task. If the CSV is the end, then you probably don't need to involve CF other than to handle the file upload, just use the XSLT. If you want to save the generated CSV out somehow somewhere, then Nick's suggestion of the XMLTransform is probably the way to go. If you actually need to do something with the XML data in CF, but only need the CSV as a means of getting the data into CF, then xml2query will cut out the CSV middle-man giving you something easier to work with in CF. So basically, you need to think about what is next the application/data flow and process the XML accordingly. Stephen ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191774 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using Coldfusion with XML
> Is it best to leave Coldfusion alone when it comes to dealing with XSLT > and XML ? No, you can do this very neatly in CFMX using the XmlTransform() function. Also, the xml2query suggestion was a good one if you want to minimise lines of code. However, if efficiency is an issue and the XML is very simple and predictable, it may be worth writing your own lightweight parser to translate straight from XML to CSV without any intermediate steps. Nick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191773 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Using Coldfusion with XML
Is it best to leave Coldfusion alone when it comes to dealing with XSLT and XML ? -Original Message- From: Ian Winter [mailto:[EMAIL PROTECTED] Sent: 26 January 2005 09:55 To: CF-Talk Subject: Re: Using Coldfusion with XML There is a xml2query customtag which you could run then create the csv from the query, bit long winded though. On Wed, 26 Jan 2005 09:36:30 -, Ian Vaughan <[EMAIL PROTECTED]> wrote: > I have an XML document that needs to be converted to a fixed width > Comma Seperated File so it can be inserted into the relevant databases. > > XSLT would perform this transformation but how can Coldfusion fit in > to make this an easy to use web application. > > For example... > > The user would upload the XML file using CFFILE through a web interface. > In the action page it would process the XML doc and produce the > relevant CSV file. > > Any ideas on the best way forward on this ... > > TIA > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191771 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Using Coldfusion with XML
There is a xml2query customtag which you could run then create the csv from the query, bit long winded though. On Wed, 26 Jan 2005 09:36:30 -, Ian Vaughan <[EMAIL PROTECTED]> wrote: > I have an XML document that needs to be converted to a fixed width Comma > Seperated File so it can be inserted into the relevant databases. > > XSLT would perform this transformation but how can Coldfusion fit in to > make this an easy to use web application. > > For example... > > The user would upload the XML file using CFFILE through a web interface. > In the action page it would process the XML doc and produce the relevant > CSV file. > > Any ideas on the best way forward on this ... > > TIA > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191768 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54