This question has been flagged
2 Replies
7757 Views
usersaccess rightsOdoo13CSVExcel
Avatar
Ng Yuen Hoe

Hi all,

I have 100+ users,  and some users have different-different groups

How can I achieve this by using Excel or CSV to import it ?


I tried to import by using CSV, but there is error: 

The error I received is:Unknown error during import: <class 'odoo.exceptions.RedirectWarning'>: ('You cannot create a new user from here.\n To create new user please go to configuration panel.', 74, 'Go to the configuration panel') at 3 different rows:
    Row 2 (Marketing Manager)
    Row 3 (Sales Officer)
    Row 4 (Sales Supervisor)
Resolve other errors first


This is the simple of users list I have: 

https://docs.google.com/spreadsheets/d/1AgRaRJxHrTN2lsen7lontHQgObiXFBaua0AIrjlU6k8/edit?usp=sharing


Anyone have the idea? Thanks in advance.

Avatar
Discard
Avatar
Paresh Wagh
Best Answer

You may want to use the technical names of the fields and the external ids. A good option would be to export the groups into a csv file so you have their external ids's for easy reference. Then create a user, export the user record and use it as a template for creating all the users.

Avatar
Discard
Avatar
Geoff Petkus
Best Answer

The following sample worked for us as an import in the Users module, creating both a User and applying some Contact details such as Job Function.

Name,Login,Related Company,Job Position
Jon Smith,jon@xyz.com,Parent Company,Sales Director

Avatar
Discard