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

Wed Dec 18 12:57:06 EET 2024

There may be a CSV export feature somewhere... though I'm try to find it.
What I did was test a copy & paste and it worked.

Will build the spreadsheet and share.

Jean

On Wed, Dec 18, 2024, 18:41 Rafik Dammak <rafik.dammak at gmail.com> wrote:

> 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.*
>>
>

-- 
**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/b0afa277/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/b0afa277/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/b0afa277/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/b0afa277/attachment-0005.png>