AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
SQL query to add to...
 
Notifications
Clear all

[Closed] SQL query to add topics

1 Posts
2 Users
0 Reactions
3,726 Views
(@jospehmoseph)
Posts: 8
Active Member
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 
[#10311]

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


 
Posted : 07/09/2019 12:14 pm
Robert
(@robert)
Posts: 10741
Support Team Admin
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

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.

 
Posted : 07/09/2019 6:21 pm
Share: