Export to JSON unavailable Follow
Recently moved my DataGrip installation to a new PC and in the process installed the latest version (DataGrip 2022.3.3
Build #DB-223.8617.3, built on January 10, 2023).
I find that I am now no longer able to export data in JSON format, only as CSV, TSV, pipe-separated types.
It would appear that the JSON data extractor is no longer available.
Any ideas on how I can retrieve the export as JSON format back again?
Please sign in to leave a comment.
Below find the contents of the JSON-Groovy.json.groovy extractor that I have.
Please check that extractor mentioned above exists on your machine.
It would appear that my installation is missing some directories.
All I have is C:\Users\<user>\AppData\Roaming\JetBrains\DataGrip2022.3\extensions\com.intellij.database\schema (which is empty)
There isn't even a C:\Users\<user>\AppData\Roaming\JetBrains\DataGrip2022.3\extensions\com.intellij.database\data directory, let alone C:\Users\<user>\AppData\Roaming\JetBrains\DataGrip2022.3\extensions\com.intellij.database\data\extractors
Please try to reinstall IDE.
Just tried the following steps
Result - no option to export in JSON format only CSV.
Checking C:\Users\<user>\AppData\Roaming\JetBrains\DataGrip2022.3 there's not even an extensions directory.
I think that I'm going to have to find a working installation of DataGrip and copy the relevant directories and files.
Are there other folders in "C:\Users\<user>\AppData\Roaming\JetBrains\DataGrip2022.3"? Please check that folder is empty after uninstallation and remove it manually before installation.
I've looked further.
It would appear that installation of DataGrip places files in c:\Users\<user>\AppData\Local\Jetbrains\DataGrip2022.3 as well as C:\Users\<user>\AppData\Roaming\Jetbrains\DataGrip2022.3
Deleting files from just the Roaming profile prevented DataGrip from installing the extra directories required for the JSON data extractor.
Having uninstalled DataGrip, deleted DataGrip2022.3 directories and sub files from BOTH Local and Roaming and then reinstalled it now wiorks.
I noted that the additional directories in Roaming that contain the data extractors are installed when I select to export data.
Thank you for your help.
Thank you for that update! I tried to install DG by uninstalling the previous version and installing the new one after a reboot. That didn't go well because I couldn't connect to my Oracle db after re-install. I am using Kerberos authentication. Only after I restored the old folders was I able to log in. Perhaps I will follow your lead and make sure more sneaky DG user folders are removed first.
Make sure that the inside the Scratches and Consoles folder contains the following: