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 English MS Excell #232

Open cesine opened 9 years ago

cesine commented 9 years ago

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

  1. Click on the edit icon
  2. Find a way to open the information in Mac English 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 9 years ago

(I removed the gif cuz it was crashing the screen)

copy-pasted the sample data into English Excel. Excel has two "save as csv" options. Here is Save as Windows CSV (I think many people will use this option).

  1. Save as Windows CSV
  2. Open the saved CSV file with Mac's 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

screen shot 2014-11-20 at 16 55 21

When opened with Sublime and with R, accent showed up normal (but teachers won't use Sublime or R). screen shot 2014-11-20 at 17 19 54 screen shot 2014-11-20 at 17 20 43

hisakonog commented 9 years ago
  1. Save as MS-DOS CSV (teachers won't use thins option! but just in case)
  2. Open the saved file with 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

screen shot 2014-11-20 at 16 58 35

Opening it with Sublime and R also messes up the accent. This may be irrelevant but I thought it's interesting...

screen shot 2014-11-20 at 17 22 29 screen shot 2014-11-20 at 17 22 54

hisakonog commented 9 years ago

Ok there is an option to save as just csv. TextEdit opens it without corrupting the accent. screen shot 2014-11-20 at 19 54 41