[ale] OT - Billing software for small time web hosting company
James P. Kinney III
jkinney at localnetsolutions.com
Thu Sep 2 15:29:34 EDT 2004
Cool! The billing/accounting app I use SQL-Ledger. It does loads of
stuff, but recurring billing is currently handled by outside scripting.
Post it up on Freshmeat (when they get back online --MySQL connection
error!) as there is bound to be a need for it.
On Thu, 2004-09-02 at 14:32, Nathan J. Underwood wrote:
> Ok, I was using a spreadsheet to track what domains we were hosting, who
> the client (owner) was, what 'hosting package' they were using, when it
> was due, etc., and it quickly got out of control. If I didn't look at
> the spreadsheet every day (we didn't think to setup billing cycles, so
> we had customers that were due pretty much every day), I got behind. I
> went to freshmeat to try to find something that was free (we're in that
> 'starving artist' phase of business right now), would keep track of who
> we were hosting, when they signed up, when they were due, and how much
> they owed up. Also, I wanted it to email me when customers were $X days
> out, so I could send them a net 30 invoice. Long story short, couldn't
> find anything, so I threw something together myself. It's ugly,
> undocumented, insecure, etc., but pretty straight forward. If there's
> anyone out there in a similar position (i.e. need something to track
> billing, and remind you when to bill folks ahead of time), if you
> promise not to laugh, I'll send it to you. You pretty much just have to
> do the following to get it up and running:
> - Create a database
> - Add your user to the database
> - add a 'use table;' statement to the top of the .sql file
> - run mysql < file.sql -u -p
> - unzip the files in a directory that your webserver can see
>
> Again, I wouldn't use it anywhere that someone wearing a darker hat than
> you could get to it, but it works, and is helping me to keep my sanity.
> If you're interested, shoot me an email and I can email it to you.
> The whole thing (zipped) is only around 56k.
>
> If this is the wrong place to stick this, my apologies. I just know
> that there are some other folks doing web hosting, and I wasn't sure if
> they were having the same problem.
> --
> registered linux user # 73046
>
>
> !DSPAM:41376769207616452218072!
>
> ______________________________________________________________________
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
>
> !DSPAM:41376769207616452218072!
--
James P. Kinney III \Changing the mobile computing world/
CEO & Director of Engineering \ one Linux user /
Local Net Solutions,LLC \ at a time. /
770-493-8244 \.___________________________./
http://www.localnetsolutions.com
GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jkinney at localnetsolutions.com>
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
More information about the Ale
mailing list