X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fmisc%2Fcust_pkg-import.html;h=6fdaea157e886d3c81780df938651a2582d83adc;hb=361f46c265aa76ce4fc9b00393e970d4c8b762bd;hp=e97e283100d7107c2f8e29ff05a86168c9996f15;hpb=df844e1ff7b7b93657d7ca2978426e146a75192c;p=freeside.git diff --git a/httemplate/misc/cust_pkg-import.html b/httemplate/misc/cust_pkg-import.html index e97e28310..6fdaea157 100644 --- a/httemplate/misc/cust_pkg-import.html +++ b/httemplate/misc/cust_pkg-import.html @@ -29,16 +29,28 @@ Import a file containing customer packages. @@ -72,27 +84,54 @@ Uploaded files can be CSV (comma-separated value) files or Excel spreadsheets. Default with agent_custid format has the following field order: agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire

+Default with existing location format has the following field order: custnum<%$req%>, locationnum, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire +

+ All dates format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, order_date, start_date, setup, bill, last_bill, susp, adjourn, resume, cancel, expire, contract_end, dundate

+All dates with agent_custid format has the following field order: agent_custid<%$req%>, pkgpart<%$req%>, discountnum, order_date, start_date, setup, bill, last_bill, susp, adjourn, resume, cancel, expire, contract_end, dundate +

+ +All dates with existing location format has the following field order: custnum<%$req%>, locationnum, pkgpart<%$req%>, discountnum, order_date, start_date, setup, bill, last_bill, susp, adjourn, resume, cancel, expire, contract_end, dundate +

+ Account service format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, username, _password, domsvc

Account service with agent_custid format has the following field order: agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, username, _password, domsvc

-Phone sevice format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, countrycode, phonenum, sip_password, pin +Account service with existing location format has the following field order: custnum<%$req%>, locationnum, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, username, _password, domsvc +

+ +Phone service format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, countrycode, phonenum, sip_password, pin

Phone service with agent_custid format has the following field order: agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, countrycode, phonenum, sip_password, pin

-External sevice format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, id, title +Phone service with existing location format has the following field order: custnum<%$req%>, locationnum, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, countrycode, phonenum, sip_password, pin +

+ +Bulk phone service format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, countrycode, start_phonenum-end_phonenum, sip_password, pin +

+ +Bulk phone service with agent_custid format has the following field order: agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, countrycode, start_phonenum-end_phonenum, sip_password, pin +

+ +Bulk phone service with existing location format has the following field order: custnum<%$req%>, locationnum, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, countrycode, start_phonenum-end_phonenum, sip_password, pin +

+ +External service format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, id, title

External service with agent_custid format has the following field order: agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, id, title

+External service with existing location format has the following field order: custnum<%$req%>, locationnum, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, id, title +

+ Location format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, @@ -114,7 +153,31 @@ address1<%$req%>, address2, city<%$req%>, state<%$req%>, zip<%$req%>, country<%$

-<%$req%> Required fields +Location, quantity and price customizations with phone service format has the following field order: custnum<%$req%>, +pkgpart<%$req%>, discountnum, +start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, +quantity, setup_fee, recur_fee, +address1<%$req%>, address2, city<%$req%>, state<%$req%>, zip<%$req%>, country<%$req%>, countrycode, phonenum, sip_password, pin + +

+ +Location, quantity and price customizations with phone service and agent_custid format has the following field order: agent_custid<%$req%>, +pkgpart<%$req%>, discountnum, +start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, +quantity, setup_fee, recur_fee, +address1<%$req%>, address2, city<%$req%>, state<%$req%>, zip<%$req%>, country<%$req%>, countrycode, phonenum, sip_password, pin + +

+ +Location, quantity and price customizations with phone service and agent_custid and agent_pkgid format has the following field order: agent_custid<%$req%>, agent_pkgid, +pkgpart<%$req%>, discountnum, +start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, +quantity, setup_fee, recur_fee, +address1<%$req%>, address2, city<%$req%>, state<%$req%>, zip<%$req%>, country<%$req%>, countrycode, phonenum, sip_password, pin + +

+ +<%$req%> Required fields (for address fields, required if an address is specified)

Field information: @@ -157,6 +220,8 @@ Field information:
  • title: External service identifier, text +
  • locationnum: Existing location (cust_location.locationnum) +
  • address1: Service address, number and street, text
  • address2: Service address, suite/unit/building identifier, text