Import existing users from esoTalk

Franz

Dakoom We refrain from promising any dates, for good reasons. 😉

In my personal opinion, it will be done some time this year...

Dakoom

I understand, don't worry. At least I tried! 😃

Dakoom

So, let's say I install a new Flarum and I completely remove esoTalk. Then I open the DB of esoTalk and I export all the users via SQL query. And then I do (on the new Flarum db) something like this:

INSERT INTO fl_users (username, email, join_time) VALUES
('UserExample', 'useremail@gmail.com', 1430328990),
etc.

Should this work?

VIRUXE

Dakoom have you taken a look at the phpbb importer? Examine the code it should clear your doubts.

Dakoom

Ok, I created this file:
Used it and it seems to work. Now I have the dump file and I should be able to import it on Flarum. The problem is that I can't import it right now as I have first to clean it from spammer users. Mhhh, do you have some suggestions eg for a fast way to do this?

VIRUXE

Dakoom don't you think you should give credit to the original author of that importer?

Dakoom

So for me the best thing would be to create a simple script in PHP (but I don't know how to do it right now, I'm just googling for it) that lets me see a list of users and delete them from the database in a fast way. Do you have some suggestions?

luceos

Dakoom open the export in a program like excel or google sheets and manually delete the entries?

Dakoom

I did it via phpMyAdmin with the "LIKE" function, so using SQL queries like this:

DELETE FROM et_member WHERE email LIKE '%.ie%'
OR
email like '%.pw%'
OR
email like '%.ua%'
OR
email like '%.pl%'
OR
email like '%.vn%'
OR
email like '%.xyz%'
OR
email like '%.directory%'

Ok, finished. Now I'll try to import it on a Flarum local install to see what's happen.

Dakoom

I get problems with primary keys. How could I set them to AUTO INCREMENT?

luceos

Dakoom what is the exact problem. The Flarum database should have auto increment keys.

Dakoom

luceos I forgot to clean the Flarum database before importing. I'll try it again today and I'll let you know! 😛

VIRUXE Sure! I already have this in the gist I created:

I created this based on this other importer from phpBB: gist.github.com/robrotheram/fa15c112fd7c995fdbc0. It shoudl work but I still have not tested it because I have to clean the database from spammers users.

But please let me know if I should include something else.

Dakoom

luceos Ok, I tried but nothing. I clened the database, so I had only one users (admin) and the first tag/section/category that's by default on a normal Flarum install. I created the flarum.sql file from my esoTalk installation, but when I import it to Flarum I still geti this error: #1062 - Duplicate entry '3' for key 'PRIMARY'.

Kulga

VIRUXE He does

I created this based on this other importer from phpBB: link. It shoudl work but I still have not tested it because I have to clean the database from spammers users.

VIRUXE

Dakoom check if you have that value doubled somewhere in your SQL script.

Kulga I fail to see where that is written. I'm on my mobile, I just see the snippet that displays the files contents/.

Dakoom

VIRUXE I fail to see where that is written. I'm on my mobile, I just see the snippet that displays the files contents/.

Don't worry at all. 🙂

VIRUXE check if you have that value doubled somewhere in your SQL script.

I really can't understand in the SQL file if I have it doubled. I'm not so SQL saavy. This is the current SQL file that I have: pastebin removed

Kulga

Dakoom It looks like you're importing users, tags, posts all at once?
Try separating that (just import users) to try and isolate the error.

HavocK

Dakoom Are those people ok for showing there email here ?

Just saying...

Dakoom

Kulga

I'll try! Good idea. Thank you!

HavocK

Yup, for the most of them they're all friends of mine. But I remove it. Thank you for poiting this out.

« Previous Page Next Page »