InfoQube IM - Community

Submitted by KeithB on 2018/11/08 22:41

Here's another project file to share.

I captured most of the current forums, which contains the title, replies, created, last reply.

The forumcapture.zip contains the excel I used, with a worksheet with some notes as to what I did.

I put tags of the subforum name tags in green, and a few keyword tags in aquamarine, to help differentiate.

So this so far lets you search all the forum posts by title, and any additional tags you create. The links work, so if you find something, it will take you to your browser with that topic.

I plan to use this as a starting search, and probably capture the relevant threads I'm interested in, to the doc pane. I'll also be doing additional tagging.

Anyway, I think it will be handy.

And no, I don't think I'm crazy enough to capture the content of 4xxx pages, but I will fill things in by attrition as I'm dealing with them.

There is so much knowledge in the forums just waiting to be mined!

Ideas for improvement, or about uses I haven't thought of are welcome. I'm sure this will be useful.

Comments

Great !

But why not just directly link to the mySQL which stores the forum ?

Yes it is possible, it was done years ago to capture the Mantis bug tracking system that was used back then.

(see the download page)

I'll work on this after updating the documentation for v110

Pierre_Admin

IQ Designer

I would be interested in how that would work, but only do that if it's not much of a detour from the roadmap.

I don't think I wasted my time, since with the effort involved in putting the last two samples together, I can really see the IQ skills improving very quickly.

It is so cool now being able to copy and paste xml from excel or another SNDB. I hadn't realized how relatively easy that was; I now have the forum titles and the manual merged into my main database.

FYI, on the copy and paste from excel, any titles with commas in them weren't pasting over properly.

Hi Keith, Pierre,

Is there an updated version of this, or an easy way to create a sync to the forum MySQL that gets updated in the same way as the welcome IQbase? I would also like to have a such a powerful knowledge repository that can be searched and sorted inside InfoQube.

Thank you,
Cyganet

[quote=Cyganet]Is there an updated version of this, or an easy way to create a sync to the forum MySQL that gets updated in the same way as the welcome IQbase? I would also like to have a such a powerful knowledge repository that can be searched and sorted inside InfoQube.
[/quote]

Have a shot at Sync with the Online User Manual

(of course, with the Welcome to IQ supplied, I try to update Tags and Related Items, your copy would not get those)

Pierre_Admin

IQ Designer

Thank you Pierre, this is looking promising! The power and flexibility of InfoQube keeps impressing me more every day that I use it.

I followed the instructions, and now I'm a bit stuck: How do I edit the sync xml file to get the forum threads instead of the documentation pages? Simple replacements such as ((node.type)="forum") don't work, and I don't know the database table structure to write the correct SQL query.