Ideas to look into

Found around the web; no action defined yet (incubating)

Efficiently Cleaning Text with Pandas

Introduction

It’s no secret that data cleaning is a large portion of the data analysis process. When using pandas, there are multiple techniques for cleaning text fields to prepare for further analysis. As data sets grow large, it is important to find efficient methods that perform in a reasonable time and are maintainable since the text cleaning process evolves over time.

This article will show examples of cleaning text fields in a large data file and illustrates tips for how to efficiently clean …

FIRE in a developing economy

My wife’s cousin recently moved to Cote d’Ivoire, and our latest conversation centered around financial independence and early retirement. The topic is also known under the trendy term “FIRE”. You may have heard about it as “those darn milenials retiring in their 30s”.

A lot of the advice I’m familiar with is US-centric (or covering Canada, Australia, EU countries, and so on). I couldn’t find adequate resources for pursuing financial independence in emergent economies. I tried to research this subject, and …

PiKVM - Control up to 4 servers simultaneously

This is every homelabbers dream isn't it? Controlling multiple systems that don't have IPMI natively, remotely. Thanks to PiKVM, we've been able to do this on a 1:1 basis for a while - but I've found a HDMI/USB KVM switch which will let us up that number to 4:1.

PiKVM is designed to run on a Raspberry Pi 4 (it will run on a Zero but performance will be awful). It uses an HDMI CSI bridge adapter to capture the input from a remote system and using the OTG capabilities of the USB-C port on the Pi 4, spoofs …

How do you handle startup with encrypted volumes?

At the moment I'm using dropbear to enable ssh login before the drive decrypts so I can enter the password but its pretty painful when I want to de a reboot, and I'm really worried about losing the ssh key for it. even though I have it backed up. I'm considering changing to a piKVM but it seems like just another single point of failure.

How do you all handle this problem? Have you got an easier solution or recommendations?

submitted by /u/caffeineneededtolive to r/linuxadmin
[link] …

Goodbye runbot, welcome runboat.

As you may have noticed, a new tool has arrived in the OCA landscape: runboat. It is a runbot replacement that is specially tailored to OCA needs. What was runbot and why we can do better? ** Runbo...

Pandas Groupby Warning

Introduction

One of the reasons I like using pandas instead of Excel for data analysis is that it is easier to avoid certain types of copy-paste Excel errors. As great as pandas is, there is still plenty of opportunity to make errors with pandas code. This article discusses a subtle issue with pandas groupby code that can lead to big errors if you’re not careful. I’m writing this because I have happened upon this in the past but it still bit me big time just recently. I hope this article can help a few …

Check for duplicate items in a list with Ansible using a custom filter

Ansible provides some useful ways to manipulate data and filter items from sets or lists. None of these built-in filters provided what I thought would be a simple task - show duplicate items in a list.

Let's assume that I mistyped and entered a duplicate IP address into a list - like so:

- {mac: 3E:79:66:00:87:F7, ip: 192.168.1.1, hostname: dns}
- {mac: F2:8F:35:40:8A:9C, ip: 192.168.1.1, hostname: irc}
- {mac: 92:A9:C6:04:AE:CA, ip: 192.168.1.3, hostname: dev}

I need a way to not only check each item for …

Fully automated DNS and DHCP with Ansible, Dnsmasq and Pihole

You do like declarative configurations don't you? Good!

For the longest time I've made do with clicking through the Opnsense UI to add static IP reservations via MAC address mapping. It's been one of those minor friction points of network administration that I've put up with because automating the process seemed daunting.

This post will detail how I solved a few interesting problems as I fully automated DNS overrides and DHCP reservations using Pihole, and the program it's built on top of Dnsmasq.

Some …

Advanced Wireguard Container Routing

Introduction

WireGuard at this point needs no introduction as it became quite ubiquitous especially within the homelab community due to its ease of use and high performance. We previously showcased several ways to route host and container traffic through our WireGuard docker container in a prior blog article. In this article, we will showcase a more complex setup utilizing multiple WireGuard containers on a VPS to achieve split tunneling so we can send outgoing connections …

Notes to self: Ansible, SSH, and a password

I’m just the messenger; don’t kill me. The user who asked the question and I both well know the security of logging in via SSH can greatly be improved upon by using SSH keys instead of passwords.

Be that as it may, there was what I thought an interesting case, in that an Ansible installation with a few hundred hosts has the requirement to change root passwords whenever an admin departs the organization. In order for this to be possible, passwords obtained from a password storage will be used to login as …

Use 1 PiKVM instance to control 4 systems

I've previously written about this topic but feel the need to post an update as after watching a recent TechnoTim video, I have adopted a new 4x1 HDMI matrix which works a whole lot better.

The goal here is to use 1 PiKVM to control 4 servers "at once". By "at once", I mean "one at a time but with the ability to dynamically switch between up to 4 systems from a single PiKVM instance".

I know the Raspberry Pi 4 is practically impossible to buy these days but if you have one from the old days you can use, then …

External-facing API + React apps

I've just started at a company that currently uses Odoo but is facing issues with regards to usability of the user-interface.

We want to continue to use Odoo for trained managers, but build a suite of external "micro-apps" in React JS that allow end-users to have a simple, modern, responsive interface that is tailored to their specific task.

The React apps will need to leverage Odoo's data via an API that does not exist yet, but that will need to be scalable and robust with features you'd expect in a …

Draw and Map your Self Hosted Services using Excaladraw

