Archive for October, 2009
Sage Line 50 ODBC Explorer
OK, a couple of days later than I said (work schedule is crazy at the moment) you can download the free Sage 50 Explorer. This tool allows you to connect to Sage Line 50 data, query any of the tables and then export the resulting data to Excel or a comma separated text file.
Please note this uses the Sage ODBC driver which is read-only, you cannot change any data only extract it. However also please note the software is provided as is with no warranty of any kind implied or otherwise. If you are going to extract data to be extra safe take a backup first! Simply send an email to explorer@domorewithsage.com where you will receive a link to download the software.
In the next week or so I will be adding a couple of videos to demonstrate the product. You can additionally head over to ezinearticles.com and search for Sage Line 50 ODBC and you will find a couple of articles I have written on querying Sage data.
Category: Uncategorized
New Sage Product Launched in the UK
I blogged about this on my other blog over at Sage Line 500 regarding the official UK launch of a new Sage product called ERP X3. Now it is unclear where this product will sit in the range, probably between Sage 200 and Sage 1000 but thats yet to be confirmed, but once I do know I will let you all know! For mid-range customers this *might* offer a better fully integrated CRM and financials solution and this is touted as a fully web enabled solution.
Category: News
Sage Line 50 for iPhone?
You know I start lots of little projects, some end up as products, others get consigned to the bin. What I have learnt over many many years in business is that now I don’t waste much time on things unless their is a definite market of willing buyers for any prospective project. So as much as an exercise for me to learn iPhone development (and perhaps join the app store goldrush which seems to be taking place!)
I have the bare bones of, for want of a better term, a sage line 50 ‘viewer’ for the iphone. For those technically inclined I have a small php web server which reads data from line 50, packages it as XML which then gets consumed by an application on the iphone. Cool? certainly, commercially viable? unknown at the moment, if you have a few seconds spare I would be grateful if you could complete the poll on the right.
Cost wise I would probably give away the iphone application and charge a nominal fee for the server portion of the solution. In real terms it would enable you or your staff to remotely view Line 50 data (Sales, Purchase, Nominal, Stock and transactions) anywhere they could get wi-fi or a 3g signal.
Category: Sage 50
Sage Line 50 ODBC
I get alot of requests on how to extract data from Sage Line 50. It always revolves around using the supplied ODBC driver which gets installed along with Sage. However I have taken things a step further and developed what I call ‘Sage 50 Explorer’. This is a visual tool which uses the ODBC driver and allows you to query the data in any Sage table, issue SQL against at and, even better, export the data from any table to a comma separated text file or an Excel spreadsheet.
Best of all its, FREE and will be available early next week for download.
Category: Sage 50, Small Business
