Page 1 of 2

Re: Portal, data logging, app issues

Posted: Sun Nov 05, 2017 5:55 pm
by rimai
Can you post your code?

Re: Portal, data logging, app issues

Posted: Sun Nov 05, 2017 8:14 pm
by reefoffillory
rimai wrote:Can you post your code?
#include <ReefAngel_Features.h>
#include <Globals.h>
#include <RA_Wifi.h>
#include <Wire.h>
#include <OneWire.h>
#include <Time.h>
#include <DS1307RTC.h>
#include <InternalEEPROM.h>
#include <RA_NokiaLCD.h>
#include <RA_ATO.h>
#include <RA_Joystick.h>
#include <LED.h>
#include <RA_TempSensor.h>
#include <Relay.h>
#include <RA_PWM.h>
#include <Timer.h>
#include <Memory.h>
#include <InternalEEPROM.h>
#include <RA_Colors.h>
#include <RA_CustomColors.h>
#include <Salinity.h>
#include <RF.h>
#include <IO.h>
#include <ORP.h>
#include <AI.h>
#include <PH.h>
#include <WaterLevel.h>
#include <Humidity.h>
#include <DCPump.h>
#include <PAR.h>
#include <ReefAngel.h>

////// Place global variable code below here


////// Place global variable code above here


void setup()
{
    // This must be the first line
 ReefAngel.Init(); //Initialize controller
  ReefAngel.AddStandardMenu(); // Let's use 2014 Screen
    // Ports toggled in Feeding Mode
    ReefAngel.FeedingModePorts = Port1Bit | Port5Bit | Port6Bit | Port7Bit;
    // Ports toggled in Water Change Mode
    ReefAngel.WaterChangePorts = Port1Bit | Port5Bit | Port6Bit | Port7Bit;
    // Ports toggled when Lights On / Off menu entry selected
    ReefAngel.LightsOnPorts = Port3Bit | Port4Bit | Port8Bit;
    // Ports turned off when Overheat temperature exceeded
    ReefAngel.OverheatShutoffPorts = Port3Bit;
    // Use T1 probe as temperature and overheat functions
    ReefAngel.TempProbe = T1_PROBE;
    ReefAngel.OverheatProbe = T1_PROBE;


    // Ports that are always on
    ReefAngel.Relay.On( Port1 );
    ReefAngel.Relay.On( Port6 );

    ////// Place additional initialization code below here
    

    ////// Place additional initialization code above here
}

void loop()
{
    ReefAngel.StandardHeater( Port2 );
    ReefAngel.ActinicLights( Port3 );
    ReefAngel.DayLights( Port4 );
    ReefAngel.Relay.DelayedOn( Port5 );
    ReefAngel.Relay.DelayedOn( Port7 );
    ReefAngel.Relay.Set( Port8, !ReefAngel.Relay.Status( Port4 ) );
    ////// Place your custom code below here
    

    ////// Place your custom code above here

    // This should always be the last line
    ReefAngel.Portal ( "reefoffillory" );
    ReefAngel.ShowInterface();
}


I changed the part about the standard menu [as advance as my arduino/coding knowledge goes] and I changed the last part about the portal [that you said to do earlier]

I got this coding after using the Wizard

Re: Portal, data logging, app issues

Posted: Sun Nov 05, 2017 10:16 pm
by rimai
Well, you are using internal memory code and we can't see the settings you are using.
But, I just reread the post and there is no such thing as delayed start after feeding in the wizard.
For lights, if you use hard coded settings, you can pick the time to start and stop.

Re: Portal, data logging, app issues

Posted: Mon Nov 06, 2017 11:52 am
by reefoffillory
rimai wrote:Well, you are using internal memory code and we can't see the settings you are using.
But, I just reread the post and there is no such thing as delayed start after feeding in the wizard.
For lights, if you use hard coded settings, you can pick the time to start and stop.

I must have misunderstood the wording from the wizard, I thought it said under 'delayed start' that it's the amount of time that outlets are shut off after entering feeding and/or waterchange mode.

Is it better to use internal memory code or another type? I'm guessing this is in relation to the second screen of the wizard? I don't really need to be able to adjust the settings in the portal - I don't mind hooking my laptop up to the RA in order to change settings

Re: Portal, data logging, app issues

Posted: Mon Nov 06, 2017 1:13 pm
by rimai
Yes, you better off using hard coded settings.

Re: Portal, data logging, app issues

Posted: Tue Nov 07, 2017 12:55 pm
by binder
delayed start is the amount of time the outlet remains OFF after one of the following: exiting water change mode, feeding mode and controller start up

so if you set port1 to have a 1 minute delayed start, it won’t turn on until 1 minute after you have 1 of the 3 previously mentioned scenarios.

this is useful if you have a powerhead that is out of the water during water changes and it takes your return pump a minute to get the water level back up to normal. so you wouldn’t want that powerhead on and running out of the water immediately after your water change.


Sent from my iPad using Tapatalk

Re: Portal, data logging, app issues

Posted: Wed Nov 08, 2017 2:19 pm
by reefoffillory
binder wrote:delayed start is the amount of time the outlet remains OFF after one of the following: exiting water change mode, feeding mode and controller start up

so if you set port1 to have a 1 minute delayed start, it won’t turn on until 1 minute after you have 1 of the 3 previously mentioned scenarios.

this is useful if you have a powerhead that is out of the water during water changes and it takes your return pump a minute to get the water level back up to normal. so you wouldn’t want that powerhead on and running out of the water immediately after your water change.


Sent from my iPad using Tapatalk
That was how I intended to use it, I wanted my skimmer to stay off for 15 minutes, and my ATO to stay off for 20 minutes (how I set it up in the wizard) but it's not working, going to try again sometime this week

