summaryrefslogtreecommitdiff
path: root/httemplate/misc
diff options
context:
space:
mode:
authorivan <ivan>2009-05-05 10:40:15 +0000
committerivan <ivan>2009-05-05 10:40:15 +0000
commit791b34f7cb476e7c645d8eb7019dde9fdf5cf663 (patch)
tree86f450997d706e6a3453162828a46875427d16fd /httemplate/misc
parentabffd58d0109d62dad8c34f09353a6b3bddd2c03 (diff)
finish the import portion of excel rate edit, RT#5108
Diffstat (limited to 'httemplate/misc')
-rw-r--r--httemplate/misc/process/rate_edit_excel.html10
-rw-r--r--httemplate/misc/rate_edit_excel.html14
2 files changed, 22 insertions, 2 deletions
diff --git a/httemplate/misc/process/rate_edit_excel.html b/httemplate/misc/process/rate_edit_excel.html
new file mode 100644
index 000000000..acd5f4995
--- /dev/null
+++ b/httemplate/misc/process/rate_edit_excel.html
@@ -0,0 +1,10 @@
+<% $server->process %>
+<%init>
+
+die "access denied"
+ unless $FS::CurrentUser::CurrentUser->access_right('Configuration');
+
+my $server = new FS::UI::Web::JSRPC 'FS::rate_detail::process_edit_import', $cgi;
+
+</%init>
+
diff --git a/httemplate/misc/rate_edit_excel.html b/httemplate/misc/rate_edit_excel.html
index 7d3255301..e73133c05 100644
--- a/httemplate/misc/rate_edit_excel.html
+++ b/httemplate/misc/rate_edit_excel.html
@@ -4,7 +4,7 @@
'name' => 'RateImportForm',
'action' => 'process/rate_edit_excel.html',
'num_files' => 1,
- 'fields' => [ 'format' ], #?
+ 'fields' => [ 'format' ],
'message' => 'Rate edit successful',
'url' => $p."browse/rate_region.html",
)
@@ -23,12 +23,22 @@
<TH ALIGN="left" COLSPAN=2>2. Edit rates with Excel (or other .XLS-compatible application)</TH>
</TR>
+ <TR>
+ <TD ALIGN="left" COLSPAN=2>
+ &nbsp;&nbsp;&nbsp;&nbsp;-&nbsp;To add rates, add four columns like an existing rate, with headers starting with "NEW: Rate Name" or "Rate Name".<BR>
+ &nbsp;&nbsp;&nbsp;&nbsp;-&nbsp;<FONT SIZE="-2"><I>For rate addition, protection can be turned off in Excel via the Tools-&gt;Protection-&gt;Unprotect Sheet menu command. Note that only new rates can be added; modified grayed out cells will not be imported.</I></FONT>
+ </TD>
+ </TR>
+
<% include( '/elements/file-upload.html',
'field' => 'file',
- 'label' => '3. Upload edited rate file: '. ( '&nbsp'x4 ), #yuck
+ 'label' => '3. Upload edited rate file: ',
+ 'label_align' => 'left',
)
%>
+ <INPUT TYPE="hidden" NAME="format" VALUE="default">
+
<TR>
<TD COLSPAN=2 ALIGN="center" STYLE="padding-top:6px">
<INPUT TYPE = "submit"