Bulk Customer Updates Interface
The bulk customer update interface is used to update the details of a large number of customers. It will update the billing cycle, treatment type, payment method or credit control status of all account numbers provided in the interface.
Save a csv file in the correct format in your "Interfaces\Bulk Customer Update Import" folder.
- If the file is successfully processed it is placed in "Interfaces\Bulk Customer Update Import\Archive".
- If it is not able to be processed it is placed in the "Interfaces\Bulk Customer Update Import\Error" folder with an error file explaining why.
This interface can be manually run at any time from the Scheduled Tasks screen.
The file must be a CSV file with the following columns :
- Account_number (mandatory)
The account number must be a valid account number in Utilmate. If an account cannot be found, the file will error with an error message explaining the account cannot be found.
Must be a valid bill cycle code in Utilmate.
Must be a valid treatment type code in Utilmate.
Must be a valid payment method code in Utilmate
Must be a valid credit control status in Utilmate
Note: maximum character limit is 255. If longer, your file will error.