Troubleshooting Bulk Imports

9 min read

This article covers howw you can navigate to the error logs linked to a certain Contact Import Bulk Action and how to work through the errors to resolve them:

Master Bulk Importing Error Code List

Error IDError CodeWhat the Error MeansSteps to Resolve the Error
1001UnknownMonstro is unable to process the file due to an unknown error. Your data was not imported.Confirm that your file meets all requirements. Try to re-import after clearing your browser cache or using another browser.
1002The import file contains an Owner value that matches more than one user in the account. This usually occurs for names. The affected records were imported, but the Owner's property does not contain a value.Replace the name of the owner with their email address in your import file, then re-import the file. You can also manually update the Owner property value in the affected records.
1003The import file contains more than one sheet. Your data was not imported.Remove any additional sheets from your import file, then re-import. Review additional file requirements for importing into Monstro.
1004A required property in the import file contains an invalid value. The data in that row was not imported.Confirm the format requirements of your specific property or the property type, update your file to match the correct format, then re-import.
1005The import file contains a value that does not match an existing option in an enumeration property. The affected records were still imported, but the enumeration property does not contain a value.Identify the incorrect value by comparing your import file against the property in Monstro. You can choose to update the value in your import file to match an existing option or add the value as a custom option to your property. Once you're done, re-import the file or manually update the property value in the affected records.
1006During the import, the checkbox to update existing records using Contact IDs was selected. However, the Contact ID listed in the file did not match an existing ID in Monstro. The records were not imported.Ensure that the [object] IDs are correct. You may need to export your existing records to get the correct object IDs. If you're not updating or associating existing objects in Monstro, do not select the checkbox during the import process.
1007The file you selected was not found. Your data was not imported.Verify that you have saved your file to your computer and that it is the correct file type. Once you've done that, re-upload the file.
1008Failed validation of Email. The import file contains an email address that does not conform to the format of a typical email address. The import did not create or update the records.For contacts, update your import file with the correct email, to make sure your format is correct with '@' '.com then re-import the file.
1009The import file contains a row with data that cannot be processed because there is no value against the record of its unique identifier (primary column).Verify that your data value matches the correct format for the property you are importing, then re-import the file. You can also manually update the property value in the affected records.
1010The same value of the primary column is present against multiple records. Your data was imported against all HL records but there may be duplicates of the same record in MonstroChoose a different column header to act as your primary column or fix any mistakes, then re-import the files.
1011The same unique value was used multiple times within your files. Your data was imported but there may be duplicates of the same record in Monstro. If you were trying to associate, your records were not associated.Choose a different column header to act as your unique value or fix any mistakes, then re-import the files.
1012The same Contact ID was used multiple times within your files. The affected records were not updated or associated in Monstro.Update your import file so that there is only one row with that Contact ID. Keep the row with the most up-to-date information that you want to be included in Monstro. Once you've removed duplicates, re-import the files.
1013The import file contains a value for a number property with non-numeric characters or numbers not formatted as per E.164 format. The affected records were imported, but the number property does not contain a value.Update your import file with the correct numerical value and re-import, or manually update the property value in the affected records.
1014The import file contains a date value that does not match the format you selected during the import process. The affected records were imported, but the date property does not contain a value.Update your import file with the correct value and re-import, or manually update the property value in the affected records.
1015The import file contains a record owner that does not match a user in Monstro. The affected records were imported, but the Owner field does not contain a value.Update the data in the Owner.

List of supported Time zones

Time ZoneTime Zone
Etc/GMT+12Europe/London
Pacific/MidwayAfrica/Cairo
Pacific/HonoluluAfrica/Harare
America/JuneauEurope/Amsterdam
US/AlaskaEurope/Belgrade
America/DawsonEurope/Brussels
America/Los_AngelesEurope/Madrid
America/PhoenixEurope/Oslo
America/TijuanaEurope/Sarajevo
US/ArizonaAfrica/Nairobi
America/BelizeAsia/Amman
America/BoiseAsia/Baghdad
America/ChihuahuaAsia/Jerusalem
America/DenverAsia/Kuwait
America/EdmontonAsia/Qatar
America/GuatemalaEurope/Athens
America/ManaguaEurope/Bucharest
America/ReginaEurope/Helsinki
Canada/SaskatchewanEurope/Moscow
US/MountainAsia/Baku
America/Bahia_BanderasAsia/Dubai
America/BogotaAsia/Kabul
America/CancunAsia/Tehran
America/ChicagoAsia/Karachi
America/Mexico_CityAsia/Yekaterinburg
US/CentralAsia/Colombo
America/CaracasAsia/Kolkata
America/DetroitAsia/Calcutta
America/Indiana/IndianapolisAsia/Kathmandu
America/LouisvilleAsia/Almaty
America/ManausAsia/Dhaka
America/New_YorkAsia/Rangoon
America/SantiagoAsia/Bangkok
America/Santo_DomingoAsia/Krasnoyarsk
America/TorontoAsia/Irkutsk
US/East-IndianaAsia/Kuala_Lumpur
US/EasternAsia/Shanghai
America/Argentina/Buenos_AiresAsia/Taipei
America/Glace_BayAustralia/Perth
America/MontevideoAsia/Seoul
America/Sao_PauloAsia/Tokyo
Canada/AtlanticAsia/Yakutsk
America/St_JohnsAustralia/Adelaide
Canada/NewfoundlandAustralia/Darwin
America/GodthabAsia/Vladivostok
America/NoronhaAustralia/Brisbane
Etc/GMT+2Australia/Canberra
Atlantic/Cape_VerdeAustralia/Hobart
Atlantic/AzoresAustralia/Sydney
UTCPacific/Guam
Africa/AlgiersAsia/Magadan
Africa/CasablancaPacific/Auckland
Africa/LagosPacific/Fiji
Atlantic/CanaryPacific/Tongatapu

