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