Hi Arthur,
The file you supplied is almost perfect, but there are two small things.
1.) The Duration field seems to be putting the Duration_S value into the month spot in the Duration field rather than in the seconds or minutes. (Duration_S is correct).
2.) The Direction field is always showing Out.
I have attached an example export from the database. Rows without a 1 in front of the value in the DIALED_PHONE column are incoming calls. Rows with the 1 in front are outgoing calls.
3.) Randomly I receive either one or both of the following errors:
05/08/09 13:14:57 Comdial FX. Item: RING. Error occurred while converting date/time string value "0" with the template "" (Invalid argument to date encode)
05/08/09 13:14:57 Comdial FX. Item: CALL_DURATION. Error occurred while converting date/time string value "780" with the template "" (On format: D/YYYY H:MM:SS AMPM string: 0)
Thank you for all your help.
Jason