Countries of US addresses showing up as Foreign in some names
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 Dec 12 '18 at 20:35
Mark WilsonMark Wilson
161
add a comment |
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 Dec 12 '18 at 20:35
Mark WilsonMark Wilson
161
add a comment |
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 Dec 12 '18 at 20:35
Mark WilsonMark 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 Dec 12 '18 at 20:35
Mark WilsonMark Wilson
161
asked Dec 12 '18 at 20:35
Mark WilsonMark Wilson
161
asked Dec 12 '18 at 20:35
Mark WilsonMark Wilson
161
asked Dec 12 '18 at 20:35
Mark WilsonMark Wilson
161
asked Dec 12 '18 at 20:35
Mark WilsonMark Wilson
161
161
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
(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 Dec 12 '18 at 20:39
Lesley Carter - BackOfficeLesley 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♦
Dec 12 '18 at 21:50
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',
autoActivateHeartbeat: false,
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
(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 Dec 12 '18 at 20:39
Lesley Carter - BackOfficeLesley 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♦
Dec 12 '18 at 21:50
add a comment |
(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 Dec 12 '18 at 20:39
Lesley Carter - BackOfficeLesley 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♦
Dec 12 '18 at 21:50
add a comment |
(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 Dec 12 '18 at 20:39
Lesley Carter - BackOfficeLesley 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 Dec 12 '18 at 20:39
Lesley Carter - BackOfficeLesley Carter - BackOffice
1,127310
answered Dec 12 '18 at 20:39
Lesley Carter - BackOfficeLesley Carter - BackOffice
1,127310
answered Dec 12 '18 at 20:39
Lesley Carter - BackOfficeLesley Carter - BackOffice
1,127310
answered Dec 12 '18 at 20:39
Lesley Carter - BackOfficeLesley 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♦
Dec 12 '18 at 21:50
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♦
Dec 12 '18 at 21:50
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♦
Dec 12 '18 at 21:50
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♦
Dec 12 '18 at 21:50
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.
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
