Is there a way of setting the exact time a call was answered as variable?

[ghurty]

Is there a way of setting the exact time a call was answered as variable? That way it can be used when writing to a database as a unique ID number?


Thanks

 

[jroper]

The time a call was answered would not be guaranteed to be unique.

Asterisk assigns the global variable UNIQUEID to each channel, which is recorded in the CDR, I would suggest using that.

Other useful global channel variables are context, priority, exten, and channel.

Joe

 

[ghurty]

Thank you.

Based on what I am reading here:
http://readlist.com/lists/lists.digium.com/asterisk-users/11/57788.html

It might not be the best for me to use UNIQUEID as a unique Id number.

Any suggestions of a better way for me to set a unique ID number that will be written to a database for everything that is done on a particular call?

Thanks

 

[jroper]

Hi

They offer some suggestions in that post. The issue, as they explained, is that the uniqueid is based on the channel, so when the channel changes, so does the unique ID, this also explains why the CDR in Asterisk are a bit of a mess!

It would depend on your application as to what you need to do - e.g. your unique key could be a serial number incremented by 1.

E.g. create record with key first, then write to the record previously created.

Joe

 

[ghurty]

What I am trying to do is write a basic app that will allow the following:

There is a charity organization in town that gives supplies to families in need.

Until now, after a volunteer would provide some supplies, they would have to go onto a computer a log it in (for inventory and record purposes).

So the set up would be as follows:
Volunteer calls in, gets prompted for ID and PIN code.
Once authenticated.
They will type in the family ID#.
Then they will type in the Item ID# that they provided, and quantity. It will then give them the option of entering additional items.

For record purposis, I am trying to have every entery done in one call logged and linked together. So that is why I need to have a unique ID #.

While I am on this subject, I know it is possible to pass values to a php script (which is what I am planning on doing) but is it possible to receive values back from a php script? I am thinking of using that for the authentication set up.

Thank You

 

[ghurty]

Here is what I coded so far.
I am trying to figure out how how to do the userID and PIN part.

Also, is it better for me to be using php files (like I am trying to do.) or better to use ODBC connect module that comes with PiaF?

Any other comments about my code?

Reworking code

Thanks

 

[jroper]

Hi

You can address a MySQL database directly in the asterisk dial plan, without using ODBC.

So I would have a series of tables, such as user account, ID tables etc, and address the tables directly.

See here for the syntax

http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL

Personally, I use Apstel for this kind of stuff, it makes orting out the syntax easier.

Joe

 

[ghurty]

Thank you. I will try to rewrite it.

Thakns