Thanks to Dave and Graham - once again Profox turns up trumps!!! I'll look at the system when I'm next in their office next week and get a better idea of what's available.
Thanks again, John John Weller 01380 723235 07976 393631 > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Graham Brown (CompSYS) > Sent: 16 November 2007 20:12 > To: [EMAIL PROTECTED] > Subject: RE: [NF] Sage question (mainly for UK guys) > > > Hi John > > Sage should come with an ODBC driver > This is some simple vfp8 code to rip out the names and addresses. > > I used Excel and MSQuery to find out the tables and field names. > > nHandle=Sqlstringconnect("dsn=SageLine50v11;uid=manager") > If nHandle>=0 > N=SQLEXEC(nHandle,"select * from sales_ledger order by > address_1","temp") > If Select("temp")>0 > oDE=Createobject("decust"+db_platform) > oDE.custsupp.lNoDataOnLoad=.F. > oDE.OpenTables() > > Select temp > SCAN > WAIT WINDOW temp.address_1 NOWAIT noclear > > SELECT custsupp > LOCATE FOR cs_name=temp.address_1 > IF EOF() > APPEND BLANK > REPLACE cs_name WITH temp.address_1 > ENDIF > REPLACE cs_add1 WITH temp.address_2,; > cs_add2 WITH temp.address_3,; > cs_add3 WITH temp.address_4,; > cs_postcode WITH temp.address_5,; > cs_telno WITH temp.telephone,; > cs_fax WITH temp.fax,; > cs_email WITH temp.email,; > cs_web WITH temp.web_address,; > cs_accno WITH temp.account_ref > =mtableUpdate() > SELECT temp > > Endscan > oDE.CloseTables() > USE IN temp > > Else > Wait Window "Unable to open Sage View" > ENDIF > SQLDISCONNECT(nHandle) > > Else > Wait Window "Unable to access Sage" > Endif > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of John Weller > Sent: 16 November 2007 20:02 > To: [email protected] > Subject: [NF] Sage question (mainly for UK guys) > > > I am working with a local charity who have a few shops. They > need a simple > stock control system and have asked me to write one. They are currently > using Sage Line 50 to hold their stock and find it far too > complex for their > simple requirements and too inflexible for their situation. My question > is - does any of the UK brethren know if data can be exported > from Sage into > a CSV or similar? If not I'll have the system produce a printout > and direct > it to a text file and manipulate that to get the data but it > would be easier > if I could get it directly. I know Sage used to have that facility but I > hear that now you need an SDK which is not cheap. > > TIA > > John Weller > 01380 723235 > 07976 393631 > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
