Time Reports for Farm Payroll

I just wanted to see if anyone is using FarmOS to track hours for there Payroll? We currently are at Silver Creek Nursery and have been for the past several months. We are really excited with the ability to link it to assets and keep better farm records. We have grand plans to create assets for each of our trees in the orchard (we have over 200 different varieties of apples and other tress). This way we can do bloom tracking, harvest tracking for each cultivar.

Anyway, currently I am trying to streamline payroll. Right now I have to export two CSV’s. One for logs and one for Qty’s and then join them in excel to figure out the hours for payroll. I have been learning python and using the FarmOS.py API to create a simple UI for time logs. I am trying to get a payroll report in a touch of a button using the FarmOS.py API but I am struggling with filters. I have had success with simple filters but struggle with more complex ones like log timestamp dates between ranges.

I was wondering if anyone had some insight about how to go about this or if FarmOS.py is even the best tool for the job.


Have you ever used node-red? It may be simpler for building UI’s for interacting with the API.
@pat may have something similar built already.

This may also be another nice use case for AssetLink @Symbioquine? Perhaps not a mobile field tool use case but not sure that needs to be a constraint either?


I have not used node-red. I have looked into it a little bit. Would your website have a good node-red getting started with farmOS example?


NVM I just found this topic Node-Red example flows for beginners


Haven’t much on my site at the moment, I must add to it though.
I made a couple of videos on getting started, farmOS - YouTube

I’d actually forgotten about that thread, it’s probably the best place for some basic flows.


Yea. That’s right. Now the users logs their times, and I get a notification with a summary every time, and the users get’s their summary pr mail every time they log hours. They’re also provided with a list view of unpaid hours while adding new ones.
Could need some refinement, but it works fine.

I love farmOS, but it’s (yet) painful to add logs of some complexity. Node-Red helps a lot to make complex logging super-easy with any detail level you can think of. It’s for sure well spent time to study Node-Red.

I’ll share the flow on github eventually. Just been too busy.


Cross-posing my comment from another thread:

1 Like