M is in the cell
Ladies and gentlemen, good news for our town.
It finally happened - M was put in the cell.
And feels great there. Maybe it not a prison but an Excel cell.
Being there, he leads the whole M-gang. As well as conditional formatting in EXCEL.
Close integration of excel with the database provides a new convenient design tool.
Interactive reports, input forms, diagrams are generated only by m-commands in cells, without classical programming.
More detailed on https://github.com/mx-alex/MX
We will monitor the development of the situation and answer your questions.
best wishes
Alex
Hi Alex! Thanks for sharing!
Do you want to publish your solution on Open Exchange? It will give it more visibility and you can use several business development tools to get more leads. Here is how to publish.
Also, are there demo or videos?
Hi Evgeny !
Thanks for the addition.
I will continue this topic. And in the Exchange too.
The easiest way to become familiar is to import vmx.ro in namespace and run the macro mx.xlsb
Alex.
Some screens as examples of work MX,
they can be seen after downloading from github and starting mx.xlsb macro
Nice!
Any screencast on how to reproduce it?
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
I downloaded and installed in USER, but unfortunately I am having a lot of trouble following your documentation and your examples. When clicking around in the interface, I got lots of errors and ultimately had to force quit the program. I wonder if my config file isn't right, but that is hard for me to follow and understand too.
Hopefully you can clean up your documentation and I can try again!
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
Using:
Cache 2018
Excel 2013
Using my local Cache so localhost 1972
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
Alex, the easiest (for tester) way to test an arbitrary module is to embed (for developer) the module into docker container cause this will work in any case on any machine with Docker installed.
Why not install your staff in a docker container? Check the template. Another option - make a ZPM module - the template for ZPM module.
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.
Why do you think so?
IRIS running in docker exposes its ports to a host machine and can be accessed used by any other application on a machine, e.g. Excel
Consider a simple exercise:
1. Install Docker desktop (if you don't have it).
2. Run in OS terminal the following:
Then open Management portal in your host browser on:
http://localhost:52773/csp/UtilHome.csp
Works?
Alex, just published an article, which could help to Dockerise your repo just by introducing a few files - everyone will be able to launch you project with docker. And maybe even collaborate.
Thanks
I will definitely look
(problems with docker)
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
Thanks! I don't seem to have that option (54). I do have the others however,
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
Do $System.OBJ.ImportDir("c:/mx","vmx.ro","ck",,1)
Compilation error fixed
Sorry
Social networks
InterSystems resources
Log in or sign up
Log in or create a new account to continue
Log in or sign up
Log in or create a new account to continue
Log in or sign up
Log in or create a new account to continue