The import can be performed via properly formatted and saved CSV file, 75Bit CRM supports importing data for the following resources:
Before import, make sure that the CSV file is saved in UTF-8 to avoid any encoding issues.
The import feature for all the supported resources is located when viewing the index page, for example, table contacts.
- Navigate to the resource list view.
- Click the elipsis button located on the top right side.
- Click Import.
- Download a sample file to get familiar with how your rows must be constructed.
- After you are ready with your file, upload the file to start the import process.
When importing huge amount of data and you have created Zapier zaps with create triggers it's highly recommended to temporary disable the zaps from your Zapier account to prevent thousands of zaps triggering because of the created records, this will help you to not waste your remaining tasks in your Zapier account, it's recommended to enable the zaps after 30 minutes you performed the import.
It's recommended that the CSV file headings (first row) names be the same as the sample file you downloaded, so 75Bit CRM can map them to the appropriate fields during upload.
Any workflow triggers, notifications like assigned emails or dashboard notifications are disabled during import.
75Bit CRM import feature allows you to map the columns from your actual CSV file to the fields in your 75Bit CRM installation.
If you checked the notes above, we recommended the heading rows to be the same like in the sample file or like your actual field name so 75Bit CRM can easily map them into the appropriate fields, however, after the CSV file is uploaded, you can still choose to skip column to be imported by settings the map field to empty or map your column into another field.
On the left side, you can see the columns from the CSV file, as well some rows are used as sample data so you can more easily determine whether it's the appropriate column, however, on the right side, the mapped columns are shown which you can use to select appropriate field for the column on the left side.
When required, the user/owner fields must be always provided with ID or full name of the user.
When importing contacts, if a contact already exists by email or phone number, the contact will be updated with the new values from the import file.
When importing products, if a product already exists by name or SKU number, the product will be updated with the new values from the import file.
When importing companies, if company address (street, city, state, zip/postal code, country) or email already exists, the company will be updated with the new values from the import file.
If a duplicate record is found and this duplicate record is in the trash, the record will be restored from the tash.
Records are not imported
Try using different software to generate the CSV files. You can try using Google Drive and export it as a CSV file to see if this will solve the problem.
All rows imported in 1 field
The issue can happen if your .csv file is not properly formatted and you are using poorly designed .csv software to edit the file.
In most cases, this issue will be solved when you just open the file in a proper editor and re-save it with a comma separator.
Additionally, it's recommended to download the sample file from 75Bit CRM and open this file to be like guidance for your .csv file construction.