[Spce-user] Error in Upload Fees as CSV in 3.8.3

[Daniel Grotti]

Hi Marco,
the one in attach should be the right format.
Please check it out.


--
Daniel Grotti
VoIP Engineer


Sipwise GmbH
Europaring F15 | 2345 Brunn am Gebirge, Austria | www.sipwise.com

On 09/23/2015 10:12 AM, Marco Teixeira wrote:
> Hello list,
> 
> Anyone managed to import Fees as CSV in LTS 3.8.3 ?
> Always getting this in panel.log:
> 
> ngcp-panel: ERROR: IP=X.X.X.X CALLED=Controller::Billing::fees_upload
> TX=14068C5A8908C020 USER=admin DATA={ 'save' => 'Upload', 'submitid' =>
> '', 'upload_fees' => 'CSV.txt'} MSG="Failed to upload Billing Fees
> (DBIx::Class::Schema::txn_do(): Some lines could not be parsed. Did not
> reach eof. Last successful: 0. at
> /usr/share/perl5/NGCP/Panel/Controller/Billing.pm line 467. at
> /usr/share/perl5/Catalyst/Model/DBIC/Schema.pm line 501#012)" LOG=""
> 
> Did not touch fees field order in config.yml:
>   fees_csv:
>     element_order:
>       - source
>       - destination
>       - direction
>       - zone
>       - zone_detail
>       - onpeak_init_rate
>       - onpeak_init_interval
>       - onpeak_follow_rate
>       - onpeak_follow_interval
>       - offpeak_init_rate
>       - offpeak_init_interval
>       - offpeak_follow_rate
>       - offpeak_follow_interval
>       - use_free_time
> 
> My CSV.txt is like this (edited in notepad++ in UTF8 in UNIX format):
> ".","\.local$",out,"local","local services",0,1,0,1,0,1,0,1,0
> ".","^3512",out,"PT","Portugal Fixed",0.1,1,0.1,1,0.1,1,0.1,1,0
> 
> By looking at the code, it line that errors out points to a cycle for
> working billing zones... (i already have them created)
> 
> Any clues ?
> 
> ---
> Best regards
> Marco
> ---
> 
> 
> 
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: example_fees.csv
Type: text/csv
Size: 166 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20150923/679f8f47/attachment-0001.csv>