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>
|
