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

[Marco Teixeira]

Hello Daniel,

I already had found your sample file somewhere in this list. I based my
file on it... The only thing i changed is the pattern. I'm using "^351".
Fromk ehat i can see of the error, it doesn't even parse the first line.
I also tried the file in UNIX and DOS format (because of LineBreaks)
Always same result...


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


---
Cumprimentos / Best regards
Marco

On Wed, Sep 23, 2015 at 10:15 AM, Daniel Grotti <dgrotti at sipwise.com> wrote:

> 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
> >
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20150923/5766011b/attachment-0001.html>