<% include('/elements/header.html', 'Edit rates with Excel' ) %> % if ( $have_conn ) { WARNING: This functionality does not yet preserve connection charges.

% } <& /elements/form-file_upload.html, 'name' => 'RateImportForm', 'action' => 'process/rate_edit_excel.html', 'num_files' => 1, 'fields' => [ 'format' ], 'message' => 'Rate edit successful', 'url' => $p."browse/rate_region.html", 'onsubmit' => "document.RateImportForm.submitButton.disabled=true;" &> <% &ntable("#cccccc", 2) %> 1. Download current rates: Download rate spreadsheet 2. Edit rates with Excel (or other .XLS-compatible application)     - To add rates, add four columns like an existing rate, with headers starting with "NEW: Rate Name" or "Rate Name".
    - For rate addition, protection can be turned off in Excel via the Tools->Protection->Unprotect Sheet menu command. Note that only new rates can be added; modified grayed out cells will not be imported. <% include( '/elements/file-upload.html', 'field' => 'file', 'label' => '3. Upload edited rate file: ', 'label_align' => 'left', ) %> <% include('/elements/footer.html') %> <%init> die "access denied" unless $FS::CurrentUser::CurrentUser->access_right('Configuration'); my $sth = dbh->prepare('SELECT COUNT(*) FROM rate_detail WHERE conn_charge > 0 OR conn_sec > 0 LIMIT 1') or die dbh->errstr; $sth->execute or die $sth->errstr; my $have_conn = $sth->fetchrow_arrayref->[0];