Extension number truncated during export to MS SQL.

Started by CliffEAF, June 27, 2024, 11:00:00 AM

Previous topic - Next topic

CliffEAF

I am currently trying out PBX data logger and it is almost perfect except for one small problem.

I have set up SMDR on an Inter-Tel Axxess and am capturing data via a serial port.
This system uses 5 digit extension numbers.
The extension numbers appear fine in the data logger application itself and also in the text log, so the extension numbers are being recorded correctly.

When I set up the data logger to export to MS SQL, the numbers that appear in the EXT field only have 4 digits, the last digit is left off. The binding of the EXT field is set up correctly and the SQL column should allow 10 characters.
What should I do to correctly export the 5 digit extension numbers to SQL ?.

Thank you.

Arthur Grasin

Please, send your log file example to support _at_ aggsoft.com and I'll verify it.
If you like my work, please take a few seconds and add feedback about our site or our software [here]