dosubot[bot] commented on issue #30383:
URL: https://github.com/apache/superset/issues/30383#issuecomment-2373317082
<!-- Answer -->
I found some similar issues and discussions that might help you resolve the
import errors you're encountering:
1. **Similar Issues and Discussions**:
- [Dashboard Import Error: An error occurred while importing dashboard:
Error importing dashboard Please re-export your file and try importing again
superset](https://github.com/apache/superset/discussions/25987)
<sup>[[1]](https://github.com/apache/superset/discussions/25987)</sup>.
- [Import is not working: An error occurred while importing dashboard:
Import dashboard failed for an unknown
reason](https://github.com/apache/superset/issues/19222)
<sup>[[2]](https://github.com/apache/superset/issues/19222)</sup>.
- [Dashboard Import Error: An error occurred while importing dashboard:
Error importing dashboard Please re-export your file and try importing again
superset](https://github.com/apache/superset/issues/25989)
<sup>[[3]](https://github.com/apache/superset/issues/25989)</sup>.
2. **Suggested Solutions**:
- **Downgrade to Version 4.0.0**: Some users have reported that
downgrading to version 4.0.0 resolved their import issues:
```bash
export TAG=4.0.0
docker compose -f docker-compose-image-tag.yml up
```
You can find more details and example dashboards in [this
issue](https://github.com/apache/superset/issues/19222)
<sup>[[2]](https://github.com/apache/superset/issues/19222)</sup>.
- **Check and Fix YAML Files**: If the error is related to incorrect
values in the `template_params` parameter, you can manually fix the exported
YAML files:
- Unzip the exported file.
- Search for the `template_params` field in the YAML files and replace
`''` with `null`.
- Recompress the directory and try importing again.
Detailed steps can be found in [this
issue](https://github.com/apache/superset/issues/26130)
<sup>[[4]](https://github.com/apache/superset/issues/26130)</sup>.
- **Ensure Correct Folder Structure**: Make sure the folder structure in
the ZIP file is correct. The root should contain directories like `Databases`
and `Datasets`. More details are available in [this
issue](https://github.com/apache/superset/issues/27284)
<sup>[[5]](https://github.com/apache/superset/issues/27284)</sup>.
3. **Import Request Structure**:
Ensure that your import request is correctly formatted and includes all
necessary information. The import endpoint expects a multipart/form-data
request with the following fields:
- `formData`: The uploaded file (ZIP or JSON).
- `passwords`: A JSON map of passwords for each featured database in the
ZIP file.
- `overwrite`: A boolean indicating whether to overwrite existing
dashboards.
- `ssh_tunnel_passwords`: A JSON map of passwords for each SSH tunnel
associated with a featured database in the ZIP file.
- `ssh_tunnel_private_keys`: A JSON map of private keys for each SSH
tunnel associated with a featured database in the ZIP file.
Example:
```python
import requests
url = "http://your-superset-instance/api/v1/dashboard/import/";
files = {
'formData': ('dashboard.zip', open('path/to/your/dashboard.zip',
'rb')),
}
data = {
'passwords': '{"databases/MyDatabase.yaml": "my_password"}',
'overwrite': 'true',
'ssh_tunnel_passwords': '{"databases/MyDatabase.yaml":
"my_ssh_password"}',
'ssh_tunnel_private_keys': '{"databases/MyDatabase.yaml":
"my_private_key"}',
}
response = requests.post(url, files=files, data=data)
print(response.status_code)
print(response.json())
```
Ensure that the paths and passwords in the JSON maps match the structure
and contents of your ZIP file
<sup>[[6]](https://github.com/apache/superset/blob/master/superset/dashboards/api.py)</sup><sup>[[7]](https://github.com/apache/superset/blob/master/superset/cli/importexport.py)</sup>.
4. **Permissions**:
Ensure that the user performing the import has the "can_write" permission
on the "Database" resource. Without this permission, the import will fail if
the database does not already exist
<sup>[[8]](https://github.com/apache/superset/blob/master/superset/commands/database/importers/v1/utils.py)</sup>.
These steps should help you troubleshoot and resolve the import errors
you're facing.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
