Slashdot Mirror


Running a Business on Open Source Software?

Graabein asks: "I'm part of an effort to startup a VoIP provider. We've decided to use Open Source Software wherever possible. Production is not a problem, we can handle the VoIP network itself, POTS termination, web sites, email systems, all the usual stuff. The business side of things is another matter entirely. We need to be able to handle Customer Relationship data, manage subscriptions, handle invoicing and accounts, have a web shop of sorts, online billing, credit card transactions, and more. Whatever system we use has to be able to handle national standards for accounting, or at least be possible to modify to do so. We've looked at Compiere, but our business types are not impressed. Neither am I, for that matter. Requiring an Oracle license is one thing (database independence is 'in development', but it has been for a long time, with no discernable progress), not working properly with Mozilla is another (you need IE to use it fully in HTML mode). What other options are there?"

"Our business types are full of suggestions for supposedly excellent and well suited systems, however they all have in common that they require Windows on the client. If we choose one of those systems our OSS policy is pretty much moot and OSS has been relegated to (some) servers in the computer room and that's about it. I don't mind running these business functions on a Windows server if that is the best system for the job, but having to run Windows on every client in order to access the data is simply not acceptable.

We want Linux and OpenOffice on every desktop. We want to be able to access customer data from a variety of clients, even including Windows. The same goes for Accounting data, HR data, QA data, you name it. Do we have to write our own system from scratch? I'm not sure that is very realistic."

