 |  |
Go back to my early posts several months ago :) Alot of people are
Re: Usage Import
From: mbailey@journey.net
Date: Thursday, March 1, 2001
Time: 10:15:28 pm
switching to databases for Radius It would be nice to pull things in from
our radius server as a summary statement. Of course this might have to
loop per user also you need to take into account on the statment to look
at user and user@domain
What would be kewl then is allow for wholesale to another provider.
Say at @otherdomain
I could assign an account inside opti as the bill account for otherdomain
and opti pulls radius data for all of their accounts say unique users
and bills that N times the product inside their account
Or summarize the total hours for their users and bill them at hours times
product in the account. :)
Maybe from the web interface when customers check time online they get
summaries for previous months and daily data in current month..
Maybe an option to save the extra data in another database for historical
reasons..
Well have to upgrade tommorow.. Can I trust the new upgrade routine? ;)
Enjoy the rest of the evening shawn and take a day off..
--Matt
On Thu, 1 Mar 2001, Shawn Hogan wrote:
> mbailey@journey.net wrote:
>
> > I agree.. This is where link against a seperate database would be nice
> > (say MSSQL) which can handle the large data a bit better than FMPro
> >
> > We currently put several hundred thousand records per day into MSSQL for
> > radius.. I could only imagine that is alot of data and Plat* and IBob both
> > just link to this data and perform computations directly on the radius
> > database. I have a pretty good little DLL that links to our database and
> > pull per session informationo out..
> >
> > Just thinking that maybe another table for daily information for the users
> > to see and one for billing aspects on a monthly basis.
> > This information can be quite usefull for things like should I give this
> > guy a refund because he claims he could not get on.
> >
> > Ooops yesterday he logged in twice for 5 hours total time. Guess he is
> > just pulling my leg and will not be getting a refund today.
>
> Hmmmm... that gives me an idea... what if you could define a SQL statement
> to get the value of the current month's totals instead of importing the
> data? Like maybe at the end of the month, Optigold builds the monthly
> totals dynamically with SQL calls?
>
> That would be kind of cool I think.
>
> - Shawn
>
> -------------------------------
> Shawn D. Hogan
> President, Digital Point Solutions
> http://www.digitalpoint.com
> (858) 452-3696
>
>
> ---------------------------------------------------
> To subscribe, unsubscribe or to search list archive
> please visit http://www.optigold.com/lists/isp.html
> ---------------------------------------------------
>
---------------------------------------------------
To subscribe, unsubscribe or to search list archive
please visit http://www.optigold.com/lists/isp.html
---------------------------------------------------
Messages In This Thread:
Return to Digital Point Solutions' Home Page