Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
cesine opened this issue Nov 19, 2014 · 5 comments
Open

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

cesine opened this issue Nov 19, 2014 · 5 comments

Comments

@cesine
Copy link
Contributor

cesine commented Nov 19, 2014

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
@cesine cesine added this to the Teacher Dashboard Beta release milestone Nov 19, 2014
@cesine cesine assigned hisakonog and unassigned PhaedraRoyle Nov 19, 2014
@cesine cesine changed the title Modify/save sample class list using Mac English MS Excell Modify/save sample class list using Mac French MS Excell Nov 19, 2014
@hisakonog
Copy link
Member

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
Copy link
Member

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
Copy link
Member

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
Copy link
Contributor Author

cesine commented Nov 21, 2014

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
Copy link
Member

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants