Re: Importing bookkeeping data

Daniel Mpolokoso ( )
Wed, 17 Jun 1998 20:50:01 +0200


Don't you think it would be of benefit to provider a user-friendly interface
into Emerald for importation of data? For example, why not have a fixed
format record definition for MBR which can then be imported directly into
Emerald? Post.Office, for example, uses templates for account creation and

Another example could be importation of billing information generated
outside of Emerald. Surely the interface isn't that complex, so long as
certain rules are adhered to. I realise there may be a level of complexity
in the inner-workings of Emerald and interaction with the database, but
surely, end-users shouldn't have to be SQL Server gurus as well?



Dale E. Reed Jr. wrote:
> Olivier Astier wrote:
> >
> > I want to import data from my current Bookkeepping software : QuickBook
> > I have recovered the quickbook data in text and excel format.
> > The problem is that I don't know how to import them in the Emerald SQL
> > database. I think I could create a SQL query by inserting the right SQL
> > commands between the database fields in Excel, but I don't know wich
> > commands and maybe there's an easier way to do this.
> > If you already faced this problem could you help me with that? Please assume
> > that my SQL skills are limited ; but I learn quickly.
> This is not a trvial task to accomplish and without in depth SQL
> experience and knowledge, I can only recommend you talk to us
> about doing it for you. It typically takes about 5-6 hours of
> consulting to convert a CSV or excel type user information into
> Emerald. The cost is minimal compared to the time and effort
> you would put into it yourself trying to accomplish this.
> Please don't take this the wrong way, as I am not saying you
> couldn't do it. Its just that we have had a lot of customers
> who were in-experienced in SQL Server try, and they all eventually
> just asked us to do it. I'm trying to save you from going down
> that same road. :)
> --
> Dale E. Reed Jr. (
> _________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today |

-- ------------------------------------------------------------------------Daniel Mpolokoso - Technical Manager,           Email:  daniel@zamnet.zmZAMNET Communication Systems Limited,           Phone: +260 - 1 - 751751P.O. Box 32379, Lusaka, Zambia.                 Fax:   +260 - 1 - 290358