Database import
By Pavel Kurfürst on Friday, 27 June 2014
Posted in General Issues
Replies 3
Likes 0
Views 595
Votes 0
Hello,

my client needs to import old database with questions and replies to the easy discuss.
It is a database, where questions and answers are placed separately to two tables.

Each table has, as I check, all fields which are important to easy discuss, but I do not not, how are questions and replyes connected (in according to fields I saw).

First, I will import users so I will have user id.

Each question has its creation time, user id, category, etc, but as replies have its own id and also id of the question to which it bellongs to, I am confused how it is managed in easy discuss.

Thank you in advance

Best regards
Pavel Kurfürst
Hello Pavel,

Each question / discussions are treated as a post in the #__discuss_post table. Their relation is identified by the parent_id column. If it is a reply, the parent_id should be the discussion id. If it's a discussion, the parent_id would then be 0
Mark
·
Saturday, 28 June 2014 01:34
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Mark,

OK, thank you, it is done. Now, I will have to deal with notification, because it shows me, I have not read all imported posts.

I have noticed you tell one of the user who migrated from vBulletin, that there is no possibility to mark all migrated/imported posts as read.
But I also find, there is columd in #_discuss_users named posts_read.

What if I know all users ID and imported posts ID. Can I manually import some content to this column which will mark all posts for specified user (to users I know their ID) as read?

In my case, there is for example:
a:43:{i:0;s:1:"3";i:1;s:1:"6";i:2;s:1:"8";i:3;s:2:"10";i:4;s:2:"12";i:5;s:2:"13";i:6;s:2:"16";i:7;s:2:"20";i:8;s:2:"26";i:9;s:2:"28";i:10;s:2:"27";i:11;s:2:"38";i:12;s:2:"40";i:13;s:2:"34";i:14;s:2:"32";i:15;s:2:"39";i:16;s:2:"37";i:17;s:2:"36";i:18;s:2:"41";i:19;s:2:"31";i:20;s:2:"43";i:21;s:2:"59";i:22;s:2:"58";i:23;s:2:"57";i:24;s:2:"56";i:25;s:2:"55";i:26;s:2:"54";i:27;s:2:"53";i:28;s:2:"52";i:29;s:2:"51";i:30;s:2:"50";i:31;s:2:"49";i:32;s:2:"48";i:33;s:2:"60";i:34;s:2:"33";i:35;s:3:"116";i:36;s:3:"104";i:37;s:2:"61";i:38;s:5:"25420";i:39;s:5:"25286";i:40;s:5:"25309";i:41;s:5:"25237";i:42;s:5:"25235";}

so I am not sure, what a:43 means, but I suppose that in the brackets there is something like i:true/false for something; s:true/false for something;"post ID"

Please advise.

Best regards
Pavel Kurfürst
Pavel Kurfürst
·
Sunday, 29 June 2014 16:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Pavel,

I am really sorry for the delay of this reply as it is a weekend for us here. These are actually "serialized" objects and you need to unserialize them back into PHP again.
Mark
·
Sunday, 29 June 2014 17:30
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post