Search results for query: *

Thanks Jay, I have looked at that KB before when I was verifying the syntax of the original query. The query itself works fine, I've tested it on another SQL server we have (DR replica) with the same data & XLS file and it runs no problem, it also runs fine on the LIVE server we have.... up...

I'm having an issue with using the OpenRowset function in T-SQL to read Excel workbooks. I use the query in the following format: SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Temp\file.xls;HDR=No;IMEX=1', 'SELECT * FROM [Sheet1$]') Initially the query works fine...

Does anyone know much about MiXML development? It seems that it is available as an application server that acts as a broker between workstation HTTP messages converting the requests to/from XML from the 3300. But I also read that there is a MiXML API that I would assume could be access...

Thanks for all the options, I particularly like the sound of the YA-Lite solution - I'll have a play around and see what works best. Good point with documenting the SYS SP, thankfully we don't have many at the moment but it's still worth keeping a list with comments & owners etc. Happy New...

Thanks for the suggestion. I have around 30 extns to divert, is there any way of issuing an equivalent to the **2 from the Maintenance Command window? (that way I could copy/paste the commands rather than have to key them each time – lazy I’ll admit but we’re a small team so any time saving is...

I have a requirement to divert a set of internal extensions to an individual number (xmas party time!). I do not have physical access to the devices but I can reprogram using the 3300 system console. My current thinking is to export the current Call Rerouting Assignment form, edit the First...

Hmm, I'm being told that with an ISDN30 only 1 CLI outside of the DID range can be displayed and it would be fixed. If I want to show multiple CLIs outside of the range then I would require multiple ISDN30 presentations with a minimum of 8 channels on each! They didn't know anything about...

I've been trying to talk to BT about it but not getting very far :-( So I would need to ask BT to mask one of the numbers in the existing DID range that I know I can use to the number I want to display? I can't help but think if I knew who to talk to at BT and what to ask them they could add...

I hope I'm not hijacking the thread but I think my query is on topic... I have been playing with CPN Substitution & DID Ranges for CPN Substitution and I have managed to get it to work using a test extension displaying a different CLI. We have 60 channels over 2 ISDN30 PRI links, there is a...

I may be entirely off the mark but it sounds like a network storm, perhaps you have a faulty NIC or a scheduled job that transfers a large amount of data over the network? I would suggest you do implement a separate VLAN for your voice traffic, if only to separate the voice from the data...

It sounds like you've got some other devices using up your available bandwidth. Are the phones & the MXe on the same LAN segment? (what's the network specs? 10Mb/100Mb etc) Do the same phones drop at regular intervals?

Are there any errors shown in the Maintenance/Software logs? We have HP network hardware and 5330 phones, after a while I found that phones would just crash and reboot, sometimes during calls or when the device was ringing, unfortunately our solution involved returning the devices to Mitel or...

Many thanks slapin, your method DHCP reservations would be a sensible way to go - the problem is that we have the multiple admins working different parts of the network/telephony systems and we also have 4 pbx's clustered over 2 sites with different dhcp ranges on each. We use device MACs for...

Do you have any sort of automated process to cross-check the agent details on the recorder against the live Mitel ones, or does it update those automatically? We're using a package called Audiolog by Verint (formerly Mercom), the control db is in MS Access and the call records are in SQL. Our...

Apologies for my narrow minded UK-only view -> P45 is a code for Details of employee leaving work in UK and Irish taxation. :-)

Sorry, I didn't mean to suggest that I was expecting an SQL source - the other sources of data that I want to programatically compare the Mitel data with are in Access & SQL. I may well take the data from the Mitel and import it into some temporary SQL tables to do data comparisons. Basically...

Thanks for the suggestion. I did wonder about using SSL/Telnet but I was warned by one of our Mitel support engineers that there was a bug in the Mitel OS that left a thread open when an sx2000 telnet session was closed, these threads built after repeated connections and would eventually cause...

Hi, does anyone know if it's possible to automatically export the current DCHP list from a 3300? At the moment I'm manually logging into the ESM and using the Export button to dump the "All IP Telephones" page to csv. Ideally I'd like to be able to query the 3300 directly at run-time if there...