newmips / newmips

Newmips Software - NodeJS Low code platform

⚠ Newmips generator is no longer maintained! ⚠
Thank you for heading to the new version which is now called Nodea Software!
https://github.com/nodea-software/nodea

Newmips

Newmips is a computer aided software that enable to generate NodeJS applications by giving instructions to a bot.
Official Website is : https://newmips.com

Classic Installation

Prerequisites

NodeJS >= 8.11.3
MySQL / MariaDB or Postgres server installed and running.

Instructions

Download and unzip the following archive in your working directory : https://github.com/newmips/newmips/archive/master.zip
Or git clone:

git clone [email protected]:newmips/newmips.git

Execute the following instructions:

cd NEWMIPS_FOLDER
chmod +x install.sh
bash install.sh

Follow the instructions and wait for message :
Newmips ready to be started -> node server.js

Then, execute command line :

node server.js

Open your browser on http://127.0.0.1:1337
Set your password on the first connection page http://127.0.0.1:1337/first_connection?login=admin
The default generator login is: admin

Note : to create your first application, ports 9000 and 9001 must be available on your computer.

Docker Installation

Prerequisites

Docker and Docker compose installed

Instructions

Create (and adapt if necessary) "docker-compose.yml" file:

version: '3.5'

services:
  newmips:
	depends_on:
	  - database
	image: newmips/newmips:latest
	networks:
	  proxy:
		ipv4_address: 172.21.0.14
	ports:
	  - "1337:1337"
	  - "9001-9100:9001-9100"
	environment:
	  SERVER_IP: "172.21.0.14"
	  DATABASE_IP: "172.21.0.15"
  database:
	image: newmips/newmips-mysql:latest
	networks:
	  proxy:
		ipv4_address: 172.21.0.15
	volumes:
	  - db_data:/var/lib/mysql
	ports:
	  - "3306:3306"
	environment:
	  MYSQL_ROOT_PASSWORD: P@ssw0rd+
	  MYSQL_DATABASE: newmips
	  MYSQL_USER: newmips
	  MYSQL_PASSWORD: newmips

networks:
  proxy:
	ipam:
	  driver: default
	  config:
		- subnet: 172.21.0.0/24

volumes:
  db_data: {}

Execute Docker compose command:

sudo docker-compose -f docker-compose.yml -p studio up -d

Wait about 30 seconds and open your browser on http://127.0.0.1:1337
Set your password on the first connection page http://127.0.0.1:1337/first_connection?login=admin
The default generator login is: admin

Note : to set up Newmips docker containers, range ports 9001 to 9100 must be available on your computer.

Documentation

Newmips software documentation is available at : https://docs.newmips.com.

Follow us

• Twitter
• LinkedIn

License

Newmips is released under the GNU GPL v3.0 license. It contains several open source components distributed under the MIT, BSD or GNU GPL V3.0 licenses.

newmips's Issues

How to rename entity?

J'ai créé une entité "Customers". Comment la renommer en "Customer"?

Each time I add/remove a field I loose it on the screen

Would it be possible to set the overflow of container of the table_e_table_wrapper always visible. This is not only a matter of setting the overflow-x to scroll, but also to set the height of the iframe large enough.

How to have a referred-to field depend on the user ?

I have an entity Customer with a field SalesRep referring to an external entity Employee. Naturally, the SalesRep depends on the login user.

How to?

field for %

request for improvement.

Would it be possible to open a new type of fields for percentages. With icon "%" and values between 0 and 100.

list fields

list fields : c'est bien.
list field for entity [variable] : ce serait bien aussi.

default value do not accept dots

I need to issue the following command:
add field Badge Number with default value 756.2904.2452.20

But Mipsy just erases all my dots.

Problem loading data.

Bonjour,

newmips m'a préparé une démo.

Les scripts de création ont parfaitement fonctionnés, mais impossible de charger les données.
D'après le log, les scripts essayent de charger les tables 2_e_duty_station

REQUEST:  INSERT INTO 2_e_duty_station (`f_name`, `f_code`) VALUES('Milan', 'MIL');
ERROR:  ER_NO_SUCH_TABLE: Table 'newmips.2_e_duty_station' doesn't exist 

Alors que dans msyql la table s'appele 3-e-duty-station.

---

