Category: Web

100 Posts

        Dear visitor, I hope you have enjoyed some of the posts or got some useful insights/help that have assisted you in your work or interest. I have enjoyed writing most of these and learning some varied skills along the way, not all in the areas I expected when I started the journey. One thing that

Asset Tiger 1. free Online Asset Management Service with Free mobile app

         The AlternativeTo website popped up Asset Tiger as a free asset management tool when I typed in Alternatives to OpenMAINT. It is a cloud based tool and has a mobile app so that you can use it on your smartphone or tablet which is good too, as its free (the OpenMAINT one isn’t). Asset

DataTables for dynamic database queries for tables on web pages & export tools

        I have been interested in displaying tabulated data on a web page from a Database, exploring what is out there to use. WordPress has a couple of Free Table add-in’s but they are usually only available for uploading static data to your website (or from Excel/CSV). There is one WordPress Add-in that read from a

Excel web scraping and connecting to database. Dynamic updating of Excel imported data

        After writing the previous post on web scraping and the example given of using Google Spreadsheet to obtain a web table I started wondering about Excel. I was aware that it had a web connection so decided to explore those. This first video shows how to automate the data scraping  from websites into Excel: Then

Google searching, free Web Scraping tools and free Extract Tables from PDF tool.

        I have been looking at some of the free Data Science and Cognitive Computing Courses and was following the Data Journalism: First Steps, Skills and Tools course. The Google Searching video was on improving your searches in Google using the following: quotes to get specific key words eg “data science on construction” using – sign

Python 8. Jupyter Notebook

         There is an interactive tutorial here running Python. This instance is running from another website so could be slow. I found this video extremely good for setting up (I used the pip install method not anaconda) and how to use it. The Jupyter Notebook The Jupyter Notebook is an open-source web application that allows

Github – learning basic setup and use

        I have downloaded a lot of stuff from Github but haven’t really bothered figuring what it was about. I found this video a simple way to get my head around it and get to use it initially: Github Tutorial For Beginners – Github Basics for Mac or Windows & Source Control Basics I had signed

Python 6. How to automate the creation of HTML pages for 360 Panorama’s

        Panoramic files (360/180) can be viewed directly with a programme such as Paint, but they do not make much sense. You need a specific Panoramic programme to read the files correctly. I use the FREE photo sphere viewer by Jeremy Heleine. Follow the link to see the demos. The method that the programme uses is

Panorama file Hotspot setup using FREE Photo Sphere Viewer, plan link & tabs

        The newย ย  photo sphere viewer by Jeremy Heleine allows you to put Markers on your Panorama . See demo here. I think that is pretty cool and I wondered if you could make them into Hyperlinks to link other panoramas to make a virtual tour. So I did some tests. My previous way to be