53 of 504 comments (clear)

  1. SQL-Ledger of course ! by Anonymous Coward · · Score: 5, Informative

    http://www.sql-ledger.com

    1. Re:SQL-Ledger of course ! by Anonymous Coward · · Score: 5, Informative

      I'd be a little more reassured if they didn't use floats to store amounts.

      And making the bookkeeper do data entry in a web form with no client side scripting to help (ie: for immediate validation, incremental lookup fields, adding rows to data entry tables)? Ugh.

    2. Re:SQL-Ledger of course ! by cHBs · · Score: 5, Informative

      There are other FOSS financial accounting software. I have created the list Open and Free Financial Accounting System of the ones I found. I hope some of you can use it. The most enjoyable greetings

      --
      I wanna live in a world based on open standards so every one have the freedom to choose. Claus Sorensen, cs@chbs.dk
    3. Re:SQL-Ledger of course ! by Viking+Coder · · Score: 4, Insightful

      No - doubles are just as lousy, in the long run.

      Use Int64s.

      $92,233,720,368,547,758.07 to -$92,233,720,368,547,758.08 should be enough range for most folks. Most governments, too.

      --
      Education is the silver bullet.
  2. Some things to try by ptaff · · Score: 5, Informative

    You might want to peek at OpenGroupware. My colleagues and I have skimmed though what was available and it seems to be the most impressive for at least the customer management side. Though the look of the web interface will not amaze your artist friends, it seems to work well. You can interoperate with Evolution, Mozilla Calendar and some other programs - even Outlook should you want to buy the driver.

    I'd strongly suggest not to be impressed by eGroupWare's feature list and cute themes (I know WE've been fooled). Seems like these guys, though talented, are not really working towards stabilizing the tree, so you see frightening changelogs - like code rewrites between 1.0RC2 and 1.0RC3. They forked from phpGroupWare lately but I can't tell if it's a more serious project.

    One of my friends is completely sold to the Horde Project so you might want to try it.

    All of these will not solve all your issues but no application does and as these three above are open source, you can do the linking as you like.

    1. Re:Some things to try by Red+Storm · · Score: 4, Insightful

      Phprojekt is another good one to check out too. I've used it for a few small time projects and most people have found it relatively easy to understand. The thing I like most about Phprojekt over OpenGroupware is the install docs are much easier to understand, and for the most part it's worked straight from the tarball.

      --
      ---- Fight to protect your right to keep and arm bears! ummmm... ya I think that's right....
  3. OSS Sofware in general.. by Red+Storm · · Score: 3, Interesting

    I have run into this problem a few times with my busisness. What did I end up doing? I resorted to the ultimate open source system, pen and paper. I have looked at a few packages for use as an accounting system but I seemed to always run into a problem with this and that, and when I'd try and read the documentation it sucked ass! It assumed you already knew XY and Z to get the package working when you don't really need to know them when it's finaly working. I dislike winblows as much as the next Slashdotter, but I have to say most programs in the windows einvironment install and work out of the box, and the install documentation is written at a level even a drunk person can understand.

    --
    ---- Fight to protect your right to keep and arm bears! ummmm... ya I think that's right....
  4. Look at freshmeat.net by BeBoxer · · Score: 5, Informative

    Have you looked around on freshmeat.net? There are quite a few people providing some sort of business management package. A quick search for "billing invoicing" turned up the Trabas VoIP Billing package as the first hit. Probably a good place to start. I'm sure there is plenty of stuff that will do most of what you want. Is your company comfortable with doing some minor coding on an existing project to get exactly what you want? If so, there are a lot more options.

  5. A common problem I think, not easy to solve by dot-magnon · · Score: 5, Informative

    I think this is a common problem. I run a business myself, with two friends. We've just started, but we're looking into getting things like customer related software in order before doing anything serious about ourselves. I've worked voluntary with organisations and economy before, and I know things screw up if things are not kept track of.

    I think your questions are hard to answer, and even though I have searched a lot for software (not online shopping/CC, we send invoice by mail since we're only doing business inside Norway) I have yet to find anything free and useful.

    We've really considered doing it ourselves, making a simpe customer registration and management system with a web frontend. Using f.i. perl modules, you can create Excel documents with tabular data, and such. So that might be a thing to do. If you accept a tiny bit of manual work, that is. Of course, that tiny bit isn't that tiny after you've got hundred customers to bill.

    But at least, I know that GnuCash has some functions regarding invoicing and customer registry, but I haven't really had the time to try it out. The rest of GnuCash is good, though, so there should be a hope. So far we can keep track of our economy, and if it works, GnuCash might do our customers as well, even generating invoices.

    Good luck, and I hope this post will create some feedback for myself as well. Feel free to email me if you want to discuss, by the way.

    1. Re:A common problem I think, not easy to solve by RajivSLK · · Score: 4, Interesting

      We had a similar problem at Sparklit (www.sparklit.com if you interested). We ended up developing a CRM from the ground up. We started with something simple and over the years it has grown into a very robust system rivaling anything I have seen.

      Every person we have shown it to says something to the effect of "Wow, Why don't you sell this?".

      Some of the features are:

      Automatic Re-occurring Subscriptions (Discounts/Usage Charges etc are supported)
      Automatic Credit Card Billing
      Support Incidents/Tickets (with multiple statuses/email notification etc)
      Reporting: Revenue/Income/Product growth/Usage etc
      User memos/phone logs
      Debit/Credit Manager
      Fraud Manager
      User Output Tracker (Can track a users usage of the site in real-time. Useful for debugging.)
      Debt Manager - (Automatic Processes owing accounts through 7 steps "Email Invoice/Snail Mail Invoice/Legal Notices/Collection Agency etc" all without any human intervention)

      And much more stuff that is very specific to our system. The point is that you can write a specific app that will perform much better than 3rd party "generic" apps. It is the specific things that will save you time. For example our support request system has a feature that will automatically alert me via Jabber when a support request comes in. It will then analyze the ticket looking for common keywords and suggest a list of "Quick Answers" to respond with. Due to the level integration required with our other systems a third party solution was out of the question. You might find the same.

  6. How much is this ideal policy costing you? by dmorin · · Score: 4, Insightful
    While you're waiting for your Slashdot answer, start the egg timer and multiply it times the amount of money you're burning waiting for the ideal answer. If no reasonable OSS alternative exists, then cut your losses, salvage what parts of your OSS policy that you can, make a decision and get moving. I've been in places where the developers have two workstations - a Unix and a Windows - exactly for the situation you describe. Or relegate Linux to the servers but put Xwindow on the developers Windows machines. That's a day one decision, not one to labor over and try to get perfect otherwise everything falls to pieces.

    Your internal IT should never ever never be a gating item for letting your business department do what it needs to do. If the chairman of the board likes MS Word and just doesn't "get" Open Office, then the amount of his and your time that you burn trying to show him the light will forever outweigh the cost you would have paid to get him a Crossover license and a copy of Word and keep him happy and concentrating on what he is supposed to be doing.

    1. Re:How much is this ideal policy costing you? by Kris_J · · Score: 3, Insightful

      You are completely wrong. An Open Source policy is not just some pie-in-the-sky ideal -- it's a valid business decision based on value and control. Buying into proprietory, closed systems is a significant risk and can result in not only large financial outlays now, but again later, eg; When the product is discontinued and the tax laws change. Software with only a Windows client is almost as bad as no software at all.

    2. Re:How much is this ideal policy costing you? by dmorin · · Score: 4, Insightful
      You are completely wrong. An Open Source policy is not just some pie-in-the-sky ideal -- it's a valid business decision based on value and control.

      Sure, it's a valid business strategy. But you have to know when your strategy is not going well, and change it. Before you even get to the IT section of the business plan, you know you need certain internal systems. The business can run without OSS. It cannot run without accounting software, or whatever it is that the original post (which is not in front of me) said. So I suppose you *could* say "It's more important for everything to be OSS, I guess we will just live without a [blank] system", but I'm not sure that's a valid business decision anymore.

      Buying into proprietory, closed systems is a significant risk and can result in not only large financial outlays now, but again later, eg; When the product is discontinued and the tax laws change. Software with only a Windows client is almost as bad as no software at all.

      It's also the model that's been working for something like 30 years now. While I prefer open source as much as the next guy, you can't just dismiss something as "almost as bad as no software at all" when the world has been running that way just fine. Make open source win by showing it to be of a higher quality than closed -- not by trying to debate why closed source doesnt work. The evidence is against you.

    3. Re:How much is this ideal policy costing you? by Kris_J · · Score: 3, Insightful
      It's also the model that's been working for something like 30 years now.
      Working badly. Back a manager into a corner and you might be able to get them to admit just how many times they've had to throw away an expensive peice of software because their company's needs and the software developer's intentions have diverged. I'm sure any study that placed a value on waste due to closed software would come up with a value in the billions, with a b.
  7. We use the following: by dskoll · · Score: 5, Informative

    For CRM, we use TUTOS.

    For accounting, it's SQL-Ledger. Both the CRM and accounting apps are backed by PostgreSQL.

    For office suites, OpenOffice.

    Web browsing is Mozilla; e-mail is whatever our employees prefer (Mozilla, Kmail, Evolution, Pine, Mutt, whatever...)

    We are completely MSFT-free and intend to stay that way.

  8. Accounting Software by Count+of+Montecristo · · Score: 4, Informative
    We use Passport Software Inc's 'RW32' provided and professionally supported by SCAS, in Torrance, CA.

    It is a closed source general accounting software, but it runs on Linux, and the clients are linux too.

    It takes off where Great Plains Classic left, when it got shut down by microsoft in favor of MS Dynamics, and i think its great, rock solid stuff. (passport, not Dynamics)

    Also, it is written in COBOL, and uses ACUCORP's ACUCOBOL runtime, for which you need a license. Finally, ACUCORP provides an ODBC driver that works pretty nicely with PHP for web frontends and reporting, and also runs on Linux.

    The only gripe I have, is terminal emulation in Konsole, 'cuz the graphics characters come out as A-umlauts and what have you, and i cant seem to find documentation for that issue anywhere.. suggestions?

    --
    *shower*
  9. Re:Because Windows... what? by SIG+TR0LL · · Score: 5, Funny

    It costs you a couple of bucks to buy Starbucks coffee for all your employees. In the grand scheme of your business, it is an insignificant cost.

    It is also a business expense which makes it tax-deductible, so the actual cost is even lower than the price you pay up front for coffee.

    Suck it up and join the rest of the business world.

    --
    i love trolls
  10. Re:Because Windows... what? by Red+Storm · · Score: 4, Insightful

    True, very true. However if you have let's say an IT budget of only $5000 and you have to get enough machines for 4 people, what then? True you can "suck it up" and purchase a machine with windows installed, but if you choose to use linux as we all know that saves you a few bucks now. Writeoffs only happen at tax time, not at startup.

    --
    ---- Fight to protect your right to keep and arm bears! ummmm... ya I think that's right....
  11. Flamebait or not he's right. by BoomerSooner · · Score: 3, Insightful

    VMWare $280
    WindowsXP License $180
    Quickbooks Pro $300

    Not risking a business to save $760, priceless.

    In the end you'll get more out of doing it right the first time than you will by screwing up your accounting/etc and hiring someone (or wasting someone's time) to fix it.

    1. Re:Flamebait or not he's right. by Senior+Frac · · Score: 5, Insightful

      It's not the first $780 he's worried about, but the the 2nd, 3rd, 4th, etc.

    2. Re:Flamebait or not he's right. by Jason+Earl · · Score: 4, Interesting

      It's not about the $780 per desktop. Even Microsoft will happily tell you that the licensing fees are a drop in the ocean. However, there are serious cost issues involved with supporting Windows desktops, and anyone that tells you differently is selling something.

      That's especially true of a business (like this one) where a large percentage of the employees are going to be doing customer service. They don't need full fledged desktops. A thin client connecting via X to an application server would be far less expensive and far easier to support. A single Linux server (given enough memory) will happily support over a hundred thin clients if those thin clients are just doing order entry and light office tasks.

      Not only does the business save a considerable amount of money on software licensing, but they end up with a architecture that is far less expensive to maintain. Software and hardware upgrades are a snap and maintenance is essentially non-existant. If a monitor or thin client fails you simply replace it. Instead of Windows PC technicians you only need a monkey that can be taught which cords plug in where.

      On the other hand, it also is possible to mix in a few Citrix servers for those Windows applications that are needed for specialized desktops, so it shouldn't be that critical if there isn't Linux software for everything.

  12. Re:Open Source is not CHEAPER by dot-magnon · · Score: 4, Insightful

    You're not really asking for a flame, but I think you're disinsightful.

    Open Source developers do business as well. Many developers run their business of OSS, or create OSS outside of their work time. Of course, when someone CREATE a business package, they'll have to know what to do with it. But I would agree that in some cases, the searching user would need some insight in what a product needs to offer.

    What would customers know? Do you advertise on your enterprise site that you use this-and-that Inc. Accounting Software? Besides, OSS isn't insecure by default, by all means. And, in many countries, like Norway (mine), you own your own information. If a business f**ks up handling your information, they're up in their knees in lawsuits in no time, if users want that.

    Bottom line, Open Source is Open Development, not Open Access.

  13. Ask for quotations.... or pay the price by martijnd · · Score: 5, Insightful

    Simple answer: what you are looking for does not (yet) exist.

    There are a lot of fancy applications on the net, none of them any usefull for your purposes (and please prove me wrong, I'd though I had been pretty thorough)

    Having looked at the same problem for my own small business I'd say that if your business is essential to you, you either start asking for quotations for companies that can deliver a solution to fits your purposes or find a stock application that does most of what you need. (and does it in a way that most members of staff understand it)

    Look at the price, and see if its matches your needs and budget.

    As you are setting up your own business, you should NOT be fooling around trying to recreate the wheel; you will need al your energy to focus on your business and hope that it doesn't go belly up.

    One sure way of doing that is having a dozen incompatible systems hide all your major business information from you, your customers, and your staff.

  14. SQL-Ledger by slpalmer · · Score: 4, Informative

    I was recently asking this same question, albeit for a home-based consulting business.

    The solution that I found was SQL-Ledger. While it is overkill for my needs, I think it might fit your criteria quite well.

  15. Re:Because Windows... what? by Strudelkugel · · Score: 4, Informative

    The parent should not have been modded flamebait.

    Are you running a business to make money, or just to say you used OSS? It seems pretty clear that you don't have a business plan, because if you did, the cost of licensing v. cost of finding something that might work would have become apparent, and you wouldn't have had to ask this question. Forget about technology for a sec, get out your favorite spreadsheet and crunch your finances. Get your priorities in order. Don't make the same mistakes my former associates and I did

    --
    Imagine how much harder physics would be if electrons had feelings! -Feynman, maybe
  16. Quickbooks Pro 2000 was my last Intuit purchase by originalhack · · Score: 5, Informative
    I started using Intuit products with Quicken 2.0 and Quit after buying Quickbooks Pro 2000. It deliberately disables many obvious features in attempts to sell add-ons and internet services. It has a very heavy-handed registration process and contacts Intuit's servers later without asking. And worst, it has essentially no open interfaces so it traps your data within itself and refuses to allow itself to integrate with other applications.

    That was my last purchase from Intuit. I have removed it from my system and it sits on a shelf.

  17. Re:Mozilla Runs on WIndows by Anonymous Coward · · Score: 5, Insightful

    Don't count on a "web interface" equalling "will run on any platform". I've lost count of the number of "web enabled" applications that only work in I.E. Some vendors seem to think the purpose of a web interface is so you don't have to install new software on your Windows PC (giving them the benefit of the doubt vs just plain laziness/poor qa), whereas it _should_ mean it's platform and browser independent.

    Personally, if it will only run on I.E. in Windows (wine/xover office notwithstanding), what's the point - may as well run a Windows app.

    If a company goes to the trouble of making a web interface, it ought to be done "right", so any web browser that follows http/html standards can run it. It's not _that_ hard to do.

  18. Not necessarily by HPNpilot · · Score: 5, Informative

    Some net apps require Microsoft extensions or are written using proprietary IE calls and absolutely MUST be run on IE. And don't tell me changing the browser id string will make it work. That will eliminate the warning messages but not make things work. I am having to deal with this issue right at this moment.

  19. Bite the bullet with WINE by bluGill · · Score: 4, Insightful

    You will likely need windows for some things, unfortunatly. Fortunatly Wine works very well for a lot of window programs, and since you are looking for which one you use, you can demand Wine compatability from the start.

    Don't be a jerk instisting on all open source, you have a buisness to run, and that means spending money once in a while. Don't waste your money (except by sending it to me....), but don't be too frugal either. If you can only get what you need from a pay software, buy it and get on with your buieness.

    P.S. buy Crossover as your wine implimentation, those guys put a lot of support into wine and should be helped. (Or alternativly you can get WineX, but they focus on games so I doupt you care about their advantages)

  20. Business reality vs. FOSS idealism. by smoon · · Score: 4, Informative

    You're running a business. Get over the idealism and focus on what you _need_.

    You need an accounting system that an auditor from a public firm will write an unqualified opinion on. In general this is going to mean a commercial product -- Solomon, Great Plains, Quickbooks, etc.

    You need a payroll system that always works. Flawlessly. Many companies outsource this. Explaining to folks that the .7 version borked the checks and you've upgraded to .8 and that borked the witholding info so now you need to rebuild it -- that's unacceptable. Bite the bullet and focus on your business needs.

    You need a business plan that the investors technical people will sign off on. Betting everything on untried and little-used systems isn't going to get you there.

    So for a lot of things: buckle down and do what needs to be done.

    For the other 90% -- use open office, linux or bsd desktops, open groupware or even openexchange (suse). There are plenty of Linux/BSD/Apache/whatever storefront systems. Work on it. For the accounting/finance/etc folks -- get a windows terminal server and use rdesktop for those windows apps.

    --
    "But actually trying to use m4 as a general-purpose langage would be deeply perverse" --ESR
  21. What will your customers be using? by case_igl · · Score: 3, Insightful

    If you are a startup looking to get into the VoIP market, chances are almost all of your customers are going to be running some kind of Windows based computer.

    While I applaud open source and use it myself wherever I can personally, and in our offices, we still all have Windows machines on our desks.

    If 95% of your customer base (and honestly the number is probably higher) is using Windows to either use your product, learn about your product, or do things like manage their accounts it is foolhearted to not have that technology available yourself.

    Our servers and backend systems all run Linux, and yes it does save us money, but don't handicap your business' already statistically slim chances for success by not using a platform most of your customers will!

    1. Re:What will your customers be using? by Brandybuck · · Score: 4, Insightful

      ...but don't handicap your business' already statistically slim chances for success by not using a platform most of your customers will!

      While it is certainly true that you want to support the platform most of your clients have (English), the converse of deliberately turning away everyone else (Spanish) is false.

      Let's say you 5% of your potential customer base will use something other than Windows. You have 10,000 customers this year. By requiring your customers to use Windows, you've just lost 500 customers. You've also lost 500 others that they recommended to your competitors instead. If that lost revenue is greater than the cost difference of support their systems, you're stupid.

      Frankly, in this day and age, with well defined HTML, CSS and ECMA standards, requiring your customers to use Internet Explorer is insane.

      --
      Don't blame me, I didn't vote for either of them!
  22. Open source credit card processing by witten · · Score: 5, Informative

    You mentioned that you needed to process credit cards. Check out my employer, TrustCommerce, which offers a completely open source credit card processing API for connecting to our payment gateway. It compiles on tons of platforms (including Linux), and we have versions for many programming languages: C, C++, PHP, Python, Ruby, Perl, ColdFusion, Lisp, etc. All code is GPL.

  23. What does accounting have to do with VoIP? by rufusdufus · · Score: 3, Insightful

    Your accountants and your tech staff are totally different people right? If the accountants want to use Windows, and your techs want to use Linux, why not?

    I can totally understand the desire to be in total control of the software on your mission critical VoIP system, and Open Source makes a lot of sense. But forcing accountants who know zip about it to use Linux is foolhardy; the time wasted fumbling with an unfamiliar system will dwarf any savings (financial and spiritual) gained by using some open source thing.

  24. Freeside? by jjeffries · · Score: 4, Informative
    Maybe you should take a look at Freeside. It's aimed at ISP management, so it has most of the functions you'll need, plus it's pretty easy to extend so you could have it set up to provision your VOIP services. If you have a perl guy around it would be easy.

    I played with it for a while but the bosses where I work went with anther, Windows-based management system, that has as yet proven too difficult and unstable to actually put into production.

  25. Make your own... by LostCluster · · Score: 3, Interesting

    You are not going to find an out-of-box product that is perfectly made for your business. Use the open-source LAMP combination (Linux, Apache, MySQL, PHP) to build your own application complete with a built-for you database scheme and user interface. That way, you're sure it'll support absoultely everything your business does, and have the ability to upgrade the software should you ever expand into another product line.

    Hire a consultant, and make sure you own the rights to the resulting code when you're done.

  26. Sometimes the customer must be guided... by Phil+John · · Score: 3, Insightful

    ...we get it all the time, customer wanting xyz because it's the latest buzzword, or their friend uses it or they've been seduced by an evil marketing-droid.

    If it fits in with what they need to do and will give them more bang for their buck then go for it. However, sometimes they don't realise that solution xyz has problems efg and that actually solution hij would not only alleviate those problems but cost them less to have supported.

    Hopefully they will eventually come around to the fact that they didn't know what they heck they were doing when they specced xyz, that you are indeed the expert and ask for your assistance, net result? Everything will be right as rain.

    Now if they won't budge on wanting xyz, and it will be a PITA to support, you have to ask yourself:-

    how much will it cost me to offer that support?

    and: how much business (on top of the current project) will I see as a direct result of taking them on?


    If it will cost you more than it will bring in, it's time to either outsource it or let the customer know you can't do it for the price they want. They'll probably thank you for your honesty and come back to you when everyone else says the same.

    --
    I am NaN
  27. I run an OSS CRM project by einhverfr · · Score: 4, Informative

    I can tell you that there are problems you may encounter at the moment trying to get all your needs met and integrated in the way you want. At best, you can probably buy a license for some components that are not yet available via OSS.

    Here is what HERMES offers at the moment:
    Web based CRM including appointments and tasks for customers.

    Features that should be out within another month or 2 include:
    internal communications system (i.e. communications not involving customers)
    Interal appointment handling (i.e. appointments not involving customers)
    Appointment and task delegation.

    In the mid range, I will offer UI independence via SOAP, LDAP, POP3, SMTP, and IMAP.

    In the long run, we want to offer most of what you are looking for. Please understand though, that I have been unable to find any open source packages for handling credit card transactions, so you would probably need to pay for an (expensive) license for such a component.

    Subscription management etc. is not a problem-- there are OSS solutions that could be modified to do this with a trivial amount of work.

    Anyway, Hope this helps.

    I have heard good things about SQLledger, but IIRC, it runs on MySQL, which has a nasty habit of truncating large numbers, so I am not sure if I would trust it. It should be easy to port to PostgreSQL though, I would think.

    --

    LedgerSMB: Open source Accounting/ERP
    1. Re:I run an OSS CRM project by sunset · · Score: 4, Informative

      I have heard good things about SQLledger, but IIRC, it runs on MySQL, which has a nasty habit of truncating large numbers, so I am not sure if I would trust it. It should be easy to port to PostgreSQL though, I would think.

      SQL-Ledger does not work with MySQL. It's a high quality project and works great with Postgres. I use and recommend it.

  28. SimpleData by coryrauch · · Score: 3, Informative

    SimpleData CRM/ERP business software. Works on IE and Netscape, and runs on open-source amp (apache mysql php) platform. I work for this company and we have already over a 100 company sites using it.

  29. Some Easy Solutions... by ShwAsasin · · Score: 4, Informative

    When I started at my current employer we were an all Windows NT 4 company. Our embedded devices used Dos as well. After discussing the benefits of Linux vs. Windows CE/Pocket PC my manager decided we should write our new software for Linux. Although our software isn't open source, it's a minor step forward (in my opinion). One of our former employees who was incharge of shipping wrote all the databases in Access, which up until now has been a pain in the butt to find an alternative. If you have the time using Apache+PHP+MySQL is a great way to integrate a database for general purposes however it's fairly time consuming. Another alternative is using Open Office's data sources functionality and creating your own forms within the documents. It's similar to Access from what I've played with it, but I'm no Access expert. I do know that you access DBase, MySQL, and several other database types and since OpenOffice is available for Windows/Linux it's something to consider. I haven't found anything good as of yet and the accounting department is pretty reluctant to hand over their software for me to test in Wine. =D

  30. Re:Try a Mix by SwansonMarpalum · · Score: 5, Informative

    Your opinion comes from a demonstrably spurious source.

    MySQL and ReiserFS are both made available under the terms of the GNU General Public License.

    The GPL allows people to do absolutely whatever they want with software obtained under it, including using it to run their business in a commercial environment. The GPL does not allow one to distribute the product which was obtained through the GPL in a non-GPLed product, or to distribute products which contain GPLed products under a non-GPL license.

    MySQL AB and Hans Reiser make their money by offering alternative commercial licenses which will allow you to distribute the work you derive from their work under a non-GPL license. This only means you have to pay them if you want to release software which links to the code they wrote

    --
    "Give away the stone, let the oceans take and transmutate this cold and faded anchor." - Maynard James Keenan
  31. Oracle Apps will support Mozilla by ziegast · · Score: 3, Informative

    Requiring an Oracle license is one thing ..., not working properly with Mozilla is another (you need IE to use it fully in HTML mode). What other options are there?

    If you use Oracle Applications, you might be interested in Oracle's announcement that they're going to be supporting Mozilla.

    That takes care of half of the problem.

    -ez

    Karma: Whore (you look at your article scores after posting)

  32. When will some OSS developers get a clue... by m0nkyman · · Score: 4, Informative

    ... and get together with an MBA, and write the killer app for OS. Put together a modular business package, customizable for a variety of businesses (that's where you make the money). Look at ACC-PAC for inspiration. Most businesses need :
    Accounts Receivable/Customer relations
    Accounts Payable/Supplier relations
    Inventory
    Payroll/ HR management

    This ain't rocket surgery. It is painfully dull, boring and potentially stupidly lucrative.

    As one person I suggested it to said: "Thom, that would be great but involves two things that geeks hate: writing accounting software, and cold calling."

    Most businesses that need this desperately are small to medium sized businesses that are currently using a few thousand dollars worth of computer hardware exactly the same way they would use a two hundred dollar typewriter.

    When I started where I work, inventory was typed out in MS Word, and printed out once a year, with additions hand written throughout the year. We're currently paying someone several thousand dollars to write an inventory database for us in Filemaker. Why wasn't this done years ago? THEY DIDN'T KNOW IT COULD BE DONE!!! If you want to make a good living, and can write accounting software, cold call businesses in your area, and tell them:
    "I can make the computer work the way YOU want it to work, not make you work the way that off the shelf software wants you to work."
    You will make the sale, and you can reuse your code on the next project.

    Why don't I do it? I have a job I like more, that pays enough to keep me in all the toys I want. :)

    --
    ~ a low user id is no indication I have a clue what I'm talking about.
  33. A few things to consider by invisik · · Score: 5, Informative

    I am a consultant that started my own thing just about a year ago. I do a lot of day-to-day Windows stuff, but internally run SUSE on just about everything and my wife has a Powerbook.

    We use Quickbooks 2003 for accounting. Works well, fairly easy to use for my non-accounting brain. What I did to accomplish this was to run a Windows 2000 Server basically as a terminal server to allow either one of us to use Quickbooks on our boxes. I had the firewall forwarded so my accountant could get into it as well. They key is not to use the box for anything else, no web browsing, no e-mail, no nothing. Keep it patched, toss on a copy of Symantec antivirus, install the free version of SFU and you can back it up over the network on yer linux box. Seems to be the best way to "Windows-enable" your linux network.

    I also run Mozilla mail against SUSE OpenExchange Server with great success and happiness. OpenExchange has an excellent web interface to mail as well as document management (with revision control), knowledgebase, contacts with contact history type functionality, job and project tracking (admittedly difficult to use), and internal instant messaging. Can sync yer Palm to it as well, or toss on Outlook with IMAP if you really have to. It's quite an excellent product and the pricing is quite reasonable considering what it can do. Doesn't need huge system resources either. I run it on dual a PIII-866 with 256MB right now--512MB would be quite sufficient. (swaps a bit with 256)

    OpenOffice.Org runs on the SUSE desktops and the PowerBook has genuine MS Office X. She gets into some complex Excel formulas and macros so decided to go MS on that one. I have NO problem recommending OpenOffice.Org to anyone doing office tasks. If you gotta have support, go StarOffice from Sun--just as good, only a few bucks.

    I haven't really gotten into any of the PHPProjekt-type wares. Seem to be a lot of functionality, but not much of it done up really well, and much less of it useful in and office setting. That groupware "killer app" is still lurking out there somewhere, if it's not the SUSE product.

    Linux on the desktop is definately do-able. I do it here. My wife's old PC with XP crashed a few months ago--bought her the PowerBook and never thought about the Windows box again. All of your major tasks can be done on linux. I have an IBM X31 laptop and SUSE Pro 9.0 support all my hardware, including wireless network card and even some funky IBM stuff. I'm sure RedHat would be fine as well, especially on desktop systems--your preference.

    The community will get better with accounting-type programs. I think it will probably still be a few years until something surfaces. The Win 2000 as terminal server should suffice until then, and it's not too expensive.

    Good luck in your efforts, let us all know how you end up!

    -m

    --
    http://www.invisik.com
  34. Re:Because Windows... what? by Oliver+Defacszio · · Score: 3, Insightful
    OK, Charlie, let's examine this old chestnut of an argument that you've trotted out.

    So, I'm going to start a business with 5 employees, including myself. I have a $5000 IT budget. I am the only one in the office with any computer experience, which is as follows:

    - About 15 years of 'practical' computer experience.
    - About 5 years professional experience as a desktop jockey and, later, as a Windows sysadmin.
    - I've installed a half-dozen UNIX (mostly BSD) servers for very, very small web sites, but never as a file/application server.
    - I've tried Linux on the desktop a few times, but gave up after a week of fighting with any number of typical desktop Linux problems (hardware support, package management, etc).

    So, how am I going to spend that $5000? Should I become embroiled in trying in vain to set up FREE Linux/BSD desktop and server machines without any real experience? Network shares, proxies, client applications, network printing -- that would take weeks. Should I hire someone to do it for me at a ridiculous cost, not to mention the support costs for when something goes wrong in my 5 station LAN? How many operations that size have you seen that can afford IT support costs @ even a measly $70 an hour? Or, should I just eat the software costs of Windows, have the entire small LAN running in a weekend by myself, and essentially forget it all exists? True, buying Windows means I can't afford the same hardware horsepower, and I may be stuck using a PC as a server (instead of a 'real' one), but I can fix 95% of it myself.

    This happened in countless scenarios that I've personally witnessed (after having been brought in to take over the maintenance once the business gets busy enough). This constant "linux is cheaper" chant is completely, yet unsurprisingly, ignorant of several factors above and beyond the actual purchase price.

    --

    -
    Inventor of the term 'pardon my French'.
  35. Browser-based interface not always the best choice by Guillermito · · Score: 5, Insightful

    IMO, browser-based interfaces lack in the usability front. They are simply not rich enough.

    They work fine on the web because they are a compromise: I give you a site with a rather dull interface , but you get to it without installing custom software AND ALSO you are presented with a familiar and simple user interface (click links, scroll pages, fill up form fields, submit info), so you can catch on quickly with my site, because it work quite similarly to other sites you have visited before (an important aspect that some flash-based and some overworked DHTML-based sites seem to overlook).

    Of course, the software used internally in a business has both more demands and less limitations.

    It has less limitations because you can install wathever software you want (you have tech support, and don't depend on the end user failing to install the latest plugin). You don't have severe bandwidth limitations. You can standarize on a single platform for your clients, and on a single screen resolution (or, if it is not single, at least can be a known and definite set). You don't need to engineer your application to be run in a restrictive security sandbox, so you can have full control of the devices attached to your computer. For instance, you can make the application print an invoice as part of a transaction, without explicit user intervention (no "print" dialog), automatically selecting certain parameters (paper size, margins, resolution), not allowing the user to mess with them. The application you build can also have a steeper learning curve, because you won't have casual users (potential customers that have to figure out how things work on their own, and that you'll loose if they get annoyed), but permanent users that are your employees and can be trained.

    The user interface of business software has higher demands too. If you fill in an online purchase form twice a week, you can put up with a clumsy user interface. But if that is your job, and you process purchase orders from 9 to 5, you'll need something better than the average HTML form. For instance, when a customer tells their name over the phone, you type the first three letters and a list of those customers that meet the citeria is instantly displayed for an easier selection. Also, you might want your text to be spell checked as you type when fou fill a text area. If you have used both SQL-Ledger and GNU cash, or PhpMyAdmin and mysqlcc, or any web-mail and any mail program, or groups.google.com and any newsreader then you should know what I'm talking about: even the best engineered web application falls short to almost all rich GUI applications.

    Of course, in the future web interfaces might evolve to become richer (XForms, for intance), but until then, selecting a web-based architecture for internal business use certainly can hurt productivity.

    Having said all this, I must also point out that it depends on what you call "a Browser-based application". I have taken for granted that the original poster meant a HTML-based application as opposed to, say, an application consisting in a single page containing a java applet or ActiveX control.

  36. Re:How much is lack of research costing _you_? by Anonymous Coward · · Score: 3, Insightful

    So I suppose you *could* say "It's more important for everything to be OSS, I guess we will just live without a [blank] system", but I'm not sure that's a valid business decision anymore.

    You have created a false dilemna. You suggest there are only two options: non-OSS or nothing. That simply isn't true. All your talk about egg timers and burning money is also unwise. It is fairly obvious that the original poster should not just grab QuickBooks while s/he is at Walmart because it is convenient. Nor should a startup jump in with PeopleSoft or SAP or GnuCash, or anybody without a reasonably thorough investigation. Two or three days of waiting for Slashdot suggestions is a minor effort in the larger research.

    The original poster is leary of building from scratch. I think that should be re-considered. Every off the shelf solution involves considerable "business process re-engineering." In other words, you have to force your business to work the way the software was built. Universities adopting Peoplesoft have found that they could not pay their faculty "9 over 12" because Peoplesoft wasn't built that way. Professors accustomed to working 9 months, but receiving paycheck all year long suddenly are forced into larger paydays for 9 months, then nothing for 3 months. Don't like it? Pay a lot of money to have the system modified, or do it yourself.

    Ask Chevron how much in house programming it took to get SAP to allow vendor payment authorization the way Chevron had always done it before. Ask Fisher Price how many in house programmers it takes to get Keenan/Arbor to handle sales promotions that Keenan/Arbor didn't envision when they built the framework. Ask your local utility how much work it takes to tie your billing and provisioning together. See if they've even achieved it! It's pretty tough when you don't own the source. Oh yeah, and watch what happens when your vendor of choice releases an update to one of the modules. It wipes out all the "fixes" and customizations you have added. Don't cry to them. They can't possibly support every customer's customizations.

    Now go ask Verio how five programmers can build a system from scratch that includes ordering, provisioning, and billing with global currency and pricing support in an amazing way that fits the company perfectly, while 200 hired experts struggle on to get a name-brand shrink-wrapped solution out of the planning stages. Granted, five full-time developers isn't cheap. But I can guarantee that no matter what you choose, you will need a team of developers to make it work. And when the solution is not homegrown, that team has to include highly paid outside "consultants."

    Build your own system from scratch to fit your company. Don't build/rebuild your company to fit your system.

    Oh, and about needing it to work on clients of many platforms... One word: Mozilla. It's a super nice client. From custom XUL apps to n-tier web apps, Mozilla is awesome! And it runs on more platforms than I can name. Of course, there aren't too many proprietary systems out there that have taken advantage of the platform advantages of Mozilla, but did I mention that you can build you own system?

    Or... you could just outsource the whole thing to India.

  37. OSS For Critical Internet Infrastructure by tomRakewell · · Score: 3, Interesting

    Ever since I started getting those threatening postcards from the Business Software Alliance, I have been determined to do whatever I can to get Microsoft out of my business. It has not been easy at all. In fact, I wonder if my extreme hatred for Microsoft has clouded my business judgment.

    My work has not been all for naught. I have easily and painlessly jettisoned Microsoft from all of our critical Internet infrastructure. No more Microsoft http servers, smtp servers, file servers, etc. This is where open source excels. It does not make much business sense to use Microsoft for stuff like this.

    Another huge open source success is the use of Postgresql instead of Oracle or SQL Server. It was easy to re-program our proprietary apps to use Postgres. We save a ton of money by never paying for an Oracle license. Unless you can't live without DB clustering or other advanced features, Postgres is the answer.

    My efforts to get rid of our proprietary point of sale/order entry system have taken me down a long, complicated road, and I have decided that the best solution is developing a completely custom system. This has cost a ton of time and money, and in two years has still not resulted in a functioning alternative or the decomissioning of a single Microsoft server! One day, though, I swear it will pay dividends. My stubborness here has so far been a big can of worms. But who knows, even massive, expensive fiascos like The Big Dig can one day "go live" and everybody is grateful.

    OpenOffice is a no-brainer, unless you need to exchange documents with other firms, or you need some of MS Office's advanced features. My employees initially revolted (they were just not used to it). But OO is surprisingly feature-rich, if not intuitive or robust. Of course, even though OO has been a GREAT success story, it is still deployed on Windows machines. However, I now have a migration path to Linux workstations.

    I do not even have any desire or plans to get rid of all the Microsoft boxes. We will still use Quickbooks for the back end accounting. We will still do desktop publishing using BSA-approved software (although the GIMP has replaced Photoshop in our non-print work).

    The one shining beacon of hope for me is that, even though I have not significantly reduced the number of Windows machines at my business, I have significantly increased the number of FreeBSD and Linux servers, and I have not ever upgraded my Windows NT 4.0 workstation licenses!

    My advice is to use OSS whereever you can, and proprietary software whereever you must. Always make technology decisions that give you the option to migrate to OSS if the option presents itself.

  38. Re:Because Windows... what? by _Sprocket_ · · Score: 4, Insightful


    I am the only one in the office with any computer experience, which is as follows:

    - About 15 years of 'practical' computer experience.
    - About 5 years professional experience as a desktop jockey and, later, as a Windows sysadmin.
    - I've installed a half-dozen UNIX (mostly BSD) servers for very, very small web sites, but never as a file/application server.
    - I've tried Linux on the desktop a few times, but gave up after a week of fighting with any number of typical desktop Linux problems (hardware support, package management, etc).

    ...


    True, buying Windows means I can't afford the same hardware horsepower, and I may be stuck using a PC as a server (instead of a 'real' one), but I can fix 95% of it myself.


    Let's look at the situation.

    You're not qualified to administer a Linux environment. You probably don't want to bet a business on it without additional training or help.

    But you do have experience with running a Windows environment. So you'll be able to handle that. Your choice will be pretty easy to make.

    Of course - plenty of buisnesses consist of people without any IT experience on any platform. These folks will either need training or hire help. And in this day and age, finding help with Linux is not so hard.



    This happened in countless scenarios that I've personally witnessed (after having been brought in to take over the maintenance once the business gets busy enough). This constant "linux is cheaper" chant is completely, yet unsurprisingly, ignorant of several factors above and beyond the actual purchase price.


    The pitfall small businesses run in to is thinking that since they've used Windows at home, they can also manage to run a reliable Windows-based infrastructure at work. And sure - they may get it running at first. But they inevitably run in to a situation where they need to hire help. So much for avoiding the cost of hiring IT experience. This is the scenario that I have personally experienced (and been hired to handle) numerous times.
  39. OSS does not address many business needs by firewrought · · Score: 5, Interesting
    Business has a lots of needs that OSS does not address. In part, this is probably because business coding is the most mind-numbing coding one can do, so volunteers don't take them on often. GNU Enterprise may eventually help here, but it's going to take a long time, and bringing the necessary expertise to the table will be difficult (if the gnue project even realizes it needs this expertise).

    What sort of needs does a big business have? Well, they all need to manage human resources. Most need to track items in their warehouses and perhaps training for their employees. The industrial sector will have many additional needs to track equipment, schedule resources, control work authorizations, and safely take equipment in and out of service. Running an enterprise call system also takes more than a PHP app.

    There are dozens of other highly generic needs that I haven't mentioned, but all take extensive effort to set up, customize, and integrate into a business environment. And these things are *mission critical*: millions of dollars can ride on the availability of the software. Open source can eventually get here, but it will have to (first) be written, (second) creep up through small business, and (third) be vetted and pushed by consultants who can make money from long-standing service contracts.

    I'm not trying to be pessimistic about open source, but there are many unmet needs here. Don't expect to run a serious business without proprietary software. In fact, be as objective as possible when evaluating software needs for your business... pretend that you have to defend every decision in front of someone who doesn't care about the distiction b/t free and non-free software. Someone who only thinks in terms of money, growth potiential, implementation schedules, and risk. If OSS can't stand its ground here (even with the price advantage), drop it. Don't jeporadize your business, and (if you're working for someone else) don't give your boss a bad taste of what OSS is all about.

    Stallman--as much as I support the guy--completely misses the real world when he says that "any business based on proprietary software deserves to fail". Deserving or not, any medium or large business that is not based on proprietary software will fail.

    I hope open source can one day address these needs, especially for small businesses and start-ups, but I'm not too worried even if it can't. If Linux becomes good enough in other aspects, these proprietary apps will be made to run on Linux too (and some of them already do). "Mostly" free is good enough for me.

    --
    -1, Too Many Layers Of Abstraction
  40. Re:OSS Software in general.. by mysticgoat · · Score: 4, Informative

    Has anyone here tried GnuCash?
    [Raises hand]
    I don't have accounting complicated enough make it worthwhile using accounting software, but I do wonder how it stacks up compared to Quicken

    GnuCash is hands down better for a business than Quicken. IMO, it looks much better for business work than Quicken's big brother, QuickBooks. I have some experience setting up QuickBooks and Peachtree accounting systems for mom & pop businesses, and I've run my personal accounting on one version or another of Quickbooks for about 10 years now. I've just changed over to GnuCash at the beginning of the year, as I'm migrating to Linux.

    GnuCash is a full-fledged double-entry accounting system with good audit capability (burn a standard General Ledger to CD every end of month, etc), good report features, and by reputation good A/R, A/P, tax, and payroll capabilities (It pleases me that I don't have to explore those myself.) Also by reputation, its customer and vendor tracking is pretty thorough. It also has very good support for online banking and highly regarded multi-currency handling. And since it is GPL, if extensions are needed you could hire a tame programmer to do them (and use the world to beta test his product).

    I'd suggest thoroughly exploring GnuCash and using it as a standard to measure other possible accounting systems against. I think it likely that you'd end up choosing GnuCash when all is said and done.

    You'd need another database for the non-financial aspects of tending your customers. There are advantages in keeping technical support history, etc, separate from the financial history. At a WAG, I'd bet that one of the Help Desk packages would handle all of the most important parts of this for a VoIP provider. I haven't explored OS Help Desk databases, but I would think there would be some good ones available now.

    I think OOo, GnuCash, and some GPL'd Help Desk database would cover most of your software needs. And in Linux, to boot. That will carve your potential licensing and support costs down quite a bit.

  41. simple tip by Sivaram_Velauthapill · · Score: 4, Insightful

    Whatever you do in the end, don't make the same mistake that tech-oriented people always make. Namely, putting the technology ahead of the business. There is no point of using OSS just because you want to. What comes first is the business. What is best for the business? If it is Windows, that's what you should go with. If OSS works out better, that's what you should use. Also, don't forget that you can have a mix. For example, you can use some Windows software for the business process tasks (say CRM or something) but use linux (openoffice,etc) for basic desktop use. Depending on what you need, you can pull your customer data from the Windows database (say MySQL, or MS SQL Server, or Oracle) into a linux application (this depends on what your final business software allows).

    Sivaram Velauthapillai

    --
    Sivaram Velauthapillai
    Seeking the meaning of life... @slashdot of all places ;)