Messages

1

Post New Requests Here / Re: NetTraffic xml export to Excel

« on: February 14, 2019, 04:45 AM »

@ath thanks a lot for your work. Like a charm

if anyone else needs it - excel formulas:

for date =((ts*POWER(10;2)/60/60/24)-693593)
for time =((C9/10000000))/24/60/60)
for dl/ul in MiB =dl/2^20
cursor =SQRT(pixel size*pixel size*dx*dx + pixel size*pixel size*dy*dy)

* pixel size in mm with the same name from here https://www.venea.ne...web/pixel_calculator

2

Post New Requests Here / Re: NetTraffic xml export to Excel

« on: February 13, 2019, 01:34 PM »

ok guys I know now how to translate the values. But not how to extract them.
I try to achieve it with powershell. But how can I separate all values of the same line with comas?
<key dy="19904" dx="30080" ul="1725446" dl="28220776" tm="34377250805" ts="636850944"/>
<key dy="139586" dx="221126" ul="44928805" dl="1278397665" tm="370183712706" ts="636851808"/>
should looke like this:
199904,30080,1725446 etc
139586,221126,44928805 etc

3

Post New Requests Here / Re: NetTraffic xml export to Excel

« on: February 13, 2019, 12:08 PM »

got an answer from the author:
Hello,

thank you for contact.

In one of upcoming releases I will add export to CSV (Excel compatible).

Below format explanation.

Best regards,
Michael

Format
======

ts - beginning of period
------------------------
Number of 100 - nanosecond intervals (C# ticks) since 12:00:00 midnight, January 1, 0001, divided by 1000000000.

dl, ul - number of bytes
------------------------
Bytes: dl - downloaded, ul - uploaded.

dx, dy - number of pixels
-------------------------
Distance approximation calculated as square root of pw * pw * dx * dx + ph * ph * dy * dy. Where ph is pixel height, pw is pixel width (ph = pw).

tm - work time
--------------
C# ticks / 1000000000. 1 tick = 100 nanoseconds.

Links
=====

C# ticks to date time
---------------------
https://www.venea.ne...timestamp_conversion

C# ticks to time span
---------------------
https://www.venea.ne...time_span_conversion

Pixel size
----------
https://www.venea.ne...web/pixel_calculator

4

Post New Requests Here / Re: NetTraffic xml export to Excel

« on: February 10, 2019, 09:36 AM »

@skwire
my example is the real data. Somehow this
<key dy="19904" dx="30080" ul="1725446" dl="28220776" tm="34377250805" ts="636850944"/>
translates to
2019-02-07   28.56 MiB   26.91 MiB   1.65 MiB   0.00:57:17       14.79 m

So the date should be 2019-02-07 and the time is the time logged at this day. Here for almost an hour.
here are some more examples:

[Select]

-<StatYear>

<key dy="358122" dx="582830" ul="312167827" dl="9446475679" tm="780111644557" ts="636818976"/>

</StatYear>


-<StatMonth>

<key dy="358122" dx="582830" ul="312167827" dl="9446475679" tm="780111644557" ts="636845760"/>

</StatMonth>


-<StatDay>

<key dy="19904" dx="30080" ul="1725446" dl="28220776" tm="34377250805" ts="636850944"/>

<key dy="139586" dx="221126" ul="44928805" dl="1278397665" tm="370183712706" ts="636851808"/>

<key dy="76867" dx="131457" ul="43921601" dl="325446856" tm="125459796269" ts="636852672"/>

<key dy="121765" dx="200167" ul="221591975" dl="7814410382" tm="250090884777" ts="636853536"/>

</StatDay>

which is

[Select]

2019                   9.57 GiB 9.25 GiB 320.59 MiB 0.21:55:07 289.67 m
2019-02           9.57 GiB 9.25 GiB 320.59 MiB 0.21:55:07 289.67 m
2019-02-07         28.56 MiB   26.91 MiB   1.65 MiB     0.00:57:17  14.79 m
2019-02-08 1.23 GiB 1.19 GiB 42.85 MiB 0.10:16:58 107.24 m
2019-02-09 352.26 MiB 310.37 MiB 41.89 MiB 0.03:29:05 62.45 m
2019-02-10 7.95 GiB 7.73 GiB 233.91 MiB 0.07:11:32 105.13 m

@shades
I am using a Huaweii router and in the only statistics I see is the total amount since the connection was set up. And this message "Volume statistics provided here are approximate. For accurate statistics and details of charges refer to your bills." So yeah

Also if someone has a small tool/program to log such data to excel I am willing to change.

5

Post New Requests Here / Re: NetTraffic xml export to Excel

« on: February 08, 2019, 11:13 AM »

@ath
yeah I got that, but how can i translate
<key dy="19904" dx="30080" ul="1725446" dl="28220776" tm="34377250805" ts="636850944"/>
to
2019-02-07   28.56 MiB   26.91 MiB   1.65 MiB   0.00:57:17       14.79 m

6

Post New Requests Here / Re: NetTraffix xml export to Excel

« on: February 08, 2019, 09:33 AM »

What is NetTraffix?

-skwire (February 08, 2019, 05:30 AM)

my bad. NetTraffic https://www.venea.net/web/nettraffic

7

Post New Requests Here / NetTraffic xml export to Excel

« on: February 08, 2019, 04:28 AM »

the statistics in the program itself look like this

[Select]

Date              tot            received       sent            time         cursor distance
2019-02-07 28.56 MiB 26.91 MiB 1.65 MiB 0.00:57:17     14.79 m

the export xml looks like this:

[Select]

-<StatDay>
<key dy="19904" dx="30080" ul="1725446" dl="28220776" tm="34377250805" ts="636850944"/>
</StatDay>

how can I import that in excel? I do not even understand how to get the date back
ts seems to be the date, it is the only variable which doesn't change over the day.

8

Finished Programs / Re: Taskbar Button Grouping/ Group Similar Icons on Taskbar Win 10 x64

« on: February 07, 2019, 01:04 PM »

Thank you very much. Works like a charm! Perfect

9

Finished Programs / Taskbar Button Grouping/ Group Similar Icons on Taskbar Win 10 x64

« on: February 06, 2019, 11:51 AM »

Is there a way to switch Taskbar Button Grouping with a hotkey between "combine" and "not combine" w/o restarting explorer? Preferebaly as AHK