By default IDLE (the standard Python IDE) does not show line numbers 😦
You can install the extension IdleX to do this. This is only one of IdleX’s features. See http://idlex.sourceforge.net/features.html for an overview of all features.
You can download IdleX here. After decompressing the ZIP file you only need to run idlex.py to use this extension (and show/hide line numbers).
The relative new browser Vivaldi has been updated to Beta 2 recently.
I have been using it on a regular base the last weeks and I have to admit I am impressed. It already seems mature and stable and is fun to use.
Check out Vivaldi’s web site for more info.
Out of the box Python is an interpreted programming language.
One way to create an exe file from the standard Python py files is using PyInstaller. (note: I am working with Python 3.5. PyInstaller supports Python 3. Py2exe – which also allows to make exe files – currently only supports Python 2.7)
- Download PyInstaller (http://www.pyinstaller.org/ – documentation can also be found here)
- Install PyInstaller with the pip command:
- Start Cmd
Go to the folder containing PyInstaller-3.0.zip (using CD FOLDERNAME)
- Execute the pip command:
- > pip install pyinstaller
Now package your py file with the command PyInstaller xxx.py; for example:
> PyInstaller Testapp.py
The exe file will now be created under the dist folder. You need all files in the dist folder containing the exe file.
> PyInstaller -F Testapp.py
Now Testapp.exe will also be created in the subfolder caller “dist” in a one-file bundled exe file.
> PyInstaller -F -w Testapp.py
This also creates a one-file bundled exe file, but does not show a console window; this is probably what you need when you create a GUI application.
After a reinstallation of Windows and Office (from 2013 to 2013 – Office 365) the dates of an existing sheet were no longer visible.
Apparently there was something strange with the cell formatting. After changing the format from “*” to a normal date format the dates were visible again.
When attaching an external monitor I was not able to see a code selection on this screen in the AutoIt editor SciTE.
I found out that changing the colors involved modifying the “c:\Program Files (x86)\AutoIt3\SciTE\SciTEGlobal.properties” file.
More specifically changing the selection.fore, alpha and back solved the issue.
As the alpha.selection settings apparently can behave differenty on a laptop display and an external monitor, it makes sense to disable this setting …
- When you modify the colors in SciTE, you can immediately see the result after saving the file.
- Put # in front of the original line to keep a backup of the original setting.
- See for example this page on w3schools.com for an overview of hex values colors
- Modify indicators.alpha, for example to “indicators.alpha=150” to improve visibility when highlighting a word (see below)
Apparently it’s really easy to setup kiosk mode in Windows 8.1.
See this article at HTG for more info.
Sometimes you need to query the WSUS database using T-SQL statements.
The WSUS database can be installed using the Windows Internal Database (shipping with WSUS 3.0) or a standard SQL database.
When a Windows Internal Database is used, you can use SQL Management Studio Express to connect to. Use the following string to connect to this database: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
For more info, see http://blogs.technet.com/b/gborger/archive/2009/02/27/exploring-the-wsus-windows-internal-database.aspx.
Continue reading SQL queries on WSUS database