Discussion:
[Wikimetrics] Fwd: Problem with user names in Hebrew - metrics
Nuria Ruiz
2015-11-13 00:37:16 UTC
Permalink
Hello Michal and Shai,

When sending output please also send the cohort you are working with so we
can make sure we are able to repro this issue in our end.

Thanks,

Nuria
Hello Michal and Shai,
I've been looking into this problem and could not reproduce the error
within Wikimetrics. I created a cohort myself with Hebrew usernames,
executed a report on it and could retrieve the results normally (with
correct usernames). I also checked that the usernames in your cohorts are
stored correctly in Wikimetrics' DB.
It also seems to me that the problem may be in the tool you're using to
read the output file. Could you please send me the output file of your
report, please, so that I can check it? You can send it to my email instead
of the list, if you don't want it to be public.
Thanks!
Hello all,
It might also be an issue with the program you are using to open the
output file--I know I've had usernames turn into gibberish when I opened a
.csv output file containing cyrillic characters in Excel. I found Google
docs worked better in that case, for whatever reason.
Hope that helps!
Cheers,
Amanda
Hello!
There seems to be a problem with the output files in hebrew. There are
reports (see below) that the information is coming out as gibberish. It
sounds like Wikimetrics is accepting the usernames fine, but the output is
bad. Might it be the browser or is this an internal problem? They did not
specify which output (CSV or JSON) is having the problem.
Michal and Shai - you need to be part of the mailing list in order to
reply with any more info.
Thanks!
Edward
---------- Forwarded message ----------
Date: Thu, Nov 12, 2015 at 2:51 AM
Subject: Re: Problem with user names in Hebrew - metrics
Hi everyone,
The problem is in the output file. There's no problem with the cohort as
a whole, but only with extracting data on specific users whose names are
written in Hebrew.
We were able to extract data for all the specific users, but in the user
name column, names in Hebrew appear in gibberish. As a result, in the case
of users whose names are written in Hebrew, we cannot link the numerical
data to the specific users to which it relates.
Tighe, does it happen also in the case of Arabic?
Thanks a lot,
Shai
Hi Tighe,
Thanks for the quick and helpful response.
Our metrics expert is Chen Spector. She is supposed to be in the office
on Wednesday/ Thursday. We will consult her and then will be able to
reply better.
Greetings from Israel,
Shai
Hi Michal,
I just did a quick test with some cohorts with Arabic script and it's
working in that case. Can you tell us a bit more about the steps you're
taking and where it's breaking? Is it a new cohort? Are the usernames
validating properly?
Are you uploading a CSV or pasting in usernames in the text box? I've
seen people have issues with the upload if the file has the wrong character
set/language encryption in the file itself. Make sure it's Unicode UTF-8.
Alternatively, I've had most success copying usernames from the source file
and pasting into the text box when uploading a new cohort. It removes the
character set issue.
If this is from an existing cohort and the results are illegible
because of character coding issues, I'd reach out to the Analytics mailing
list (listed on the support page of the Metrics tool
<https://metrics.wmflabs.org/support>). They're quite responsive, and
perhaps there's an issue they've been working on that has impacted your
results unknowingly, and they'll want to know exactly what you're doing and
what's breaking so they can troubleshoot.
Hope this helps!
Tighe
--
Tighe Flanagan
Manager, Wikipedia Education Program
Wikimedia Foundation
education.wikimedia.org
Hi Edward,
I hope this email finds you well.
We have problems with user names in Hebrew when using them in the
metrics. They became list of symbols. When we what to compare the results
to the user name it is impossible.
What do you do in other cases?
Thank you, Michal
*Regards,*
*Michal Lester,*
*Executive DirectorWikimedia Israel*
*http://www.wikimedia.org.il <http://www.wikimedia.org.il/> *
*972-50-8996046 ; 972-77-751-6032 *
*[image: תמונה מוטבעת 3]*
--
*בב׹כה,*
*שי כץ *
*ךכזת הד׹כה וחינוךויקימדיה ישךאל*
משךד: 077-3200796 | נייד: 054-4435834
http://www.wikimedia.org.il
[image: תמונה מוטבעת 3]
--
*בב׹כה,*
*שי כץ *
*ךכזת הד׹כה וחינוךויקימדיה ישךאל*
משךד: 077-3200796 | נייד: 054-4435834
http://www.wikimedia.org.il
[image: תמונה מוטבעת 3]
--
Edward Galvez
Survey Specialist
Learning & Evaluation
Wikimedia Foundation
_______________________________________________
Wikimetrics mailing list
https://lists.wikimedia.org/mailman/listinfo/wikimetrics
_______________________________________________
Wikimetrics mailing list
https://lists.wikimedia.org/mailman/listinfo/wikimetrics
--
*Marcel Ruiz Forns*
Analytics Developer
Wikimedia Foundation
_______________________________________________
Wikimetrics mailing list
https://lists.wikimedia.org/mailman/listinfo/wikimetrics
שי כץ
2015-11-15 16:28:53 UTC
Permalink
Hello all,


Thank you so much for the quick response and suggestions.

Amadna – your suggestion was very helpful. It turns out that indeed the
issue was the program we were using to open the csv output file. We changed
it from Microsoft Excel to Google docs and the problem was solved.


So guys - thanks again, you helped us very much!


Shai
Post by Nuria Ruiz
Hello Michal and Shai,
When sending output please also send the cohort you are working with so we
can make sure we are able to repro this issue in our end.
Thanks,
Nuria
Post by Nuria Ruiz
Hello Michal and Shai,
I've been looking into this problem and could not reproduce the error
within Wikimetrics. I created a cohort myself with Hebrew usernames,
executed a report on it and could retrieve the results normally (with
correct usernames). I also checked that the usernames in your cohorts are
stored correctly in Wikimetrics' DB.
It also seems to me that the problem may be in the tool you're using to
read the output file. Could you please send me the output file of your
report, please, so that I can check it? You can send it to my email instead
of the list, if you don't want it to be public.
Thanks!
Hello all,
It might also be an issue with the program you are using to open the
output file--I know I've had usernames turn into gibberish when I opened a
.csv output file containing cyrillic characters in Excel. I found Google
docs worked better in that case, for whatever reason.
Hope that helps!
Cheers,
Amanda
Hello!
There seems to be a problem with the output files in hebrew. There are
reports (see below) that the information is coming out as gibberish. It
sounds like Wikimetrics is accepting the usernames fine, but the output is
bad. Might it be the browser or is this an internal problem? They did not
specify which output (CSV or JSON) is having the problem.
Michal and Shai - you need to be part of the mailing list in order to
reply with any more info.
Thanks!
Edward
---------- Forwarded message ----------
Date: Thu, Nov 12, 2015 at 2:51 AM
Subject: Re: Problem with user names in Hebrew - metrics
Hi everyone,
The problem is in the output file. There's no problem with the cohort
as a whole, but only with extracting data on specific users whose names are
written in Hebrew.
We were able to extract data for all the specific users, but in
the user name column, names in Hebrew appear in gibberish. As a result, in
the case of users whose names are written in Hebrew, we cannot link
the numerical data to the specific users to which it relates.
Tighe, does it happen also in the case of Arabic?
Thanks a lot,
Shai
Hi Tighe,
Thanks for the quick and helpful response.
Our metrics expert is Chen Spector. She is supposed to be in the
office on Wednesday/ Thursday. We will consult her and then will be able to
reply better.
Greetings from Israel,
Shai
Hi Michal,
I just did a quick test with some cohorts with Arabic script and it's
working in that case. Can you tell us a bit more about the steps you're
taking and where it's breaking? Is it a new cohort? Are the usernames
validating properly?
Are you uploading a CSV or pasting in usernames in the text box? I've
seen people have issues with the upload if the file has the wrong character
set/language encryption in the file itself. Make sure it's Unicode UTF-8.
Alternatively, I've had most success copying usernames from the source file
and pasting into the text box when uploading a new cohort. It removes the
character set issue.
If this is from an existing cohort and the results are illegible
because of character coding issues, I'd reach out to the Analytics mailing
list (listed on the support page of the Metrics tool
<https://metrics.wmflabs.org/support>). They're quite responsive,
and perhaps there's an issue they've been working on that has impacted your
results unknowingly, and they'll want to know exactly what you're doing and
what's breaking so they can troubleshoot.
Hope this helps!
Tighe
--
Tighe Flanagan
Manager, Wikipedia Education Program
Wikimedia Foundation
education.wikimedia.org
On Mon, Nov 9, 2015 at 6:26 AM, Michal Lester <
Hi Edward,
I hope this email finds you well.
We have problems with user names in Hebrew when using them in the
metrics. They became list of symbols. When we what to compare the results
to the user name it is impossible.
What do you do in other cases?
Thank you, Michal
*Regards,*
*Michal Lester,*
*Executive DirectorWikimedia Israel*
*http://www.wikimedia.org.il <http://www.wikimedia.org.il/> *
*972-50-8996046 ; 972-77-751-6032 *
*[image: תמונה מוטבעת 3]*
--
*בב׹כה,*
*שי כץ *
*ךכזת הד׹כה וחינוךויקימדיה ישךאל*
משךד: 077-3200796 | נייד: 054-4435834
http://www.wikimedia.org.il
[image: תמונה מוטבעת 3]
--
*בב׹כה,*
*שי כץ *
*ךכזת הד׹כה וחינוךויקימדיה ישךאל*
משךד: 077-3200796 | נייד: 054-4435834
http://www.wikimedia.org.il
[image: תמונה מוטבעת 3]
--
Edward Galvez
Survey Specialist
Learning & Evaluation
Wikimedia Foundation
_______________________________________________
Wikimetrics mailing list
https://lists.wikimedia.org/mailman/listinfo/wikimetrics
_______________________________________________
Wikimetrics mailing list
https://lists.wikimedia.org/mailman/listinfo/wikimetrics
--
*Marcel Ruiz Forns*
Analytics Developer
Wikimedia Foundation
_______________________________________________
Wikimetrics mailing list
https://lists.wikimedia.org/mailman/listinfo/wikimetrics
--
*בב׹כה,*


*שי כץ *
*ךכזת הד׹כה וחינוךויקימדיה ישךאל*

משךד: 077-3200796 | נייד: 054-4435834
http://www.wikimedia.org.il

[image: תמונה מוטבעת 3]
Amanda Bittaker
2015-11-19 21:12:36 UTC
Permalink
Glad to hear it helped, and glad to have you on the list now!

All the best,
Amanda
Hello all,
Thank you so much for the quick response and suggestions.
Amadna – your suggestion was very helpful. It turns out that indeed the
issue was the program we were using to open the csv output file. We
changed it from Microsoft Excel to Google docs and the problem was solved.
So guys - thanks again, you helped us very much!
Shai
Post by Nuria Ruiz
Hello Michal and Shai,
When sending output please also send the cohort you are working with so
we can make sure we are able to repro this issue in our end.
Thanks,
Nuria
Hello Michal and Shai,
I've been looking into this problem and could not reproduce the error
within Wikimetrics. I created a cohort myself with Hebrew usernames,
executed a report on it and could retrieve the results normally (with
correct usernames). I also checked that the usernames in your cohorts are
stored correctly in Wikimetrics' DB.
It also seems to me that the problem may be in the tool you're using to
read the output file. Could you please send me the output file of your
report, please, so that I can check it? You can send it to my email instead
of the list, if you don't want it to be public.
Thanks!
Hello all,
It might also be an issue with the program you are using to open the
output file--I know I've had usernames turn into gibberish when I opened a
.csv output file containing cyrillic characters in Excel. I found Google
docs worked better in that case, for whatever reason.
Hope that helps!
Cheers,
Amanda
Hello!
There seems to be a problem with the output files in hebrew. There are
reports (see below) that the information is coming out as gibberish. It
sounds like Wikimetrics is accepting the usernames fine, but the output is
bad. Might it be the browser or is this an internal problem? They did not
specify which output (CSV or JSON) is having the problem.
Michal and Shai - you need to be part of the mailing list in order to
reply with any more info.
Thanks!
Edward
---------- Forwarded message ----------
Date: Thu, Nov 12, 2015 at 2:51 AM
Subject: Re: Problem with user names in Hebrew - metrics
Hi everyone,
The problem is in the output file. There's no problem with the cohort
as a whole, but only with extracting data on specific users whose names are
written in Hebrew.
We were able to extract data for all the specific users, but in
the user name column, names in Hebrew appear in gibberish. As a result, in
the case of users whose names are written in Hebrew, we cannot link
the numerical data to the specific users to which it relates.
Tighe, does it happen also in the case of Arabic?
Thanks a lot,
Shai
Hi Tighe,
Thanks for the quick and helpful response.
Our metrics expert is Chen Spector. She is supposed to be in the
office on Wednesday/ Thursday. We will consult her and then will be able to
reply better.
Greetings from Israel,
Shai
Hi Michal,
I just did a quick test with some cohorts with Arabic script and it's
working in that case. Can you tell us a bit more about the steps you're
taking and where it's breaking? Is it a new cohort? Are the usernames
validating properly?
Are you uploading a CSV or pasting in usernames in the text box? I've
seen people have issues with the upload if the file has the wrong character
set/language encryption in the file itself. Make sure it's Unicode UTF-8.
Alternatively, I've had most success copying usernames from the source file
and pasting into the text box when uploading a new cohort. It removes the
character set issue.
If this is from an existing cohort and the results are illegible
because of character coding issues, I'd reach out to the Analytics mailing
list (listed on the support page of the Metrics tool
<https://metrics.wmflabs.org/support>). They're quite responsive,
and perhaps there's an issue they've been working on that has impacted your
results unknowingly, and they'll want to know exactly what you're doing and
what's breaking so they can troubleshoot.
Hope this helps!
Tighe
--
Tighe Flanagan
Manager, Wikipedia Education Program
Wikimedia Foundation
education.wikimedia.org
On Mon, Nov 9, 2015 at 6:26 AM, Michal Lester <
Hi Edward,
I hope this email finds you well.
We have problems with user names in Hebrew when using them in the
metrics. They became list of symbols. When we what to compare the results
to the user name it is impossible.
What do you do in other cases?
Thank you, Michal
*Regards,*
*Michal Lester,*
*Executive DirectorWikimedia Israel*
*http://www.wikimedia.org.il <http://www.wikimedia.org.il/> *
*972-50-8996046 ; 972-77-751-6032 *
*[image: תמונה מוטבעת 3]*
--
*בב׹כה,*
*שי כץ *
*ךכזת הד׹כה וחינוךויקימדיה ישךאל*
משךד: 077-3200796 | נייד: 054-4435834
http://www.wikimedia.org.il
[image: תמונה מוטבעת 3]
--
*בב׹כה,*
*שי כץ *
*ךכזת הד׹כה וחינוךויקימדיה ישךאל*
משךד: 077-3200796 | נייד: 054-4435834
http://www.wikimedia.org.il
[image: תמונה מוטבעת 3]
--
Edward Galvez
Survey Specialist
Learning & Evaluation
Wikimedia Foundation
_______________________________________________
Wikimetrics mailing list
https://lists.wikimedia.org/mailman/listinfo/wikimetrics
_______________________________________________
Wikimetrics mailing list
https://lists.wikimedia.org/mailman/listinfo/wikimetrics
--
*Marcel Ruiz Forns*
Analytics Developer
Wikimedia Foundation
_______________________________________________
Wikimetrics mailing list
https://lists.wikimedia.org/mailman/listinfo/wikimetrics
--
*בב׹כה,*
*שי כץ *
*ךכזת הד׹כה וחינוךויקימדיה ישךאל*
משךד: 077-3200796 | נייד: 054-4435834
http://www.wikimedia.org.il
[image: תמונה מוטבעת 3]
_______________________________________________
Wikimetrics mailing list
https://lists.wikimedia.org/mailman/listinfo/wikimetrics
Loading...