Search Again: Importing usage From: Randy Ide Date: Saturday, October 5, 2002 Time: 11:27:38 am We have a need to indicate what month usage occurred regardless of when the file is imported and to automate the process. The process that generates our usage on the radius is not instantly up to date at exactly midnight and we need to account for usage in the proper month without being a day or two off. Also we want usage to be updated in opti at least daily. The auto task usage imports with sql hooks assumes usage is either the current month or previous month which does not work. We have been told that opti does not pay attention to the time stamp in the import file when using auto task. We are open to importing the usage records directly into the usage table in opti if that will work, but we would need an example of how to do it and all the fields in the usage table. Randy Ide ezBiztoNet --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: Importing Usage by Alex Kain on Jan 5, 2000 at 11:35:42 pm Re: Importing Usage by Shawn Hogan on Jan 5, 2000 at 11:56:36 pm Re: Importing Usage by Alex Kain on Jan 6, 2000 at 4:26:08 am Re: Importing Usage by Shawn Hogan on Jan 6, 2000 at 12:14:18 pm Re: Importing Usage by Alex Kain on Jan 6, 2000 at 1:48:57 pm Re: Importing Usage by Shawn Hogan on Jan 6, 2000 at 3:11:21 pm importing usage by Harpreet Singh Giani on Mar 25, 2001 at 6:23:50 pm Importing Usage by Tony on Jun 28, 2001 at 8:03:41 am Re: Importing Usage by Shawn Hogan on Jun 28, 2001 at 1:18:13 pm Re: Importing Usage by Tony on Jun 28, 2001 at 4:42:00 pm importing usage by Teresa Walters on Sep 7, 2001 at 10:53:30 am Re: importing usage by Shawn Hogan on Sep 7, 2001 at 12:46:38 pm importing usage by Kayode Beyioku on Oct 19, 2001 at 4:14:03 am Re: importing usage by Shawn Hogan on Oct 19, 2001 at 12:07:50 pm Re: importing usage by Kayode Beyioku on Oct 22, 2001 at 2:34:59 pm Re: importing usage by Shawn Hogan on Oct 22, 2001 at 2:39:38 pm Importing Usage by Jed Record on Nov 28, 2001 at 12:54:22 pm Re: Importing Usage by Jeremy Anthony Kinsey on Nov 28, 2001 at 12:59:22 pm Re: Importing Usage by Shawn Hogan on Nov 28, 2001 at 2:52:06 pm Re: Importing Usage by Jed Record on Dec 6, 2001 at 6:11:42 am Re: Importing Usage by Shawn Hogan on Dec 6, 2001 at 10:52:27 am Re: Importing Usage by Jed Record on Dec 17, 2001 at 6:51:38 am Re: Importing Usage by Patti Jones on Dec 17, 2001 at 7:10:06 am Re: Importing Usage by Shawn Hogan on Dec 17, 2001 at 12:33:29 pm Re: Importing Usage by Jed Record on Dec 18, 2001 at 6:11:43 am Re: Importing Usage by Shawn Hogan on Dec 18, 2001 at 10:43:35 am Re: Importing Usage by Jed Record on Dec 18, 2001 at 11:01:43 am Re: Importing Usage by Shawn Hogan on Dec 18, 2001 at 1:31:16 pm Importing Usage by Marian McCurdy on May 1, 2002 at 3:00:51 pm Re: Importing Usage by Shawn Hogan on May 1, 2002 at 4:34:41 pm Importing Usage by Scott Antonivich on May 2, 2002 at 10:00:25 am Re: Importing Usage by Shawn Hogan on May 2, 2002 at 11:03:52 am Importing usage by Randy Ide on Oct 5, 2002 at 11:27:38 am Importing Usage by David on Nov 25, 2003 at 8:33:41 pm Re: Importing Usage by super milk on Nov 26, 2003 at 4:14:22 am Re: Importing Usage by David on Nov 26, 2003 at 5:39:59 am Re: Importing Usage by Shawn Hogan on Nov 26, 2003 at 3:20:40 pm Re: Importing Usage by David on Nov 26, 2003 at 7:17:35 pm Re: Importing Usage by Lewis Watson on Nov 27, 2003 at 6:32:10 am Re: Importing Usage by Shawn Hogan on Nov 30, 2003 at 9:49:24 pm Re: Importing Usage by David on Dec 1, 2003 at 9:29:47 am Re: Importing Usage by Shawn Hogan on Dec 1, 2003 at 2:45:12 pm