[libreoffice-users] Re: trying to integrate oracle forms with libreoffice
I have ended finding another solution for this. As OLE is a Microsoft Windows technology connecting LibreOffice with Oracle Form through it will only work on Windows. To build a Linux compatible solution required another focus so after thinking a bit I found that using jopendocument (http://www.jopendocument.org/) to do the job would be very nice and portable. the problem with this is that jopendocument's api is too much large to build a component wrapper for it in Oracle Forms in a quick time so I thought about wrapping it with another more simple thing and wrap that final component in Oracle Forms At the end I have build a wrapper for beanshell (http://www.beanshell.org/) which is very simple and with it I do the calls to jopendocument. the code and a sample of integration with jopendocument is here if anybody wants to use it: http://sourceforge.net/projects/oformsbeanshell/ best regards -- View this message in context: http://nabble.documentfoundation.org/trying-to-integrate-oracle-forms-with-libreoffice-tp4068433p4071222.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: trying to integrate oracle forms with libreoffice
Hi at the end I could made this work, the integration between libreoffice and webutil fails for two reasons: -there was no an adequate procedure for passing arrays as call arguments -the version of the jacob java library which comes with oracle forms 10gR2 was very old and doesn't support passing a arrays as arguments I made a small component similar to webutil which uses a newer jacob library and implements the call for passing arrays as arguments. I have done some basic testing (open a new document a save it with some text) and it works. I can't make the code public as the code is derived from Oracle code which comes with the Oracle Forms server but if anybody needs it I can send it in a private message best regards -- View this message in context: http://nabble.documentfoundation.org/trying-to-integrate-oracle-forms-with-libreoffice-tp4068433p4069830.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: trying to integrate oracle forms with libreoffice
libreofffice works well with ole, you can test it with the script in this page: http://www.openoffice.org/udk/common/man/tutorial/office_automation.html the problem is that the libreoffice's api is not the same as the one of m. office so you must adapt the ole calls to do the work with libreoffice. this is not a lot of work if you have already worked a bit with libreoffice macros, some months ago I adapted an app which did the calls with jscript in this way and was quite easy the problem happens when the calls are inside a closed source component (probably your situation) or you have an obscure mediator component (my situation) regards -- View this message in context: http://nabble.documentfoundation.org/trying-to-integrate-oracle-forms-with-libreoffice-tp4068433p4068516.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] trying to integrate oracle forms with libreoffice
hi In my organization we have some applications built with oracle forms which generate .doc and .xls documents, as we are migrating to LibreOffice we are trying to remove the office suite from the pc's but the users with these applications can't make the switch. the problem is that oracle forms generates the documents in the client using ole2 calls (https://en.wikipedia.org/wiki/Object_Linking_and_Embedding) to the office suite through a component called webutil (http://www.oracle.com/technetwork/developer-tools/forms/webutil-090641.html) ole2 is well supported by libreoffice so in theory the connection from oracle forms to libreoffice through webutil is possible: http://wiki.openoffice.org/wiki/Documentation/DevGuide/ProUNO/Bridge/Automation_Bridge the problem is that it seems that the webutil component was developed only with the microsoft office suite in mindand there is not guarantee to it functioning well with other suites: https://forums.oracle.com/message/4190690#4190690 has anybody faced this problem before? is possible to make libreoffice work with webutil or there is another similar component already developed with the same funcionality? thanks -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular document
in situations like this, independently of the work to be done to make libreoffice capable of opening those files you can use a version of microsoft office which supports odf to convert the file to odt. this can be an effective workaround I attach you the converted file (using microsoft office 2013). you can use these software to do the conversion from a shell: http://code.officeshots.org/trac/officeshots/browser/trunk/OfficeConvert I attach also a bat file which can help to automatize the conversion process best regards Al 12/02/2013 13:29, En/na C. H. D. ha escrit: Hello! Do I support LibreOffice? Yes, I do. Let me show some positive numbers: When I downloaded 400 .doc files, I opened 399 files in LibreOffice. Only 1 could not be opened. All 400 files were smaller than or equal to 692.5 KB. I started the testing from the smallest file to the largest file. It happened to be that I could not open that one file which was 692.5 KB. I am not a Maths expert. 399/400 = 99.75% Congratulations! This is excellent! Well done. To make a rough conclusion, I claim in a reasonable way that LibreOffice can open 99.75% of the .doc files I may come across in future if these files are smaller than 700KB. I do not know if these numbers are scientific enough. However, such information definitely helps me to say that LibreOffice 4 is really good! Microsoft Office is not my area of interest, by the way. It is just that someone uses it. There were cases when Word could not open .doc files in the past. These cases are not my area of interest. Regards, C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 寄件人︰ e-letterinp...@gmail.com 收件人︰ C. H. D.webofht-libreoffice...@yahoo.com.hk 副本(CC)︰ LibreOffice User Support Mailing Listusers@global.libreoffice.org 傳送日期︰ 2013年02月12日 (週二) 5:53 PM 主題︰ Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular document On 12/02/2013, C. H. D.webofht-libreoffice...@yahoo.com.hk wrote: Hello! Yes, my Microsoft Office is legal. (Just happened that many other people use it.) I think it is an interoperability issue. If you are very concerned about interoperability, you should be contacting m$ and ask them why they cannot open odf documents created using LO. Have you done this? I searched the Internet and looked for documents randomly to test if LibreOffice can open them. This is the authentic test. No, a more authentic test is to search for odf documents and compare of LO and m$ opens these types of documents. If Microsoft Office opens the .doc files correctly, LibreOffice should also open them correctly. No, LO is not a m$-clone. If LO opens the odt document correctly, m$ should also. Have you tested this? If Microsoft went bankrupt, what office suite would be able to handle thousands of .doc files? Unlikely, but that is the fault entirely of the user that creates the document in the m$ file format!!! If LO, or any other odf-compliant software disappears, you can find another. That is why you should be testing interoperability with odf and not m$ formats. Then, the data in the .doc files would be lost if no other office suite was able to open them, I am afraid. I hope that happens (but a small possibility). Not many people like converting .doc files into .odt files, I am afraid. That is their choice. Start creating documents in odf! -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular document
this mailing like doesn't like attachments, you can download it from there: convertidor_odf.7z (320 KB) https://mega.co.nz/#!o8IXHa7Q!JgsZ0xKsAagxtkHxy-c2lnacVUdN6zPJRcCGyJ_oRbo best regards Al 12/02/2013 13:58, En/na pasqual milvaques pons ha escrit: in situations like this, independently of the work to be done to make libreoffice capable of opening those files you can use a version of microsoft office which supports odf to convert the file to odt. this can be an effective workaround I attach you the converted file (using microsoft office 2013). you can use these software to do the conversion from a shell: http://code.officeshots.org/trac/officeshots/browser/trunk/OfficeConvert I attach also a bat file which can help to automatize the conversion process best regards Al 12/02/2013 13:29, En/na C. H. D. ha escrit: Hello! Do I support LibreOffice? Yes, I do. Let me show some positive numbers: When I downloaded 400 .doc files, I opened 399 files in LibreOffice. Only 1 could not be opened. All 400 files were smaller than or equal to 692.5 KB. I started the testing from the smallest file to the largest file. It happened to be that I could not open that one file which was 692.5 KB. I am not a Maths expert. 399/400 = 99.75% Congratulations! This is excellent! Well done. To make a rough conclusion, I claim in a reasonable way that LibreOffice can open 99.75% of the .doc files I may come across in future if these files are smaller than 700KB. I do not know if these numbers are scientific enough. However, such information definitely helps me to say that LibreOffice 4 is really good! Microsoft Office is not my area of interest, by the way. It is just that someone uses it. There were cases when Word could not open .doc files in the past. These cases are not my area of interest. Regards, C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 寄件人︰ e-letterinp...@gmail.com 收件人︰ C. H. D.webofht-libreoffice...@yahoo.com.hk 副本(CC)︰ LibreOffice User Support Mailing Listusers@global.libreoffice.org 傳送日期︰ 2013年02月12日 (週二) 5:53 PM 主題︰ Re: [libreoffice-users] Bug 60390 - FILEOPEN: Cannot open particular document On 12/02/2013, C. H. D.webofht-libreoffice...@yahoo.com.hk wrote: Hello! Yes, my Microsoft Office is legal. (Just happened that many other people use it.) I think it is an interoperability issue. If you are very concerned about interoperability, you should be contacting m$ and ask them why they cannot open odf documents created using LO. Have you done this? I searched the Internet and looked for documents randomly to test if LibreOffice can open them. This is the authentic test. No, a more authentic test is to search for odf documents and compare of LO and m$ opens these types of documents. If Microsoft Office opens the .doc files correctly, LibreOffice should also open them correctly. No, LO is not a m$-clone. If LO opens the odt document correctly, m$ should also. Have you tested this? If Microsoft went bankrupt, what office suite would be able to handle thousands of .doc files? Unlikely, but that is the fault entirely of the user that creates the document in the m$ file format!!! If LO, or any other odf-compliant software disappears, you can find another. That is why you should be testing interoperability with odf and not m$ formats. Then, the data in the .doc files would be lost if no other office suite was able to open them, I am afraid. I hope that happens (but a small possibility). Not many people like converting .doc files into .odt files, I am afraid. That is their choice. Start creating documents in odf! -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted