craftcms/feed-me

Wrong relationship entries getting added

Opened this issue · 0 comments

albertvisuals commented

Description

I am importing a CSV file. Within the file I have the column Fotografen where the values are separated with a |
Within the feed me php I have specified the delimiter

    'csvColumnDelimiter' => ';',
    'dataDelimiter' => '|',
    'backupCommand' => '"' . getenv('HOME') . '/Library/Application Support/Herd/bin/mysqldump"',
    'logging' => true,

In the Feed me import settings I have machted the relationship fields with the CSV column and set it to create a new entry if it does not exist.

The bug is now that it somehow adds random other artists to the entry, which do not belong there. It seems to only have issues when there are multiple artist in the column. I have not figured out why this is happening. It also seems not to happen on every entry but it seems to be random. I have tried to split the CSV in smaller pieces, but it does not change. It also does not happen on the same item every time I import. I have reset the database to be empty and imported again and the a previous fault entry was correct but another one shows the same issue. It happens across al related_entry fields.
I do not get any errors when importing.

Image
Image

Additional info

  • Craft version: 5.5.3
  • PHP version: 8.3
  • Database driver & version: MySQL 8.0.36
  • Plugins & versions: