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 …

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 …

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 …

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 …

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, …

Self-Hosting Guide to Alternatives: Airtable

Airtable is a popular SaaS platform for collecting, visualizing, and sharing data through low-code applications built on relational databases from a spreadsheet-like interface. Like Notion, Airtable has gained widespread popularity across individual and enterprise settings as an easy way to manage projects, event planning, calendars, roadmaps, inventories, and more.

Fortunately, a number of self-hosted projects have gained popularity in the last several years as viable alternatives for replicating Airtable's …

Odoo Evaluation: Restricting Visibility of Inventory to Other Branches

Greetings. I am in the process of evaluating Odoo, using both a local install of Community and Odoo.sh; overall, I'm impressed with the platform.

However, one issue - a potential showstopper - is that each branch can all inventory across all branches; this is incredibly confusing and given my target clientele, could create significant problems.

I have been scouring forums, documentation, you name it, for an answer and just haven't found one that fits my problem - I can't believe this is a first. I realize …

Odoo Project (& Task) & Planning Modules

Hello everyone

I'm trying to streamline how I use Odoo for project management and hoping someone has a better system than mine to share ....

I have multiple projects with tasks and most of the tasks have time estimates allocated to them (created from project templates) and all this is working fairly well. I started off using activities to create reminders when various actions need to be done and this works ok(ish) but doesn't give me visibility of how long each of the tasks will take.

I have tried the …

Product Setup for Maximum Reporting Flexibility

Hi all

In Odoo 14, are there any options other than Product Category for analysis that carry through to sales reporting? Analytic accounting has not been enabled (can you even do this in retrospect?).

I am helping someone else out. They are a retail and distribution business and aren't getting the right kind of sales data they need to run the business properly. They need to be able to report by a) supplier/brand, b) product line/function across multiple brands and c) by product. I came from MS Business …

Seeking Insights on Leveraging Data Analytics with Odooo

Hey everyone,

I've been diving deep into the world of data analytics recently, especially in how it can be integrated with Odoo. I'm really curious about how other businesses are leveraging their Odoo data to drive insights and decision-making.

For those of you who have experience or are currently working with data analytics on your Odoo instance:

What tools or platforms are you using for data visualization and reporting? I love Power BI but I don't see any easy integration.
Have you found any effective …