# \#data **URL:** https://forum.communityhealthtoolkit.org/tag/data/41.md [Latest](https://forum.communityhealthtoolkit.org/latest.md) · [Categories](https://forum.communityhealthtoolkit.org/categories.md) · [Tags](https://forum.communityhealthtoolkit.org/tags.md) --- ## [OpenFn Live Demo: Getting Started with Data Collections](https://forum.communityhealthtoolkit.org/t/openfn-live-demo-getting-started-with-data-collections/4427)
**Author:** [@ayodeleatopenfn](https://forum.communityhealthtoolkit.org/u/ayodeleatopenfn)\ **Replies:** 0\ **Last updated:** [December 4, 2024, 3:40pm UTC](https://forum.communityhealthtoolkit.org/t/openfn-live-demo-getting-started-with-data-collections/4427 "2024-12-04T15:40:06Z")
Register to attend OpenFn’s live demo call where we will showcase and discuss our latest feature - data collections. Data collections allows users to store, update, and reuse data across workflows in their OpenFn projec… --- ## [Migrate data from one form structure to another](https://forum.communityhealthtoolkit.org/t/migrate-data-from-one-form-structure-to-another/3028)
**Author:** [@Anro](https://forum.communityhealthtoolkit.org/u/Anro)\ **Replies:** 4\ **Last updated:** [September 18, 2023, 4:10pm UTC](https://forum.communityhealthtoolkit.org/t/migrate-data-from-one-form-structure-to-another/3028 "2023-09-18T16:10:46Z")
With the timelines being what they are, we’ve unfortunately resulted to using our non-prod environment as a “semi” prod in the interim. We’ve changed two main things: Age is now being dynamically calculated, whereas be… --- ## [Some useful SQL to look into upgrades](https://forum.communityhealthtoolkit.org/t/some-useful-sql-to-look-into-upgrades/2112)
**Author:** [@michael](https://forum.communityhealthtoolkit.org/u/michael)\ **Replies:** 4\ **Last updated:** [July 10, 2023, 8:31pm UTC](https://forum.communityhealthtoolkit.org/t/some-useful-sql-to-look-into-upgrades/2112 "2023-07-10T20:31:56Z")
I was recently doing some work to understand when server upgrades happened and compare that to when users upgraded their devices… and just wanted to share some SQL with everyone in case it might be useful in your work (o… --- ## [Some helpful SQL to look into number of days per month a HW opened the CHT](https://forum.communityhealthtoolkit.org/t/some-helpful-sql-to-look-into-number-of-days-per-month-a-hw-opened-the-cht/2804)
**Author:** [@michael](https://forum.communityhealthtoolkit.org/u/michael)\ **Replies:** 4\ **Last updated:** [June 21, 2023, 7:49am UTC](https://forum.communityhealthtoolkit.org/t/some-helpful-sql-to-look-into-number-of-days-per-month-a-hw-opened-the-cht/2804 "2023-06-21T07:49:49Z")
Telemetry data is recorded any time a user opens their app. We can understand how many days per month a user opens their app by looking at the number of unique days a telemetry record was recorded for them. I wanted to … --- ## [What do the various \`source\` types represent on reports](https://forum.communityhealthtoolkit.org/t/what-do-the-various-source-types-represent-on-reports/492)
**Author:** [@michael](https://forum.communityhealthtoolkit.org/u/michael)\ **Replies:** 9\ **Last updated:** [May 31, 2023, 12:31pm UTC](https://forum.communityhealthtoolkit.org/t/what-do-the-various-source-types-represent-on-reports/492 "2023-05-31T12:31:23Z")
Reports normally have a source field. I’ve seen 3 different values in this field: task, contact, and user. Are these the only possible values and are the assumptions below correct? task - report was submitted from the #… --- ## [How to interpret telemetry for household tasks (task groups)](https://forum.communityhealthtoolkit.org/t/how-to-interpret-telemetry-for-household-tasks-task-groups/2777)
**Author:** [@michael](https://forum.communityhealthtoolkit.org/u/michael)\ **Replies:** 3\ **Last updated:** [May 26, 2023, 4:39pm UTC](https://forum.communityhealthtoolkit.org/t/how-to-interpret-telemetry-for-household-tasks-task-groups/2777 "2023-05-26T16:39:26Z")
I’m trying to interpret telemetry data for household tasks (#5886) and I want to make sure I am understanding the data correctly. The telemetry documentation states that each metric includes “performance” data such as mi… --- ## [How to find "priority" tasks in PostgreSQL](https://forum.communityhealthtoolkit.org/t/how-to-find-priority-tasks-in-postgresql/1937)
**Author:** [@michael](https://forum.communityhealthtoolkit.org/u/michael)\ **Replies:** 2\ **Last updated:** [May 10, 2023, 12:39am UTC](https://forum.communityhealthtoolkit.org/t/how-to-find-priority-tasks-in-postgresql/1937 "2023-05-10T00:39:43Z")
I’m trying to do some research on “Priority” tasks… tasks where the priority.level property is set to high. The database schema documentation for tasks makes no specific mention of this property, though I imagine it wou… --- ## [Custom data exports for Direct Interaction with BI Tools](https://forum.communityhealthtoolkit.org/t/custom-data-exports-for-direct-interaction-with-bi-tools/2119)
**Author:** [@mourice](https://forum.communityhealthtoolkit.org/u/mourice)\ **Replies:** 0\ **Last updated:** [August 23, 2022, 8:55pm UTC](https://forum.communityhealthtoolkit.org/t/custom-data-exports-for-direct-interaction-with-bi-tools/2119 "2022-08-23T20:55:02Z")
Your Organization: Medic Organization Type: Not for profit Tech company What Other Organizations Would Benefit From This Feature: All organisations that actively use data from CHT for decision support. Immediately an … --- ## [Some helpful SQL to look into which roles and permissions are assigned to users](https://forum.communityhealthtoolkit.org/t/some-helpful-sql-to-look-into-which-roles-and-permissions-are-assigned-to-users/2175)
**Author:** [@michael](https://forum.communityhealthtoolkit.org/u/michael)\ **Replies:** 0\ **Last updated:** [September 16, 2022, 2:52pm UTC](https://forum.communityhealthtoolkit.org/t/some-helpful-sql-to-look-into-which-roles-and-permissions-are-assigned-to-users/2175 "2022-09-16T14:52:49Z")
We are doing some work related to Bulk Delete UX and wanted to see how many users actually have the can\_bulk\_delete\_reports permission. I wanted to share some SQL that might be helpful if you need to look into Roles, Pe… --- ## [Questions about form versioning introduced in cht-core 3.15 / cht-conf 3.10](https://forum.communityhealthtoolkit.org/t/questions-about-form-versioning-introduced-in-cht-core-3-15-cht-conf-3-10/2032)
**Author:** [@michael](https://forum.communityhealthtoolkit.org/u/michael)\ **Replies:** 6\ **Last updated:** [September 6, 2022, 11:01am UTC](https://forum.communityhealthtoolkit.org/t/questions-about-form-versioning-introduced-in-cht-core-3-15-cht-conf-3-10/2032 "2022-09-06T11:01:39Z")
cht-conf/395 added xmlVersion to forms. cht-core/7561 writes that xmlVersion as the form\_version on data\_records. A couple questions There’s a comment in 7561 that says “It should be completely backwards compatible … --- ## [Mute unmute history](https://forum.communityhealthtoolkit.org/t/mute-unmute-history/2109)
**Author:** [@bamatic](https://forum.communityhealthtoolkit.org/u/bamatic)\ **Replies:** 2\ **Last updated:** [August 23, 2022, 11:43pm UTC](https://forum.communityhealthtoolkit.org/t/mute-unmute-history/2109 "2022-08-23T23:43:18Z")
Hi there, About the mute and unmute transition, I extracted data from mute and unmute data\_records, and ordered them in chronological order. And I found : For the same place we have successive mutes without unmutes b… --- ## [Is there dummy data I can use to populate my new CHT app?](https://forum.communityhealthtoolkit.org/t/is-there-dummy-data-i-can-use-to-populate-my-new-cht-app/792)
**Author:** [@isaacholeman](https://forum.communityhealthtoolkit.org/u/isaacholeman)\ **Replies:** 5\ **Last updated:** [August 13, 2020, 8:18pm UTC](https://forum.communityhealthtoolkit.org/t/is-there-dummy-data-i-can-use-to-populate-my-new-cht-app/792 "2020-08-13T20:18:55Z")
Hi, I was just talking with a friend who installed CHT-core with the default config on his machine. He wants to test a little more, but he hasn’t used a CHT app before and it’s a bit hard for him to see how it’s working … --- ## [Is there a way to recover deleted reports in v0.4?](https://forum.communityhealthtoolkit.org/t/is-there-a-way-to-recover-deleted-reports-in-v0-4/82)
**Author:** [@medicbot](https://forum.communityhealthtoolkit.org/u/medicbot)\ **Replies:** 0\ **Last updated:** [September 29, 2016, 6:01am UTC](https://forum.communityhealthtoolkit.org/t/is-there-a-way-to-recover-deleted-reports-in-v0-4/82 "2016-09-29T06:01:00Z")
Imported Question by sanchaygupta · Sep 29, 2016 at 06:55 PM How can we recover a report that was accidentally deleted by a health facility? --- ## [What do the geolocation collection errors mean in terms of actual device (phone) settings?](https://forum.communityhealthtoolkit.org/t/what-do-the-geolocation-collection-errors-mean-in-terms-of-actual-device-phone-settings/91)
**Author:** [@medicbot](https://forum.communityhealthtoolkit.org/u/medicbot)\ **Replies:** 1\ **Last updated:** [July 16, 2019, 10:53pm UTC](https://forum.communityhealthtoolkit.org/t/what-do-the-geolocation-collection-errors-mean-in-terms-of-actual-device-phone-settings/91 "2019-07-16T22:53:10Z")
Imported Question by @michael · Sep 24, 2016 at 10:35 AM We are seeing the following errors for forms that are submitted (on the mobile app) that don’t have geolocation data. What do each of these errors mean in terms…