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
9 years ago
Arline Welty 9 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
9 years ago
Support 9 years ago

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

Arline Welty
9 years ago
Arline Welty 9 years ago

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

D Dunn
9 years ago
D Dunn 9 years ago

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

Arline Welty
9 years ago
Arline Welty 9 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. 

9 years ago
Arline Welty 9 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