Search Again: Importing Historical usage From: Justin Ainsworth Date: Thursday, January 2, 2003 Time: 6:14:38 pm Shawn, Is there an easy way to import historical usage. Let's say all the way back to 1997. I have all of the data available, and in the correct format. I don't want to spend all day doing it one month, and one file at a time. I attempted to do a import with the following field map: User -> Login Time Online -> Time Online Connections -> Sessions Avg. Time -> Secondary Time Online Bandwidth -> Bandwidth Used Disk Usage -> Disk Space Used Month -> gMonth Date (01) -> gDay Number Year -> gYear When I did the import, all of the data went in correctly with each of them in there own record. But the displayed month always shows January 1997. Any suggestions? .~. /v\ -- // \\ JA /( )\ ^`~`^ L I N U X [-----------------------------------------------------------] Justin Ainsworth Systems Administrator PHONE: (530) 879-5660x108 Sunset Net LLC FAX: (530) 879-5676 1915 Mangrove Ave WEB: http://www.sunset.net Chico, CA 95926 EMAIL: jda@sunset.net [-----------------------------------------------------------] --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: Importing Historical usage by Justin Ainsworth on Jan 2, 2003 at 6:14:38 pm Re: Importing Historical usage by Shawn Hogan on Jan 2, 2003 at 6:23:23 pm