Execution Error when importing file

Hi everyone.

Struggling to debug what seemed to be an easy issue. I'm importing a really basic .csv file into leads, nothing major, Name/ID and street. However when I run the code I get the error:

Error: Execution
Field Name Execution Error
Value NOTICE: [8] Undefined index: sms_append_opp_c on line 178 in file /var/www/acloud-crm/modules/pmse_Inbox/engine/parser/PMSEFieldParser.php

The field sms_append_opp_c is on the opportunities module, but the error seemingly isn't related to any logic hooks, has anyone got any idea why this is happening?

The import is working just fine, it just says "1 row failed out of 8" but there's only 7 anyway.

Thanks,

Daniel

0 Dmytro Chupylka over 4 years ago

an empty line at the end of the csv file?

Best Regards,
Dmytro Chupylka

integroscrm.com
We make work in Sugar CRM system faster, more convenient and efficient
0 Daniel Hill over 4 years ago in reply to Dmytro Chupylka

Afraid not! Did double check that first, even with just 7 lines on the CSV it returns with:

7 records updated successfully
1 rows were not imported due to error
0 Dmytro Chupylka over 4 years ago in reply to Daniel Hill

header? can you show csv (with no PII of course)

Best Regards,
Dmytro Chupylka

integroscrm.com
We make work in Sugar CRM system faster, more convenient and efficient
0 Ramya Katram over 4 years ago in reply to Dmytro Chupylka

Hi Daniel,

Yes it must be the header row which is throwing as an error as said by Dmytro Chupylka. You no need to worry much about that.
0 Dmytro Chupylka over 4 years ago in reply to Ramya Katram

hi Ramya Katram
i'm asking for a file (with PII cleared out) to confirm the reason

Best Regards,
Dmytro Chupylka

integroscrm.com
We make work in Sugar CRM system faster, more convenient and efficient
0 Daniel Hill over 4 years ago in reply to Dmytro Chupylka
Hi do you have a recommendation on how to host the file as the club doesn't seem to do direct uploads? The CSV copy/paste is simply:

Fullscreen
1
2
3
4
HH ID Prefix,ID,Email Address,First Name,Last Name,Mobile,Primary Address Street,Primary Address Town/City,Primary Address County,Primary Address Postcode,Primary Address Country,Business Type,Primary Source,Secondary Source,Service Type,Description,Visitor ID
HH607,8428299c-7bfc-11eb-9dbb-00163e195c39,test@test.com,Test,MergeTest1337,54654654,123 strett,London,street,b97 3er,uk,Private,Outbound - Book an appointment,Branch Signage,Live In Ongoing,fdgdfgdfgfdgfdgfdgfdgfdgfdgfdgdsfgsdfgsdfgdsfgdfsg,fdgfdgd
HH609,99b881e0-7c28-11eb-a38f-00163e195c39,test@test.com,Test1,MergeTest2345,54654654,123 street,bolton,china,nn2 1hl,uk,CHC / NHS / CCG / Hospice,Outbound - Book an appointment,Bright Horizons,Hourly Respite,fdgdfgdfgfdgfdgfdgfdgfdgfdgfdgdsfgsdfgsdfgdsfgdfsg,fdgfdgd
HH610,15182174-7ff3-11eb-a541-00163e195c39,test@test.com,Test2,Test234,54654654,123 street,bolton,china,nn2 1hl,uk,Charity,Outbound - Call me back now,Branch Signage,Hourly Ongoing,fdgdfgdfgfdgfdgfdgfdgfdgfdgfdgdsfgsdfgsdfgdsfgdfsg,fgfdgd
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
HH ID Prefix,ID,Email Address,First Name,Last Name,Mobile,Primary Address Street,Primary Address Town/City,Primary Address County,Primary Address Postcode,Primary Address Country,Business Type,Primary Source,Secondary Source,Service Type,Description,Visitor ID HH607,8428299c-7bfc-11eb-9dbb-00163e195c39,test@test.com,Test,MergeTest1337,54654654,123 strett,London,street,b97 3er,uk,Private,Outbound - Book an appointment,Branch Signage,Live In Ongoing,fdgdfgdfgfdgfdgfdgfdgfdgfdgfdgdsfgsdfgsdfgdsfgdfsg,fdgfdgd HH609,99b881e0-7c28-11eb-a38f-00163e195c39,test@test.com,Test1,MergeTest2345,54654654,123 street,bolton,china,nn2 1hl,uk,CHC / NHS / CCG / Hospice,Outbound - Book an appointment,Bright Horizons,Hourly Respite,fdgdfgdfgfdgfdgfdgfdgfdgfdgfdgdsfgsdfgsdfgdsfgdfsg,fdgfdgd HH610,15182174-7ff3-11eb-a541-00163e195c39,test@test.com,Test2,Test234,54654654,123 street,bolton,china,nn2 1hl,uk,Charity,Outbound - Call me back now,Branch Signage,Hourly Ongoing,fdgdfgdfgfdgfdgfdgfdgfdgfdgfdgdsfgsdfgsdfgdsfgdfsg,fgfdgd
0 Daniel Hill over 4 years ago in reply to Daniel Hill

Strangely enough, removing the 3rd record (4th row) the error disappears...
0 Dmytro Chupylka over 4 years ago in reply to Daniel Hill

No line feed at the end, try to add it

Best Regards,
Dmytro Chupylka

integroscrm.com
We make work in Sugar CRM system faster, more convenient and efficient
0 Daniel Hill over 4 years ago in reply to Dmytro Chupylka

Apologises for the delay, same issue. That 3rd row just seems to break it...
0 Dmytro Chupylka over 4 years ago in reply to Daniel Hill

as an option - you may try to switch 3rd row with e.g. the 2nd row.
If it won't help - the problem could be in the data of the 3rd row -changing values column by column setting them equal to "good" row 2 - and you probably find the value that causes the issue.
I would also add quotes to the values

Best Regards,
Dmytro Chupylka

integroscrm.com
We make work in Sugar CRM system faster, more convenient and efficient