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.
