Howto/doc on 'data explorer'

[lejeczek]

Hi guys.
Would there be a doc/tutorial for non-webdev on how to use data/queries/results in topics/posts? I searched but failed to find one. Thanks.

[Moin]

Did you find

Data Explorer Tutorial - Part 1 - Writing Your First Query

Want to extract some data from your Discourse site but not sure where to start? You’ve come to the right place! This is a tutorial guide for beginners who are new to the Data Explorer. If you’re already familiar with SQL and how to use the Data Explorer, then you will most likely not need to read these topic, and may want to check out our data & reporting category instead. The goal of this guide is to help you get a basic grasp of how to use the Data Explorer to create reports …

Maybe the other topics with sql-tutorial help you too.

[lejeczek]

Thanks. I’ve thumbed through it - perhaps I’ve gone blind - but cannot see bits which would mention “incorporating” queries/results into a topic/post, into its content.

[JammyDodger]

I don’t believe this is currently something you can do. There is an Automation that will send results to a PM or email. Perhaps you could check that out and see how it does it?

[lejeczek]

How people do it then or how to understand when someone says “… manually created a new topic using the data from the Published Pages query above, then published it at `/pub/index…” ?
That is a quote from another topic about “indexing published pages”

[JammyDodger]

Copy and paste?

[lejeczek]

Page Publishing

Indexing Published Pages While we’re waiting for the Index or search published pages feature, here is a way to do it manually. Finding Published Pages Using the Discourse Data Explorer you can create a new Published Pages query: SELECT CONCAT('/pub/', pp.slug) AS URL, pp.topic_id FROM published_pages pp ORDER BY pp.id Providing an Index Surely one can Run Data Explorer queries with the Discourse API to create and maintain an index of published pages. This might even be doable with the Custom …

[pfaffman (Jay Pfaffman)]

“manually created” for means that they created the topic normally and pasted in the stuff from the data explorer.

It might help if you say more about the specific problem that you are actually trying to solve.

[lejeczek]

Oh. I presumed that - since it looked like a “hot” topic to me - that proposed idea was a solution to have a dynamic index of published pages. I thought that was the idea behind it - to have TOC/index for published pages, dynamic index.

[IrisBetty]

I am stuck. I’m trying to use the query to. create a new group and copy all existing members into that group.

I understand the part of getting to data explorer, naming it etc.

I’ve copied the query - now where to do I paste it? I’ve pasted it to the text box to the right of the Select area but nothing happens.

sorry for the elementary question but I’m on a time crunch to get this done.

tx

Bronwyn

[pfaffman (Jay Pfaffman)]

@IrisBetty

I’m trying to use the query to. create a new group

Data explorer is only for exploring data, not changing it.

If you need to change something with code, and don’t have access to run stuff in rails, then you need to use the API.

@IrisBetty

create a new group and copy all existing members into that group.

What problem is this solving? Do you really want to create a new group that has every user on the system on it? You can’t use @everyone or @tl0?

[IrisBetty]

Hi Jay:

There is a post on running a query that copies all users from certain groups into a new group.

I wasn’t to copy from the current Everyone into a new group.

Going forward, some of the Everyone group won’t be in the new group.

I found the post that showed this query:

–[params]
– string_list :group_name
– string_list :new_group_names
SELECT ue.email as “address@email”, :new_group_names as “new group”
FROM users u
INNER JOIN group_users gu ON u.id = gu.user_id
INNER JOIN groups g on g.id = gu.group_id
INNER JOIN user_emails ue on u.id = ue.user_id
WHERE g.name IN (:group_name)
AND ue.primary = true

I pasted that into the box to the right of the SELECT item. It said that two new input fields should appear at the bottom. But they haven’t.

Wondering what I have done wrong.

Bron

[pfaffman (Jay Pfaffman)]

@IrisBetty

There is a post on running a query that copies all users from certain groups into a new group.

You cannot change data with the data explorer plugin. I promise.

@IrisBetty

I want to copy from the current Everyone into a new group.

You’ll need to use the API (which will be hard unless you don’t have many users) or get the folks that are hosting you to do it from Rails.

[IrisBetty]

Got it, thanks. I thought I used the data explorer to get the list and then I used that to upload to the group. I must have misunderstood. thanks for your quick advice. I’ll wait for Richard O to do it for me. Born

[pfaffman (Jay Pfaffman)]

@IrisBetty

then I used that to upload to the group

OH! I missed that part. But I don’t know if there’s a way to upload a list for a group, except as an invite?

[IrisBetty]

Adding users from groups to other groups in bulk

This guide explains how to add existing users from one or more groups to other groups using a combination of Data Explorer and bulk invites. Required user level: Administrator Summary This guide will show you how to: Create a Data Explorer query to select users from specific groups Download the query results as a CSV file Use the bulk invite feature to add these users to new groups Requirements Data Explorer plugin installed Administrator access to you…

But if it doesn’t actually add them but sends an invitation then it is of no use and I think you are probably correct.

thanks again Jay.