Re: Sage Export


"Stuart Barrett"
Hi

The database used within the Sage Line 50 range of products is
proprietary. Althought I believe the Payroll module uses an MSAccess
database.
To access the customer/supplier addresses we use the ODBC

We found the SDO to be very slow when access more than a few hundred
records across a network so we always use the ODBC Driver to access
data and only use SDO for posting Invoices etc..

Does Sage have batch processing within the GUI for importing CSV / XML / EDI
files?

We are likely to come up against the same kind of issues soon as we intend
extracting via ODBC, marrying with an admin system and possibly building
files to:
- Create Customers
- Create Invoices

Also, as a developer who has bought into the SDO would you be able to write
a set of consumable classes in a Delphiesk way to allow us to do the
injection of records?

If so, how much effort and how much cash :-)

Does the license prohibit it and does it require any runtime element that
needs installing on the client?

Cheers,

JAC.


.

Relevant Pages

  • Re: Nameless CREATE
    ... The starting point is either an existing database or one that is ... "Describe" involves issuing an SQLDescribeCol function to ODBC ... essentially much the same as character data type apart from all 8 bits ... ALTER TABLE tablename ADD COLUMN BinaryColumn BINARY ...
    (comp.lang.forth)
  • Re: fields queries and utter disaster
    ... Unfortunately the \c ODBC DATABASE field switch is not supported in Word ... of course supports ODBC connections but Word ... Mac Word Test ... suggests that it should be possible to use query files (cf. .qry/.dqy ...
    (microsoft.public.mac.office.word)
  • Re: [VW 7.3.1] ODBCConnection
    ... I played around with a few combinations on the connection string and ... with a trusted SQL Server connection. ... there are differences for database connects. ... > any database specific odbc drivers. ...
    (comp.lang.smalltalk)
  • Re: Serious Problem with Date in RecordSource
    ... Yes, this is ODBC data, not JET data, so some if the things I suggested ... >> c): Decompile the database. ... Still in the code window, choose Compile from the Debug menu. ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.formscoding)
  • Re: CDatabase, CDaoDatabase
    ... raw ODBC calls ... DAO will outperform ODBC (and so CDatabase) considerably in single user ... There is considerably more to database performance than making quick ...
    (microsoft.public.vc.language)