Danbhalah

What is the extn of the file?

Eager Beaver

The file extension is .rcl.
An example of the HEX is: 01 20 1C 40 69 71 00 0B 35 09 00 79 00 01 00 00 00 20 05 C1 EE FF based on the apparent end of record marker being EE FF.
My problem is interpreting the data in terms of calling ref, called ref, start date/time, duration, and dialled digits.

Mikie

The record is not in HEX but BCD (Binary Coded Decimal). The call record is 22 bytes long and the info you require is split between multiple bytes.

I produced a couple of apps a number of years ago to translate each record from BCD into readable digits. No promises, but if I can find them then you can have them.

Just a point of interest, how was the raw CIL collected - Buffer Box ??

Eager Beaver

Yes, collected via buffer box and dumped to CD.

That would be great if you have an app of some sort to help.

Mikie

What are your timescales for this ?

Eager Beaver

I'm keen to get going on this task and so the sooner the better.

Mikie

It's just that if I can't find the source code for the VB apps (it's been a long time), I might knock up a script in Python to decode the RCL's for you.

I'm on long term sick at the moment following an accident and it would probably take me about a week to do the code for you from fresh.

Just an option for consideration.

Eager Beaver

Hey, anything you can do would help. I've not got the spec for the data and so can't knock up any code.
Not played with Python yet but it looks interesting. My aim is to load a db with the data in order to manipulate it so any standard field structure would be great. I really need to have broken the back of the task by the end of the month, and that includes extracting the data from the mountain of discs, converting, processing and research.
Sorry to hear about the accident, hope recovery is progressing well.

Danbhalah

This is what a community is all about, I am glad some one was able to help you out.