[Colchester] Hello!

[Russell Briggs]

Hehe. Yes lets just agree sage is horrible but unfortunately is widely used
and most companies are reluctant to replace it with any open source
solutions :(

As Ian says, hosting sage files on linux is not supported, and theres no
real need since most customers that insist on running Sage have a suitable
windows machine to host it on.

We've written an integration service in C# (using SharpDevelop rather than
Visual Studio I hasten to add!) that runs on the windows sage "server" and
exposes functions from the sage API as JSON web services.

We then call these services from python on our linux server to read and
write sage data. Seems to work well for us.

Russ

PS - Python is awesome :)
On Mar 5, 2013 8:02 PM, "Ian Snow" <ian.snow at btinternet.com> wrote:

> **
>
> Hi Wayland
>
>
>
> Lets hope this doesn't turn into a Sage support thread especially with a
> starting subject of Hello!
>
>
>
> Right Sage 50, oh the big pile of crap that it is.
>
>
>
> Switching to Samba won't necessarily fix your issues and I'll explain why,
> Sage 50 uses DTA files for its "database" which each user's computer will
> read, lock to make changes, write the changes and then save and the bigger
> the DTA fiiles get the longer that takes
>
>
>
> Compare that to say a mysql server using myisam based tables, its only the
> server that locks the files not each client
>
>
>
> One thing that will help with Sage 50 performance is to make sure that the
> AV product isn't scanning the directory where the Sage data is stored, that
> definitely makes it slow
>
>
>
> Ian
>
>
>
> > On 04/03/2013 20:56, Ian Snow wrote:
>
> > > Evening Russ
>
> > >
>
> > > I too am lucky enough to get to play with Linux at work, as I admin
> Linux
>
> > > database, web, dns and mail servers as well as hack php and c++
> admittedly
>
> > > currently on Windows but we're moving to Qt so I can code on linux and
> only
>
> > > have to compile and test on Windows
>
> > >
>
> > > I've been using Linux for around a decade now, and at work on the
> desktop for
>
> > > the last year with Windows in a VirtualBox VM, due to this I haven't
> had to
>
> > > play with Wine in a commercial setting, and last used it at home to
> play Wow
>
> > > years ago before it irritated me too much to continue playing
>
> > >
>
> > > I happen to be a Sage 50 developer and I suspect your mileage will
> vary, for
>
> > > one thing Sage UK will likely not support running Sage on top of Wine.
>
> > > It also has a Sage SData Service these days and I'm not sure how Wine
> handles
>
> > > windows services
>
> > >
>
> > > Ian
>
> > >
>
> > Hello Russ and Ian,
>
> >
>
> > I would be interested in how to get Sage to run 20 users reliably. What
>
> > server tuning would be required.
>
> > It should be possible to fine tune SAMBA so it works better for Sage
>
> > than Windows 2003.
>
> >
>
> > Regards,
>
> > Wayland.
>
> >
>
> > >> Morning All!
>
> > >>
>
> > >> Just a quick message to say hello! I am a colchester resident and
> technical
>
> > >> director at Junari Ltd based in Colchester. I am lucky enough to get
> play
>
> > >> with Linux in my day job :)
>
> > >>
>
> > >> We use Ubuntu Linux servers to host OpenERP and Django-based web
>
> > >> applications for our customers, and run a KVM-based internal
> development
>
> > >> environment.
>
> > >>
>
> > >> I also use linux (ubuntu desktop) on my work laptop and my home PCs.
>
> > >>
>
> > >> Unfortunately we do still use Winblows on most of our workstations in
> the
>
> > >> office, mainly because our customers do too, and we integrate with
> several
>
> > >> windows-based products such as Sage 50 and Outlook.
>
> > >>
>
> > >> I am eager to change this at some point but I havn't really had a
> chance to
>
> > >> experiment with Wine / Crossover to see if its feasable. Would be
>
> > >> interested if anyone has any experience of using Wine in a commercial
>
> > >> environment?
>
> > >>
>
> > >> We are also always on the lookout for good open source developers!
>
> > >>
>
> > >> Look forward to meeting any local linux people!
>
> > >>
>
> > >> Russ
>
> > > _______________________________________________
>
> > > Colchester mailing list
>
> > > Colchester at mailman.lug.org.uk
>
> > > https://mailman.lug.org.uk/mailman/listinfo/colchester
>
> >
>
> >
>
> > --
>
> >
>
> > Mobile: 07925 431381
>
> > Office: 01787 388165
>
> >
>
> >
>
> > _______________________________________________
>
> > Colchester mailing list
>
> > Colchester at mailman.lug.org.uk
>
> > https://mailman.lug.org.uk/mailman/listinfo/colchester
>
> _______________________________________________
> Colchester mailing list
> Colchester at mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/colchester
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.lug.org.uk/pipermail/colchester/attachments/20130305/af3a386d/attachment.html>