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>
</Lead>
</cfloop>
</Leads>
</cfxml>
<cfset XMLPath = Expandpath("./")>
<cffile action="read" file="#XMLPath#in.xslt" variable="xslDoc">
<cfset transformedXML = XmlTransform(NexLeadXML, xslDoc)>
<cffile action="write" file="#XMLPath#NexLeadXMLPost.xml"
output="#transformedXML#">
<cfhttp method="POST" url="https://www.mysite.com/"; resolveurl="True">
<cfhttpparam file="#XMLPath#NexLeadXMLPost.xml" name="NexLeadXMLPost"
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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:197614
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
