- Pharo-users - lists.pharo.org

Re: [Pharo-users] Automation of MS Office from Pharo

by PBKResearch

Hello Pablo Many thanks for the suggestion. I have tried to use Pharo-Com to connect to Outlook, and have now got myself into a complete tangle. I have been able to connect to my already-running copy of Outlook, but when I tried to enter propertyNamed: 'Folders', an error message appeared with the text: "Instance of FFIExternalObjectType did not understand emitArgument:context:inCallout:". I could not understand this, so I closed the debugger, assuming the effects would be unwound. I found that, whatever I tried after that, the same message appeared. In desperation I closed down Pharo, without saving the image, and started again. Whatever I tried in using Pharo-Com, the exact same message appeared. Even when I tried running one of your tests, the same message. It seems clear that something in my system, not part of Pharo, has been changed in a way which persists from one run of Pharo to another. I have no idea what it can be, but I see that some parts of Pharo-Com address the registry, so I wonder if I have corrupted that in some way. For the time being I have stopped work on Pharo-Com. I hope that a night's sleep will bring inspiration. In case it means anything to you, I attach a screenshot of the error stack when I try to run the testWord case in PharoCOM-Tests. Thanks again Peter Kenny -----Original Message----- From: Pharo-users <pharo-users-bounces(a)lists.pharo.org> On Behalf Of tesonep(a)gmail.com Sent: 05 April 2020 16:23 To: Any question about pharo is welcome <pharo-users(a)lists.pharo.org> Subject: Re: [Pharo-users] Automation of MS Office from Pharo Hello, One of the alternatives to integrate with Office is the use of the COM interface. There is an implementation in https://github.com/tesonep/pharo-com. In the test package, there are examples to integrate with Word, Excell, Internet Explorer, and Access. Integration with Outlook can be done in the same fashion. It is good that the API of all the Office products is heavily documented. You can get more information about how to use Outlook here: https://docs.microsoft.com/en-us/office/vba/api/overview/outlook/object-mod… If you have any questions, please let me know. Cheers, Pablo. On Sun, Apr 5, 2020 at 2:44 PM PBKResearch <peter(a)pbkresearch.co.uk> wrote: > > Hello All > > > > I am using Pharo (currently P7, moving to P8) under Windows 10. I have MS Office 365 on my system, and use it regularly for non-Smalltalk tasks. It would be very convenient if I could issue commands to MS Office components from within Pharo. My current interest is to manage my incoming e-mails in Outlook, but I can see many other applications. I have a recollection of seeing a reference to automation of Excel to transfer data both ways, but I cannot recall where. I have searched the catalog, but could not see anything that looked relevant. I have also read the uFFI booklet, but again no luck. Could anyone point me to any information or examples of such control, please? It would not have to be Outlook, though that is my main interest; given examples for other Office components, I should be able to follow the pattern. > > > > TIA > > > > Peter Kenny -- Pablo Tesone. tesonep(a)gmail.com

April 5, 2020

Re: [Pharo-users] Automation of MS Office from Pharo

by tesonep＠gmail.com

Hello, One of the alternatives to integrate with Office is the use of the COM interface. There is an implementation in https://github.com/tesonep/pharo-com. In the test package, there are examples to integrate with Word, Excell, Internet Explorer, and Access. Integration with Outlook can be done in the same fashion. It is good that the API of all the Office products is heavily documented. You can get more information about how to use Outlook here: https://docs.microsoft.com/en-us/office/vba/api/overview/outlook/object-mod… If you have any questions, please let me know. Cheers, Pablo. On Sun, Apr 5, 2020 at 2:44 PM PBKResearch <peter(a)pbkresearch.co.uk> wrote: > > Hello All > > > > I am using Pharo (currently P7, moving to P8) under Windows 10. I have MS Office 365 on my system, and use it regularly for non-Smalltalk tasks. It would be very convenient if I could issue commands to MS Office components from within Pharo. My current interest is to manage my incoming e-mails in Outlook, but I can see many other applications. I have a recollection of seeing a reference to automation of Excel to transfer data both ways, but I cannot recall where. I have searched the catalog, but could not see anything that looked relevant. I have also read the uFFI booklet, but again no luck. Could anyone point me to any information or examples of such control, please? It would not have to be Outlook, though that is my main interest; given examples for other Office components, I should be able to follow the pattern. > > > > TIA > > > > Peter Kenny -- Pablo Tesone. tesonep(a)gmail.com

