Hi.
I download FET last month .. IS GREAT.
Now send
1) my 1st timetable
2) a file Excel for import Fet file.
After use Fet, or another program, is better work in excel for little change
by
Marco
Thank you!
Do you agree to add this file to official FET distribution, as an example? No copyright problems?
What is your name, or your highschool's name, to add it in the THANKS section?
What name should the example file have? What is your city? From Italy?
I see that you worked hard on the Excel file, but I cannot open it in OpenOffice.org. Maybe others will tell us appreciations about this script. If you have a web page, maybe you can put it there for download with a description, and I will add it to Tools/Links section on FET web page.
Thanks a lot liceo for this this script
QuoteMaybe others will tell us appreciations about this script.
well here is some feedback for the script's athour
aA good script
I use it succefully to import my .fet file
I appreciate the globale time table fotr all teachers
(http://img338.imageshack.us/img338/7910/excelimporteritalianall.png)
However it deosnot support UTF
look at the weired characters represeting day's names
(http://img194.imageshack.us/img194/2372/excelimporteritaliannou.png)
Finally could please tell me how to translate it, ecause its interface is in italian
(http://img199.imageshack.us/img199/2381/excelimporteritalian.png)
QuoteHi.
I download FET last month .. IS GREAT.
Now send
1) my 1st timetable
2) a file Excel for import Fet file.
After use Fet, or another program, is better work in excel for little change
by
Marco
This script is great. Thank you very much.
Invio una versione appena aggiornata dall'autore. Ottimo e utile script. Bel lavoro, grazie! 8-)
mmm qualcosa non funziona. Io uso di solito open office e non riesco a farlo partire. Poi ho provato in una partizione con windows xp e excel 2007 e non mi apre il file fet formattato.
Qualche idea dell'errore che commetto?
Please wirte (also) in english language here. (Or change to italien board.)
I am not sure, i tranlated only with google. looks like you have a problem, but i can't understand your exact problem.
FET import to excel work only on excel, not in open office .. i use visualbasic (Excel) not java(openoffice) sorry :-)
remember load .fet file in <fet-results/timetables/YOURFILEFETsingle> .. not in <fet-results> !
usually in
C: ... Document and setting ... <yourusername> .. fet.results .. timetables .. <yournamefetfile>single
if had problem send your file in this forum section... convert in excel work in all excel version.
Hi all
Marco
The script in the first post give error message
Even the attached file liceo.fet, It cant import it :(
QuoteThe script in the first post give error message
I find that the first script and the new one (attached to my message, posted on 26.08.2010 at 08:25:30 - I forgot to write in english... :() work both well... 8-)
QuoteEven the attached file liceo.fet, It cant import it :(
Liceo.fet is a file that you find inside the archive with the first script. As
liceo told us, it is a data-file that you must run inside FET to obtain a timetable (It took near 20 minutes to find a timetable to me!). Then you may use the script to load the .fet file (and never the mere data-file) written by FET in the output directory.
One more thing: when you load the script inside Excel, you may get an error message due to the presence of macros in the file. You can set an option in Excel (my version had an alert and an easy option in a row in the upper side of the window) to accept those macros and read the script. :)
I hope this may help...
QuoteHi.
I download FET last month .. IS GREAT.
Now send
1) my 1st timetable
2) a file Excel for import Fet file.
After use Fet, or another program, is better work in excel for little change
by
Marco
Please add in the page "DOCENTI" and subjects for each class.Thanks in advance.
thanks for the script.
but why you used script to import the timetable !
only :
- click (with right botton in the mouse) on any "html" timetable in (timetable results folder) .
- choose "open with" then "calc" or "Excel" .
regards
Does anybody use this script by Liceo? It is interesting cause is supposed to be automatic and gives a complete comprehensive view of all teacher (that is usefull and should be integrated in FET along with Student, Teacher, Rooms)
I've found two bugs in this macro
1) It doesn't support activities with ID > 1500
2) It doesn't support activities without students
However it is very useful!
Hello everyone!
This is my first message in this forum. I use FET for few weeks now, to produce the timetable in the school I work. The only think I really miss in the output is the global teachers' timetable, as in this excel file, especially the worksheet named DOCENTI.
This script is really helpful, but I have a small problem. This macro stops at Modulo3, at this code (yellow line):
'----- classi
ncla = 0
t_a = aa$: t_i = "<Students_List>": t_f = "</Students_List>"
trovadati
percla = t_res
trovacla = InStr(percla, "<Name>")
indd = 0
Do While trovacla > 0
t_a = percla: t_i = "<Name>": t_f = "</Name>"
trovadati
If Len(t_res) > 1 Then
indd = indd + 1
classi(indd) = t_res
End If
percla = t_a
trovacla = InStr(percla, "<Name>")
If indd > 199 Then Stop
Loop
ncla = indd
'---
Does anyone has any idea how to correct this? I tried to change value 199 into something bigger, but no luck... :(
Thank you very much!
After looking a little bit at the VB code, I saw that it does not work when the number of subgroups > 200! I tried to raise it at 500, but then I get another error, about type incompatibility at some point. I don't know VB though, so it is difficult to find a solution :(
Probably it relies on number of groups on 8 bits (maximum 255).
Thanks for the reply.
Is there any other way to have a table where all teachers and their corresponding activities are shown? This is the only printout I miss from FET. Apart from that, although still a newbie in the program, your program is really good! Thanks for your efforts!
Quote
Is there any other way to have a table where all teachers and their corresponding activities are shown? This is the only printout I miss from FET.
I do not understand, I need to see an example.
There is teachers time vertical/horizontal, isn't it good for this? Or activities table?
Quote
I do not understand, I need to see an example.
There is teachers time vertical/horizontal, isn't it good for this? Or activities table?
The main results printout I need for my school is like the one attached. Is there a way to get something like this out of FET, in html or whatever other format (xls, ods)?
For activities per hour, I think there is no such possibility, maybe manually count in the activities timetable. For act/teacher, please see FET menu Statistics -> Export advanced statistics to disk, it may help. Or see FET menu, Statistics -> Teachers statistics, maybe you can copy/paste the table in a spreadsheet program.
QuoteFor activities per hour, I think there is no such possibility, maybe manually count in the activities timetable.
This is not important, I can easily do it manually.
QuoteFor act/teacher, please see FET menu Statistics -> Export advanced statistics to disk, it may help. Or see FET menu, Statistics -> Teachers statistics, maybe you can copy/paste the table in a spreadsheet program.
This is not so important either.
What interests me is a way to get the main part of the table, ie in each row (representing one teacher) to have all groups throughout the week. The bottom line (total activities per hour) and the last column (total activities per teacher) are easily found in the worksheet itself.
This excel import file does that. Unfortunately it does not work in my case, probably because the number of subgroups surpasses 200 (a limit in VB code of this file).
Maybe I was not so clear at first place...
Thanks again for any idea!
I thought that you have the table in FET, see attached image (teachers time horizontal in ~/fet-results/.../index.html).
QuoteI thought that you have the table in FET, see attached image (teachers time horizontal in ~/fet-results/.../index.html).
You are so right!!! I have not seen that! :-[
I wasted so much time digging the VB code and I haven't seen the obvious. Sorry for wasting your time as well. Now I understand why you replied only about the two sums in my previous post. 8-)
Now everything is fine for me. I open the *_teachers_time_horizontal.html in LibreOffice or Excel for simple formatting and calculating the things mentioned above...
FET really solved my case! Great work! Thanks for everything!
Kind regards from Greece!
You're welcome!
Ciao a tutti , sto utilizzando per la prima volta il programma FET. L'ho trovato molto utile e non ho avuto difficoltà per caricare i dati, però non riesco a scaricare l'orario nel formato execel, sono stata indirizzata in questo forum ma non ci sono ancora riuscita. Qualcuno potrebbe aiutarmi? Grazie
Quote from: liceo on August 17, 2009, 04:51:18 PMHi.
I download FET last month .. IS GREAT.
Now send
1) my 1st timetable
2) a file Excel for import Fet file.
After use Fet, or another program, is better work in excel for little change
by
Marco
Quote from: liceo on August 17, 2009, 04:51:18 PMHi.
I download FET last month .. IS GREAT.
Now send
1) my 1st timetable
2) a file Excel for import Fet file.
After use Fet, or another program, is better work in excel for little change
by
Marco
I download Fet and generate my first timetable
I download also the script posted by liceo. Unfortunatly when I try to import data from my .fet file, an error window appears "error di runtime 5"
Does anyone have any idea to solve the problem?
I guess liceo script can't handle the "newer" FET files or it isn't anymore compatibile with newer Excel versions.
Sadly liceo was the last time online in 2011. So more than 12 years ago.
I guess he won't read here in the forum anymore.
Maybe write him an email and ask him if he can answer in the forum.