Search Again: Re: Export customer From: Tony D. Koehn Date: Thursday, October 3, 2002 Time: 9:01:46 pm Olivier, We use the Authentication Export ourself and do it twice a day. We use a custom format. After Optigold exports this we run a batch file that executes a seperate program that we wrote that does several things. 1. It creates a Radius File ready for the radius servers. 2. It checks for special characters like Quotes and <CR><LF> that are in logins, passwords, Firstnames, Lastnames and company names. 3. Generates a log file containing any problems found that we can email to someone to fix. 4. Generates a Clean users list to be used by other programs. We then use the cleaned users list and process our daily Lock Box Bank deposit files with another program that creates a file containing daily payments for importing. We choose this method becuase we use the More Service1-10 fields for various Radius Attributes such as total duplicate logons, time online, idletimeouts, etc... we also use the Balance Due and various other fields we can export. This way we can make decisions based on fields we want for what ever purpose we want such as duplicate logons. Normally only one user can logon with one username but we can modify this and have it reflect in the radius file by editing one of the MoreServices fields. Tony ----- Original Message ----- From: "olivier" <opti@dataspain.com> To: "Optigold ISP List" <isp-list@optigold.com> Sent: Thursday, October 03, 2002 7:05 PM Subject: [Optigold ISP] Export customer > Hello, > > We need to export customers information on a daily basis , but each time we > have to reselect the file and the order of those file in the export panel , > how can we memorise witch file and the order ? > > Thank you in advance > > --------------------------------------------------- > 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: Export customer by Oliver de Barrin on Oct 3, 2002 at 5:08:20 pm Re: Export customer by Tony D. Koehn on Oct 3, 2002 at 9:01:46 pm Re: Export customer by Shawn Hogan on Oct 4, 2002 at 5:32:20 am Export customer by Oliver de Barrin on Oct 4, 2002 at 6:29:35 am Re: Export customer by S.M. Maruf Hasan on Oct 4, 2002 at 7:41:34 am Re: Export customer by Shawn Hogan on Oct 4, 2002 at 11:28:50 am Re: Export customer by Shawn Hogan on Oct 4, 2002 at 11:33:37 am