Category: DataBases

Airtable first look

         I had seen Airtable pop up a number of times. I thought it was just another team tool, like Notion & ClickUp, and it is, to an extent, but its also a DataBase , but a friendly one that you can share. It allows you to create tables and link the tables together. Also to

QGis Madeira Basic conns to Maps/.csv’s/Databases

         I thought I’d have a look at QGis again now that it has been updated. I’m always wow’d by what people can do with the GIS mapping. Unfortunately for me I’m an amateur playing in this area. I did a cartography course at Uni way back and enjoy exploring some mapping tools. As QGis and

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

Regular Expressions/Regex for data cleaning

         A regular expression, regex or regexp A regular expression, regex or regexp is, in theoretical computer science and formal language theory, a sequence of characters that define a search pattern. Usually this pattern is then used by string searching algorithms for “find” or “find and replace” operations on strings, or for input validation. From Wikipedia.

RapidMiner Studio free Data Science Tool

         It provides a wealth of functionality to speed & optimize data exploration, blending & cleansing tasks โ€“ reducing the time spent importing and wrangling your data. RapidMiner provides an integrated environment for data preparation, machine learning, deep learning, text mining, and predictive analytics. RapidMiner Studio (Some information see item 18 of list).  This programme keeps

Asset Tiger 4. Testing features Reports, Localisation/Date/Time Format and Site/Location , Audit, Geo-location & Map

         Reports Standard reports The out of the box (OOTB) Asset Report is pretty standard, not too many field, as in, none of the custom fields that you have added come through. You have 2 options, the Asset by ID Tag  or Asset by Tag with Pictures. (screenshots 1 & 2 below). Both show you all

Orange free Data Mining Tool

          I was looking through 101-useful-websites article and came across and used it to look up alternatives to say “Revit” and “AutoCad” and other tools I use. I then typed in KNIME which I use for data mining, data analysis and it came up with Orange as a free alternative.  So I looked at

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