> On Jan 23, 2017, at 9:48 AM, Kevin Abraham <[email protected]> wrote: > > As for the Desktop App, the way integration here works (and you may have > several options, I did not write our App and it is quite old) is that Intuit > has an SDK which can be used in Visual Studio (in our case) to create a > Windows EXE which can then be called by 4D. So with QB launched (in our case, > there are other security options here) the user can run a 4D Method which > drops and XML file in a preset location. 4D then Launches the EXE which we > call QBXMLAgent. QBXMLAgent then reads the XML and does all the communication > with QB’s and returns an XML file for 4D to the same preset location. Note, > NO ODBC setup is required to make this work. Only that the EXE be present on > the Windows machine in preset path where 4D calls. it.
Similar to how Kevin uses Visual Studio, you can use Windows PowerShell. 4D creates and executes the Power Shell scripts that sends and/or receives data to and from Quickbooks. As noted these scripts are very simple and well documented in the Intuit Quickbooks SDK. if QB is installed on the same machine as 4D Server or Client you can talk directly to QuickBooks desktop from either 4D server or client. Intuit provides Client/Server utility apps that allow 4D Server or 4D client to talk QB installed on different machines than 4D. I have a 4D Client/Server/Quickbooks solution deployed that works seemlessly using PowerShell which allows the users to set there systems up in whatever configuration works best for the end user. I have never tried it but, if I remember correctly there is also a web service option allowing you to talk to QB Desktop over the internet. I have not worked with the QB OnLine. The communication is always 4D initiated. I do not know of any way to exchange data with 4D initiated from QuickBooks Desk Top. John ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
