Search Again: Re: Usage Import Question From: Brendan McAlpine Date: Friday, October 11, 2002 Time: 10:39:58 am The problem is the numbers are in hours format, like so: 106.233567 So how would I get that figure into an hours:minutes:seconds number? I'm sure it can be done with a script, but before I start coding that together I wanted to see if there were any other options. Brendan On Friday, October 11, 2002, at 01:19 PM, William Elliott wrote: > At 12:30 PM -0400 10/11/02, Brendan McAlpine wrote: >> I have a question regarding the format of the usage import file..... >> >> My file just contains the username and usage in hours (CSV of >> course). I have a colon after the hours number, but none between >> minutes and seconds. Is this going to cause a problem? Or will Opti >> understand that the totals are in hours? >> >> I don't want to have to go through thousands of usage records adding >> the colons between minutes and seconds if I don't have to. > > BBedit and grep search and replace are your friends. ;-) > > -- ____________________________________________________________ > Joseph D'Andrea ~ http://www.west21.com/ ~ JoeDan@West21.com > WEST21.com Internet services for the 21st Century > webhosting ~ co-location ~ wireless access > WebCat and MGI database programming > ____________________________________________________________ > > --------------------------------------------------- > 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: Usage Import Question by Brendan McAlpine on Oct 11, 2002 at 9:31:07 am Re: Usage Import Question by William Elliott on Oct 11, 2002 at 10:22:00 am Re: Usage Import Question by Brendan McAlpine on Oct 11, 2002 at 10:39:58 am Re: Usage Import Question by Shawn Hogan on Oct 11, 2002 at 10:57:14 am Usage Import Question by Brendan McAlpine on Jun 10, 2003 at 12:38:07 pm Re: Usage Import Question by Shawn Hogan on Jun 10, 2003 at 10:35:44 pm Re: Usage Import Question by Brendan McAlpine on Jun 11, 2003 at 8:11:55 am Re: Usage Import Question by Shawn Hogan on Jun 11, 2003 at 9:42:43 am Re: Usage Import Question by Brendan McAlpine on Jun 11, 2003 at 9:46:19 am