avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Thursday February 25, 2021, 7:34 pm
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Ath [ switch to compact view ]

Pages: prev1 ... 3 4 5 6 7 [8] 9 10 11 12 13 ... 140next
Living Room / Re: Looking for smartphone
« on: February 27, 2019, 01:06 AM »
if he travels outside the EU, in this case a dual SIM phone comes in handy
That's one of the features of the Nokia 6.1, and it has a Qualcomm (Snapdragon 630) soc ;)

Living Room / Re: Looking for smartphone
« on: February 26, 2019, 01:32 PM »
I've been quite happy with the Nokia 6.1 (64 GB model) I bought last year. I searched on and found the 32 GB model here that should fit the budget. I assume you can pick a different color for a similar price, if desired.
It has a decent processor and quit fair battery life (2+ days on light use), and all modern stuff like usb-c, 3.5mm audioplug, no notch and a (fast) fingerprint scanner on the back.

Living Room / Re: When you make your 100'th Post
« on: February 25, 2019, 12:45 PM »
How the hell do you guys find this stuff?

Well, you have to find joy in spotting special numbers and see the synchronicity displayed in them ;D

I'll post my own 3333rd post in style

Screenshot - 25-02-2019 , 19_47_09.png

Living Room / Re: When you make your 100'th Post
« on: February 24, 2019, 03:02 AM »
A couple of matching numbers, while posting in the same thread, and signed up in the same year, but also one notable difference...

Screenshot - 24-02-2019 , 09_57_27.png

I want to learn.
I was aiming for 'learning by example', but ok:

You should probably use the mail merge feature of Word, it involves getting the data from Excel sheet(s). There are plenty manuals/guides available on the internet, you can use google to find one.
You might want to add some calculated fields in your Excel sheet that hold the counts/calculations you requested, and you already seem to know the formulas involved.

Can you attach a real sample of the xls file here, so we can determine the structure, and you describe what exact elements you need the report to operate on?

Living Room / Re: Review Pendrive Microdrive usb 3.0 128 GB
« on: February 15, 2019, 12:39 PM »
H2testw is the way to go, read this review of that and similar tools.

Well, Windows 10 puts a default transparent shadow around any non-maximized window of ca. 5-10 pixels. That is most likely what you are seeing. You probably can't 'fix' it as it isn't broken, but designed that way.

General Software Discussion / Re: Full Windows 10 on Raspberry Pi 3!
« on: February 14, 2019, 12:50 PM »
Well, MS has been working on an ARM version of Windows since Windows-RT, and we all saw how successful that was... not. :'(

General Software Discussion / Re: Full Windows 10 on Raspberry Pi 3!
« on: February 14, 2019, 01:28 AM »
Maybe speeds will improve as better drivers are released for faster access to the SD card or possible GPU acceleration.
Well, after I tried one of the first IoT releases of Windows, specifically made for the RPi, I found it to be so dreadfully slow that I gave up on it. So while I appreciate your efforts, I'm not inclined to even try to get it working. And about the anticipated speed improvements: Keep on dreaming hoping :up:

Post New Requests Here / Re: NetTraffic xml export to Excel
« on: February 13, 2019, 03:17 PM »
Well, I mocked up a batchfile, using xmlstarlet to be downloaded here, that converts all "NetTraffic <date-time>.xml" files of current directory into a single NetTrafficAll.csv file.

