Reporting widget question

After testing for a while reporting widget, I’m really impressed, I must say… But watching at data table in per-device mode, one thing came into my mind:
The table is sorted in a growing pin number order. Ok, that’s not a problem at all…
But there are three columns: A data value, a timestamp and a pin number.

And my question: Wouldn’t it be more logical to order those in a different way:
The timestamp, the pin number, and finally the pin value?

1 Like

And my question: Wouldn’t it be more logical to order those in a different way:
The timestamp, the pin number, and finally the pin value?

I don’t know. Is it? I thought if you do export to some 3-d party does that matter?

By the way I just made some draft doc for it - https://github.com/blynkkk/blynkkk.github.io/blob/master/mobile/report.md

1 Like

BDP ? :laughing:

1 Like

Sorry, what is that? Can’t google :slight_smile:.

That’s my short of famous “Best Design Practice” :stuck_out_tongue:

Good. Cause what I googled was Big Dick Problems :smile:.

Regarding order - I really don’t know. What is the usage? I thought you just put it to excel and view as the graph. So why order is important here?

4 Likes

God, no way! But could be other shorts as well… OK, let’s stop it as it might get “censored” at some point :smiley:

As for the order: Well, sure it is not a big deal… you can choose columns and reorder them, or leave as they are - they are always usable. BUT… that is the way I would expect them to appear. And that is the way it seems to be most common order - at first timestamp, second group, last data.
(If only the forum would allow to create some form of voting…)

Edit: even default graph creator defaults the first column as an X axis… Am I right? (or not? - don’t remember actually :thinking:)

I’m with you and would make the time first. As X axis generally cames first.

1 Like

Ok. Agree. Done - https://github.com/blynkkk/blynk-server/issues/1139

2 Likes

@marvin7 fix is available in Google Play.

1 Like

Thanks ! Now I need to figure out the errors appearing when creating reports… They appeared after update. Server
0.38.2.

What errors?

Error after submitting report. I will try to remove and recreate report settings later. Will let you know ASAP

@marvin7 please post blynk.log in case you are on the Local server.

Yes, Local 0.38.2… Here’s blynk.log (from server startup till the unsuccessful report generation.)
Note that “per pin” reports were successfully generated, but per device and the newest “REPORT” failed with errors.
One more note: Click DATA SOURCE --> Project Devices Now UNSELECT some devices and GO BACK. Enter again Project Devices, and… Yes, they are still ALL selected :thinking:

OK, here’s the LOG:

15:53:56.858 INFO - Using data dir './data'
15:53:59.729 INFO - Region : local. Host : 192.168.1.130.
15:53:59.968 INFO - Renaming of old reporting files started...
15:53:59.977 INFO - Renaming of old reporting files finished after 9 ms.
15:54:01.639 INFO - Initializing gmail smtp mail transport. Username : xxxx@gmail.com. SMTP host : smtp.gmail.com:587
15:54:01.820 INFO - Reports : 0
15:54:01.828 INFO - Didn't find Let's Encrypt certificates.
15:54:01.828 WARN - You didn't specified 'server.host' or 'contact.email' properties in server.properties file. Automatic certificate generation is turned off. Please specify above properties for automatic certificates retrieval.
15:54:03.269 INFO - Hardware SSL server listening at 8441 port.
15:54:03.274 INFO - HTTP API and WebSockets server listening at 8080 port.
15:54:03.277 INFO - HTTPS API, WebSockets and Admin page server listening at 9443 port.
15:54:03.279 INFO - Mqtt hardware server listening at 8440 port.
15:54:04.969 INFO - xxx@o2.pl hardware joined.
15:54:06.310 INFO - xxx@o2.pl hardware joined.
15:54:06.312 INFO - xxx@o2.pl hardware joined.
15:54:06.315 INFO - xxx@o2.pl hardware joined.
15:54:06.331 INFO - xxx@o2.pl hardware joined.
15:54:06.513 INFO - xxx@o2.pl hardware joined.
15:54:08.921 INFO - xxx@o2.pl hardware joined.
15:54:14.206 INFO - xxx@o2.pl Blynk-app (android-22604) joined.
15:54:20.888 ERROR- Error generating report 97948 for user xxx@o2.pl. 
15:54:20.890 ERROR- java.lang.IndexOutOfBoundsException
15:54:20.890 INFO - Processed report for xxx@o2.pl, time 60 ms.
15:57:55.590 INFO - xxx@o2.pl Blynk-app (android-22604) joined.
15:58:09.459 ERROR- Error generating report 97948 for user xxx@o2.pl. 
15:58:09.460 ERROR- java.lang.IndexOutOfBoundsException
15:58:09.460 INFO - Processed report for xxx@o2.pl, time 8 ms.
15:59:29.627 INFO - xxx@o2.pl hardware joined.
16:01:45.512 INFO - xxx@o2.pl Blynk-app (android-22604) joined.
16:05:44.361 INFO - Processed report for xxx@o2.pl, time 6110 ms.
16:06:42.963 INFO - xxx@o2.pl Blynk-app (android-22604) joined.
16:07:04.507 ERROR- Error generating report 9318 for user xxx@o2.pl. 
16:07:04.508 ERROR- java.lang.IndexOutOfBoundsException
16:07:04.508 INFO - Processed report for xxx@o2.pl, time 17 ms.
16:08:47.207 ERROR- Error generating report 9318 for user xxx@o2.pl. 
16:08:47.208 ERROR- java.lang.IndexOutOfBoundsException
16:08:47.209 INFO - Processed report for xxx@o2.pl, time 24 ms.

@marvin7 wrong logging on the server =(. Not enough info to solve the issue. Could you please re-run your report with this build https://github.com/blynkkk/blynk-server/releases/download/v0.38.2/server-0.38.3-SNAPSHOT.jar and post logs again (stacktrace for the error would be enough)

Ok, give me few minutes:

IS it java 8 build??

No. Do you need java8?

To run on my hardware? - YES…

@Dmitriy ok - https://github.com/blynkkk/blynk-server/releases/download/v0.38.2/server-0.38.3-SNAPSHOT-java8.jar