Accepted Custom Field Format Requirements

Depending on the records you are importing, your file could include the following columns:

Date Picker

  • Acceptable formats-
    • mm/dd/yyyy (e.g. 10/28/2020)
    • yyyy/mm/dd (e.g. 2020/10/28)
    • You can also replace '/' with '-' '.' and it'll recognize the uploaded fields as a Date field (Available in our future release!)

Multiple Options, Checkbox, Textbox List

  • Acceptable formats-
    • Value 1, Value 2, Value 3 ...... (e.g. Blue, Yellow, Green or Blue, Yellow, Green or Blue, Yellow , Green)
    • You can also replace ' , ' with ' ; ' ' . ' and it'll recognize the uploaded fields as the aforementioned field

Radio, Single Option

  • Acceptable formats:

    • Value 1 (e.g. Blue)

File Upload, Signature

  • Not Supported

Contact Owner

  • To assign an owner to your contacts during the import, include the name of the 'User'
  • Acceptable formats:

    • FirstName LastName (e.g. Logan Paul or logan paul)

    • LastName FirstName (e.g. Paul Logan or paul logan)

    • Note #1: Unless the user has both FirstName and Last Name, the system will not recognize it during the upload

Tags

  • Acceptable formats-
    • Value 1, Value 2, Value 3 ...... (e.g. Blue,Yellow,Green or Blue, Yellow, Green or Blue , Yellow , Green)
      • You can also replace ' , ' with ' ; ' ' . ' and it'll recognize the uploaded fields as the aforementioned field.
Tags (Example Formats)Status
lowercaseok
UPPERCASEok (will be lowercased)
ProperCaseok (will be lowercased)
with a spaceok
With A Spaceok (will be lowercased)
pre-existing tagok (maps successfully)

DoNotDisturb

  • Acceptable formats-

    • True or False ( true or false )

    • Yes or No ( yes or no )

Phone Number

  • For the vast majority of cases, as long as you format the phone numbers in E.164 (Ex: +1 1234567890) our system will recognize it as valid- irrespective of the default Country picked at the sub-account level

    • Additionally, if you have set the Country to the US, the following would work perfectly fine as well
      • 123-456-7890
      • (123) 4567890
      • 1234567890
      • Furthermore, if you are working with international numbers (Outside the US), we'd encourage you to visit: https://libphonenumber.appspot.com/ and run your phone number format by the tool in conjunction with the codes below to ascertain its appropriateness for upload.

  • Numerical

    • Acceptable formats-
      • 1.23.4
      • 1234
      • .123

  • Monetary

    • Acceptable formats-
      • 1234
      • 1,234,234,333

List of supported Countries

CodeCountry
BDBangladesh
BEBelgium
BFBurkina Faso
BGBulgaria
BABosnia and Herzegovina
BBBarbados
WFWallis and Futuna
BLSaint Barthelemy
BMBermuda
BNBrunei
BOBolivia
BHBahrain
BIBurundi
BJBenin
BTBhutan
JMJamaica
BVBouvet Island
BWBotswana
WSSamoa
BQBonaire, Saint Eustatius and Saba
BRBrazil
BSBahamas
JEJersey
BYBelarus
BZBelize
RURussia
RWRwanda
RSSerbia
TLEast Timor
REReunion
TMTurkmenistan
TJTajikistan
RORomania
TKTokelau
GWGuinea-Bissau
GUGuam
GTGuatemala
GSSouth Georgia and the South Sandwich Islands
GRGreece
GQEquatorial Guinea
GPGuadeloupe
JPJapan
GYGuyana
GGGuernsey
GFFrench Guiana
GEGeorgia
GDGrenada
GBUnited Kingdom
GAGabon
SVEl Salvador
GNGuinea
GMGambia
GLGreenland
GIGibraltar
GHGhana
OMOman
TNTunisia
JOJordan
HRCroatia
HTHaiti
HUHungary
HKHong Kong
HNHonduras
HMHeard Island and McDonald Islands
VEVenezuela
PRPuerto Rico
PSPalestinian Territory
PWPalau
PTPortugal
SJSvalbard and Jan Mayen
PYParaguay
IQIraq
PAPanama
PFFrench Polynesia
PGPapua New Guinea
PEPeru
PKPakistan
PHPhilippines
PNPitcairn
PLPoland
PMSaint Pierre and Miquelon
ZMZambia
EHWestern Sahara
EEEstonia
EGEgypt
ZASouth Africa
ECEcuador
ITItaly
VNVietnam
SBSolomon Islands
ETEthiopia
SOSomalia
ZWZimbabwe
SASaudi Arabia
ESSpain
EREritrea
MEMontenegro
MDMoldova
MGMadagascar
MFSaint Martin
MAMorocco
MCMonaco
UZUzbekistan
MMMyanmar
MLMali
MOMacao
MNMongolia
MHMarshall Islands
MKMacedonia
MUMauritius
MTMalta
MWMalawi
MVMaldives
MQMartinique
MPNorthern Mariana Islands
MSMontserrat
MRMauritania