Countries of US addresses showing up as Foreign in some names
up vote
2
down vote
favorite
I have a mailing list of about 1,500 names. I have imported them into CiviCRM using a CSV spreadsheet file. The country field for all these names in my spreadsheet are all labeled United States. A good portion of my addresses after the import into CiviCrm are now listed as another country. Some show South Africa, etc. I've tried the import several times to no avail, but my original list is correct.
Any suggestions how to fix this? Thanks
Mark
contacts
asked 8 hours ago
Mark Wilson
161
add a comment |
up vote
2
down vote
favorite
I have a mailing list of about 1,500 names. I have imported them into CiviCRM using a CSV spreadsheet file. The country field for all these names in my spreadsheet are all labeled United States. A good portion of my addresses after the import into CiviCrm are now listed as another country. Some show South Africa, etc. I've tried the import several times to no avail, but my original list is correct.
Any suggestions how to fix this? Thanks
Mark
contacts
asked 8 hours ago
Mark Wilson
161
add a comment |
up vote
2
down vote
favorite
up vote
2
down vote
favorite
I have a mailing list of about 1,500 names. I have imported them into CiviCRM using a CSV spreadsheet file. The country field for all these names in my spreadsheet are all labeled United States. A good portion of my addresses after the import into CiviCrm are now listed as another country. Some show South Africa, etc. I've tried the import several times to no avail, but my original list is correct.
Any suggestions how to fix this? Thanks
Mark
contacts
asked 8 hours ago
Mark Wilson
161
I have a mailing list of about 1,500 names. I have imported them into CiviCRM using a CSV spreadsheet file. The country field for all these names in my spreadsheet are all labeled United States. A good portion of my addresses after the import into CiviCrm are now listed as another country. Some show South Africa, etc. I've tried the import several times to no avail, but my original list is correct.
Any suggestions how to fix this? Thanks
Mark
contacts
contacts
asked 8 hours ago
Mark Wilson
161
asked 8 hours ago
Mark Wilson
161
asked 8 hours ago
Mark Wilson
161
asked 8 hours ago
Mark Wilson
161
asked 8 hours ago
Mark Wilson
161
161
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
3
down vote
(You're relatively new here BTW so welcome!) It sounds as though your import sheet did not specify a country, but your site allows for multiple countries and thus multiple states/provinces. Even if the United States is your default country, I've found that the import routine will pick the first country it finds in the list of countries with similar state abbreviations, rather than hitting the correct one. The workaround to this is pretty simple; include a column for country in your import and populate it with United States (or the appropriate country).
Hope this helps!
answered 8 hours ago
Lesley Carter - BackOffice
1,127310
yep exactly the solution we have used and suggested to others for this problem. it can be fun though looking at dbs that others have imported and seeing all their US contacts spread across the globe ;-)
– petednz - fuzion♦
7 hours ago
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "605"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
noCode: true, onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fcivicrm.stackexchange.com%2fquestions%2f27690%2fcountries-of-us-addresses-showing-up-as-foreign-in-some-names%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
3
down vote
(You're relatively new here BTW so welcome!) It sounds as though your import sheet did not specify a country, but your site allows for multiple countries and thus multiple states/provinces. Even if the United States is your default country, I've found that the import routine will pick the first country it finds in the list of countries with similar state abbreviations, rather than hitting the correct one. The workaround to this is pretty simple; include a column for country in your import and populate it with United States (or the appropriate country).
Hope this helps!
answered 8 hours ago
Lesley Carter - BackOffice
1,127310
yep exactly the solution we have used and suggested to others for this problem. it can be fun though looking at dbs that others have imported and seeing all their US contacts spread across the globe ;-)
– petednz - fuzion♦
7 hours ago
add a comment |
up vote
3
down vote
(You're relatively new here BTW so welcome!) It sounds as though your import sheet did not specify a country, but your site allows for multiple countries and thus multiple states/provinces. Even if the United States is your default country, I've found that the import routine will pick the first country it finds in the list of countries with similar state abbreviations, rather than hitting the correct one. The workaround to this is pretty simple; include a column for country in your import and populate it with United States (or the appropriate country).
Hope this helps!
answered 8 hours ago
Lesley Carter - BackOffice
1,127310
yep exactly the solution we have used and suggested to others for this problem. it can be fun though looking at dbs that others have imported and seeing all their US contacts spread across the globe ;-)
– petednz - fuzion♦
7 hours ago
add a comment |
up vote
3
down vote
up vote
3
down vote
(You're relatively new here BTW so welcome!) It sounds as though your import sheet did not specify a country, but your site allows for multiple countries and thus multiple states/provinces. Even if the United States is your default country, I've found that the import routine will pick the first country it finds in the list of countries with similar state abbreviations, rather than hitting the correct one. The workaround to this is pretty simple; include a column for country in your import and populate it with United States (or the appropriate country).
Hope this helps!
answered 8 hours ago
Lesley Carter - BackOffice
1,127310
(You're relatively new here BTW so welcome!) It sounds as though your import sheet did not specify a country, but your site allows for multiple countries and thus multiple states/provinces. Even if the United States is your default country, I've found that the import routine will pick the first country it finds in the list of countries with similar state abbreviations, rather than hitting the correct one. The workaround to this is pretty simple; include a column for country in your import and populate it with United States (or the appropriate country).
Hope this helps!
answered 8 hours ago
Lesley Carter - BackOffice
1,127310
answered 8 hours ago
Lesley Carter - BackOffice
1,127310
answered 8 hours ago
Lesley Carter - BackOffice
1,127310
answered 8 hours ago
Lesley Carter - BackOffice
1,127310
1,127310
yep exactly the solution we have used and suggested to others for this problem. it can be fun though looking at dbs that others have imported and seeing all their US contacts spread across the globe ;-)
– petednz - fuzion♦
7 hours ago
add a comment |
yep exactly the solution we have used and suggested to others for this problem. it can be fun though looking at dbs that others have imported and seeing all their US contacts spread across the globe ;-)
– petednz - fuzion♦
7 hours ago
yep exactly the solution we have used and suggested to others for this problem. it can be fun though looking at dbs that others have imported and seeing all their US contacts spread across the globe ;-)
– petednz - fuzion♦
7 hours ago
yep exactly the solution we have used and suggested to others for this problem. it can be fun though looking at dbs that others have imported and seeing all their US contacts spread across the globe ;-)
– petednz - fuzion♦
7 hours ago
add a comment |
Thanks for contributing an answer to CiviCRM Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fcivicrm.stackexchange.com%2fquestions%2f27690%2fcountries-of-us-addresses-showing-up-as-foreign-in-some-names%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
