Project

General

Profile

Actions

Defect #35560

closed

Relations in issue CSV Import appear to be ignored

Added by Simon Parker almost 3 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Normal
Category:
-
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

I have set up a simple CSV file with "Related To", "Precedes" and "Follows" columns, but these appear to have no effect.
The csv file is attached.
On import, the issues appear, but they are not related in any way. Even the fourth line, which relates to an existing issue has no relationship in it.

This is our setup


Environment:
Redmine version 4.2.1.stable
Ruby version 2.6.7-p197 (2021-04-05) [x86_64-linux]
Rails version 5.2.5
Environment production
Database adapter Mysql2
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
SCM:
Subversion 1.14.1
Git 2.31.1
Filesystem
Redmine plugins:
clipboard_image_paste 1.13
gerrit_connector 0.1.0
redmine_base_deface 1.5.3
redmine_hourglass 1.1.2+develop
redmine_wiki_extensions 0.9.2
redmine_wktime 4.2.1
sidebar_hide 0.0.8
stopwatch 0.1.0
wiki_graphviz_plugin 0.8.0


Files

RelationTest.csv (322 Bytes) RelationTest.csv CSV file to test relationships Simon Parker, 2021-07-13 05:47
Actions #1

Updated by Marius BĂLTEANU over 2 years ago

  • Status changed from New to Closed
  • Assignee set to Marius BĂLTEANU
  • Resolution set to Invalid

Thanks Simon for reporting this issue.

I've investigated your case and I found that in your CSV file there is a duplicated relation entry:
  • "Issue Two" precedes "Issue Three"
  • "Issue Three" follows "Issue Two"
    This generates a duplicated follows relations which is forbidden.

The import succeed if you remove from the mapping one of the Precedes/Follows columns.

Working on this, I've found indeed some issues in Redmine and I created tickets for them:
  • The "follow" duplicated relations entry fails with 500 internal error (#35655)
  • When importing issue relations, the validation messages are not shown in the UI (#35656)
    but both issues are just improving the validation message when the import fails.

For now, I'm closing this as Invalid because if you use a correct CSV, the import should work as expected. Please reopen if you find anything else or you still have questions about issue relations import.

Actions

Also available in: Atom PDF