Uploaded files can be CSV (comma-separated value) files or Excel spreadsheets. The file should have a .CSV or .XLS extension.
Default Format has the following field order:
custnum<%$req%>, last<%$req%>, first<%$req%>, title<%$req%>, comment, selfservice_access, emailaddress, workphone, mobilephone, homephone
Field information:
You must include a customer number and either a last name, first name or title.
custnum: This is the customer number of the customer the contact is attached to.
last: Last name for contact.
first: First name for contact.
title: Optional title for contact.
comment: Optional comment for contact.
selfservice_access: Empty for no self service access or Y if granting self service access.
emailaddress: Email address for contact.
workphone: Work phone number for contact. Format xxxxxxxxxx
mobilephone: Mobile phone number for contact. Format xxxxxxxxxx
homephone: Home phone number for contact. Format xxxxxxxxxx
<% include('/elements/footer.html') %>
<%once>
my $req = qq!*!;
%once>
<%init>
die "access denied"
unless $FS::CurrentUser::CurrentUser->access_right('Import');
my $custbatch = time2str('webimport-%Y/%m/%d-%T'. "-$$-". rand() * 2**32, time);
%init>