Thread "Open Document suites compatibility"
Tabs
-
Ilario Truppa | ilario.truppa | 22. Jul 2020, 10:08
Select
Open Document suites compatibilityIs there a specific reason why this marvelous software is not compatible with OpenOffice / Libreoffice?
ILIAS is open source and would be great to use this script with open source office suites too. -
Stanislav Wischniak | wischniak (Moderator) | 22. Jul 2020, 10:57
Select
Open Document suites compatibilityHello Ilario,
that's a good question. The code is written in VBA, which is created by Microsoft.
OO/LO does not support VBA, IMHO. It does support LibreOffice Basic.. which is different, though.
So we did not have any requests on adopting to OO/LO yet (this is the first one) and would be able to do this with some funding.
Regards,
Stanislav -
Deleted | 18. Aug 2020, 00:48
Select
Edited on: 19. Aug 2020, 01:50 - by DeletedOpen Document suites compatibilityAfter I playing with ILIAS since three months I have developend a libreoffice calc macro for import and manage user accounts. It is a young project but is running stable and usable for ILIAS 6 (tested with 6.1). The appended file have version 1.4. I am waiting for some ideas and bugfixes.
(appended file updated to version 1.6) -
Stanislav Wischniak | wischniak (Moderator) | 18. Aug 2020, 19:01
Select
Open Document suites compatibilityWow! Great job!
I've checked quickly the code so far, looks pretty good. Will check on it again after my vacation.
This would be a great alternative for unix and mac systems, I guess.
Best,
Stas -
Deleted | 19. Aug 2020, 01:49
Select
Open Document suites compatibilityToday I have made some futher optimizations with the LibreOffice Macro. And I added a small documentation about the columns. The appended file is version 1.6. -
Deleted | 19. Aug 2020, 23:10
Select
Open Document suites compatibilityToday I have added translations ("de" and "fr") to the LibreOffice Macro Dialogs.
The appended file is version 1.7. -
Deleted | 20. Aug 2020, 14:34
Select
Edited on: 20. Aug 2020, 14:49 - by DeletedOpen Document suites compatibilityHere is the next version 1.8 of this Libreoffice file with macro. I have added some modes about creating Loginnames and and a more simple (old) mode about creating Passwords. -
Stanislav Wischniak | wischniak (Moderator) | 7. May 2021, 12:08
Select
Open Document suites compatibilityHi Sven.
joo4mart is needed for this.
But just from the screenshot the error is about reading/writing the file.
Either something with the filename or maybe with the target path.
You could try to save your import file somewhere else and see if this works.
regards,
Stas -
Deleted | 7. May 2021, 12:58
Select
Open Document suites compatibilityHi Stas,
I think the solution is shown in the attachement. I'm not good with VBA, but now it works.
May be joo4mart has a smarter solution as mine :-)
Thanks for your comment and stay healthy
Rgds
Sven -
Deleted | 7. May 2021, 16:47
Select
Open Document suites compatibilityFinally I have LO 7.1.3 installied. While testing the basic macro (v1.8) generating XML I do not get any errors. It seems you really have a write problem, perhaps the path 'sFullPath' in line 784 is gone?
I will try to create an execption handling while writing to files. But that is not easy in Libreoffice/Basic. -
Deleted | 10. May 2021, 09:38
Select
Open Document suites compatibilityHello Joachim,
attached a screenshot with the output of your original variable sXmlFile. That makes no sense. Therefore I have modified the variable sXmlFile as you can see in line 792.
The same issue I have with your version 2.2.
Rgds
Sven -
Deleted | 7. May 2021, 16:51
Select
Open Document suites compatibilityIn March I have already created version 2.2 of the macro. So here is the updated LibreOffice Calc file with the updated macro.