J'ai essayé de renomer la table 3-e-duty_station en 2-e-duty-station, mais alors newmips me répond

REQUEST:  INSERT INTO 1_e_duty_station (`f_name`, `f_code`) VALUES('Milan', 'MIL');
ERROR:  ER_NO_SUCH_TABLE: Table 'newmips.1_e_duty_station' doesn't exist

---

Logique, mais pas d'un grand secours !

Feature request

In the designer, we have to setup 3 different pages per entity, for creation, update, and show.

Wouldn't it possible to have 1 page plus 3 variants?
Or one show page, plus one create/update page, plus one create page ?

Undo on the studio

As far as I understand, there is no undo/redo functionality in the Studio, even with a clever use of save+reload. You need to go into the github repository, with a high risk of messing everything up.

It would be nice to have an undo (or a rollback, or unsave, or revert) instruction that restore the local session at the previous save point.

The use case goes as follow:
a) The user makes a save
b) The user makes some modification
c) The user discovers his/her modifications are wrong
d) The user issue the undo
e) The Studio and the local machine goes to the lase savepoint (= a)

To have more fancy stuff, you may think about multiple savepoints, then a redo, then an automatic save after each command.

Important: Broken link on User Home page

According to #7 it it https://alaind.newmips.studio.

It would be nice to also have the list of https://mycompany-**myapps**.newmips.studio, as well as the list of https://mycompany-myapp.newmips.cloud/.

Bug in newMips installation

I have just installed a newMips by downloading the zip from github.
I have recreated the mySql and launched start-newmips.bat
I can log on 127.0.0.1:1337

But I am unable to select/create a project.
The log says:

events.js:160
	throw er; // Unhandeled 'error' events

Error: ENOENT: no such file or directory, open 'C:\nodejs\newmips-master\workspace\1\model\e_user.js'
    at Error(native)

What is my app url?

Bonjour,
Je viens de créer une application et on m'indique que
L'url de votre application sera: cra-admin
ce qui me semble un peu court.
D'habitude, on m'indique un url du genre https://cra-admin.newmips.je-ne-me-rappèle-plus-très-bien.com.

A ce sujet, serait-il possible d'avoir cet url sur un bouton où mieux, systématiquement, sur l'écran d'acceuil.

Question: script mode for the designer

It there a script mode for the designer?

The question comes from the fact that putting a good layout require a lot of back and forth with the Preview screen and, in my case where there are a lot of fields, sometimes to rerun the whole creation script.

In that case I also have to redo the layout, 3 times per entity, by hand. It would be better if this could be stored in a text file somewhere.

Menu logout not visible enough

Le dropdown-menu du header à droite, avec les boutons « Paramètres » et « Se déconnecter » ne se voit pas très bien et se confond parfois avec l’écran principal. Mettre le fond du .navbar-nav > .user-menu > .dropdown-menu > .user-footer dans la même couleur que celle du .main-header li.user-header.

A passage, mettre une ombre autour du dropdown-menu.

How to know the mother entity of a existing Sub-entity

I have an entity Employee which is also a tab (sub entity) of the entity Office. The Office has been created before the Employee, so it is possible to list all the Employee by clicking on the left panel. However, I cannot then know which is the Office of the Employee I see on row, say, 3.

Is it possible to add the column Office on the list of Employees. In all logic this column should come just after the column Employee Id.

And for the comfort of the user, it would be better if this column is replaced by the Office name.

Bug: Iwas able to create two projects with the same name.

My script.nps did create the same project twice. It's on the https://tps.newmips-ch.studio and the name of the projects is "samples".
Of course, I could delete the one which is empty. I kept it just to show you that you have probably a dangling if then else, in your code.

installation : Port mysql

Bonjour Mipsy,
J'essaie d'installer newMips sur ma machine, mais mon MySql utilise le port 8889, parce que il a été installé par MAMP.
Du coup "mysql -u newmips -pnewmips newmips" me répond "Access denied for user newmips@localhost".
Pour info, je suis sur un Mac.
Roxane

Issue in script mode

When creating a entity in script mode newMips converts its name in entity.e_.label_entity, which rises a lot of problem afterwards.
Same thing for modules and fields.

Reproduce.:

1. Manually create project Classic Models
2. Manually create application Classic Models
3. Manually create module Administration
4. Execute the following script

