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
            Patrycja Krzyna made changes -
            Field Original Value New Value
            Assignee Patrycja Krzyna [ pkrzyna ]
            Tomek Waleń made changes -
            Sprint TAG 2021/22 Summer Sprint 1 [ 8 ]
            Tomek Waleń made changes -
            Rank Ranked higher
            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
            Tomek Waleń made changes -
            Status New [ 10000 ] Resolved [ 5 ]
            Assignee Patrycja Krzyna [ pkrzyna ] Tomasz Waleń [ tomasz_walen ]
            Resolution Fixed [ 1 ]
            Tomek Waleń made changes -
            Assignee Tomasz Waleń [ tomasz_walen ] Tomek Waleń [ walen ]
            Tomek Waleń made changes -
            Assignee Tomek Waleń [ walen ] Patrycja Krzyna [ pkrzyna ]
            Tomek Waleń made changes -
            TAG Developer Patrycja Krzyna [ pkrzyna ]
            TAG Reviewer Tomek Waleń [ walen ]
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            New New Resolved Resolved
            		71d 12h 13m 1 Tomek Waleń 2022-03-23 9:03

              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