#1 WordPress forum plugin created by gVectors Team

wpForo – WordPress Forum Plugin
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Addons Demo
  • Documentation

Forum

Home | Forum

wpDiscuz - WordPress Comment Plugin
  • Forums
  • Members
  • Recent Posts
Forums
Migrate to wpForo
Migrate to wpForo f...
SQL query to add to...
 
Share:
Share
Tweet
Share
Notifications
Clear all

SQL query to add topics

    Last Post
  RSS
JospehMoseph
 JospehMoseph
(@jospehmoseph)
Active Member

First all claps for such a wonderful forum that too integrated with WordPress. I am wondering if anyone can provide SQL script to create topics in bulk.

I have excel sheet with the topic in one column. I am thinking If I can insert all those column values as topics in the forum in bulk. Any lead will be highly appreciated.

Thanks

Quote
Topic starter Posted : September 7, 2019 8:14 am
Topic Tags
migration import
Robert
 Robert
(@robert)
Support Team Admin

Hi @jospehmoseph,

The main issue is UserID and ForumID relation to Topics. If you do a simple import your topics will not be attached to any forum or to any user. Those topics will not appear on forum because they don't have correct ForumIDs and UserIDs. You should have Forums, Topics, Posts and Users excel sheets. And it should be imported with relation of new IDs in database. in other words a simple SQL will not be able to do that. This requires a deep custom work with custom codding and processing. At the moment I think the best way is asking to ProfProjects GP or gConverter, LLC to do this job. 

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

ReplyQuote
Posted : September 7, 2019 2:21 pm
  All forum topics
  Previous Topic
Next Topic  
Related Topics
  • Move from Lithium Forum to wpForo
    3 years ago
  • Migrate from Kunena
    4 years ago
Topic Tags:  migration (27), import (4),

Forum Search

Join Us!

Download wpForo plugin
on WordPress.org

wpForo Addons

wpforo-private-messages wpforo-advanced-attachments-128x128 wpforo-embeds-128x128 wpForo User Custom Fields addon wpForo – Blog Cross Posting addon wpForo Ads Manager wpForo – WooCommerce Memberships Integration wpForo Emoticons wpForo – Tenor GIFs Integration
View all Addons »

Recent Topics

  • wpForo not working correctly with Silk browser on Fire 7 Tablet

    By starman71, 5 hours ago

  • Simplified Guests see "Add Topic" button - even if settings are right

    By DanielOfAnu, 6 hours ago

  • Forums link on main page leads to 404, is not updated

    By Redglyph, 18 hours ago

  • Creating the forum structure

    By Redglyph, 19 hours ago

  • Style Show Likers with their avatar

    By Tutrix, 2 days ago

  • User replies are "Buggy"

    By Noved, 3 days ago

Topic Tags

  • translation49
  • css49
  • plugin conflict48
  • seo45
  • new features43
  • buddypress42
  • ultimate member40
  • avatar40
  • forum40
  • moderation38
  • login38
  • registration36
  • threaded layout35
  • cache33
  • editor32
  • menu32
  • shortcode30
  • spam29
  • phrases28
  • forum accesses28
View all tags (2155)

Recent Posts

  • wpForo not working correctly with Silk browser on Fire 7 Tablet

    Just tried the Amazon Silk browser using an Amazon Fire...

    By starman71, 5 hours ago

  • RE: Guests see "Add Topic" button - even if settings are right

    One further issue, how can I disable the "Login" or "Re...

    By DanielOfAnu, 6 hours ago

  • RE: Forums link on main page leads to 404, is not updated

    @redglyph Ok, take your time. wpForo has its own Menu...

    By dimalifragis, 9 hours ago

  • RE: Creating the forum structure

    @dimalifragis I agree, first things first 🙂

    By Redglyph, 14 hours ago

  • RE: when is the new update ?

    @gsmdahisi, We're very close to release the beta vers...

    By Martin, 22 hours ago

  • RE: Hide or disable Select Forum dropdown in Private forum

    Thank you for the code which was simple to install and ...

    By BrianWent, 1 day ago

  • RE: How can i remove the Buttons under Name?

    @y-3 The code above removes the complete buttonbar i...

    By Tutrix, 2 days ago

Share:
Share
Tweet
Share
  Forum Statistics
20 Forums
9,741 Topics
49.3 K Posts
5 Online
43 K Members

Latest Post: wpForo not working correctly with Silk browser on Fire 7 Tablet Our newest member: [HD] Топ Ган Мэверик 2022 Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo | Copyright © 2016-2022 gVectors Team
Copyright Registration Service - Click here for more information or to register work
wpForo is Registered with the IP Rights Office
Copyright Registration Service

Ref: 4477265538
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Addons Demo
  • Documentation