Re: [hylafax-users] Modem Initialization Question

["Greg Youngers" <Greg.Youngers@xxxxxxxxxxxxxxxx>]

Hello Bodo,

The Cisco CDR SQL database contains a number of records.  It is
currently configured to purge records older than 5 days because the
information is not needed.  Typically there are between 3000 and 6000
records at any time.

The records are sorted in descending order by dateTimeConnect (this
gives last completed call since failed calls have dateTimeConnect = 0) -
and the top record is selected and then the original dialed number of
that call is returned by the query.

There are time-stamp fields included in the records, such as:
dateTimeConnect (mentioned above)
dateTimeDisconnect

Others may exist but I'd have to check the field names directly to be
sure.  Not all fields are populated by our version of CallManager CDR.

The ugly part of the time fields is that they are "written in Universal
Coordinated Time (UTC), which is the number of seconds since January 1,
1970 GMT, or simply Epoch time."


Thanks for any assistance.

Greg



-----Original Message-----
From: hylafax-users-bounce@xxxxxxxxxxx
[mailto:hylafax-users-bounce@xxxxxxxxxxx] On Behalf Of Bodo Meissner
Sent: Wednesday, July 14, 2010 2:45 PM
To: hylafax-users@xxxxxxxxxxx
Subject: Re: [hylafax-users] Modem Initialization Question

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Am 13.07.2010 17:23, schrieb Greg Youngers:

> 2) Every minute CallManager updates SQL db with completed call info
> including the dialed number
> 3) Sixty-five seconds after a successful fax call ends, FaxDispatch
> queries SQL for the last call to the modem extension which that fax
was
> received on - resulting in the original dialed number.

Hello Greg,

what exactly do you have in the SQL DB?
Only one call info record (from the last call) or more than one? Do you
have a time field?


Bodo
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEARECAAYFAkw+E8sACgkQnMz9fgzDSqcerwCfRS1CeNFGtrVtJZgkYWNQzJgE
7mgAoJViI5T128tWA0gZOoOXQa/BZ5Q7
=sos9
-----END PGP SIGNATURE-----


____________________ HylaFAX(tm) Users Mailing List
_______________________
  To subscribe/unsubscribe, click
http://lists.hylafax.org/cgi-bin/lsg2.cgi
 On UNIX: mail -s unsubscribe hylafax-users-request@xxxxxxxxxxx <
/dev/null
  *To learn about commercial HylaFAX(tm) support, mail sales@xxxxxxxxx*



____________________ HylaFAX(tm) Users Mailing List _______________________
  To subscribe/unsubscribe, click http://lists.hylafax.org/cgi-bin/lsg2.cgi
 On UNIX: mail -s unsubscribe hylafax-users-request@xxxxxxxxxxx < /dev/null
  *To learn about commercial HylaFAX(tm) support, mail sales@xxxxxxxxx*