Freeside :: Windows :: And a whole lot of love.

[Jacob Leaver]

If one were to add a flag to the tables that need server-side things to
happen, then one could use a cron demon job to to the server-side stuff, and
then clear the flag.

As far as adding garbage goes, I think that you could use accesses drop-down
lists, and error trapping to prevent garbage.

-----Original Message-----
From: Ivan Kohler [mailto:ivan at sisd.com]
Sent: Wednesday, October 07, 1998 3:24 PM
To: cerkit at skyfire.net
Cc: ivan-freeside at sisd.com
Subject: Re: Freeside :: Windows :: And a whole lot of love.


The only caution I have is that while _reading_ database tables should
work, _writing_ or _modifying_ database tables will miss some of the
callbacks... for example, if you add someone to the svc_acct table
directly, the `useradd' command won't get run.  It might also be possible
to add garbage data normally not allowed (since, again, you are modifying
the database directly).

Read access has all sorts of interesting reporting possibilities, though,
and in all likelihood the people who would need most reports at an ISP
would be happier with Access.

As soon as I return home I'll setup Access on my roomate's Windows machine
and play around with this with you.

On Wed, 7 Oct 1998 cerkit at skyfire.net wrote:

>
> 	I'm currently doing testing with interfacing freeside
> database tables under mysql using Access, from Office97, through the
> freely available, MyODBC drivers obtainable on http://www.mysql.org
>
> 	If anyone is interested in sharing their experience, ideas or
> partaking in this venture please communicate with me here on the list.
>
> cerkit-------  --- -   + -- --  : --   '    \   / ------- -  +   +
> "The difference between the internet and a cactus plant is that the
> cactus has the pricks on the outside."
> -------  --- -   + -- --  : --   '    \   / ------- -  + at skyfire.net
> 			  ` icq 12416036 /
>
>

--
Ivan Kohler <ivan at sisd.com> - finger for PGP key
Silicon Interactive Software Design - http://www.sisd.com/ - 888-670-SISD
Open-source billing and administration for ISPs -
http://www.sisd.com/freeside
20 4,16 * * * saytime # please don't be surprised if you find me dreaming
too