Back

Extender Windows and Detailed Windows truncating ID field at 15

Published: Dec 08, 2011
Post Author Written by Kevin Jones

When using SmartConnect to import into Extender Windows or Extender Detail Windows, the key field is being truncated at a length of 15 characters.


This will be resolved in the next release of SmartConnect. Currently to correct the issue you need to run these two SQL scripts against all your company databases. After running the scripts, the key field length will be set to 255 and the import will run correctly. You can download the SQL queries here

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.