summaryrefslogtreecommitdiff
path: root/httemplate/misc/rate-import.html
blob: 538418d13eb1f9b7f0fdde7a8e351397df77c519 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
<% include("/elements/header.html",'Import Rate Plan') %>

<& /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?
     'onsubmit'  => "document.RateImportForm.submitButton.disabled=true;",
&>

<% &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      = "submitButton"
             NAME    = "submitButton"
             VALUE   = "Import rate plan"
      >
    </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>