From: ivan <ivan>
Date: Mon, 9 Aug 2010 19:20:13 +0000 (+0000)
Subject: package web import from CSV/XLS, RT#9529
X-Git-Tag: TORRUS_1_0_9~418
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=5302c3ef626bbde7afdb7606176210f528992661;hp=efa7c9c0233f2c3d1e39d62f17cac30b36f593c4

package web import from CSV/XLS, RT#9529
---

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.
 <b>Default with agent_custid</b> format has the following field order: <i>agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire</i>
 <BR><BR>
 
-<b>Account service</b> format has the following field order: <i>custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, username, _password</i>
+<b>Account service</b> format has the following field order: <i>custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, username, _password, domsvc</i>
 <BR><BR>
 
-<b>Account service with agent_custid</b> format has the following field order: <i>agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, username, _password</i>
+<b>Account service with agent_custid</b> format has the following field order: <i>agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, username, _password, domsvc</i>
 <BR><BR>
 
 <b>Phone sevice</b> format has the following field order: <i>custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, countrycode, phonenum, sip_password, pin</i>
@@ -103,10 +103,28 @@ Field information:
 
   <li><i>discountnum</i>: Optional discount.  Configuration -&gt; Packages -&gt; Discounts
 
+  <li><i>start_date</i>: Indicates a future start date; do not fill in for active packages
+
+  <li><i>setup</i>: Indicates setup fee has been charged and package setup on this date
+
+  <li><i>bill</i>: Next bill date
+
+  <li><i>last_bill</i>: Last bill date
+
+  <li><i>susp</i>: Indicates the package is suspended (on the given date).
+
+  <li><i>adjourn</i>: Indicates a future suspension on this date.
+
+  <li><i>cancel</i>: Indicates the package is cancelled (on the given date).
+
+  <li><i>expire</i>: Indicates a future cancellation on this date.
+
 <!--
   <li><i>username</i> and <i>_password</i> are required if <i>pkgpart</i> is specified. (Extended and Extended plus company formats)
 -->
 
+  <li><i>domsvc</i>: Domain svcnum
+
   <li><i>id</i>: External service id, integer
 
   <li><i>title</i>: External service identifier, text