Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Importing roles/fun...
 
Notifications
Clear all

Importing roles/functions

6 Posts
2 Users
0 Reactions
2,093 Views
(@ppmichirones)
Posts: 7
Active Member
Topic starter
 
[#6096]

How do I can import massively roles/functions?

Thanks in advanced.

P.P.


 
Posted : 27 Jun 2019 12H50
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Hi,

Import of parameters is not possible.


 
Posted : 27 Jun 2019 13H45
(@ppmichirones)
Posts: 7
Active Member
Topic starter
 

And with a "LOAD DATA FROM INTO role"?


 
Posted : 27 Jun 2019 20H54
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Best way to break the framework 👿


 
Posted : 27 Jun 2019 21H21
(@ppmichirones)
Posts: 7
Active Member
Topic starter
 

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


 
Posted : 27 Jun 2019 21H50
(@ppmichirones)
Posts: 7
Active Member
Topic starter
 

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.


 
Posted : 01 Jul 2019 19H35
Share:

Scroll to Top