Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save W3BGUY/8d4ad67795adbff74048bd2644e193ba to your computer and use it in GitHub Desktop.
Save W3BGUY/8d4ad67795adbff74048bd2644e193ba to your computer and use it in GitHub Desktop.
JitterBit Conversion for Country Code in NetSuite AddressBook
<trans>
$contact_country=CASE(
$contact_countryShort=="AF","_afghanistan",
$contact_countryShort=="AX","_alandIslands",
$contact_countryShort=="AL","_albania",
$contact_countryShort=="DZ","_algeria",
$contact_countryShort=="AS","_americanSamoa",
$contact_countryShort=="AD","_andorra",
$contact_countryShort=="AO","_angola",
$contact_countryShort=="AI","_anguilla",
$contact_countryShort=="AQ","_antarctica",
$contact_countryShort=="AG","_antiguaAndBarbuda",
$contact_countryShort=="AR","_argentina",
$contact_countryShort=="AM","_armenia",
$contact_countryShort=="AW","_aruba",
$contact_countryShort=="AU","_australia",
$contact_countryShort=="AT","_austria",
$contact_countryShort=="AZ","_azerbaijan",
$contact_countryShort=="BS","_bahamas",
$contact_countryShort=="BH","_bahrain",
$contact_countryShort=="BD","_bangladesh",
$contact_countryShort=="BB","_barbados",
$contact_countryShort=="BY","_belarus",
$contact_countryShort=="BE","_belgium",
$contact_countryShort=="BZ","_belize",
$contact_countryShort=="BJ","_benin",
$contact_countryShort=="BM","_bermuda",
$contact_countryShort=="BT","_bhutan",
$contact_countryShort=="BO","_bolivia",
$contact_countryShort=="BA","_bosniaAndHerzegovina",
$contact_countryShort=="BW","_botswana",
$contact_countryShort=="BV","_bouvetIsland",
$contact_countryShort=="BR","_brazil",
$contact_countryShort=="IO","_britishIndianOceanTerritory",
$contact_countryShort=="BN","_bruneiDarussalam",
$contact_countryShort=="BG","_bulgaria",
$contact_countryShort=="BF","_burkinaFaso",
$contact_countryShort=="BI","_burundi",
$contact_countryShort=="KH","_cambodia",
$contact_countryShort=="CM","_cameroon",
$contact_countryShort=="CA","_canada",
$contact_countryShort=="IC","_canaryIslands",
$contact_countryShort=="CV","_capeVerde",
$contact_countryShort=="KY","_caymanIslands",
$contact_countryShort=="CF","_centralAfricanRepublic",
$contact_countryShort=="EA","_ceutaAndMelilla",
$contact_countryShort=="TD","_chad",
$contact_countryShort=="CL","_chile",
$contact_countryShort=="CN","_china",
$contact_countryShort=="CX","_christmasIsland",
$contact_countryShort=="CC","_cocosKeelingIslands",
$contact_countryShort=="CO","_colombia",
$contact_countryShort=="KM","_comoros",
$contact_countryShort=="CD","_congoDemocraticPeoplesRepublic",
$contact_countryShort=="CG","_congoRepublicOf",
$contact_countryShort=="CK","_cookIslands",
$contact_countryShort=="CR","_costaRica",
$contact_countryShort=="CI","_coteDIvoire",
$contact_countryShort=="HR","_croatiaHrvatska",
$contact_countryShort=="CU","_cuba",
$contact_countryShort=="CY","_cyprus",
$contact_countryShort=="CZ","_czechRepublic",
$contact_countryShort=="DK","_denmark",
$contact_countryShort=="DJ","_djibouti",
$contact_countryShort=="DM","_dominica",
$contact_countryShort=="DO","_dominicanRepublic",
$contact_countryShort=="TP","_eastTimor",
$contact_countryShort=="EC","_ecuador",
$contact_countryShort=="EG","_egypt",
$contact_countryShort=="SV","_elSalvador",
$contact_countryShort=="GQ","_equatorialGuinea",
$contact_countryShort=="ER","_eritrea",
$contact_countryShort=="EE","_estonia",
$contact_countryShort=="ET","_ethiopia",
$contact_countryShort=="FK","_falklandIslands",
$contact_countryShort=="FO","_faroeIslands",
$contact_countryShort=="FJ","_fiji",
$contact_countryShort=="FI","_finland",
$contact_countryShort=="FR","_france",
$contact_countryShort=="GF","_frenchGuiana",
$contact_countryShort=="PF","_frenchPolynesia",
$contact_countryShort=="TF","_frenchSouthernTerritories",
$contact_countryShort=="GA","_gabon",
$contact_countryShort=="GM","_gambia",
$contact_countryShort=="GE","_georgia",
$contact_countryShort=="DE","_germany",
$contact_countryShort=="GH","_ghana",
$contact_countryShort=="GI","_gibraltar",
$contact_countryShort=="GR","_greece",
$contact_countryShort=="GL","_greenland",
$contact_countryShort=="GD","_grenada",
$contact_countryShort=="GP","_guadeloupe",
$contact_countryShort=="GU","_guam",
$contact_countryShort=="GT","_guatemala",
$contact_countryShort=="GG","_guernsey",
$contact_countryShort=="GN","_guinea",
$contact_countryShort=="GW","_guineaBissau",
$contact_countryShort=="GY","_guyana",
$contact_countryShort=="HT","_haiti",
$contact_countryShort=="HM","_heardAndMcDonaldIslands",
$contact_countryShort=="VA","_holySeeCityVaticanState",
$contact_countryShort=="HN","_honduras",
$contact_countryShort=="HK","_hongKong",
$contact_countryShort=="HU","_hungary",
$contact_countryShort=="IS","_iceland",
$contact_countryShort=="IN","_india",
$contact_countryShort=="ID","_indonesia",
$contact_countryShort=="IR","_iranIslamicRepublicOf",
$contact_countryShort=="IQ","_iraq",
$contact_countryShort=="IE","_ireland",
$contact_countryShort=="IM","_isleOfMan",
$contact_countryShort=="IL","_israel",
$contact_countryShort=="IT","_italy",
$contact_countryShort=="JM","_jamaica",
$contact_countryShort=="JP","_japan",
$contact_countryShort=="JE","_jersey",
$contact_countryShort=="JO","_jordan",
$contact_countryShort=="KZ","_kazakhstan",
$contact_countryShort=="KE","_kenya",
$contact_countryShort=="KI","_kiribati",
$contact_countryShort=="KP","_koreaDemocraticPeoplesRepublic",
$contact_countryShort=="KR","_koreaRepublicOf",
$contact_countryShort=="KW","_kuwait",
$contact_countryShort=="KG","_kyrgyzstan",
$contact_countryShort=="LA","_laoPeoplesDemocraticRepublic",
$contact_countryShort=="LV","_latvia",
$contact_countryShort=="LB","_lebanon",
$contact_countryShort=="LS","_lesotho",
$contact_countryShort=="LR","_liberia",
$contact_countryShort=="LY","_libyanArabJamahiriya",
$contact_countryShort=="LI","_liechtenstein",
$contact_countryShort=="LT","_lithuania",
$contact_countryShort=="LU","_luxembourg",
$contact_countryShort=="MO","_macau",
$contact_countryShort=="MK","_macedonia",
$contact_countryShort=="MG","_madagascar",
$contact_countryShort=="MW","_malawi",
$contact_countryShort=="MY","_malaysia",
$contact_countryShort=="MV","_maldives",
$contact_countryShort=="ML","_mali",
$contact_countryShort=="MT","_malta",
$contact_countryShort=="MH","_marshallIslands",
$contact_countryShort=="MQ","_martinique",
$contact_countryShort=="MR","_mauritania",
$contact_countryShort=="MU","_mauritius",
$contact_countryShort=="YT","_mayotte",
$contact_countryShort=="MX","_mexico",
$contact_countryShort=="FM","_micronesiaFederalStateOf",
$contact_countryShort=="MD","_moldovaRepublicOf",
$contact_countryShort=="MC","_monaco",
$contact_countryShort=="MN","_mongolia",
$contact_countryShort=="ME","_montenegro",
$contact_countryShort=="MS","_montserrat",
$contact_countryShort=="MA","_morocco",
$contact_countryShort=="MZ","_mozambique",
$contact_countryShort=="MM","_myanmar",
$contact_countryShort=="NA","_namibia",
$contact_countryShort=="NR","_nauru",
$contact_countryShort=="NP","_nepal",
$contact_countryShort=="NL","_netherlands",
$contact_countryShort=="AN","_netherlandsAntilles",
$contact_countryShort=="NC","_newCaledonia",
$contact_countryShort=="NZ","_newZealand",
$contact_countryShort=="NI","_nicaragua",
$contact_countryShort=="NE","_niger",
$contact_countryShort=="NG","_nigeria",
$contact_countryShort=="NU","_niue",
$contact_countryShort=="NF","_norfolkIsland",
$contact_countryShort=="MP","_northernMarianaIslands",
$contact_countryShort=="NO","_norway",
$contact_countryShort=="OM","_oman",
$contact_countryShort=="PK","_pakistan",
$contact_countryShort=="PW","_palau",
$contact_countryShort=="PS","_palestinianTerritories",
$contact_countryShort=="PA","_panama",
$contact_countryShort=="PG","_papuaNewGuinea",
$contact_countryShort=="PY","_paraguay",
$contact_countryShort=="PE","_peru",
$contact_countryShort=="PH","_philippines",
$contact_countryShort=="PN","_pitcairnIsland",
$contact_countryShort=="PL","_poland",
$contact_countryShort=="PT","_portugal",
$contact_countryShort=="PR","_puertoRico",
$contact_countryShort=="QA","_qatar",
$contact_countryShort=="RE","_reunionIsland",
$contact_countryShort=="RO","_romania",
$contact_countryShort=="RU","_russianFederation",
$contact_countryShort=="RW","_rwanda",
$contact_countryShort=="BL","_saintBarthelemy",
$contact_countryShort=="SH","_saintHelena",
$contact_countryShort=="KN","_saintKittsAndNevis",
$contact_countryShort=="LC","_saintLucia",
$contact_countryShort=="MF","_saintMartin",
$contact_countryShort=="VC","_saintVincentAndTheGrenadines",
$contact_countryShort=="WS","_Samoa",
$contact_countryShort=="SM","_sanMarino",
$contact_countryShort=="ST","_saoTomeAndPrincipe",
$contact_countryShort=="SA","_saudiArabia",
$contact_countryShort=="SN","_senegal",
$contact_countryShort=="RS","_serbia",
$contact_countryShort=="SC","_seychelles",
$contact_countryShort=="SL","_sierraLeone",
$contact_countryShort=="SG","_singapore",
$contact_countryShort=="SK","_slovakRepublic",
$contact_countryShort=="SI","_slovenia",
$contact_countryShort=="SB","_solomonIslands",
$contact_countryShort=="SO","_somalia",
$contact_countryShort=="ZA","_southAfrica",
$contact_countryShort=="GS","_southGeorgia",
$contact_countryShort=="ES","_spain",
$contact_countryShort=="LK","_sriLanka",
$contact_countryShort=="PM","_stPierreAndMiquelon",
$contact_countryShort=="SD","_sudan",
$contact_countryShort=="SR","_suriname",
$contact_countryShort=="SJ","_svalbardAndJanMayenIslands",
$contact_countryShort=="SZ","_swaziland",
$contact_countryShort=="SE","_sweden",
$contact_countryShort=="CH","_switzerland",
$contact_countryShort=="SY","_syrianArabRepublic",
$contact_countryShort=="TW","_taiwan",
$contact_countryShort=="TJ","_tajikistan",
$contact_countryShort=="TZ","_tanzania",
$contact_countryShort=="TH","_thailand",
$contact_countryShort=="TG","_togo",
$contact_countryShort=="TK","_tokelau",
$contact_countryShort=="TO","_tonga",
$contact_countryShort=="TT","_trinidadAndTobago",
$contact_countryShort=="TN","_tunisia",
$contact_countryShort=="TR","_turkey",
$contact_countryShort=="TM","_turkmenistan",
$contact_countryShort=="TC","_turksAndCaicosIslands",
$contact_countryShort=="TV","_tuvalu",
$contact_countryShort=="UG","_uganda",
$contact_countryShort=="UA","_ukraine",
$contact_countryShort=="AE","_unitedArabEmirates",
$contact_countryShort=="GB","_unitedKingdomGB",
$contact_countryShort=="US","_unitedStates",
$contact_countryShort=="UY","_uruguay",
$contact_countryShort=="UM","_uSMinorOutlyingIslands",
$contact_countryShort=="UZ","_uzbekistan",
$contact_countryShort=="VU","_vanuatu",
$contact_countryShort=="VE","_venezuela",
$contact_countryShort=="VN","_vietnam",
$contact_countryShort=="VG","_virginIslandsBritish",
$contact_countryShort=="VI","_virginIslandsUSA",
$contact_countryShort=="WF","_wallisAndFutunaIslands",
$contact_countryShort=="EH","_westernSahara",
$contact_countryShort=="YE","_yemen",
$contact_countryShort=="ZM","_zambia",
$contact_countryShort=="ZW","_zimbabwe",
true,''
);
if(Length($contact_country)>0 && $contact_country!=Null() && $contact_country!='',
$contact_country;,
Unmap();
);
</trans>
@W3BGUY
Copy link
Author

W3BGUY commented Jun 6, 2016

I use this when passing data from #Salesforce addresses to #NetSuite addresses. The Salesforce field is CountryCode. The NetSuite field is country. This code is placed inside a #JitterBit transformation script.

@steven-t-h
Copy link

This is great!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment