IRC logs for #farmOS, 2020-06-07 (GMT)

2020-06-06
2020-06-08
TimeNickMessage
[03:20:19]* JustTB has quit (Quit: Leaving.)
[03:27:56]* JustTB has joined #farmos
[03:51:00]* JustTB has quit (Quit: Leaving.)
[04:19:53]* donblair[m] has quit (Ping timeout: 256 seconds)
[04:19:53]* donblair[m]1 has joined #farmos
[04:35:05]* calbasi_matrix has quit (*.net *.split)
[04:36:21]* calbasi_matrix has joined #farmos
[08:02:23]* JustTB has joined #farmos
[10:57:40]<skipper_is[m]>The most useful way to look at the daily liveweight gains would be to calculate the daily liveweight gain for each animal - then average it. So, Animal 1: 5kg on day 1 (01/05/2020), on day 10 (10/05/2020) he weighed 15kg, so his daily liveweight gain is 1kg/day, Animal 2: 3kg on Day 1 (was born later on the 10/05/2020), and on Day 4 (14/05/2020) he weighed 5kg, so his daily liveweight gain would be 0.5kg/day. The
[10:57:40]<skipper_is[m]>average to display would be 0.75kg/day.
[10:58:46]<skipper_is[m]>For the latest record in the graph - take the last weight for the animal, and subtract the 2nd last from it. Divide that by the days between
[10:59:05]<skipper_is[m]>and average for all animals
[11:00:28]<skipper_is[m]>Also....
[11:00:32]<skipper_is[m]>ACTION sent a long message: < https://matrix.org/_matrix/media/r0/download/matrix.org/WQWqaygkpQfsfFqB... >
[11:44:56]<skipper_is[m]> * >
[11:44:56]<skipper_is[m]>PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), ('farm_asset', '147', '147', 'planting', 'rdf_mapping', 'und', 'Array', 'Arra' at line 1: INSERT INTO {field_data_field_farm_season} (entity_type, entity_id, revision_id, bundle, delta, language,
[11:44:56]<skipper_is[m]>...(truncated)
[11:45:20]<skipper_is[m]> * ```
[11:45:20]<skipper_is[m]>PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), ('farm_asset', '147', '147', 'planting', 'rdf_mapping', 'und', 'Array', 'Arra' at line 1: INSERT INTO {field_data_field_farm_season} (entity_type, entity_id, revision_id, bundle, delta, language,
[11:45:20]<skipper_is[m]>...(truncated)
[11:47:06]<mstenta[m]>https://github.com/farmOS/farmOS/pull/297
[11:47:41]<mstenta[m]>Thanks for posting the weight report details to an issue skipper_is !
[11:47:41]<skipper_is[m]>Ah sweet, I'll clone that
[11:48:30]<skipper_is[m]>I hope it makes sense...
[12:27:20]<paul121[m]>Yea that makes sense @skipper_is:matrix.org !
[12:28:32]<paul121[m]>I'm curious if we might need some different "modes". I think there still is a use case where a random sampling of animals are weighed. So individual assets might not be tracked
[12:31:12]<paul121[m]>I'll try and put more thoughts in that issue later this week
[12:32:04]<paul121[m]>I'm curious, have you seen the "Weight" tab that is added to individual animal assets? Any thoughts or feedback on that?
[12:33:31]<paul121[m]>Pretty basic right now - only displays a graph of weights. But it might be easy to add daily gain on that graph
[12:38:45]<skipper_is[m]>If they are all of the same age/stage and you do random sampling, then yes it may work, but personally actual daily live weight gain would be better, oherwise you get a graph like this, which is, quite frankly, useless
[12:38:46]<skipper_is[m]>ACTION uploaded an image: image.png (36KB) < https://matrix.org/_matrix/media/r0/download/matrix.org/uimqJkAdUKSwAGUQ... >
[12:40:10]<skipper_is[m]>For the individual weight pages, it would look quite good with daily liveweight gain, but whether that'd make sense on the chart, or as a separate table - It is only really the latest one that is of much use really...
[12:51:48]<paul121[m]>Yeah, the average sampling is a rather specific use case. I agree tracking of individuals is needed
[12:52:14]<paul121[m]>Should have included some description text about that
[12:53:17]<paul121[m]>Ah interesting! I think there is a `Weight: value` that gets added to the asset description
[12:54:26]<paul121[m]>Maybe it would make sense to add something like: `Weight Gain: 10kg since 5/1/2020`
[13:33:45]<skipper_is[m]>Yea, possibly - I'm having a little play with the weight report on the asset page at the moment, seeing whether I can put something in there - mainly as it is a simple page and easy to edit..
[13:34:27]<skipper_is[m]>One question though - is there a reverse function of format_date? That gets the formatted date and put it back to a timestamp? Or should I modify the base array to keep timestamp separate?
[13:36:43]<skipper_is[m]>nvm, there is a second array created with quantity and timestamp
[13:52:47]<skipper_is[m]>ACTION uploaded an image: image.png (60KB) < https://matrix.org/_matrix/media/r0/download/matrix.org/AlbIKurPGdaLGoCd... >
[13:52:53]<skipper_is[m]>Well, it works, but it isn't quite where I wanted it
[13:54:15]<skipper_is[m]>It is also the least elegant solution
[13:54:21]<skipper_is[m]>ACTION uploaded an image: image.png (19KB) < https://matrix.org/_matrix/media/r0/download/matrix.org/laolsSmLjPRCDhNh... >
[14:17:40]<skipper_is[m]>Also, is there an even shorter format_date? With just the date, not the time?
[16:08:06]* calbasi_matrix has quit (Ping timeout: 256 seconds)
[16:08:22]* calbasi_matrix has joined #farmos
[16:49:10]* JustTB has quit (Ping timeout: 246 seconds)
[17:03:48]* JustTB has joined #farmos
[17:29:04]* JustTB has quit (Ping timeout: 246 seconds)
[17:44:49]* JustTB has joined #farmos
[17:53:09]* ddsh[m] has quit (*.net *.split)
[17:53:10]* jonathan[m] has quit (*.net *.split)
[17:53:10]* andifi[m] has quit (*.net *.split)
[17:53:10]* dazinism has quit (*.net *.split)
[17:53:35]* dazinism has joined #farmos
[17:53:35]* ddsh[m] has joined #farmos
[17:53:35]* jonathan[m] has joined #farmos
[17:53:35]* andifi[m] has joined #farmos
[17:53:51]* pllagn[m] has quit (*.net *.split)
[17:53:51]* skipper_is[m] has quit (*.net *.split)
[17:53:51]* mstenta[m] has quit (*.net *.split)
[17:53:51]* farmtech[m] has quit (*.net *.split)
[17:53:52]* mindcls[m] has quit (*.net *.split)
[17:53:53]* Dorn[m] has quit (*.net *.split)
[17:53:53]* zedrckr[m] has quit (*.net *.split)
[17:53:54]* younes__auto[m] has quit (*.net *.split)
[17:53:54]* frederike[m] has quit (*.net *.split)
[17:53:55]* mmn has quit (*.net *.split)
[17:53:55]* calbasi_matrix has quit (*.net *.split)
[17:53:56]* joshua[m]2 has quit (*.net *.split)
[17:53:56]* ddsh[m] has quit (*.net *.split)
[17:53:56]* jonathan[m] has quit (*.net *.split)
[17:53:56]* andifi[m] has quit (*.net *.split)
[17:53:56]* dazinism has quit (*.net *.split)
[17:53:57]* svenn has quit (*.net *.split)
[17:53:58]* JustTB has quit (*.net *.split)
[17:53:59]* donblair[m]1 has quit (*.net *.split)
[17:53:59]* martha[m] has quit (*.net *.split)
[17:53:59]* canadrian[m] has quit (*.net *.split)
[17:53:59]* tcmah[m] has quit (*.net *.split)
[17:53:59]* symbioquine[m] has quit (*.net *.split)
[17:53:59]* paul121[m] has quit (*.net *.split)
[17:54:01]* scrdcow[m] has quit (*.net *.split)
[17:54:01]* rsteup[m] has quit (*.net *.split)
[17:54:01]* janjan[m] has quit (*.net *.split)
[17:54:01]* stefanie[m] has quit (*.net *.split)
[17:54:29]* andifi[m] has joined #farmos
[17:54:29]* jonathan[m] has joined #farmos
[17:54:29]* ddsh[m] has joined #farmos
[17:54:29]* dazinism has joined #farmos
[17:54:29]* JustTB has joined #farmos
[17:54:29]* calbasi_matrix has joined #farmos
[17:54:29]* donblair[m]1 has joined #farmos
[17:54:29]* joshua[m]2 has joined #farmos
[17:54:29]* Dorn[m] has joined #farmos
[17:54:29]* martha[m] has joined #farmos
[17:54:29]* canadrian[m] has joined #farmos
[17:54:29]* zedrckr[m] has joined #farmos
[17:54:29]* scrdcow[m] has joined #farmos
[17:54:29]* svenn has joined #farmos
[17:54:29]* pllagn[m] has joined #farmos
[17:54:29]* younes__auto[m] has joined #farmos
[17:54:29]* paul121[m] has joined #farmos
[17:54:29]* symbioquine[m] has joined #farmos
[17:54:29]* tcmah[m] has joined #farmos
[17:54:29]* rsteup[m] has joined #farmos
[17:54:29]* skipper_is[m] has joined #farmos
[17:54:29]* janjan[m] has joined #farmos
[17:54:29]* farmtech[m] has joined #farmos
[17:54:29]* mstenta[m] has joined #farmos
[17:54:29]* stefanie[m] has joined #farmos
[17:54:29]* mindcls[m] has joined #farmos
[17:54:29]* frederike[m] has joined #farmos
[17:54:29]* mmn has joined #farmos
[17:55:56]* pllagn[m] has quit (*.net *.split)
[17:55:56]* skipper_is[m] has quit (*.net *.split)
[17:55:56]* mstenta[m] has quit (*.net *.split)
[17:55:56]* farmtech[m] has quit (*.net *.split)
[17:55:57]* mindcls[m] has quit (*.net *.split)
[17:56:15]* pllagn[m] has joined #farmos
[17:56:15]* skipper_is[m] has joined #farmos
[17:56:15]* farmtech[m] has joined #farmos
[17:56:15]* mstenta[m] has joined #farmos
[17:56:15]* mindcls[m] has joined #farmos
[17:56:28]* Dorn[m] has quit (Ping timeout: 240 seconds)
[17:56:28]* zedrckr[m] has quit (Ping timeout: 240 seconds)
[17:56:30]* younes__auto[m] has quit (Ping timeout: 240 seconds)
[17:56:33]* frederike[m] has quit (Ping timeout: 240 seconds)
[17:56:37]* donblair[m]1 has quit (Ping timeout: 244 seconds)
[17:56:37]* martha[m] has quit (Ping timeout: 244 seconds)
[17:56:37]* canadrian[m] has quit (Ping timeout: 244 seconds)
[17:56:38]* tcmah[m] has quit (Ping timeout: 244 seconds)
[17:56:38]* symbioquine[m] has quit (Ping timeout: 244 seconds)
[17:56:38]* paul121[m] has quit (Ping timeout: 244 seconds)
[17:56:44]* ddsh[m] has quit (Ping timeout: 244 seconds)
[17:56:45]* jonathan[m] has quit (Ping timeout: 244 seconds)
[17:56:47]* pllagn[m] has quit (Ping timeout: 252 seconds)
[17:56:47]* farmtech[m] has quit (Ping timeout: 252 seconds)
[17:56:48]* mindcls[m] has quit (Ping timeout: 252 seconds)
[17:57:07]* scrdcow[m] has quit (Ping timeout: 260 seconds)
[17:57:08]* rsteup[m] has quit (Ping timeout: 260 seconds)
[17:57:08]* janjan[m] has quit (Ping timeout: 260 seconds)
[17:57:09]* stefanie[m] has quit (Ping timeout: 260 seconds)
[17:57:14]* dazinism has quit (Ping timeout: 244 seconds)
[17:57:52]* calbasi_matrix has quit (*.net *.split)
[17:57:52]* joshua[m]2 has quit (*.net *.split)
[17:58:09]* calbasi_matrix has joined #farmos
[17:58:09]* joshua[m]2 has joined #farmos
[17:58:32]* mmn has quit (*.net *.split)
[17:59:37]* mmn has joined #farmos
[18:00:29]* calbasi_matrix has quit (Ping timeout: 243 seconds)
[18:00:30]* joshua[m]2 has quit (Ping timeout: 243 seconds)
[18:00:52]* andifi[m] has quit (Ping timeout: 244 seconds)
[18:01:33]* skipper_is[m] has quit (Ping timeout: 252 seconds)
[18:01:33]* mstenta[m] has quit (Ping timeout: 252 seconds)
[18:06:20]* donblair[m]1 has joined #farmos
[18:06:20]* symbioquine[m] has joined #farmos
[18:06:20]* paul121[m] has joined #farmos
[18:06:21]* canadrian[m] has joined #farmos
[18:06:22]* tcmah[m] has joined #farmos
[18:07:19]* janjan[m] has joined #farmos
[18:07:19]* rsteup[m] has joined #farmos
[18:07:20]* Dorn[m] has joined #farmos
[18:07:21]* younes__auto[m] has joined #farmos
[18:07:22]* zedrckr[m] has joined #farmos
[18:07:34]* ddsh[m] has joined #farmos
[18:14:03]* calbasi_matrix has joined #farmos
[18:15:21]* andifi[m] has joined #farmos
[18:16:56]* mstenta[m] has joined #farmos
[18:16:56]* skipper_is[m] has joined #farmos
[18:16:56]* farmtech[m] has joined #farmos
[18:16:56]* pllagn[m] has joined #farmos
[18:17:30]* scrdcow[m] has joined #farmos
[18:20:50]* dazinism has joined #farmos
[18:21:26]* joshua[m]2 has joined #farmos
[18:21:44]* frederike[m] has joined #farmos
[18:21:56]* stefanie[m] has joined #farmos
[18:30:04]* jonathan[m] has joined #farmos
[18:30:18]* mindcls[m] has joined #farmos
[18:33:59]* martha[m] has joined #farmos