Defect #35560
closed
Relations in issue CSV Import appear to be ignored
Added by Simon Parker almost 3 years ago.
Updated almost 3 years ago.
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
- 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.
Also available in: Atom
PDF
Updated by