There are some good free XML tools at xml.fusebox.org if you need em Greg Hamm Partner Coreillia Development [EMAIL PROTECTED] http://www.coreillia.com
-----Original Message----- From: Matt [mailto:[EMAIL PROTECTED] Sent: July 24, 2003 2:11 PM To: CF-Talk Subject: RE: Quickbooks and CF Haven't tried it on anything but CFMX, but aside from the use of CFXML and CFCs, the rest of it should be mostly the same. Matt -----Original Message----- From: Bruce Rojas-Rennke [mailto:[EMAIL PROTECTED] Sent: Thursday, July 24, 2003 5:06 PM To: CF-Talk Subject: RE: Quickbooks and CF Very cool, thanks much I'll scarf this right down. I'm using CF 5.0 for dev, CF 4.5 (client's) for production. Have you tried banging into COM objects with those CF versions? tanx a bazillion, Bruno -----Original Message----- From: Matt [mailto:[EMAIL PROTECTED] Sent: Thursday, July 24, 2003 2:48 PM To: CF-Talk Subject: RE: Quickbooks and CF Oh yeah, I spent a few months trying to make CFMX work with the QBXML request processor. First off, COM support in CFMX is just horrible. Don't even waste your time with it. I just kept getting endless errors trying to make calls to the QBXMLRPe (more on this later). What I did was use CF to generate the request QBXML, then used an ASP script to submit it and get the return QBXML, then used CF again to parse it. It's kind of a round-about way, but again, it's easier than getting error after error from CF. This is the basics of the ASP connector: <% Sub DoWork On Error Resume Next 'step 1: create QBXMLRPE object (EXE wrapper around QBXMLRP) Set rp = Server.CreateObject("QBXMLRPE.RequestProcessor") 'step2: Connect to QB rp.OpenConnection "1", "MyAppName" ticket = rp.BeginSession( "", request.Form("openMode")) inRq = request.Form("requestXML") outRs = rp.ProcessRequest(ticket, inRq) Response.Write(outRs) rp.EndSession ticket rp.CloseConnection End Sub DoWork %> Now, you can't call the QBXMLRP.DLL COM object directly from an ASP page, as IIS security doesn't allow it. So, Quickbooks provides an EXE wrapper for it, called QBXMLRPe.exe, which can be found in the SDKRoot/tools/access/QBXMLRPe/ folder. There is a readme in that folder explaining how to properly install it. After you have the QBXMLRPe wrapper installed correctly, and the ASP page is available on the server, then you can write CFM pages that can call Quickbooks. What I do is first generate the XML using <CFXML>. Then I have a CFC called "aspConnector.cfc" that takes the generated XML as its only parameter, makes an HTTP post to the ASP page using <CFHTTP>, and returns the Response QBXML from the ASP page. It might sound a little complicated, but it was actually fairly easy and is yet to fail. As long as you don't try to make the COM calls directly from CFMX, you'll be ok. Matt -----Original Message----- From: Bruce Rojas-Rennke [mailto:[EMAIL PROTECTED] Sent: Thursday, July 24, 2003 4:26 PM To: CF-Talk Subject: Quickbooks and CF Hello, I am involved in a project to integrate a CF Web Application with Quickbooks 2003 Pro. The path I am on is using the QB SDK's QBXML Request Processor API to send their xml-based requests and recieve responses from QB. I am using CFOBJECT and CFSCRIPT to try and replicate the VB code samples provided to show the connection/session process with the COM object: QBXMLRP.RequestProcessor. Sooo my question is - has anyone else out there been thru this, and if so blees you and could I have a peek at your code/approach to connect to the object above and use the communication methods that object proveides? I'm wading thru this using cfobject and cfscript, cffile cfwddx might come into play too, not sure yet. gracias nuevas, Bruno ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
