Search Again: Re: import usaage From: David Date: Wednesday, December 10, 2003 Time: 5:55:30 pm Not sure I like his aswer as it is not automatic but shawn's ersponse to my similiar questions is found here http://www.digitalpoint.com/lists/73982.html David -----Original Message----- From: isp-list@optigold.com [mailto:isp-list@optigold.com]On Behalf Of Patti Jones Sent: Wednesday, December 10, 2003 6:06 PM To: Optigold Subject: [Optigold ISP] import usaage I am importing my usage from the sql file and I notice in OG when I do the import it is adding the import to what is already there. In other words, Day 1 2 hours Day 2 3 hours Total of 5 hours OG will import 2 hours on the first day then 5 hours on the 2nd but it shows a total of 7 hours not 5. Here is the import script I am using. Is there something I need to trigger before the import each morning. Deleting all the month's usage in OG and then importing works but that seems to be such a pain. SELECT UserName,count(UserName),sum(AcctSessionTime),sum((((AcctInputOctets+AcctOut putOctets)/1024)/1024)) FROM radacct WHERE AcctStopTime >= '<Y1>-<M1>-<D1>' AND AcctStopTime <= '<Y2>-<M2>-<D2>' GROUP BY UserName; Patti --------------------------------------------------- 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: import usaage by Patti Jones on Dec 10, 2003 at 5:00:12 pm Re: import usaage by David on Dec 10, 2003 at 5:55:30 pm Re: import usaage by Administrator on Dec 11, 2003 at 3:16:10 am Re: import usaage by Patti Jones on Dec 11, 2003 at 4:26:59 am Re: import usaage by David on Dec 11, 2003 at 6:56:46 am Re: import usaage by Administrator on Dec 11, 2003 at 11:28:07 am Re: import usaage by Administrator on Dec 11, 2003 at 11:39:46 am Re: import usaage by Patti Jones on Dec 11, 2003 at 11:50:55 am Re: import usaage by Shawn Hogan on Dec 11, 2003 at 12:33:34 pm Re: import usaage by Shawn Hogan on Dec 11, 2003 at 12:34:58 pm Re: import usaage by David on Dec 11, 2003 at 7:48:46 pm Re: import usaage by Shawn Hogan on Dec 12, 2003 at 12:20:10 pm Re: import usaage by Administrator on Dec 15, 2003 at 12:39:29 am Re: import usaage by Shawn Hogan on Dec 15, 2003 at 11:46:01 am Re: import usaage by Administrator on Dec 16, 2003 at 3:36:22 am Re: import usaage by Shawn Hogan on Dec 16, 2003 at 2:21:56 pm Re: import usaage by Administrator on Dec 17, 2003 at 12:57:54 am