search

ProjetDeRechercheSurLecriture / DyslexDisorthGame

This repository contains the OpenSource code base for PRÉ (Projet de Recherche sur l’Écriture) http://www.medicine.mcgill.ca/srvachew/ http://phaedraroylelab.ca/
3 stars 4 forks source link

Modify/save sample class list using Mac French MS Excell #231

Open cesine opened 10 years ago

cesine commented 10 years ago

Open this url https://github.com/ProjetDeRechercheSurLecriture/DyslexDisorthGame/blob/master/angular_client/app/sample/eleves_template_point_virgule_mac.csv

  1. Click on the edit icon (see animated gif for instructions)
  2. Find a way to open the information in Mac French Microsoft Excel (either by opening it, and then editing the accents so that they are correct, or by copy pasting each cell into Excel)
  3. Save the file on your computer using the MS Excel file save as menu (Save as .csv)
  4. Open the file in a plain text editor, Paste the text into the github page
hisakonog commented 10 years ago

Disclaimer: I don't really trust that my Excel is actually set to French. After I changed the language setting, I opened the csv from #222 (which I downloaded last Friday) to make sure it recognizes virgule as columns, and it did. However, when I re-downloaded the same file from #222 and opened it, everything was opened in one column, and there is no virgule but it was comma. I don't know why this happened, unless you have changed the csv at http://app.phophlo.ca/sample/eleves_template.csv since last Friday.

hisakonog commented 10 years ago

Copy-pasted the sample csv to supposedly (but not certainly) set-to-French Excel. Save as Windows CSV and opened in TextEdit. Result:

Code Permanent;N∞ section;PrÈnom;Nom de famille;Date de naissance migm740610ea;212;Marius;Mignon;2010-06-12 rega665319is;212;Amelie;Regnault;2010-03-04 sica761209om;212;Armande;Sicard;2009-12-14 thic665310ke;212;Corine;Thiebaud;2010-03-04 voia685310ks;212;Alfredine;Voirin;2010-03-06

capture d ecran 2014-11-20 a 18 23 24

I guess Excel is in fact set to French as there are virgule au lieu de comma.

hisakonog commented 10 years ago

Saved as simple csv. TextEdit opens it without corrupting the accents. And it's virgule-separated screen shot 2014-11-20 at 19 56 17 .

cesine commented 10 years ago 
unless you have changed the csv at http://app.phophlo.ca/sample/eleves_template.csv since last Friday.

yes in fact, we did :) we put the ; version there only temporarlily as a patch. http://app.phophlo.ca/sample/eleves_template.csv has only , and is in UTF-8 and there are 4 new files point virgule which has the ; for mac, windows and , for mac, windows

hisakonog commented 10 years ago

ok, then I think my temporary French Excel is reliable.