Rate Upload Type

@foreach($uploadtypes as $key => $value)

{{ Form::radio('RateUploadType', $key, ($key == $RateUploadType ? true : false) , array("class"=>"RateUploadType")) }} {{ $value }}

@endforeach

Vendor

{{ Form::select('Vendor', $Vendors, $VendorID , array("class"=>"select2","id"=>RateUpload::vendor)) }}

Ratetable

{{ Form::select('Ratetable', $Ratetables, $RatetableID , array("class"=>"select2","id"=>RateUpload::ratetable)) }}

Customer

{{ Form::select('Customer', $Customers, $CustomerID , array("class"=>"select2","id"=>RateUpload::customer)) }}

Trunk

{{ Form::select('Trunk', [], "" , array("class"=>"select2 small","id"=>"Trunk")) }} {{ Form::hidden('isTrunks', "0" , array("class"=>"form-control","id"=>"isTrunks","disabled"=>"disabled")) }}

Upload Template

{{ Form::select('uploadtemplate', [], "" , array("class"=>"select2","id"=>"uploadtemplate")) }}

Upload (.xls, .xlsx, .csv)

Import Rates From Sheet

{{ Form::select('importratesheet', [], "" , array("class"=>"select2","id"=>"importrate")) }}

Import Dial Codes From Sheet

{{ Form::select('importdialcodessheet', [], "" , array("class"=>"select2","id"=>"importdialcodes")) }}

Settings

Replace all of the existing rates with the rates from the file

Rates with 'effective from' date in the past should be uploaded as effective immediately

Add new codes from the file to code decks

Review Rates

Complete File
Partial File

Skips rows from Start (Rate)

Skips rows from Bottom (Rate)

Note

Allowed Extension .xls, .xlsx, .csv

Replace all of the existing rates with the rates from the file - The default option is to add new rates. If there is at least one parameter that differentiates a new rate from the existent one then the new rate will override it. If a rate for a certain prefix exists in the tariff but is not present in the file you received from the carrier, it will remain unchanged. The replace mode uploads all the new rates from the file and marks all the existent rates as discontinued.

Rates with 'effective from' date in the past should be uploaded as 'effective immediately' - Sometimes you might receive a file with rates later than expected, when the moment at which the rates were supposed to become effective has already passed. By default this check box is disabled and a rate that has an 'effective from' date that has passed will be rejected and not included in the tariff. Altematively, you may choose to insert these rates into the tariff and make them effective from the current moment; to do so enable this check box.

Code	Description	Rate	Effective Date	End Date	Action	Connection Fee(Opt.)	Interval1(Opt.)	IntervalN(Opt.)	Forbidden(Opt.)	Preference(Opt.)
9379	Afghanistan Cellular-Others	0.001	11-12-2014 12:00:00 AM	15-12-2014 12:00:00 AM	I ?	0.05	1	1	0	5
9377	Afghanistan Cellular-Areeba	0.002	11-12-2014 12:00:00 AM	15-12-2014 12:00:00 AM	U ?	0.05	1	1	1	2
9378	Afghanistan Cellular	0.003	11-12-2014 12:00:00 AM	15-12-2014 12:00:00 AM	D ?	0.05	1	1	1	1

Upload Rates

Vendor Rate File Format

Review Rates

Change Selected

Change Selected