M is in the cell

Announcement

alex kosinets · Feb 8, 2020

#ObjectScript #Tools #Caché #InterSystems IRIS

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

Discussion (19)0

Evgeny Shvarov · Feb 9, 2020

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?

0 0

alex kosinets · Feb 9, 2020

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.

0 0

alex kosinets · Feb 18, 2020

Some screens as examples of work MX,
they can be seen after downloading from github and starting mx.xlsb macro

0 0

Evgeny Shvarov · Feb 18, 2020

Nice!

Any screencast on how to reproduce it?

0 0

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

0 0

Michael Davidovich · Feb 21, 2020

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!

0 0

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

0 0

Michael Davidovich · Feb 21, 2020

Using:

Cache 2018

Excel 2013

Using my local Cache so localhost 1972

0 0

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

0 0

Evgeny Shvarov · Feb 21, 2020

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.

0 0

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.

0 0

Evgeny Shvarov · Feb 22, 2020

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

0 0

Evgeny Shvarov · Feb 22, 2020

Consider a simple exercise:

1. Install Docker desktop (if you don't have it).

2. Run in OS terminal the following:

docker run --rm -p 52773:52773 --init --name iris store/intersystems/iris-community:2020.1.0.199.0

Then open Management portal in your host browser on:

http://localhost:52773/csp/UtilHome.csp

Works?

0 0

Evgeny Shvarov · Feb 24, 2020

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.

0 0

alex kosinets · Feb 25, 2020

Thanks

I will definitely look

(problems with docker)

0 0

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

0 0

Michael Davidovich · Feb 21, 2020

Thanks! I don't seem to have that option (54). I do have the others however,

0 0

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

0 0

alex kosinets · Mar 1, 2020

Do $System.OBJ.ImportDir("c:/mx","vmx.ro","ck",,1)

Compilation error fixed

Sorry

0 0