My imports are pulling in bad data; what's wrong?
A:
Excel has a habit of automatically changing values in fields based on format. To ensure quality CSV imports, make sure your zip code is a text field if it needs zeroes on the front, same thing for ID numbers with preceeding zeros, check that your dates are formated with four-digit years, etc.
Was this helpful?
Showing 3 reactions
Carlyn Maw commented
2012-05-03 13:19:00 -0700
Another quick tip – when importing data with dates, make sure the time zone is set correctly.
I got this support tip:
“When you import a date, NationBuilder will look at the time of the import in GMT and then adjust it to the timezone which your Nation is set to in the control panel:
https://YOURNATION.nationbuilder.com/admin/setting/edit
In this case PST is 8 hours behind GMT. The importer saw Dec. 15 2011 00:00:00 as the import date then shift it back 8 hours to align with your Nation’s settings (Dec. 14 2011 16:00:00)."
I got this support tip:
“When you import a date, NationBuilder will look at the time of the import in GMT and then adjust it to the timezone which your Nation is set to in the control panel:
https://YOURNATION.nationbuilder.com/admin/setting/edit
In this case PST is 8 hours behind GMT. The importer saw Dec. 15 2011 00:00:00 as the import date then shift it back 8 hours to align with your Nation’s settings (Dec. 14 2011 16:00:00)."
adriel hampton commented
2012-01-24 11:40:23 -0800
Chris, I moved this Q&A to http://nationbuilder.com/supporter_data, where you’ll find a bunch more information on this topic.
Join our team
We're hiring great software developers and organizers. Learn more →
