Search Again: Re: Importing Usage Logs From: Shawn Hogan Date: Monday, July 20, 1998 Time: 11:31:48 am Robert Hough wrote: >Got a quick question here... I just imported a usage file that wasn't >accurate, so I imported the correct one. However, now I have to entries for >June on each users record. Is there a way to mass remove one, or a way to >prevent it from posting the same month twice, like only use the most >current import? So you have 2 June records for each customer then or something? Well, there isn't a method for a "mass usage" purge... It's assumed that once it's imported and verified as "good data" that it doesn't need to be mass deleted. Plus, a mass-purge routine wouldn't really work that well in this case, because you have two records that are for the same time period. If you told Optigold ISP to purge all June usage records, it would wipe both sets. Anyway, you can do one of two things... Since I beleive June would be your first month of usage imported, you can replace your Time_.USR with an empty table (from the trial installer), and reimport the good set. Or... You can email me (privately of course) your Time_.USR file and I'll purge the first set for you by hand. - Shawn ------------------------------- Shawn D. Hogan President, Data Point Solutions http://www.data-point.com (619) 452-3696 ICQ: 8319647

Messages In This Thread: Importing Usage Logs by Robert Hough on Jul 20, 1998 at 10:52:19 am Re: Importing Usage Logs by Shawn Hogan on Jul 20, 1998 at 11:31:48 am