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
2015-11-13 2:37 GMT+02:00 Nuria Ruiz nuria@wikimedia.org:
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
On Thu, Nov 12, 2015 at 12:50 PM, Marcel Ruiz Forns mforns@wikimedia.org wrote:
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!
On Thu, Nov 12, 2015 at 8:23 PM, Amanda Bittaker <abittaker@wikimedia.org
wrote:
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
On Thu, Nov 12, 2015 at 10:18 AM, Edward Galvez egalvez@wikimedia.org wrote:
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 ---------- From: שי כץ shai@wikimedia.org.il Date: Thu, Nov 12, 2015 at 2:51 AM Subject: Re: Problem with user names in Hebrew - metrics To: Tighe Flanagan tflanagan@wikimedia.org Cc: Michal Lester mlester@wikimedia.org.il, Edward Galvez < egalvez@wikimedia.org>
Hi everyone, I spoke with Chen on the subject and that's what I understand: 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
2015-11-09 17:23 GMT+02:00 שי כץ shai@wikimedia.org.il:
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
2015-11-09 16:34 GMT+02:00 Tighe Flanagan tflanagan@wikimedia.org:
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 tflanagan@wikimedia.org education.wikimedia.org
On Mon, Nov 9, 2015 at 6:26 AM, Michal Lester < mlester@wikimedia.org.il> wrote:
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 Wikimetrics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikimetrics
Wikimetrics mailing list Wikimetrics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikimetrics
-- *Marcel Ruiz Forns* Analytics Developer Wikimedia Foundation
Wikimetrics mailing list Wikimetrics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikimetrics
