> Philip,
>
> Yes, I've already have the content from the xls file converted to xml
> with the following code:
>
> <cfxml variable="myXML">
> <Customers>
> <cfloop query="ExcelDSN">
> <Customer>
> <CustomerSource SourceID="NL" SourceType="Purchased" />
> <SourceType>SourceType
> #ExcelDSN.sourcetype#</SourceType>
> <Name>#ExcelDSN.Name#</Name>
> <EveningPhone>#ExcelDSN.Phone#</EveningPhone>
> <Address1>#ExcelDSN.Address1#</Address1>
> <Address2>#ExcelDSN.Address2#</Address2>
> <City>#ExcelDSN.City#</City>
> <State>State #ExcelDSN.State#</State>
> <Zip>Zip #ExcelDSN.Zip#</Zip>
> </Customer>
> </cfloop>
> </Customers>
> </cfxml>
> <cfset XMLPath = Expandpath("./")>
>
> <cffile action="read" file="#XMLPath#in.xslt" variable="xslDoc">
> <cfset transformedXML = XmlTransform(myXML, xslDoc)>
> <cffile action="write" file="#XMLPath#myXML.xml"
> output="#transformedXML#">
>
> <cfhttp method="POST" url="https://www.mysite.com/";
> resolveurl="True">
> <cfhttpparam file="#XMLPath#myXML.xml" name="myXMLPost"
> type="file">
> <!--- Roger's suggestion --->
> <cfhttpparam name="param1" value="#transformedXML#" type="XML">
> <cfhttpparam type="Header" name="Accept-Encoding" value="deflate;q=0">
>
> <cfhttpparam type="Header" name="TE" value="deflate;q=0">
>
> </cfhttp>
>
>
> Will the above work?
> Our client has not given us a valid URL to post to yet, so I am not
> sure if it will work or not just yet.
>
>
>
> >So, you've read the content from the excel file and you have the
> content in
> >a variable? Now you need to write that to XML? Please be specific /
> post a
> >little code to clue us in on the process.
> >
> >If so, check out the ColdFusion native tag called cfxml. After you
> build
> >your data within the tag, use cffile to write the new file.
> >
> >Warmest Regards,
> >
> >Phillip B. Holmes
> >
> >
> >
> >
> >-----Original Message-----
> >From: SD CFer [mailto:[EMAIL PROTECTED]
> >Sent: Saturday, March 05, 2005 12:54 PM
> >To: CF-Talk
> >Subject: Post an XML doc to a URL
> >
> >Hello all...
> >
> >I'm a long time ColdFusion developer, have done some .NET and now
> I've
> >encountered the XML thing (which rocks btw).
> >
> >Anyway, I've managed to create my XML doc from an .XLS/.CSV file, now
> I must
> >post this XML doc to a URL.
> >
> >Has someone already done this? I don't want to reinvent the wheel
> here.
> >
> >My first thought is to use <cfhttp>... am I on the right road here?
> >
> >Any help is greatly appreciated!
> >
> >Thanks in advance for any comments/suggestions.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:197615
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
