On Sun, Nov 15, 2015 at 8:28 AM, שי כץ <shai@wikimedia.org.il> wrote:
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,NuriaOn 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,AmandaOn 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,Shai2015-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). 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 FlanaganManager, Wikipedia Education ProgramWikimedia FoundationOn 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, MichalRegards,
Michal Lester,
Executive Director
Wikimedia Israel972-50-8996046 ; 972-77-751-6032
בברכה,
שי כץ
רכזת הדרכה וחינוך
ויקימדיה ישראל
משרד: 077-3200796 | נייד: 054-4435834
http://www.wikimedia.org.il
--בברכה,
שי כץ
רכזת הדרכה וחינוך
ויקימדיה ישראל
משרד: 077-3200796 | נייד: 054-4435834
http://www.wikimedia.org.il
--Edward GalvezSurvey SpecialistLearning & EvaluationWikimedia 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 FornsAnalytics DeveloperWikimedia Foundation
_______________________________________________
Wikimetrics mailing list
Wikimetrics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikimetrics
--בברכה,
שי כץ
רכזת הדרכה וחינוך
ויקימדיה ישראל
משרד: 077-3200796 | נייד: 054-4435834
http://www.wikimedia.org.il
_______________________________________________
Wikimetrics mailing list
Wikimetrics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikimetrics