[joenational]

I have an asterisk master file that shows what calls were made and what extensions made the calls etc... it is a .csv file at this point. I need to make a database out of it somehow so that people can look up certain phone numbers that were called or speific extensions.

Basically from this master file I need something so that managers can seach it for it exactly what they want. I am trying to figure out how to do this and was suggested by some that Access might be a good way. I am pretty strong in MS access so I can import the csv file into a table but how do I clean it up or is there another tool that can be used. Of course the asterisk is running off a Linux box so if there is a tool to bridge the linux file to an MS file or something like that.

Hope that makes sense.

Thanks guys,

[fenderfreek]

If it were me doing it, I'd use a php script to load it into a MySQL database(the scripts are everywhere online). From there, you could have a php-driven search page to get what you want. If you needed it updated daily, you could just run the commands against MySQL with a shell script.

That's just one way though. I'm not very familiar with M$ products, so I can't tell you about using Access with it.

[joenational]

Hmm... well if there was another way then I would do it that way, I looked at PHP not that long ago but not familar with Mysql. Where are these scripts that you speak of though. I would like to take a look at them.

Thanks,

[fenderfreek]

If you Google for "insert csv into mysql" there's several script/code banks that have snippets to do just that. As for using MySQL, it's not too hard. There's tons of great books that will get you as far as you need to for this. The only significant thing that prior experience might lend is how to properly secure your code. If security is less of an issue(all of this is used on a small, private network) then I wouldn't worry quite so much about it.