X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fmisc%2Fcust_main-import.cgi;h=84da38611c6bd02a35f3af089b86ce4b1c1e255d;hb=c648976f0b7975f2328ebd7ba8c711fad0ca4195;hp=b273a80aa8cbfbd966a79858297d87b10e328bff;hpb=9509e5bfb7f9331303153cac24d7bfecbe2ea9f1;p=freeside.git
diff --git a/httemplate/misc/cust_main-import.cgi b/httemplate/misc/cust_main-import.cgi
index b273a80aa..84da38611 100644
--- a/httemplate/misc/cust_main-import.cgi
+++ b/httemplate/misc/cust_main-import.cgi
@@ -1,28 +1,11 @@
<% include("/elements/header.html",'Batch Customer Import') %>
-
+
+
+
+
+Extended file format is CSV, with the following field order: agent_custid, refnum<%$req%>, last<%$req%>, first<%$req%>, address1<%$req%>, address2, city<%$req%>, state<%$req%>, zip<%$req%>, country, daytime, night, ship_last, ship_first, ship_address1, ship_address2, ship_city, ship_state, ship_zip, ship_country, payinfo<%$req%>, paycvv, paydate<%$req%>, invoicing_list, pkgpart, username, _password
+
+
+Extended plus company file format is CSV, with the following field order: agent_custid, refnum<%$req%>, last<%$req%>, first<%$req%>, company, address1<%$req%>, address2, city<%$req%>, state<%$req%>, zip<%$req%>, country, daytime, night, ship_last, ship_first, ship_company, ship_address1, ship_address2, ship_city, ship_state, ship_zip, ship_country, payinfo<%$req%>, paycvv, paydate<%$req%>, invoicing_list, pkgpart, username, _password
+
+
+<%$req%> Required fields
+
+
+Field information:
+
+
+
+ - agent_custid: This is the reseller's idea of the customer number or identifier. It may be left blank. If specified, it must be unique per-agent.
+
+
- refnum: Advertising source number - where a customer heard about your service. Configuration -> Miscellaneous -> View/Edit advertising sources. This field has special treatment upon import: If a string is passed instead
+of an integer, the string is searched for and if necessary auto-created in the
+advertising source table.
+
+
- payinfo: Credit card number, or leave this, paycvv and paydate blank for email/paper invoicing.
+
+
- paycvv: CVV2 number (three digits on the back of the credit card)
+
+
- paydate: Credit card expiration date, MM/YYYY or MM/YY (M/YY and M/YYYY are also accepted).
+
+
- invoicing_list: Email address for invoices, or POST for postal invoices.
+
+
- pkgpart: Package definition. Configuration -> Provisioning, services and packages -> View/Edit package definitions
+
+
- username and _password are required if pkgpart is specified.
+
+
+
+
<% include('/elements/footer.html') %>
<%once>
+
my $req = qq!*!;
+
%once>
+<%init>
+
+die "access denied"
+ unless $FS::CurrentUser::CurrentUser->access_right('Import');
+
+%init>