The SIO2 project
  1. The SIO2 project
  2. SIO-2473

Invalid INDEX format in export submission

        Details

        • Type: Bug Bug
        • Status: Resolved Resolved
        • Priority: Major Major
        • Resolution: Fixed
        • Affects Version/s: TAG 2021/22 Winter Sprint
        • Fix Version/s: None
        • Component/s: OIOIOI
        • Labels:
          None
        • Sprint:
          TAG 2021/22 Summer Sprint 1

          Description

          After "Export submission" the format of INDEX file is invalid.
          Most columns are exported with binary string tag (see anonymized screenshot).
          UTF characters are exported in hex format.

          Expected behaviour:
          INDEX file that can be loaded to Excel or pandas.read_csv

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            Patrycja Krzyna added a comment -
            I couldn't reproduce it - files generated by my local instance look like this:

            submission_id,user_id,username,first_name,last_name,city,school,school_city,problem_short_name,score
            54,1,admin,,,NULL,NULL,NULL,sum,100
            55,2,uczestnik,Uczestnik,Testowy,NULL,NULL,NULL,sum,100
            56,2,uczestnik,Uczestnik,Testowy,NULL,NULL,NULL,sum,0

            I've also tried generating this file for a real contest on sio2.mimuw.edu.pl and it looks fine, too...
            Show
            Patrycja Krzyna added a comment - I couldn't reproduce it - files generated by my local instance look like this: submission_id,user_id,username,first_name,last_name,city,school,school_city,problem_short_name,score 54,1,admin,,,NULL,NULL,NULL,sum,100 55,2,uczestnik,Uczestnik,Testowy,NULL,NULL,NULL,sum,100 56,2,uczestnik,Uczestnik,Testowy,NULL,NULL,NULL,sum,0 I've also tried generating this file for a real contest on sio2.mimuw.edu.pl and it looks fine, too...
            Hide
            Permalink
            Gerrit Gerrit added a comment -
            Change oioioi~master~I94410256678ee02be421d0c56e5c4c103950d66d, patchset 1
            https://gerrit.sio2project.mimuw.edu.pl/3813

            SIO-2473 fixing broken INDEX format in exportszu

            Change-Id: I94410256678ee02be421d0c56e5c4c103950d66d
            Show
            Gerrit Gerrit added a comment - Change oioioi~master~I94410256678ee02be421d0c56e5c4c103950d66d, patchset 1 https://gerrit.sio2project.mimuw.edu.pl/3813 SIO-2473 fixing broken INDEX format in exportszu Change-Id: I94410256678ee02be421d0c56e5c4c103950d66d

              People

              • Assignee:
                Patrycja Krzyna
                Reporter:
                Tomek Waleń
                TAG Developer:
                Patrycja Krzyna
                TAG Reviewer:
                Tomek Waleń
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Agile