Category: Data Extraction

StdLib API automation test with AirTable, SMS message, GMail & Google Sheets

        Somewhere I came across Standard Library but best searched for under StdLib. I signed up for it and found a couple of videos. It looked like magic and required serious coding, so I put it down at the time. I have been receiving regular “onboarding” emails (Seems pretty common and irritating when you sign up

Interactive web tables, Jexcel

        I found a post that had an article about an Excel type spreadsheet that you have in your web page with the benefits listed below, so I thought I’d have a play with it. jExcel is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with Excel or any other

Architectural Colour Schedule in Excel

        The last post I tried to use AirTable to create a Colour Schedule from a Revit export. Thinking I could use the Database to cross reference items in the room such as doors/windows etc to be able to pull those in to make the colour scheme planning more comprehensive. It didn’t work. Along the way

Revit internal condition over time GIF

        Background I have written a post on showing internal building fabric condition over time in this article Revit Internal Condition over Time. I was not, at the time, happy with the presentation of the information as it was a series of screenshots that I then put in as slides to step through the process. Two

Google Sheets ImportFEED, Import HTML & ImportXML

        Further to my previous post Google Sheets “GOOGLEFINANCE()” for free Stock data that started with referencing 5 things that Excel couldn’t do but Google Sheets can, I wanted to explore a few of the features mentioned in that video. It mentioned the following Google Sheet Functions: ImportFEED(), Import HTML() &ImportXML() 1. ImportFeed() Well, I followed

Learning UiPath RPA (Robotic Process Automation)

        Macro Tools Following on from Macro productivity tools using AlternativeTo I came across: SikuliX automates anything you see on the screen of your desktop computer running Windows, Mac or some Linux/Unix. It uses image recognition powered by OpenCV to identify and control GUI components. This is handy in cases when there is no easy access to

Finding leads for my Services Website- web scraping? Targeting business URL’s-Part 3

        At the end of the last post I put a few steps for my process: Part 1.Initially broad targeting. Harvesting personal emails with searches which include gmail.com etc. Part 2. I need to find some Facility Management Directories and do a web crawl on some of those. To do that I could use the Firefox