October 3, 2009 at 19:35Electronic magazine, or the horrors of our town
For some time now I have been working as a deputy. Director of IT at a college in Moscow.
The work is interesting, but everyone has to deal with it.
I want to talk about one of the many state projects that I had to face.
I think many who at least out of the corner of their eyes read news in the IT field remember the story with the school portal. For those who don’t remember, here’s a wiki about how they successfully sawn 13,950,000 rubles and it all came to the surface thanks to blogs.
But everything flows, everything changes and for two years now there has been a live birth of the next cut, of which there is not a word in RuNet yet. It lives at the elegant address schoolinfo.educom.ru: 8080 and is called the "Electronic Journal" or more officially the "School Information System." It was formerly called “City School Information System 1.0” and lived here . To understand the seriousness of the problem, the expense of schools using this service goes to hundreds, if not thousands, of the system’s developer, called “E-school” www.e-school.ru , whose website is full of beautiful words about efficiency, long-term partnership and numerous GOST ah.
As you can see, you can enter there only with a username and password and the only possible IE browser, although the presence of this username and password does not guarantee entry, it is good if the system deigns to give you an error message, usually this does not happen if everything is correct after a few minutes expectations, we get inside the system. (Now I wanted to take screenshots for the post, the system showed prudence and logged in for 10 minutes). Alas, the screenshots will come later. I should note that this is not that the problem of logging into the system is the problem of performance in general, any interaction with the server entails a wait of 30 seconds to 10 minutes, the connection simply does not last longer, the transaction was successful or not, the user is left to guess .
Judging by the reviews of colleagues, the previous version still worked a year ago. Then, all users were forcibly hinted at migrating to version No. ... well, just a new version, simultaneously asking them to manually rewrite all the data for the past year, since the developers did not master the database conversion. Just re-drive all the teachers, all students, all grades and attendance of all students in all the lessons that are scattered (namely scattered) in the bowels of the system.
The technology platform is asp + .NET + mssql, in principle it is quite specific, but personally I don’t see anything particularly vicious in it.
What is the vice? I'll tell you about an elementary transaction. Suddenly, it turns out that the period of training students by some miracle was wrong, the students learn not from September 1, but from the 14th. Accordingly, from the 1st to the 14th we are not allowed to give ratings. Well, let's try to fix it. We take one student, delete his study period and create a new one for him. Yes, unfortunately his ratings and attendance were completely deleted. Well, well, to be expected. We reopen the class and find that attendance and grades of the entire class in which the child is studying also completely reset to zero. What to do with this ?! Yes, nothing special, just re-drive thousands of numbers and letters with your hands into the tablet. Thank God the system graciously allows us to export what we see on the screen (not data from all the tables) to excel, since this is implemented by a couple of lines on ASP. No liability for data security, system availability, etc. developers and support services of this system are not.
Honestly, there were a lot of ways to steal more data or the whole database (interestingly, is the data on other schools just as easy to reset?).
What one teacher or administrator sees in the grading tables may not at all coincide with what is visible from other accounts. I have not found a system in this yet.
Accordingly, any unsuccessful mouse click can lead to the loss of a large number of human hours for driving data again. There are no means of automated input, from the interfaces there is only a web interface with lags of 10 minutes, no backup, no responsibility, it is possible to save what you now see in Excel, so that it would be possible to drive in the data again. But this system still claims to manage money for dinners, taking into account the aisles, but just not ...
In a cursory glance, this thing is a bit more complicated than the school portal. If a school portal was made by a schoolchild within a week, then a student working on an electronic journal mastered ASP and at the same time even a month or two, unfortunately, even one hand tester did not have enough hands.
The list of “merits” can be continued for a long time, who was responsible for the visual design ?! Who randomly named the menu items. Yes, this is the same student who received the papers ... so I would like to find out how many millions of rubles, dollars, yen or what is sawn better there.
Alas, our teachers have already started to work with EJ by inertia, so it will be difficult for me to test it further, I’m sorry to recover the data, but what I encountered is enough for my eyes to start sending letters of the corresponding content and in the service note to demand refusal to use the system .
Are there any analogues? Yes, complete.
Do you want, use ballov.net online or try the services listed hereif you want - deploy a “NET school” (which we will most likely do) and ensure the data is safe and the solution is finished with a file. There are a lot of options, but the most dumb, inexorably predictable way was realized with state support.
In the end, please let me have some PR. Recently I have been blogging about the life of a professional IT specialist in a college in Moscow. If suddenly IT issues in educational institutions are not indifferent to you, then I invite you to read.
The work is interesting, but everyone has to deal with it.
I want to talk about one of the many state projects that I had to face.
I think many who at least out of the corner of their eyes read news in the IT field remember the story with the school portal. For those who don’t remember, here’s a wiki about how they successfully sawn 13,950,000 rubles and it all came to the surface thanks to blogs.
But everything flows, everything changes and for two years now there has been a live birth of the next cut, of which there is not a word in RuNet yet. It lives at the elegant address schoolinfo.educom.ru: 8080 and is called the "Electronic Journal" or more officially the "School Information System." It was formerly called “City School Information System 1.0” and lived here . To understand the seriousness of the problem, the expense of schools using this service goes to hundreds, if not thousands, of the system’s developer, called “E-school” www.e-school.ru , whose website is full of beautiful words about efficiency, long-term partnership and numerous GOST ah.
As you can see, you can enter there only with a username and password and the only possible IE browser, although the presence of this username and password does not guarantee entry, it is good if the system deigns to give you an error message, usually this does not happen if everything is correct after a few minutes expectations, we get inside the system. (Now I wanted to take screenshots for the post, the system showed prudence and logged in for 10 minutes). Alas, the screenshots will come later. I should note that this is not that the problem of logging into the system is the problem of performance in general, any interaction with the server entails a wait of 30 seconds to 10 minutes, the connection simply does not last longer, the transaction was successful or not, the user is left to guess .
Judging by the reviews of colleagues, the previous version still worked a year ago. Then, all users were forcibly hinted at migrating to version No. ... well, just a new version, simultaneously asking them to manually rewrite all the data for the past year, since the developers did not master the database conversion. Just re-drive all the teachers, all students, all grades and attendance of all students in all the lessons that are scattered (namely scattered) in the bowels of the system.
The technology platform is asp + .NET + mssql, in principle it is quite specific, but personally I don’t see anything particularly vicious in it.
What is the vice? I'll tell you about an elementary transaction. Suddenly, it turns out that the period of training students by some miracle was wrong, the students learn not from September 1, but from the 14th. Accordingly, from the 1st to the 14th we are not allowed to give ratings. Well, let's try to fix it. We take one student, delete his study period and create a new one for him. Yes, unfortunately his ratings and attendance were completely deleted. Well, well, to be expected. We reopen the class and find that attendance and grades of the entire class in which the child is studying also completely reset to zero. What to do with this ?! Yes, nothing special, just re-drive thousands of numbers and letters with your hands into the tablet. Thank God the system graciously allows us to export what we see on the screen (not data from all the tables) to excel, since this is implemented by a couple of lines on ASP. No liability for data security, system availability, etc. developers and support services of this system are not.
Honestly, there were a lot of ways to steal more data or the whole database (interestingly, is the data on other schools just as easy to reset?).
What one teacher or administrator sees in the grading tables may not at all coincide with what is visible from other accounts. I have not found a system in this yet.
Accordingly, any unsuccessful mouse click can lead to the loss of a large number of human hours for driving data again. There are no means of automated input, from the interfaces there is only a web interface with lags of 10 minutes, no backup, no responsibility, it is possible to save what you now see in Excel, so that it would be possible to drive in the data again. But this system still claims to manage money for dinners, taking into account the aisles, but just not ...
In a cursory glance, this thing is a bit more complicated than the school portal. If a school portal was made by a schoolchild within a week, then a student working on an electronic journal mastered ASP and at the same time even a month or two, unfortunately, even one hand tester did not have enough hands.
The list of “merits” can be continued for a long time, who was responsible for the visual design ?! Who randomly named the menu items. Yes, this is the same student who received the papers ... so I would like to find out how many millions of rubles, dollars, yen or what is sawn better there.
Alas, our teachers have already started to work with EJ by inertia, so it will be difficult for me to test it further, I’m sorry to recover the data, but what I encountered is enough for my eyes to start sending letters of the corresponding content and in the service note to demand refusal to use the system .
Are there any analogues? Yes, complete.
Do you want, use ballov.net online or try the services listed hereif you want - deploy a “NET school” (which we will most likely do) and ensure the data is safe and the solution is finished with a file. There are a lot of options, but the most dumb, inexorably predictable way was realized with state support.
In the end, please let me have some PR. Recently I have been blogging about the life of a professional IT specialist in a college in Moscow. If suddenly IT issues in educational institutions are not indifferent to you, then I invite you to read.