<br><div class="gmail_quote">On Mon, Dec 27, 2010 at 3:58 PM, Bryant Zimmerman <span dir="ltr"><<a href="mailto:BryantZ@zktech.com">BryantZ@zktech.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<span style="font-family: Arial,Helvetica,sans-serif; font-size: 10pt;">Ok I figured out how to store the userfield. It only worked when I did a Set(CHANNEL(userfield)=value) I was doing a single underscore and it was not working.<br>
</span></blockquote><div><br>Yes, the CEL code is written to store away only channel fields (not CDR fields). Userfield is stored on the channel directly (ignoring CDR stuff).<br><br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<span style="font-family: Arial,Helvetica,sans-serif; font-size: 10pt;">
<br>
So now this brings me to my other two questions with CEL.<br>
<br>
1. Is there some way to store the extradata info in the odbc_database. I can get userdeftype but I can't store the data supplied with it in a standalone field? This seems inconsistent at best as I can store it in a field in the cel-custom csv files. Am I just missing the correct field name. I can not find one in the documentation?<br>
</span></blockquote><div><br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><span style="font-family: Arial,Helvetica,sans-serif; font-size: 10pt;">
2. Is there some way to store custom channel variables to the CEL record in either the cel-custom csv or the database. What I am looking to do is to set a custom channel variable and have it stored when a CEL event is logged in either the database or csv. Is it currently possible to do?<br>
</span></blockquote><div><br><br><div>When I originally wrote the CEL stuff, I knew people would want something like this. But the first implementor didn't need this.<br>
I remember playing with code to store channel vars beginning with CEL_ along with the event;<br>
whether it was a mental exercise, or whether I threw in some comments that were later removed, I<br>
cannot tell. I just looked at the current code, and I don't see anything to do this sort of thing.<br>
At any rate, it wouldn't be just this simple. We'd have to have some API funcs to fetch those vars from the<br>
event record. Some machinery in the backends to allow columns with such names to be matched against<br>
those vars, etc. And, I'd have to review the AST_EVENT stuff to see it could handle multiple prop decls.<br>I'd bet that it could, and if not, we could just put them all in one record.<br><br>If this kind of thing isn't handled in the underlying layer of the CEL stuff, then the cool stuff in the odbc<br>
layer can't take advantage of it.<br>
<br>
</div>murf<br></div></div><div id="WISESTAMP_SIG_6535"><span style="font-size: 13.3px; font-family: Verdana,Arial,Helvetica,sans-serif;"><img src="http://s.wisestamp.com/pixel.png?p=mozilla&v=2.0.4&t=1293556529503&u=5848228&e=9898" height="1" width="1"></span></div>