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>