select project classicmodels
select application Classic Models
select module Administration
create entity Job Title
  add field job title
create entity order status
  add field order status

5. The following entities are created
   entity.e_job_title.label_entity
   entity.e_order_status.label_entity
6. Nothing can be done with these

How to jump to the mother entity of a sub-entity

I have an entity Employee which is also a tab (sub entity) of the entity Office. The Office has been created before the Employee, so it is possible to list all the Employee by clicking on the left panel.

Is it then possible to have a click or a button so that I jump to the corresponding Office ?

For example, if I click on Dianne Murphy, I jump to the San Fransisco office, and if I click on William Paterson, I jump to Sidney office.

It would be nice if the solution could avoid crawling in the dust.

locales for ID

I have an entity Offices with an ID, which I want to call "Office Code".

When I edit the fr_FR.json into "e_offices": { ..., "id_entity": "Office Code",... }, newMips displays "Office Code Offices".

Bug in "one to one" relationship

Using the Team-Player example of your doc does not seams to work : when creating a Player, you are not able to select the Player-Team from the Team entities.

Reproduce:

create entity Team
add field Team Name
create entity Member
add field Member Name
add field Team related to Member using Member Name

then

create a new Team entity with name : 'The Merry Hacker Company'
create a new Player entity with name 'AlainD', the try to select his team: 
a) The drop box is empty
b) Even if you type the name 'The Merry Hacker Company' in the team field, and press the save button, the Player is created but his team is not recorded properly, instead a player-name is used as the team-name. 

Command line to define new entity (data row)

Existe-t-il une commande equivalente à INSERT INTO entity VALUES ?

Mot de passe oublié

Sur le site newmips.com, au login, il manque un bouton "J'ai oublié mon mot de passe".
[En fait je me souviens du mot de passe, je n'ai pas besoin d'un nouveau, C'est pour vous signaler que,.. Enfin, je me comprend. J'espère que vous aussi...]

BUG: champ "phone" restiruées en type "number"

J'ai créé un champ téléphone, avec create field DateOfBirth with type date.

Mais sur l'écran de saisie il est restitué comme <input class="form-control input" placeholder="phone" name="f_phone" value="" type="number">.

Nombre d'éléments à afficher

Le nombre d'éléments à afficher est à choisir dans ine liste déroulante femée (50, 200, 500, Tous).
Serait-il possible d'en faire une liste déroulante ouverte? Je dois afficher 3 ou 4 éléments pour un copie d'écran.

Défaut dans la sécurité

Reopen discussion about feature #15 (3 screens per entity)

*** For the moment, we prefer to keep the possibility to design each page independantly. ***

Is there a reason? I mean, is there a way to design the layout by script which I do not know about? Or to copy/paste a page layout? Or something of the kind, because, I cannot believe, deep within me, that you sincerely wish to multiply you own work by 3.

Default language

During the development, I need to check the English version as well as the French version.

I did not found a way to do it on the top left menu (nearby the user/disconnect button), and changing my default browser language did do anything.

I tried to change the workspace/{app}/config/language.json with no effect.

Is there any known way to do it?

Bug : List field

La commande list field répond : Cannot read property 'Module' of null

Bug: Import thème css

ERR_CONNECTION_REFUSED : quand je dépose mon template ci-joint
HRB2B.zip

Retour à l'acccueil

Un bouton équivalent à https://alaind.newmips.studio/default/home serait bienvenu sur l'écran de prévisualisation.

S'il existe déjà, le rendre plus visible serait bienvenu aussi.

Very serious and critical BUG in api

The api/getToken does not work.
The http://127.0.01:9034 does not listen at all.

The correct api url is http://127.0.0.1:9003.
Please correct

Documentation is like sex: when it is good, it is very, very good; and when it is bad, it is better than nothing. -- Dick Brandon

Horizontal bars in subentities not showing

In a tab for a subentities the horizontal bar does not show. As a consequence, it is impossible to modify or delete it.

Bug in defining API id access

There is a bug when defining a new API id (or when updating it).
If you click OK, the identifier is never the less created.

Linux centric (=non windows) command in last release

With a fresh install, I get the following error:

