Studio 5 to Omnis 10.1 - Mac - Apple Events

[Doug Easterbrook]

talking to excel….  use the open source excel component.   I’ve mentioned it on the list a few times.  here’s the link:

http://www2.artsman.com/omnis/Software/Omnis-XL384.zip <http://www2.artsman.com/omnis/Software/Omnis-XL384.zip> 

This is the same as the LibXL project that Andy mentioned.



Other than that.   good luck.     not even sure what the other conversion issues would be like from omnis 5 — and whether you should do the DML->Postgres option to move the database into postgres.

I’ll bet there are lots of snakes in the grass.  I”m surprised that they didn’t get stuck years ago since omnis 5 is back in the OSX 10.4 days or so with the OS 9 emulator … in it.








Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
http://www.artsman.com
Phone (403) 650-1978

> On November 8, 2019, at 1:43 PM, Michael Mantkowski <michaelj at clientrax.com> wrote:
> 
> I have been asked to look at an Omnis 5 library for a company whose developer has moved on.
> 
> They want to upgrade the application to work with Studio 10.1 so they can use the latest Mac OS.
> 
> The current application uses Apple Events to work with MS Excel.  Being that Apple Events are obsolete now, how would one interact with Excel on the Mac?
> 
> Here is an example of some of the code that 10.2 is flagging.
> 
> "On Hold Base.Jims Code1.Launch Excel Open Spreadsheet.1"	"Method line"	"Commented obsolete command:Enable receiving of Apple events OBSOLETE COMMAND"
> "On Hold Base.Jims Code1.Launch Excel Open Spreadsheet.18"	"Method line"	"Commented obsolete command:Send finder event OBSOLETE COMMAND Open Files (FV_SPREADSHEETFULLPATH)"
> "On Hold Base.Jims Code1.Launch Excel Open Spreadsheet.22"	"Method line"	"Commented obsolete command:Send finder event OBSOLETE COMMAND Open Files (FV_TEMPLATEPATH)"
> "On Hold Base.Jims Code1.Save Sheet As.6"	"Method line"	"Commented obsolete command:Send finder event OBSOLETE COMMAND Open Files (LV_SAVESCRIPTPATH)"
> "On Hold Base.Jims Code1.Quit Excel.1"	"Method line"	"Commented obsolete command:Set event recipient OBSOLETE COMMAND Microsoft Excel"
> "On Hold Base.Jims Code1.Quit Excel.2"	"Method line"	"Commented obsolete command:Send core event OBSOLETE COMMAND Quit Application"
> "On Hold Base.Jims Code1.Launch Update Script Timer.2"	"Method line"	"Commented obsolete command:Send finder event OBSOLETE COMMAND Open Files (FV_UDSALESSCRIPTPATH)"
> 
> I also plan to look for any obsolete hash variable use.  Anything else I should be on the lookout for?
> 
> Thanks!
> 
> *********************************************************************
> Michael Mantkowski
> ClienTrax Software
> 1-614-875-2245
> *********************************************************************
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com