X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fmisc%2Fcust_main-import.cgi;h=028876c3adf145476669c3f1292ab835ac59e4c2;hb=005b2dcf775df328afb013dc6acef5cbb564aa38;hp=9c1f98479a7675887f14966ff86469a610108cd4;hpb=04a69f9d197efee6fa396bd35d04ae553e669978;p=freeside.git diff --git a/httemplate/misc/cust_main-import.cgi b/httemplate/misc/cust_main-import.cgi index 9c1f98479..028876c3a 100644 --- a/httemplate/misc/cust_main-import.cgi +++ b/httemplate/misc/cust_main-import.cgi @@ -30,7 +30,9 @@ Import a file containing customer records. @@ -89,9 +91,15 @@ Uploaded files can be CSV (comma-separated value) files or Excel spreadsheets. Extended format has 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, paycvv, paydate, invoicing_list, pkgpart, username, _password

+Extended plus options format has 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, paycvv, paydate, invoicing_list, pkgpart, username, _password, options +

+ Extended plus company format has 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, paycvv, paydate, invoicing_list, pkgpart, username, _password

+Extended plus company and options format has 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, paycvv, paydate, invoicing_list, pkgpart, username, _password, options +

+ External service format has 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, paycvv, paydate, invoicing_list, pkgpart, next_bill_date, id, title

@@ -111,7 +119,7 @@ Field information: 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. +
  • payinfo: Credit card number, or leave this, paycvv and paydate blank for email/paper invoicing. You may optionally prepend an 'A' or 'D' to the credit card number for automatic or on demand of customer billing respectively
  • paycvv: CVV2 number (three digits on the back of the credit card) @@ -119,7 +127,7 @@ advertising source table.
  • invoicing_list: Email address for invoices, or POST for postal invoices. -
  • pkgpart: Package definition. Configuration -> Provisioning, services and packages -> View/Edit package definitions +
  • pkgpart: Package definition. Configuration -> Packages -> Package definitions
  • username and _password are required if pkgpart is specified. (Extended and Extended plus company formats) @@ -127,6 +135,13 @@ advertising source table.
  • title: External service identifier, text +
  • options: text containing one or more of + + +