import/export tags

[mutdmour]

https://community.n8n.io/t/export-workflows-with-tags/6161

[ivov]

Long-time requested feature, thanks for taking this on.

[ivov]

Export tests

• Single-file export via CLI: packages/cli/bin/n8n export:workflow --all --input=wf.json --pretty → Pass: JSON contains correct tags
• Multi-file export via CLI: packages/cli/bin/n8n export:workflow --all --separate --output=mydir --pretty → Pass: JSON contains correct tags
• Single-workflow export via UI → Pass: JSON contains correct tags

Import tests

• Single-file import via CLI: packages/cli/bin/n8n import:workflow --input=wfs.json → Fail: Single file containing two workflows, each workflow referencing the same tag, triggers SQLITE_CONSTRAINT: UNIQUE constraint failed: tag_entity.name. Example: [{ "id": 1, ..., "tags": [ { "name": "tagX", ... } ] }, { "id": 2, ..., "tags": [ { "name": "tagX", ... } ] }]
• Multi-file import via CLI: packages/cli/bin/n8n import:workflow --separate --input=mydir → Fail: Multiple files, each containing a workflow referencing the same tag, triggers SQLITE_CONSTRAINT: UNIQUE constraint failed: tag_entity.name. Example: { "id": 1, ..., "tags": [ { "name": "tagX", ... } ] } and { "id": 2, ..., "tags": [ { "name": "tagX", ... } ] }
• Single-workflow import via UI → Pass: Displayed workflow is correctly tagged. (But imported workflow is not named per JSON - unclear if it should be.)

[ivov]

Import tests

Single-file import via CLI: packages/cli/bin/n8n import:workflow --input=wfs.json with two workflows having a shared tag

• Pass on sqlite
• Fail on mysql: An error occurred while importing workflows. See log messages for details. Duplicate entry 'tagX' for key 'tag_entity.IDX_8f949d7a3a984759044054e89b'
• Fail on postgres: An error occurred while importing workflows. See log messages for details. duplicate key value violates unique constraint "idx_812eb05f7451ca757fb98444ce"

Multi-file import via CLI: packages/cli/bin/n8n import:workflow --separate --input=mydir with two workflows having a shared tag

• Pass on sqlite
• Fail on mysql: An error occurred while importing workflows. See log messages for details. Duplicate entry 'tagX' for key 'tag_entity.IDX_8f949d7a3a984759044054e89b'
• Fail on postgres: An error occurred while importing workflows. See log messages for details. duplicate key value violates unique constraint "idx_812eb05f7451ca757fb98444ce"

Single-workflow import via UI from file

• Pass on sqlite, mysql, postgres: Tags saved correctly, but workflow name not set from JSON. (Not clear if workflow name not set from JSON is intended behavior.)

Single-workflow import via UI from URL

• Did not test, same logic as importing from file import.

Export tests

All-workflows export via CLI: packages/cli/bin/n8n export:workflow --all --output=all.json --pretty

• Pass on sqlite: JSON contains correct tags
• Pass on mysql: JSON contains correct tags
• Pass on postgres: JSON contains correct tags

Single-workflow export via CLI: packages/cli/bin/n8n export:workflow --id=1 --output=1.json --pretty

• Pass on sqlite: JSON contains correct tags
• Pass on mysql: JSON contains correct tags
• Pass on postgres: JSON contains correct tags

[janober]

Great, thanks a lot. Got merged.

[janober]

Got released with n8n@0.180.0