How to upload bulk question answers?

I do have questions and answers in xls, how to upload this to newly setup forum?

thanks!

1 Like

What do you mean upload them?

Do you mean upload them to a post? If so, are you trying to attach them, or make the contents of the XLS the contents of the post?

Are you trying to make them the FAQ section of the site?

I have a feeling whatever you’re wanting to do would be fairly simple but I just don’t understand what your desired result is.

4 Likes

Lucas, Thanks for the quick reply. I wrote 2000 question and answer in xls and would like to post those on my discourse forum, please let me know if there any ways to import.

If visitor comes to my forum they will at least see these 2k posts on sites.

Oh. You’d like to import these Q/A’s as separate topics? Or post them to a single, very long, general Q/A topic? Can you provide a sample row or two from your spreadsheet?

1 Like

Yes, I would like to import these Q&A as a separate topics.

example:
question: What is cloud server?
Answer: A cloud server is a virtual server (rather than a physical server) running in a cloud computing environment. It is built, hosted and delivered via a cloud computing platform via the internet, and can be accessed remotely. They are also known as virtual servers.

Question: What is Amazon AWS?
Answer: Amazon Web Services . Amazon Web Services ( AWS ) is a secure cloud services platform, offering compute power, database storage, content delivery and other functionality to help businesses scale and grow.

I’ll keep my personal thoughts regarding how having 2000+ individual topics dedicated to single questions may be a bad idea to myself for now.

I see two possible ways of accomplishing your goal. One would be to convert your spreadsheet to a CSV and then use the API and some shell scripting to loop through the file creating a new post for every line.

Another way could be to set up “Allow posting from email” and then use Excel’s “Mail Merge” feature to email every q/A to Discourse, creating a new topic.

2 Likes

Ok, could you please point me to API documentation for posting.

https://docs.discourse.org

Here you go! Best of luck!

4 Likes

thank you! appreciate you help.

The idea of preloading a lot of topics has been presented here before. I remember one topic that was particularly relevant but I couldn’t find it so maybe I read it on another website like Feverbee

While @chumstick has chosen not to comment, I’d be reluctant to start a new forum with a lot of simple Q&A tpics. Gathering a core group of enthusiastic users would probably be a better option to encourage interaction.

Anyway,you can ignore what I say but I’m also wondering if you’ve read any of the helpful topics on starting a Discourse forum:

Blog posts on building a Discourse community


Other topics on kick-starting and seeding (creating topics and users) a new forum:




8 Likes

Thanks Remah! I will check all these links

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.