Back to connectors… Back to Sage CRM...

IMAN says a selection list value mapping is incorrect in Sage CRM transform- but I don't see how that could be. (5 replies)

Arline Welty
7 years ago
Arline Welty 7 years ago

Hi all,

Looking for a little advice on this. I'm importing a daily list of registered products from a CSV sheet to Sage  CRM, mapping to person & product entities. On one of my CSV rows, it says the selection list value is invalid, but I can see the selection list value both in the Sage CRM customization area and, if I manually create the product record in CRM using the selection list, the database value looks to match what's in the CSV.

What might be the issue? It doesn't happen with other products but I'm not sure what's up with this particular one. There are no spaces in the CSV or the CRM value.

Screenshots included...troubleshooting advice is welcomed.

Thanks!
Arline

https://www.realisable.co.uk/wp-content/uploads/2017/07/DatabaseValue_InputManually.jpg
Support
7 years ago
Support 7 years ago

Arline, what is the value you're trying to update to CRM?

Arline Welty
7 years ago
Arline Welty 7 years ago

Thanks guys, the value I'm trying to update to CRM is 'RFTECActive200Charger' in the field dqpr_productdesc. 

D Dunn
7 years ago
D Dunn 7 years ago

By chance is it the only value that is longer than 20 characters?

Arline Welty
7 years ago
Arline Welty 7 years ago

Thanks for checking but no, I just tested and I can successfully insert a product record with a value that's longer than 20 characters. 

7 years ago
Arline Welty 7 years ago

Closed due to inactivity.

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close