Help with Solar Channel Setup

Ask questions about the GEM here.
SirMaple
Posts: 70
Joined: Sat Aug 08, 2015 11:37 pm
Location: Canada

Re: Help with Solar Channel Setup

Post by SirMaple » Tue May 02, 2023 7:15 am

ben wrote:
Mon May 01, 2023 1:37 pm
Try

INSERT INTO hourdata (channel_id, date, wattsecond, watt, kwh, seconds, cost, totalcost, amps, peakwatt, minwatt)
SELECT '2386', date, wattsecond, watt, kwh, seconds, cost, totalcost, amps, peakwatt, minwatt
FROM hourdata
WHERE channel_id = 2341
AND date < (select min(date) from hourdata where channel_id = 2386);
That did it. Everything looks good now. Just need to clean up the CT wiring in the garage and I'd say everything is done.

Thanks again for all the help. Much appreciated!
Post Reply