Discourse Data Explorer Import no longer works?

Bug
,
1

I’ve been trying to import some SQL queries from one discourse forum to another. Worked fine for the last few years. However, now when I try to import a query it allows me to select it and then nothing happens. Thoughts?

1 Like
2

You’ll need to share more information like what the query was.

How are you trying to import them?

2 Likes
3

This is an example for one of the queries:

--[params]
-- integer :page = 0

SELECT topic_views.*, single_sign_on_records.external_id, topics.title
from topic_views
left join single_sign_on_records
on topic_views.user_id = single_sign_on_records.user_id
left join topics
on topic_views.topic_id = topics.id
OFFSET :page * 1000
LIMIT ALL

I try to import it using the import button and selecting the file (attached)
topic-views.dcquery.json (605 Bytes)

Edit:

Using this button:

Screenshot 2024-02-12 at 09.58.52
Screenshot 2024-02-12 at 09.58.521208×222 15.8 KB

4

I hadn’t remembered that was a feature. When I try clicking import and selecting a file, nothing seems to happen.

5

It worked fine up until about October, you could export the json file and import no problem. Now as you say, nothing happens. Its much quicker than copying and pasting because I have a large number of files.

1 Like
6

You might move this to bug

1 Like
7

This is a side effect of this change (in pick-files-button.js):

By removing this.onFilesPicked(files);, you remove the action call defined here:

3 Likes
8

So this was a change made by Discourse so there isn’t a way for me personally to fix?

2 Likes
9

That’s right; it’s best to wait for a fix.

2 Likes
11

Thanks for reporting this! It should now be resolved :tada:

3 Likes
13

This topic was automatically closed after 42 hours. New replies are no longer allowed.