unfinished rate import
authorivan <ivan>
Tue, 25 May 2010 12:41:22 +0000 (12:41 +0000)
committerivan <ivan>
Tue, 25 May 2010 12:41:22 +0000 (12:41 +0000)
httemplate/misc/process/rate-import.html [new file with mode: 0644]
httemplate/misc/rate-import.html [new file with mode: 0644]

diff --git a/httemplate/misc/process/rate-import.html b/httemplate/misc/process/rate-import.html
new file mode 100644 (file)
index 0000000..2c64164
--- /dev/null
@@ -0,0 +1,9 @@
+<% $server->process %>
+<%init>
+
+die "access denied"
+  unless $FS::CurrentUser::CurrentUser->access_right('Import');
+
+my $server = new FS::UI::Web::JSRPC 'FS::rate::process_batch_import', $cgi;
+
+</%init>
diff --git a/httemplate/misc/rate-import.html b/httemplate/misc/rate-import.html
new file mode 100644 (file)
index 0000000..ae8ee69
--- /dev/null
@@ -0,0 +1,76 @@
+<% include("/elements/header.html",'Import Rate Plan') %>
+
+<% include( '/elements/form-file_upload.html',
+              'name'      => 'RateImportForm',
+              'action '   => 'process/rate-import.html',
+              'num_files' => 1,
+              'fields'    => [ 'ratename' ],
+              'message'   => 'Rate plan import successful',
+#              'url'       => $p."browse/rate_detail.cgi?ratenum=$ratenum", #XXX how?
+          )
+%>
+
+<% &ntable("#cccccc", 2) %>
+
+  <TR>
+    <TD>Rate plan</TD>
+    <TD>
+      <INPUT TYPE="text" NAME="ratename" SIZE=32 VALUE="">
+    </TD>
+  </TR>
+
+  <% include( '/elements/file-upload.html',
+                'field' => 'file',
+                'label' => 'Filename',
+            )
+  %>
+
+  <TR>
+    <TD COLSPAN=2 ALIGN="center" STYLE="padding-top:6px">
+      <INPUT TYPE    = "submit"
+             ID      = "submit"
+             VALUE   = "Import rate plan"
+             onClick = "document.RateImportForm.submit.disabled=true;"
+      >
+    </TD>
+  </TR>
+
+</TABLE>
+
+</FORM>
+
+<BR>
+
+<!--Upload file can be a text file or Excel spreadsheet.  If an Excel spreadsheet,
+ should have an .XLS extension.
+<BR><BR>
+-->
+File format is CSV (comma-separated value), with the following field order:
+<ul>
+  <li>Destination name
+  <li>Country code / Prefix.  See below for formatting rules.
+  <li>Rate (per minute)
+<!--
+  <li>(Optional) Included minutes
+  <li>(Optional) Granularity
+-->
+</ul>
+
+Formatting rules for second field:
+<ul>
+  <li>Simple entries contain just a countrycode or a countrycode and single prefix for example, "61" or "52 33".  Whitespace, plus and dash are ignored.
+  <li>Additional prefixes may be appended after a comma (appropriately quoted), but country code should only be listed once at the beginning.  For example, "61 38,39".
+  <li>
+</ul>
+
+Have caution when importing prefix data that is mismatched to your current
+prefixes.
+
+<% include('/elements/footer.html') %>
+
+<%init>
+
+die "access denied"
+  unless $FS::CurrentUser::CurrentUser->access_right('Import');
+
+</%init>