The following warnings occurred:
Warning [2] Undefined variable $unreadreports - Line: 26 - File: global.php(961) : eval()'d code PHP 8.2.25 (Linux)
File Line Function
/global.php(961) : eval()'d code 26 errorHandler->error
/global.php 961 eval
/printthread.php 16 require_once



UserSpice
Bulk Users Import via json - Printable Version

+- UserSpice (https://userspice.com/forums)
+-- Forum: Support Center (https://userspice.com/forums/forumdisplay.php?fid=23)
+--- Forum: UserSpice 4.3 and Below (https://userspice.com/forums/forumdisplay.php?fid=26)
+--- Thread: Bulk Users Import via json (/showthread.php?tid=1100)

Bulk Users Import via json - ebzjruiz - 07-10-2018

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?

RE: Bulk Users Import via json - Brandin - 07-10-2018

I'd convert them to CSV then import:
https://json-csv.com/

Brandin.

RE: Bulk Users Import via json - ebzjruiz - 07-10-2018

(07-10-2018, 07:28 PM)Brandin Wrote: 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.

RE: Bulk Users Import via json - Brandin - 07-10-2018

(07-10-2018, 08:53 PM)ebzjruiz Wrote:
(07-10-2018, 07:28 PM)Brandin Wrote: 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.

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/

RE: Bulk Users Import via json - ebzjruiz - 07-10-2018

(07-10-2018, 09:05 PM)Brandin Wrote:
(07-10-2018, 08:53 PM)ebzjruiz Wrote:
(07-10-2018, 07:28 PM)Brandin Wrote: 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.

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/
Same results, imported directly into users view in phpmyadmin and still not appearing.

RE: Bulk Users Import via json - Brandin - 07-10-2018

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.

RE: Bulk Users Import via json - ebzjruiz - 07-10-2018

(07-10-2018, 09:55 PM)Brandin Wrote: 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?

RE: Bulk Users Import via json - ebzjruiz - 07-11-2018

(07-10-2018, 09:55 PM)Brandin Wrote: 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.