By HMED on Tuesday, 19 July 2016
Posted in General
Replies 1
Likes 0
Views 366
Votes 0
Hello,

Is it possible to help us importing our existing posts from easysocial as evergreens posts in Joocial ?
We asked the Extly team but they dont know well the ED database structure

Here's the tutorial for default joomla content :
http://www.extly.com/docs/autotweetng_joocial/tutorials/faq-evergreens

I understand if you cannot help with this 3rd ext
Hey Jan!,

I am sorry for the delay of this reply,

Thanks for understand this is actually out of our support scope.

But you can share with their developer regarding with Easydiscuss table structure and see is it can help much here?

All the question and reply stored in this table -> #__discuss_posts
All the categories stored in this table -> #__discuss_category


// You can check following columns which you need to store the discussion info
$data['content'] = $content;
$data['title'] = $subject;
$data['category_id'] = $categoryId;
$data['user_id'] = $item->userid;
$data['hits'] = $item->hits;
$data['created'] = ED::date($item->time)->toMySQL();
$data['modified'] = ED::date($item->time)->toMySQL();
$data['replied'] = ED::date($lastreplied)->toMySQL();
$data['ip'] = $item->ip;
// editor type by default we use `bbcode`
$data['content_type'] = 'bbcode';

// if that is question the parent_id is 0 , if other one is consider is reply
$data['parent_id'] = 0;

$data['user_type'] = member or guest;
// if that is guest published the discussion post, these following 2 columns must contain the guest user data
$data['poster_email'] = $item->email;
$data['poster_name'] = $item->name;

// published == 1 , unpublished == 0
$data['published'] = published or unpublished;


After you done above, then we will run some maintenance script to update your `thread_id` from #__discuss_posts which need to sync to this table #__discuss_thread.

Note : It would be best do it in your development site.
·
Tuesday, 19 July 2016 11:42
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post