Hi
I am the author of the program to convert the XML file output from FET to Excel Workbook.
I open this post to allow all those who want to use it to report any bugs or ask for instructions on installing or using the program.
I hope it help.
Hello. First of all, thank you for the program. If I can get it to work, it may be extremely helpful. I am experiencing an issue though, when I run the program on my teachers.xml file. The program crashes in Windows ("FetToExcelExporter has stopped working"). The details are at the end of this post. I am using Win 7 64 bit. Thoughts?
Problem signature:
Problem Event Name: APPCRASH
Application Name: FETtoExcelExporter.exe
Application Version: 1.0.0.1
Application Timestamp: 55f039bb
Fault Module Name: MSVCR100.dll
Fault Module Version: 10.0.40219.325
Fault Module Timestamp: 4df2be1e
Exception Code: c0000005
Exception Offset: 00001fc8
OS Version: 6.1.7601.2.1.0.256.1
Locale ID: 2057
Additional Information 1: 0a9e
Additional Information 2: 0a9e372d3b4ad19135b953a78882e789
Additional Information 3: 0a9e
Additional Information 4: 0a9e372d3b4ad19135b953a78882e789
It will help him if you sent him a sample file.
OK thanks. Should I send him the XML file via personal message? Or should I copy and paste the text into a post in this thread?
PM is maybe a bad idea, because he was online the last time at 10 September 2015 and i am not sure if he turned on automatic Email notification if he got an PM.
Publishing the file a quote here is also bad.
I suggest to sent him by Email. Maybe also per PM, but then write here something like: "I sent you a PM. Please check it", because i might read it as an anonymous user (not logged in).
Quote from: panyadee on October 05, 2015, 01:45:34 AM
OK thanks. Should I send him the XML file via personal message? Or should I copy and paste the text into a post in this thread?
You can attach files to this post.
I am interest to try FetToExcelExporter. But I never succes to download this file from " http://lalescu.ro/liviu/fet/download/tools-links/roberto-travisan/FETtoExcelExporter%20Executable.zip"
I can download it on my computer (but I did not run it).
May FetToExcelExporter be open source or you want to keep it closed?
May be it will help for some derivative works wich I have in mind....
Davide.
Quote from: Davide Cottignoli on October 11, 2015, 09:09:11 AM
May FetToExcelExporter be open source or you want to keep it closed?
May be it will help for some derivative works wich I have in mind....
Davide.
It is free open source. See the readme.txt:
"
The program is free and the source can be modified and reused.
The program uses the libraries available on the Internet:
pugixml http://pugixml.org/
simplexlsx http://simplexlsx.sourceforge.net/
for these libraries are worth their distribution licenses
"
In http://lalescu.ro/liviu/fet/download/tools-links/roberto-travisan/ there is also the source.
Thank you Liviu,
I didn't see that.
Davide.
Because I have Mac OS X Lion (is quite old, I know), I need to compile it from source.
However I don't find any advice in the readme file by Roberto Trevisan.
Can someone help me?
Davide.
I do not know. Unfortunately, also, the original poster Groucho seems not to be active here any more. I'll write him an email to look on this thread.
Hello
First of all sorry for my English.
I'll try to answer your questions.
Crash of the Windows version: unfortunately are not able to answer without being able to experiment with the XML file that produces the error. You can contact me by a private message to which shall answer and send you my email address to which to send the XML file as an attachment that someone crash the application FetToExcelExporter.
Sources: the sources, as I tried to explain in the ReadMe.txt file attached to the distribution, can be downloaded for both Windows and Mac and can be rebuilt, modified to your liking. For public libraries: pugixml and simplexlsx, apply the user licenses present in the source or site of publication. The sources were compiled with Visual Studio 2010 on Windows and with XCode 5.2 on Mac.
Mac version: as I said sources are available that I compiled for XCode 5.2 under Yosemite but I recompiled for XCode 7 under El Capitain without problems. Unfortunately, they are not able to recompile for Mac Lion and, probably, some of the user interface should be reviewed on the basis of the functionality 'of controls available for Lion as, probably, the sources that deal with loading the XML file, processing, see results and export them to Excel can be used with minimal variations.
I hope I was helpful.
R. Trevisan
Salve
Prima di tutto scusatemi per il mio Inglese.
Cerchero di rispondere alle vostre domande.
Crash della versione Windows: putroppo non sono in grado di rispondere senza poter fare delle prove con il file xml che produce l'errore. Potete contattarmi tramite un messaggio privato al quale rispondero inviandovi il mio indirizzo di posta elettronica al quale spedire come allegato il file xml che manda in crash l'applicazione. Senza il file mi e' davvero difficile indovinare quale possa essere l'origine dell'errore.
Sorgenti: i sorgenti, come ho cercato di spiegare nel file ReadMe.txt allegato alla distribuzione, sono scaricabili sia per Windows che per Mac e possono essere ricompilati, modificati a vostro piacere. Per le librerie pubbliche: pugixml e simplexlsx, valgono le licenze d'uso presenti nei sorgenti o nei siti di pubblicazione. I sorgenti sono stati compilati con Visual Studio 2010 in ambiente Windows e XCode 5.2 in ambiente Mac.
Versione Mac: come ho detto sono disponibili i sorgenti che ho compilato per XCode 5.2 (Yosemite) ma che ho ricompilato anche per XCode 7 (El Capitain) senza alcuna modifica. Purtroppo non sono in grado di ricompilare per Mac Lion e, probabilmente, alcune parti dell'interfaccia utente vanno riviste in base alle funzionalita' dei controlli disponibili per Lion mentre, probabilmente, i sorgenti che si occupano di caricare il file xml, processarlo, visualizzare i rsultati ed esportali verso Excel possono essere impiegati con minime varianti.
Spero di essere stato d'aiuto.
R. Trevisan
Hello
First of all sorry for my poor English.
After a while, a new version of the FetToExcelExporter program is available.
Thanks to the CamilleC user, who sent me a sample, I solved the bug that caused the program crash due to incorrect sizing of a matrix.
There are no particular updates.
Given the problems encountered by some users I have available two versions of the executable program for Windows.
The first lighter version, FETtoExcelExporter Windows Executable.zip, requires the presence on your pc of the MFC100.dll currently present in Windows XP onwards.
The second, FETtoExcelExporter Windows Executable Static.zip,heaviest version, does not require the presence of MFC100.dll and should therefore work with all versions of Windows.
I remember that because of the restrictions introduced by Windows Vista on, the program must run in Administrator mode. If not, the program will not be able to successfully save the output files in Excel format.
The Mac version and compiled under Mac OSX Sierra with XCode 8.0. The first time you launch the program, you may see the message that the program itself is not certified (downloaded from the Internet?). To continue running, you must explicitly enable the execution.
Always in the Mac environment, when the file produced by FetToExcelExporter is loaded from some version of Excel, a style sheet formatting problem is reported. It's a problem I could not solve but can be safely ignored by continuing to load the file and save it with another name or overwrite it.
I hope I have been of help.
Notify me of any other errors.
Salve
Dopo qualche tempo e disponibile una nuova versione del programma FetToExcelExporter.
Grazie all'utente CamilleC, che mi ha inviato un file, ho risolto il bug che causava il crash del programma dovuto ad un errato dimensionamento di una matrice.
Non ci sono particolari aggiornamenti.
Visti i problemi incontrati da alcuni utenti ho messo a dispozione due versioni del programma eseguibile per Windows.
La prima versione, piu leggera, FETtoExcelExporter Windows Executable.zip, richiede la presenza sul vostro pc delle MFC100.dll usualmente presenti da Windows XP in poi.
La seconda versione, FETtoExcelExporter Windows Executable Static.zip, piu pesante, non richiede la presenza delle MFC100.dll e dovrebbe quindi funzionare con tutte le versioni di Windows.
Ricordo che, a causa delle restrizioni introdotte da Windows Vista in poi, il programma deve essere eseguito in modalita' amministratore. In caso contrario il programma non sara' in grado di salvare correttamente i file di output in formato Excel.
La versione per Mac e compilata sotto Mac OSX Sierra con XCode 8.0. La prima volta che viene lanciato il programma puo' comparire il messaggio che segnala che il programma stesso non e certificato (scaricato da Internet?). Per continuare l'esecuzione occorre esplicitamente abilitarne l'esecuzione.
Sempre in ambiente Mac, quando il file prodotto da FetToExcelExporter viene caricato da alcune versioni di Excel viene segnalato un problema relativo alla formattazione dei fogli di stile. E un problema che non sono riuscito a risolvere ma puo' essere tranquillamente ignorato continuando a caricare il file e salvandolo con altro nome o sovrscrivendolo.
Spero di essere stato d'aiuto. Segnalatemi altri eventuali errori.
I have try on Mac OS Sierra and the app crash when export file.
Provato con MAc OS Sierra e crassha quando esporti il file subito dopo aver indicato nome e luogo dove salvare il file. Aggiungo che se si cambia font viene una scritta del tipo null(0) dove normalmente c'รจ scritto il font.
Hi
I tried to change the font and save the file for Excel on my MacBook but did not match the reported issues.
Could you send me the file that generated the reported error?
Salve
Ho provato a modificare il font e salvare il file per Excel sul mio MacBook con MacOS Sierra ma non riscontro i problemi segnalati.
Potreste inviarmi il file che genera l'errore segnalato?
Groucho!
Will you look to following thread:
https://lalescu.ro/liviu/fet/forum/index.php?topic=3644.0
and give your feedback?
thank you sir for this great tool
i have been using it for more than two years
i only need one thing if you can add
please i want you sir to add "rooms to excel file""
because we have only ""teacher to excel file"" and ""students to excell file""
Roberto Trevisan just sent me his latest updates, including rooms' timetable. No Mac version, yet (only Windows). See https://lalescu.ro/liviu/fet/toolslinks.html
Roberto Trevisan just sent me updates to his tool. No Mac version. The user can choose what to print.
See https://lalescu.ro/liviu/fet/toolslinks.html
thank you very much both of you for all your time and effort
the idea of selection is very great indeed
however it looks the same problem persists
export the rooms (students only) but we find only subjects and teachers
for me what is very useful is to find in the excel sheet named (all rooms) the students only
Still there is a problem
Choosing export teacher's and only subjects this will give you the rooms
Choosing export teacher's and only rooms this will give you the students
Choosing export teacher's and only students this will give you the subjects
Choosing export students's and only teachers this will give you the rooms
Choosing export students's and only rooms this will give you the teachers
The only thing which sounds to work is :
Choosing export students's and only subjects this will give you the subjects (no problem)
Concerning the rooms what i realy find useful is :
The all rooms sheet must have only the students
Groucho sent me the hopefully corrected code. Please get the new version (1.0.0.4).
Thank you both of you
:)
Now it is working with great sucess
you did it and you did it great
I am glad it works! I will tell Groucho.
hello!
I have been using FETtoExcelExporter.
I hope the author receives this letter
Can the author help me to transfer the classes 10A1,10A2,10A3......10A10 and 11A1,11A2,.....11A10 and 12A1,....12A10
When I convert excel to:
10A1, 10A10, 10A11 and 11A1, 11A10,11A2....11A9 and 12A1,12A10,...12A9
And convert the layers to horizontal, vertical
hello
My class order is 10A1,10A2,10A3,10A4,10A5,10A6,10A7,10A8,10A9,10A10,10A11
FETtoExcelExporter:
10A1,10A10,10A11,10A2,10A3,10A4,10A5,10A6,10A7,10A8,10A9
As a workaround you might try to rename 10A1 into 10A01
thank you
how to FETtoExcelExporter according to this file
(https://i.imgur.com/6288up3.png)