Search results for query: *

When you say this: If you go thru Options on the menu of the Server software you will see the 'Download Historical data ' option on the drop down. Will that be on the BCMS computer or will that be on the phone switch? Thanks again. Jason

I have this in my table: fields: id, create_date, end_date sample data: 12345, 9/12/08, 9/22/08 I need to turn that in to this: ID Date 12345 9/12/08 12345 9/13/08 12345 9/14/08 12345 9/15/08 12345 9/16/08 12345 9/17/08 12345 9/18/08 12345 9/19/08 12345...

I hear them talking about the BCMS, is that the same thing, very sorry for my ignorance.

Sorry I am not sure. I was just handed the histdb.mdb and told to write reports. I will ask the users if they know how to get into the CMS, any tips that you can give to help me send them in the correct direction?

Thanks for the replies. I am not sure why my data would stop collecting, do you know of a way to "rerun" past data that was missed in the database? I have a lot of 1/2 day reports right now.

Actually I think I just found this on Avaya's site. I understand the problem, but does anyone know if this error will stop the DB from collecting data? I guess that is my real question here.

Every now and then the histbd.mdb will stop gathering data. Not sure why, but does anyone know of a way to "rerun" a data dump that was lost. I am betting there is not a way but it is worth a try. :)

I just took over this system and am having a few reporting problems. I get this error every now and then. Server: BCMSVuServer 1107 list bcms agent day : Column data in BCMS has overflowed switch display capacity. Although I can't prove this yet it seems that when this error comes up the DB...

Does anyone have a macro that will insert a $ in each formula all the places there is a cell reference? so that I can move the folmulas without making the cell references change? Make sense?

OK I figured out my problem. I used Activecell.formula rather than just active cell. That must mean to take the formula value of the cell rather than evaluating it. Thanks to everyone for helping. jamminjaymeyer

OK that makes sense. When I try what you mentioned above it still evaluates the active cell formula into a numeric value and puts that number in the formula in place of the full formula that I need. The problem I am having is rather than evaluating the formula that I am trying to place back...

Thank you so much. You are exactly correct as to my procedure. Now it seems to be evaluating the Right(ActiveCell, Len(ActiveCell) - 1) into a value rather than keeping the actual "formula text. Is there any way to not have it evaluate the text in to a number?

I have a number of cells that now require an if statement to be included at the begining. The macro code that I am trying to use is: ActiveCell.FormulaR1C1 = "=if(N7=0,0," & Right(ActiveCell.FormulaR1C1, Len(ActiveCell.FormulaR1C1) - 1) & ")" All of it work fine except the N7 reference. When I...

Thanks for the reply McGruff753. I have the manual that explains the different values like you inserted above, that book helps a lot but I am looking more for a procedure that will make the record flag as such. For instance if the agent does a #8 transfer to a specific applicaation and the...

Does anyone have a good listing of what calls get flagged as what in the call detail table? I am espically concerned about the cflag1 field and the call type field. I have the tables and fields document, that lists out the possible values but does not really explain what each of them are. Any...

Is it possible to delete a file on the harddrive with a SQL command?

I have a mapped drive on my SQL server that I would like to create a DB on and I can not get it to work. Is there a trick to this? It says my drive is not supported for database files "network drive not supported for database files" Any Ideas?

Well it works now but I am not sure why it started again. I think it really came down to not having enough disk space we added some more disk space and it seemed to help. It was a pretty big DB and it needed a lot of free space to back up, way more free space than the actual size of the DB...

Hello, I have a server that sends e-mail to another department's SMTP relay server, but their server is down a lot and not reliable. Is it possible, in IIS, to set up a cache server of some kind that would hold the e-mails and forward them on to the SMTP relay server when it becomes available...

Hello, I am pretty sure that the DTS packages are stored in the MSDB database on the server. Does this mean that if I am backing up the MSDB database are my packages being backed up also?