AnsweredAssumed Answered

Import records: update matching with case sensitivity?

Question asked by rank_amateur on Sep 19, 2018
Latest reply on Sep 19, 2018 by rank_amateur

Hello     — I have a routine of exporting a spreadsheet from Salesforce and then importing into FMP. When I use "update matching", I'm getting errors, because some of the Salesforce IDs are identical to others except for a difference in case.


Is there a way to force FMP to accept only case-sensitive matches? Or does a workaround spring to mind? (I've used both .csv and .xlsx but that hasn't helped.)


Thank you to this community, as ever...