Portal, data logging, app issues

Related to the Portal
rimai
Posts: 12881
Joined: Fri Mar 18, 2011 6:47 pm

Re: Portal, data logging, app issues

Post by rimai »

Can you post your code?
Roberto.
reefoffillory
Posts: 20
Joined: Tue Sep 19, 2017 6:36 pm

Re: Portal, data logging, app issues

Post 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
rimai
Posts: 12881
Joined: Fri Mar 18, 2011 6:47 pm

Re: Portal, data logging, app issues

Post 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.
Roberto.
reefoffillory
Posts: 20
Joined: Tue Sep 19, 2017 6:36 pm

Re: Portal, data logging, app issues

Post 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
rimai
Posts: 12881
Joined: Fri Mar 18, 2011 6:47 pm

Re: Portal, data logging, app issues

Post by rimai »

Yes, you better off using hard coded settings.
Roberto.
binder
Posts: 2871
Joined: Fri Mar 18, 2011 6:20 pm
Location: Illinois
Contact:

Re: Portal, data logging, app issues

Post 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
reefoffillory
Posts: 20
Joined: Tue Sep 19, 2017 6:36 pm

Re: Portal, data logging, app issues

Post 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
rimai
Posts: 12881
Joined: Fri Mar 18, 2011 6:47 pm

Re: Portal, data logging, app issues

Post by rimai »

Unless someone changed the libraries, the delayedstart is only applicable to power on delays.
Roberto.
reefoffillory
Posts: 20
Joined: Tue Sep 19, 2017 6:36 pm

Re: Portal, data logging, app issues

Post 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
rimai
Posts: 12881
Joined: Fri Mar 18, 2011 6:47 pm

Re: Portal, data logging, app issues

Post by rimai »

Sure. You can get a json formatted file.
http://forum.reefangel.com/status/jsonp ... &filter=t1
Roberto.
reefoffillory
Posts: 20
Joined: Tue Sep 19, 2017 6:36 pm

Re: Portal, data logging, app issues

Post 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!
binder
Posts: 2871
Joined: Fri Mar 18, 2011 6:20 pm
Location: Illinois
Contact:

Re: Portal, data logging, app issues

Post 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
rimai
Posts: 12881
Joined: Fri Mar 18, 2011 6:47 pm

Re: Portal, data logging, app issues

Post 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/
Roberto.
rimai
Posts: 12881
Joined: Fri Mar 18, 2011 6:47 pm

Re: Portal, data logging, app issues

Post 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
Roberto.
reefoffillory
Posts: 20
Joined: Tue Sep 19, 2017 6:36 pm

Re: Portal, data logging, app issues

Post 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.
rimai
Posts: 12881
Joined: Fri Mar 18, 2011 6:47 pm

Re: Portal, data logging, app issues

Post by rimai »

The first column would be date and time in unix (EPOCH) format.
Roberto.
binder
Posts: 2871
Joined: Fri Mar 18, 2011 6:20 pm
Location: Illinois
Contact:

Re: Portal, data logging, app issues

Post 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
Post Reply