go to post alex kosinets · Dec 17, 2021 MX: Mumps & eXcel Joining - But Why? | InterSystems Developer Community | An article on this topic and links to others. ( MX = MULTIEXCEL )
go to post alex kosinets · Nov 29, 2021 w $p("Happy new year ..................","...") --------------- Happy new year
go to post alex kosinets · Mar 5, 2021 Metallurgy, construction, clothing industry, peat extraction, trade, logistics. Also as universal system for financial and accounting for any enterprise.
go to post alex kosinets · Jan 24, 2021 We made a non-standard interface via Excel see https://community.intersystems.com/post/m-cell good luck!
go to post alex kosinets · Oct 1, 2020 Hi Ruslan ! Our technology MX combines M & EXCEL. https://community.intersystems.com/post/m-cell
go to post alex kosinets · May 31, 2020 Hi Oliver, You're on the right track ! button ##class(SYS.Stats.Dashboard).Sample() see on cell T7 (far right on 1_TEST sheet) button [design-mode] see top-menu of MX : buttons top-menu left to right : to-home-MX, mini-term-MX, print, copy-active-sheet-to-folder-C:\M, change-MX-date, design-mode, EXIT-MX Regards Alex
go to post alex kosinets · May 29, 2020 Oliver to check how MX works on your machinejust open file sea-battle-mx.xlsband select sea-battle (top big button ). You will connect to our m-server. Alex
go to post alex kosinets · May 29, 2020 Hi Oliver, you import VMX programs in 'USER' namespace Cache or IRIS windows 64-bit or 32-bityou run in terminal : USER> do ^ZSTU you started mx.xlsb after mx.xlsb start such picture should appear if not - send me errors text please Regards Alex
go to post alex kosinets · May 28, 2020 Hi Oliver, (other way)If you connect the MX virtual excel to your m-database, you can read books very simply:In an Excel cell, write down the formula$$ReadSheet c:\myfolder\mybook.xlsb#mysheet ^myGlob(myIndex) * After starting MX, the specified sheet will be read and converted to global.On one sheet there are many such formulas. Or read the entire book at once in ^global, and not just one sheet:$$ReadSheet c:\mx\mybook.xlsb#* ^myGlob(myIndex, * And you can work with this globals as you like, write the results in Excel or another way.MX Works with all Cache or IRIS. see also
go to post alex kosinets · Mar 14, 2020 set a="1.2.3.4" x "set tmp("_$tr(a,".",",")_")="""" " zw tmp tmp(1,2,3,4)="" if 1 2 3 4 5 … is integer
go to post alex kosinets · Mar 1, 2020 Do $System.OBJ.ImportDir("c:/mx","vmx.ro","ck",,1) Compilation error fixed Sorry
go to post alex kosinets · Feb 22, 2020 Evgeny, Excel and M both must be in docker . Also, M connected with Excel via port 5264 (2264 for Cache ). I think it is problems.
go to post alex kosinets · Feb 21, 2020 Mike, MX work only with 5264 - IRIS, 2264 - CACHE 64 bit, 2232 - CACHE 32 bit not 1972 port !! If it is important - in the future I will redo it to any port. Alex
go to post alex kosinets · Feb 21, 2020 Mike, please - delete mx_confi.vmx (it is duble of mx_confi.xlsb ) - upgrade MX (without re-installing vmx.ro ) mx_confi.xlsb must be version 2 hour ago Alex
go to post alex kosinets · Feb 21, 2020 Simple test for MS.Excel only (without your m-server) : - download MX to any empty folder on any win-comp and unzip - start mx.xlsb, your must see that image below (excel-macro-enabled ) - click large button [ 54. VMX test-CACHE-32 bit internet ] If this picture below appeared - the client excel test went fine ( else check internet and repeat ) try to open the toys and flags Alex
go to post alex kosinets · Feb 21, 2020 Mike , I will be grateful for the information- server version- excel version- port and ip-address your m-server - error text in any case, we will test more Alex
go to post alex kosinets · Feb 20, 2020 Hi Mike, sorry, I recently joined Community. I think excel inside the database will solve any problems with export in .xls or .xlsx format. Virtual-excel-inside-M on Linux or Windows, clients on MS.Excel on Windows https://community.intersystems.com/post/m-cell email sia.enters@inbox.lv Alex
go to post alex kosinets · Feb 18, 2020 It's hard - but there is no other way. For start MX with Cache 8-bit or unicode, or IRIS InterSystems : - download the repository as ZIP file, then unzip to a separate folder, for example: to c:\mx\ on any win-computer - start IRIS (Cache) terminal, then run the following commands after USER> zn "yournspace" Set root = "path on filesystem to which repository was downloaded" Do $System.OBJ.ImportDir(root,"vmx.ro","ck",,1) Do ^ZSTU ( Alternative option : USER> zn "yournspace" Do ^%RI Do ^ZSTU ) - edit the [connections] table in the MX_CONFI.xlsb (edit tcp port and $znspace) - run mx.xlsb (MS EXCEL be sure, required dot . as system-decimal-delimiter) Select and press the big button to connect to MX-server. Start sheet will open. You will see buttons for calling tests and games
