basic-scripts

• zmd5sum.sh: returns md5sum of the uncompressed content of gzip files, useful as 2 identical files produce 2 different gzipped files:

• html_file_browser.sh: browse local HTML files in a folder using "Previous" and "Next" buttons, like what (for example) Windows Photo Viewer does for image files
• dokuwiki2redmine.pl: really basic DokuWiki (MediaWiki) to Redmine (Textile) converter
• downloadAllSharepointListAttachments.html: in SharePoint lists with attachments, by default you can open or download only one at a time. With this HTML+JS code, you can create a "Download all attachments" button: add a Content Editor webpart, click Edit Source and insert this code inside
• JxlToPoi.java: reads a JXL workbook sheet and writes its data and style to a POI workbook sheet
• AntipodeFinder.html: easily find your antipodes in a Leaflet map:

• youtube_cmd.sh: command line youtube player, using ddgr + youtube-dl + mpv:

• diffxlsx.sh: like diff but for Excel files. Converts them to CSV with xlsx2csv and diffs them. Useful for files with few differences, for example to check what was changed between two versions of the same file

• ImdbAgesInMovie.sql: If you are watching a movie and would like to see how old where the actors when they filmed it (and you happen to have SQL access to IMDB or have installed the IMDB database files in your own MySQL server), then run this query. Example for Dark City (1999):