This project has moved and is read-only. For the latest updates, please go here.

There is no data to export!

Topics: 5. Support
Sep 1, 2015 at 7:00 PM
Edited Sep 1, 2015 at 7:19 PM
when I call:
/usr/local/bin/sbfspot.3/SBFspot -finq -q -123s=DATA -cfg/var/www/123solar/config/SBFspot_0.cfg -nosql
Output:
20150901-19:51:57 229.070 0.194 44.000 0.000 0.000 0.000 0.000 0.000 0.000 49.980 81.481 54.730 0.000 22337.072 316.750 0.086 27.000 314.520 0.087 27.000 229.070 0.194 44.000 >>>S123:OK
There is no data to export!
Where is the Problem ?

Source Code:
int ExportMonthDataToCSV(const Config *cfg, InverterData *inverters[])
{
   char msg[80 + MAX_PATH];
   if (cfg->CSV_Export == 1)
   {
      if (VERBOSE_NORMAL) puts("ExportMonthDataToCSV()");

      if (inverters[0]->monthData[0].datetime <= 0)   //invalid date?
         puts("There is no data to export!"); //First day of the month?
      else
      {
         FILE *csv;
         
         ect.
         ........
Sep 1, 2015 at 8:18 PM
dear pv81,

can you please provide a FULL log file by using the options -d5 -v5

method:
write the log to a file by using the command: sbfspot "your-options" -d5 -v5 1>your-log-ou.txt 2>your-log-err.txt
the string "your-options" corresponds with the options that you normally apply
in your case this is "-finq -q -123s=DATA -cfg/var/www/123solar/config/SBFspot_0.cfg -nosql"

since you are a user of the -123s option -> the log file will give more information

take note:
-1- at the first day in of a month there is not yet a month file,
example today you will not yet get a september file -> from the info you did give this might be your case
please validate this "tomorrow"

-2- the total-production for a day is only available the next day,
example total production for 02september becomes availabe at 03sept early morning

-3- as a result -> for a complete list with the production of the previous month one can use the option -am2

kr wim
Sep 1, 2015 at 8:31 PM
Edited Sep 1, 2015 at 8:37 PM
For 123solar you don't need csv files, so use the -nocsv option (like you said in your unedited message above)
The -q option should suppress the "no data" message but it doesn't (bug?)
Like Wim said: the first day of every month, there is no monthdata to export, hence the message.
Marked as answer by SBF on 9/1/2015 at 12:36 PM
Sep 1, 2015 at 8:36 PM
The fix is:
        if (inverters[0]->monthData[0].datetime <= 0)   //invalid date?
        {
            if (!quiet)     puts("There is no data to export!"); //First day of the month?
        }
        else
        {
Marked as answer by SBF on 9/1/2015 at 12:36 PM
Sep 2, 2015 at 10:04 AM
@SBF: Can you fix this in the next version ? i think, there are other 123solar-users to with that problem. Thx
Sep 2, 2015 at 2:09 PM
Sure. I know 123Solar is very sensitive to this unexpected output.
Sep 19, 2015 at 1:00 PM
SBF wrote:
The fix is:
        if (inverters[0]->monthData[0].datetime <= 0)   //invalid date?
        {
            if (!quiet)     puts("There is no data to export!"); //First day of the month?
        }
        else
        {
You have not chage it, why ?
Sep 22, 2015 at 9:13 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.