The Network Subscription Process in CRM is returning Addresses with IDs formatted with zeros at the end, such as: 852352217691194000. Why is this happening?
A Comma Separated Values (.CSV) file is imported or edited in Microsoft Excel. It is a known feature in Excel that when importing .CSVs, the last 3 digits of the IDs transform to the closer thousand. This results in the occurrence described above.
Use an editor designed specifically for working with .CSV files. Example: Ron's Editor.
Send us your feedback: We're always looking for advice to help improve our Knowledge Base! Please let us know if this article was helpful or provide feedback on how we can improve your experience here.