example_csv.html 1.4 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. <HTML>
  2. <HEAD>
  3. <TITLE>CSV file example</TITLE>
  4. </HEAD>
  5. <BODY>
  6. <h1>CSV example for certificate importation</h1>
  7. This is an example file and this data can't be imported on your platform. The user id must correspond to users existing on your platform.</br>
  8. The mandatory fields are emphasized. The other fields can be omitted. The separator is always the ";". If you want to overwrite the scores, you must choose the "Overwrite score" option.</br>
  9. <h2>Complete CSV score importation file</h2>
  10. <b>username</b>;official_code;<b>lastname</b>;<b>firstname</b>;<b>score</b>;date</br>
  11. <b>bgate</b>;bgate;Gate;Bill;<b>2</b>;02/25/09 12:24 PM</br>
  12. <b>ltorvald</b>;ltorvald;Torvald;Linus;<b>10</b>;02/25/09 12:24 PM</br>
  13. <b>jsmith</b>;;<b>Smith</b>;<b>John</b>;<b>3</b>;</br>
  14. </br></br>
  15. <h2>Minimal CSV score importation file</h2>
  16. This is possible to use a minimal file if you choose the "Ingnore error option" :
  17. </br></br>
  18. username;score</br>
  19. bgate;2</br>
  20. ltorvald;10</br>
  21. jsmith;3</br>
  22. <h2>Presence score importation file</h2>
  23. For the presence this is the same file except the score fied which is "0" for absent and "1" for present :
  24. </br></br>
  25. <b>username</b>;official_code;<b>lastname</b>;<b>firstname</b>;<b>score</b>;date</br>
  26. <b>bgate</b>;bgate;Gate;Bill;<b>0</b>;02/25/09 12:24 PM</br>
  27. <b>ltorvald</b>;ltorvald;Torvald;Linus;<b>1</b>;02/25/09 12:24 PM</br>
  28. <b>jsmith</b>;;<b>Smith</b>;<b>John</b>;<b>0</b>;</br>
  29. </BODY>