GEM connection via DB

Ask questions about the GEM here.
Post Reply
ben
Site Admin
Posts: 4262
Joined: Fri Jun 04, 2010 9:39 am

Re: GEM connection via DB

Post by ben » Tue Mar 11, 2014 10:33 am

rnoble wrote:I'm working on setting up my tiered rates and would like some clarity... My first 600kWh are always ~$.13/kWh, 600kWh+ are ~$.17/kWh from June-September only.

Would this look something like this?
Image

If it's documented somewhere, please point me in the right direction.
I would do the following:

01-01 to 06-01 50000 kWh 0.13
06-01 to 09-30 600 kWh 0.13
06-01 to 09-30 50000 kWh 0.17
09-30 to 12-31 50000 kWh 0.13

or

01-01 to 12-31 600 kWh 0.13
01-01 to 09-30 50000 kWh 0.13
06-01 to 09-30 50000 kWh 0.17
09-30 to 12-31 50000 kWh 0.13

The 50000 kWh is just an arbitrarily high number, eventually I'll just have a check box for infinity.
Ben
Brultech Research Inc.
E: ben(at)brultech.com
rnoble
Posts: 60
Joined: Thu Jan 02, 2014 10:27 am

Re: GEM connection via DB

Post by rnoble » Tue Mar 11, 2014 10:41 am

ben wrote: I would do the following:

01-01 to 06-01 50000 kWh 0.13
06-01 to 09-30 600 kWh 0.13
06-01 to 09-30 50000 kWh 0.17
09-30 to 12-31 50000 kWh 0.13
Got it... What about the Saturday/Sunday boxes? I don't have any special rate changes for the weekends (I'm still holding out on my "dumb" meter). Should this boxes be checked or left blank?
ben
Site Admin
Posts: 4262
Joined: Fri Jun 04, 2010 9:39 am

Re: GEM connection via DB

Post by ben » Tue Mar 11, 2014 11:06 am

rnoble wrote:
ben wrote: I would do the following:

01-01 to 06-01 50000 kWh 0.13
06-01 to 09-30 600 kWh 0.13
06-01 to 09-30 50000 kWh 0.17
09-30 to 12-31 50000 kWh 0.13
Got it... What about the Saturday/Sunday boxes? I don't have any special rate changes for the weekends (I'm still holding out on my "dumb" meter). Should this boxes be checked or left blank?
Left blank if you don't have any special rates.

Ben
Ben
Brultech Research Inc.
E: ben(at)brultech.com
rnoble
Posts: 60
Joined: Thu Jan 02, 2014 10:27 am

Re: GEM connection via DB

Post by rnoble » Wed Mar 19, 2014 11:52 am

I'm now trying to connect to SEG. I've typed my token into the DB, but SEG can't discover my device... Do I need to do anything on the GEM to get the DB to send data to SEG?
Teken
Posts: 2700
Joined: Wed Dec 15, 2010 4:09 pm
Location: The Bad Lands

Re: GEM connection via DB

Post by Teken » Wed Mar 19, 2014 6:17 pm

rnoble wrote:I'm now trying to connect to SEG. I've typed my token into the DB, but SEG can't discover my device... Do I need to do anything on the GEM to get the DB to send data to SEG?
Hello Ryan,

What steps have you completed in the GEM thus far? Also, I gather your SEG site is fully configured and set up per the below set up guide?

The SEG set up guide in the Brultech software section has an excellent step by step: http://brultech.com/home/software/index ... etsoft/1/1
Teken . . .

My ongoing projects thread: http://www.brultech.com/community/viewt ... ?f=2&t=929
Buy me a cup of coffee: https://www.paypal.me/Teken https://gfinotify.com/ Discount Code: PC10
rnoble
Posts: 60
Joined: Thu Jan 02, 2014 10:27 am

Re: GEM connection via DB

Post by rnoble » Thu Mar 20, 2014 5:59 am

Teken wrote:
rnoble wrote:I'm now trying to connect to SEG. I've typed my token into the DB, but SEG can't discover my device... Do I need to do anything on the GEM to get the DB to send data to SEG?
Hello Ryan,

What steps have you completed in the GEM thus far? Also, I gather your SEG site is fully configured and set up per the below set up guide?

The SEG set up guide in the Brultech software section has an excellent step by step: http://brultech.com/home/software/index ... etsoft/1/1
I was just using the 6 steps outlined on the SEG forward tab of the DB.

1. Register as a new user here.
2. Go to sites, and click "add a site".
3. Copy down the site token, and enter your site name, then save it.
4. Enter your site key below, and checkmark enabled, then save those settings.
5. Wait for the discovery process on SmartEnergyGroups.com to finish.
6. If the discovery process times out, check your site key below and try rediscovering.


I'll look at the instructions soon.
ben
Site Admin
Posts: 4262
Joined: Fri Jun 04, 2010 9:39 am

Re: GEM connection via DB

Post by ben » Thu Mar 20, 2014 10:13 am

If you're using the latest DB firmware, check your Raw Data logs to make sure SEG packets are being sent.

Ben
Ben
Brultech Research Inc.
E: ben(at)brultech.com
rnoble
Posts: 60
Joined: Thu Jan 02, 2014 10:27 am

Re: GEM connection via DB

Post by rnoble » Thu Mar 20, 2014 10:21 am

ben wrote:If you're using the latest DB firmware, check your Raw Data logs to make sure SEG packets are being sent.

Ben
This is what I get...
2014-03-20 11:19:09 AM SmartEneryGroups (site (token removed) (node 01000858 ? (p_1 2271.97)(e_1 40.39)(a_1 23.903)(p_2 1.94)(e_2 0.03)(a_2 0)(p_3 1870.72)(e_3 33.26)(a_3 20.185)(p_4 0.02)(e_4 0)(a_4 0.013)(p_5 0.02)(e_5 0)(a_5 0)(p_6 0.45)(e_6 0.01)(a_6 0)(p_7 10.73)(e_7 0.19)(a_7 0.253)(p_8 1.3)(e_8 0.02)(a_8 0.06)(p_9 0.02)(e_9 0)(a_9 0)(p_10 0.31)(e_10 0.01)(a_10 0)(p_11 151.92)(e_11 2.7)(a_11 1.273)(p_12 0.02)(e_12 0)(a_12 0)(p_13 10.02)(e_13 0.18)(a_13 0.38)(p_14 7.08)(e_14 0.13)(a_14 0.08)(p_15 81.02)(e_15 1.44)(a_15 1.045)(p_16 1.86)(e_16 0.03)(a_16 0)(p_17 0.7)(e_17 0.01)(a_17 0)(p_18 1.97)(e_18 0.04)(a_18 0.02)(p_19 1.14)(e_19 0.02)(a_19 0)(p_20 13.08)(e_20 0.23)(a_20 0.118)(p_21 0.36)(e_21 0.01)(a_21 0)(p_22 0.14)(e_22 0)(a_22 0)(p_23 84.23)(e_23 1.5)(a_23 1.153)(p_24 29.3)(e_24 0.52)(a_24 0.32)(p_25 0)(e_25 0)(a_25 0)(p_26 0)(e_26 0)(a_26 0)(p_27 0)(e_27 0)(a_27 0)(p_28 0)(e_28 0)(a_28 0)(p_29 0)(e_29 0)(a_29 0)(p_30 0)(e_30 0)(a_30 0)(p_31 0)(e_31 0)(a_31 0)(p_32 0)(e_32 0)(a_32 0)(temperature_1 0)(temperature_2 0)(temperature_3 0)(temperature_4 0)(temperature_5 0)(temperature_6 0)(temperature_7 0)(n_1 0)(n_2 0)(n_3 0)(n_4 0)(v_1 123.18)))
ben
Site Admin
Posts: 4262
Joined: Fri Jun 04, 2010 9:39 am

Re: GEM connection via DB

Post by ben » Thu Mar 20, 2014 10:25 am

rnoble wrote:
ben wrote:If you're using the latest DB firmware, check your Raw Data logs to make sure SEG packets are being sent.

