A program to convert the FET timetable XML results to Microsoft Excel, by Robert

[pervezshaikh]

In Tools/Links section, there is "A program to convert the FET timetable XML results to Microsoft Excel, by Roberto Trevisan". There should be a reserved section for its discussion. I this forum, there is a section <FET Tools>, where "TiTiTo - Tiny Timetabling Tool" discussion is available. I propose to create another discussion section for the subject.

[Volker Dirr]

Yes, maybe.
On the other hand there are not many questions about that tool and a moderator is also needed. I can't moderate questions for that tool.
Also we should be careful that there are not too many sections, since it become untidy by that. I must admit that i am currently not very happy with "Tips and Tricks" since:
a) nearly nobody use it
b) it is in fact similar to "Get help", the only difference is that the guy who ask the question also give the answer itself. So in my opinion "Get help" and "Tips and Tricks" should be merged.

I am also not very happy about "Galician / Galego", because that is also pretty unused. But i don't know a better solution yet. So it should stay. I just fear there might be over 100 languages later. Maybe we can do subsections than and only the continent is the main section.

But Liviu is in charge to decide that.

[Liviu Lalescu]

I will let you (Volker and other users) decide if we'll add a new board for "A program to convert the FET timetable XML results to Microsoft Excel, by Roberto Trevisan".

[Volker Dirr]

In my opinion:
As long as there is nobody moderating that new section: No.

The programm is also pretty simple. You can't do something wrong. In worst case there is the readme file.
You can only import a teachers xml. You can view and export the timetable and there is only one option (choosing the font).
The "bad" thing of the converter is that it can't handle students structes fine. You will only see the activities of the exact group. So it is like viewing the "Less detailed" html timetable, just that even the "???" mark is missing if there are several activities in that time slot.

Maybe we can just do it "sticky" in the help forum. (or more correct: in the "tips and tricks" forum, but i am note sure how many guys will read that if it is "only" there.)

[pervezshaikh]

I converted the <Even_Semester_CED_teachers.xml> by  <FETtoExcelExporter.exe> it showed me all things well. Then I exported the two files which are attached in zipped format. I tried to open them with Excel 2013. First dialogue said "We found a problem with some content in 'Even_Semester_Students.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes." I clicked Yes.
The file was open and second dialogue said "Excel was able to open the file by repairing or removing the unreadable contents.
Removed Part: /xl/sharedStrings.xml part with XML error.  (Strings) Illegal name character. Line 2, column 470." Further more the diague contained "Removed Records: Cell information from /xl/worksheets/sheet1.xml part
Removed Records: Cell information from /xl/worksheets/sheet2.xml part
Removed Records: Cell information from /xl/worksheets/sheet3.xml part
Removed Records: Cell information from /xl/worksheets/sheet4.xml part
Removed Records: Cell information from /xl/worksheets/sheet5.xml part
Removed Records: Cell information from /xl/worksheets/sheet6.xml part
Removed Records: Cell information from /xl/worksheets/sheet7.xml part
Removed Records: Cell information from /xl/worksheets/sheet8.xml part
Removed Records: Cell information from /xl/worksheets/sheet9.xml part
Removed Records: Cell information from /xl/worksheets/sheet10.xml part
Removed Records: Cell information from /xl/worksheets/sheet11.xml part
Removed Records: Cell information from /xl/worksheets/sheet12.xml part
Removed Records: Cell information from /xl/worksheets/sheet13.xml part
Removed Records: Cell information from /xl/worksheets/sheet14.xml part
Removed Records: Cell information from /xl/worksheets/sheet15.xml part
Removed Records: Cell information from /xl/worksheets/sheet16.xml part
Removed Records: Cell information from /xl/worksheets/sheet17.xml part"

There were 17 blank sheets.
I repeated with <Even_Semester_CED_Teachers.xlsx>.
The end result was same ie I got blank sheets.
The exe file has certain problems

[Volker Dirr]

Sadly i can't help you with that. I hope Roberto will read and help you.

BTW: Roberto published the source, but he didn't wrote about the license. So in fact I could read his source it, but am not allowed to modify (fix) it.  On the ohter hand it doens't matter too much since i don't have time to read fix his code.

[pervezshaikh]

I hope he would respond with in a month.

[pervezshaikh]

Volker!

Will you read a post of Liviu:
https://lalescu.ro/liviu/fet/forum/index.php?topic=2190.msg12407#msg12407

It clearly shows that source can be modified and reused. If you do not have enough time, ignore it.

[Volker Dirr]

ah. ok. i just done a very quick view on some files of the source. The bad thing is that i can't see if it is his source or if it is one of the libraries that are worth their distribution licenses (and i didn't read their licenses yet).

Groucho: I highly suggest to do it like nearly all other guys do it: write in the first lines of each source file the license. i also highly suggest to add the licenses of the libraries that you are using.