(Used the PowerShell highlighter as Batch isn't supported by the board)
You'll need to adjust the path to the xml.exe file, and check the other settings as 'documented'
NOTE: No data-conversions done here, Excel can do that better and easier
Code: PowerShell [Select]
  1. @echo off
  2. :: Set the relative path to your xmlstarlet install:
  3. set XML=..\Downloads\XML\xmlstarlet-1.6.1\xml.exe
  4. :: Change filemask if desired
  5. set "FILEMASK=NetTraffic 2*.xml"
  6. :: Change result outputfile as desired, keep the .csv extension, when adding spaces, surround with quotes like FILEMASK
  7. set OUTFILE=NetTrafficAll.csv
  8. :: Add StatHour to this list if desired
  9. set "ELEMENTS=StatYear StatMonth StatDay"
  10. :: Choose csv separator, either , (comma) or ; (semicolon)
  11. set CSVSEP=;
  13. set XMLARG1=sel -T -t -m NetTraffic/
  14. set XMLARG2=/key -v "concat('
  15. set XMLARG3=%CSVSEP%',@ts,'%CSVSEP%',@tm,'%CSVSEP%',@dl,'%CSVSEP%',@ul,'%CSVSEP%',@dx,'%CSVSEP%',@dy)" -n
  17. :: Write header
  18. echo Period%CSVSEP%ts%CSVSEP%tm%CSVSEP%dl%CSVSEP%du%CSVSEP%dx%CSVSEP%dy>"%OUTFILE%"
  19. :: Loop all files from FILEMASK
  20. for %%F in ("%FILEMASK%") do (
  21. echo File: %%F
  22. :: Fetch all configured elements
  23. for %%G in (%ELEMENTS%) do (
  24. %XML% %XMLARG1%%%G%XMLARG2%%%G%XMLARG3% "%%F" >>"%OUTFILE%"
  25. )
  26. )

NOTE2: The csv file will be fully replaced each run of the script!

Post New Requests Here / Re: NetTraffic xml export to Excel
« on: February 13, 2019, 01:44 PM »
Thanks for sharing. And I'm happy my educated guess about the ts field was quite close :-[

Can you attach an original xml file to a reply? Scraping it from your messages doesn't provide the original structure, you seem to have taken clips from a webbrowser (the dashes in front of the <Stat elements give it away ;)) (Finally downloaded NetTraffic and did a testrun 8))

N.A.N.Y. 2019 / Re: NANY 2019: TextWorx - Universal Text Manipulator
« on: February 13, 2019, 01:33 PM »
Ath - I've added your base64 encode string function.
And it works like a charm, thanks :Thmbsup:

Use sed, the Stream EDitor, known from Linux, but also available for Windows. And here is a SO answer with details

The Windows download can be found here:

Let me guess: You're on Windows 10?

LaunchBar Commander / Re: LBC - Loop Send Keys
« on: February 11, 2019, 01:20 PM »
I would like to loop the {DOWN} x 10
You could run my tool WinSendKeys, that is created in, and supports, the AutoIt3 syntax, like {DOWN 10} to repeat the {DOWN} keystroke 10 times (might need surrounding quotes when used on a command-line). It also has options to direct the keystrokes to a specific window or application, read keystrokes from a (script)file, execute mouse clicks and moves, and a whole plethora of related stuff.
Haven't tried myself to start it from LBC, as I'm not an LBC user, but it is designed for tasks like that.

Living Room / Re: Refurbished or used internal hard disks 3½ 6TB-12TB
« on: February 09, 2019, 05:08 AM »
Ejem. What do you think about this ?


Real or imaginary ?

It's real, but not suitable as main storage.
And how long you'll have a device that will support micro-USB? My current phone has (and most newer phones will have) USB-C connector...

Post New Requests Here / Re: NetTraffic xml export to Excel
« on: February 09, 2019, 05:02 AM »
Well, I tried a couple of possibilities, and the closes guess I have is that 'ts' is related to 1/1/0000, in seconds, but with a factor 100 off. Guess that's close enough for determining the data.
ul and dl are quite self explanatory (million bytes).

Best advice would probably be to contact the developer and ask for documentation.

Post New Requests Here / Re: NetTraffic xml export to Excel
« on: February 08, 2019, 10:26 AM »
Excel can open an xml file just fine as a worksheet:
  • Start Excel (2007 or later I'd advise)
  • Use File-Open to fetch the xml file
  • Choose either the 1st 'As an XML table' or 2nd 'As a readonly workbook' option when prompted
    • The 1st option will induce a message about a missing schema, just continue with OK
    • The 2nd option will include some of the metadata as column headers, it can be removed if desired
  • Process & massage the data as required/desired

Skwire Empire / Re: Release: sWeather (tray-based weather app)
« on: February 07, 2019, 01:55 PM »
as 7z or zip package
Attaching files to posts, or inserting screenshots (png's) into the message, has never been an issue here, using Palemoon, Firefox or Chrome browsers.

And use the <Win>-(cursor-keys) hotkeys to move and resize the current window...

Living Room / Re: DC on Discord :O
« on: February 05, 2019, 12:26 PM »
because nobody ever talks on the DC IRC
I'd want to write on IRC, but I can't, as by default the 'voice' flag is off, so I can't even ask there to turn it on... :-[

Thanks Curt, but my aim was to educate the OP in formulating a more complete question, but maybe that's to much to ask for drive-by posters :-[

A few developer tools come to mind:
- Compare It! by Grigsoft (shareware, my personal favorite)
- Beyond Compare by Scooter Software (shareware)
- WinMerge (OSS)

They may need some configuration/settings to act as described.

Skwire Empire / Re: Release: sWeather (tray-based weather app)
« on: January 24, 2019, 04:58 AM »
And also the changelog in the help/about screen is updated upto 1.7.6, not 1.7.7...

Pages: prev1 ... 3 4 5 6 7 [8] 9 10 11 12 13 ... 140next