{ Error: Command failed: cp C:\newmips2.6\structure/../structure/template/package.json C:\newmips2.6\structure/../workspace/
'cp' n'est pas reconnu en tant que commande interne
ou externe, un programme exécutable ou un fichier de commandes.

    at ChildProcess.exithandler (child_process.js:204:12)
    at emitTwo (events.js:106:13)
    at ChildProcess.emit (events.js:191:7)
    at maybeClose (internal/child_process.js:891:16)
    at Process.ChildProcess._handle.onexit (internal/child_process.js:226:5)
  killed: false,
  code: 1,
  signal: null,
  cmd: 'cp C:\\newmips2.6\\structure/../structure/template/package.json C:\\newmips2.6\\structure/../workspace/' }
events.js:160
      throw er; // Unhandled 'error' event
      ^

Suggested diagnostic:
This can come from modules_handle.js:14 or from structure\structure_application.js:62.

Suggested correction:
Use process.platform to chek if you on a windows OS and, in this case use

• in modules_handle.js:14
cmd = 'xcopy /e structure/template/node_modules workspace/';
  See here if you need to copy hidden files and/or privileges.

• in structure\structure_application.js:62:
  var cmd = 'copy ' + dir + '/../structure/template/package.json ' + dir + '/../workspace/';

Question about field names

Underlines are removed from the command box: create field date_from --> create field datefrom.

Normal?

Change color for Success of First connection

Api getToken error

When getting a token with /api/getToken with java I get the response {"token":"238a76125ca56016ce1be2e1ebaab0b9"

It is not a problem in itself but following calls to any api/entity?token=238a76125ca56016ce1be2e1ebaab0b9 gives the result

<html><body><h1>502 Bad Gateway</h1>The server returned an invalid or incomplete response.</body></html>

Knowing this one may requires sometimes to debug, a workaround will be appreciated.

Cloud: copy/paste not working.

Reproduce:

• Open a newMips app on the cloud
• list an entity, and display any of them in order to update it
• select a field and copy it with Ctrl-C or with the right-click menu
• select an other field on the same entity or an other entity and paste it with Ctrl-V or the right-click menu.

Result: nothing happens.

Expected result: the first field gets copied.

Temps de latence à l'execution d'un script

Lorsqu'on créé un script le temps de latence entre le bouton Executer [avec un "create project cra1: Nouveau projet cra1 (4) créé." presque immédiat] , et le démarrage du progress bar est un peu long.

Du coup, on a tendence à croire que l'apli est créée et on a aller se balader sur les pages de development sans attendre.

Il serait judicieux de changer le message en "Nouveau project cra1 en cours de création", "Nouvelle application cra1-admin en cours de création", "Nouvelle entité *** en cours de creation", etc, etc,...

Documentation

Il semble que e system comprend lorsque que je lui dit create field boolean, alors que d'après la doc je devrais tout écrire : create field **with type** boolean.

Si je me souviens bien, traditionnellement les parties optionelle de syntaxe sont notées entre crochet. Il faudrait donc remplacer CREATE | FIELD | STRING (WITH TYPE | STRING) par

• create field <field-name> [with type] [string].

Filter references lists

I have a field related to an entity Contract which has a boolean called Active. When I choose a Contract, I want to display only the active contracts. Is this possible ?

Bug: Boolean/Checkbox does not work

When telling Mipsy to add field Active with type boolean, the softbot creates a field named Active with type string. Replace boolean with checkbox does the same.

Workaround: use a default. When asked to add field Active with type boolean with type false, the bot creates the field as a checkbox.

How to rename IDs

En créant l'entité "customers", le sytème a créé le champ "IDCustomers".
Comment spécifier que la clé s'appèle "CustomerNumber" ?

Format for Numeric fields in list

When creating or showing a money field in an entity have a thousands separator, while showing in list it has no thousands separator.
Please add one for list. Low priority.

Question about field names (reopen)

Reopen issue #8 (inadvertently closed by the administrator instead of the user).

But I have created a field called recovery_hash with the creation script.
How do I remove it or change its attribute ?

Default value for related to field

Is it possible to extend the script with a command like:

create field (.*) related to (.*) using (.*) with default value (.*)

Ciel qu'ais-je fais???

J'étais en train de visualiser une entity, et j'ai entré la commande delete entity <entity>.

J'ai cru que je recevais ma feuille d'impôt.