Ben
This is what I get...
2014-03-20 11:19:09 AM SmartEneryGroups (site (token removed) (node 01000858 ? (p_1 2271.97)(e_1 40.39)(a_1 23.903)(p_2 1.94)(e_2 0.03)(a_2 0)(p_3 1870.72)(e_3 33.26)(a_3 20.185)(p_4 0.02)(e_4 0)(a_4 0.013)(p_5 0.02)(e_5 0)(a_5 0)(p_6 0.45)(e_6 0.01)(a_6 0)(p_7 10.73)(e_7 0.19)(a_7 0.253)(p_8 1.3)(e_8 0.02)(a_8 0.06)(p_9 0.02)(e_9 0)(a_9 0)(p_10 0.31)(e_10 0.01)(a_10 0)(p_11 151.92)(e_11 2.7)(a_11 1.273)(p_12 0.02)(e_12 0)(a_12 0)(p_13 10.02)(e_13 0.18)(a_13 0.38)(p_14 7.08)(e_14 0.13)(a_14 0.08)(p_15 81.02)(e_15 1.44)(a_15 1.045)(p_16 1.86)(e_16 0.03)(a_16 0)(p_17 0.7)(e_17 0.01)(a_17 0)(p_18 1.97)(e_18 0.04)(a_18 0.02)(p_19 1.14)(e_19 0.02)(a_19 0)(p_20 13.08)(e_20 0.23)(a_20 0.118)(p_21 0.36)(e_21 0.01)(a_21 0)(p_22 0.14)(e_22 0)(a_22 0)(p_23 84.23)(e_23 1.5)(a_23 1.153)(p_24 29.3)(e_24 0.52)(a_24 0.32)(p_25 0)(e_25 0)(a_25 0)(p_26 0)(e_26 0)(a_26 0)(p_27 0)(e_27 0)(a_27 0)(p_28 0)(e_28 0)(a_28 0)(p_29 0)(e_29 0)(a_29 0)(p_30 0)(e_30 0)(a_30 0)(p_31 0)(e_31 0)(a_31 0)(p_32 0)(e_32 0)(a_32 0)(temperature_1 0)(temperature_2 0)(temperature_3 0)(temperature_4 0)(temperature_5 0)(temperature_6 0)(temperature_7 0)(n_1 0)(n_2 0)(n_3 0)(n_4 0)(v_1 123.18)))
Looks right, when you reboot do you have any problems with time syncing?

Ben
Ben
Brultech Research Inc.
E: ben(at)brultech.com
rnoble
Posts: 60
Joined: Thu Jan 02, 2014 10:27 am

Re: GEM connection via DB

Post by rnoble » Thu Mar 20, 2014 10:29 am

ben wrote:
rnoble wrote:
ben wrote:If you're using the latest DB firmware, check your Raw Data logs to make sure SEG packets are being sent.

Ben
This is what I get...
2014-03-20 11:19:09 AM SmartEneryGroups (site (token removed) (node 01000858 ? (p_1 2271.97)(e_1 40.39)(a_1 23.903)(p_2 1.94)(e_2 0.03)(a_2 0)(p_3 1870.72)(e_3 33.26)(a_3 20.185)(p_4 0.02)(e_4 0)(a_4 0.013)(p_5 0.02)(e_5 0)(a_5 0)(p_6 0.45)(e_6 0.01)(a_6 0)(p_7 10.73)(e_7 0.19)(a_7 0.253)(p_8 1.3)(e_8 0.02)(a_8 0.06)(p_9 0.02)(e_9 0)(a_9 0)(p_10 0.31)(e_10 0.01)(a_10 0)(p_11 151.92)(e_11 2.7)(a_11 1.273)(p_12 0.02)(e_12 0)(a_12 0)(p_13 10.02)(e_13 0.18)(a_13 0.38)(p_14 7.08)(e_14 0.13)(a_14 0.08)(p_15 81.02)(e_15 1.44)(a_15 1.045)(p_16 1.86)(e_16 0.03)(a_16 0)(p_17 0.7)(e_17 0.01)(a_17 0)(p_18 1.97)(e_18 0.04)(a_18 0.02)(p_19 1.14)(e_19 0.02)(a_19 0)(p_20 13.08)(e_20 0.23)(a_20 0.118)(p_21 0.36)(e_21 0.01)(a_21 0)(p_22 0.14)(e_22 0)(a_22 0)(p_23 84.23)(e_23 1.5)(a_23 1.153)(p_24 29.3)(e_24 0.52)(a_24 0.32)(p_25 0)(e_25 0)(a_25 0)(p_26 0)(e_26 0)(a_26 0)(p_27 0)(e_27 0)(a_27 0)(p_28 0)(e_28 0)(a_28 0)(p_29 0)(e_29 0)(a_29 0)(p_30 0)(e_30 0)(a_30 0)(p_31 0)(e_31 0)(a_31 0)(p_32 0)(e_32 0)(a_32 0)(temperature_1 0)(temperature_2 0)(temperature_3 0)(temperature_4 0)(temperature_5 0)(temperature_6 0)(temperature_7 0)(n_1 0)(n_2 0)(n_3 0)(n_4 0)(v_1 123.18)))
Looks right, when you reboot do you have any problems with time syncing?

Ben
I just rebooted and the times at the top of the page are correct... Is that what you're referring to?
Post Reply