Re: 4D and Sage

2017-06-14 Thread Pat Bensky via 4D_Tech
Nigel, It would be cool to see that code :) No rush. This is not an urgent job. Cheers Pat On 14 June 2017 at 08:55, Nigel Greenlee via 4D_Tech <4d_tech@lists.4d.com> wrote: > Pat > > I have code for this:..it uses the ODBC plug in but should be converted to > just use SQL i think. > > > > Nigel

Re: 4D and Sage

2017-06-14 Thread Nigel Greenlee via 4D_Tech
Pat I have code for this:..it uses the ODBC plug in but should be converted to just use SQL i think. Nigel > On 13 Jun 2017, at 12:17, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> wrote: > > We've had a few enquiries from customers and prospects about interfacing > with Sage and I'd like to

Re: 4D and Sage

2017-06-14 Thread Paul Dennis via 4D_Tech
I had sage line 50 working ok with odbc. I was able to export data from sage into our 4D app. However this was for a one of conversion rather than ongoing integration. Paul -- View this message in context: http://4d.1045681.n5.nabble.com/4D-and-Sage-tp5752571p5752592.html Sent from the 4D Tech

Re: 4D and Sage

2017-06-13 Thread J. Douglas Cryer via 4D_Tech
Pat, Transpose is your best bet. It does the automation and you can just pickup and drop files. Regards, Dougie ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archive

Re: 4D and Sage

2017-06-13 Thread Guy Algot via 4D_Tech
I recently went through the process of trying to determine how to integrate with Sage since a client was looking to use them. Very difficult and expensive was the answer regarding automated integration. I have looked at Xero previously because of their REST API but in accounting terms I don’t k

Re: 4D and Sage

2017-06-13 Thread Douglas Cryer via 4D_Tech
Pat, We have done 3 things with regards Sage Integration. It is important to note these are all in relation to Sage Line 50. Simple Export This is just exporting invoices in a text format for import into Sage using their standard import function. Integration via Transpose - http://www.red-it.

Re: 4D and Sage

2017-06-13 Thread Peter Bozek via 4D_Tech
On Tue, Jun 13, 2017 at 1:17 PM, Pat Bensky via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Basically we need to: > - Extract data into our 4D database > - Push data from 4D to Sage > I did export of accounting info from 4D based CRM system to Sage (German). It is quite simple, export - import of pl

4D and Sage

2017-06-13 Thread Pat Bensky via 4D_Tech
We've had a few enquiries from customers and prospects about interfacing with Sage and I'd like to get an idea of how much work would be involved in setting this up. Basically we need to: - Extract data into our 4D database - Push data from 4D to Sage Standard stuff I guess :) We'll be using 4D v