How to import user from csv

#1

i have like 10 user to create and the csv i am uploading is not working. what is the correct format for csv?
Thanks

#2

username,fullname,email,roleid,title

roleid must be an ObjectID from MongoDB.

The default password assigned is Password1!

If it still fails let me know. It may be failing due to the role changes.

1 Like
#3

works like a charm. My problem was using a ; delimiter instead of a , . thanks and cannot decribe how awsome the software is and its just getting better.

#4

it imported but i dont see any user an when try importing again it stucks on :

  • Starting import…
  • Importing testuser close

am kind of stuck again. check the database user does not exist.
this is my csv file:

username fullname email roleid title
testuser test user testus@mail.com support commercial
#5

Roleid needs to be the ObjectID of the role.

#6

hi there - i tried the same format for csv user import but im still getting an error.

my format is as follows:
abeisel,Alexandra Beisel,abeisel@myemail.com,5d8905e44b35c14ae2e0b051,user
abrowning,America Browning,abrowning@myemail.com,5d8905e44b35c14ae2e0b051,user

thoughts?

thank you!

#7

Error messages logged in browser console, or server console?

#8

  1. {success: false, error: “Invalid Username - UserSchema.GetUserByUsername()”}

  2. success: false

  3. error: “Invalid Username - UserSchema.GetUserByUsername()”

  4. proto:

1. constructor: ƒ Object()
2. __defineGetter__: ƒ __defineGetter__()
3. __defineSetter__: ƒ __defineSetter__()
4. hasOwnProperty: ƒ hasOwnProperty()
5. __lookupGetter__: ƒ __lookupGetter__()
6. __lookupSetter__: ƒ __lookupSetter__()
7. isPrototypeOf: ƒ isPrototypeOf()
8. propertyIsEnumerable: ƒ propertyIsEnumerable()
9. toString: ƒ toString()
10. valueOf: ƒ valueOf()
11. toLocaleString: ƒ toLocaleString()
12. get __proto__: ƒ __proto__()
13. set __proto__: ƒ __proto__()

  1. arguments: (...)
  2. caller: (...)
  3. length: 1
  4. name: "set __proto__"
  5. __proto__: ƒ ()
  6. [[Scopes]]: Scopes[0]
#9

I think you may be missing a comma (,) between the fullname and email address.