Hello! We are currently on the process of migratin...
# help
n
Hello! We are currently on the process of migrating our app from Firebase to Supabase. I am on the process of migrating the users currently. So far what I have done is export our firebase users in a json format and create a script, that walks this json files and outputs basic
INSERT INTO auth.users
queries. Of course pwd are NULL and will have to be reset manually. Question is: Am I missing something? Because when I go to the users dashboard, and hit
Send password recovery email
, I get an error:
Send password recovery failed: Database error finding user
This is an example of the insert query that I am making
Copy code
sql
INSERT INTO "auth"."users" ("instance_id", "id", "aud", "role", "email", "encrypted_password", "raw_app_meta_data", "raw_user_meta_data", "is_super_admin", "created_at", "updated_at") 
VALUES ('00000000-0000-0000-0000-000000000000', 'ba917c4e-a67c-5e00-b737-0012829b9ff2', 'authenticated', 'authenticated', 'email@email.com', NULL, '{"provider": "email"}', 'null', FALSE, '2021-08-20T19:27:46.427Z', NOW());