custom field containing database ID is exporting wrong number

The number that shows up on the Subscriber Snapshot is the correct number that came from our client's CRM database. But when I export the bounces, that custom field exports a truncated number.

For example:

Joe Smith's record ID that we uploaded and that shows in his snapshot is: 1054151204044455107
But when we export the subscriber records, his number gets changed to: 1.05415E+18

How do I get the exported data to be exactly what's in the CM system and shows on the snapshot page?


MondoVox, 8 years ago

OK, I figured it out. Export to .txt file and using text wizard in Excel, change that field type to 'text'. THEN open the document. Only took me an hour to figure out that I can't change the fields to 'text' type once the file is already pulled through Excel. The numbers don't go back.

Mathew Mathew, 8 years ago

Thanks for the update Julia, that's going to come in handy for people.

Get in touch with us on Twitter:
We're also on Facebook:

See why 200,000 companies worldwide love Campaign Monitor.

From Australia to Zimbabwe, and everywhere in between, companies count on Campaign Monitor for email campaigns that boost the bottom line.

Get started for free