Hi all…and, esp. John, Ken, and Keisuke, This thread is very timely for me. I’m presently working-on a 4D system that I need to connect to QuickBooks Desktop. This is a Win10 system and presently 4D v16 and QB 2017 Desktop (single-user). In the 4D system, users enter payments-received and refunds-sent data and I need to transfer this data to QB. I’m anticipating that the connection will be uni-directional (4D —> QB only) but it might need to be bi-directional. There will be only one user who will have QB and 4D on their system. This user will be the only user who will access the connection. There is not a lot of data to be transferred…approx. 300 transactions a month.
Another 4D developer has recommended using QODBC (FlexQuarters) and this looks to be a possibility. I’d be very interested in any other recommendations. If you’d like to contact me directly, my email is: kgeiger dot ins at gmail dot com. TIA and regards, Ken Geiger > On Dec 13, 2019, at 6:04 PM, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Ken, > > I have a deployed 4D database talking to QB on Windows 10 and 4D17r5. > It started out using Myles’ plug in. For me I had to stop using the plug in > when the client moved to Windows 7. > > I was able to get it done using… > > QB RDS client and server: Client or Client/Server needed or not at all > depending on where Quickbooks is located on the network in relation to the > requesting 4D Client or requesting 4D Server. > > Windows PowerShell: 4D creates the QB request with the help of Myles’ > XML methods. It then packs it into a PowerShelll script. The script is saved > to a script fil. Launch External Process is used to launch PowerShell to read > the script file. PowerSell creates the QBXMLRP com object and sends the > request. The response is written out to as file on the hard drive which is > read by 4D. > > This has worked quite well over the years. When the client moved to > Windows 10 I needed to do a bit of massaging but got it to work. > > Each time I revisit this project, it takes me a while to get my head > around it all, but if you have any questions feel free to contact me off > line. I will do my best… I am a MAC guy so my brain really needs a refresher > each time I have to deal with Windows. > > John > >> On Dec 13, 2019, at 9:47 AM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> I have been using QBManager from Myles Wakeham up until now with version >> 15.4, but it will not work with v17. >> >> I found this link (https://github.com/miyako/4d-tips-quickbook-integration) >> from the post (below) from Miyako in 2017 regarding integration to >> QuickBooks. >> >> I've downloaded the database, but the code does not look familiar to >> QBManager in any way. >> >> I'm not sure how to use Miyako's plugin to open a connection to QuickBooks >> and then subsequently send and retrieve data and then close the connection. >> >> The QBManager plugin uses QBXML to do all of this. I'm wondering if I need >> to re-write all of the code to use Miyako's plugin, or if some/most of it >> can be reused. >> >> Is there any documentation or examples for Miyako's plugin that anyone is >> aware of and would be willing to share? >> >> Thank you, >> Ken Eyring >> >> >> >> >> >> On 09/05/17 20:26 PM, Keisuke Miyako via 4D_Tech wrote: >>> you could start from here: >>> https://github.com/miyako/4d-tips-quickbook-integration >>>> 2017/09/06 8:18、Douglas von Roeder via 4D_Tech <4d_tech@lists.4d.com> のメール： >>>> What's the best approach to take for that. >>> ********************************************************************** >>> 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:4d_tech-unsubscr...@lists.4d.com >>> ********************************************************************** >> ********************************************************************** >> 4D Internet Users Group (4D iNUG) >> Archive: http://lists.4d.com/archives.html >> Options: https://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com >> ********************************************************************** > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
