[NCSG-EC] NCSG - Trying to understand our members' distribution.

[Rafik Dammak]

Hi Jean,

You mean we can export to csv file? That is at least one good thing for any
future migration.
I think you can create spreadsheet and share it.

Best,

Rafik



On Mon, Dec 16, 2024, 14:32 Jean F. Quéralt <JFQueralt at theiofoundation.org>
wrote:

> Hi Rafik.
>
> Been looking into the CRM and managed to find my way around seeing all the
> registrations (or what seems to be it).
> Should you authorize it, and for the sake of easiness of handling, I'd
> create a spreadsheet and share with the people on this thread.
>
> Best,
> Jean F. Queralt
> Founder & CEO - The IO Foundation <https://TheIOFoundation.org>
> Book a meeting <https://TIOF.Click/BookJFQ> (30 minutes)
>
>
> On Mon, 16 Dec 2024 at 13:02, Rafik Dammak <rafik.dammak at gmail.com> wrote:
>
>> Hi Jean,
>>
>> Thanks for your comment. I will take your offer and hope you can
>> investigate more on this topic.
>> I put it in my to do list and plan to bring it to EC for discussion.
>>
>> Best,
>>
>> Rafik
>>
>>
>>
>> Le sam. 14 déc. 2024 à 12:05, Jean F. Quéralt <
>> JFQueralt at theiofoundation.org> a écrit :
>>
>>> Hi Rafik.
>>>
>>> Noted on this. I tried ti make sense of the report config and "fix it"
>>> and I gave up 0.3s right after.
>>>
>>> Juan tried once to reach out to members with not vet promising results
>>> in my estimation, although he's in a better position to give feedback on
>>> that.
>>>
>>> I'm keen on investigating more on this topic if your want me to.
>>>
>>> Cheers
>>> Jean
>>>
>>>
>>> On Sat, Dec 14, 2024, 10:31 Rafik Dammak <rafik.dammak at gmail.com> wrote:
>>>
>>>> Hi Jean,
>>>>
>>>> Thanks for bringing this to my attention.
>>>> I cannot make any conclusion on how aggregation or reports for total or
>>>> region are being made in civicrm as I am just in initial steps to
>>>> understand the setup, relation to the vendor etc.
>>>>
>>>> We can use election check-in process to ask members for updates but
>>>> only part of membership respond. We can reach all in way to engage and
>>>> update. However, data cleaning and update might take time and effort since
>>>> it will likely involve manual work. For point like voting, that is already
>>>> handled with the check-in process.
>>>>
>>>> Anyway, I will bring this to NCSG EC to work on plan for membership
>>>> data update and management in addition to application review and members
>>>> status. We can work on parallel about members engagement. Hope we will fix
>>>> this and have something sustainable.
>>>>
>>>> Best,
>>>>
>>>> Rafik
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Sat, Dec 14, 2024, 04:34 Jean F. Quéralt <
>>>> JFQueralt at theiofoundation.org> wrote:
>>>>
>>>>> Hi everyone.
>>>>>
>>>>> CC Juan & as this is a topic of relevance.
>>>>>
>>>>> I am looking at the reports on CiviCRM and the math isn't mathing.
>>>>>
>>>>> *NCSG*
>>>>> [image: image.png]
>>>>> 1) If the first row is "total" then that's obviously not right.
>>>>> 2) The "unknown" row is way too high. We need to do some data
>>>>> housekeeping there.
>>>>>
>>>>> *NPOC*
>>>>> [image: image.png]
>>>>> 1) If the first row is "total" then that's obviously not right.
>>>>> 2) The "unknown" row is way too high. We need to do some data
>>>>> housekeeping there.
>>>>>
>>>>> *NCUC*
>>>>> [image: image.png]
>>>>>
>>>>> 1) If the first row is "total" then that's obviously not right.
>>>>> 2) The "unknown" row is way too high. We need to do some data
>>>>> housekeeping there.
>>>>> 3) I've ran a crude counting and the total entries for NCUC is 864. I
>>>>> can't get any of the summary numbers to combine to give me that sum.
>>>>>
>>>>>
>>>>> In summary, we have no idea where we are.
>>>>>
>>>>> @Rafik Dammak <rafik.dammak at gmail.com>: I'd request to give this some
>>>>> priority as it affects not only our ability to understand which regions we
>>>>> should concentrate our efforts to engage new members, it gives us no
>>>>> information about which members are actually active since their
>>>>> registration and potentially skews internal procedures such as voting.
>>>>>
>>>>> Best,
>>>>> Jean F. Queralt
>>>>> Founder & CEO - The IO Foundation <https://TheIOFoundation.org>
>>>>> Book a meeting <https://TIOF.Click/BookJFQ> (30 minutes)
>>>>>
>>>>> *DISCLAIMER*
>>>>> *The content of this message, which may contain personal or sensitive
>>>>> data, is confidential. If you have received it by mistake, please inform
>>>>> the sender by replying to the email and then permanently delete the
>>>>> message, including any attachments. It is forbidden to copy, forward or in
>>>>> any way reveal the content of this message to anyone. The integrity and
>>>>> security of this email cannot be guaranteed over the Internet and,
>>>>> therefore, the sender will not be held liable for any damage caused by the
>>>>> message.*
>>>>>
>>>>
>>> *DISCLAIMER*
>>> *The content of this message, which may contain personal or sensitive
>>> data, is confidential. If you have received it by mistake, please inform
>>> the sender by replying to the email and then permanently delete the
>>> message, including any attachments. It is forbidden to copy, forward or in
>>> any way reveal the content of this message to anyone. The integrity and
>>> security of this email cannot be guaranteed over the Internet and,
>>> therefore, the sender will not be held liable for any damage caused by the
>>> message.*
>>>
>>
> *DISCLAIMER*
> *The content of this message, which may contain personal or sensitive
> data, is confidential. If you have received it by mistake, please inform
> the sender by replying to the email and then permanently delete the
> message, including any attachments. It is forbidden to copy, forward or in
> any way reveal the content of this message to anyone. The integrity and
> security of this email cannot be guaranteed over the Internet and,
> therefore, the sender will not be held liable for any damage caused by the
> message.*
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ncsg.is/pipermail/ncsg-ec/attachments/20241218/1411924c/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 23556 bytes
Desc: not available
URL: <http://lists.ncsg.is/pipermail/ncsg-ec/attachments/20241218/1411924c/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 31046 bytes
Desc: not available
URL: <http://lists.ncsg.is/pipermail/ncsg-ec/attachments/20241218/1411924c/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 30184 bytes
Desc: not available
URL: <http://lists.ncsg.is/pipermail/ncsg-ec/attachments/20241218/1411924c/attachment-0005.png>