= Firebase WP Importer

Tool for importing Wordpress users into Firebase authentication database.

Based on https://twitter.com/TPXP/status/1275073372464939011[@TPXP research].

== Installation

[source,sh]

yarn global add firebase-wp-importer

== Usage

. Generate Service Account key in Firebase and save as +sa.json+.

. Prepare +users.json+ in following format: + [source,json]

[ { "ID": 123, "user_pass": "$P$Bv4ZO4aa3bpaVV5GLo73L4MvEbWOSS.", "user_email": "[email protected]", "user_login": "admin", "display_name": "John Doe" }, ... ]

. Execute import: + [source,sh]

firebase-wp-importer --cert sa.json users.json

==== Generating users.json directly from MySQL

Use following query to get properly formatted JSON from +wp_users+ table:

[source,sh]

SELECT JSON_ARRAYAGG(JSON_OBJECT('ID', ID, 'user_login', user_login, 'user_pass', user_pass, 'user_email', user_email, 'display_name', display_name)) from wp_users;