Can't import dashbaords with CLI about superset HOT 4 OPEN

To resolve the superset.commands.exceptions.CommandInvalidError: Error importing dashboard issue when trying to import dashboards using the CLI in Apache Superset, follow these steps:

1. Check User Permissions:
   Ensure the user has the necessary permissions to create or overwrite dashboards. This is checked by security_manager.can_access("can_write", "Dashboard").

2. Validate Configuration:
   Ensure the dashboard configuration (config dictionary) is correctly formatted and includes all necessary fields. Pay special attention to the uuid, position, and metadata fields.

3. Handle UUIDs and IDs:
   Ensure that the UUIDs for charts and datasets are correctly mapped and updated in the configuration. The update_id_refs function helps in updating these references.

4. Remove Deprecated Fields:
   Remove any deprecated fields from the configuration, such as show_native_filters in the metadata.

Additionally, ensure that the CLI command for importing dashboards is correctly used. Here is an example of how to use the import_dashboards command from superset/cli/importexport.py:

@click.command()
@with_appcontext
@click.option(
    "--path",
    "-p",
    required=True,
    help="Path to a single ZIP file",
)
@click.option(
    "--username",
    "-u",
    required=True,
    help="Specify the user name to assign dashboards to",
)
def import_dashboards(path: str, username: Optional[str]) -> None:
    """Import dashboards from ZIP file"""
    from superset.commands.dashboard.importers.dispatcher import ImportDashboardsCommand
    from superset.commands.importers.v1.utils import get_contents_from_bundle

    if username is not None:
        g.user = security_manager.find_user(username=username)
    if is_zipfile(path):
        with ZipFile(path) as bundle:
            contents = get_contents_from_bundle(bundle)
    else:
        with open(path) as file:
            contents = {path: file.read()}
    try:
        ImportDashboardsCommand(contents, overwrite=True).run()
    except Exception:  # pylint: disable=broad-except
        logger.exception(
            "There was an error when importing the dashboards(s), please check "
            "the exception traceback in the log"
        )
        sys.exit(1)

By following these steps and ensuring the configuration and permissions are correctly handled, you should be able to resolve the CommandInvalidError when importing dashboards using the CLI in Apache Superset ^[1][2][3].

To continue the conversation, mention @dosu.

from superset.

I have same issue as you too, in my cases:

• I have dashboards in json file first (exported from superset 2.0.0)
• import json file to superset 3.1.3-dev -> work, dashboard shown perfectly
• then I export these dashboards to zip and import again (both in superset 3.1.3-dev) -> some work, some throw errors same as yours

from superset.

Okay, please follow this #26130 to debug your zip file and yaml file to see any arguments have errors

from superset.

Hello,
my zip file is correct : the zip file (created from CLI) is imported with success from gui
I have just the error when I import the zip file from CLI

I have try again on superset 4.0.0, I have the same behavior

Best regards

from superset.