From 5302c3ef626bbde7afdb7606176210f528992661 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 9 Aug 2010 19:20:13 +0000 Subject: [PATCH] package web import from CSV/XLS, RT#9529 --- FS/FS/cust_pkg/Import.pm | 2 +- httemplate/misc/cust_pkg-import.html | 22 ++++++++++++++++++++-- 2 files changed, 21 insertions(+), 3 deletions(-) diff --git a/FS/FS/cust_pkg/Import.pm b/FS/FS/cust_pkg/Import.pm index 7a4b9d50c..43470a4c0 100644 --- a/FS/FS/cust_pkg/Import.pm +++ b/FS/FS/cust_pkg/Import.pm @@ -102,7 +102,7 @@ sub process_batch_import { my %formatfields = ( 'default' => [], - 'svc_acct' => [qw( username _password )], + 'svc_acct' => [qw( username _password domsvc )], 'svc_phone' => [qw( countrycode phonenum sip_password pin )], 'svc_external' => [qw( id title )], ); diff --git a/httemplate/misc/cust_pkg-import.html b/httemplate/misc/cust_pkg-import.html index 404e96588..b29884d66 100644 --- a/httemplate/misc/cust_pkg-import.html +++ b/httemplate/misc/cust_pkg-import.html @@ -70,10 +70,10 @@ 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

-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 +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 +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 @@ -103,10 +103,28 @@ Field information:
  • discountnum: Optional discount. Configuration -> Packages -> Discounts +
  • start_date: Indicates a future start date; do not fill in for active packages + +
  • setup: Indicates setup fee has been charged and package setup on this date + +
  • bill: Next bill date + +
  • last_bill: Last bill date + +
  • susp: Indicates the package is suspended (on the given date). + +
  • adjourn: Indicates a future suspension on this date. + +
  • cancel: Indicates the package is cancelled (on the given date). + +
  • expire: Indicates a future cancellation on this date. + +
  • domsvc: Domain svcnum +
  • id: External service id, integer
  • title: External service identifier, text -- 2.11.0