Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-13658

Import/export csv roundtrip fails for accounts with leading zeros

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.5.0, 2.5.2, 2.5.3, 2.6.0
    • Fix Version/s: None
    • Component/s: Gradebook Classic
    • Labels:
      None

      Description

      If you have a site with student users who have leading zeros in their usernames (eids), e.g. "001234", when you export this to a CSV and import into Excel (e.g. Office 2003), Excel converts the usernames into numbers (even if they are quote-delimited).

      When you save this again as a CSV, the username is saved without leading zeros meaning it cannot be imported.

      The only solution to this Excel issue seems to be to have Gradebook provide an export option in .xls format, with the usernames exported as string-formatted cells.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  Unassigned Unassigned
                  Reporter:
                  smarquard Stephen Marquard
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  0 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration