Publisher does not support the Fluid field type. Please do not contact asking when support will be available.

If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.

Ticket: relationship field is not updating

Status Resolved
Add-on / Version DataGrab 4.0.4
Severity
EE Version 6.3.4

HAMAD AL GAHTANI

Jun 01, 2022

Hello
I am trying to import entries from a CSV file
it has duplicated data but with a small difference in relation

so the behaviour is DataGrab will create new entry with relation with (path_ee_id) number 4
it should find the same (title) and try to update the content but this time it should add another relation 602
but every-time it keeps the first value of relation # 4
my field is multiple relation, I expected to add the new relation Id once it finds duplicated title
so how to add multiple relations? show i make it pipe (|) spreaated or this way should works as the

the Grid behaviour once entry updated Action to take when an entry is updated (Keep existing rows and append new), in relation it wont append the new too?

MY CSV like:

path_MDM_id major_name_Arabic major_name_English EE_cat_id speciality_code speciality_name_arabic speciality_name_english Path_name_arabic path_ee_id
2 الأعمال التجارية و الإدارة Business and management 6 32722 إدارة الوثائق والمحفوظات Management of Document Archives مسار واعد 4
2 الأعمال التجارية و الإدارة Business and management 6 32722 إدارة الوثائق والمحفوظات Management of Document Archives مسار الرواد 602

#1

BoldMinded (Brian)

Hi, Hamad. Please include a larger sample of your csv file, which includes 2 or 3 relevant entries, and share a link to it so I can download it. Pasting it into a comment field loses it’s formatting.

Also, please share the output of your DataGrab log file when attempting to run this import. https://docs.boldminded.com/datagrab/docs/troubleshooting

#2

HAMAD AL GAHTANI

Dear Please check this

https://bts.dndoon.net/Majors_minors_Paths_2.csv https://bts.dndoon.net/system/user/cache/DataGrab-import.log

#3

HAMAD AL GAHTANI

any updates team 😊

#4

BoldMinded (Brian)

No updates, sorry. I’ve been on vacation. I just tried logging into your CP and the login you provided does not work.

#5

HAMAD AL GAHTANI

Edited this comment by admin b/c login was provided in plain text in a non-private comment.

#6

BoldMinded (Brian)

Hamad, the next comment is going to have a link to a new build that should work, but you will need to update your import file. The Relationship import never supported multiple relationships properly, so instead of repeating the rows for an entry just to assign more than 1 relationship, I made it so you need only a single row for the parent entry, and then for the relationships separate the entry_ids with the pipe character. For example:

https://www.dropbox.com/s/p2gv4diwx7sxx47/ticket-2426.png?dl=0

So instead of having 5 rows to assign 5 relationships to the E-Business entry, just create 1 row with all the related entry ids in a single field.

This way is much more efficient than duplicating the rows because it ends up doing a lot of extra database calls and unnecessary saves and updates.

#7

BoldMinded (Brian)

Comment has been marked private.

#8

HAMAD AL GAHTANI

Brian, thanks for your help I will update you for sure

Login to reply