<% include('/elements/header.html', 'Edit tax rates with Excel' ) %> % # 'name' => 'RateImportForm', <& /elements/form-file_upload.html, 'name' => 'TaxEditForm', 'action' => 'process/tax_edit_excel.html', 'num_files' => 1, 'fields' => [ 'format' ], 'message' => 'Tax Rate edit successful', 'url' => $p."browse/cust_main_county.cgi", 'onsubmit' => "document.TaxEditForm.submitButton.disabled=true;" &> <% &ntable("#cccccc", 2) %> File format should be as follows:

Country as standard two letter code

State as standard two letter code

County name

City name

Tax name

Tax rate

* first row should be blank or contain headers
* Tax rate should be formated as a number not percentage.

Upload tax rates with Excel (or other .XLS-compatible application) <% include( '/elements/file-upload.html', 'field' => 'file', 'label' => '', '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];