Welcome, Guest
You have to register before you can post on our site.

Username
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 1,781
» Latest member: mattheinrich
» Forum threads: 10,491
» Forum posts: 70,572

Full Statistics

Online Users
There are currently 102 online users.
» 3 Member(s) | 99 Guest(s)
Dean Roddey, IVB, Shaky

Latest Threads
Problem with Jetstream Dr...
Forum: CQC Support
Last Post: Dean Roddey
14 minutes ago
» Replies: 12
» Views: 74
ISY, need Plan B
Forum: Installation/Configuration
Last Post: IVB
16 minutes ago
» Replies: 2
» Views: 5
CQC Voice with Acoustic M...
Forum: CQC Support
Last Post: Dean Roddey
3 hours ago
» Replies: 1
» Views: 11
Generic Irrigation Schedu...
Forum: Driver Development
Last Post: Dean Roddey
Yesterday, 09:24 PM
» Replies: 540
» Views: 106,926
A challenge for the brain...
Forum: General Automation
Last Post: Dean Roddey
Yesterday, 09:21 PM
» Replies: 18
» Views: 1,019
Official 5.3 Beta Discuss...
Forum: Beta Discussions
Last Post: Dean Roddey
Yesterday, 08:47 PM
» Replies: 262
» Views: 15,161
CQC maxing CPU utiiiizati...
Forum: CQC Support
Last Post: Dean Roddey
Yesterday, 05:30 PM
» Replies: 23
» Views: 182
Cover Art Browser
Forum: CQC Support
Last Post: Dean Roddey
Yesterday, 12:25 PM
» Replies: 5
» Views: 45
A proposal for implementi...
Forum: CQC Support
Last Post: znelbok
02-22-2018, 08:18 PM
» Replies: 7
» Views: 114
Rain 8 with CQC?
Forum: Installation/Configuration
Last Post: znelbok
02-22-2018, 08:10 PM
» Replies: 27
» Views: 1,490

 
  Problem with Jetstream Driver
Posted by: RichardU - 02-16-2018, 07:21 AM - Forum: CQC Support - Replies (12)

I've been using the Jetstream driver for almost ten years. It works perfectly for all my devices, except ...

The last three devices I've enrolled give me an error: 
    Timed out waiting for DEV reply
    The value written ... was rejected by the driver. Reason = ValueRejected

Interestingly, CQC still controls the devices. But it takes longer to do it, and throws the error. 

I've done every test I can imagine. When you enroll a device, Jetstream automatically assigns an ID. IDs that don't work are 51, 52, 53. I even took a working device and re-enrolled it, which made it device 53. It now creates the error.

I can create new scenes with no problem. Of course, I am updating the config file and running reconfig on the driver as needed.

Could there be any reason why devices over ID=50 are not working properly. Or any other ideas?

Thanks, Richard

Print this item

  CQC maxing CPU utiiiization
Posted by: MikeA - 02-15-2018, 02:46 PM - Forum: CQC Support - Replies (23)

Just upgraded from Windows 7 to Windows 10 on one of my client machines which is primarily used
as a media player, using MyMovies/PowerDVD17.  Running CQC 4.8.3.
CQC is maxing out the processor to 99% and making the whole machine sluggish.  If I stop the CQC
processes the computer starts behaving normally.  I am running the tray monitor.  For some reason,
maybe it has always done this, but I don't think so, there is also an instance of the CQC Server process
in addition to the Client and Tray Monitor processes running.
Any ideas on what I can try to get things working normally?
I never had any problems like this on Win 7.
My system was built in 2014, but seems to have enough horsepower without CQC running to do
everything else, including running PowerDVD 17.
Thanks in advance.
Mike

Print this item

  Onkyo receiver volume issue
Posted by: dlmorgan999 - 02-15-2018, 08:27 AM - Forum: CQC Support - Replies (11)

Up until yesterday, I was using an Onkyo TX-SR707.  Although not on the list in the driver, selecting the TX-SR706 worked just fine.

Yesterday I installed a new receiver (one that supports 4K, which I needed after I upgraded to a 4K TV - these things always seem to snowball  Tongue ).  I figured it would be a drop-in upgrade, as the new receiver is a TX-NR757 which is very similar to mine but a newer vintage.

Power, mute, source selection, and volume control all work  The issue is that the driver is displaying values for volume level that are half of what they should be.  So for example, if the receiver is set to 50, CQC is showing 100.  If I raise the volume further using the remote control, CQC stays at 100.

I took a brief look at the driver source code but didn't see anything obvious.  Any suggestions or ideas?

Print this item

  Backup without Stopping Service
Posted by: RichardU - 02-13-2018, 12:49 PM - Forum: CQC Support - Replies (5)

I know I'm supposed to stop the server to backup, but that's hardly set and forget. What happens if I backup without stopping the server? How much grief will that cause me during an restore (if one is even possible)?

Thanks, Richard

Print this item

  Mozilla iOT - Project Things
Posted by: znelbok - 02-11-2018, 11:31 PM - Forum: General Automation - Replies (1)

Mozilla have just announced project Things.