Re: Portal, data logging, app issues

Posted: Thu Nov 09, 2017 10:30 am
by rimai
Unless someone changed the libraries, the delayedstart is only applicable to power on delays.

Re: Portal, data logging, app issues

Posted: Thu Nov 30, 2017 8:23 am
by reefoffillory
rimai wrote:Unless someone changed the libraries, the delayedstart is only applicable to power on delays.
I tried searching the forum for information, but couldn't find anything. Am I able to download the data in the portal history to a form which is able to be manipulated such as a comma delimited/excel etc. file?

I'd like to be able to log my data for more than 3 days at a time, even if that means I have to download data every 3 days and compile it into a spreadsheet myself.

Is there already the capability to do this? I only see the option on the webchart to export image files

Thanks

Re: Portal, data logging, app issues

Posted: Thu Nov 30, 2017 10:14 am
by rimai
Sure. You can get a json formatted file.
http://forum.reefangel.com/status/jsonp ... &filter=t1

Re: Portal, data logging, app issues

Posted: Fri Dec 01, 2017 7:48 am
by reefoffillory
rimai wrote:Sure. You can get a json formatted file.
http://forum.reefangel.com/status/jsonp ... &filter=t1
Thank you for the response. I will be the first to admit that I am not as technically savvy as I would like to think. Does this pull the current status? How far back does it go?

I noticed that when I click on that link I only see temperature info, and no pH info. I also don't see an indication of time/sequence [unless i'm missing something].

I have never heard of JSON before, but I don't want to do anything too crazy with the data, just be able to see a chart of my temp/pH changes and be able to graph it in Excel or Google Sheets or something similar.

I also realize you're not in the business of free tech lessons so I understand if you don't have any further help to offer!

Thanks again!

Re: Portal, data logging, app issues

Posted: Fri Dec 01, 2017 10:29 am
by binder
the example given just pulls the current status for t1, hence the filter=t1 section.
json is just a way to format key value pairs.
there should be a way to get a complete data chunk in xml formatted response from the portal and that would (at least i think but don’t remember off hand since i haven’t looked for a while) include a date & time stamp. that’s what i do in my android app when the user asks for the data from the portal. i don’t have the exact url handy but can get it if you want.
xml and json are the only 2 ways to get the formatted data.


Sent from my iPad using Tapatalk

Re: Portal, data logging, app issues

Posted: Fri Dec 01, 2017 10:55 am
by rimai
It only goes the same as the portal.
This is the url the portal uses to pull data.
If you don't know how to manipulate json on excel, you can use this:
https://json-csv.com/

Re: Portal, data logging, app issues

Posted: Fri Dec 01, 2017 10:56 am
by rimai
To manipulate data on excel, just google.
This one is the first one it came up with:
https://www.youtube.com/watch?v=CjnsX81qWUg

Re: Portal, data logging, app issues

Posted: Fri Dec 01, 2017 11:30 am
by reefoffillory
binder wrote:the example given just pulls the current status for t1, hence the filter=t1 section.
json is just a way to format key value pairs.
there should be a way to get a complete data chunk in xml formatted response from the portal and that would (at least i think but don’t remember off hand since i haven’t looked for a while) include a date & time stamp. that’s what i do in my android app when the user asks for the data from the portal. i don’t have the exact url handy but can get it if you want.
xml and json are the only 2 ways to get the formatted data.


Sent from my iPad using Tapatalk
That would be great, I'd like time & Value for the data so that I can graph it.

I am able to split the values in the JSON file, but it's just not valuable without a date/time reference.

The value before the ,[reading] doesn't seem to mean anything for my purposes?

Thank you guys!

Really hoping to get these last few parts of the controller figured out before I decide to buy some more modules and expand it =)


I do have the android app linked to my portal - is it easier to get the data [including date/time/value] through the app? I am okay with having to manipulate/separate the data out in excel once I get a file with the data in it.

Re: Portal, data logging, app issues

Posted: Fri Dec 01, 2017 11:56 am
by rimai
The first column would be date and time in unix (EPOCH) format.

Re: Portal, data logging, app issues

Posted: Fri Dec 01, 2017 3:48 pm
by binder
reefoffillory wrote:
binder wrote:the example given just pulls the current status for t1, hence the filter=t1 section.
json is just a way to format key value pairs.
there should be a way to get a complete data chunk in xml formatted response from the portal and that would (at least i think but don’t remember off hand since i haven’t looked for a while) include a date & time stamp. that’s what i do in my android app when the user asks for the data from the portal. i don’t have the exact url handy but can get it if you want.
xml and json are the only 2 ways to get the formatted data.


Sent from my iPad using Tapatalk
That would be great, I'd like time & Value for the data so that I can graph it.

I am able to split the values in the JSON file, but it's just not valuable without a date/time reference.

The value before the ,[reading] doesn't seem to mean anything for my purposes?

Thank you guys!

Really hoping to get these last few parts of the controller figured out before I decide to buy some more modules and expand it =)


I do have the android app linked to my portal - is it easier to get the data [including date/time/value] through the app? I am okay with having to manipulate/separate the data out in excel once I get a file with the data in it.
there currently is no way to export the data from my android app.
so your best solution is to do what Roberto suggested or do what I mentioned. I personally don't know the json format and have not looked at it to understand it better. I just parse the xml data. regardless, to do what you want you will need a script to do the following:
1. query the portal for the data (xml or json)
2. save/process the data (if necessary)
3. import into excel

you just need to figure out what route you want to take and get started and then ask questions if you encounter any along the way.

Sent from my XT1585 using Tapatalk