Messages

176

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

-4wd (February 26, 2019, 06:13 PM)

That's one of the features of the Nokia 6.1, and it has a Qualcomm (Snapdragon 630) soc

177

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 amazon.de 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.

178

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?

-Target (February 24, 2019, 04:34 PM)

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


I'll post my own 3333rd post in style

179

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...

180

Living Room / Re: How to automatically generate reports based on xls files?

« on: February 19, 2019, 03:08 AM »

I want to learn.

-kalos (February 18, 2019, 02:30 PM)

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.

181

Living Room / Re: How to automatically generate reports based on xls files?

« on: February 18, 2019, 12:45 PM »

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?

182

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.

183

JGPaiva's GridMove and Ahk Tools / Re: GridMove Window Snap: Window Edges: Inherent margin?

« on: February 15, 2019, 12:35 PM »

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.

184

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.

185

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.

-Deozaan (February 13, 2019, 05:05 PM)

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

186

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=;
12.  
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
16.  
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!

187

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 )

188

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.

-BGM (February 13, 2019, 10:48 AM)

And it works like a charm, thanks

189

Post New Requests Here / Re: Delete All Text In File Until Particular String

« on: February 13, 2019, 05:28 AM »

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: http://gnuwin32.sour...net/packages/sed.htm

190

JGPaiva's GridMove and Ahk Tools / Re: GridMove Window Snap: Window Edges: Inherent margin?

« on: February 12, 2019, 12:40 PM »

Let me guess: You're on Windows 10?

191

LaunchBar Commander / Re: LBC - Loop Send Keys

« on: February 11, 2019, 01:20 PM »

I would like to loop the {DOWN} x 10

-slc7 (May 13, 2018, 06:00 AM)

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.

192

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 ?

https://es.aliexpres...1.0.0.274263c0ZRWOJH

Real or imaginary ?

-Contro (February 09, 2019, 04:31 AM)

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...

193

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.

194

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

195

Skwire Empire / Re: Release: sWeather (tray-based weather app)

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

as 7z or zip package

-Drugwash (February 07, 2019, 01:43 PM)

Attaching files to posts, or inserting screenshots (png's) into the message, has never been an issue here, using Palemoon, Firefox or Chrome browsers.

196

General Software Discussion / Re: How to stack windows side by side in Windows 10?

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

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

197

Living Room / Re: DC on Discord :O

« on: February 05, 2019, 12:26 PM »

because nobody ever talks on the DC IRC

-Stephen66515 (February 04, 2019, 09:08 PM)

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...

198

General Software Discussion / Re: [Splasm Software] Why can't I tab to the TYPE field?

« on: February 01, 2019, 01:15 AM »

Splasm: https://www.splasm.com/products/

-Curt (January 31, 2019, 06:31 PM)

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

199

Post New Requests Here / Re: Wish: NumberComparer tool to compare two list of words and export differences

« on: January 28, 2019, 08:30 AM »

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.

200

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...