Sorry You Cant Import More Than 250000 Records at a Time Please Try Again With a Smaller Import
When importing records into HubSpot, you may see errors. Below, learn how to resolve an mistake detected during an import, download an error file, view mistake details, and right issues in your import file or Salesforce. Before starting an import or fixing a file with errors, learn the relevant terms and requirements for importing into HubSpot. Before y'all've completed an import, HubSpot checks for certain errors in the showtime 3 rows of your file. If whatever of the following errors are detected, they are brought to your attention while mapping properties in the import process: To resolve these errors from the Map columns in your file to HubSpot properties screen: Please annotation: since HubSpot simply detects errors in the first three rows, there may be boosted errors in the residue of your file that were not resolved. The post-obit is an alphabetized list of fault codes with details for the error and possible steps for resolution. In some cases, records with errors will be imported and can be corrected either in HubSpot, or past correcting the import file and reimporting. In other cases, records volition non import and the import file volition need to be corrected earlier reimporting. Please annotation: the fault codes in your file will contain capital letters and underscore characters, but are listed in normal text inside this article. For example, the fault volition appear as AMBIGUOUS_ENUMERATION_OPTION in the file, only y'all will detect information technology as Ambiguous enumeration option in the table below. The same tape matches more 1 of the existing options divers for an enumeration holding. This applies to multi-select, dropdown select, radio select, and checkbox type properties. You may besides see this fault if the value in your file is the belongings selection's label rather than its internal value. This applies to enumeration property options where the label is different than the internal value. The afflicted records were imported, but the enumeration belongings does not contain a value. Identify the incorrect value by comparing your import file confronting the property in HubSpot . U pdate the value in your import file to match only one existing option, or the option'due south internal value if the characterization is different from its internal value. Once yous've updated the value, then re-import the file. You can likewise Resolve errors during an import
Download an error file
Resolve an import file error
Cryptic enumeration option
What the error means
How to resolve the error
Could not find owner
What the error means
The import file contains a tape owner that does non lucifer a user in HubSpot. The affected records were imported, but the Owner field does not contain a value.
How to resolve the error
Update the data in the Owner column of your import file to include the first and final name or e-mail of a user in your business relationship. If the person you lot desire to assign the record to is not yet a user in the account, add together them as a user , then re-import with their proper name or e-mail as it appears in the account.
Could not parse engagement
What the mistake means
The import file contains a appointment value that does not friction match the format yous selected during the import procedure. The affected records were imported, but the date property does not comprise a value.
How to resolve the mistake
Update your import file with the correct value and re-import, or manually update the property value in the afflicted records.
Could non parse number
What the mistake means
The import file contains a value for a number property with non-numeric characters. The affected records were imported, simply the number property does non contain a value.
How to resolve the mistake
Update your import file with the correct numerical value and re-import, or manually update the property value in the affected records.
Could not parse row
What the fault ways
The import file contains a row with information that cannot be processed. If it'due south a required property, the records were not imported. If it'south not a required property, the records were imported, only that property does not contain a value.
How to resolve the error
Verify that your data value matches the right format for the belongings yous are importing, gear up any mistakes, then re-import the file. You can besides manually update the property value in the affected records.
Could not parse term
What the error means
The import file contains a value for a time period that does not match an accustomed term format. The affected records were nevertheless imported, but the term property does non comprise a value.
How to resolve the error
Update the term values in your file to be either a whole number of months or in ISO8601 Duration Format (e.g. a menstruum of fourth dimension of 3 years, six months, four days would be P3Y6M4D), then re-import the file. You lot can as well manually update the property value in the afflicted records.
Duplicate alternate ID
What the error means
The same alternate ID was used multiple times within your files. Your data was imported but at that place may be duplicates of the same record in HubSpot. If you were trying to associate, your records were not associated.
How to resolve the error
Choose a different column header to act as your alternating ID, then re-import the files.
- To avoid duplicates, use E-mail for contacts, Company domain name for companies, or [Object] ID for any object.
- To associate records , utilise Email , Company domain name , [Object] ID, or choose a one-to-many belongings where one value is unique for the many records associated with information technology (e.g. Company name as the one, which volition be associated with many contacts who work at the aforementioned company.) Refer to the sample import files for further guidance.
Duplicate clan ID
What the fault ways
The association ID you chose to acquaintance your records is not unique.
How to resolve the error
Choose a different column header to human action as the common column betwixt your two files. For best results, choose a one-to-many belongings where one value is unique for the many records associated with it (due east.yard. Company name equally the 1, which volition be associated with many contacts who piece of work at the same company.) Refer to the sample import files for further guidance. In one case you've selected a new clan ID, re-import your files.
Indistinguishable object ID
What the error means
The aforementioned [object] ID was used multiple times within your files. The afflicted records were not updated or associated in HubSpot.
How to resolve the error
Update your import file so that there is only one row with that [object] ID. Keep the row with the almost upward-to-date information that you lot desire included in HubSpot. Once y'all've removed duplicates, re-import the files.
Duplicate row content
What the error means
HubSpot detected that the import file contains duplicate records. The import did not create a new record.
How to resolve the error
Remove the duplicate in your import file and re-import.
Duplicate unique property value
What the fault ways
The same unique value was used multiple times within your files. Your data was imported merely there may be duplicates of the same tape in HubSpot. If you lot were trying to associate, your records were non associated.
How to resolve the mistake
Choose a unlike column header to human action as your unique value, then re-import the files.
- To avert duplicates, use Electronic mail for contacts, Company domain proper noun for companies, or [Object] ID for any object.
- To associate records , use Email , Company domain name , [Object] ID, or choose a one-to-many property where one value is unique for the many records associated with it (east.yard. Company proper noun as the one, which volition be associated with many contacts who work at the same company.) Refer to the sample import files for further guidance.
Failed to create association
What the fault means
HubSpot is unable to associate your records in their electric current format. The records were imported merely were non associated.
How to resolve the error
Verify that you have met the file requirements for associating your records. If importing in one file, you may need to add a unique identifier for each object. If importing in two files, you may need to select a different common column to properly associate. Make the changes to your files and re-import, or manually associate your records.
Failed to opt out contact
What the error means
HubSpot was unable to opt-out certain contacts in the opt-out file.
How to resolve the error
Failed to procedure object with empty property values
What the error ways
Y our file contains empty values for multiple columns and HubSpot was unable to procedure the record. Your information in that row was not imported.
How to resolve the error
Fill in the missing holding values of your import file, then re-import the file.
Failed validation of Email, Deal/Ticket phase, or Bargain/Ticket pipeline
What the error means
The import file contains an email address that does not suit to the format of a typical electronic mail accost (e.k., name@domain.com ) or a value for the Deal Stage, Bargain Pipeline, Ticket Status, or Ticket Pipeline property that does not friction match an existing stage, status, or pipeline name in HubSpot. The import did not create or update the records.
How to resolve the mistake
For contacts, update your import file with the right e-mail, and then re-import the file. For deals or tickets, update your import file with the correct stage, status, and pipeline name, or add together the custom deal phase or ticket status to HubSpot. One time you're done, re-import the file.
File non constitute
What the error means
The file you selected was non found. Your data was not imported.
How to resolve the error
Verify that you take saved your file to your reckoner and that information technology is the correct file type. Once you've done that, re-upload the file.
GDPR blacklisted email
What the error means
The import file contains i or more than emails that have been blocked from communication due to GDPR . These contacts were not imported.
How to resolve the error
The import file volition all the same import your other contacts, simply you tin can not add the blocked contacts via import. You can add these contacts manually, but they will be automatically opted-out of marketing communication.
Wrong number of columns
What the error means
The import file contains at least one column without a header. The data in columns without headers was non imported.
How to resolve the error
Ostend whether or not the data in the columns should be imported, add together appropriate headers or remove the columns, and then re-import the file.
Invalid alternate ID
What the fault means
The import file contains an invalid value imported as an email address, domain name, or [object] ID. The import did not create or update the record.
How to resolve the error
Update your import file with the right e-mail, domain proper name, or [object] ID value, then re-import the file.
Invalid association identifier
What the error means
The import file does not comprise a proper unique value to associate your records. The data was imported, but the resulting records were not associated in HubSpot.
How to resolve the fault
Update your import file to include a valid association identifier (e.g. Email for contacts, Visitor domain name for companies, or [object] IDs), so re-import the file. Learn how to gear up upwardly your files properly to import and associate multiple objects.
Invalid enumeration selection
What the mistake means
The import file contains a value that does not match an existing option in an enumeration property . This applies to multi-select, dropdown select, radio select, and checkbox type properties. The afflicted records were however imported, but the enumeration property does not comprise a value.
How to resolve the error
Identify the incorrect value by comparing your import file against the belongings in HubSpot. 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. In one case you're done, re-import the file or manually update the property value in the affected records.
Invalid file type
What the error means
The import file is the wrong file type for importing into HubSpot. Y our data was non imported.
How to resolve the mistake
Convert your file to a .csv, .xls, or .xlsx file, and then re-import. Review additional file requirements for importing into HubSpot.
Invalid number size
What the error means
The import file contains a numerical value that is too small or besides big. The affected rows were imported, but the number property does not incorporate a value.
How to resolve the error
Ostend the format requirements of your specific property or the property type, update your file to match the correct format, then re-import. You lot can also manually update the property value in the affected records.
Invalid object ID
What the error ways
During the import, the checkbox to update existing records using [object] IDs was selected. However, the [object] ID listed in the file did non match an existing ID in HubSpot. The records were not imported.
How to resolve the error
Ensure that the [object] IDs are correct. You may demand to consign your existing records to get the correct object IDs. If you're not updating or associating existing objects in HubSpot, do non select the checkbox during the import process.
Invalid required property
What the error means
A required property in the import file contains an invalid value. The information in that row was not imported.
How to resolve the mistake
Confirm the format requirements of your specific property or the property blazon, update your file to match the right format, then re-import.
Invalid canvas count
What the mistake ways
The import file contains more than than ane canvas. Your data was not imported.
How to resolve the fault
Remove any additional sheets from your import file, then re-import. Review boosted file requirements for importing into HubSpot.
Invalid spreadsheet
What the mistake ways
The import file is non a valid spreadsheet file. Your information was not imported.
How to resolve the error
Catechumen your file to a .csv, .xls, or .xlsx file, then re-import. Review additional file requirements for importing into HubSpot.
Limit exceeded
What the error means
HubSpot is unable to create the tape due to a limit. Your file may exist also large or you lot may have reached an account limit, such as reaching your max number of lists . Your data was not imported.
How to resolve the error
Confirm that your file is smaller than 150 MB, and has less than 250,000 rows and 1,000 columns. If the file is larger, separate your data into multiple files, then re-import. If the file is the correct size, larn more than about your HubSpot subscription and its limitations.
Multiple companies with this domain
What the error means
The import file contains a Company domain name value that matches multiple companies in your HubSpot account. The import did not update the visitor record.
How to resolve the error
Search for the specific Company domain name value in your companies home to find the duplicate domains. Merge the visitor records or delete i of them, then re-import the file.
Multiple owners plant
What the error means
The import file contains an Possessor value that matches more than one user in the account. This usually occurs for names (e.g., in that location are two John Doe users in your HubSpot account, and the import file contained the proper name "John Doe"). The afflicted records were imported, but the Owner property does not contain a value.
How to resolve the mistake
Replace the proper name of the owner with their email accost in your import file, then re-import the file. You can likewise manually update the Owner holding value in the afflicted records.
No object ID from association identifier
What the error ways
During the import, the checkbox to update existing records using [object] IDs was selected. Nonetheless, the required object IDs were not included in the files. The data was imported, but the resulting records are not associated in HubSpot.
How to resolve the fault
Update your import file to include the object IDs, then re-import the file. Y'all may demand to export your existing records to go the correct object IDs. Acquire how to set up your files properly to import and acquaintance multiple objects.
Outside valid term range
What the mistake means
The import file contains a value for a fourth dimension period that is outside of the accepted term range. The affected records were imported, but the term holding does not incorporate a value.
How to resolve the error
Update the term values in your file to be within the accustomed time range (a whole number greater than or equal to 1 month), then re-import the file. You can also manually update the property value in the affected records.
Exterior valid time range
What the mistake means
The import file contains a value for a time flow that is outside of the accepted time range. The afflicted records were imported, but the fourth dimension range property does not comprise a value.
How to resolve the error
Update the time range values in your file to be inside the accepted time range (less than 1000 years), then re-import the file. You can also manually update the property value in the affected records.
Property definition non found
What the error means
The import file contains a column header that does not match a HubSpot propert y. The data in that column was not imported.
How to resolve the error
During the import, match your columns correctly by selecting an existing property or past creating a new property on the Map columns in your file to [object] properties folio. You can also cull to skip importing unmatched columns.
Property value non found
What the mistake means
The import file is missing a value for a required property. The data in that row was not imported.
How to resolve the error
Update your import file to include a value for the required holding, then re-import the file.
Unknown bad request
What the mistake means
The import file contains an invalid record ID that does non match any existing record in your HubSpot account. The import did non update the record, as the data does non lucifer any existing record.
How to resolve the fault
Verify you have the correct [object] ID. If you find an incorrect ID, update your import file with the correct [object] ID, and then re-import the file.
Unknown fault
What the mistake ways
HubSpot is unable to process the file due to an unknown error. Your data was no t imported.
How to resolve the error
Confirm that your file meets all requirements. Endeavor to re-import after clearing your browser enshroud or using another browser. If y'all are still seeing an error, postal service on the Community (all users) or contact the support team (Starter, Professional, and Enterprise business relationship only).
Salesforce import errors
- Navigate to your records:
- Contacts: In your HubSpot account, navigate to Contacts > Contacts.
- Companies: In your HubSpot business relationship, navigate to Contacts > Companies.
- Deals: In your HubSpot account, navigate to Sales > Deals.
- Tickets: In your HubSpot account, navigate to Service > Tickets.
- Custom objects: In your HubSpot account, navigate toContacts > Contacts, so click the dropdown carte in the top left and select the name of the custom object.
- Products: In your HubSpot account, click the settings icon settings in the main navigation bar. In the left sidebar menu, navigate to Objects > Products & Quotes.
- In the upper correct, click Import. If you're on the products index folio, click the Actions dropdown menu, and so select Import.
- Hover over the Salesforce import that has errors, then clickView import errors.
- In theImport Errors table, hover over an error and clickView details to run across more than information.
- The right panel will bear witness a clarification of the mistake, forth with resolution information. Yous'll likewise see a list of records affected past the mistake. Click a record link to access the tape and make changes every bit needed.
Contacts Deals Companies Tickets Products & Quotes CRM Setup
Source: https://knowledge.hubspot.com/crm-setup/troubleshoot-import-errors
0 Response to "Sorry You Cant Import More Than 250000 Records at a Time Please Try Again With a Smaller Import"
Post a Comment