Contents / System life hacks
Import/export of APRO CRM data
You can import/export APRO CRM data in Excel.
Import is only available to the users allowed to add/edit the CRM data (according to their access permissions). The user adding an object is automatically assigned to supervise it. Selecting the users to add/edit the CRM data is the prerogative of APRO CRM administrators.
Import/export of contacts
Import/export of contacts is performed from page "Contacts" (right sidebar):
You can import an Excel file of any columns complexity and customize the correspondence of its columns to the fields in CRM contact profiles.
Click "Import" to open the import parameters:
1 — select the file you wish to import;
2 — select contact class: private individual / legal entity;
3 — select contact type;
4 — associate the contacts you are importing with a certain user/group;
5 — define the rule to settle the cases of the imported and the existing fields overlap;
6 — in case of fields overlap, contacts missing the content in obligatory fields will not be imported from the Excel file.
Go to next page to customize the correspondence of the columns in Excel file to the fields in contact profile:
Select the fields you want to export from contact profile to Excel and click "Export". This will send all the contacts from the current page to an Excel file, minding the fields you selected.
Export of objects has the same interface.
You can also export deals and activities assorted by their types. Make sure you select one type of deal/activity on the right sidebar of the deal/activity page by removing all the unnecessary types — and the button "Export" will appear in the lower right corner of the page:
By default, exporting data from the CRM is only permitted to CRM administrators. To grant other users access to export, go to Main menu — Settings — CRM — Objects / Contacts / Activities / Deals — Access settings (upper tab):
Attention! Users with access permissions for export can only operate the data they have viewing access to (see access permissions for CRM groups).
To import objects photos from an Excel file to the CRM, create the relevant column in the Excel file and fill out its cells with the URLs of the photos. You can store the photos on your website, so that they would be available for downloading without authorization. APRO CRM will download the photos from these URLs, when importing the Excel file.
Back to Contents