KS-Soft

I know I can reset the statistics for test from the web interface which seems to use java script. I was wondering if there is a way to automat this through a macro in excel. I have to supply a way for the Director of IT to get monthly Metrics of all test performed. SO what I did was write some sql q...

What are some specs about your system you are running HM on CPU ? Mem? HM Ver? OS Ver? .NET Framework Ver? Other third party software or development software. Reason I ask is because this error is not caused by HM in my opion. Even though HM is the reported program that is only because they system i...

High all I am using the folloiwing sql to update the results of my tests to a mysql db. I wish to only update if the test exist all ready. If it doesn't exist then insert. (As you will see in my statement.) Anyways it does not update if the test exist all ready. It is always inserting. NSERT INTO me...

I tried and get some error about ; expected at end of statement. I tried to add the semicolon but still get the same error.

Thank YOu
You saved me alot of work.

I am guessing at this but can someone take a look at this and tell me whats wrong. What I am trying to do is with ODBC logging to a access database I want to just update the record from a test instead of inserting a new record. Even better would be to update the record and if not exist then insert r...

Ok I figured this out by mistake. In my database the colum name was Date. While trying to figure this out by recreating a new table I mispelled the Date colum to datw and the query worked. When I fixed the mispelling to Date it didn't work again. So for some reason the query will not execute if the ...

Also you shoud wrap %DateTime% variable in ', e.g: Insert into hm (TestName, Folder, Date, Alive, Dead, Average) VALUES ('%TestName%', '%Folder%','%DateTime%',left('%AliveRatio%',instr('%AliveRatio%',' %')-1) ,left('%DeadRatio%',instr('%DeadRatio%',' %')-1) ,'%AverageReply%') That was a typo in my ...

Ok this is probably not going to be my last one but anyways I am trying to have the test date inserted into my database theough odbc and keep getting a syntax error Insert into hm (TestName, Folder, Date, Alive, Dead, Average) VALUES ('%TestName%', '%Folder%',%Date%,left('%AliveRatio%',instr('%Alive...

Thank You
Maybe not the best but the working solution
It works for what I need it for.

I tried it in the odbc string in advanced log settings
Undefined function 'Replace' in expression

maybe it is my setup but the replace function does not work with a odbc connection.

Thank You
I will try today.

I am logginf to a odbc msaccess database. I want to strip the % off the end of the replies for Alive and Dead because when I try to run a query to give me the average of a certain test I get a error that says mismatched data. I have been doing this through a query in access but over time the log has...

I am having a simular issue where I thought it was a network problem also but have found it it is not. MY problem is if I have \\servername in the test method and a test errors by "unable to connect to specified machine" I go in and put the ip address and the test will work. Or vise versa....