As I recall, this feature is now supported in 5.2 and later. I have installed 5.3.0. How do contestants access the sample input and output files? I looked in the places where I would expect to find it but did not see it, nor did I see it in the team manual.
Regards, Marc
Hi Marc,
They should be available on the problems page, but you may need to enable a config setting if I recall correctly. I'm without computer so I didn't check any of this.
Jaap
On November 9, 2017 9:02:37 AM GMT+01:00, Marc Furon marcf@dslextreme.com wrote:
As I recall, this feature is now supported in 5.2 and later. I have installed 5.3.0. How do contestants access the sample input and output files? I looked in the places where I would expect to find it but did not see it, nor did I see it in the team manual.
Regards, Marc
DOMjudge-devel mailing list DOMjudge-devel@domjudge.org https://www.domjudge.org/mailman/listinfo/domjudge-devel
Jaap Eldering wrote:
They should be available on the problems page, but you may need to enable a config setting if I recall correctly. I'm without computer so I didn't check any of this.
The only configuration setting I see is "show teams the diff output against the sample data?" I was looking for a setting that would actually allow them to download the files. If this is not available we have another way to provide that but I would like to know.
Also, I am trying to import team accounts with passwords. I used the format in the standards document, using the team names as the "Full Name". I get this SQL error when doing the import:
error: SQL error, Error#1452: Cannot add or update a child row: a foreign key constraint fails (`domjudge`.`user`, CONSTRAINT `user_ibfk_1` FOREIGN KEY (`teamid`) REFERENCES `team` (`teamid`) ON DELETE SET NULL), query: 'REPLACE INTO user SET `name` = "Big Ballers", `username` = "acm101", `password` = "$2y$10$ILEqS5X6w93RVQ/euA1UYeTKXseyUAK9efUnmMknnk5CPprWvCg/K", `teamid` = "acm101"'
Here are the first few lines of the team account file:
accounts 1 team Big Ballers acm101 password1 team Brain Dead Simple acm102 password2 team Kernel Sanders acm103 password3
The teams imported correctly and exist with the given names.
Regards, Marc
On 09/11/17 17:05, Marc Furon wrote:
Jaap Eldering wrote:
They should be available on the problems page, but you may need to enable a config setting if I recall correctly. I'm without computer so I didn't check any of this.
The only configuration setting I see is "show teams the diff output against the sample data?" I was looking for a setting that would actually allow them to download the files. If this is not available we have another way to provide that but I would like to know.
Ok, I checked: you don't need to change any configuration setting; the "show teams the diff output against the sample data?" is an extra setting that allows teams to view the diff (as the jury normally can) for the sample test cases when they click on a submission in the list on their team overview page.
When you tag test cases as "sample" on the test case page (linked from a problem page), then these will show up as downloadable on the team problems page (the link in the top menu), see attached screenshot. To be honest that interface is not very polished, but it should work.
Also, I am trying to import team accounts with passwords. I used the format in the standards document, using the team names as the "Full Name". I get this SQL error when doing the import:
Ok, thanks for the report! I don't have time to look into it now (maybe someone else can?) but will add an issue for it.
Jaap
error: SQL error, Error#1452: Cannot add or update a child row: a foreign key constraint fails (`domjudge`.`user`, CONSTRAINT `user_ibfk_1` FOREIGN KEY (`teamid`) REFERENCES `team` (`teamid`) ON DELETE SET NULL), query: 'REPLACE INTO user SET `name` = "Big Ballers", `username` = "acm101", `password` = "$2y$10$ILEqS5X6w93RVQ/euA1UYeTKXseyUAK9efUnmMknnk5CPprWvCg/K", `teamid` = "acm101"'
Here are the first few lines of the team account file:
accounts 1 team Big Ballers acm101 password1 team Brain Dead Simple acm102 password2 team Kernel Sanders acm103 password3
The teams imported correctly and exist with the given names.
Regards, Marc
DOMjudge-devel mailing list DOMjudge-devel@domjudge.org https://www.domjudge.org/mailman/listinfo/domjudge-devel
Hi Marc,
On 09/11/17 17:05, Marc Furon wrote:
Also, I am trying to import team accounts with passwords. I used the format in the standards document, using the team names as the "Full Name". I get this SQL error when doing the import:
error: SQL error, Error#1452: Cannot add or update a child row: a foreign key constraint fails (`domjudge`.`user`, CONSTRAINT `user_ibfk_1` FOREIGN KEY (`teamid`) REFERENCES `team` (`teamid`) ON DELETE SET NULL), query: 'REPLACE INTO user SET `name` = "Big Ballers", `username` = "acm101", `password` = "$2y$10$ILEqS5X6w93RVQ/euA1UYeTKXseyUAK9efUnmMknnk5CPprWvCg/K", `teamid` = "acm101"'
Here are the first few lines of the team account file:
accounts 1 team Big Ballers acm101 password1 team Brain Dead Simple acm102 password2 team Kernel Sanders acm103 password3
The teams imported correctly and exist with the given names.
On a second look: the problem is that your account file is not quite up to spec, and we're arguably not very fault tolerant in parsing it. According to the specification [1] a team account should be of the form "team-nnn" where nnn is a number with leading zeros. Our code doesn't recognize "acm101". This can be "fixed" by editing this line: https://github.com/DOMjudge/domjudge/blob/5.3/www/jury/impexp_tsv.php#L192
Clearly, we have to think of a more flexible way of dealing with this and implement better error handling.
Best, Jaap
[1] https://clics.ecs.baylor.edu/index.php/Contest_Control_System_Requirements#a...
Jaap Eldering wrote:
On a second look: the problem is that your account file is not quite up to spec, and we're arguably not very fault tolerant in parsing it. According to the specification [1] a team account should be of the form "team-nnn" where nnn is a number with leading zeros. Our code doesn't recognize "acm101".
Yes, I see that in the specification, although I don't know why the specification has to be that narrow for user IDs. I worked around the issue by importing the users as other types, then issuing SQL commands to convert them to team users and add the account to team relationships in the database. Everything seems to be there now.
I also now see where the sample input and output downloads are.
Marc
On November 10, 2017 8:37:40 AM GMT+01:00, Marc Furon marcf@dslextreme.com wrote:
Jaap Eldering wrote:
On a second look: the problem is that your account file is not quite up to spec, and we're arguably not very fault tolerant in parsing it. According to the specification [1] a team account should be of the form "team-nnn" where nnn is a number with leading zeros. Our code doesn't recognize "acm101".
Yes, I see that in the specification, although I don't know why the specification has to be that narrow for user IDs. I worked around the issue by importing the users as other types, then issuing SQL commands to convert them to team users and add the account to team relationships in the database. Everything seems to be there now.
I guess that specification is a bit of a relic from the past. It's based on the use case that systems would be able to import these as numeric IDs. I'm currently not even sure if we need this.
Jaap
I also now see where the sample input and output downloads are.
Marc
-
Jaap Eldering -
Marc Furon