Back in March of 2023 I wrote an article highlighting an app called Excalidraw. Since then, I have been seeing quite a few people using it or recommending it for drawing diagrams.

Excaladraw is a great self-hosted and open source web tool for drawing diagrams and mapping out projects that you want to display comprehensive visuals of.

I'm going to create a simple diagram that shows my self-hosted services setup and explain how I did it using nothing more than Excalidraw and free icons from WalkxCode on …

How to customize Incus containers with cloud-init

Incus is a manager for virtual machines and system containers. There is also an Incus support forum.

A virtual machine (VM) is an instance of an operating system that runs on a computer, along with the main operating system. A virtual machine uses hardware virtualization features for the separation from the main operating system. With virtual machines, the full operating system boots up in them. You can use cloud-init to customize virtual machines that are launched with Incus.

A system container is an …

Migrate email data from one Google Workspace account to another, available in open beta

What’s changing

Beginning today, a new data migration experience is available: you can migrate your users’ email data from one Google Workspace account to another in a more reliable and efficient manner. You can configure your data migration for up to 100 users at a time and also run delta migrations, which smartly brings over any newly generated data from the source without duplicating previously migrated content.

This feature is available as an open beta, which means admins can use it without enrolling in a …

Available in open beta: Build AppSheet automations using Google Forms

This announcement was part of Google Cloud Next ‘24. Visit the Workspace Blog to learn more about the next wave of innovations in Workspace, including enhancements to Gemini for Google Workspace.

What’s changing

AppSheet helps users automate manual workflows by integrating with data sources like Google Drive and Sheets, and today we’re excited to announce its integration with another data collection tool in Workspace: Google Forms.

Many companies rely on the data collected via form submissions when they are …

Introducing AppSheet Organizations

What’s changing

We’re making it easier to manage your AppSheet users with the introduction of AppSheet Organizations. An AppSheet organization creates organization administrators with a centralized tool to manage all of the teams in the organization and delegate team management responsibilities to team administrators.

This chart shows the hierarchical relationship between an organization, and its teams and members.

An organization is based on a Workspace organization and is tied to your primary domain. One …

Odoo REST API modules in the marketplace - which one do you use?

I tried two REST API modules in Odoo Marketplace. And I am not quite sure about the authentication. One needs to concatenate username and password another is unclear - I am still clueless about this one honestly.

I am thinking about "sync" and create automation workflows among a couple of services (Stripe, my React web app, etc) and Odoo. I am trying Azure Logic App as I can easily use Azure Key Vault with it and I have other apps hosted in Azure.

I do code but not like a developer. So I am comfortable …

Re-assign the open stuff after an employee has left

Things can be assigned in many different places from Projects/tasks to CRM (I think all activities from chatter go here?) to Purchase orders, etc.

Found this post on the Odoo forum:

What is the process to offboard a User in Odoo? Is there a checklist of steps? | Odoo

But it seems to be a very manual process.

Is there a better way?

submitted by /u/timd001
[link] [comments]

New ways to quickly format and organize data with tables in Google Sheets

This announcement was part of Google Cloud Next ‘24. Visit the Workspace Blog to learn more about the next wave of innovations in Workspace, including enhancements to Gemini for Google Workspace.

What’s changing

We know it can be time consuming to perform repetitive tasks like updating data in a spreadsheet. In addition, maintaining the structure and format of the data can be difficult when there are multiple people updating the document.

To help solve for this, we’re excited to announce tables in Google …

What's the best attendance fingerprint machine to use with Odoo?

Hello

We're in the process of moving to Odoo v17 hosted on Digital Ocean. We want to purchase and implement an attendance fingerprint machine to track when every employee came into office and left office. There are about 50 employees in total. What's the best brand that's compatible with Odoo?

Thanks

submitted by /u/ThePerito
[link] [comments]

API via XMLRPC - Is there a better way for multiple calls?

I am using XMLRPC to access the API. (Man do I wish I could do this with simple SQL calls).

I am building out a PDF price list for customers. I have 4 tiers of pricing and I want to show the product name and each of the tiers.

//this starts the process to grab the Tier1 price (1 of 4 tiers) $ids = $models->execute_kw($db, $uid, $password, 'product.pricelist.item', 'search_read', array(array(array('pricelist_id', '=', 1)))); foreach ($ids as $passid) { $ids1 = $models->execute_kw($db, $uid, $password, …

Gemini (gemini.google.com) is now available to Google Workspace users in more territories and languages

This announcement was part of Google I/O ‘24. Visit the Workspace Blog for more about new ways to engage with Gemini for Workspace and the Keyword Blog for more ways to stay productive with Gemini for Google Workspace.

What’s changing

Earlier this year, we announced that Google Workspace customers with a Gemini Enterprise or Business add-on now have access to chat with Gemini at gemini.google.com.

Starting today, we’re pleased to announce that Gemini (gemini.google.com) is now available in more than 35 …

Read 20 Short Stories From Nobel Prize-Winning Writer Alice Munro (RIP) Free Online

Note: Back in 2013, when Alice Munro won the Nobel Prize in Literature, we published a post featuring 20 short stories written by Munro. Today, with the sad news that Alice Munro has passed away, at the age of 92, we’re bringing the original post (from October 10, 2013) back to the surface–in part because you can still read the 20 stories free online. Please find the stories at the bottom of this post.

Calling her a “master of the contemporary short story,” the Swedish Academy awarded 82-year-old …