RE: Using Coldfusion with XML
I am receiving the following error when parsing an XML doc, any ideas why it is looking for p 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:plt;/ppThe CFML compiler was processing:ullt; marks the beginning of a ColdFusion tag.Did you mean LT or LTE?lia cfset tag beginning on line 20, column 2./ul The error occurred in \testpages\parse2.cfm: line 22 20 : cfset mydoc=XmlParse(myxml) 21 : 22 : cfset scheme=#mydoc.buildingrecordset.buildingrecord.XMLAttributes.SchemeUniqu eRecordIdentifier# 23 : 24 : ---CODE !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleTEST XML/title /head body cffile action=upload filefield=UploadFile destination=#GetTempDirectory()# nameconflict=overwrite cffile action=read file=#GetTempDirectory()##cffile.serverfile# variable=myxml cfset mydoc=XmlParse(myxml) cfset scheme=#mydoc.buildingrecordset.buildingrecord.XMLAttributes.SchemeUniqu eRecordIdentifier# CFOUTPUT Name = #mydoc.buildingrecordset.buildingrecord.XMLAttributes.PersonRegistration Number# Record = #scheme# /CFOUTPUT /body /html ~| 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:192728 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 p 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:plt;/ppThe CFML compiler was processing:ullt; marks the beginning of a ColdFusion tag.Did you mean LT or LTE?lia cfset tag beginning on line 20, column 2./ul The error occurred in \testpages\parse2.cfm: line 22 20 : cfset mydoc=XmlParse(myxml) 21 : 22 : cfset scheme=#mydoc.buildingrecordset.buildingrecord.XMLAttributes.SchemeUniqu eRecordIdentifier# 23 : 24 : ---CODE !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleTEST XML/title /head body cffile action=upload filefield=UploadFile destination=#GetTempDirectory()# nameconflict=overwrite cffile action=read file=#GetTempDirectory()##cffile.serverfile# variable=myxml cfset mydoc=XmlParse(myxml) cfset scheme=#mydoc.buildingrecordset.buildingrecord.XMLAttributes.SchemeUniqu eRecordIdentifier# CFOUTPUT Name = #mydoc.buildingrecordset.buildingrecord.XMLAttributes.PersonRegistration Number# Record = #scheme# /CFOUTPUT /body /html ~| 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
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 p 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:plt;/ppThe CFML compiler was processing:ullt; marks the beginning of a ColdFusion tag.Did you mean LT or LTE?lia cfset tag beginning on line 20, column 2./ul The error occurred in \testpages\parse2.cfm: line 22 20 : cfset mydoc=XmlParse(myxml) 21 : 22 : cfset scheme=#mydoc.buildingrecordset.buildingrecord.XMLAttributes.SchemeUniqu eRecordIdentifier# 23 : 24 : ---CODE !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleTEST XML/title /head body cffile action=upload filefield=UploadFile destination=#GetTempDirectory()# nameconflict=overwrite cffile action=read file=#GetTempDirectory()##cffile.serverfile# variable=myxml cfset mydoc=XmlParse(myxml) cfset scheme=#mydoc.buildingrecordset.buildingrecord.XMLAttributes.SchemeUniqu eRecordIdentifier# CFOUTPUT Name = #mydoc.buildingrecordset.buildingrecord.XMLAttributes.PersonRegistration Number# Record = #scheme# /CFOUTPUT /body /html ~| 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
Th P isn't part of the error itself, only an escaped P coming from CF's built in error handler, it does that sometimes. The most important bit is the lt; () 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 p 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:plt;/pp -- 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
Getting the following error from my ocde below, any ideas folks? --START SNIPPET--- cffile action=UPLOAD filefield=Form.UploadFile destination=Form.UploadFile nameconflict=OVERWRITE CFSET MyXML = XmlParse(#Uploadfile#) CFSET xnBuildingRecordset = MyXML.XMLRoot CFSET xnSchemeUniqueRecordIdentifier = xnBuildingRecordset.XMLAttributes[name] CFOUTPUT PThe Number is #xnSchemeUniqueRecordIdentifier#/P /CFOUTPUT -END-- Document root element is missing. Document root element is missing. The error occurred in testpages\parse.cfm: line 12 10 : cffile action=UPLOAD filefield=Form.UploadFile destination=Form.UploadFile nameconflict=OVERWRITE 11 : 12 : CFSET MyXML = XmlParse(#Uploadfile#) 13 : 14 : CFSET xnBuildingRecordset = MyXML.XMLRoot ~| 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
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
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 = cffile action=upload filefield=UploadFile destination=#GetTempDirectory()# nameconflict=overwrite cffile action=read file=#GetTempDirectory()##cffile.serverfile# variable=variables.thisXMLFile CFSET variables.MyXML = XmlParse(variables.thisXMLFile) CFSET variables.xnBuildingRecordset = variables.MyXML.XMLRoot CFSET variables.xnSchemeUniqueRecordIdentifier = variables.xnBuildingRecordset.XMLAttributes[name] CFOUTPUT PThe Number is #variables.xnSchemeUniqueRecordIdentifier#/P /CFOUTPUT ~| 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
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
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
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
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
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
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. form action=xml.cfm ENCTYPE=multipart/form-data method=post name=form input type=file name=UploadFile p input type=submit name=submit value=Upload Document /form 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. cffile action=UPLOAD filefield=Form.UploadFile destination=downloads\documents nameconflict=OVERWRITE -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
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
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
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
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
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
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
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: 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
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 form action=parse.cfm ENCTYPE=multipart/form-data method=post name=form input type=file name=UploadFile p input type=submit name=submit value=Upload Document /form And my action page of body cffile action=UPLOAD filefield=Form.UploadFile CFSET MyXML = XmlParse(#Uploadfile#) CFSET xnBuildingRecord = MyXML.XMLRoot CFSET xnSchemeUniqueRecordIdentifier = xnBuildingRecord.XMLAttributes[name] CFOUTPUT PThe Number is #xnSchemeUniqueRecordIdentifier#/P/CFOUTPUT /body /html -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
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 ... ... ...form action=parse.cfm ENCTYPE=multipart/form-data method=post ...name=form ...input type=file name=UploadFile ...p ...input type=submit name=submit value=Upload Document .../form ... ...And my action page of ... ...body ... ...cffile action=UPLOAD filefield=Form.UploadFile ... ...CFSET MyXML = XmlParse(#Uploadfile#) ... ...CFSET xnBuildingRecord = MyXML.XMLRoot ... ...CFSET xnSchemeUniqueRecordIdentifier = ...xnBuildingRecord.XMLAttributes[name] ... ...CFOUTPUT ...PThe Number is #xnSchemeUniqueRecordIdentifier#/P/CFOUTPUT .../body .../html ... ... ... ...-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
You need to add a DESTINATION attribute to your CFFile tag: cffile action=UPLOAD filefield=Form.UploadFile destination=c:\someDirectory -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