Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 10 total
Thread Manipulating data from different sources
Mon, May 4 2009 2:34 PMPermanent Link

Peter H
Hi

I am using 4.26 Client Server for a Business management System for a Client.

I do some integration with the Clients accounts system (Sage Line 50), which I read from
but dont write to using an ODBC driver supplied by Sage.

The Sage ODBC Driver is crushingly slow, it can take 30/60 seconds or more to get  a few
lines of data.  My client is fine with it as it saves them lots of work and time.

I also do some reports that take a few minutes, my client is fine with this also as it
saves a week of work everytime they press the button.

I am pretty much stuck with looping through the SageData, querying DBISAM for relevant data.

I would like to have a database do the work.  For example, I can open the Sage stuff by
linking the tables to an Access Database and presumably do joins against  a DBISAM
database similarly linked with DBISAM ODBC.

Anyone got any better ideas?

Thanks

Peter
Tue, May 5 2009 10:33 AMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Peter,

I also have a customer using SAGE software (but not Line 50) that uses MS SQL
Server. My approach have been to use ADO in Delphi, to import data from SAGE
applications to DBISAM temporary tables, and then produce the reports they want,
combining data from SAGE applications with data from the DBISAM database of my
application. What database system is the SAGE 50 app using?

--
Fernando Dias
[Team Elevate]
Tue, May 5 2009 6:31 PMPermanent Link

Peter H
Hi Fernando

Sage Line 50 uses a Sage database of their own format.  It was a clunker 10 years ago and
its getting no better!!!!

If it was SQLServer it would be a breeze, I would ODBC DBISAM and ODBC SQLServer with
Access and front end in Delphi.

I've spent all day tossing around ideas and I'm going with running a batch job in the
night time - I've spoken to the client and they are ok with it. They presently dual entry
and reconciling errors is taking them lots of time.

Its actually not as bad as it looks as the client has 11,000 invoices and only issues 2000
a year.

The job is nothing really as its only 20/30 a day to run some logic on and post or reject
and run a report on the rejects.

I'll import all 11,000 into a DBISAM table by looping through them which will take a
little time, once thats done a select of the new records that have been added to Sage
takes about 3 minutes (running on Windows 2003 server!)

Once the Invoices have been posted in Sage they cannot be altered other than by raising
Credit Notes so if I import the Credit Notes as well it should work.

I'm surprised no-one has written a driver for Sage, lots of people use it.

Regards


Peter
Fri, May 15 2009 5:10 AMPermanent Link

Peter H
Hi

I have an elegant solution to this problem.

I import all the Sage recs I need into DBISAM in the night time and let DBISAM do all the
work.

I 'Top up' the new recs every day which only amounts to 100 recs and run import routines
and reporting on them.

It has in fact opened a whole new revenue stream for me because the client likes what I
have done so much.

DBISAM has been fantastic for me as I bought DBISAM for a specific job in 2005 and the job
is still ongoing in 2009!

The software I created for my client is 'business critical' - the client could not survive
one day without it - a programmers dream.

I work for myself and DBISAM has put the food on my table for 4 years with no end in sight!

Thanks Tim!


Fri, May 15 2009 8:21 AMPermanent Link

"Rita"

"Peter H" <peter.hodgson@software4biz.co.uk> wrote in message
news:F46864CE-EAC4-4864-9943-18F650EC5515@news.elevatesoft.com...
>
> I work for myself and DBISAM has put the food on my table for 4 years with
> no end in sight!
>

That is cool any dinner invitations ?
Rita

Fri, May 15 2009 11:06 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Peter,

<< DBISAM has been fantastic for me as I bought DBISAM for a specific job in
2005 and the job is still ongoing in 2009!

The software I created for my client is 'business critical' - the client
could not survive one day without it - a programmers dream.

I work for myself and DBISAM has put the food on my table for 4 years with
no end in sight! >>

Thanks for the kind words.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, May 20 2009 9:31 AMPermanent Link

Peter H
"Tim Young [Elevate Software]" wrote:


Thanks for the kind words.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

I am still staggered by DBISAM, I find it very fast and reliable.  The reliability is key
for me.

The app has 25 people logged in at all times.

The client wanted to be able to put a client on hold and deal with another client at the
same time without closing down the first client. Because the client form opens 10 related
datasets (contacts, invoices, alerts etc) and another 10 or so and reference tables there
were some difficulties in this.  I got around this very simply by using command line
options to change the look and feel of the application, so the user knows which version of
the program they have open.  

Each user can open the software with two versions at once (X1 and X2).  This has worked
great and equates to 50 users logged on with the possibilty of  as many as 1000 datasets open.

I have no difficulty running the server running on a single core AMD 2800 Athlon on
Windows 2003 Server.  The server occassionally runs slowly as it also handles a Sage
accounts program that I would like to off load.  The backplane is running on two cheap 48
port gigabyte switches bought (new) on eBay for $150 each.

I off loaded 200gigs of documents onto a FreeNas (cut down Linux BSD) box which is used as
a document server for the organisation.

Apart from a problem at the start with a release (4.21 I think) I have had no data
problems or performance issues of any kind.

Thanks Again Tim

Regards


Peter
Thu, May 21 2009 3:16 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Peter,

That's a great rundown on your implementation.  Did you get our emails a
while ago about case studies using our products ?  We're always looking for
customers that are willing to do a case study or small write-up that we can
put on the web site.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, May 21 2009 5:57 PMPermanent Link

Peter H
"Tim Young [Elevate Software]" wrote:

Peter,

That's a great rundown on your implementation.  Did you get our emails a
while ago about case studies using our products ?  We're always looking for
customers that are willing to do a case study or small write-up that we can
put on the web site.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim

I would be very pleased to do a write up of my project over the last few years.

Please eMail me and let me know what sort of thing you are looking for.

Best Wishes

Peter
Tue, May 26 2009 1:04 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Peter,

<< I would be very pleased to do a write up of my project over the last few
years.

Please eMail me and let me know what sort of thing you are looking for.  >>

I sure will, thanks.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image