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
BoldMinded (Brian)
Jun 02, 2022
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
HAMAD AL GAHTANI
Jun 02, 2022
Dear Please check this
https://bts.dndoon.net/Majors_minors_Paths_2.csv
https://bts.dndoon.net/system/user/cache/DataGrab-import.log
HAMAD AL GAHTANI
Jun 03, 2022
any updates team 😊
BoldMinded (Brian)
Jun 05, 2022
No updates, sorry. I’ve been on vacation. I just tried logging into your CP and the login you provided does not work.
HAMAD AL GAHTANI
Jun 05, 2022
Edited this comment by admin b/c login was provided in plain text in a non-private comment.
BoldMinded (Brian)
Jun 06, 2022
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:
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.
BoldMinded (Brian)
Jun 06, 2022
Comment has been marked private.
HAMAD AL GAHTANI
Jun 08, 2022
Brian, thanks for your help I will update you for sure