April 5, 2020

Automation of MS Office from Pharo

by PBKResearch

Hello All I am using Pharo (currently P7, moving to P8) under Windows 10. I have MS Office 365 on my system, and use it regularly for non-Smalltalk tasks. It would be very convenient if I could issue commands to MS Office components from within Pharo. My current interest is to manage my incoming e-mails in Outlook, but I can see many other applications. I have a recollection of seeing a reference to automation of Excel to transfer data both ways, but I cannot recall where. I have searched the catalog, but could not see anything that looked relevant. I have also read the uFFI booklet, but again no luck. Could anyone point me to any information or examples of such control, please? It would not have to be Outlook, though that is my main interest; given examples for other Office components, I should be able to follow the pattern. TIA Peter Kenny

April 5, 2020

Lighthouse

by Martin Barale

Does lighthouse work on modern versions of pharo? I wanted to take a look at it but it gave me some problems in versions 8, and 6. Regards, Martin

April 4, 2020

Re: [Pharo-users] Help! Iceberg just stopped working!

by Russ Whaley

Ah found the thread. I solved my issue. Had to delete the repository and start over with iceberg. 60 second fix, once I determined it was nothing else I could find... Thanks! On Fri, Apr 3, 2020 at 5:11 PM Russ Whaley <whaley.russ(a)gmail.com> wrote: > I did a commit last night to GitHub - I checked, it's there. > > Today when I tried to load iceberg I get the attached error (see > screenshot). > > The libraries from last night's commit/push are still there - but Iceberg > says it can't find them... and refuses to load so that I could maybe delete > the reference and then add it back (something I have to do quite often as > the iceberg/github connection gets disconnected every couple of days or so). > > Can anyone tell me where to start looking? Where it says on the error - > that it can't find my files at a certain location... the 2nd screenshot - > is those files at that location!... > > Thanks! > Russ > > -- > Russ Whaley > whaley.russ(a)gmail.com > -- Russ Whaley whaley.russ(a)gmail.com

April 4, 2020

Iceberg problems...

by Russ Whaley

I don't know how to respond to a previous message I've sent (without having a response from someone else appear in my email!)... I got my Iceberg problems solved by deleting my repository and starting over. I don't know why I had to do this, but it was a 60 second fix, once I decided to go down that route. I've had to do this probably 5-6 times over the past month. All other times have been due to (at least in my observation) to the image hanging - where I can't <cmd-.>. I don't whether there is a top secret file inside each repository - or the folders are timestamped, or whatever, but my repository is now back up and running. Thanks! -- Russ Whaley whaley.russ(a)gmail.com

April 4, 2020

Google Form

by Hilaire

Hi, As teachers and students are confined home, there are some needs of tooling for distance learning. Did any of you worked on generating Google Form with Pharo? Hilaire -- Dr. Geo http://drgeo.eu

April 4, 2020

Re: [Pharo-users] [ANN] Pharo-Spreedsheet on GitHub

by Hilaire

Nice community work Hilaire -- Dr. Geo http://drgeo.eu

April 4, 2020

[ANN] Temple on GitHub

by Torsten Bergmann

Need a very minimalistic template engine for Pharo to be able to embed expressions in text? Then maybe the simple "Temple" project https://github.com/astares/Pharo-Temple is useful for you. Side note: ========== If this is just too minimalistic and you need more then check Norberts Mustache project: https://github.com/noha/mustache Bye T.

April 3, 2020

[ANN] TinyMCE for Seaside moved to GitHub

by Torsten Bergmann

Seaside wrapper for Tiny MCE Editor moved to GitHub now too including load instructions: https://github.com/astares/Seaside-TinyMCE Screenshot and details to be found on the project page. Have fun T.

April 3, 2020