FetToExcelExporter. A program to convert XML FET output files to Excel Workbook

[Groucho]

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.

[panyadee]

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?

Code Select Expand

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


[Volker Dirr]

It will help him if you sent him a sample file.

[panyadee]

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?

[Volker Dirr]

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).

[Liviu Lalescu]

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.

[ekawaluya]

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"

[Liviu Lalescu]

I can download it on my computer (but I did not run it).

[Davide Cottignoli]

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.

[Liviu Lalescu]

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.

[Davide Cottignoli]

Thank you Liviu,
I didn't see that.

Davide.

[Davide Cottignoli]

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.

[Liviu Lalescu]

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.

[Groucho]

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

[Groucho]

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.