I have json containing a list of users and all the required fields for creation including password. Is there a good way to add them to UserSpice all at once?
Bulk Users Import via json
I'd convert them to CSV then import:
https://json-csv.com/
Brandin.
When importing the csv via phpmyadmin the imported users dont show up in the admin_users.php table.
[quote='Brandin' pid='6600' dateline='1531250890']
I'd convert them to CSV then import:
https://json-csv.com/
Brandin.
When importing the csv via phpmyadmin the imported users dont show up in the admin_users.php table.
[/quote]
You want to make sure your column count matches and you're importing in the view of the users table, not just from the DB view. If that doesn't work, try converting CSV to SQL:
https://sqlizer.io/
[quote='ebzjruiz' pid='6601' dateline='1531255983']
[quote='Brandin' pid='6600' dateline='1531250890']
I'd convert them to CSV then import:
https://json-csv.com/
Brandin.
When importing the csv via phpmyadmin the imported users dont show up in the admin_users.php table.
[/quote]
You want to make sure your column count matches and you're importing in the view of the users table, not just from the DB view. If that doesn't work, try converting CSV to SQL:
https://sqlizer.io/
[/quote]
Same results, imported directly into users view in phpmyadmin and still not appearing.
There are no errors? You used SQLIZER as well? If that didn't work, I don't know how else to guide you since this is a non-US related issue.
Brandin.
Brandin.
There are no errors? You used SQLIZER as well? If that didn't work, I don't know how else to guide you since this is a non-US related issue.
Brandin.
No errors. Are there any specific columns I need to add values to or leave blank before import?
There are no errors? You used SQLIZER as well? If that didn't work, I don't know how else to guide you since this is a non-US related issue.
Brandin.
My mistake, I didn't realize they were set to inactive on default so I didnt see them in the view.