Forum

Importing roles/fun...
 
Notifications
Retirer tout

Importing roles/functions

6 Posts
2 Utilisateurs
0 Reactions
2,060 Vu
(@ppmichirones)
Posts: 7
Active Member
Début du sujet
 
[#6096]

How do I can import massively roles/functions?

Thanks in advanced.

P.P.


 
Posté : 27/06/2019 12:50 pm
(@babynus)
Posts: 14952
Membre Admin
 

Hi,

Import of parameters is not possible.


 
Posté : 27/06/2019 1:45 pm
(@ppmichirones)
Posts: 7
Active Member
Début du sujet
 

And with a "LOAD DATA FROM INTO role"?


 
Posté : 27/06/2019 8:54 pm
(@babynus)
Posts: 14952
Membre Admin
 

Best way to break the framework 👿


 
Posté : 27/06/2019 9:21 pm
(@ppmichirones)
Posts: 7
Active Member
Début du sujet
 

Thanks but that doesn't help...
I'll try it.
Audentes fortuna iuvat.


 
Posté : 27/06/2019 9:50 pm
(@ppmichirones)
Posts: 7
Active Member
Début du sujet
 

It worked.

Solution:

A CSV file with the following structure:
==============
111;Plumber;

A plumbering work

;127.02
[...]
999;Shoemaker;

An old man with a whoe in his hands

;134.07
==============

In mysql client:

LOAD DATA INFILE '' into table ''role columns terminated by ';' (sortOrder,name,description,defaultCost);

If you don't want warnings pay attention to only 2 decimals in defaultCost.


 
Posté : 01/07/2019 7:35 pm
Share:
Retour en haut