in summary I believe its supposed to bring together devices that would not normally be "connected" under a single API.

It uses a RPi but appears to be able to use a PC as well.

https://iot.mozilla.org/

Published API as well - Maybe CQC could work with this......

Print this item

  How To: DataLogDB multiple columns in one query
Posted by: IVB - 02-11-2018, 07:34 PM - Forum: How-To - No Replies

Wasn't sure how to title it for non-techies, but I needed a way to simplify creating a multi-line chart with my data in DataLogDB.

I have multiple temp sensors all being logged via DataLogDb. Each of these show up as a different row (Timestamp, Field, Value), but in order to make graphing easy I need it in a single row. IE, Time of collection, temp 1, temp 2, temp 3, temp 4, etc.  The DataLogDB collects all data at the same time as i have identical intervals.

Fortunately I remembered enough from being a database dude back in the day that I knew how to do self joins. In my case I have 7 different temp sensors (actually more but this is what I have SQL'ed up so far).

Figured y'all might be interested in this, it's not super hard stuff but if you don't know SQL it would suck to write.

This performs phenomenally fast, so no runaway query issues. And now it'll be trivial to do a multi-line chart against it, as I can declare the first column as the label, and data series is in columns 2-8.

Quote:set nocount on;

select a.Timestamp, 
a.Value AS TempAmara, 
b.Value AS TempAtticEquip, 
c.Value AS TempAtticOuter, 
d.Value AS TempDen, 
e.Value AS TempDining, 
f.Value AS TempEntryKP, 
G.Value AS TempPantryKP

from CQC.dbo.DataLogValues A
inner join CQC.dbo.DataLogValues B
ON a.TimeStamp = b.TimeStamp
INNer join CQC.dbo.DataLogValues C
ON a.TimeStamp = C.TimeStamp
INNER join CQC.dbo.DataLogValues D 
ON a.TimeStamp = D.TimeStamp
INNER join CQC.dbo.DataLogValues E
ON a.TimeStamp = E.TimeStamp
INNER join CQC.dbo.DataLogValues F 
ON a.TimeStamp = F.TimeStamp
INNER join CQC.dbo.DataLogValues G
ON a.TimeStamp = G.TimeStamp

where a.Descriptor='Temp-Amara'
and b.Descriptor = 'Temp-AtticEquip'
and c.Descriptor = 'Temp-AtticOuter'
and d.Descriptor = 'Temp-Den'
and E.Descriptor = 'Temp-Dining'
and F.Descriptor = 'Temp-EntryKP'
and G.Descriptor = 'Temp-PantryKP'

when you call sqlcmd from a command line make sure you specify the column separator. IE, -s "," to parse the columsn right.

Print this item

  TrayMon: "Maximum collection node count exceeded"
Posted by: IVB - 02-11-2018, 07:07 PM - Forum: CQC Support - Replies (5)

Hey, I created a few .sql queries that i'm running via a .cmd file, having CQC kick them off via TrayMon. Getting a max collection node count exceeded error, although the query seems to run.

I dropped it to 1 query at a time, still having it. Check out the log file.



Attached Files
.zip   cqc-logsnap.zip (Size: 1.23 KB / Downloads: 2)
Print this item

  CAB collection sorting
Posted by: rbroders - 02-10-2018, 01:59 PM - Forum: CQC Support - Replies (3)

If I have a Movie Title, say "Captain America", I use the CQC Media Repository Manager to arrange the the "Collections in the Title Set" to be ordered:  "First Avenger", "The Winter Soldier", "Civil War".

However, when I drill into "Captain America" in the CAB viewer I get the titles in "The Winter Soldier", "The First Avenger", "Civil War".

All of my collections have this problem.  The titles seem to be in random order (not alphabetical anyway).

Thanks -- Bob (CQC 5.2.1)

Print this item

  Nest brought back into the nest
Posted by: Dean Roddey - 02-07-2018, 06:27 PM - Forum: General Automation - No Replies

I saw some stories about Nest being brought back into Google, i.e. no longer an independent subsidiary. I can't imagine that Google did that because it thought that (all other things being equal) that Nest would do better within the much larger hierarchy of Google. So it would seem that this is not to be seen as a reward for a job well done, right?

Print this item

  iOS App for WebRIVA - CTC CQC
Posted by: znelbok - 02-06-2018, 01:35 AM - Forum: Apple/iOS Related Products - Replies (27)

I am pleased to announce that there is now an app on the iOS App store for CQC WebRiva.  CTC CQC

This was written by someone I reached out to after he wrote a similar app for a C-Bus lighting system (He also makes some really really nice in wall iPad mounts that match Clipsal C-Bus Saturn switches).

This app will go full screen and has options to turn on caching, no pixel etc in settings - so no more URL mangling or testing.

You can also put in teh LAN address and WAN address (and ports) seperatly so no more different icons on the home screen.

Please give it a go and give me any feed back and I will forward it to him.  Alternatively you can contact him directly using the email he has included in the help page.

[Image: Icon-60@3x.png]

AU STORE

[Image: app_store.png]

US STORE

[Image: app_store.png]


Enjoy

Mick

Print this item