10-12-2017 10:49 AM
If i export all our clients using the Clients,Export button, it creates a CSV file that can be downloaded from System,Tools, Downloads.
If i try to import this file back into UCRM from System,Tools,CSV import,Clients Import. It does not work. A fiew of the biggest problems I see with the exported file are UCRM puts first and last name in one column. Puts all emails in the same column, All phone numbers in the same column. And the registration date is not in the format that the import wants.
Another huge problem for us is if the client already exsists, then it is impossible to import new data into an exsisting account. For example the data entry person for us did not include customer emails when they entered the account into UCRM. I was hoping to export the exsisting customers to CSV, add their emails, and then import the file back into UCRM. Unfortunately that does not appear possible. It errors out saying client ID already exsists.
10-13-2017 12:28 AM
Hello @superbree, the CSV import tool is intended for importing new customers only, not updating them. If you want to update existing customers with new data, you can use UCRM API. See the API docs here http://docs.ucrm.apiary.io/# and an example script here https://community.ubnt.com/t5/UCRM-Complete-WISP-Management/UCRM-API-example-script-to-reset-invoice...
We'll check the UCRM export cannot be imported back, thank you for reporting this.